WORKLOAD REPOSITORY report for

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
VIS	189753083	VIS	1	10.2.0.3.0	NO	oracle16.engr.sgi.com

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	1	14-Oct-07 17:13:19	5521	202.2
End Snap:	2	14-Oct-07 18:14:17	5523	245.2
Elapsed:		60.96 (mins)
DB Time:		1,148.40 (mins)

 

Report Summary

Cache Sizes

	Begin	End
Buffer Cache:	8,000M	8,000M	Std Block Size:	8K
Shared Pool Size:	3,008M	3,008M	Log Buffer:	30,736K

Load Profile

	Per Second	Per Transaction
Redo size:	8,771,198.34	25,345.28
Logical reads:	632,303.36	1,827.11
Block changes:	55,279.85	159.74
Physical reads:	400.26	1.16
Physical writes:	841.77	2.43
User calls:	12,531.64	36.21
Parses:	2,774.27	8.02
Hard parses:	2.69	0.01
Sorts:	3,077.10	8.89
Logons:	3.37	0.01
Executes:	29,268.95	84.58
Transactions:	346.07

% Blocks changed per Read:	8.74	Recursive Call %:	79.20
Rollback per transaction %:	21.56	Rows per Sort:	10.63

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	99.96	Redo NoWait %:	100.00
Buffer Hit %:	99.95	In-memory Sort %:	100.00
Library Hit %:	100.06	Soft Parse %:	99.90
Execute to Parse %:	90.52	Latch Hit %:	98.14
Parse CPU to Parse Elapsd %:	84.27	% Non-Parse CPU:	98.12

Shared Pool Statistics

	Begin	End
Memory Usage %:	79.25	98.05
% SQL with executions>1:	73.79	82.95
% Memory for SQL w/exec>1:	64.08	57.01

Top 5 Timed Events

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
CPU time		61,227		88.9
db file sequential read	913,724	2,736	3	4.0	User I/O
log file sync	514,377	1,188	2	1.7	Commit
log file parallel write	897,603	316	0	.5	System I/O
latch: cache buffers chains	373,107	235	1	.3	Concurrency

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

Back to Top

Wait Events Statistics

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

Back to Top

Time Model Statistics

• Total time in database user-calls (DB Time): 68904.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	61,635.03	89.45
DB CPU	61,226.62	88.86
inbound PL/SQL rpc elapsed time	12,210.39	17.72
PL/SQL execution elapsed time	9,695.60	14.07
Java execution elapsed time	3,013.42	4.37
parse time elapsed	1,451.19	2.11
hard parse elapsed time	674.92	0.98
repeated bind elapsed time	160.55	0.23
connection management call elapsed time	40.82	0.06
sequence load elapsed time	39.94	0.06
PL/SQL compilation elapsed time	9.89	0.01
hard parse (sharing criteria) elapsed time	8.81	0.01
failed parse elapsed time	4.15	0.01
hard parse (bind mismatch) elapsed time	1.39	0.00
DB time	68,904.11
background elapsed time	1,176.47
background cpu time	729.76

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	1,113,123	0.00	2,941	3	0.88
Commit	514,377	0.00	1,188	2	0.41
Concurrency	1,389,922	0.77	888	1	1.10
System I/O	1,193,641	0.00	430	0	0.94
Application	85,998	0.08	312	4	0.07
Network	52,985,827	0.00	301	0	41.86
Other	224,536	16.89	277	1	0.18
Configuration	85,981	0.00	214	2	0.07

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	913,724	0.00	2,736	3	0.72
log file sync	514,377	0.00	1,188	2	0.41
log file parallel write	897,603	0.00	316	0	0.71
latch: cache buffers chains	373,107	0.00	235	1	0.29
latch: In memory undo latch	60,285	0.00	204	3	0.05
enq: HW - contention	66,188	0.00	204	3	0.05
latch: undo global data	41,676	0.00	189	5	0.03
read by other session	176,465	0.00	175	1	0.14
enq: UL - contention	3,025	1.39	167	55	0.00
SQL*Net more data from client	2,666,614	0.00	140	0	2.11
cursor: pin S wait on X	11,316	95.03	116	10	0.01
db file parallel write	292,640	0.00	112	0	0.23
buffer busy waits	854,086	0.00	97	0	0.67
SQL*Net more data to client	2,105,298	0.00	93	0	1.66
enq: TX - row lock contention	1,255	2.07	90	72	0.00
latch: library cache	31,260	0.00	82	3	0.02
SQL*Net message to client	48,213,915	0.00	69	0	38.09
latch: library cache pin	15,009	0.00	50	3	0.01
enq: TX - index contention	30,128	0.00	44	1	0.02
SQL*Net break/reset to client	81,656	0.00	35	0	0.06
db file scattered read	10,619	0.00	25	2	0.01
library cache load lock	776	0.00	20	26	0.00
latch: row cache objects	9,725	0.00	18	2	0.01
latch: redo allocation	11,234	0.00	16	1	0.01
enq: KO - fast object checkpoint	26	3.85	15	570	0.00
latch free	2,896	0.00	12	4	0.00
library cache lock	332	0.00	10	32	0.00
LGWR wait for redo copy	38,718	0.49	10	0	0.03
latch: session allocation	8,055	0.00	10	1	0.01
latch: cache buffers lru chain	5,070	0.00	7	1	0.00
kksfbc child completion	156	78.21	6	39	0.00
enq: SQ - contention	18,702	0.00	6	0	0.01
enq: TX - contention	9,281	0.00	6	1	0.01
enq: RO - fast object reuse	32	0.00	6	177	0.00
cursor: pin S	55,857	0.00	5	0	0.04
local write wait	3,998	0.00	5	1	0.00
library cache pin	739	0.00	5	6	0.00
buffer deadlock	38,193	98.27	3	0	0.03
enq: FB - contention	5,158	0.00	3	1	0.00
enq: TX - allocate ITL entry	943	0.00	3	3	0.00
latch: library cache lock	1,052	0.00	3	2	0.00
enq: DV - contention	167	0.00	2	15	0.00
latch: cache buffer handles	3,317	0.00	2	1	0.00
wait list latch free	523	0.00	2	3	0.00
latch: object queue header operation	2,608	0.00	2	1	0.00
control file parallel write	1,773	0.00	1	1	0.00
latch: shared pool	935	0.00	1	2	0.00
os thread startup	10	0.00	1	107	0.00
log file switch completion	77	0.00	1	13	0.00
row cache lock	913	0.00	1	1	0.00
PX Deq Credit: send blkd	863	0.00	1	1	0.00
latch: enqueue hash chains	166	0.00	1	3	0.00
PX Deq: Signal ACK	51	29.41	1	10	0.00
control file sequential read	1,617	0.00	0	0	0.00
latch: redo writing	66	0.00	0	3	0.00
enq: US - contention	67	0.00	0	2	0.00
L1 validation	12	66.67	0	7	0.00
latch: checkpoint queue latch	59	0.00	0	1	0.00
enq: TQ - TM contention	121	0.00	0	1	0.00
direct path read	7,917	0.00	0	0	0.01
enq: TM - contention	4	0.00	0	16	0.00
enq: TQ - DDL contention	72	0.00	0	1	0.00
reliable message	56	0.00	0	1	0.00
cursor: mutex S	168	0.00	0	0	0.00
PX qref latch	83	72.29	0	1	0.00
db file parallel read	2	0.00	0	15	0.00
latch: messages	44	0.00	0	1	0.00
cursor: mutex X	81	0.00	0	0	0.00
latch: object queue header heap	18	0.00	0	1	0.00
enq: PS - contention	12	0.00	0	1	0.00
write complete waits	5	0.00	0	2	0.00
log file sequential read	4	0.00	0	1	0.00
direct path write	349	0.00	0	0	0.00
log file single write	4	0.00	0	0	0.00
latch: parallel query alloc buffer	3	0.00	0	0	0.00
direct path write temp	37	0.00	0	0	0.00
direct path read temp	12	0.00	0	0	0.00
SQL*Net message from client	48,213,849	0.00	11,379,224	236	38.09
pipe get	43,343	47.36	60,436	1394	0.03
Streams AQ: waiting for messages in the queue	7,278	100.00	35,555	4885	0.01
PL/SQL lock timer	322	99.69	3,595	11164	0.00
jobq slave wait	1,218	94.99	3,564	2926	0.00
Streams AQ: qmn slave idle wait	130	0.00	3,555	27349	0.00
Streams AQ: qmn coordinator idle wait	260	50.00	3,555	13674	0.00
Streams AQ: waiting for time management or cleanup tasks	271	5.54	3,529	13023	0.00
PX Idle Wait	1,274	94.19	2,390	1876	0.00
PX Deq: Execution Msg	1,111	0.72	37	33	0.00
PX Deq: Execute Reply	3,575	0.00	8	2	0.00
PX Deq: Parse Reply	60	0.00	3	58	0.00
PX Deq: Msg Fragment	995	0.00	0	0	0.00
PX Deq Credit: need buffer	1,182	0.00	0	0	0.00
PX Deq: Table Q Normal	476	0.00	0	0	0.00
PX Deq: Join ACK	61	0.00	0	1	0.00
class slave wait	1	0.00	0	2	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
log file parallel write	897,553	0.00	316	0	0.71
db file parallel write	292,640	0.00	112	0	0.23
events in waitclass Other	44,625	0.42	15	0	0.04
db file scattered read	959	0.00	5	5	0.00
db file sequential read	662	0.00	2	3	0.00
control file parallel write	1,773	0.00	1	1	0.00
os thread startup	2	0.00	0	155	0.00
control file sequential read	854	0.00	0	0	0.00
latch: redo writing	59	0.00	0	3	0.00
direct path read	720	0.00	0	0	0.00
latch: cache buffers chains	3	0.00	0	8	0.00
latch: library cache	3	0.00	0	2	0.00
log file sequential read	4	0.00	0	1	0.00
log file sync	2	0.00	0	1	0.00
direct path write	220	0.00	0	0	0.00
latch: shared pool	3	0.00	0	0	0.00
log file single write	4	0.00	0	0	0.00
latch: In memory undo latch	2	0.00	0	0	0.00
buffer busy waits	4	0.00	0	0	0.00
rdbms ipc message	888,768	1.18	30,917	35	0.70
Streams AQ: qmn slave idle wait	130	0.00	3,555	27349	0.00
Streams AQ: qmn coordinator idle wait	260	50.00	3,555	13674	0.00
pmon timer	2,336	95.80	3,530	1511	0.00
smon timer	166,366	0.00	3,530	21	0.13
Streams AQ: waiting for time management or cleanup tasks	271	5.54	3,529	13023	0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
BUSY_TIME	69,331,850
IDLE_TIME	50,499,022
IOWAIT_TIME	1,696,903
NICE_TIME	0
SYS_TIME	4,658,568
USER_TIME	61,354,019
LOAD	16
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	296,736
NUM_CPUS	32
NUM_CPU_SOCKETS	16

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
VIS	68,782.50	61,130.10	1,359,648	2,306,902,017
SYS$USERS	160.70	138.90	81,626	6,687,579
SYS$BACKGROUND	0.00	0.00	21,054	373,822

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	Admin Total Wts	Admin Wt Time	Network Total Wts	Network Wt Time
VIS	1088199	291421	1389523	88736	0	0	52966472	30091
SYS$USERS	22350	1938	389	4	0	0	89	0
SYS$BACKGROUND	2582	745	17	34	0	0	0	0

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
• Complete List of SQL Text

Back to Top

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 Module	SQL Text
7,468	7,243	285,451	0.03	10.84	60t2tt1564j0k		SELECT SUBSTRB(MACHINE, 1, 60)...
4,445	4,169	7,308	0.61	6.45	fkxdmd0h7xg54	OEXOETEL	select item, item_id, item_d...
4,101	3,868	112,799	0.04	5.95	6h2tpcxpymqu7	JDBC Thin Client	BEGIN :1 := FND_AOLJ_UTIL.is_V...
2,558	2,461	75,104	0.03	3.71	3prk3vg9u0abb	JDBC Thin Client	BEGIN FND_GLOBAL.APPS_INITIA...
2,513	2,272	289	8.69	3.65	0z318y6g3uagc	INCTCW	declare l_retstat varchar2 ( 3...
1,941	1,915	14	138.66	2.82	8c30hkqv9n7cr	OEHVIMP	BEGIN OE_BULK_ORDER_IMPORT_PVT...
1,856	1,803	10	185.64	2.69	bkxrrs52m7d8p	WSHINTERFACE	BEGIN WSH_SHIP_CONFIRM_ACTIONS...
1,726	1,460	16	107.88	2.51	1nj7kuvxgpwah	RAXTRX	begin ARP_TAX . SET_DEFAULT_TA...
1,683	1,458	157,307	0.01	2.44	5kqw5535fjvw6	ARXTWMAI	SELECT NVL(RCTT.ATTRIBUTE10, ...
1,655	1,374	49,999	0.03	2.40	gk43kd7q5mak4	RAXTRX	update ra_customer_trx_lines l...
1,292	1,255	39,339	0.03	1.87	9sf243fdjmdmh	JDBC Thin Client	begin fnd_global.apps_initiali...
1,138	1,028	16	71.13	1.65	5qyckzm5v1qmj	RAXTRX	begin :return_value:i_return_v...
1,126	1,032	205,828	0.01	1.63	473dq7tb653mp	CSCCCCRC	declare p varchar2(32767); ...
1,073	1,069	8	134.16	1.56	7g05xfvc5vp74	ARTERRPW	BEGIN arp_run.revenue_recognit...
982	940	1,224	0.80	1.42	3cb7xm8ykx1qh	icx.por.req.server.RequisitionAM	begin :1 := POR_UTIL_PKG.subm...
928	845	16	58.01	1.35	815ygd4pc1bpd	RAXTRX	INSERT INTO RA_CUSTOMER_TRX_LI...
862	809	258,868	0.00	1.25	25wzrzwd46a44	asn.dashboard.server.DashboardAM	SELECT 1 FROM DUAL WHERE EXIST...
813	788	21,227	0.04	1.18	8h16w67202y4g		begin fnd_global.initialize(:s...
795	750	64,146	0.01	1.15	g8102j8yynbwz	OEXOETEL	begin WF_STANDARD.CONTINUEFLOW...
745	61	2,427	0.31	1.08	3dssuqfjsynrk	asn.lead.server.LeadUwqAM	SELECT count(1) FROM (SELECT *...
742	252	2,427	0.31	1.08	8c8cf4vtv4tx2	asn.lead.server.LeadUwqAM	SELECT * FROM ( SELECT LeadEO....
730	599	96	7.61	1.06	37f1qguwxw0sk	RAXTRX	begin IF ( :v_msg_level:i_msg_...
697	679	363,954	0.00	1.01	a29grr748ghc4	fnd.framework.navigate.server.OANavigatePortletA	BEGIN jdr_custom_internal.getA...

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 Module	SQL Text
7,243	7,468	285,451	0.03	10.84	60t2tt1564j0k		SELECT SUBSTRB(MACHINE, 1, 60)...
4,169	4,445	7,308	0.57	6.45	fkxdmd0h7xg54	OEXOETEL	select item, item_id, item_d...
3,868	4,101	112,799	0.03	5.95	6h2tpcxpymqu7	JDBC Thin Client	BEGIN :1 := FND_AOLJ_UTIL.is_V...
2,461	2,558	75,104	0.03	3.71	3prk3vg9u0abb	JDBC Thin Client	BEGIN FND_GLOBAL.APPS_INITIA...
2,272	2,513	289	7.86	3.65	0z318y6g3uagc	INCTCW	declare l_retstat varchar2 ( 3...
1,915	1,941	14	136.78	2.82	8c30hkqv9n7cr	OEHVIMP	BEGIN OE_BULK_ORDER_IMPORT_PVT...
1,803	1,856	10	180.32	2.69	bkxrrs52m7d8p	WSHINTERFACE	BEGIN WSH_SHIP_CONFIRM_ACTIONS...
1,460	1,726	16	91.28	2.51	1nj7kuvxgpwah	RAXTRX	begin ARP_TAX . SET_DEFAULT_TA...
1,458	1,683	157,307	0.01	2.44	5kqw5535fjvw6	ARXTWMAI	SELECT NVL(RCTT.ATTRIBUTE10, ...
1,374	1,655	49,999	0.03	2.40	gk43kd7q5mak4	RAXTRX	update ra_customer_trx_lines l...
1,255	1,292	39,339	0.03	1.87	9sf243fdjmdmh	JDBC Thin Client	begin fnd_global.apps_initiali...
1,069	1,073	8	133.57	1.56	7g05xfvc5vp74	ARTERRPW	BEGIN arp_run.revenue_recognit...
1,032	1,126	205,828	0.01	1.63	473dq7tb653mp	CSCCCCRC	declare p varchar2(32767); ...
1,028	1,138	16	64.23	1.65	5qyckzm5v1qmj	RAXTRX	begin :return_value:i_return_v...
940	982	1,224	0.77	1.42	3cb7xm8ykx1qh	icx.por.req.server.RequisitionAM	begin :1 := POR_UTIL_PKG.subm...
845	928	16	52.81	1.35	815ygd4pc1bpd	RAXTRX	INSERT INTO RA_CUSTOMER_TRX_LI...
809	862	258,868	0.00	1.25	25wzrzwd46a44	asn.dashboard.server.DashboardAM	SELECT 1 FROM DUAL WHERE EXIST...
788	813	21,227	0.04	1.18	8h16w67202y4g		begin fnd_global.initialize(:s...
750	795	64,146	0.01	1.15	g8102j8yynbwz	OEXOETEL	begin WF_STANDARD.CONTINUEFLOW...
679	697	363,954	0.00	1.01	a29grr748ghc4	fnd.framework.navigate.server.OANavigatePortletA	BEGIN jdr_custom_internal.getA...
599	730	96	6.24	1.06	37f1qguwxw0sk	RAXTRX	begin IF ( :v_msg_level:i_msg_...
252	742	2,427	0.10	1.08	8c8cf4vtv4tx2	asn.lead.server.LeadUwqAM	SELECT * FROM ( SELECT LeadEO....
61	745	2,427	0.03	1.08	3dssuqfjsynrk	asn.lead.server.LeadUwqAM	SELECT count(1) FROM (SELECT *...

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: 2,312,580,606
• Captured SQL account for 25.9% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
125,576,284	14	8,969,734.57	5.43	1914.98	1941.28	8c30hkqv9n7cr	OEHVIMP	BEGIN OE_BULK_ORDER_IMPORT_PVT...
116,783,535	16	7,298,970.94	5.05	1460.42	1726.15	1nj7kuvxgpwah	RAXTRX	begin ARP_TAX . SET_DEFAULT_TA...
113,712,884	49,999	2,274.30	4.92	1373.84	1655.16	gk43kd7q5mak4	RAXTRX	update ra_customer_trx_lines l...
106,134,860	157,307	674.70	4.59	1458.01	1683.02	5kqw5535fjvw6	ARXTWMAI	SELECT NVL(RCTT.ATTRIBUTE10, ...
104,205,151	8	13,025,643.88	4.51	1068.55	1073.32	7g05xfvc5vp74	ARTERRPW	BEGIN arp_run.revenue_recognit...
94,278,241	205,828	458.04	4.08	1032.31	1125.91	473dq7tb653mp	CSCCCCRC	declare p varchar2(32767); ...
93,493,150	16	5,843,321.88	4.04	1027.71	1138.09	5qyckzm5v1qmj	RAXTRX	begin :return_value:i_return_v...
92,916,462	258,868	358.93	4.02	809.50	862.25	25wzrzwd46a44	asn.dashboard.server.DashboardAM	SELECT 1 FROM DUAL WHERE EXIST...
76,069,608	10	7,606,960.80	3.29	1803.19	1856.38	bkxrrs52m7d8p	WSHINTERFACE	BEGIN WSH_SHIP_CONFIRM_ACTIONS...
54,726,072	10	5,472,607.20	2.37	642.39	653.90	1du9v021t8m46	ARGLTP	insert into gl_interface(creat...
53,839,267	16	3,364,954.19	2.33	844.95	928.24	815ygd4pc1bpd	RAXTRX	INSERT INTO RA_CUSTOMER_TRX_LI...
48,331,076	289	167,235.56	2.09	2271.58	2512.63	0z318y6g3uagc	INCTCW	declare l_retstat varchar2 ( 3...
47,464,972	1,224	38,778.57	2.05	939.59	981.76	3cb7xm8ykx1qh	icx.por.req.server.RequisitionAM	begin :1 := POR_UTIL_PKG.subm...
40,772,482	96	424,713.35	1.76	598.85	730.43	37f1qguwxw0sk	RAXTRX	begin IF ( :v_msg_level:i_msg_...
39,062,787	174,381	224.01	1.69	613.05	625.85	3b3psftuyks81	INVTTMTX	BEGIN INV_TXNSTUB_PUB.postTran...
39,037,834	174,377	223.87	1.69	594.95	606.80	gf1u933c95jb5	INVTTMTX	DECLARE l_ret_stat varchar2...
37,754,729	64,146	588.57	1.63	749.96	794.63	g8102j8yynbwz	OEXOETEL	begin WF_STANDARD.CONTINUEFLOW...
34,942,016	57,314	609.66	1.51	631.93	644.41	4yak7x2zqz0dh	WSHFRREL	BEGIN inv_transfer_order_pvt.f...
28,343,853	7,308	3,878.47	1.23	4169.16	4445.14	fkxdmd0h7xg54	OEXOETEL	select item, item_id, item_d...
26,380,148	458,962	57.48	1.14	239.83	242.41	91hakq9n36htp		SELECT TEXT_VALUE FROM WF_ITEM...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

• Total Disk Reads: 1,463,914
• Captured SQL account for 44.8% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
209,126	2,427	86.17	14.29	61.11	745.02	3dssuqfjsynrk	asn.lead.server.LeadUwqAM	SELECT count(1) FROM (SELECT *...
161,625	8	20,203.13	11.04	12.69	35.98	g6yx4z6m66xtq	RAXMTR	select /*+ parallel(t, 8) para...
147,938	2,427	60.96	10.11	252.32	742.10	8c8cf4vtv4tx2	asn.lead.server.LeadUwqAM	SELECT * FROM ( SELECT LeadEO....
107,705	6	17,950.83	7.36	7.40	28.97	4099q0gjjdwah	RAXMTR	select /*+ parallel(t, 8) para...
24,824	10	2,482.40	1.70	1803.19	1856.38	bkxrrs52m7d8p	WSHINTERFACE	BEGIN WSH_SHIP_CONFIRM_ACTIONS...
19,045	125,714	0.15	1.30	56.26	63.57	fb13x9qx0ftks	OEXOETEL	begin OE_STANDARD_WF.OEOL_SELE...
16,871	7,314	2.31	1.15	523.56	594.56	8jb36w62w5hqf	ibuSRDetailsActions.jsp	BEGIN IBU_REQ_PKG.UpdateServic...
15,860	205,828	0.08	1.08	1032.31	1125.91	473dq7tb653mp	CSCCCCRC	declare p varchar2(32767); ...
15,445	258,868	0.06	1.06	809.50	862.25	25wzrzwd46a44	asn.dashboard.server.DashboardAM	SELECT 1 FROM DUAL WHERE EXIST...
14,636	289	50.64	1.00	2271.58	2512.63	0z318y6g3uagc	INCTCW	declare l_retstat varchar2 ( 3...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

• Total Executions: 107,048,010
• Captured SQL account for 6.9% of Total

Executions	Rows Processed	Rows per Exec	CPU per Exec (s)	Elap per Exec (s)	SQL Id	SQL Module	SQL Text
610,679	610,635	1.00	0.00	0.00	avc1jqzz04wpr	JDBC Thin Client	SELECT 'x' FROM DUAL
458,962	439,146	0.96	0.00	0.00	91hakq9n36htp		SELECT TEXT_VALUE FROM WF_ITEM...
400,390	315,720	0.79	0.00	0.00	fmfdkztk8vx23		SELECT CATEGORY, SEVERITY, F...
393,149	389,422	0.99	0.00	0.00	0b85w9vv0hbt1		UPDATE WF_ITEM_ATTRIBUTE_VALUE...
363,954	363,928	1.00	0.00	0.00	a29grr748ghc4	fnd.framework.navigate.server.OANavigatePortletA	BEGIN jdr_custom_internal.getA...
298,363	5,072,075	17.00	0.00	0.00	cwyx16zn1hpfb	JDBC Thin Client	select parameter, value from ...
285,451	285,346	1.00	0.03	0.03	60t2tt1564j0k		SELECT SUBSTRB(MACHINE, 1, 60)...
265,742	265,742	1.00	0.00	0.00	2rg930brttdn3	ap.oie.server.WebExpensesAM	INSERT INTO WF_NOTIFICATION_AT...
258,868	0	0.00	0.00	0.00	25wzrzwd46a44	asn.dashboard.server.DashboardAM	SELECT 1 FROM DUAL WHERE EXIST...
205,828	205,827	1.00	0.01	0.01	473dq7tb653mp	CSCCCCRC	declare p varchar2(32767); ...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 10,146,579
• Captured SQL account for 39.9% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
610,647	610,679	6.02	avc1jqzz04wpr	JDBC Thin Client	SELECT 'x' FROM DUAL
400,346	400,390	3.95	fmfdkztk8vx23		SELECT CATEGORY, SEVERITY, F...
363,943	363,954	3.59	a29grr748ghc4	fnd.framework.navigate.server.OANavigatePortletA	BEGIN jdr_custom_internal.getA...
298,359	298,363	2.94	cwyx16zn1hpfb	JDBC Thin Client	select parameter, value from ...
205,828	205,828	2.03	473dq7tb653mp	CSCCCCRC	declare p varchar2(32767); ...
174,387	174,389	1.72	6gnth2mfbs2nq	INVTTMTX	declare v_ret number := 0...
125,711	125,714	1.24	fb13x9qx0ftks	OEXOETEL	begin OE_STANDARD_WF.OEOL_SELE...
122,169	122,170	1.20	162ttnv4ubqun	OEXOETEL	begin OE_DS_PVT.Check_PO_Appr...
117,075	117,076	1.15	1c0b7sas42w2z	INVTTMTX	SELECT NVL(ITEM_COST, 0), ...
112,963	112,964	1.11	8camsgjsr9zya	OEXOETEL	begin OE_TRANSACTION_TYPES_PK...
101,951	101,952	1.00	76sw2a4vnc89j	icx.por.req.server.RequisitionAM	begin FND_FLEX_WORKFLOW_APIS.S...

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
17,381,357	8	0.55	g6yx4z6m66xtq	RAXMTR	select /*+ parallel(t, 8) para...
7,228,895	6	0.23	4099q0gjjdwah	RAXMTR	select /*+ parallel(t, 8) para...
1,051,610	20,414	0.03	1fvcx62k23ph5	OEXOETEL	SELECT /*+ ORDERED USE_NL(qpq ...

Back to SQL Statistics
Back to Top

 

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

 

Complete List of SQL Text

SQL Id	SQL Text
0b85w9vv0hbt1	UPDATE WF_ITEM_ATTRIBUTE_VALUES SET TEXT_VALUE = :B4 WHERE ITEM_TYPE = :B3 AND ITEM_KEY = :B2 AND NAME = :B1
0z318y6g3uagc	declare l_retstat varchar2 ( 3 ) ; l_msg_data varchar2 ( 244 ) ; l_msg_cnt number ; l_trx_cnt number ; BEGIN :retval := INV_TXN_MANAGER_PUB . process_Transactions ( p_api_version => 1.0 , p_commit => fnd_api . g_true , x_return_status => l_retstat , x_msg_count => l_msg_cnt , x_msg_data => l_msg_data , x_trans_count => l_trx_cnt , p_table => 1 , p_header_id => :header_id ) ; END ;
162ttnv4ubqun	begin OE_DS_PVT.Check_PO_Approved( :t_application_id, :t_entity_short_name, :t_validation_entity_short_name, :t_validation_tmplt_short_name, :t_record_set_short_name, :t_scope, :t_result ); end;
1c0b7sas42w2z	SELECT NVL(ITEM_COST, 0), COST_UPDATE_ID FROM CST_ITEM_COSTS WHERE INVENTORY_ITEM_ID = :1 AND ORGANIZATION_ID = :2 AND COST_TYPE_ID = :3
1du9v021t8m46	insert into gl_interface(created_by, date_created, status, actual_flag, group_id, set_of_books_id, user_je_source_name, user_je_category_name, accounting_date, subledger_doc_sequence_id, subledger_doc_sequence_value, ussgl_transaction_code, currency_code, code_combination_id, entered_dr, entered_cr, accounted_dr, accounted_cr, reference1, reference10, reference21, reference22, reference23, reference24, reference25, reference26, reference27, reference28, reference29, reference30, request_id)select /*+ ORDERED USE_NL (l ctlgd ct ctt cust) INDEX (ctlgd, RA_CUST_TRX_LINE_GL_DIST_N5) +*/ :b0 created_by , trunc(sysdate ) date_created , :b1 status , :b2 actual_flag , :b3 group_id , :b4 sob_id , :b5 source_name , decode(ctt.type, 'CM', :b6, 'DM', :b7, 'CB', :b8, :b9) category , ctlgd.gl_date gl_date , ct.doc_sequence_id doc_seqid , ct.doc_sequence_value doc_num , ctlgd.ussgl_transaction_code ussgl , ct.invoice_currency_code currency , ctlgd.code_combination_id ccid , decode(ctlgd.account_class, 'REC', decode(sign(nvl(ctlgd.amount, 0)), (-1), null , nvl(ctlgd.amount, 0)), 'ROUND', decode(sign(nvl(ctlgd.acctd_amount, 0)), (-1), (-nvl(ctlgd.amount, 0)), null ), decode(sign(nvl(ctlgd.amount, 0)), (-1), (-nvl(ctlgd.amount, 0)), null )) entered_dr , decode(ctlgd.account_class, 'REC', decode(sign(nvl(ctlgd.amount, 0)), (-1), (-nvl(ctlgd.amount, 0)), null ), 'ROUND', decode(sign(nvl(ctlgd.acctd_amount, 0)), (-1), null , nvl(ctlgd.amount, 0)), decode(sign(nvl(ctlgd.amount , 0)), (-1), null , nvl(ctlgd.amount, 0))) entered_cr , decode(ctlgd.account_class, 'REC', decode(sign(nvl(ctlgd.amount, 0)), (-1), null , nvl(ctlgd.acctd_amount, 0)), 'ROUND', decode(sign(nvl(ctlgd.acctd_amount, 0)), (-1), (-nvl(ctlgd.acctd_amount, 0)), null ), decode(sign(nvl(ctlgd.amount, 0)), (-1), (-nvl(ctlgd.acctd_amount, 0)), null )) acctd_dr , decode(ctlgd.account_class, 'REC', decode(sign(nvl(ctlgd.amount, 0)), (-1), (-nvl(ctlgd.acctd_amount, 0)), null ), 'ROUND', decode(sign(nvl(ctlgd.acctd_amount, 0)), (-1), null , nvl(ctlgd.acctd_amount, 0)), decode(sign(nvl(ctlgd.amount, 0)), (-1), null , nvl(ctlgd.acctd_amount, 0))) acctd_cr , (:b10||to_char(:b3)) ref1 , decode(:b12, 'Y', null , ((((((l.meaning||' ')||:b13)||decode(ctt.type, 'CB', :b14, 'CM', :b15, 'DEP', :b16, 'DM', :b17, 'GUAR', :b18, 'INV', :b19, null ))||' ')||ct.trx_number)||:b20)) ref10 , to_char(:b3) ref21 , to_char(ct.customer_trx_id) ref22 , to_char(ctlgd.cust_trx_line_gl_dist_id) ref23 , ct.trx_number ref24 , cust.account_number ref25 , 'CUSTOMER' ref26 , to_char(ct.bill_to_customer_id) ref27 , decode(ctt.type, 'CM', 'CM', 'DM', 'DM', 'CB', 'CB', 'INV') ref28 , (decode(ctt.type, 'CM', 'CM_', 'DM', 'DM_', 'CB', 'CB_', 'INV_')||ctlgd.account_class) ref29 , 'RA_CUST_TRX_LINE_GL_DIST' ref30 , :b22 from ra_cust_trx_line_gl_dist ctlgd , ra_cust_trx_line_gl_dist rec , ar_lookups l , ra_customer_trx ct , ra_cust_trx_types ctt , hz_cust_accounts cust where ((((((((((((((((ctlgd.cust_trx_line_gl_dist_id+0)<: b23 and ctlgd.gl_date between to_date((:b24||' 00:00:00'), 'DD-MON-RR HH24:MI:SS') and to_date((:b25||' 23:59:59'), 'DD-MON-RR HH24:MI:SS')) and ctlgd.posting_control_id=(-3)) and ctlgd.set_of_books_id=:b4) and ctlgd.account_set_flag='N') and ctlgd.customer_trx_id=ct.customer_trx_id) and l.lookup_type='AUTOGL_TYPE') and l.lookup_code=nvl(ctlgd.account_class, 'REV')) and ct.complete_flag='Y') and ct.bill_to_customer_id=cust.cust_account_id) and ct.cust_trx_type_id=ctt.cust_trx_type_id) and ctlgd.customer_trx_id=rec.customer_trx_id) and rec.account_class='REC') and rec.latest_rec_flag='Y') and rec.account_set_flag='N') and 'NOT_MFAR_TYPE'=AR_MFAR_PKG.ar_mfar_trx_post(ctlgd.customer_trx_id, :b0, :b1, :b2, :b3, :b4, :b5, :b6, :b7, :b8, :b9, :b10, :b12, :b13, :b20, :b14, :b15, :b17, :b16, :b18, :b19, :b24, :b25, :b23))
1fvcx62k23ph5	SELECT /*+ ORDERED USE_NL(qpq qplh qph) index(qpq qp_qualifiers_n4) index(qph qp_list_headers_b_n7) index(qplatq qp_preq_line_attrs_tmp_n2) l_header_outer_qual_cur_mod */ QPQ.LIST_HEADER_ID, QPQ.LIST_LINE_ID LIST_LINE_ID, QPQ.QUALIFIER_GROUP_CNT, QPQ.OTHERS_GROUP_CNT, QPQ.HEADER_QUALS_EXIST_FLAG, QPQ.SEARCH_IND, :B7 VALIDATED_FLAG, :B7 APPLIED_FLAG, :B12 ATTRIBUTE_LEVEL, :B2 ATTRIBUTE_TYPE, QPLATQ.CONTEXT , QPLATQ.ATTRIBUTE , QPLATQ.VALUE_FROM , QPQ.QUALIFIER_GROUPING_NO QUALIFIER_GROUPING_NO , QPQ.QUALIFIER_PRECEDENCE , QPQ.QUALIFIER_DATATYPE, QPQ.QUALIFIER_ATTR_VALUE , QPQ.QUALIFIER_ATTR_VALUE_TO , QPQ.START_DATE_ACTIVE, QPQ.END_DATE_ACTIVE, :B7 PRICING_ATTR_FLAG, QPQ.COMPARISON_OPERATOR_CODE , QPH.LIST_TYPE_CODE, QPH.ASK_FOR_FLAG, QPLATQ.PRICING_STATUS_CODE, 'OHQ' , NULL LINE_INDEX, NULL PRICING_EFFECTIVE_DATE, QPH.START_DATE_ACTIVE_FIRST START_DATE_ACTIVE_FIRST, QPH.END_DATE_ACTIVE_FIRST END_DATE_ACTIVE_FIRST, NULL LINE_TYPE_CODE, :B9 PRICING_PHASE_ID, QPQ.LIST_HEADER_ID || '-' || QPQ.LIST_LINE_ID || '-' || QPQ.QUALIFIER_GROUPING_NO UNIQUE_KEY, QPH.START_DATE_ACTIVE START_DATE_ACTIVE_H, QPH.END_DATE_ACTIVE END_DATE_ACTIVE_H, QPH.START_DATE_ACTIVE_SECOND START_DATE_ACTIVE_SECOND, QPH.END_DATE_ACTIVE_SECOND END_DATE_ACTIVE_SECOND, QPH.ACTIVE_DATE_FIRST_TYPE, QPH.ACTIVE_DATE_SECOND_TYPE, QPH.LIMIT_EXISTS_FLAG FROM QP_NPREQ_LINE_ATTRS_TMP QPLATQ, QP_QUALIFIERS QPQ , QP_LIST_HEADER_PHASES QPLH, QP_LIST_HEADERS_B QPH, QP_PRICE_REQ_SOU RCES_V QPRS WHERE QPQ.LIST_HEADER_ID = QPLH.LIST_HEADER_ID AND QPLH.LIST_HEADER_ID = QPH.LIST_HEADER_ID AND ((NVL(:B10 , 'OFF') = 'ON' AND :B11 = QPH.ORIG_ORG_ID) OR (NVL(:B10 , 'OFF') = 'ON' AND NVL(QPH.GLOBAL_FLAG, 'Y') = 'Y') OR NVL(:B10 , 'OFF') = 'OFF' ) AND QPLH.PRICING_PHASE_ID = :B9 AND QPQ.QUALIFIER_CONTEXT = QPLATQ.CONTEXT AND QPQ.QUALIFIER_ATTRIBUTE = QPLATQ.ATTRIBUTE AND QPQ.QUALIFIER_ATTR_VALUE = QPLATQ.VALUE_FROM AND QPQ.COMPARISON_OPERATOR_CODE = '=' AND QPQ.LIST_LINE_ID = -1 AND QPQ.SEARCH_IND = 1 AND ((QPH.CURRENCY_CODE IS NOT NULL AND QPH.CURRENCY_CODE = :B8 ) OR QPH.CURRENCY_CODE IS NULL) AND ((QPH.ASK_FOR_FLAG = :B4 AND QPH.LIST_HEADER_ID IN (SELECT LIST_HEADER_ID FROM QP_NPREQ_LINE_ATTRS_TMP WHERE ATTRIBUTE_TYPE = 'QUALIFIER' AND PRICING_STATUS_CODE = :B3 AND VALIDATED_FLAG = :B7 AND LIST_HEADER_ID IS NOT NULL)) OR QPH.ASK_FOR_FLAG = :B7 ) AND ((:B6 BETWEEN NVL(QPH.START_DATE_ACTIVE , :B6 ) AND NVL(QPH.END_DATE_ACTIVE, :B6 ) OR :B5 BETWEEN NVL(QPH.START_DATE_ACTIVE , :B5 ) AND NVL(QPH.END_DATE_ACTIVE, :B5 ))) AND ((:B6 BETWEEN NVL(QPQ.START_DATE_ACTIVE , :B6 ) AND NVL(QPQ.END_DATE_ACTIVE, :B6 ) OR :B5 BETWEEN NVL(QPQ.START_DATE_ACTIVE , :B5 ) AND NVL(QPQ.END_DATE_ACTIVE, :B5 ))) AND QPH.LIST_TYPE_CODE NOT IN ('PRL', 'AGR') AND QPQ.LIST_TYPE_CODE NOT IN ('PRL', 'AGR') AND QPH.ACTIVE_FLAG = :B4 AND QPQ.ACTIVE_FLAG = :B4 AND QPLATQ.DISTINCT_QUALIFIER_FLAG = :B4 AND QPQ.LIST_HEADER_ID = QPH.LIST_HEADER_ID AND QPLATQ.PRICING_STATUS_CODE = :B3 AND QPLATQ .ATTRIBUTE_TYPE = :B2 AND QPRS.REQUEST_TYPE_CODE = :B1 AND QPH.SOURCE_SYSTEM_CODE = QPRS.SOURCE_SYSTEM_CODE UNION ALL SELECT /*+ ORDERED USE_NL(qpq qplh qph) index(qpq qp_qualifiers_n6) index(qph qp_list_headers_b_n7) index(qplatq qp_preq_line_attrs_tmp_n2) l_header_outer_qual_cur_mod */ QPQ.LIST_HEADER_ID, QPQ.LIST_LINE_ID LIST_LINE_ID, QPQ.QUALIFIER_GROUP_CNT, QPQ.OTHERS_GROUP_CNT, QPQ.HEADER_QUALS_EXIST_FLAG, QPQ.SEARCH_IND, :B7 VALIDATED_FLAG, :B7 APPLIED_FLAG, :B12 ATTRIBUTE_LEVEL, :B2 ATTRIBUTE_TYPE, QPLATQ.CONTEXT , QPLATQ.ATTRIBUTE , QPLATQ.VALUE_FROM , QPQ.QUALIFIER_GROUPING_NO QUALIFIER_GROUPING_NO , QPQ.QUALIFIER_PRECEDENCE , QPQ.QUALIFIER_DATATYPE, QPQ.QUALIFIER_ATTR_VALUE , QPQ.QUALIFIER_ATTR_VALUE_TO , QPQ.START_DATE_ACTIVE, QPQ.END_DATE_ACTIVE, :B7 PRICING_ATTR_FLAG, QPQ.COMPARISON_OPERATOR_CODE , QPH.LIST_TYPE_CODE, QPH.ASK_FOR_FLAG, QPLATQ.PRICING_STATUS_CODE, 'OHQ' , NULL LINE_INDEX, NULL PRICING_EFFECTIVE_DATE, QPH.START_DATE_ACTIVE_FIRST START_DATE_ACTIVE_FIRST, QPH.END_DATE_ACTIVE_FIRST END_DATE_ACTIVE_FIRST, NULL LINE_TYPE_CODE, :B9 PRICING_PHASE_ID, QPQ.LIST_HEADER_ID || '-' || QPQ.LIST_LINE_ID || '-' || QPQ.QUALIFIER_GROUPING_NO UNIQUE_KEY, QPH.START_DATE_ACTIVE START_DATE_ACTIVE_H, QPH.END_DATE_ACTIVE END_DATE_ACTIVE_H, QPH.START_DATE_ACTIVE_SECOND START_DATE_ACTIVE_SECOND, QPH.END_DATE_ACTIVE_SECOND END_DATE_ACTIVE_SECOND, QPH.ACTIVE_DATE_FIRST_TYPE, QPH.ACTIVE_DATE_SECOND_TYPE, QPH.LIMIT_EXISTS_FLAG FROM QP_NPR EQ_LINE_ATTRS_TMP QPLATQ, QP_QUALIFIERS QPQ , QP_LIST_HEADER_PHASES QPLH, QP_LIST_HEADERS_B QPH, QP_PRICE_REQ_SOURCES_V QPRS WHERE QPQ.LIST_HEADER_ID = QPLH.LIST_HEADER_ID AND QPLH.LIST_HEADER_ID = QPH.LIST_HEADER_ID AND ((NVL(:B10 , 'OFF') = 'ON' AND :B11 = QPH.ORIG_ORG_ID) OR (NVL(:B10 , 'OFF') = 'ON' AND NVL(QPH.GLOBAL_FLAG, 'Y') = 'Y') OR NVL(:B10 , 'OFF') = 'OFF' ) AND QPLH.PRICING_PHASE_ID = :B9 AND QPQ.QUALIFIER_CONTEXT = QPLATQ.CONTEXT AND QPQ.QUALIFIER_ATTRIBUTE = QPLATQ.ATTRIBUTE AND QPQ.COMPARISON_OPERATOR_CODE = :B14 AND QPQ.QUALIFIER_DATATYPE = :B13 AND QPQ.SEARCH_IND = 1 AND QPQ.LIST_LINE_ID = -1 AND FND_NUMBER.CANONICAL_TO_NUMBER(DECODE(QPQ.QUALIFIER_DATATYPE, :B13 , QPLATQ.VALUE_FROM, NULL)) BETWEEN QPQ.QUAL_ATTR_VALUE_FROM_NUMBER AND QPQ.QUAL_ATTR_VALUE_TO_NUMBER AND ((QPH.CURRENCY_CODE IS NOT NULL AND QPH.CURRENCY_CODE = :B8 ) OR QPH.CURRENCY_CODE IS NULL) AND ((QPH.ASK_FOR_FLAG = :B4 AND QPH.LIST_HEADER_ID IN (SELECT LIST_HEADER_ID FROM QP_NPREQ_LINE_ATTRS_TMP WHERE ATTRIBUTE_TYPE = 'QUALIFIER' AND PRICING_STATUS_CODE = :B3 AND VALIDATED_FLAG = :B7 AND LIST_HEADER_ID IS NOT NULL)) OR QPH.ASK_FOR_FLAG = :B7 ) AND ((:B6 BETWEEN NVL(QPH.START_DATE_ACTIVE , :B6 ) AND NVL(QPH.END_DATE_ACTIVE, :B6 ) OR :B5 BETWEEN NVL(QPH.START_DATE_ACTIVE , :B5 ) AND NVL(QPH.END_DATE_ACTIVE, :B5 ))) AND ((:B6 BETWEEN NVL(QPQ.START_DATE_ACTIVE , :B6 ) AND NVL(QPQ.END_DATE_ACTIVE, :B6 ) OR :B5 BETWEEN NVL(QPQ.START_DATE_ACTIVE , :B5 ) AND NVL(QPQ.END_DATE_ACTIVE, :B5 )) ) AND QPH.LIST_TYPE_CODE NOT IN ('PRL', 'AGR') AND QPQ.LIST_TYPE_CODE NOT IN ('PRL', 'AGR') AND QPH.ACTIVE_FLAG = :B4 AND QPQ.ACTIVE_FLAG = :B4 AND QPLATQ.DISTINCT_QUALIFIER_FLAG = :B4 AND QPQ.LIST_HEADER_ID = QPH.LIST_HEADER_ID AND QPLATQ.PRICING_STATUS_CODE = :B3 AND QPLATQ.ATTRIBUTE_TYPE = :B2 AND QPRS.REQUEST_TYPE_CODE = :B1 AND QPH.SOURCE_SYSTEM_CODE = QPRS.SOURCE_SYSTEM_CODE UNION ALL SELECT /*+ ORDERED USE_NL(qpq qplh qph) index(qpq qp_qualifiers_n5) index(qph qp_list_headers_b_n7) index(qplatq qp_preq_line_attrs_tmp_n2) l_header_outer_qual_cur_mod */ QPQ.LIST_HEADER_ID, QPQ.LIST_LINE_ID LIST_LINE_ID, QPQ.QUALIFIER_GROUP_CNT, QPQ.OTHERS_GROUP_CNT, QPQ.HEADER_QUALS_EXIST_FLAG, QPQ.SEARCH_IND, :B7 VALIDATED_FLAG, :B7 APPLIED_FLAG, :B12 ATTRIBUTE_LEVEL, :B2 ATTRIBUTE_TYPE, QPLATQ.CONTEXT , QPLATQ.ATTRIBUTE , QPLATQ.VALUE_FROM , QPQ.QUALIFIER_GROUPING_NO QUALIFIER_GROUPING_NO , QPQ.QUALIFIER_PRECEDENCE , QPQ.QUALIFIER_DATATYPE, QPQ.QUALIFIER_ATTR_VALUE , QPQ.QUALIFIER_ATTR_VALUE_TO , QPQ.START_DATE_ACTIVE, QPQ.END_DATE_ACTIVE, :B7 PRICING_ATTR_FLAG, QPQ.COMPARISON_OPERATOR_CODE , QPH.LIST_TYPE_CODE, QPH.ASK_FOR_FLAG, QPLATQ.PRICING_STATUS_CODE, 'OHQ' , NULL LINE_INDEX, NULL PRICING_EFFECTIVE_DATE, QPH.START_DATE_ACTIVE_FIRST START_DATE_ACTIVE_FIRST, QPH.END_DATE_ACTIVE_FIRST END_DATE_ACTIVE_FIRST, NULL LINE_TYPE_CODE, :B9 PRICING_PHASE_ID, QPQ.LIST_HEADER_ID || '-' || QPQ.LIST_LINE_ID || '-' || QPQ.QUALIFIER_GROUPING_NO UNIQUE_KEY, QPH.STAR T_DATE_ACTIVE START_DATE_ACTIVE_H, QPH.END_DATE_ACTIVE END_DATE_ACTIVE_H, QPH.START_DATE_ACTIVE_SECOND START_DATE_ACTIVE_SECOND, QPH.END_DATE_ACTIVE_SECOND END_DATE_ACTIVE_SECOND, QPH.ACTIVE_DATE_FIRST_TYPE, QPH.ACTIVE_DATE_SECOND_TYPE, QPH.LIMIT_EXISTS_FLAG FROM QP_NPREQ_LINE_ATTRS_TMP QPLATQ, QP_QUALIFIERS QPQ , QP_LIST_HEADER_PHASES QPLH, QP_LIST_HEADERS_B QPH, QP_PRICE_REQ_SOURCES_V QPRS WHERE QPQ.LIST_HEADER_ID = QPLH.LIST_HEADER_ID AND QPLH.LIST_HEADER_ID = QPH.LIST_HEADER_ID AND ((NVL(:B10 , 'OFF') = 'ON' AND :B11 = QPH.ORIG_ORG_ID) OR (NVL(:B10 , 'OFF') = 'ON' AND NVL(QPH.GLOBAL_FLAG, 'Y') = 'Y') OR NVL(:B10 , 'OFF') = 'OFF' ) AND QPLH.PRICING_PHASE_ID = :B9 AND QPQ.QUALIFIER_CONTEXT = QPLATQ.CONTEXT AND QPQ.QUALIFIER_ATTRIBUTE = QPLATQ.ATTRIBUTE AND QPQ.COMPARISON_OPERATOR_CODE = :B14 AND QPQ.SEARCH_IND = 1 AND QPQ.LIST_LINE_ID = -1 AND QPQ.QUALIFIER_DATATYPE IN (:B17 , :B16 , :B15 ) AND QPLATQ.VALUE_FROM BETWEEN QPQ.QUALIFIER_ATTR_VALUE AND QPQ.QUALIFIER_ATTR_VALUE_TO AND ((QPH.CURRENCY_CODE IS NOT NULL AND QPH.CURRENCY_CODE = :B8 ) OR QPH.CURRENCY_CODE IS NULL) AND ((QPH.ASK_FOR_FLAG = :B4 AND QPH.LIST_HEADER_ID IN (SELECT LIST_HEADER_ID FROM QP_NPREQ_LINE_ATTRS_TMP WHERE ATTRIBUTE_TYPE = 'QUALIFIER' AND PRICING_STATUS_CODE = :B3 AND VALIDATED_FLAG = :B7 AND LIST_HEADER_ID IS NOT NULL)) OR QPH.ASK_FOR_FLAG = :B7 ) AND ((:B6 BETWEEN NVL(QPH.START_DATE_ACTIVE , :B6 ) AND NVL(QPH.END_DATE_ACTIVE, :B6 ) OR :B5 BETWEEN NVL(QPH.START_DATE_ACTIVE , :B5 ) AN D NVL(QPH.END_DATE_ACTIVE, :B5 ))) AND ((:B6 BETWEEN NVL(QPQ.START_DATE_ACTIVE , :B6 ) AND NVL(QPQ.END_DATE_ACTIVE, :B6 ) OR :B5 BETWEEN NVL(QPQ.START_DATE_ACTIVE , :B5 ) AND NVL(QPQ.END_DATE_ACTIVE, :B5 ))) AND QPH.LIST_TYPE_CODE NOT IN ('PRL', 'AGR') AND QPQ.LIST_TYPE_CODE NOT IN ('PRL', 'AGR') AND QPH.ACTIVE_FLAG = :B4 AND QPQ.ACTIVE_FLAG = :B4 AND QPLATQ.DISTINCT_QUALIFIER_FLAG = :B4 AND QPQ.LIST_HEADER_ID = QPH.LIST_HEADER_ID AND QPLATQ.PRICING_STATUS_CODE = :B3 AND QPLATQ.ATTRIBUTE_TYPE = :B2 AND QPRS.REQUEST_TYPE_CODE = :B1 AND QPH.SOURCE_SYSTEM_CODE = QPRS.SOURCE_SYSTEM_CODE UNION ALL SELECT /*+ ORDERED USE_NL(qpq qplh qph) index(qpq qp_qualifiers_n5) index(qph qp_list_headers_b_n7) index(qplatq qp_preq_line_attrs_tmp_n2) l_header_outer_qual_cur_mod */ QPQ.LIST_HEADER_ID, QPQ.LIST_LINE_ID LIST_LINE_ID, QPQ.QUALIFIER_GROUP_CNT, QPQ.OTHERS_GROUP_CNT, QPQ.HEADER_QUALS_EXIST_FLAG, QPQ.SEARCH_IND, :B7 VALIDATED_FLAG, :B7 APPLIED_FLAG, :B12 ATTRIBUTE_LEVEL, :B2 ATTRIBUTE_TYPE, QPLATQ.CONTEXT , QPLATQ.ATTRIBUTE , QPLATQ.VALUE_FROM , QPQ.QUALIFIER_GROUPING_NO QUALIFIER_GROUPING_NO , QPQ.QUALIFIER_PRECEDENCE , QPQ.QUALIFIER_DATATYPE, QPQ.QUALIFIER_ATTR_VALUE , QPQ.QUALIFIER_ATTR_VALUE_TO , QPQ.START_DATE_ACTIVE, QPQ.END_DATE_ACTIVE, :B7 PRICING_ATTR_FLAG, QPQ.COMPARISON_OPERATOR_CODE , QPH.LIST_TYPE_CODE, QPH.ASK_FOR_FLAG, QPLATQ.PRICING_STATUS_CODE, 'OHQ' , NULL LINE_INDEX, NULL PRICING_EFFECTIVE_DATE, QPH.START_DATE_ACTIVE_FIRST START_DATE_ACTI VE_FIRST, QPH.END_DATE_ACTIVE_FIRST END_DATE_ACTIVE_FIRST, NULL LINE_TYPE_CODE, :B9 PRICING_PHASE_ID, QPQ.LIST_HEADER_ID || '-' || QPQ.LIST_LINE_ID || '-' || QPQ.QUALIFIER_GROUPING_NO UNIQUE_KEY, QPH.START_DATE_ACTIVE START_DATE_ACTIVE_H, QPH.END_DATE_ACTIVE END_DATE_ACTIVE_H, QPH.START_DATE_ACTIVE_SECOND START_DATE_ACTIVE_SECOND, QPH.END_DATE_ACTIVE_SECOND END_DATE_ACTIVE_SECOND, QPH.ACTIVE_DATE_FIRST_TYPE, QPH.ACTIVE_DATE_SECOND_TYPE, QPH.LIMIT_EXISTS_FLAG FROM QP_NPREQ_LINE_ATTRS_TMP QPLATQ, QP_QUALIFIERS QPQ , QP_LIST_HEADER_PHASES QPLH, QP_LIST_HEADERS_B QPH, QP_PRICE_REQ_SOURCES_V QPRS WHERE QPQ.LIST_HEADER_ID = QPLH.LIST_HEADER_ID AND QPLH.LIST_HEADER_ID = QPH.LIST_HEADER_ID AND ((NVL(:B10 , 'OFF') = 'ON' AND :B11 = QPH.ORIG_ORG_ID) OR (NVL(:B10 , 'OFF') = 'ON' AND NVL(QPH.GLOBAL_FLAG, 'Y') = 'Y') OR NVL(:B10 , 'OFF') = 'OFF' ) AND QPLH.PRICING_PHASE_ID = :B9 AND QPQ.QUALIFIER_CONTEXT = QPLATQ.CONTEXT AND QPQ.QUALIFIER_ATTRIBUTE = QPLATQ.ATTRIBUTE AND QPQ.COMPARISON_OPERATOR_CODE = 'NOT =' AND QPQ.QUALIFIER_ATTR_VALUE <> QPLATQ.VALUE_FROM AND QPQ.SEARCH_IND = 1 AND QPQ.LIST_LINE_ID = -1 AND ((QPH.CURRENCY_CODE IS NOT NULL AND QPH.CURRENCY_CODE = :B8 ) OR QPH.CURRENCY_CODE IS NULL) AND ((QPH.ASK_FOR_FLAG = :B4 AND QPH.LIST_HEADER_ID IN (SELECT LIST_HEADER_ID FROM QP_NPREQ_LINE_ATTRS_TMP WHERE ATTRIBUTE_TYPE = 'QUALIFIER' AND PRICING_STATUS_CODE = :B3 AND VALIDATED_FLAG = :B7 AND LIST_HEADER_ID IS NOT NULL)) OR QPH.ASK_FOR_FLAG = :B7 ) AND ((:B6 B ETWEEN NVL(QPH.START_DATE_ACTIVE , :B6 ) AND NVL(QPH.END_DATE_ACTIVE, :B6 ) OR :B5 BETWEEN NVL(QPH.START_DATE_ACTIVE , :B5 ) AND NVL(QPH.END_DATE_ACTIVE, :B5 ))) AND ((:B6 BETWEEN NVL(QPQ.START_DATE_ACTIVE , :B6 ) AND NVL(QPQ.END_DATE_ACTIVE, :B6 ) OR :B5 BETWEEN NVL(QPQ.START_DATE_ACTIVE , :B5 ) AND NVL(QPQ.END_DATE_ACTIVE, :B5 ))) AND QPH.LIST_TYPE_CODE NOT IN ('PRL', 'AGR') AND QPQ.LIST_TYPE_CODE NOT IN ('PRL', 'AGR') AND QPH.ACTIVE_FLAG = :B4 AND QPQ.ACTIVE_FLAG = :B4 AND QPLATQ.DISTINCT_QUALIFIER_FLAG = :B4 AND QPQ.LIST_HEADER_ID = QPH.LIST_HEADER_ID AND QPLATQ.PRICING_STATUS_CODE = :B3 AND QPLATQ.ATTRIBUTE_TYPE = :B2 AND QPRS.REQUEST_TYPE_CODE = :B1 AND QPH.SOURCE_SYSTEM_CODE = QPRS.SOURCE_SYSTEM_CODE
1nj7kuvxgpwah	begin ARP_TAX . SET_DEFAULT_TAX_CODE ( :setSql , :updSql ) ; END ;
25wzrzwd46a44	SELECT 1 FROM DUAL WHERE EXISTS ( SELECT 1 FROM FND_GRANTS G, WF_USER_ROLES R WHERE G.GRANTEE_KEY = R.ROLE_NAME AND R.USER_NAME IN (SELECT INCRNS.NAME FROM WF_LOCAL_ROLES SRC , WF_LOCAL_ROLES INCRNS WHERE SRC.NAME = :B4 AND SRC.PARENT_ORIG_SYSTEM = INCRNS.PARENT_ORIG_SYSTEM AND SRC.PARENT_ORIG_SYSTEM_ID = INCRNS.PARENT_ORIG_SYSTEM_ID) AND G.OBJECT_ID = :B3 AND ((:B2 = -1) OR (G.MENU_ID IN (SELECT CMF.MENU_ID FROM FND_COMPILED_MENU_FUNCTIONS CMF WHERE CMF.FUNCTION_ID = :B2 ))) AND ( G.CTX_SECGRP_ID = -1 OR G.CTX_SECGRP_ID = SYS_CONTEXT('FND', 'SECURITY_GROUP_ID')) AND ( G.CTX_RESP_ID = -1 OR G.CTX_RESP_ID = SYS_CONTEXT('FND', 'RESP_ID')) AND ( G.CTX_RESP_APPL_ID = -1 OR G.CTX_RESP_APPL_ID = SYS_CONTEXT('FND', 'RESP_APPL_ID')) AND ( G.CTX_ORG_ID = -1 OR G.CTX_ORG_ID = SYS_CONTEXT('FND', 'ORG_ID')) AND G.START_DATE <= SYSDATE AND ( G.END_DATE IS NULL OR G.END_DATE >= SYSDATE ) AND G.INSTANCE_TYPE = :B1 )
2rg930brttdn3	INSERT INTO WF_NOTIFICATION_ATTRIBUTES ( NOTIFICATION_ID, NAME, TEXT_VALUE, NUMBER_VALUE, DATE_VALUE, EVENT_VALUE ) VALUES ( :B6 , :B5 , :B4 , :B3 , :B2 , :B1 )
37f1qguwxw0sk	begin IF ( :v_msg_level:i_msg_level > 0 ) THEN arp_util . enable_debug ( 1000000 ) ; arp_global . msg_level := :v_msg_level:i_msg_level ; END IF ; arp_auto_accounting . g_error_buffer := NULL ; :v_num_failed_dist_rows:i_num_failed_dist_rows := 0 ; :v_coa_id:i_coa_id := arp_standard . gl_chart_of_accounts_id ; :v_retval:i_retval := 1 ; arp_auto_accounting . do_autoaccounting ( :v_mode:i_vmode , :v_account_class , :v_trx_id:i_trx_id , :v_line_id:i_line_id , :v_line_salesrep_id:i_line_salesrep_id , :v_request_id:i_request_id , :v_gl_date , :v_orig_gl_date , :v_total_trx_amount:i_total_trx_amount , :v_passed_ccid:i_passed_ccid , :v_force_acct_set_no , :v_cust_trx_type_id:i_cust_trx_type_id , :v_primary_salesrep_id:i_primary_salesrep_id , :v_inv_item_id:i_inv_item_id , :v_memo_line_id:i_memo_line_id , :v_ccid:i_ccid , :v_concat_segments:i_concat_segments , :v_num_failed_dist_rows:i_num_failed_dist_rows ) ; IF ( :v_mode:i_vmode = 'G' AND :v_ccid:i_ccid = -1 ) THEN :v_retval:i_retval := 0 ; END IF ; EXCEPTION WHEN arp_auto_accounting . no_ccid THEN :v_retval:i_retval := 0 ; WHEN NO_DATA_FOUND THEN NULL ; WHEN OTHERS THEN arp_util . debug ( 'arcdaa()' ) ; arp_util . debug ( SQLERRM ) ; :v_errorbuf:i_errorbuf := arp_auto_accounting . g_error_buffer ; :v_sqlcode:i_sqlcode := SQLCODE ; END ;
3b3psftuyks81	BEGIN INV_TXNSTUB_PUB.postTransaction(:1, :2, :3); END;
3cb7xm8ykx1qh	begin :1 := POR_UTIL_PKG.submitreq(:2, :3, :4, :5, :6); end;
3dssuqfjsynrk	SELECT count(1) FROM (SELECT * FROM ( SELECT LeadEO.sales_lead_id as SalesLeadId , to_char(hz_timezone_pub.convert_datetime(:1, hcp.timezone_id, SYSDATE), 'HH:MI AM ') ||' '||ht.standard_time_short_code as PrimaryContactLocalTime , SUBSTRB(LeadEO.description, 1, 240) as Description , hp.party_name as ContactName , custParty.party_name as CustomerName , aslt.meaning as RankName , ast.meaning as LeadStatus , ROUND(SYSDATE - LeadEO.creation_date) as Age , DECODE(LeadEO.status_code, 'CONVERTED_TO_OPPORTUNITY', 'ASNCnvToOpptyDsbld', 'ASNCnvToOpptyEnbld') as ASNLeadLstCnvToOppty , LeadEO.customer_id , hp.party_id , LeadEO.primary_contact_party_id , hr.relationship_id FROM as_sales_leads LeadEO , ( SELECT /*+ no_merge */ distinct aaa.sales_lead_id, aaa.customer_id FROM as_accesses_all aaa WHERE aaa.sales_lead_id IS NOT NULL AND aaa.lead_id IS NULL AND aaa.salesforce_id = :2) secu , as_statuses_tl ast , as_sales_lead_ranks_tl aslt , hz_parties CustParty , hz_parties hp, hz_relationships hr , hz_contact_points hcp , hz_timezones ht , ams_source_codes amsc WHERE LeadEO.sales_lead_id = secu.sales_lead_id AND LeadEO.customer_id = secu.customer_id AND LeadEO.status_code = ast.status_code AND ast.language = USERENV('LANG') AND LeadEO.lead_rank_id = aslt.rank_id (+) AND aslt.language (+) = USERENV('LANG') AND LeadEO.customer_id = CustParty.party_id AND LeadEO.primary_contact_party_id = hr.party_id(+) AND hr.subject_ id = hp.party_id (+) AND hr.subject_table_name (+) = 'HZ_PARTIES' AND hr.object_id(+) = LeadEO.customer_id AND hr.object_table_name (+) = 'HZ_PARTIES' AND LeadEO.primary_contact_party_id = hcp.owner_table_id(+) AND hcp.owner_table_name (+) = 'HZ_PARTIES' AND hcp.primary_flag (+) = 'Y' AND hcp.contact_point_type (+) = 'PHONE' AND hcp.timezone_id = ht.timezone_id (+) AND LeadEO.source_promotion_id = amsc.source_code_id AND amsc.source_code_for_id = :3 AND LeadEO.status_code = :4 ORDER BY age ) )
3prk3vg9u0abb	BEGIN FND_GLOBAL.APPS_INITIALIZE( user_id=>:1 , resp_id=>:2 , resp_appl_id=>:3 , security_group_id=>:4 , server_id=>:5);END;
4099q0gjjdwah	select /*+ parallel(t, 8) parallel_index(t, 8) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*), count("LAST_UPDATED_BY"), count(distinct "LAST_UPDATED_BY"), sum(sys_op_opnsize("LAST_UPDATED_BY")), substrb(dump(min("LAST_UPDATED_BY"), 16, 0, 32), 1, 120), substrb(dump(max("LAST_UPDATED_BY"), 16, 0, 32), 1, 120), count("LAST_UPDATE_DATE"), count(distinct "LAST_UPDATE_DATE"), substrb(dump(min("LAST_UPDATE_DATE"), 16, 0, 32), 1, 120), substrb(dump(max("LAST_UPDATE_DATE"), 16, 0, 32), 1, 120), count("LAST_UPDATE_LOGIN"), count(distinct "LAST_UPDATE_LOGIN"), sum(sys_op_opnsize("LAST_UPDATE_LOGIN")), substrb(dump(min("LAST_UPDATE_LOGIN"), 16, 0, 32), 1, 120), substrb(dump(max("LAST_UPDATE_LOGIN"), 16, 0, 32), 1, 120), count("LOCATION_SEGMENT_ID"), count(distinct "LOCATION_SEGMENT_ID"), sum(sys_op_opnsize("LOCATION_SEGMENT_ID")), substrb(dump(min("LOCATION_SEGMENT_ID"), 16, 0, 32), 1, 120), substrb(dump(max("LOCATION_SEGMENT_ID"), 16, 0, 32), 1, 120), count("MOVEMENT_ID"), count(distinct "MOVEMENT_ID"), sum(sys_op_opnsize("MOVEMENT_ID")), substrb(dump(min("MOVEMENT_ID"), 16, 0, 32), 1, 120), substrb(dump(max("MOVEMENT_ID"), 16, 0, 32), 1, 120), count("ORG_ID"), count(distinct "ORG_ID"), sum(sys_op_opnsize("ORG_ID")), substrb(dump(min("ORG_ID"), 16, 0, 32), 1, 120), substrb(dump(max("ORG_ID"), 16, 0, 32), 1, 120), count("AMOUNT_INCLUDES_TAX_FLAG"), count(distinct "AMOUNT_INCLUDES_TAX_FLAG"), sum(sys_op_opnsize("AMOUNT_INCLUDES_TAX_FLAG" )), substrb(dump(min("AMOUNT_INCLUDES_TAX_FLAG"), 16, 0, 32), 1, 120), substrb(dump(max("AMOUNT_INCLUDES_TAX_FLAG"), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTR_CATEGORY"), count(distinct "HEADER_GDF_ATTR_CATEGORY"), sum(sys_op_opnsize("HEADER_GDF_ATTR_CATEGORY")), substrb(dump(min("HEADER_GDF_ATTR_CATEGORY"), 16, 0, 32), 1, 120), substrb(dump(max("HEADER_GDF_ATTR_CATEGORY"), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE1"), count(distinct "HEADER_GDF_ATTRIBUTE1"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE1")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE1", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE1", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE2"), count(distinct "HEADER_GDF_ATTRIBUTE2"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE2")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE2", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE2", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE3"), count(distinct "HEADER_GDF_ATTRIBUTE3"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE3")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE3", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE3", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE4"), count(distinct "HEADER_GDF_ATTRIBUTE4"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE4")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE4", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE4", 1, 32)), 16, 0 , 32), 1, 120), count("HEADER_GDF_ATTRIBUTE5"), count(distinct "HEADER_GDF_ATTRIBUTE5"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE5")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE5", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE5", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE6"), count(distinct "HEADER_GDF_ATTRIBUTE6"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE6")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE7"), count(distinct "HEADER_GDF_ATTRIBUTE7"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE7")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE7", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE7", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE8"), count(distinct "HEADER_GDF_ATTRIBUTE8"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE8")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE8", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE8", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE9"), count(distinct "HEADER_GDF_ATTRIBUTE9"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE9")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE9", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE9", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE10"), count(distinct "HEADER_GDF_ATTRIBUTE10"), sum(sys_op_opn size("HEADER_GDF_ATTRIBUTE10")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE10", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE10", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE11"), count(distinct "HEADER_GDF_ATTRIBUTE11"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE11")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE11", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE11", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE12"), count(distinct "HEADER_GDF_ATTRIBUTE12"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE12")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE12", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE12", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE13"), count(distinct "HEADER_GDF_ATTRIBUTE13"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE13")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE13", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE13", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE14"), count(distinct "HEADER_GDF_ATTRIBUTE14"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE14")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE14", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE14", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE15"), count(distinct "HEADER_GDF_ATTRIBUTE15"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE15")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE1 5", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE15", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE16"), count(distinct "HEADER_GDF_ATTRIBUTE16"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE16")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE16", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE16", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE17"), count(distinct "HEADER_GDF_ATTRIBUTE17"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE17")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE17", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE17", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE18"), count(distinct "HEADER_GDF_ATTRIBUTE18"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE18")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE18", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE18", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE19"), count(distinct "HEADER_GDF_ATTRIBUTE19"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE19")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE19", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE19", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE20"), count(distinct "HEADER_GDF_ATTRIBUTE20"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE20")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE20", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE 20", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE21"), count(distinct "HEADER_GDF_ATTRIBUTE21"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE21")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE21", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE21", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE22"), count(distinct "HEADER_GDF_ATTRIBUTE22"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE22")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE22", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE22", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE23"), count(distinct "HEADER_GDF_ATTRIBUTE23"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE23")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE23", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE23", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE24"), count(distinct "HEADER_GDF_ATTRIBUTE24"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE24")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE24", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE24", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE25"), count(distinct "HEADER_GDF_ATTRIBUTE25"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE25")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE25", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE25", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE26"), count(distin ct "HEADER_GDF_ATTRIBUTE26"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE26")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE26", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE26", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE27"), count(distinct "HEADER_GDF_ATTRIBUTE27"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE27")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE27", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE27", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE28"), count(distinct "HEADER_GDF_ATTRIBUTE28"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE28")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE28", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE28", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE29"), count(distinct "HEADER_GDF_ATTRIBUTE29"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE29")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE29", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE29", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE30"), count(distinct "HEADER_GDF_ATTRIBUTE30"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE30")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE30", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE30", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTR_CATEGORY"), count(distinct "LINE_GDF_ATTR_CATEGORY"), sum(sys_op_opnsize("LINE_GDF_ATTR_CATEGORY")), sub strb(dump(min("LINE_GDF_ATTR_CATEGORY"), 16, 0, 32), 1, 120), substrb(dump(max("LINE_GDF_ATTR_CATEGORY"), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE1"), count(distinct "LINE_GDF_ATTRIBUTE1"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE1")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE1", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE1", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE2"), count(distinct "LINE_GDF_ATTRIBUTE2"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE2")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE2", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE2", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE3"), count(distinct "LINE_GDF_ATTRIBUTE3"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE3")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE3", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE3", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE4"), count(distinct "LINE_GDF_ATTRIBUTE4"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE4")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE4", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE4", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE5"), count(distinct "LINE_GDF_ATTRIBUTE5"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE5")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE5", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE5", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE6") , count(distinct "LINE_GDF_ATTRIBUTE6"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE6")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE7"), count(distinct "LINE_GDF_ATTRIBUTE7"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE7")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE7", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE7", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE8"), count(distinct "LINE_GDF_ATTRIBUTE8"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE8")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE8", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE8", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE9"), count(distinct "LINE_GDF_ATTRIBUTE9"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE9")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE9", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE9", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE10"), count(distinct "LINE_GDF_ATTRIBUTE10"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE10")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE10", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE10", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE11"), count(distinct "LINE_GDF_ATTRIBUTE11"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE11")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE11", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE11", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE12"), count(distinct "LINE_GDF_ATTRIBUTE12"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE12")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE12", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE12", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE13"), count(distinct "LINE_GDF_ATTRIBUTE13"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE13")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE13", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE13", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE14"), count(distinct "LINE_GDF_ATTRIBUTE14"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE14")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE14", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE14", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE15"), count(distinct "LINE_GDF_ATTRIBUTE15"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE15")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE15", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE15", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE16"), count(distinct "LINE_GDF_ATTRIBUTE16"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE16")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE16", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE16", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE17"), cou nt(distinct "LINE_GDF_ATTRIBUTE17"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE17")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE17", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE17", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE18"), count(distinct "LINE_GDF_ATTRIBUTE18"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE18")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE18", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE18", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE19"), count(distinct "LINE_GDF_ATTRIBUTE19"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE19")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE19", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE19", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE20"), count(distinct "LINE_GDF_ATTRIBUTE20"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE20")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE20", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE20", 1, 32)), 16, 0, 32), 1, 120), count("RESET_TRX_DATE_FLAG"), count(distinct "RESET_TRX_DATE_FLAG"), sum(sys_op_opnsize("RESET_TRX_DATE_FLAG")), substrb(dump(min("RESET_TRX_DATE_FLAG"), 16, 0, 32), 1, 120), substrb(dump(max("RESET_TRX_DATE_FLAG"), 16, 0, 32), 1, 120), count("PAYMENT_SERVER_ORDER_NUM"), count(distinct "PAYMENT_SERVER_ORDER_NUM"), sum(sys_op_opnsize("PAYMENT_SERVER_ORDER_NUM")), substrb(dump(min(substrb("PAYMENT_SERVER_ORDER_NUM", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("PAYMENT_SERVER_ORDER_NUM", 1, 32)), 16, 0, 32), 1, 120), count("APPROVAL_CODE"), count(distinct "APPROVAL_CODE"), sum(sys_op_opnsize("APPROVAL_CODE")), substrb(dump(min(substrb("APPROVAL_CODE", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("APPROVAL_CODE", 1, 32)), 16, 0, 32), 1, 120), count("ADDRESS_VERIFICATION_CODE"), count(distinct "ADDRESS_VERIFICATION_CODE"), sum(sys_op_opnsize("ADDRESS_VERIFICATION_CODE")), substrb(dump(min(substrb("ADDRESS_VERIFICATION_CODE", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ADDRESS_VERIFICATION_CODE", 1, 32)), 16, 0, 32), 1, 120), count("WAREHOUSE_ID"), count(distinct "WAREHOUSE_ID"), sum(sys_op_opnsize("WAREHOUSE_ID")), substrb(dump(min("WAREHOUSE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("WAREHOUSE_ID"), 16, 0, 32), 1, 120), count("TRANSLATED_DESCRIPTION"), count(distinct "TRANSLATED_DESCRIPTION"), sum(sys_op_opnsize("TRANSLATED_DESCRIPTION")), substrb(dump(min(substrb("TRANSLATED_DESCRIPTION", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("TRANSLATED_DESCRIPTION", 1, 32)), 16, 0, 32), 1, 120), count("CONS_BILLING_NUMBER"), count(distinct "CONS_BILLING_NUMBER"), sum(sys_op_opnsize("CONS_BILLING_NUMBER")), substrb(dump(min("CONS_BILLING_NUMBER"), 16, 0, 32), 1, 120), substrb(dump(max("CONS_BILLING_NUMBER"), 16, 0, 32), 1, 120), count("PROMISED_COMMITMENT_AMOUNT"), count(distinct "PROMISED_COMMITMENT_AMOUNT"), sum(sys_op_opnsize("PROMISED_COMMITMENT_AMOUNT")), substrb(dump (min("PROMISED_COMMITMENT_AMOUNT"), 16, 0, 32), 1, 120), substrb(dump(max("PROMISED_COMMITMENT_AMOUNT"), 16, 0, 32), 1, 120), count("PAYMENT_SET_ID"), count(distinct "PAYMENT_SET_ID"), sum(sys_op_opnsize("PAYMENT_SET_ID")), substrb(dump(min("PAYMENT_SET_ID"), 16, 0, 32), 1, 120), substrb(dump(max("PAYMENT_SET_ID"), 16, 0, 32), 1, 120), count("ORIGINAL_GL_DATE"), count(distinct "ORIGINAL_GL_DATE"), substrb(dump(min("ORIGINAL_GL_DATE"), 16, 0, 32), 1, 120), substrb(dump(max("ORIGINAL_GL_DATE"), 16, 0, 32), 1, 120), count("CONTRACT_LINE_ID"), count(distinct "CONTRACT_LINE_ID"), sum(sys_op_opnsize("CONTRACT_LINE_ID")), substrb(dump(min("CONTRACT_LINE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("CONTRACT_LINE_ID"), 16, 0, 32), 1, 120), count("CONTRACT_ID"), count(distinct "CONTRACT_ID"), sum(sys_op_opnsize("CONTRACT_ID")), substrb(dump(min("CONTRACT_ID"), 16, 0, 32), 1, 120), substrb(dump(max("CONTRACT_ID"), 16, 0, 32), 1, 120), count("SOURCE_DATA_KEY1"), count(distinct "SOURCE_DATA_KEY1"), sum(sys_op_opnsize("SOURCE_DATA_KEY1")), substrb(dump(min(substrb("SOURCE_DATA_KEY1", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("SOURCE_DATA_KEY1", 1, 32)), 16, 0, 32), 1, 120), count("SOURCE_DATA_KEY2"), count(distinct "SOURCE_DATA_KEY2"), sum(sys_op_opnsize("SOURCE_DATA_KEY2")), substrb(dump(min(substrb("SOURCE_DATA_KEY2", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("SOURCE_DATA_KEY2", 1, 32)), 16, 0, 32), 1, 120), count("SOURCE_DATA_KEY3"), count(distinct "SOURCE_DATA _KEY3"), sum(sys_op_opnsize("SOURCE_DATA_KEY3")), substrb(dump(min(substrb("SOURCE_DATA_KEY3", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("SOURCE_DATA_KEY3", 1, 32)), 16, 0, 32), 1, 120), count("SOURCE_DATA_KEY4"), count(distinct "SOURCE_DATA_KEY4"), sum(sys_op_opnsize("SOURCE_DATA_KEY4")), substrb(dump(min(substrb("SOURCE_DATA_KEY4", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("SOURCE_DATA_KEY4", 1, 32)), 16, 0, 32), 1, 120), count("SOURCE_DATA_KEY5"), count(distinct "SOURCE_DATA_KEY5"), sum(sys_op_opnsize("SOURCE_DATA_KEY5")), substrb(dump(min(substrb("SOURCE_DATA_KEY5", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("SOURCE_DATA_KEY5", 1, 32)), 16, 0, 32), 1, 120), count("INVOICED_LINE_ACCTG_LEVEL"), count(distinct "INVOICED_LINE_ACCTG_LEVEL"), sum(sys_op_opnsize("INVOICED_LINE_ACCTG_LEVEL")), substrb(dump(min("INVOICED_LINE_ACCTG_LEVEL"), 16, 0, 32), 1, 120), substrb(dump(max("INVOICED_LINE_ACCTG_LEVEL"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE4"), count(distinct "REFERENCE_LINE_ATTRIBUTE4"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE4")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE4"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE4"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE5"), count(distinct "REFERENCE_LINE_ATTRIBUTE5"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE5")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE5"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE5"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE6"), count(distinct "REFERENCE_LINE_ATTRIBUTE6"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE6")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE6"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE6"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE7"), count(distinct "REFERENCE_LINE_ATTRIBUTE7"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE7")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE7"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE7"), 16, 0, 32), 1, 120), count("TERRITORY_ID"), count(distinct "TERRITORY_ID"), sum(sys_op_opnsize("TERRITORY_ID")), substrb(dump(min("TERRITORY_ID"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_ID"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT1"), count(distinct "TERRITORY_SEGMENT1"), sum(sys_op_opnsize("TERRITORY_SEGMENT1")), substrb(dump(min("TERRITORY_SEGMENT1"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT1"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT2"), count(distinct "TERRITORY_SEGMENT2"), sum(sys_op_opnsize("TERRITORY_SEGMENT2")), substrb(dump(min("TERRITORY_SEGMENT2"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT2"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT3"), count(distinct "TERRITORY_SEGMENT3"), sum(sys_op_opnsize("TERRITORY_SEGMENT3")), substrb(dump(min("TERRITORY_SEGMENT3"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT3"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT4"), count(distinct "TERRITORY_SEGM ENT4"), sum(sys_op_opnsize("TERRITORY_SEGMENT4")), substrb(dump(min("TERRITORY_SEGMENT4"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT4"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT5"), count(distinct "TERRITORY_SEGMENT5"), sum(sys_op_opnsize("TERRITORY_SEGMENT5")), substrb(dump(min("TERRITORY_SEGMENT5"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT5"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT6"), count(distinct "TERRITORY_SEGMENT6"), sum(sys_op_opnsize("TERRITORY_SEGMENT6")), substrb(dump(min("TERRITORY_SEGMENT6"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT6"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT7"), count(distinct "TERRITORY_SEGMENT7"), sum(sys_op_opnsize("TERRITORY_SEGMENT7")), substrb(dump(min("TERRITORY_SEGMENT7"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT7"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT8"), count(distinct "TERRITORY_SEGMENT8"), sum(sys_op_opnsize("TERRITORY_SEGMENT8")), substrb(dump(min("TERRITORY_SEGMENT8"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT8"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT9"), count(distinct "TERRITORY_SEGMENT9"), sum(sys_op_opnsize("TERRITORY_SEGMENT9")), substrb(dump(min("TERRITORY_SEGMENT9"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT9"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT10"), count(distinct "TERRITORY_SEGMENT10"), sum(sys_op_opnsize("TERRITORY_SEGMENT10")), substrb(dump(min("TERRITORY_SEGMENT10"), 16, 0, 32), 1 , 120), substrb(dump(max("TERRITORY_SEGMENT10"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT11"), count(distinct "TERRITORY_SEGMENT11"), sum(sys_op_opnsize("TERRITORY_SEGMENT11")), substrb(dump(min("TERRITORY_SEGMENT11"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT11"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT12"), count(distinct "TERRITORY_SEGMENT12"), sum(sys_op_opnsize("TERRITORY_SEGMENT12")), substrb(dump(min("TERRITORY_SEGMENT12"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT12"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT13"), count(distinct "TERRITORY_SEGMENT13"), sum(sys_op_opnsize("TERRITORY_SEGMENT13")), substrb(dump(min("TERRITORY_SEGMENT13"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT13"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT14"), count(distinct "TERRITORY_SEGMENT14"), sum(sys_op_opnsize("TERRITORY_SEGMENT14")), substrb(dump(min("TERRITORY_SEGMENT14"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT14"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT15"), count(distinct "TERRITORY_SEGMENT15"), sum(sys_op_opnsize("TERRITORY_SEGMENT15")), substrb(dump(min("TERRITORY_SEGMENT15"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT15"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT16"), count(distinct "TERRITORY_SEGMENT16"), sum(sys_op_opnsize("TERRITORY_SEGMENT16")), substrb(dump(min("TERRITORY_SEGMENT16"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT16"), 16, 0, 32), 1, 120), count("T ERRITORY_SEGMENT17"), count(distinct "TERRITORY_SEGMENT17"), sum(sys_op_opnsize("TERRITORY_SEGMENT17")), substrb(dump(min("TERRITORY_SEGMENT17"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT17"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT18"), count(distinct "TERRITORY_SEGMENT18"), sum(sys_op_opnsize("TERRITORY_SEGMENT18")), substrb(dump(min("TERRITORY_SEGMENT18"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT18"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT19"), count(distinct "TERRITORY_SEGMENT19"), sum(sys_op_opnsize("TERRITORY_SEGMENT19")), substrb(dump(min("TERRITORY_SEGMENT19"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT19"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT20"), count(distinct "TERRITORY_SEGMENT20"), sum(sys_op_opnsize("TERRITORY_SEGMENT20")), substrb(dump(min("TERRITORY_SEGMENT20"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT20"), 16, 0, 32), 1, 120), count("ATTRIBUTE_CATEGORY"), count(distinct "ATTRIBUTE_CATEGORY"), sum(sys_op_opnsize("ATTRIBUTE_CATEGORY")), substrb(dump(min("ATTRIBUTE_CATEGORY"), 16, 0, 32), 1, 120), substrb(dump(max("ATTRIBUTE_CATEGORY"), 16, 0, 32), 1, 120), count("ATTRIBUTE1"), count(distinct "ATTRIBUTE1"), sum(sys_op_opnsize("ATTRIBUTE1")), substrb(dump(min(substrb("ATTRIBUTE1", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE1", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE2"), count(distinct "ATTRIBUTE2"), sum(sys_op_opnsize("ATTRIBUTE2")), substrb(dump(min(s ubstrb("ATTRIBUTE2", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE2", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE3"), count(distinct "ATTRIBUTE3"), sum(sys_op_opnsize("ATTRIBUTE3")), substrb(dump(min(substrb("ATTRIBUTE3", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE3", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE4"), count(distinct "ATTRIBUTE4"), sum(sys_op_opnsize("ATTRIBUTE4")), substrb(dump(min(substrb("ATTRIBUTE4", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE4", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE5"), count(distinct "ATTRIBUTE5"), sum(sys_op_opnsize("ATTRIBUTE5")), substrb(dump(min(substrb("ATTRIBUTE5", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE5", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE6"), count(distinct "ATTRIBUTE6"), sum(sys_op_opnsize("ATTRIBUTE6")), substrb(dump(min(substrb("ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE7"), count(distinct "ATTRIBUTE7"), sum(sys_op_opnsize("ATTRIBUTE7")), substrb(dump(min(substrb("ATTRIBUTE7", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE7", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE8"), count(distinct "ATTRIBUTE8"), sum(sys_op_opnsize("ATTRIBUTE8")), substrb(dump(min(substrb("ATTRIBUTE8", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE8", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE9"), count(distinct "ATTRIBUTE9"), sum(sys_op_opnsize("ATTRIBUTE9")), substrb(dump(min(substrb("ATTRIBUTE9", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE9", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE10"), count(distinct "ATTRIBUTE10"), sum(sys_op_opnsize("ATTRIBUTE10")), substrb(dump(min(substrb("ATTRIBUTE10", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE10", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE11"), count(distinct "ATTRIBUTE11"), sum(sys_op_opnsize("ATTRIBUTE11")), substrb(dump(min(substrb("ATTRIBUTE11", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE11", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE12"), count(distinct "ATTRIBUTE12"), sum(sys_op_opnsize("ATTRIBUTE12")), substrb(dump(min(substrb("ATTRIBUTE12", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE12", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE13"), count(distinct "ATTRIBUTE13"), sum(sys_op_opnsize("ATTRIBUTE13")), substrb(dump(min(substrb("ATTRIBUTE13", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE13", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE14"), count(distinct "ATTRIBUTE14"), sum(sys_op_opnsize("ATTRIBUTE14")), substrb(dump(min(substrb("ATTRIBUTE14", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE14", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE15"), count(distinct "ATTRIBUTE15"), sum(sys_op_opnsize("ATTRIBUTE15")), substrb(dump(min(substrb("ATTRIBUTE15", 1, 32)), 16, 0, 32), 1, 120), substrb( dump(max(substrb("ATTRIBUTE15", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE_CATEGORY"), count(distinct "HEADER_ATTRIBUTE_CATEGORY"), sum(sys_op_opnsize("HEADER_ATTRIBUTE_CATEGORY")), substrb(dump(min("HEADER_ATTRIBUTE_CATEGORY"), 16, 0, 32), 1, 120), substrb(dump(max("HEADER_ATTRIBUTE_CATEGORY"), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE1"), count(distinct "HEADER_ATTRIBUTE1"), sum(sys_op_opnsize("HEADER_ATTRIBUTE1")), substrb(dump(min(substrb("HEADER_ATTRIBUTE1", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE1", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE2"), count(distinct "HEADER_ATTRIBUTE2"), sum(sys_op_opnsize("HEADER_ATTRIBUTE2")), substrb(dump(min(substrb("HEADER_ATTRIBUTE2", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE2", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE3"), count(distinct "HEADER_ATTRIBUTE3"), sum(sys_op_opnsize("HEADER_ATTRIBUTE3")), substrb(dump(min(substrb("HEADER_ATTRIBUTE3", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE3", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE4"), count(distinct "HEADER_ATTRIBUTE4"), sum(sys_op_opnsize("HEADER_ATTRIBUTE4")), substrb(dump(min(substrb("HEADER_ATTRIBUTE4", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE4", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE5"), count(distinct "HEADER_ATTRIBUTE5"), sum(sys_op_opnsize("HEADER_ATTRIBUTE5")), substrb(dump(min(substrb("HE ADER_ATTRIBUTE5", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE5", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE6"), count(distinct "HEADER_ATTRIBUTE6"), sum(sys_op_opnsize("HEADER_ATTRIBUTE6")), substrb(dump(min(substrb("HEADER_ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE7"), count(distinct "HEADER_ATTRIBUTE7"), sum(sys_op_opnsize("HEADER_ATTRIBUTE7")), substrb(dump(min(substrb("HEADER_ATTRIBUTE7", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE7", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE8"), count(distinct "HEADER_ATTRIBUTE8"), sum(sys_op_opnsize("HEADER_ATTRIBUTE8")), substrb(dump(min(substrb("HEADER_ATTRIBUTE8", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE8", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE9"), count(distinct "HEADER_ATTRIBUTE9"), sum(sys_op_opnsize("HEADER_ATTRIBUTE9")), substrb(dump(min(substrb("HEADER_ATTRIBUTE9", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE9", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE10"), count(distinct "HEADER_ATTRIBUTE10"), sum(sys_op_opnsize("HEADER_ATTRIBUTE10")⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀椀渀⠀猀甀戀猀琀爀戀⠀∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㄀　∀Ⰰ㄀Ⰰ㌀㈀⤀⤀Ⰰ㄀㘀Ⰰ　Ⰰ㌀㈀⤀Ⰰ㄀Ⰰ㄀㈀　⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀愀砀⠀猀甀戀猀琀爀戀⠀∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㄀　∀Ⰰ㄀Ⰰ㌀㈀⤀⤀Ⰰ㄀㘀 Ⰰ　Ⰰ㌀㈀⤀Ⰰ㄀Ⰰ㄀㈀　⤀Ⰰ挀漀甀渀琀⠀∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㄀㄀∀⤀Ⰰ挀漀甀渀琀⠀搀椀猀琀椀渀挀琀 ∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㄀㄀∀⤀Ⰰ猀甀洀⠀猀礀猀开漀瀀开漀瀀渀猀椀稀攀⠀∀䠀䔀䄀䐀䔀刀开䄀 吀吀刀䤀䈀唀吀䔀㄀㄀∀⤀⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀椀渀⠀猀甀戀猀琀爀戀⠀∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㄀㄀∀Ⰰ㄀Ⰰ㌀㈀⤀⤀Ⰰ㄀㘀Ⰰ　Ⰰ㌀㈀⤀Ⰰ㄀Ⰰ㄀㈀　⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀愀砀⠀猀甀戀猀琀爀戀⠀∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㄀㄀∀Ⰰ㄀Ⰰ㌀㈀⤀⤀Ⰰ㄀㘀Ⰰ　Ⰰ㌀㈀⤀Ⰰ㄀Ⰰ㄀㈀　⤀Ⰰ挀漀甀渀琀⠀∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㄀㈀∀⤀Ⰰ挀漀甀渀琀⠀搀椀猀琀椀渀挀琀 ∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㄀㈀∀⤀Ⰰ猀甀洀⠀猀礀猀开漀瀀开漀瀀渀猀椀稀攀⠀∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㄀㈀∀⤀⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀椀渀⠀猀甀戀猀琀爀戀⠀∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㄀㈀∀Ⰰ㄀Ⰰ㌀㈀⤀⤀Ⰰ㄀㘀Ⰰ　Ⰰ㌀㈀⤀Ⰰ㄀Ⰰ㄀㈀　⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀愀砀⠀猀甀戀猀琀爀戀⠀∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㄀㈀∀Ⰰ㄀Ⰰ㌀㈀⤀⤀Ⰰ㄀㘀Ⰰ　Ⰰ㌀㈀⤀Ⰰ㄀Ⰰ㄀㈀　⤀Ⰰ挀漀甀渀琀⠀∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㄀㌀∀⤀Ⰰ挀漀甀渀琀⠀搀椀猀琀椀渀挀琀 ∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㄀㌀∀⤀Ⰰ猀甀洀⠀猀礀猀开漀瀀开漀瀀渀猀椀稀攀⠀∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㄀㌀∀⤀⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀椀渀⠀猀甀戀猀琀爀戀⠀∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㄀㌀∀Ⰰ㄀Ⰰ㌀㈀⤀⤀Ⰰ㄀㘀Ⰰ　Ⰰ㌀㈀⤀Ⰰ㄀Ⰰ㄀㈀　⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀愀砀⠀猀甀戀猀琀爀戀⠀∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㄀㌀∀Ⰰ㄀Ⰰ㌀㈀⤀⤀Ⰰ㄀㘀Ⰰ　Ⰰ㌀㈀⤀Ⰰ㄀Ⰰ㄀㈀　⤀Ⰰ挀漀甀渀琀⠀∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㄀㐀∀⤀Ⰰ挀漀甀渀琀⠀搀椀猀琀椀渀挀琀 ∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㄀㐀∀⤀Ⰰ猀甀洀⠀猀礀猀开漀瀀开漀瀀渀猀椀稀攀⠀∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㄀㐀∀⤀⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀椀渀⠀猀甀戀猀琀爀戀⠀∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㄀㐀∀Ⰰ㄀Ⰰ㌀㈀⤀⤀Ⰰ㄀㘀Ⰰ　Ⰰ㌀ ㈀⤀Ⰰ㄀Ⰰ㄀㈀　⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀愀砀⠀猀甀戀猀琀爀戀⠀∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㄀㐀∀Ⰰ㄀Ⰰ㌀㈀⤀⤀Ⰰ㄀㘀Ⰰ　Ⰰ㌀㈀⤀Ⰰ㄀Ⰰ㄀㈀　⤀Ⰰ挀漀甀渀琀⠀∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㄀㔀∀⤀Ⰰ挀漀甀渀琀⠀搀椀猀琀椀渀挀琀 ∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㄀㔀∀⤀Ⰰ猀甀洀⠀猀礀猀开漀瀀开漀瀀渀猀椀稀攀⠀∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㄀㔀∀⤀⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀椀渀⠀猀甀戀猀琀爀戀⠀∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㄀㔀∀Ⰰ㄀Ⰰ㌀㈀⤀⤀Ⰰ㄀㘀Ⰰ　Ⰰ㌀㈀⤀Ⰰ㄀Ⰰ㄀㈀　⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀愀砀⠀猀甀戀猀琀爀戀⠀∀䠀䔀䄀䐀䔀刀开䄀吀吀刀䤀䈀唀吀䔀㄀㔀∀Ⰰ㄀Ⰰ㌀㈀⤀⤀Ⰰ㄀㘀Ⰰ　Ⰰ㌀㈀⤀Ⰰ㄀Ⰰ㄀㈀　⤀Ⰰ挀漀甀渀琀⠀∀䌀伀䴀䴀䔀一吀匀∀⤀Ⰰ挀漀甀渀琀⠀搀椀猀琀椀渀挀琀 ∀䌀伀䴀䴀䔀一吀匀∀⤀Ⰰ猀甀洀⠀猀礀猀开漀瀀开漀瀀渀猀椀稀攀⠀∀䌀伀䴀䴀䔀一吀匀∀⤀⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀椀渀⠀猀甀戀猀琀爀戀⠀∀䌀伀䴀䴀䔀一吀匀∀Ⰰ㄀Ⰰ㌀㈀⤀⤀Ⰰ㄀㘀Ⰰ　Ⰰ㌀㈀⤀Ⰰ㄀Ⰰ㄀㈀　⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀愀砀⠀猀甀戀猀琀爀戀⠀∀䌀伀䴀䴀䔀一吀匀∀Ⰰ㄀Ⰰ㌀㈀⤀⤀Ⰰ㄀㘀Ⰰ　Ⰰ㌀㈀⤀Ⰰ㄀Ⰰ㄀㈀　⤀Ⰰ挀漀甀渀琀⠀∀䤀一吀䔀刀一䄀䰀开一伀吀䔀匀∀⤀Ⰰ挀漀甀渀琀⠀搀椀猀琀椀渀挀琀 ∀䤀一吀䔀刀一䄀䰀开一伀吀䔀匀∀⤀Ⰰ猀甀洀⠀猀礀猀开漀瀀开漀瀀渀猀椀稀攀⠀∀䤀一吀䔀刀一䄀䰀开一伀吀䔀匀∀⤀⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀椀渀⠀猀甀戀猀琀爀戀⠀∀䤀一吀䔀刀一䄀䰀开一伀吀䔀匀∀Ⰰ㄀Ⰰ㌀㈀⤀⤀Ⰰ㄀㘀Ⰰ　Ⰰ㌀㈀⤀Ⰰ㄀Ⰰ㄀㈀　⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀ 洀愀砀⠀猀甀戀猀琀爀戀⠀∀䤀一吀䔀刀一䄀䰀开一伀吀䔀匀∀Ⰰ㄀Ⰰ㌀㈀⤀⤀Ⰰ㄀㘀Ⰰ　Ⰰ㌀㈀⤀Ⰰ㄀Ⰰ㄀㈀　⤀Ⰰ挀漀甀渀琀⠀∀䤀一䤀吀䤀䄀䰀开䌀唀匀吀伀䴀䔀刀开吀刀堀开䤀䐀∀⤀Ⰰ挀漀甀渀琀⠀搀椀猀琀椀渀挀琀 ∀䤀一䤀吀䤀䄀䰀开䌀唀匀吀伀䴀䔀刀开吀刀堀开䤀䐀∀⤀Ⰰ猀甀洀⠀猀礀猀开漀瀀开漀瀀渀猀椀稀攀⠀∀䤀一䤀吀䤀䄀䰀开䌀唀匀吀伀䴀䔀刀开吀刀堀开䤀䐀∀⤀⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀椀渀⠀∀䤀一䤀吀䤀䄀䰀开䌀唀匀吀伀䴀䔀刀开吀刀堀开䤀䐀∀⤀Ⰰ㄀㘀Ⰰ　Ⰰ㌀㈀⤀Ⰰ㄀Ⰰ㄀㈀　⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀愀砀⠀∀䤀一䤀吀䤀䄀䰀开䌀唀匀吀伀䴀䔀刀开吀刀堀开䤀䐀∀⤀Ⰰ㄀㘀Ⰰ　Ⰰ㌀㈀⤀Ⰰ㄀Ⰰ㄀㈀　⤀Ⰰ挀漀甀渀琀⠀∀唀匀匀䜀䰀开吀刀䄀一匀䄀䌀吀䤀伀一开䌀伀䐀䔀开䌀伀一吀䔀堀吀∀⤀Ⰰ挀漀甀渀琀⠀搀椀猀琀椀渀挀琀 ∀唀匀匀䜀䰀开吀刀䄀一匀䄀䌀吀䤀伀一开䌀伀䐀䔀开䌀伀一吀䔀堀吀∀⤀Ⰰ猀甀洀⠀猀礀猀开漀瀀开漀瀀渀猀椀稀攀⠀∀唀匀匀䜀䰀开吀刀䄀一匀䄀䌀吀䤀伀一开䌀伀䐀䔀开䌀伀一吀䔀堀吀∀⤀⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀椀渀⠀∀唀匀匀䜀䰀开吀刀䄀一匀䄀䌀吀䤀伀一开䌀伀䐀䔀开䌀伀一吀䔀堀吀∀⤀Ⰰ㄀㘀Ⰰ　Ⰰ㌀㈀⤀Ⰰ㄀Ⰰ㄀㈀　⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀愀砀⠀USSGL_TRANSACTION_CODE_CONTEXT"), 16, 0, 32), 1, 120), count("USSGL_TRANSACTION_CODE"), count(distinct "USSGL_TRANSACTION_CODE"), sum(sys_op_opnsize("USSGL_TRANSACTION_CODE")), substrb(dump(min("USSGL_TRANSACTION_CODE"), 16, 0, 32), 1, 120), substrb(dump(max("USSGL_TRANSACTION_CODE"), 16, 0, 32), 1, 120), count("ACCTD_AMOUNT"), count(distinct "ACCTD_AMOUNT"), sum(sys_op_opnsize("ACCTD_AMOUNT")), substrb(dump(min("ACCTD_AMOUNT"), 16, 0, 32), 1, 120), substrb(dump(max("ACCTD_AMOUNT"), 16, 0, 32), 1, 120), count("CUSTOME R_BANK_ACCOUNT_ID"), count(distinct "CUSTOMER_BANK_ACCOUNT_ID"), sum(sys_op_opnsize("CUSTOMER_BANK_ACCOUNT_ID")), substrb(dump(min("CUSTOMER_BANK_ACCOUNT_ID"), 16, 0, 32), 1, 120), substrb(dump(max("CUSTOMER_BANK_ACCOUNT_ID"), 16, 0, 32), 1, 120), count("CUSTOMER_BANK_ACCOUNT_NAME"), count(distinct "CUSTOMER_BANK_ACCOUNT_NAME"), sum(sys_op_opnsize("CUSTOMER_BANK_ACCOUNT_NAME")), substrb(dump(min(substrb("CUSTOMER_BANK_ACCOUNT_NAME", 1, 32)), 16, 0, 32) , 1, 120), substrb(dump(max(substrb("CUSTOMER_BANK_ACCOUNT_NAME", 1, 32)), 16, 0, 32), 1, 120), count("UOM_CODE"), count(distinct "UOM_CODE"), sum(sys_op_opnsize("UOM_CODE")), substrb(dump(min("UOM_CODE"), 16, 0, 32), 1, 120), substrb(dump(max("UOM_CODE"), 16, 0, 32), 1, 120), count("UOM_NAME"), count(distinct "UOM_NAME"), sum(sys_op_opnsize("UOM_NAME")), substrb(dump(min("UOM_NAME"), 16, 0, 32), 1, 120), substrb(dump(max("UOM_NAME"), 16, 0, 32), 1, 120), count("DOCUMENT_NUMBER_SEQUENCE_ID"), count(distinct "DOCUMENT_NUMBER_SEQUENCE_ID"), sum(sys_op_opnsize("DOCUMENT_NUMBER_SEQUENCE_ID")), substrb(dump(min("DOCUMENT_NUMBER_SEQUENCE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("DOCUMENT_NUMBER_SEQUENCE_ID"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE10"), count(distinct "LINK_TO_LINE_ATTRIBUTE10"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE10")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE10"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE10"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE11"), count(distinct "LINK_TO_LINE_ATTRIBUTE11"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE11")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE11"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE11"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE12"), count(distinct "LINK_TO_LINE_ATTRIBUTE12"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE12")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE12"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE12") , 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE13"), count(distinct "LINK_TO_LINE_ATTRIBUTE13"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE13")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE13"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE13"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE14"), count(distinct "LINK_TO_LINE_ATTRIBUTE14"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE14")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE14"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE14"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE15"), count(distinct "LINK_TO_LINE_ATTRIBUTE15"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE15")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE15"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE15"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE8"), count(distinct "LINK_TO_LINE_ATTRIBUTE8"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE8")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE8"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE8"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE9"), count(distinct "LINK_TO_LINE_ATTRIBUTE9"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE9")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE9"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE9"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE10"), count(distinct "REFERENCE_LINE_ATTRIBUTE10"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE10")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE1 0"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE10"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE11"), count(distinct "REFERENCE_LINE_ATTRIBUTE11"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE11")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE11"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE11"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE12"), count(distinct "REFERENCE_LINE_ATTRIBUTE12"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE12")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE12"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE12"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE13"), count(distinct "REFERENCE_LINE_ATTRIBUTE13"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE13")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE13"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE13"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE14"), count(distinct "REFERENCE_LINE_ATTRIBUTE14"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE14")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE14"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE14"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE15"), count(distinct "REFERENCE_LINE_ATTRIBUTE15"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE15")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE15"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE15"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE8"), count(dis tinct "REFERENCE_LINE_ATTRIBUTE8"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE8")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE8"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE8"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE9"), count(distinct "REFERENCE_LINE_ATTRIBUTE9"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE9")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE9"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE9"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE10"), count(distinct "INTERFACE_LINE_ATTRIBUTE10"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE10")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE10"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE10"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE11"), count(distinct "INTERFACE_LINE_ATTRIBUTE11"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE11")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE11"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE11"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE12"), count(distinct "INTERFACE_LINE_ATTRIBUTE12"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE12")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE12"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE12"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE13"), count(distinct "INTERFACE_LINE_ATTRIBUTE13"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE13")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE13"), 16, 0, 32), 1 , 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE13"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE14"), count(distinct "INTERFACE_LINE_ATTRIBUTE14"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE14")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE14"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE14"), 16, 0, 32), 1, 120) from "AR"."RA_INTERFACE_LINES_ALL" sample ( 10.0000000000) t
473dq7tb653mp	declare p varchar2(32767); begin p := FND_GENERIC_POLICY.GET_PREDICATE(:sn, :on); :v1 := substr(p, 1, 4000); :v2 := substr(p, 4001, 4000); :v3 := substr(p, 8001, 4000); :v4 := substr(p, 12001, 4000); :v5 := substr(p, 16001, 4000); :v6 := substr(p, 20001, 4000); :v7 := substr(p, 24001, 4000); :v8 := substr(p, 28001, 4000); :v9 := substr(p, 32001, 767); :v10 := substr(p, 4001, 1); :v11 := substr(p, 8001, 1); :v12 := substr(p, 12001, 1); :v13 := substr(p, 16001, 1); :v14 := substr(p, 20001, 1); :v15 := substr(p, 24001, 1); :v16 := substr(p, 28001, 1); :v17 := substr(p, 32001, 1); end;
4yak7x2zqz0dh	BEGIN inv_transfer_order_pvt.finalize_pick_confirm(:1, :2, :3, :4, :5, :6, :7); END;
5kqw5535fjvw6	SELECT NVL(RCTT.ATTRIBUTE10, ' ') FROM RA_CUST_TRX_TYPES_ALL RCTT, RA_CUSTOMER_TRX_ALL RCT WHERE RCT.CUSTOMER_TRX_ID = :B1 AND RCT.CUST_TRX_TYPE_ID = RCTT.CUST_TRX_TYPE_ID
5qyckzm5v1qmj	begin :return_value:i_return_value := arp_rounding . correct_dist_rounding_errors ( :request_id , NULL , NULL , :rows_processed:i_rows_processed , :error_msg:i_error_msg , NULL , NULL , :trx_class , 'N' , :debug_mode , arp_global . sysparam . trx_header_level_rounding , 'N' ) ; END ;
60t2tt1564j0k	SELECT SUBSTRB(MACHINE, 1, 60), PROCESS, PROGRAM FROM V$SESSION WHERE AUDSID = :B1
6gnth2mfbs2nq	declare v_ret number := 0; begin if (INV_TABLE_LOCK_PVT.lock_onhand_records(:1, :2, :3, :4, :5, :6, :7) ) then v_ret := 1; end if; :8 := v_ret; end;
6h2tpcxpymqu7	BEGIN :1 := FND_AOLJ_UTIL.is_Valid_ICX(:2, NULL, 'Y', TRUE, TRUE, NULL, NULL, NULL, NULL, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, TRUE);:19 := fnd_session_management.g_enc_key;:20 := fnd_session_management.g_mac_key;END;
76sw2a4vnc89j	begin FND_FLEX_WORKFLOW_APIS.START_GENERATION (:v1, :v2, :v3, :v4, :v5); end;
7g05xfvc5vp74	BEGIN arp_run.revenue_recognition( :errbuf, :rc, :A0, :A1, :A2); END;
815ygd4pc1bpd	INSERT INTO RA_CUSTOMER_TRX_LINES ( customer_trx_line_id, last_update_date, last_updated_by, creation_date, created_by, last_update_login, customer_trx_id, interface_line_attribute1, interface_line_attribute2, interface_line_attribute3, interface_line_attribute4, interface_line_attribute5, interface_line_attribute6, interface_line_attribute7, interface_line_attribute8, interface_line_attribute9, interface_line_attribute10, interface_line_attribute11, interface_line_attribute12, interface_line_attribute13, interface_line_attribute14, interface_line_attribute15, interface_line_context, line_number, set_of_books_id, reason_code, inventory_item_id, description, translated_description, previous_customer_trx_id, previous_customer_trx_line_id, initial_customer_trx_line_id, quantity_ordered, quantity_credited, quantity_invoiced, unit_standard_price, unit_selling_price, amount_includes_tax_flag, uom_code, sales_order, sales_order_line, sales_order_date, sales_order_source, sales_order_revision, accounting_rule_id, accounting_rule_duration, line_type, rule_start_date, extended_amount, taxable_amount, revenue_amount, link_to_cust_trx_line_id, sales_tax_id, location_segment_id, vat_tax_id, tax_precedence, tax_rate, item_exception_rate_id, tax_exemption_id, memo_line_id, attribute_category, attribute1, attribute2, attribute3, attribute4, attribute5, attribute6, attribute7, attribute8, attribute9, attribute10, attribut e11, attribute12, attribute13, attribute14, attribute15, global_attribute_category, global_attribute1, global_attribute2, global_attribute3, global_attribute4, global_attribute5, global_attribute6, global_attribute7, global_attribute8, global_attribute9, global_attribute10, global_attribute11, global_attribute12, global_attribute13, global_attribute14, global_attribute15, global_attribute16, global_attribute17, global_attribute18, global_attribute19, global_attribute20, request_id, program_application_id, program_id, program_update_date, default_ussgl_transaction_code, autorule_complete_flag, last_period_to_credit, tax_exempt_flag, tax_exempt_reason_code, tax_exempt_number, movement_id, payment_set_id, warehouse_id, contract_line_id, invoiced_line_acctg_level, source_data_key1, source_data_key2, source_data_key3, source_data_key4, source_data_key5) SELECT l.interface_line_id, sysdate, :b1, sysdate, :b2, :b3, l.customer_trx_id, l.interface_line_attribute1, l.interface_line_attribute2, l.interface_line_attribute3, l.interface_line_attribute4, l.interface_line_attribute5, l.interface_line_attribute6, l.interface_line_attribute7, l.interface_line_attribute8, l.interface_line_attribute9, l.interface_line_attribute10, l.interface_line_attribute11, l.interface_line_attribute12, l.interface_line_attribute13, l.interface_line_attribute14, l.interface_line_attribute15, substr(decode(l.interface_line_context, 'Global Dat a Elements', null, l.interface_line_context), 1, 30), l.line_number, l.set_of_books_id, decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type), 'LINE', l.reason_code, null), decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type), 'LINE', l.inventory_item_id, null), decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type), 'LINE', l.description, null), decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type), 'LINE', l.translated_description, null), null, null, decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type), 'LINE', l.reference_line_id, null), decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type), 'LINE', l.quantity_ordered, null), decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type), 'LINE', decode(t.type, 'CM', l.quantity, null), null), decode(l.line_type, 'LINE', decode(t.type, 'CM', null, nvl(l.quantity, 1)), 'CHARGES', 1, null), decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type), 'LINE', l.unit_standard_price, null), decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type), 'LINE', nvl(l.unit_selling_price, decode(t.type, 'CM', decode(l.credit_method_for_acct_rule, 'UNIT', l.amount/l.quantity, null), decode(l.quantity, 0, l.amount, null, l.amount, ROUND(l.amount/l.quantity, 15)))), null), l.amount_includes_tax_flag, decode(l.line_type, 'LINE', l.uom_code, 'CHARGES', null, null), decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type), 'LINE', l.sales_order, null), decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type), 'LINE', ltrim(l.sales_order_line) , null), decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type), 'LINE', l.sales_order_date , null), decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type), 'LINE', l.sales_order_source , null), decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type), 'LINE', l.sales_order_revision , null), decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type), 'LINE', l.accounting_rule_id, null), decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type), 'LINE', decode(l.accounting_rule_id, null, null, decode(r.type, 'A', r.occurrences, l.accounting_rule_duration)), null), l.line_type, decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type), 'LINE', decode(l.accounting_rule_id, null, null, l.rule_start_date), null), decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type), 'LINE', decode(l.quantity * l.unit_selling_pr ice, null, nvl(l.amount, 0), decode(c.minimum_accountable_unit, null, round(l.quantity * l.unit_selling_price, c.precision), round(l.quantity * l.unit_selling_price / c.minimum_accountable_unit)* c.minimum_accountable_unit)), 'TAX', decode(l.amount, null, decode(l.tax_precedence, null, decode(parent.quantity * parent.unit_selling_price, null, decode(c.minimum_accountable_unit, null, round(nvl(parent.amount, 0) * (nvl(l.tax_rate, 0)/100), c.precision), round(nvl(parent.amount, 0) * (nvl(l.tax_rate, 0)/100)/ c.minimum_accountable_unit) * c.minimum_accountable_unit), decode(c.minimum_accountable_unit, null, round(parent.quantity * parent.unit_selling_price * (nvl(l.tax_rate, 0)/100), c.precision), round(parent.quantity * parent.unit_selling_price * (nvl(l.tax_rate, 0)/100)/ c.minimum_accountable_unit) * c.minimum_accountable_unit)), 0), nvl(l.amount, 0)), nvl(l.amount, 0)), decode(l.line_type, 'TAX', decode(l.tax_precedence, null, decode(parent.quantity * parent.unit_selling_price, null, decode(c.minimum_accountable_unit, null, round(nvl(parent.amount, 0), c.precision), round(nvl(parent.amount, 0) / c.minimum_accountable_unit) * c.minimum_accountable_unit), decode(c.minimum_accountable_unit, null, round(parent.quantity * parent.unit_selling_price , c.precision), round(parent.quantity * parent.unit_selling_price / c.minimum_accountable_ unit) * c.minimum_accountable_unit)), 0), null), decode(l.line_type, 'LINE', nvl(l.amount, 0), 'CHARGES', null, null), decode(l.line_type, 'TAX', l.link_to_line_id, 'FREIGHT', l.link_to_line_id, null), decode(l.line_type, 'TAX', l.sales_tax_id, null), decode(l.line_type, 'TAX', l.location_segment_id, null), decode(l.line_type, 'TAX', l.vat_tax_id, 'LINE', l.vat_tax_id, null), decode(l.line_type, 'TAX', l.tax_precedence, null), decode(l.line_type, 'TAX', l.tax_rate, null), decode(l.line_type, 'TAX', l.exception_id, null), decode(l.line_type, 'TAX', l.exemption_id, null), decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type), 'LINE', l.memo_line_id, null), l.attribute_category, rtrim(l.attribute1), rtrim(l.attribute2), rtrim(l.attribute3), rtrim(l.attribute4), rtrim(l.attribute5), rtrim(l.attribute6), rtrim(l.attribute7), rtrim(l.attribute8), rtrim(l.attribute9), rtrim(l.attribute10), rtrim(l.attribute11), rtrim(l.attribute12), rtrim(l.attribute13), rtrim(l.attribute14), rtrim(l.attribute15), l.line_gdf_attr_category, l.line_gdf_attribute1, l.line_gdf_attribute2, l.line_gdf_attribute3, l.line_gdf_attribute4, l.line_gdf_attribute5, l.line_gdf_attribute6, l.line_gdf_attribute7, l.line_gdf_attribute8, l.line_gdf_attribute9, l.line_gdf_attribute10, l.line_gdf_attribute11, l.line_gdf_attribute12, l.line_gdf_attribute1 3, l.line_gdf_attribute14, l.line_gdf_attribute15, l.line_gdf_attribute16, l.line_gdf_attribute17, l.line_gdf_attribute18, l.line_gdf_attribute19, l.line_gdf_attribute20, :b4, :b5, :b6, sysdate, l.ussgl_transaction_code, decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type), 'LINE', decode(l.accounting_rule_id, null, null, 'N'), null), decode(decode(l.line_type, 'CHARGES', 'LINE', l.line_type), 'LINE', decode(l.credit_method_for_acct_rule, 'UNIT', null, null), null), decode(l.line_type, 'LINE', l.tax_exempt_flag, null), decode(l.line_type, 'LINE', decode(l.tax_exempt_flag, 'E', l.tax_exempt_reason_code, null), null), decode(l.line_type, 'LINE', decode(l.tax_exempt_flag, 'E', l.tax_exempt_number, null), null), l.movement_id, l.payment_set_id, l.warehouse_id, l.contract_line_id, l.invoiced_line_acctg_level, l.source_data_key1, l.source_data_key2, l.source_data_key3, l.source_data_key4, l.source_data_key5 FROM FND_CURRENCIES C, RA_CUST_TRX_TYPES t, RA_RULES r, RA_INTERFACE_LINES_GT parent, RA_INTERFACE_LINES_GT l WHERE l.request_id = :b7 AND l.currency_code = c.currency_code AND l.cust_trx_type_id = t.cust_trx_type_id AND l.accounting_rule_id = r.rule_id(+) AND l.customer_trx_id is not null AND l.link_to_line_id = parent.interface_line_id(+) AND nvl(l.interface_status, '~') != 'P'
8c30hkqv9n7cr	BEGIN OE_BULK_ORDER_IMPORT_PVT.ORDER_IMPORT_CONC_PGM( :errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8); END;
8c8cf4vtv4tx2	SELECT * FROM ( SELECT LeadEO.sales_lead_id as SalesLeadId , to_char(hz_timezone_pub.convert_datetime(:1, hcp.timezone_id, SYSDATE), 'HH:MI AM ') ||' '||ht.standard_time_short_code as PrimaryContactLocalTime , SUBSTRB(LeadEO.description, 1, 240) as Description , hp.party_name as ContactName , custParty.party_name as CustomerName , aslt.meaning as RankName , ast.meaning as LeadStatus , ROUND(SYSDATE - LeadEO.creation_date) as Age , DECODE(LeadEO.status_code, 'CONVERTED_TO_OPPORTUNITY', 'ASNCnvToOpptyDsbld', 'ASNCnvToOpptyEnbld') as ASNLeadLstCnvToOppty , LeadEO.customer_id , hp.party_id , LeadEO.primary_contact_party_id , hr.relationship_id FROM as_sales_leads LeadEO , ( SELECT /*+ no_merge */ distinct aaa.sales_lead_id, aaa.customer_id FROM as_accesses_all aaa WHERE aaa.sales_lead_id IS NOT NULL AND aaa.lead_id IS NULL AND aaa.salesforce_id = :2) secu , as_statuses_tl ast , as_sales_lead_ranks_tl aslt , hz_parties CustParty , hz_parties hp, hz_relationships hr , hz_contact_points hcp , hz_timezones ht , ams_source_codes amsc WHERE LeadEO.sales_lead_id = secu.sales_lead_id AND LeadEO.customer_id = secu.customer_id AND LeadEO.status_code = ast.status_code AND ast.language = USERENV('LANG') AND LeadEO.lead_rank_id = aslt.rank_id (+) AND aslt.language (+) = USERENV('LANG') AND LeadEO.customer_id = CustParty.party_id AND LeadEO.primary_contact_party_id = hr.party_id(+) AND hr.subject_id = hp.party_id (+) AND hr.subject_table_name (+) = 'HZ_PARTIES' AND hr.object_id(+) = LeadEO.customer_id AND hr.object_table_name (+) = 'HZ_PARTIES' AND LeadEO.primary_contact_party_id = hcp.owner_table_id(+) AND hcp.owner_table_name (+) = 'HZ_PARTIES' AND hcp.primary_flag (+) = 'Y' AND hcp.contact_point_type (+) = 'PHONE' AND hcp.timezone_id = ht.timezone_id (+) AND LeadEO.source_promotion_id = amsc.source_code_id AND amsc.source_code_for_id = :3 AND LeadEO.status_code = :4 ORDER BY age )
8camsgjsr9zya	begin OE_TRANSACTION_TYPES_PKG.Val_Ord_Change( :t_application_id, :t_entity_short_name, :t_validation_entity_short_name, :t_validation_tmplt_short_name, :t_record_set_short_name, :t_scope, :t_result ); end;
8h16w67202y4g	begin fnd_global.initialize(:session_id, :user_id, :resp_id, :resp_appl_id, :security_group_id, :site_id, :login_id, :conc_login_id, :prog_appl_id, :conc_program_id, :conc_request_id, :conc_priority_request, :form_id, :form_application_id, :conc_process_id, :conc_queue_id, :queue_appl_id, :server_id); fnd_profile.put('ORG_ID', :l); fnd_profile.put('MFG_CHART_OF_ACCOUNTS_ID', :m); fnd_profile.put('APPS_MAINTENANCE_MODE', :amm); end;
8jb36w62w5hqf	BEGIN IBU_REQ_PKG.UpdateServiceRequest(:1, :2, -1, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16); END;
91hakq9n36htp	SELECT TEXT_VALUE FROM WF_ITEM_ATTRIBUTE_VALUES WHERE ITEM_TYPE = :B3 AND ITEM_KEY = :B2 AND NAME = :B1
9sf243fdjmdmh	begin fnd_global.apps_initialize(-1, -1, -1, :1); end;
a29grr748ghc4	BEGIN jdr_custom_internal.getActiveLayers(:1, :2, :3, :4, :5); END;
avc1jqzz04wpr	SELECT 'x' FROM DUAL
bkxrrs52m7d8p	BEGIN WSH_SHIP_CONFIRM_ACTIONS.interface_ALL_wrp( :errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8); END;
cwyx16zn1hpfb	select parameter, value from nls_session_parameters
fb13x9qx0ftks	begin OE_STANDARD_WF.OEOL_SELECTOR (:v1, :v2, :v3, :v4, :v5); end;
fkxdmd0h7xg54	select item, item_id, item_description, inventory_item_id, item_identifier_type, decode(item_identifier_type, 'INT', :1, 'CUST', :2, item_identifier_type) item_identifier_type_meaning, inventory_item, Address, cust_address, item_definition_level from oe_items_v where ( UPPER(ITEM) LIKE :3 AND (ITEM LIKE :4 OR ITEM LIKE :5 OR ITEM LIKE :6 OR ITEM LIKE :7)) AND ( (sold_to_org_id = :8 or sold_to_org_id is null) and (item_status ='ACTIVE' or item_status IS NULL) and (cross_ref_status = 'ACTIVE' or cross_ref_status IS NULL) ) order by item
fmfdkztk8vx23	SELECT CATEGORY, SEVERITY, FND_LOG_SEVERITY FROM FND_NEW_MESSAGES WHERE MESSAGE_NAME = :B1 AND APPLICATION_ID = :B2 AND LANGUAGE_CODE = :B3 AND ROWNUM = 1
g6yx4z6m66xtq	select /*+ parallel(t, 8) parallel_index(t, 8) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*), count("INTERFACE_LINE_ATTRIBUTE15"), count(distinct "INTERFACE_LINE_ATTRIBUTE15"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE15")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE15"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE15"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE9"), count(distinct "INTERFACE_LINE_ATTRIBUTE9"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE9")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE9"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE9"), 16, 0, 32), 1, 120), count("VAT_TAX_ID"), count(distinct "VAT_TAX_ID"), sum(sys_op_opnsize("VAT_TAX_ID")), substrb(dump(min("VAT_TAX_ID"), 16, 0, 32), 1, 120), substrb(dump(max("VAT_TAX_ID"), 16, 0, 32), 1, 120), count("REASON_CODE_MEANING"), count(distinct "REASON_CODE_MEANING"), sum(sys_op_opnsize("REASON_CODE_MEANING")), substrb(dump(min(substrb("REASON_CODE_MEANING", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("REASON_CODE_MEANING", 1, 32)), 16, 0, 32), 1, 120), count("LAST_PERIOD_TO_CREDIT"), count(distinct "LAST_PERIOD_TO_CREDIT"), sum(sys_op_opnsize("LAST_PERIOD_TO_CREDIT")), substrb(dump(min("LAST_PERIOD_TO_CREDIT"), 16, 0, 32), 1, 120), substrb(dump(max("LAST_PERIOD_TO_CREDIT"), 16, 0, 32), 1, 120), count("PAYING_CUSTOMER_ID"), count(distinct "PAYING_CUSTOMER_ID"), sum(sys_op_opnsize("PAYING_CUSTOMER_ID")) , substrb(dump(min("PAYING_CUSTOMER_ID"), 16, 0, 32), 1, 120), substrb(dump(max("PAYING_CUSTOMER_ID"), 16, 0, 32), 1, 120), count("PAYING_SITE_USE_ID"), count(distinct "PAYING_SITE_USE_ID"), sum(sys_op_opnsize("PAYING_SITE_USE_ID")), substrb(dump(min("PAYING_SITE_USE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("PAYING_SITE_USE_ID"), 16, 0, 32), 1, 120), count("TAX_EXEMPT_FLAG"), count(distinct "TAX_EXEMPT_FLAG"), sum(sys_op_opnsize("TAX_EXEMPT_FLAG")), substrb(dump(min("TAX_EXEMPT_FLAG"), 16, 0, 32), 1, 120), substrb(dump(max("TAX_EXEMPT_FLAG"), 16, 0, 32), 1, 120), count("TAX_EXEMPT_REASON_CODE"), count(distinct "TAX_EXEMPT_REASON_CODE"), sum(sys_op_opnsize("TAX_EXEMPT_REASON_CODE")), substrb(dump(min("TAX_EXEMPT_REASON_CODE"), 16, 0, 32), 1, 120), substrb(dump(max("TAX_EXEMPT_REASON_CODE"), 16, 0, 32), 1, 120), count("TAX_EXEMPT_REASON_CODE_MEANING"), count(distinct "TAX_EXEMPT_REASON_CODE_MEANING"), sum(sys_op_opnsize("TAX_EXEMPT_REASON_CODE_MEANING")), substrb(dump(min(substrb("TAX_EXEMPT_REASON_CODE_MEANING", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("TAX_EXEMPT_REASON_CODE_MEANING", 1, 32)), 16, 0, 32), 1, 120), count("TAX_EXEMPT_NUMBER"), count(distinct "TAX_EXEMPT_NUMBER"), sum(sys_op_opnsize("TAX_EXEMPT_NUMBER")), substrb(dump(min(substrb("TAX_EXEMPT_NUMBER", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("TAX_EXEMPT_NUMBER", 1, 32)), 16, 0, 32), 1, 120), count("SALES_TAX_ID"), count(distinct "SALES_TAX_ID"), sum(sys_op_opnsize("SALES_TAX_ID")), substrb(dump(min("SALES_TAX_ID"), 16, 0, 32), 1, 120), substrb(dump(max("SALES_TAX_ID"), 16, 0, 32), 1, 120), count("CREATED_BY"), count(distinct "CREATED_BY"), sum(sys_op_opnsize("CREATED_BY")), substrb(dump(min("CREATED_BY"), 16, 0, 32), 1, 120), substrb(dump(max("CREATED_BY"), 16, 0, 32), 1, 120), count("CREATION_DATE"), count(distinct "CREATION_DATE"), substrb(dump(min("CREATION_DATE"), 16, 0, 32), 1, 120), substrb(dump(max("CREATION_DATE"), 16, 0, 32), 1, 120), count("CUST_TRX_TYPE_NAME"), count(distinct "CUST_TRX_TYPE_NAME"), sum(sys_op_opnsize("CUST_TRX_TYPE_NAME")), substrb(dump(min("CUST_TRX_TYPE_NAME"), 16, 0, 32), 1, 120), substrb(dump(max("CUST_TRX_TYPE_NAME"), 16, 0, 32), 1, 120), count("CUST_TRX_TYPE_ID"), count(distinct "CUST_TRX_TYPE_ID"), sum(sys_op_opnsize("CUST_TRX_TYPE_ID")), substrb(dump(min("CUST_TRX_TYPE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("CUST_TRX_TYPE_ID"), 16, 0, 32), 1, 120), count("TERM_NAME"), count(distinct "TERM_NAME"), sum(sys_op_opnsize("TERM_NAME")), substrb(dump(min("TERM_NAME"), 16, 0, 32), 1, 120), substrb(dump(max("TERM_NAME"), 16, 0, 32), 1, 120), count("TERM_ID"), count(distinct "TERM_ID"), sum(sys_op_opnsize("TERM_ID")), substrb(dump(min("TERM_ID"), 16, 0, 32), 1, 120), substrb(dump(max("TERM_ID"), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_BATCH_NAME"), count(distinct "ORIG_SYSTEM_BATCH_NAME"), sum(sys_op_opnsize("ORIG_SYSTEM_BATCH_NAME")), substrb(dump(min(substrb("ORIG_SYSTEM_BATCH_NAME", 1, 32)), 16, 0, 32), 1, 120), substrb( dump(max(substrb("ORIG_SYSTEM_BATCH_NAME", 1, 32)), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_BILL_CUSTOMER_REF"), count(distinct "ORIG_SYSTEM_BILL_CUSTOMER_REF"), sum(sys_op_opnsize("ORIG_SYSTEM_BILL_CUSTOMER_REF")), substrb(dump(min(substrb("ORIG_SYSTEM_BILL_CUSTOMER_REF", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ORIG_SYSTEM_BILL_CUSTOMER_REF", 1, 32)), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_BILL_CUSTOMER_ID"), count(distinct "ORIG_SYSTEM_BILL_CUSTOMER_ID"), sum(sys_op_opnsize("ORIG_SYSTEM_BILL_CUSTOMER_ID")), substrb(dump(min("ORIG_SYSTEM_BILL_CUSTOMER_ID"), 16, 0, 32), 1, 120), substrb(dump(max("ORIG_SYSTEM_BILL_CUSTOMER_ID"), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_BILL_ADDRESS_REF"), count(distinct "ORIG_SYSTEM_BILL_ADDRESS_REF"), sum(sys_op_opnsize("ORIG_SYSTEM_BILL_ADDRESS_REF")), substrb(dump(min(substrb("ORIG_SYSTEM_BILL_ADDRESS_REF", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ORIG_SYSTEM_BILL_ADDRESS_REF", 1, 32)), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_BILL_ADDRESS_ID"), count(distinct "ORIG_SYSTEM_BILL_ADDRESS_ID"), sum(sys_op_opnsize("ORIG_SYSTEM_BILL_ADDRESS_ID")), substrb(dump(min("ORIG_SYSTEM_BILL_ADDRESS_ID"), 16, 0, 32), 1, 120), substrb(dump(max("ORIG_SYSTEM_BILL_ADDRESS_ID"), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_BILL_CONTACT_REF"), count(distinct "ORIG_SYSTEM_BILL_CONTACT_REF"), sum(sys_op_opnsize("ORIG_SYSTEM_BILL_CONTACT_REF")), substrb(dump(min(substrb("ORIG_SYSTEM_BILL_CONTACT_REF", 1, 32)), 16, 0, 32), 1, 120), substrb( dump(max(substrb("ORIG_SYSTEM_BILL_CONTACT_REF", 1, 32)), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_BILL_CONTACT_ID"), count(distinct "ORIG_SYSTEM_BILL_CONTACT_ID"), sum(sys_op_opnsize("ORIG_SYSTEM_BILL_CONTACT_ID")), substrb(dump(min("ORIG_SYSTEM_BILL_CONTACT_ID"), 16, 0, 32), 1, 120), substrb(dump(max("ORIG_SYSTEM_BILL_CONTACT_ID"), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_SHIP_CUSTOMER_REF"), count(distinct "ORIG_SYSTEM_SHIP_CUSTOMER_REF"), sum(sys_op_opnsize("ORIG_SYSTEM_SHIP_CUSTOMER_REF")), substrb(dump(min(substrb("ORIG_SYSTEM_SHIP_CUSTOMER_REF", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ORIG_SYSTEM_SHIP_CUSTOMER_REF", 1, 32)), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_SHIP_CUSTOMER_ID"), count(distinct "ORIG_SYSTEM_SHIP_CUSTOMER_ID"), sum(sys_op_opnsize("ORIG_SYSTEM_SHIP_CUSTOMER_ID")), substrb(dump(min("ORIG_SYSTEM_SHIP_CUSTOMER_ID"), 16, 0, 32), 1, 120), substrb(dump(max("ORIG_SYSTEM_SHIP_CUSTOMER_ID"), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_SHIP_ADDRESS_REF"), count(distinct "ORIG_SYSTEM_SHIP_ADDRESS_REF"), sum(sys_op_opnsize("ORIG_SYSTEM_SHIP_ADDRESS_REF")), substrb(dump(min(substrb("ORIG_SYSTEM_SHIP_ADDRESS_REF", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ORIG_SYSTEM_SHIP_ADDRESS_REF", 1, 32)), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_SHIP_ADDRESS_ID"), count(distinct "ORIG_SYSTEM_SHIP_ADDRESS_ID"), sum(sys_op_opnsize("ORIG_SYSTEM_SHIP_ADDRESS_ID")), substrb(dump(min("ORIG_SYSTEM_SHIP_ADDRESS_ID"), 16, 0, 32), 1, 120), substrb(dump(max("ORIG _SYSTEM_SHIP_ADDRESS_ID"), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_SHIP_CONTACT_REF"), count(distinct "ORIG_SYSTEM_SHIP_CONTACT_REF"), sum(sys_op_opnsize("ORIG_SYSTEM_SHIP_CONTACT_REF")), substrb(dump(min(substrb("ORIG_SYSTEM_SHIP_CONTACT_REF", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ORIG_SYSTEM_SHIP_CONTACT_REF", 1, 32)), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_SHIP_CONTACT_ID"), count(distinct "ORIG_SYSTEM_SHIP_CONTACT_ID"), sum(sys_op_opnsize("ORIG_SYSTEM_SHIP_CONTACT_ID")), substrb(dump(min("ORIG_SYSTEM_SHIP_CONTACT_ID"), 16, 0, 32), 1, 120), substrb(dump(max("ORIG_SYSTEM_SHIP_CONTACT_ID"), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_SOLD_CUSTOMER_REF"), count(distinct "ORIG_SYSTEM_SOLD_CUSTOMER_REF"), sum(sys_op_opnsize("ORIG_SYSTEM_SOLD_CUSTOMER_REF")), substrb(dump(min(substrb("ORIG_SYSTEM_SOLD_CUSTOMER_REF", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ORIG_SYSTEM_SOLD_CUSTOMER_REF", 1, 32)), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_SOLD_CUSTOMER_ID"), count(distinct "ORIG_SYSTEM_SOLD_CUSTOMER_ID"), sum(sys_op_opnsize("ORIG_SYSTEM_SOLD_CUSTOMER_ID")), substrb(dump(min("ORIG_SYSTEM_SOLD_CUSTOMER_ID"), 16, 0, 32), 1, 120), substrb(dump(max("ORIG_SYSTEM_SOLD_CUSTOMER_ID"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ID"), count(distinct "LINK_TO_LINE_ID"), sum(sys_op_opnsize("LINK_TO_LINE_ID")), substrb(dump(min("LINK_TO_LINE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ID"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_CONTEXT"), count(distin ct "LINK_TO_LINE_CONTEXT"), sum(sys_op_opnsize("LINK_TO_LINE_CONTEXT")), substrb(dump(min("LINK_TO_LINE_CONTEXT"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_CONTEXT"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE1"), count(distinct "LINK_TO_LINE_ATTRIBUTE1"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE1")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE1"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE1"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE2"), count(distinct "LINK_TO_LINE_ATTRIBUTE2"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE2")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE2"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE2"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE3"), count(distinct "LINK_TO_LINE_ATTRIBUTE3"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE3")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE3"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE3"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE4"), count(distinct "LINK_TO_LINE_ATTRIBUTE4"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE4")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE4"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE4"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE5"), count(distinct "LINK_TO_LINE_ATTRIBUTE5"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE5")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE5"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE5"), 16, 0, 32), 1, 120), count("LINK_TO_L INE_ATTRIBUTE6"), count(distinct "LINK_TO_LINE_ATTRIBUTE6"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE6")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE6"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE6"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE7"), count(distinct "LINK_TO_LINE_ATTRIBUTE7"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE7")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE7"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE7"), 16, 0, 32), 1, 120), count("RECEIPT_METHOD_NAME"), count(distinct "RECEIPT_METHOD_NAME"), sum(sys_op_opnsize("RECEIPT_METHOD_NAME")), substrb(dump(min("RECEIPT_METHOD_NAME"), 16, 0, 32), 1, 120), substrb(dump(max("RECEIPT_METHOD_NAME"), 16, 0, 32), 1, 120), count("RECEIPT_METHOD_ID"), count(distinct "RECEIPT_METHOD_ID"), sum(sys_op_opnsize("RECEIPT_METHOD_ID")), substrb(dump(min("RECEIPT_METHOD_ID"), 16, 0, 32), 1, 120), substrb(dump(max("RECEIPT_METHOD_ID"), 16, 0, 32), 1, 120), count(distinct "CONVERSION_TYPE"), sum(sys_op_opnsize("CONVERSION_TYPE")), substrb(dump(min("CONVERSION_TYPE"), 16, 0, 32), 1, 120), substrb(dump(max("CONVERSION_TYPE"), 16, 0, 32), 1, 120), count("CONVERSION_DATE"), count(distinct "CONVERSION_DATE"), substrb(dump(min("CONVERSION_DATE"), 16, 0, 32), 1, 120), substrb(dump(max("CONVERSION_DATE"), 16, 0, 32), 1, 120), count("CONVERSION_RATE"), count(distinct "CONVERSION_RATE"), sum(sys_op_opnsize("CONVERSION_RATE")), substrb(dump(min("CONVERSION_RATE"), 16, 0, 32), 1, 120), substrb(dum p(max("CONVERSION_RATE"), 16, 0, 32), 1, 120), count("CUSTOMER_TRX_ID"), count(distinct "CUSTOMER_TRX_ID"), sum(sys_op_opnsize("CUSTOMER_TRX_ID")), substrb(dump(min("CUSTOMER_TRX_ID"), 16, 0, 32), 1, 120), substrb(dump(max("CUSTOMER_TRX_ID"), 16, 0, 32), 1, 120), count("TRX_DATE"), count(distinct "TRX_DATE"), substrb(dump(min("TRX_DATE"), 16, 0, 32), 1, 120), substrb(dump(max("TRX_DATE"), 16, 0, 32), 1, 120), count("GL_DATE"), count(distinct "GL_DATE"), substrb(dump(min("GL_DATE"), 16, 0, 32), 1, 120), substrb(dump(max("GL_DATE"), 16, 0, 32), 1, 120), count("DOCUMENT_NUMBER"), count(distinct "DOCUMENT_NUMBER"), sum(sys_op_opnsize("DOCUMENT_NUMBER")), substrb(dump(min("DOCUMENT_NUMBER"), 16, 0, 32), 1, 120), substrb(dump(max("DOCUMENT_NUMBER"), 16, 0, 32), 1, 120), count("TRX_NUMBER"), count(distinct "TRX_NUMBER"), sum(sys_op_opnsize("TRX_NUMBER")), substrb(dump(min("TRX_NUMBER"), 16, 0, 32), 1, 120), substrb(dump(max("TRX_NUMBER"), 16, 0, 32), 1, 120), count("LINE_NUMBER"), count(distinct "LINE_NUMBER"), sum(sys_op_opnsize("LINE_NUMBER")), substrb(dump(min("LINE_NUMBER"), 16, 0, 32), 1, 120), substrb(dump(max("LINE_NUMBER"), 16, 0, 32), 1, 120), count("QUANTITY"), count(distinct "QUANTITY"), sum(sys_op_opnsize("QUANTITY")), substrb(dump(min("QUANTITY"), 16, 0, 32), 1, 120), substrb(dump(max("QUANTITY"), 16, 0, 32), 1, 120), count("QUANTITY_ORDERED"), count(distinct "QUANTITY_ORDERED"), sum(sys_op_opnsize("QUANTITY_ORDERED")), substrb(dump(min("QUANTITY_ORDERED"), 16, 0, 32), 1, 120), substrb(dump(max("QUANTITY_ORDERED"), 16, 0, 32), 1, 120), count("UNIT_SELLING_PRICE"), count(distinct "UNIT_SELLING_PRICE"), sum(sys_op_opnsize("UNIT_SELLING_PRICE")), substrb(dump(min("UNIT_SELLING_PRICE"), 16, 0, 32), 1, 120), substrb(dump(max("UNIT_SELLING_PRICE"), 16, 0, 32), 1, 120), count("UNIT_STANDARD_PRICE"), count(distinct "UNIT_STANDARD_PRICE"), sum(sys_op_opnsize("UNIT_STANDARD_PRICE")), substrb(dump(min("UNIT_STANDARD_PRICE"), 16, 0, 32), 1, 120), substrb(dump(max("UNIT_STANDARD_PRICE"), 16, 0, 32), 1, 120), count("PRINTING_OPTION"), count(distinct "PRINTING_OPTION"), sum(sys_op_opnsize("PRINTING_OPTION")), substrb(dump(min("PRINTING_OPTION"), 16, 0, 32), 1, 120), substrb(dump(max("PRINTING_OPTION"), 16, 0, 32), 1, 120), count("INTERFACE_STATUS"), count(distinct "INTERFACE_STATUS"), sum(sys_op_opnsize("INTERFACE_STATUS")), substrb(dump(min("INTERFACE_STATUS"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_STATUS"), 16, 0, 32), 1, 120), count("REQUEST_ID"), count(distinct "REQUEST_ID"), sum(sys_op_opnsize("REQUEST_ID")), substrb(dump(min("REQUEST_ID"), 16, 0, 32), 1, 120), substrb(dump(max("REQUEST_ID"), 16, 0, 32), 1, 120), count("RELATED_BATCH_SOURCE_NAME"), count(distinct "RELATED_BATCH_SOURCE_NAME"), sum(sys_op_opnsize("RELATED_BATCH_SOURCE_NAME")), substrb(dump(min(substrb("RELATED_BATCH_SOURCE_NAME", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("RELATED_BATCH_SOURCE_NAME", 1, 32)), 16, 0, 32), 1, 120), count("RELATED_TRX_NUMBER"), coun t(distinct "RELATED_TRX_NUMBER"), sum(sys_op_opnsize("RELATED_TRX_NUMBER")), substrb(dump(min("RELATED_TRX_NUMBER"), 16, 0, 32), 1, 120), substrb(dump(max("RELATED_TRX_NUMBER"), 16, 0, 32), 1, 120), count("RELATED_CUSTOMER_TRX_ID"), count(distinct "RELATED_CUSTOMER_TRX_ID"), sum(sys_op_opnsize("RELATED_CUSTOMER_TRX_ID")), substrb(dump(min("RELATED_CUSTOMER_TRX_ID"), 16, 0, 32), 1, 120), substrb(dump(max("RELATED_CUSTOMER_TRX_ID"), 16, 0, 32), 1, 120), count("PREVIOUS_CUSTOMER_TRX_ID"), count(distinct "PREVIOUS_CUSTOMER_TRX_ID"), sum(sys_op_opnsize("PREVIOUS_CUSTOMER_TRX_ID")), substrb(dump(min("PREVIOUS_CUSTOMER_TRX_ID"), 16, 0, 32), 1, 120), substrb(dump(max("PREVIOUS_CUSTOMER_TRX_ID"), 16, 0, 32), 1, 120), count("CREDIT_METHOD_FOR_ACCT_RULE"), count(distinct "CREDIT_METHOD_FOR_ACCT_RULE"), sum(sys_op_opnsize("CREDIT_METHOD_FOR_ACCT_RULE")), substrb(dump(min("CREDIT_METHOD_FOR_ACCT_RULE"), 16, 0, 32), 1, 120), substrb(dump(max("CREDIT_METHOD_FOR_ACCT_RULE"), 16, 0, 32), 1, 120), count("CREDIT_METHOD_FOR_INSTALLMENTS"), count(distinct "CREDIT_METHOD_FOR_INSTALLMENTS"), sum(sys_op_opnsize("CREDIT_METHOD_FOR_INSTALLMENTS")), substrb(dump(min("CREDIT_METHOD_FOR_INSTALLMENTS"), 16, 0, 32), 1, 120), substrb(dump(max("CREDIT_METHOD_FOR_INSTALLMENTS"), 16, 0, 32), 1, 120), count("REASON_CODE"), count(distinct "REASON_CODE"), sum(sys_op_opnsize("REASON_CODE")), substrb(dump(min("REASON_CODE"), 16, 0, 32), 1, 120), substrb(dump(max("REASON_CODE"), 16, 0, 32), 1, 120), count("TAX_RATE" ), count(distinct "TAX_RATE"), sum(sys_op_opnsize("TAX_RATE")), substrb(dump(min("TAX_RATE"), 16, 0, 32), 1, 120), substrb(dump(max("TAX_RATE"), 16, 0, 32), 1, 120), count("TAX_CODE"), count(distinct "TAX_CODE"), sum(sys_op_opnsize("TAX_CODE")), substrb(dump(min(substrb("TAX_CODE", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("TAX_CODE", 1, 32)), 16, 0, 32), 1, 120), count("TAX_PRECEDENCE"), count(distinct "TAX_PRECEDENCE"), sum(sys_op_opnsize("TAX_PRECEDENCE")), substrb(dump(min("TAX_PRECEDENCE"), 16, 0, 32), 1, 120), substrb(dump(max("TAX_PRECEDENCE"), 16, 0, 32), 1, 120), count("EXCEPTION_ID"), count(distinct "EXCEPTION_ID"), sum(sys_op_opnsize("EXCEPTION_ID")), substrb(dump(min("EXCEPTION_ID"), 16, 0, 32), 1, 120), substrb(dump(max("EXCEPTION_ID"), 16, 0, 32), 1, 120), count("EXEMPTION_ID"), count(distinct "EXEMPTION_ID"), sum(sys_op_opnsize("EXEMPTION_ID")), substrb(dump(min("EXEMPTION_ID"), 16, 0, 32), 1, 120), substrb(dump(max("EXEMPTION_ID"), 16, 0, 32), 1, 120), count("SHIP_DATE_ACTUAL"), count(distinct "SHIP_DATE_ACTUAL"), substrb(dump(min("SHIP_DATE_ACTUAL"), 16, 0, 32), 1, 120), substrb(dump(max("SHIP_DATE_ACTUAL"), 16, 0, 32), 1, 120), count("FOB_POINT"), count(distinct "FOB_POINT"), sum(sys_op_opnsize("FOB_POINT")), substrb(dump(min("FOB_POINT"), 16, 0, 32), 1, 120), substrb(dump(max("FOB_POINT"), 16, 0, 32), 1, 120), count("SHIP_VIA"), count(distinct "SHIP_VIA"), sum(sys_op_opnsize("SHIP_VIA")), substrb(dump(min("SHIP_VIA"), 16, 0, 32), 1, 120), subst rb(dump(max("SHIP_VIA"), 16, 0, 32), 1, 120), count("WAYBILL_NUMBER"), count(distinct "WAYBILL_NUMBER"), sum(sys_op_opnsize("WAYBILL_NUMBER")), substrb(dump(min(substrb("WAYBILL_NUMBER", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("WAYBILL_NUMBER", 1, 32)), 16, 0, 32), 1, 120), count("INVOICING_RULE_NAME"), count(distinct "INVOICING_RULE_NAME"), sum(sys_op_opnsize("INVOICING_RULE_NAME")), substrb(dump(min("INVOICING_RULE_NAME"), 16, 0, 32), 1, 120), substrb(dump(max("INVOICING_RULE_NAME"), 16, 0, 32), 1, 120), count("INVOICING_RULE_ID"), count(distinct "INVOICING_RULE_ID"), sum(sys_op_opnsize("INVOICING_RULE_ID")), substrb(dump(min("INVOICING_RULE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("INVOICING_RULE_ID"), 16, 0, 32), 1, 120), count("ACCOUNTING_RULE_NAME"), count(distinct "ACCOUNTING_RULE_NAME"), sum(sys_op_opnsize("ACCOUNTING_RULE_NAME")), substrb(dump(min("ACCOUNTING_RULE_NAME"), 16, 0, 32), 1, 120), substrb(dump(max("ACCOUNTING_RULE_NAME"), 16, 0, 32), 1, 120), count("ACCOUNTING_RULE_ID"), count(distinct "ACCOUNTING_RULE_ID"), sum(sys_op_opnsize("ACCOUNTING_RULE_ID")), substrb(dump(min("ACCOUNTING_RULE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("ACCOUNTING_RULE_ID"), 16, 0, 32), 1, 120), count("ACCOUNTING_RULE_DURATION"), count(distinct "ACCOUNTING_RULE_DURATION"), sum(sys_op_opnsize("ACCOUNTING_RULE_DURATION")), substrb(dump(min("ACCOUNTING_RULE_DURATION"), 16, 0, 32), 1, 120), substrb(dump(max("ACCOUNTING_RULE_DURATION"), 16, 0, 32), 1, 120), count("RUL E_START_DATE"), count(distinct "RULE_START_DATE"), substrb(dump(min("RULE_START_DATE"), 16, 0, 32), 1, 120), substrb(dump(max("RULE_START_DATE"), 16, 0, 32), 1, 120), count("PRIMARY_SALESREP_NUMBER"), count(distinct "PRIMARY_SALESREP_NUMBER"), sum(sys_op_opnsize("PRIMARY_SALESREP_NUMBER")), substrb(dump(min("PRIMARY_SALESREP_NUMBER"), 16, 0, 32), 1, 120), substrb(dump(max("PRIMARY_SALESREP_NUMBER"), 16, 0, 32), 1, 120), count("PRIMARY_SALESREP_ID"), count(distinct "PRIMARY_SALESREP_ID"), sum(sys_op_opnsize("PRIMARY_SALESREP_ID")), substrb(dump(min("PRIMARY_SALESREP_ID"), 16, 0, 32), 1, 120), substrb(dump(max("PRIMARY_SALESREP_ID"), 16, 0, 32), 1, 120), count("SALES_ORDER"), count(distinct "SALES_ORDER"), sum(sys_op_opnsize("SALES_ORDER")), substrb(dump(min(substrb("SALES_ORDER", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("SALES_ORDER", 1, 32)), 16, 0, 32), 1, 120), count("SALES_ORDER_LINE"), count(distinct "SALES_ORDER_LINE"), sum(sys_op_opnsize("SALES_ORDER_LINE")), substrb(dump(min("SALES_ORDER_LINE"), 16, 0, 32), 1, 120), substrb(dump(max("SALES_ORDER_LINE"), 16, 0, 32), 1, 120), count("SALES_ORDER_DATE"), count(distinct "SALES_ORDER_DATE"), substrb(dump(min("SALES_ORDER_DATE"), 16, 0, 32), 1, 120), substrb(dump(max("SALES_ORDER_DATE"), 16, 0, 32), 1, 120), count("SALES_ORDER_SOURCE"), count(distinct "SALES_ORDER_SOURCE"), sum(sys_op_opnsize("SALES_ORDER_SOURCE")), substrb(dump(min(substrb("SALES_ORDER_SOURCE", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(sub strb("SALES_ORDER_SOURCE", 1, 32)), 16, 0, 32), 1, 120), count("SALES_ORDER_REVISION"), count(distinct "SALES_ORDER_REVISION"), sum(sys_op_opnsize("SALES_ORDER_REVISION")), substrb(dump(min("SALES_ORDER_REVISION"), 16, 0, 32), 1, 120), substrb(dump(max("SALES_ORDER_REVISION"), 16, 0, 32), 1, 120), count("PURCHASE_ORDER"), count(distinct "PURCHASE_ORDER"), sum(sys_op_opnsize("PURCHASE_ORDER")), substrb(dump(min(substrb("PURCHASE_ORDER", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("PURCHASE_ORDER", 1, 32)), 16, 0, 32), 1, 120), count("PURCHASE_ORDER_REVISION"), count(distinct "PURCHASE_ORDER_REVISION"), sum(sys_op_opnsize("PURCHASE_ORDER_REVISION")), substrb(dump(min(substrb("PURCHASE_ORDER_REVISION", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("PURCHASE_ORDER_REVISION", 1, 32)), 16, 0, 32), 1, 120), count("PURCHASE_ORDER_DATE"), count(distinct "PURCHASE_ORDER_DATE"), substrb(dump(min("PURCHASE_ORDER_DATE"), 16, 0, 32), 1, 120), substrb(dump(max("PURCHASE_ORDER_DATE"), 16, 0, 32), 1, 120), count("AGREEMENT_NAME"), count(distinct "AGREEMENT_NAME"), sum(sys_op_opnsize("AGREEMENT_NAME")), substrb(dump(min("AGREEMENT_NAME"), 16, 0, 32), 1, 120), substrb(dump(max("AGREEMENT_NAME"), 16, 0, 32), 1, 120), count("AGREEMENT_ID"), count(distinct "AGREEMENT_ID"), sum(sys_op_opnsize("AGREEMENT_ID")), substrb(dump(min("AGREEMENT_ID"), 16, 0, 32), 1, 120), substrb(dump(max("AGREEMENT_ID"), 16, 0, 32), 1, 120), count("MEMO_LINE_NAME"), count(distinct "MEMO_LINE_NAME"), su m(sys_op_opnsize("MEMO_LINE_NAME")), substrb(dump(min(substrb("MEMO_LINE_NAME", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MEMO_LINE_NAME", 1, 32)), 16, 0, 32), 1, 120), count("MEMO_LINE_ID"), count(distinct "MEMO_LINE_ID"), sum(sys_op_opnsize("MEMO_LINE_ID")), substrb(dump(min("MEMO_LINE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("MEMO_LINE_ID"), 16, 0, 32), 1, 120), count("INVENTORY_ITEM_ID"), count(distinct "INVENTORY_ITEM_ID"), sum(sys_op_opnsize("INVENTORY_ITEM_ID")), substrb(dump(min("INVENTORY_ITEM_ID"), 16, 0, 32), 1, 120), substrb(dump(max("INVENTORY_ITEM_ID"), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG1"), count(distinct "MTL_SYSTEM_ITEMS_SEG1"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG1")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG1", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG1", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG2"), count(distinct "MTL_SYSTEM_ITEMS_SEG2"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG2")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG2", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG2", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG3"), count(distinct "MTL_SYSTEM_ITEMS_SEG3"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG3")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG3", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG3", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG4"), count(distinct "MTL _SYSTEM_ITEMS_SEG4"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG4")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG4", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG4", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG5"), count(distinct "MTL_SYSTEM_ITEMS_SEG5"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG5")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG5", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG5", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG6"), count(distinct "MTL_SYSTEM_ITEMS_SEG6"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG6")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG6", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG6", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG7"), count(distinct "MTL_SYSTEM_ITEMS_SEG7"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG7")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG7", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG7", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG8"), count(distinct "MTL_SYSTEM_ITEMS_SEG8"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG8")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG8", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG8", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG9"), count(distinct "MTL_SYSTEM_ITEMS_SEG9"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG9")), substrb(dump(min(substrb("MTL_SYSTEM_ ITEMS_SEG9", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG9", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG10"), count(distinct "MTL_SYSTEM_ITEMS_SEG10"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG10")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG10", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG10", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG11"), count(distinct "MTL_SYSTEM_ITEMS_SEG11"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG11")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG11", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG11", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG12"), count(distinct "MTL_SYSTEM_ITEMS_SEG12"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG12")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG12", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG12", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG13"), count(distinct "MTL_SYSTEM_ITEMS_SEG13"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG13")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG13", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG13", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG14"), count(distinct "MTL_SYSTEM_ITEMS_SEG14"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG14")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG14", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_I TEMS_SEG14", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG15"), count(distinct "MTL_SYSTEM_ITEMS_SEG15"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG15")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG15", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG15", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG16"), count(distinct "MTL_SYSTEM_ITEMS_SEG16"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG16")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG16", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG16", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG17"), count(distinct "MTL_SYSTEM_ITEMS_SEG17"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG17")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG17", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG17", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG18"), count(distinct "MTL_SYSTEM_ITEMS_SEG18"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG18")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG18", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG18", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG19"), count(distinct "MTL_SYSTEM_ITEMS_SEG19"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG19")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG19", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG19", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG20"), coun t(distinct "MTL_SYSTEM_ITEMS_SEG20"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG20")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG20", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG20", 1, 32)), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ID"), count(distinct "REFERENCE_LINE_ID"), sum(sys_op_opnsize("REFERENCE_LINE_ID")), substrb(dump(min("REFERENCE_LINE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ID"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_CONTEXT"), count(distinct "REFERENCE_LINE_CONTEXT"), sum(sys_op_opnsize("REFERENCE_LINE_CONTEXT")), substrb(dump(min("REFERENCE_LINE_CONTEXT"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_CONTEXT"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE1"), count(distinct "REFERENCE_LINE_ATTRIBUTE1"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE1")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE1"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE1"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE2"), count(distinct "REFERENCE_LINE_ATTRIBUTE2"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE2")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE2"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE2"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE3"), count(distinct "REFERENCE_LINE_ATTRIBUTE3"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE3")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE3"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUT E3"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ID"), sum(sys_op_opnsize("INTERFACE_LINE_ID")), substrb(dump(min("INTERFACE_LINE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ID"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_CONTEXT"), count(distinct "INTERFACE_LINE_CONTEXT"), sum(sys_op_opnsize("INTERFACE_LINE_CONTEXT")), substrb(dump(min("INTERFACE_LINE_CONTEXT"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_CONTEXT"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE1"), count(distinct "INTERFACE_LINE_ATTRIBUTE1"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE1")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE1"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE1"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE2"), count(distinct "INTERFACE_LINE_ATTRIBUTE2"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE2")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE2"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE2"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE3"), count(distinct "INTERFACE_LINE_ATTRIBUTE3"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE3")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE3"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE3"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE4"), count(distinct "INTERFACE_LINE_ATTRIBUTE4"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE4")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE4"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LIN E_ATTRIBUTE4"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE5"), count(distinct "INTERFACE_LINE_ATTRIBUTE5"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE5")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE5"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE5"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE6"), count(distinct "INTERFACE_LINE_ATTRIBUTE6"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE6")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE6"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE6"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE7"), count(distinct "INTERFACE_LINE_ATTRIBUTE7"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE7")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE7"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE7"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE8"), count(distinct "INTERFACE_LINE_ATTRIBUTE8"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE8")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE8"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE8"), 16, 0, 32), 1, 120), count(distinct "BATCH_SOURCE_NAME"), sum(sys_op_opnsize("BATCH_SOURCE_NAME")), substrb(dump(min(substrb("BATCH_SOURCE_NAME", 1, 32)), 16, 0, 32), 1, 120), substrb⠀搀甀洀瀀⠀洀愀砀⠀猀甀戀猀琀爀戀⠀∀䈀䄀吀䌀䠀开匀伀唀刀䌀䔀开一䄀䴀䔀∀Ⰰ㄀Ⰰ㌀㈀⤀⤀Ⰰ㄀㘀Ⰰ　Ⰰ㌀㈀⤀Ⰰ㄀Ⰰ㄀㈀　⤀Ⰰ挀漀甀渀琀⠀∀匀䔀吀开伀䘀开䈀伀伀䬀匀开䤀䐀∀⤀Ⰰ挀漀甀渀琀⠀搀椀猀琀椀渀挀琀 ∀匀䔀吀开伀䘀开䈀伀伀䬀匀开䤀䐀∀⤀Ⰰ猀甀洀⠀猀礀 猀开漀瀀开漀瀀渀猀椀稀攀⠀∀匀䔀吀开伀䘀开䈀伀伀䬀匀开䤀䐀∀⤀⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀椀渀⠀∀匀䔀吀开伀䘀开䈀伀伀䬀匀开䤀䐀∀⤀Ⰰ㄀㘀Ⰰ　Ⰰ㌀㈀⤀Ⰰ㄀Ⰰ㄀㈀　⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀愀砀⠀∀匀䔀吀开 伀䘀开䈀伀伀䬀匀开䤀䐀∀⤀Ⰰ㄀㘀Ⰰ　Ⰰ㌀㈀⤀Ⰰ㄀Ⰰ㄀㈀　⤀Ⰰ挀漀甀渀琀⠀搀椀猀琀椀渀挀琀 ∀䰀䤀一䔀开吀夀倀䔀∀⤀Ⰰ猀甀洀⠀猀礀猀开漀瀀开漀瀀渀猀椀稀攀⠀∀䰀䤀一䔀开吀夀倀䔀∀⤀⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀椀渀⠀∀䰀䤀一䔀开吀夀倀䔀∀⤀Ⰰ㄀㘀Ⰰ　Ⰰ㌀㈀⤀Ⰰ㄀Ⰰ㄀㈀　⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀愀砀⠀∀䰀䤀一䔀开吀夀倀䔀∀⤀Ⰰ㄀㘀Ⰰ　Ⰰ㌀㈀⤀Ⰰ㄀Ⰰ㄀㈀　⤀Ⰰ挀漀甀渀琀⠀搀椀猀琀椀渀挀琀 ∀䐀䔀匀䌀刀䤀倀吀䤀伀一∀⤀Ⰰ猀甀洀⠀猀礀猀开漀瀀开漀瀀渀猀椀稀攀⠀∀䐀䔀匀䌀刀䤀倀吀䤀伀一∀⤀⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀椀渀⠀猀甀戀猀琀爀戀⠀∀䐀䔀匀䌀刀䤀倀吀䤀伀一∀Ⰰ㄀Ⰰ㌀㈀⤀⤀Ⰰ㄀㘀Ⰰ　Ⰰ㌀㈀⤀Ⰰ㄀Ⰰ㄀㈀　⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀愀砀⠀猀甀戀猀琀爀戀⠀∀䐀䔀匀䌀刀䤀倀吀䤀伀一∀Ⰰ㄀Ⰰ㌀㈀⤀⤀Ⰰ㄀㘀Ⰰ　Ⰰ㌀㈀⤀Ⰰ㄀Ⰰ㄀㈀　⤀Ⰰ挀漀甀渀琀⠀搀椀猀琀椀渀挀琀 ∀䌀唀刀刀䔀一䌀夀开䌀伀䐀䔀∀⤀Ⰰ猀甀洀⠀猀礀猀开漀瀀开漀瀀渀猀椀稀攀⠀∀䌀唀刀刀䔀一䌀夀开䌀伀䐀䔀∀⤀⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀椀渀⠀∀䌀唀刀刀䔀一䌀夀开䌀伀䐀䔀∀⤀Ⰰ㄀㘀Ⰰ　Ⰰ㌀㈀⤀Ⰰ㄀Ⰰ㄀㈀　⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀愀砀⠀∀䌀唀刀刀䔀一䌀夀开䌀伀䐀䔀∀⤀Ⰰ㄀㘀Ⰰ　Ⰰ㌀㈀⤀Ⰰ㄀Ⰰ㄀㈀　⤀Ⰰ挀漀甀渀琀⠀∀䄀䴀伀唀一吀∀⤀Ⰰ挀漀甀渀琀⠀搀椀猀琀椀渀挀琀 ∀䄀䴀伀唀一吀∀⤀Ⰰ猀甀洀⠀猀礀猀开漀瀀开漀瀀渀猀椀稀攀⠀∀䄀䴀伀唀一吀∀⤀⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀椀渀⠀∀䄀䴀伀唀一吀∀⤀Ⰰ㄀㘀Ⰰ　Ⰰ㌀㈀⤀Ⰰ㄀Ⰰ㄀㈀　⤀Ⰰ猀甀戀猀琀爀戀⠀搀甀洀瀀⠀洀愀砀⠀∀䄀䴀伀唀一吀∀⤀Ⰰ㄀㘀Ⰰ　Ⰰ㌀㈀⤀Ⰰ㄀Ⰰ㄀㈀　⤀ 昀爀漀洀 ∀䄀刀∀⸀∀刀䄀开䤀一吀䔀刀䘀䄀䌀䔀开䰀䤀一䔀匀开䄀䰀䰀∀ 猀愀洀瀀氀攀 ⠀ ㄀　⸀　　　　　　　　　　⤀ 琀
g8102j8yynbwz	begin WF_STANDARD.CONTINUEFLOW (:v1, :v2, :v3, :v4, :v5); end;
gf1u933c95jb5	DECLARE l_ret_stat varchar2(56); BEGIN CSI_INV_TXN_HOOK_PKG.postTransaction( p_header_id => :1 , p_transaction_id => :2 , x_return_status => l_ret_stat ); INV_TXNSTUB_PUB.g_ret_status := l_ret_stat; END;
gk43kd7q5mak4	update ra_customer_trx_lines l set (vat_tax_id, amount_includes_tax_flag) = (select :VAT_TAX_ID, decode(:AMOUNT_INCLUDES_TAX_OVERRIDE, 'N', :AMOUNT_INCLUDES_TAX_FLAG, NVL(l.amount_includes_tax_flag, :AMOUNT_INCLUDES_TAX_FLAG) ) from dual ) where customer_trx_line_id=:LINE_ID and line_type ='LINE'

Back to SQL Statistics
Back to Top

 

Instance Activity Statistics

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

Back to Top

Instance Activity Stats

Statistic	Total	per Second	per Trans
CPU used by this session	6,230,425	1,703.52	4.92
CPU used when call started	6,214,277	1,699.10	4.91
CR blocks created	14,457,335	3,952.91	11.42
Cached Commit SCN referenced	1,659,260	453.67	1.31
Commit SCN cached	16	0.00	0.00
DB time	17,795,210	4,865.55	14.06
DBWR checkpoint buffers written	1,774,577	485.20	1.40
DBWR checkpoints	58	0.02	0.00
DBWR object drop buffers written	58,888	16.10	0.05
DBWR parallel query checkpoint buffers written	84,956	23.23	0.07
DBWR revisited being-written buffer	563	0.15	0.00
DBWR transaction table writes	1,588	0.43	0.00
DBWR undo block writes	1,648,989	450.86	1.30
DFO trees parallelized	10	0.00	0.00
IMU CR rollbacks	33,718,437	9,219.26	26.64
IMU Flushes	374,061	102.28	0.30
IMU Redo allocation size	2,546,151,372	696,166.03	2,011.64
IMU commits	645,829	176.58	0.51
IMU contention	45,192	12.36	0.04
IMU ktichg flush	12,696	3.47	0.01
IMU pool not allocated	2,903	0.79	0.00
IMU recursive-transaction flush	1,814	0.50	0.00
IMU undo allocation size	5,769,058,528	1,577,369.91	4,557.97
IMU- failed to get a private strand	2,903	0.79	0.00
PX local messages recv'd	9,177	2.51	0.01
PX local messages sent	9,177	2.51	0.01
Parallel operations downgraded 25 to 50 pct	6	0.00	0.00
Parallel operations downgraded 50 to 75 pct	2	0.00	0.00
Parallel operations downgraded to serial	31	0.01	0.00
Parallel operations not downgraded	2	0.00	0.00
SQL*Net roundtrips to/from client	48,142,494	13,163.07	38.04
active txn count during cleanout	94,731,674	25,901.43	74.84
application wait time	31,190	8.53	0.02
background checkpoints completed	2	0.00	0.00
background checkpoints started	2	0.00	0.00
background timeouts	11,547	3.16	0.01
branch node splits	1,055	0.29	0.00
buffer is not pinned count	742,740,572	203,079.35	586.82
buffer is pinned count	1,219,740,558	333,500.18	963.68
bytes received via SQL*Net from client	11,374,139,153	3,109,905.16	8,986.39
bytes sent via SQL*Net to client	10,089,895,799	2,758,768.70	7,971.75
calls to get snapshot scn: kcmgss	120,670,408	32,993.58	95.34
calls to kcmgas	18,921,506	5,173.50	14.95
calls to kcmgcs	1,721,425	470.67	1.36
change write time	112,987	30.89	0.09
cleanout - number of ktugct calls	15,836,389	4,329.97	12.51
cleanouts and rollbacks - consistent read gets	13,430,327	3,672.11	10.61
cleanouts only - consistent read gets	165,736	45.32	0.13
cluster key scan block gets	952,895	260.54	0.75
cluster key scans	194,942	53.30	0.15
commit batch/immediate performed	5,979	1.63	0.00
commit batch/immediate requested	5,979	1.63	0.00
commit cleanout failures: block lost	275,552	75.34	0.22
commit cleanout failures: buffer being written	139	0.04	0.00
commit cleanout failures: callback failure	142,790	39.04	0.11
commit cleanout failures: cannot pin	43,734	11.96	0.03
commit cleanouts	10,506,670	2,872.72	8.30
commit cleanouts successfully completed	10,044,443	2,746.34	7.94
commit immediate performed	5,979	1.63	0.00
commit immediate requested	5,979	1.63	0.00
commit txn count during cleanout	1,585,412	433.48	1.25
concurrency wait time	88,741	24.26	0.07
consistent changes	896,297,448	245,064.71	708.14
consistent gets	2,098,860,305	573,868.18	1,658.25
consistent gets - examination	1,366,089,883	373,514.86	1,079.31
consistent gets direct	168,644	46.11	0.13
consistent gets from cache	2,098,691,180	573,821.93	1,658.12
current blocks converted for CR	317	0.09	0.00
cursor authentications	1,963	0.54	0.00
data blocks consistent reads - undo records applied	891,167,326	243,662.03	704.09
db block changes	202,180,032	55,279.85	159.74
db block gets	213,699,808	58,429.58	168.84
db block gets direct	61,866	16.92	0.05
db block gets from cache	213,637,960	58,412.67	168.79
deferred (CURRENT) block cleanout applications	1,847,215	505.06	1.46
dirty buffers inspected	709,485	193.99	0.56
doubling up with imu segment	0	0.00	0.00
enqueue conversions	9,862	2.70	0.01
enqueue releases	5,063,166	1,384.37	4.00
enqueue requests	5,065,925	1,385.12	4.00
enqueue timeouts	2,492	0.68	0.00
enqueue waits	122,726	33.56	0.10
exchange deadlocks	38,189	10.44	0.03
execute count	107,048,010	29,268.95	84.58
failed probes on index block reclamation	1,207	0.33	0.00
free buffer inspected	6,039,066	1,651.20	4.77
free buffer requested	20,151,130	5,509.70	15.92
heap block compress	9,250,209	2,529.18	7.31
hot buffers moved to head of LRU	2,946,175	805.54	2.33
immediate (CR) block cleanout applications	13,596,164	3,717.45	10.74
immediate (CURRENT) block cleanout applications	1,183,223	323.52	0.93
index crx upgrade (found)	90,825	24.83	0.07
index crx upgrade (positioned)	10,882,806	2,975.57	8.60
index fast full scans (full)	8	0.00	0.00
index fast full scans (rowid ranges)	47	0.01	0.00
index fetch by key	166,920,234	45,639.15	131.88
index scans kdiixs1	164,965,587	45,104.72	130.33
java call heap collected bytes	1,493,135,336	408,251.49	1,179.68
java call heap collected count	18,155,789	4,964.14	14.34
java call heap gc count	4,761	1.30	0.00
java call heap live object count	1,448,954	396.17	1.14
java call heap live object count max	1,449,466	396.31	1.15
java call heap live size	349,596,480	95,586.30	276.21
java call heap live size max	349,678,528	95,608.74	276.27
java call heap object count	3,643,383	996.17	2.88
java call heap object count max	3,639,743	995.17	2.88
java call heap total size	450,756,608	123,245.40	356.13
java call heap total size max	450,756,608	123,245.40	356.13
java call heap used size	489,994,288	133,973.72	387.13
java call heap used size max	489,861,848	133,937.51	387.03
leaf node 90-10 splits	23,992	6.56	0.02
leaf node splits	259,164	70.86	0.20
lob reads	23,687	6.48	0.02
lob writes	49,953	13.66	0.04
lob writes unaligned	49,953	13.66	0.04
logons cumulative	12,309	3.37	0.01
messages received	1,193,675	326.37	0.94
messages sent	1,193,676	326.37	0.94
no buffer to keep pinned count	16	0.00	0.00
no work - consistent read gets	683,461,471	186,871.32	539.98
opened cursors cumulative	6,786,537	1,855.57	5.36
parse count (failures)	4,001	1.09	0.00
parse count (hard)	9,844	2.69	0.01
parse count (total)	10,146,579	2,774.27	8.02
parse time cpu	115,096	31.47	0.09
parse time elapsed	136,575	37.34	0.11
physical read IO requests	934,174	255.42	0.74
physical read bytes	11,992,391,680	3,278,947.12	9,474.86
physical read total IO requests	935,870	255.88	0.74
physical read total bytes	12,019,320,832	3,286,310.06	9,496.13
physical read total multi block requests	17,763	4.86	0.01
physical reads	1,463,914	400.26	1.16
physical reads cache	1,085,918	296.91	0.86
physical reads cache prefetch	159,818	43.70	0.13
physical reads direct	377,998	103.35	0.30
physical reads direct temporary tablespace	372	0.10	0.00
physical reads prefetch warmup	15,297	4.18	0.01
physical write IO requests	1,089,695	297.94	0.86
physical write bytes	25,220,440,064	6,895,746.19	19,925.97
physical write total IO requests	2,674,804	731.34	2.11
physical write total bytes	58,886,108,160	16,100,577.75	46,524.28
physical write total multi block requests	1,793,922	490.49	1.42
physical writes	3,078,667	841.77	2.43
physical writes direct	62,458	17.08	0.05
physical writes direct (lob)	248	0.07	0.00
physical writes direct temporary tablespace	4,291	1.17	0.00
physical writes from cache	3,016,209	824.69	2.38
physical writes non checkpoint	2,650,910	724.81	2.09
pinned buffers inspected	7,875	2.15	0.01
prefetch clients - default	1	0.00	0.00
prefetch warmup blocks aged out before use	233,114	63.74	0.18
prefetched blocks aged out before use	139	0.04	0.00
process last non-idle time	3,657	1.00	0.00
queries parallelized	10	0.00	0.00
recursive aborts on index block reclamation	10	0.00	0.00
recursive calls	174,501,121	47,711.91	137.87
recursive cpu usage	3,706,680	1,013.48	2.93
redo blocks written	65,588,826	17,933.23	51.82
redo buffer allocation retries	44	0.01	0.00
redo entries	103,358,037	28,260.05	81.66
redo log space requests	77	0.02	0.00
redo log space wait time	117	0.03	0.00
redo ordering marks	1,079,881	295.26	0.85
redo size	32,079,701,864	8,771,198.34	25,345.28
redo subscn max counts	2,457,092	671.82	1.94
redo synch time	121,956	33.35	0.10
redo synch writes	2,437,290	666.40	1.93
redo wastage	404,297,888	110,542.70	319.42
redo write time	35,741	9.77	0.03
redo writer latching time	976	0.27	0.00
redo writes	896,739	245.19	0.71
rollback changes - undo records applied	279,332	76.37	0.22
rollbacks only - consistent read gets	1,112,764	304.25	0.88
rows fetched via callback	102,064,822	27,906.46	80.64
session connect time	0	0.00	0.00
session cursor cache hits	5,977,088	1,634.25	4.72
session logical reads	2,312,580,606	632,303.36	1,827.11
session pga memory	13,064,375,352	3,572,047.77	10,321.80
session pga memory max	14,124,742,456	3,861,972.22	11,159.57
session uga memory	###############	75,861,827.80	219,210.58
session uga memory max	89,506,417,744	24,472,750.59	70,716.54
shared hash latch upgrades - no wait	34,095,082	9,322.24	26.94
shared hash latch upgrades - wait	131,124	35.85	0.10
sorts (memory)	11,254,154	3,077.10	8.89
sorts (rows)	119,659,574	32,717.19	94.54
sql area evicted	829	0.23	0.00
sql area purged	4,110	1.12	0.00
summed dirty queue length	3,823,180	1,045.33	3.02
switch current to new buffer	1,832,610	501.07	1.45
table fetch by rowid	836,992,430	228,849.59	661.28
table fetch continued row	22,582,397	6,174.46	17.84
table scan blocks gotten	79,759,208	21,807.68	63.02
table scan rows gotten	4,553,075,767	1,244,897.19	3,597.26
table scans (direct read)	416	0.11	0.00
table scans (long tables)	622	0.17	0.00
table scans (rowid ranges)	578	0.16	0.00
table scans (short tables)	6,373,758	1,742.71	5.04
total number of times SMON posted	165,999	45.39	0.13
transaction rollbacks	5,979	1.63	0.00
transaction tables consistent read rollbacks	209	0.06	0.00
transaction tables consistent reads - undo records applied	18,663	5.10	0.01
undo change vector size	11,549,412,056	3,157,828.10	9,124.87
user I/O wait time	294,730	80.58	0.23
user calls	45,833,123	12,531.64	36.21
user commits	992,790	271.45	0.78
user rollbacks	272,917	74.62	0.22
workarea executions - onepass	4	0.00	0.00
workarea executions - optimal	6,367,888	1,741.10	5.03
write clones created in background	3,764	1.03	0.00
write clones created in foreground	961	0.26	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	329,593	1,266,302
opened cursors current	1,116,381	1,354,361
workarea memory allocated	579	4,251
logons current	5,521	5,523

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)	2	1.97

Back to Instance Activity Statistics
Back to Top

 

IO Stats

• Tablespace IO Stats
• File IO Stats

Back to Top

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)
APPS_TS_TX_DATA	581,133	159	3.16	1.13	110,421	30	165,495	0.22
APPS_UNDOTS1	17,175	5	0.45	1.00	592,574	162	354,918	0.07
APPS_TS_TX_IDX	239,360	65	3.13	1.04	127,185	35	107,043	0.29
APPS_TS_TX_INTERFACE	12,630	3	2.61	30.53	122,626	34	58,007	0.30
APPS_ASSM_DATA	38,275	10	0.82	2.26	49,227	13	186,041	0.72
APPS_ASSM_IDX	20,811	6	1.92	1.00	54,266	15	144,189	0.19
TEMP	3,961	1	3.03	2.07	23,663	6	132	6.82
SYSTEM	8,614	2	3.59	3.23	3,133	1	12,753	0.39
APPS_TS_SEED	8,227	2	4.22	1.12	2,548	1	1,005	2.57
CTXSYS	632	0	4.05	1.10	1,855	1	2	0.00
APPS_TS_QUEUES	307	0	4.04	1.20	745	0	409	1.59
SYSAUX	481	0	2.31	1.27	493	0	0	0.00
APPS_TS_ARCHIVE	232	0	3.41	1.00	543	0	236	4.32
APPS_TS_SUMMARY	100	0	4.60	1.00	249	0	138	0.43
APPS_TS_NOLOGGING	47	0	4.68	1.30	111	0	7	2.86
APPS_TS_MEDIA	6	0	5.00	1.00	6	0	0	0.00
ODM	10	0	2.00	1.00	2	0	0	0.00
OLAP	10	0	5.00	1.00	2	0	0	0.00
OWAPUB	10	0	2.00	1.00	2	0	0	0.00
PORTAL	10	0	4.00	1.00	2	0	0	0.00
SYNCSERVER	10	0	2.00	1.00	2	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)
APPS_ASSM_DATA	/OASB/11.5.10/oracle/data/apps_assm_data.dbf	38,275	10	0.82	2.26	49,227	13	186,041	0.72
APPS_ASSM_IDX	/OASB/11.5.10/oracle/data/apps_assm_idx.dbf	20,811	6	1.92	1.00	54,266	15	144,189	0.19
APPS_TS_ARCHIVE	/OASB/11.5.10/oracle/data/archive1.dbf	81	0	3.46	1.00	241	0	118	3.56
APPS_TS_ARCHIVE	/OASB/11.5.10/oracle/data/archive2.dbf	151	0	3.38	1.00	302	0	118	5.08
APPS_TS_MEDIA	/OASB/11.5.10/oracle/data/media1.dbf	2	0	5.00	1.00	2	0	0	0.00
APPS_TS_MEDIA	/OASB/11.5.10/oracle/data/media2.dbf	2	0	5.00	1.00	2	0	0	0.00
APPS_TS_MEDIA	/OASB/11.5.10/oracle/data/media3.dbf	2	0	5.00	1.00	2	0	0	0.00
APPS_TS_NOLOGGING	/OASB/11.5.10/oracle/data/nologging1.dbf	21	0	4.76	1.67	60	0	7	2.86
APPS_TS_NOLOGGING	/OASB/11.5.10/oracle/data/nologging2.dbf	22	0	4.55	1.00	42	0	0	0.00
APPS_TS_NOLOGGING	/OASB/11.5.10/oracle/data/nologging3.dbf	4	0	5.00	1.00	9	0	0	0.00
APPS_TS_QUEUES	/OASB/11.5.10/oracle/data/queues1.dbf	28	0	3.93	1.00	91	0	6	0.00
APPS_TS_QUEUES	/OASB/11.5.10/oracle/data/queues2.dbf	95	0	4.00	1.38	163	0	212	2.78
APPS_TS_QUEUES	/OASB/11.5.10/oracle/data/queues3.dbf	71	0	2.68	1.07	156	0	109	0.28
APPS_TS_QUEUES	/OASB/11.5.10/oracle/data/queues4.dbf	38	0	3.95	1.16	91	0	57	0.53
APPS_TS_QUEUES	/OASB/11.5.10/oracle/data/queues5.dbf	21	0	6.19	1.10	63	0	1	0.00
APPS_TS_QUEUES	/OASB/11.5.10/oracle/data/queues6.dbf	20	0	5.50	1.10	65	0	4	0.00
APPS_TS_QUEUES	/OASB/11.5.10/oracle/data/queues7.dbf	34	0	5.00	1.32	116	0	20	0.00
APPS_TS_SEED	/OASB/11.5.10/oracle/data/reference1.dbf	517	0	4.45	1.21	236	0	214	2.52
APPS_TS_SEED	/OASB/11.5.10/oracle/data/reference10.dbf	540	0	4.19	1.08	172	0	0	0.00
APPS_TS_SEED	/OASB/11.5.10/oracle/data/reference2.dbf	669	0	4.25	1.22	267	0	704	2.78
APPS_TS_SEED	/OASB/11.5.10/oracle/data/reference3.dbf	947	0	4.05	1.11	293	0	10	3.00
APPS_TS_SEED	/OASB/11.5.10/oracle/data/reference4.dbf	945	0	4.16	1.10	275	0	45	0.67
APPS_TS_SEED	/OASB/11.5.10/oracle/data/reference5.dbf	902	0	4.35	1.07	247	0	1	0.00
APPS_TS_SEED	/OASB/11.5.10/oracle/data/reference6.dbf	919	0	4.53	1.14	279	0	10	0.00
APPS_TS_SEED	/OASB/11.5.10/oracle/data/reference7.dbf	923	0	4.31	1.12	248	0	2	0.00
APPS_TS_SEED	/OASB/11.5.10/oracle/data/reference8.dbf	942	0	4.20	1.07	288	0	11	1.82
APPS_TS_SEED	/OASB/11.5.10/oracle/data/reference9.dbf	923	0	3.86	1.14	243	0	8	0.00
APPS_TS_SUMMARY	/OASB/11.5.10/oracle/data/summary1.dbf	7	0	2.86	1.00	29	0	0	0.00
APPS_TS_SUMMARY	/OASB/11.5.10/oracle/data/summary2.dbf	7	0	1.43	1.00	34	0	69	0.29
APPS_TS_SUMMARY	/OASB/11.5.10/oracle/data/summary3.dbf	8	0	3.75	1.00	29	0	20	1.00
APPS_TS_SUMMARY	/OASB/11.5.10/oracle/data/summary4.dbf	9	0	2.22	1.00	23	0	18	0.00
APPS_TS_SUMMARY	/OASB/11.5.10/oracle/data/summary5.dbf	6	0	8.33	1.00	25	0	0	0.00
APPS_TS_SUMMARY	/OASB/11.5.10/oracle/data/summary6.dbf	27	0	4.81	1.00	44	0	1	0.00
APPS_TS_SUMMARY	/OASB/11.5.10/oracle/data/summary7.dbf	31	0	5.16	1.00	46	0	29	0.69
APPS_TS_SUMMARY	/OASB/11.5.10/oracle/data/summary8.dbf	5	0	8.00	1.00	19	0	1	0.00
APPS_TS_TX_DATA	/OASB/11.5.10/oracle/data/tx_data1.dbf	2,041	1	2.64	1.52	2,059	1	6,298	0.33
APPS_TS_TX_DATA	/OASB/11.5.10/oracle/data/tx_data10.dbf	1,905	1	2.72	1.39	1,998	1	5,993	0.25
APPS_TS_TX_DATA	/OASB/11.5.10/oracle/data/tx_data11.dbf	2,113	1	2.81	1.44	2,169	1	6,975	0.41
APPS_TS_TX_DATA	/OASB/11.5.10/oracle/data/tx_data12.dbf	52,303	14	3.07	1.09	8,132	2	6,419	0.09
APPS_TS_TX_DATA	/OASB/11.5.10/oracle/data/tx_data13.dbf	52,618	14	3.37	1.09	7,949	2	6,803	0.10
APPS_TS_TX_DATA	/OASB/11.5.10/oracle/data/tx_data14.dbf	55,253	15	3.25	1.09	9,613	3	39,838	0.10
APPS_TS_TX_DATA	/OASB/11.5.10/oracle/data/tx_data15.dbf	52,136	14	2.98	1.09	8,083	2	6,507	0.27
APPS_TS_TX_DATA	/OASB/11.5.10/oracle/data/tx_data16.dbf	52,147	14	3.07	1.09	7,994	2	6,867	0.27
APPS_TS_TX_DATA	/OASB/11.5.10/oracle/data/tx_data17.dbf	52,037	14	3.04	1.09	8,002	2	4,898	0.08
APPS_TS_TX_DATA	/OASB/11.5.10/oracle/data/tx_data18.dbf	51,721	14	3.09	1.10	7,948	2	5,471	0.12
APPS_TS_TX_DATA	/OASB/11.5.10/oracle/data/tx_data19.dbf	51,858	14	3.07	1.09	7,910	2	6,040	0.10
APPS_TS_TX_DATA	/OASB/11.5.10/oracle/data/tx_data2.dbf	2,206	1	2.45	2.22	2,406	1	6,683	0.38
APPS_TS_TX_DATA	/OASB/11.5.10/oracle/data/tx_data20.dbf	51,846	14	3.28	1.09	7,725	2	5,083	0.15
APPS_TS_TX_DATA	/OASB/11.5.10/oracle/data/tx_data21.dbf	51,967	14	3.40	1.09	7,903	2	5,991	0.08
APPS_TS_TX_DATA	/OASB/11.5.10/oracle/data/tx_data3.dbf	2,796	1	2.70	2.11	2,959	1	6,759	0.43
APPS_TS_TX_DATA	/OASB/11.5.10/oracle/data/tx_data4.dbf	3,538	1	2.74	1.81	3,029	1	6,357	0.36
APPS_TS_TX_DATA	/OASB/11.5.10/oracle/data/tx_data5.dbf	16,210	4	3.48	1.22	3,195	1	6,160	0.38
APPS_TS_TX_DATA	/OASB/11.5.10/oracle/data/tx_data6.dbf	4,736	1	3.14	1.66	3,103	1	6,933	0.27
APPS_TS_TX_DATA	/OASB/11.5.10/oracle/data/tx_data7.dbf	15,710	4	3.52	1.20	2,907	1	6,155	0.41
APPS_TS_TX_DATA	/OASB/11.5.10/oracle/data/tx_data8.dbf	2,611	1	2.35	1.96	2,459	1	6,360	0.26
APPS_TS_TX_DATA	/OASB/11.5.10/oracle/data/tx_data9.dbf	3,381	1	2.55	1.90	2,878	1	6,905	0.27
APPS_TS_TX_IDX	/OASB/11.5.10/oracle/data/tx_idx1.dbf	1,620	0	3.46	1.02	2,147	1	2,513	0.43
APPS_TS_TX_IDX	/OASB/11.5.10/oracle/data/tx_idx10.dbf	2,094	1	3.36	1.03	4,792	1	2,269	0.33
APPS_TS_TX_IDX	/OASB/11.5.10/oracle/data/tx_idx11.dbf	2,214	1	3.03	1.02	3,733	1	3,132	1.18
APPS_TS_TX_IDX	/OASB/11.5.10/oracle/data/tx_idx12.dbf	20,516	6	3.08	1.03	9,074	2	7,019	0.22
APPS_TS_TX_IDX	/OASB/11.5.10/oracle/data/tx_idx13.dbf	20,302	6	3.04	1.04	8,741	2	6,480	0.23
APPS_TS_TX_IDX	/OASB/11.5.10/oracle/data/tx_idx14.dbf	24,059	7	2.93	1.03	13,423	4	9,539	0.18
APPS_TS_TX_IDX	/OASB/11.5.10/oracle/data/tx_idx15.dbf	19,846	5	3.10	1.05	8,578	2	6,300	0.37
APPS_TS_TX_IDX	/OASB/11.5.10/oracle/data/tx_idx16.dbf	19,835	5	3.18	1.04	8,406	2	5,364	0.15
APPS_TS_TX_IDX	/OASB/11.5.10/oracle/data/tx_idx17.dbf	19,977	5	3.07	1.04	8,267	2	5,839	0.23
APPS_TS_TX_IDX	/OASB/11.5.10/oracle/data/tx_idx18.dbf	19,735	5	3.15	1.04	8,299	2	5,659	0.15
APPS_TS_TX_IDX	/OASB/11.5.10/oracle/data/tx_idx19.dbf	19,994	5	3.08	1.05	8,586	2	5,998	0.20
APPS_TS_TX_IDX	/OASB/11.5.10/oracle/data/tx_idx2.dbf	1,824	0	3.17	1.02	3,608	1	9,168	0.20
APPS_TS_TX_IDX	/OASB/11.5.10/oracle/data/tx_idx20.dbf	19,626	5	3.09	1.05	8,268	2	7,595	0.23
APPS_TS_TX_IDX	/OASB/11.5.10/oracle/data/tx_idx21.dbf	19,892	5	3.14	1.04	8,326	2	7,039	0.24
APPS_TS_TX_IDX	/OASB/11.5.10/oracle/data/tx_idx3.dbf	2,944	1	3.18	1.03	4,033	1	3,268	0.43
APPS_TS_TX_IDX	/OASB/11.5.10/oracle/data/tx_idx4.dbf	4,381	1	3.40	1.02	3,806	1	2,522	0.52
APPS_TS_TX_IDX	/OASB/11.5.10/oracle/data/tx_idx5.dbf	4,280	1	3.51	1.01	3,189	1	2,578	0.45
APPS_TS_TX_IDX	/OASB/11.5.10/oracle/data/tx_idx6.dbf	4,214	1	3.54	1.03	3,002	1	2,873	0.42
APPS_TS_TX_IDX	/OASB/11.5.10/oracle/data/tx_idx7.dbf	4,113	1	3.40	1.03	2,705	1	3,910	0.37
APPS_TS_TX_IDX	/OASB/11.5.10/oracle/data/tx_idx8.dbf	3,790	1	3.41	1.03	3,452	1	4,026	0.30
APPS_TS_TX_IDX	/OASB/11.5.10/oracle/data/tx_idx9.dbf	4,104	1	3.46	1.03	2,750	1	3,952	0.19
APPS_TS_TX_INTERFACE	/OASB/11.5.10/oracle/data/ts_tx_inte.dbf	1,507	0	2.10	13.08	4,753	1	5,489	0.14
APPS_TS_TX_INTERFACE	/OASB/11.5.10/oracle/data/ts_tx_inte2.dbf	2,391	1	2.86	30.65	23,699	6	10,581	0.40
APPS_TS_TX_INTERFACE	/OASB/11.5.10/oracle/data/ts_tx_inte3.dbf	2,282	1	2.85	32.13	23,639	6	12,540	0.30
APPS_TS_TX_INTERFACE	/OASB/11.5.10/oracle/data/ts_tx_inte4.dbf	2,287	1	2.89	31.92	23,432	6	10,347	0.29
APPS_TS_TX_INTERFACE	/OASB/11.5.10/oracle/data/ts_tx_inte5.dbf	1,996	1	2.46	36.75	23,517	6	9,315	0.28
APPS_TS_TX_INTERFACE	/OASB/11.5.10/oracle/data/ts_tx_inte6.dbf	2,167	1	2.27	33.64	23,586	6	9,735	0.30
APPS_UNDOTS1	/OASB/11.5.10/oracle/data/undo01.dbf	460	0	0.30	1.00	21,852	6	34,038	0.07
APPS_UNDOTS1	/OASB/11.5.10/oracle/data/undo02.dbf	256	0	0.27	1.00	21,075	6	32,329	0.07
APPS_UNDOTS1	/OASB/11.5.10/oracle/data/undo03.dbf	220	0	0.27	1.00	20,963	6	34,018	0.06
APPS_UNDOTS1	/OASB/11.5.10/oracle/data/undo04.dbf	24	0	0.83	1.00	21,191	6	36,342	0.06
APPS_UNDOTS1	/OASB/11.5.10/oracle/data/undo05.dbf	3,102	1	0.47	1.00	109,287	30	45,047	0.09
APPS_UNDOTS1	/OASB/11.5.10/oracle/data/undo06.dbf	2,595	1	0.45	1.00	104,308	29	45,382	0.07
APPS_UNDOTS1	/OASB/11.5.10/oracle/data/undo07.dbf	3,063	1	0.44	1.00	96,609	26	43,551	0.06
APPS_UNDOTS1	/OASB/11.5.10/oracle/data/undo08.dbf	4,215	1	0.52	1.00	100,013	27	43,657	0.07
APPS_UNDOTS1	/OASB/11.5.10/oracle/data/undo09.dbf	3,240	1	0.38	1.00	97,276	27	40,554	0.08
CTXSYS	/OASB/11.5.10/oracle/data/ctx1.dbf	159	0	3.65	1.16	244	0	1	0.00
CTXSYS	/OASB/11.5.10/oracle/data/ctx2.dbf	473	0	4.19	1.07	1,611	0	1	0.00
ODM	/OASB/11.5.10/oracle/data/odm.dbf	10	0	2.00	1.00	2	0	0	0.00
OLAP	/OASB/11.5.10/oracle/data/olap.dbf	10	0	5.00	1.00	2	0	0	0.00
OWAPUB	/OASB/11.5.10/oracle/data/owa1.dbf	10	0	2.00	1.00	2	0	0	0.00
PORTAL	/OASB/11.5.10/oracle/data/portal.dbf	10	0	4.00	1.00	2	0	0	0.00
SYNCSERVER	/OASB/11.5.10/oracle/data/mobile01.dbf	10	0	2.00	1.00	2	0	0	0.00
SYSAUX	/OASB/11.5.10/oracle/data/sysaux01.dbf	330	0	2.21	1.35	280	0	0	0.00
SYSAUX	/OASB/11.5.10/oracle/data/sysaux02.dbf	151	0	2.52	1.07	213	0	0	0.00
SYSTEM	/OASB/11.5.10/oracle/data/sys1.dbf	1,246	0	3.35	3.32	349	0	535	1.08
SYSTEM	/OASB/11.5.10/oracle/data/sys2.dbf	1,281	0	3.71	3.25	408	0	456	1.97
SYSTEM	/OASB/11.5.10/oracle/data/sys3.dbf	1,159	0	3.75	3.41	364	0	482	1.16
SYSTEM	/OASB/11.5.10/oracle/data/sys4.dbf	1,273	0	3.90	3.17	624	0	629	1.00
SYSTEM	/OASB/11.5.10/oracle/data/sys5.dbf	1,439	0	3.37	2.90	561	0	604	1.06
SYSTEM	/OASB/11.5.10/oracle/data/sys6.dbf	1,284	0	3.58	3.17	405	0	1,159	0.50
SYSTEM	/OASB/11.5.10/oracle/data/sys7.dbf	878	0	3.51	3.70	341	0	2,168	0.28
SYSTEM	/OASB/11.5.10/oracle/data/sys8.dbf	26	0	2.31	1.00	37	0	6,633	0.07
SYSTEM	/OASB/11.5.10/oracle/data/sys9.dbf	28	0	2.86	1.00	44	0	87	0.46
TEMP	/OASB/11.5.10/oracle/data/tmp1.dbf	884	0	3.01	1.63	4,474	1	0
TEMP	/OASB/11.5.10/oracle/data/tmp2.dbf	1,198	0	3.07	1.90	7,238	2	99	7.58
TEMP	/OASB/11.5.10/oracle/data/tmp3.dbf	964	0	3.30	1.51	6,814	2	13	3.85
TEMP	/OASB/11.5.10/oracle/data/tmp4.dbf	915	0	2.72	3.31	5,137	1	20	5.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	989,500	100	2,308,672,770	1,084,605	3,016,065	0	0	1,030,460

Back to Top

 

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

Back to Top

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	99	55908	1304628	4040791	73728000	4040791
E	0	123	72972	1667174	19367113	73728000	19367113

Back to Advisory Statistics
Back to Top

 

Buffer Pool Advisory

No data exists for this section of the report.

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
100.00	629,161	11

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	12,000	750	44,139.69	3.63	0.01	100.00	0.00	1,048,576
E	12,000	750	57,593.84	2.17	0.00	100.00	0.00	1,048,576

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	M-Pass Execs
2K	4K	5,736,919	5,736,919	0	0
64K	128K	11,855	11,855	0	0
128K	256K	1,122	1,122	0	0
256K	512K	594	594	0	0
512K	1024K	196,754	196,754	0	0
1M	2M	422,586	422,586	0	0
2M	4M	22	18	4	0
4M	8M	40	40	0	0
8M	16M	2	2	0	0
32M	64M	8	8	0	0
64M	128M	6	6	0	0
128M	256M	2	2	0	0

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
1,500	0.13	792,348.28	13,834.93	98.00	1,354
3,000	0.25	792,348.28	13,714.67	98.00	1,340
6,000	0.50	792,348.28	13,592.51	98.00	1,315
9,000	0.75	792,348.28	13,452.97	98.00	1,293
12,000	1.00	792,348.28	5.45	100.00	1,278
14,400	1.20	792,348.28	5.45	100.00	1,258
16,800	1.40	792,348.28	5.45	100.00	1,233
19,200	1.60	792,348.28	5.45	100.00	1,215
21,600	1.80	792,348.28	5.45	100.00	1,195
24,000	2.00	792,348.28	5.45	100.00	1,157
36,000	3.00	792,348.28	5.45	100.00	820
48,000	4.00	792,348.28	0.00	100.00	0
72,000	6.00	792,348.28	0.00	100.00	0
96,000	8.00	792,348.28	0.00	100.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
2,416	0.80	343	13,387	1,490,701	1.00	2,647	1.18	91,906,888
2,720	0.90	627	17,973	1,491,106	1.00	2,242	1.00	91,925,052
3,024	1.00	929	20,712	1,491,108	1.00	2,240	1.00	91,925,463
3,328	1.10	1,185	30,739	1,491,108	1.00	2,240	1.00	91,925,614
3,632	1.20	1,191	31,400	1,491,108	1.00	2,240	1.00	91,925,614
3,936	1.30	1,191	31,400	1,491,108	1.00	2,240	1.00	91,925,614
4,240	1.40	1,191	31,400	1,491,108	1.00	2,240	1.00	91,925,614
4,544	1.50	1,191	31,400	1,491,108	1.00	2,240	1.00	91,925,614
4,848	1.60	1,191	31,400	1,491,108	1.00	2,240	1.00	91,925,614
5,152	1.70	1,191	31,400	1,491,108	1.00	2,240	1.00	91,925,614
5,456	1.80	1,191	31,400	1,491,108	1.00	2,240	1.00	91,925,614
5,760	1.90	1,191	31,400	1,491,108	1.00	2,240	1.00	91,925,614
6,064	2.01	1,191	31,400	1,491,108	1.00	2,240	1.00	91,925,614

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

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Java Pool Advisory

Java Pool Size(M)	JP 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
48	0.18	12	327	785	1.00	2,242	1.00	10,425
80	0.29	12	327	785	1.00	2,242	1.00	10,425
112	0.41	12	327	785	1.00	2,242	1.00	10,425
144	0.53	12	327	785	1.00	2,242	1.00	10,425
176	0.65	12	327	785	1.00	2,242	1.00	10,425
208	0.76	12	327	785	1.00	2,242	1.00	10,425
240	0.88	12	327	785	1.00	2,242	1.00	10,425
272	1.00	12	327	785	1.00	2,242	1.00	10,425
304	1.12	12	327	785	1.00	2,242	1.00	10,425
336	1.24	12	327	785	1.00	2,242	1.00	10,425
368	1.35	12	327	785	1.00	2,242	1.00	10,425
400	1.47	12	327	785	1.00	2,242	1.00	10,425
432	1.59	12	327	785	1.00	2,242	1.00	10,425
464	1.71	12	327	785	1.00	2,242	1.00	10,425
496	1.82	12	327	785	1.00	2,242	1.00	10,425
528	1.94	12	327	785	1.00	2,242	1.00	10,425

Back to Advisory Statistics
Back to Top

 

Wait Statistics

• Buffer Wait Statistics
• Enqueue Activity

Back to Top

Buffer Wait Statistics

• ordered by wait time desc, waits desc

Class	Waits	Total Wait Time (s)	Avg Time (ms)
data block	646,435	251	0
undo block	315,326	19	0
undo header	39,576	6	0
1st level bmb	22,677	3	0
file header block	129	1	7
segment header	6,080	1	0
2nd level bmb	264	0	0
extent map	7	0	0
bitmap index block	3	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)
HW-Segment High Water Mark	364,856	364,814	42	64,719	210	3.24
UL-User-defined	70,767	69,899	868	2,869	171	59.46
TX-Transaction (row lock contention)	2,407	1,155	1,252	1,072	92	86.04
TX-Transaction (index contention)	33,294	33,294	0	26,004	45	1.74
KO-Multiple Object Checkpoint (fast object checkpoint)	216	216	0	22	15	689.36
SQ-Sequence Cache	75,919	75,919	0	16,352	6	0.37
TX-Transaction	1,400,337	1,400,378	0	6,727	6	0.89
RO-Multiple Object Reuse (fast object reuse)	288	288	0	32	6	181.63
FB-Format Block	42,590	42,590	0	3,685	3	0.80
TX-Transaction (allocate ITL entry)	1,128	1,128	0	829	3	3.20
DV-Diana Versioning	32,221	32,221	0	158	3	15.96
US-Undo Segment	13,558	13,558	0	52	0	1.85
TQ-Queue table enqueue (TM contention)	292	292	0	121	0	0.72
TQ-Queue table enqueue (DDL contention)	480	480	0	72	0	0.93
TM-DML	2,269,978	2,270,031	0	3	0	22.00
PS-PX Process Reservation	640	312	328	10	0	1.10

Back to Wait Statistics
Back to Top

 

Undo Statistics

• Undo Segment Summary
• Undo Segment Stats

Back to Top

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	1,657.42	1,397,513	2,670	424		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
14-Oct 18:10	230,257	199,697	664	400	108	0/0	0/0/0/0/0/0
14-Oct 18:00	488,005	235,618	2,670	394	111	0/0	0/0/0/0/0/0
14-Oct 17:50	284,843	247,494	2,504	417	143	0/0	0/0/0/0/0/0
14-Oct 17:40	192,031	186,588	1,900	416	170	0/0	0/0/0/0/0/0
14-Oct 17:30	181,421	283,745	1,901	396	192	0/0	0/0/0/0/0/0
14-Oct 17:20	280,859	244,371	1,261	424	230	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

Back to Top

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,527	0.00		0	0
AWR Alerted Metric Element list	354,577	0.00		0	0
Consistent RBA	898,843	0.07	0.00	0	0
FOB s.o list latch	114,002	0.03	0.13	0	0
In memory undo latch	659,550,927	2.16	0.00	204	1,301,259	0.00
JOX SGA heap latch	1,945,817	0.00		0	0
JS mem alloc latch	0			0	2	0.00
JS queue state obj latch	21,930	0.00		0	0
JS slv state obj latch	3	0.00		0	0
KMG MMAN ready and startup request latch	1,218	0.00		0	0
KTF sga latch	12	0.00		0	1,231	0.00
KWQMN job cache list latch	6,123	0.18	0.91	0	0
MQL Tracking Latch	0			0	73	0.00
Memory Management Latch	0			0	1,218	0.00
OS process	21,936	0.00		0	0
OS process allocation	15,835	0.01	0.00	0	0
OS process: request allocation	14,577	0.01	0.00	0	0
PL/SQL warning settings	4,677,400	0.00		0	0
SGA IO buffer pool latch	50,614	0.00	0.00	0	50,718	0.00
SQL memory manager latch	1	0.00		0	1,209	0.00
SQL memory manager workarea list latch	7,386,182	0.01	0.02	0	0
Shared B-Tree	131	0.00		0	0
active checkpoint queue latch	298,220	0.00	0.00	0	2	0.00
active service list	56,351	0.04	0.05	0	2,328	0.00
alert log latch	0			0	2	0.00
begin backup scn array	5,669	0.00		0	0
cache buffer handles	25,857,250	3.75	0.00	2	0
cache buffers chains	5,511,042,986	2.16	0.00	235	19,084,877	3.81
cache buffers lru chain	10,900,629	0.70	0.07	7	33,883,374	0.76
cache table scan latch	8,095	0.01	0.00	0	8,095	0.00
channel handle pool latch	437,403	0.08	0.02	0	0
channel operations parent latch	1,847,151	0.85	0.00	0	0
checkpoint queue latch	18,192,831	0.02	0.02	0	2,994,449	0.03
client/application info	1,809,691	0.00	0.00	0	0
commit callback allocation	89,393	0.00	1.00	0	0
compile environment latch	3,213,233	0.00		0	0
dictionary lookup	76	0.00		0	0
dml lock allocation	4,521,148	0.55	0.02	4	0
dummy allocation	24,664	0.01	0.00	0	0
enqueue hash chains	10,314,142	0.25	0.01	1	855	1.40
enqueues	5,849,518	0.40	0.02	2	0
error message lists	185	0.00		0	0
event group latch	7,285	0.00		0	0
file cache latch	30,371	0.00	0.00	0	0
global KZLD latch for mem in SGA	12,195	0.00		0	0
global ctx hash table latch	24,896	0.00		0	0
hash table column usage latch	1,906	0.05	0.00	0	16,513,920	0.00
hash table modification latch	133	0.00		0	2	0.00
internal temp table object number allocation latc	3	0.00		0	0
job workq parent latch	0			0	124	0.00
job_queue_processes free list latch	0			0	2	0.00
job_queue_processes parameter latch	123	0.00		0	0
kks stats	24,337	0.02	0.00	0	0
ksuosstats global area	246	0.00		0	0
ktm global data	166,226	0.00		0	0
kwqbsn:qsga	131	0.00		0	0
lgwr LWN SCN	899,951	0.21	0.00	0	0
library cache	362,690,608	0.62	0.01	82	14,441	0.66
library cache load lock	6,097	1.02	0.00	0	11	0.00
library cache lock	64,012,379	0.15	0.01	3	8	0.00
library cache lock allocation	1,856,706	0.01	0.03	0	0
library cache pin	224,900,457	0.45	0.01	50	20	0.00
library cache pin allocation	612,160	0.00	0.05	0	0
list of block allocation	532,431	0.05	0.07	0	0
loader state object freelist	336,670	0.01	0.00	0	0
longop free list parent	41	0.00		0	41	0.00
message pool operations parent latch	440,718	0.14	0.01	0	0
messages	3,444,046	0.09	0.01	0	0
mostly latch-free SCN	1,051,496	13.82	0.00	0	0
multiblock read objects	24,246	0.02	0.00	0	2	0.00
ncodef allocation latch	204	0.00		0	0
object queue header heap	5,246,093	0.02	0.02	0	493,088	0.16
object queue header operation	55,344,563	0.13	0.03	2	0
object stats modification	430,243	0.07	0.03	0	4	0.00
parallel query alloc buffer	1,848	1.24	0.13	0	0
parallel query stats	168	6.55	0.09	0	0
parameter list	37,893	0.00	0.00	0	0
parameter table allocation management	27,059	0.16	0.65	0	0
post/wait queue	1,582,601	0.05	0.00	0	516,025	0.05
process allocation	14,618	0.76	1.21	1	7,283	0.03
process group creation	14,577	0.00		0	0
process queue	1,039	0.38	0.00	0	0
process queue reference	181,942	0.10	0.00	0	11,902	0.70
qmn task queue latch	524	0.00		0	0
query server freelists	859	6.87	0.00	0	0
query server process	8	87.50	1.00	2	8	0.00
redo allocation	6,685,051	11.19	0.02	16	102,609,677	5.48
redo copy	0			0	103,366,114	0.06
redo writing	3,730,170	0.03	0.07	0	0
resmgr group change latch	866,830	0.00		0	0
resmgr:actses active list	36,798	0.79	0.99	1	0
resmgr:actses change group	36,608	0.00		0	0
resmgr:free threads list	24,661	0.01	0.67	0	0
resmgr:schema config	1	0.00		0	0
row cache objects	137,053,098	0.77	0.01	18	3,748	0.35
rules engine aggregate statistics	51,106	0.03	0.00	0	0
rules engine evaluation context statistics	0			0	2	0.00
rules engine rule set statistics	153,317	0.02	0.00	0	0
rules engine rule statistics	51,105	0.00		0	0
sequence cache	16,829,711	1.08	0.00	1	0
session allocation	19,473,930	1.22	0.03	10	0
session idle bit	94,963,788	0.02	0.02	1	0
session state list latch	73,431	0.26	0.98	0	0
session switching	15,884	0.01	0.00	0	0
session timer	2,328	0.00		0	0
shared pool	7,388,321	0.30	0.04	1	0
shared pool sim alloc	371	0.00		0	0
shared pool simulator	1,607,163	0.00	0.04	0	0
slave class	1	0.00		0	0
slave class create	4	0.00		0	0
sort extent pool	1,495,492	0.29	0.02	0	0
state object free list	2	0.00		0	0
statistics aggregation	84	0.00		0	0
temp lob duration state obj allocation	862	0.00		0	0
temporary table state object allocation	14,348	0.00		0	0
threshold alerts latch	584	0.00		0	0
trace latch	53	0.00		0	0
transaction allocation	131,945	0.00	0.00	0	0
transaction branch allocation	204	0.00		0	0
undo global data	1,077,999,874	1.47	0.00	189	6,507	0.12
user lock	48,856	0.03	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	Sleep1	Sleep2	Sleep3
cache buffers chains	5,511,042,986	118,786,468	373,060	118,594,655	0	0	0
undo global data	1,077,999,874	15,800,410	41,676	15,765,540	0	0	0
In memory undo latch	659,550,927	14,264,342	60,283	14,212,399	0	0	0
library cache	362,690,608	2,239,487	31,220	2,210,329	0	0	0
row cache objects	137,053,098	1,060,935	9,268	1,052,072	0	0	0
library cache pin	224,900,457	1,011,470	15,007	997,394	0	0	0
cache buffer handles	25,857,250	968,869	3,317	965,813	0	0	0
redo allocation	6,685,051	748,340	11,234	738,020	0	0	0
session allocation	19,473,930	238,144	8,052	230,732	0	0	0
sequence cache	16,829,711	182,503	413	182,113	0	0	0
mostly latch-free SCN	1,051,496	145,329	348	145,006	0	0	0
library cache lock	64,012,379	95,119	1,046	94,098	0	0	0
cache buffers lru chain	10,900,629	76,045	5,070	71,211	0	0	0
object queue header operation	55,344,563	73,996	2,585	71,568	0	0	0
enqueue hash chains	10,314,142	25,583	166	25,428	0	0	0
dml lock allocation	4,521,148	25,039	548	24,522	0	0	0
enqueues	5,849,518	23,551	464	23,098	0	0	0
shared pool	7,388,321	22,418	933	21,530	0	0	0
session idle bit	94,963,788	15,955	298	15,669	0	0	0
channel operations parent latch	1,847,151	15,614	17	15,599	0	0	0
sort extent pool	1,495,492	4,270	69	4,203	0	0	0
checkpoint queue latch	18,192,831	3,401	59	3,345	0	0	0
messages	3,444,046	3,226	44	3,186	0	0	0
lgwr LWN SCN	899,951	1,874	5	1,869	0	0	0
redo writing	3,730,170	994	66	935	0	0	0
SQL memory manager workarea list latch	7,386,182	962	23	940	0	0	0
object queue header heap	5,246,093	890	17	875	0	0	0
post/wait queue	1,582,601	757	2	755	0	0	0
message pool operations parent latch	440,718	613	5	608	0	0	0
channel handle pool latch	437,403	338	7	332	0	0	0
resmgr:actses active list	36,798	290	288	8	0	0	0
object stats modification	430,243	284	8	276	0	0	0
list of block allocation	532,431	254	17	240	0	0	0
session state list latch	73,431	189	185	6	0	0	0
library cache lock allocation	1,856,706	152	5	147	0	0	0
process allocation	14,618	111	134	3	0	0	0
shared pool simulator	1,607,163	69	3	66	0	0	0
parameter table allocation management	27,059	43	28	16	0	0	0
FOB s.o list latch	114,002	32	4	28	0	0	0
parallel query alloc buffer	1,848	23	3	20	0	0	0
active service list	56,351	21	1	20	0	0	0
library cache pin allocation	612,160	19	1	18	0	0	0
KWQMN job cache list latch	6,123	11	10	1	0	0	0
parallel query stats	168	11	1	10	0	0	0
query server process	8	7	7	0	0	0	0
resmgr:free threads list	24,661	3	2	1	0	0	0
commit callback allocation	89,393	1	1	0	0	0	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	NoWait Misses	Sleeps	Waiter Sleeps
FOB s.o list latch	ksfd_allfob	0	3	4
FOB s.o list latch	ksfd_fobd	0	1	0
In memory undo latch	kturbk	0	45,647	48,395
In memory undo latch	ktiFlush: child	0	10,833	3,946
In memory undo latch	kticmt: child	0	2,389	903
In memory undo latch	ktichg: child	0	906	6,648
In memory undo latch	ktiTxnPoolFree	0	421	2
In memory undo latch	ktbgfc	0	51	388
In memory undo latch	ktiBRacquire	0	34	0
In memory undo latch	ktuswr	0	1	0
KWQMN job cache list latch	kwqmnuji: update job item	0	10	4
SQL memory manager workarea list latch	qesmmIUnRegisterWorkArea	0	12	4
SQL memory manager workarea list latch	qesmmIRegisterWorkArea	0	11	19
active service list	ksws_event: ksws event	0	1	0
cache buffer handles	kcbzgs	0	1,924	1,815
cache buffer handles	kcbzfs	0	1,393	1,502
cache buffers chains	kcbchg: kslbegin: bufs not pinned	0	549,721	651,303
cache buffers chains	kcbgtcr: kslbegin excl	0	328,043	276,691
cache buffers chains	kcbgtcr: fast path	0	310,486	10,685
cache buffers chains	kcbrls: kslbegin	0	284,937	341,570
cache buffers chains	kcbchg: kslbegin: call CR func	0	94,766	340,365
cache buffers chains	kcbzgb: scan from tail. nowait	0	45,462	0
cache buffers chains	kcbget: pin buffer	0	20,383	3,957
cache buffers chains	kcbgcur: kslbegin	0	20,271	8,306
cache buffers chains	kcbzwb	0	5,265	2,439
cache buffers chains	kcbget: exchange rls	0	2,482	1,445
cache buffers chains	kcbget: exchange	0	2,012	2,784
cache buffers chains	kcbcge	0	315	3,481
cache buffers chains	kcb_is_private	0	127	264
cache buffers chains	kcbnlc	0	101	381
cache buffers chains	kcbso1: set no access	0	42	66
cache buffers chains	kcbgtcr: kslbegin shared	0	33	13
cache buffers chains	kcbesc: escalate	0	29	4
cache buffers chains	kcbzib: finish free bufs	0	20	36
cache buffers chains	kcbnew: new latch again	0	13	2
cache buffers chains	kcb_pre_apply: kcbhq61	0	8	660
cache buffers chains	kcb_post_apply: kcbhq62	0	7	22
cache buffers chains	kcbbic2	0	6	1
cache buffers chains	kcb_post_apply: kcbhq63	0	1	7
cache buffers chains	kcbbxsv	0	1	1
cache buffers lru chain	kcbzgws	0	3,292	0
cache buffers lru chain	kcbzgb: posted for free bufs	0	647	2,040
cache buffers lru chain	kcbzswcu	0	427	392
cache buffers lru chain	kcbgtcr:CR Scan:KCBRSKIP	0	298	0
cache buffers lru chain	kcbo_link_q	0	236	37
cache buffers lru chain	kcbbxsv: move to being written	0	75	1,124
cache buffers lru chain	kcbbic2	0	36	1,080
cache buffers lru chain	kcbbwlru	0	32	221
cache buffers lru chain	kcbo_ivd_proc	0	21	259
cache buffers lru chain	kcbzar: KSLNBEGIN	0	1	0
channel handle pool latch	ksrchconnect()	0	6	3
channel handle pool latch	ksrchdelete()	0	2	9
channel operations parent latch	ksrchdelete()	0	20	3
channel operations parent latch	ksrapublish()	0	14	0
channel operations parent latch	ksrchconnect()	0	6	6
channel operations parent latch	ksrmfree()	0	2	10
channel operations parent latch	ksrwait()	0	2	20
channel operations parent latch	ksrsconsume()	0	1	8
checkpoint queue latch	kcbklbc: Link buffer into ckpt queue	0	42	1
checkpoint queue latch	kcbswcu: Switch buffers	0	15	15
checkpoint queue latch	kcbbwthc: thread checkpoint buffers	0	2	36
commit callback allocation	ktcccod	0	1	0
dml lock allocation	ktaiam	0	393	383
dml lock allocation	ktaidm	0	155	165
enqueue hash chains	ksqgtl3	0	75	77
enqueue hash chains	ksqrcl	0	53	60
enqueue hash chains	ksqcmi: kslgpl	0	18	9
enqueue hash chains	ksqcmi: if deadlock detected	0	12	1
enqueue hash chains	ksqcmi: get hash chain latch after wait	0	7	19
enqueue hash chains	ksqcnl	0	1	0
enqueues	ksqies	0	197	283
enqueues	ksqgel: create enqueue	0	166	123
enqueues	ksqdel	0	97	57
enqueues	ksqgtl2	0	3	0
lgwr LWN SCN	kcs023	0	68	0
library cache	kglpnp: child	0	12,344	14,294
library cache	kglpndl: child: after processing	0	11,493	1,482
library cache	kglobpn: child:	0	2,438	4,550
library cache	kglpndl: child: before processing	0	2,115	8,844
library cache	kglLockCursor	0	854	985
library cache	kglScanDependency	0	415	0
library cache	kglpin	0	358	154
library cache	kglhdgn: child:	0	307	420
library cache	kgldte: child 0	0	302	394
library cache	kgldti: 2child	0	46	16
library cache	kglic	0	34	0
library cache	kglhdgc: child:	0	17	8
library cache	kglivl: child	0	8	0
library cache	kglhdiv: child	0	7	0
library cache	kglobld	0	4	1
library cache	kgldrp: child	0	2	0
library cache	kgldtld: 2child	0	2	0
library cache	kglukp: child	0	2	1
library cache	kglupd: child	0	2	0
library cache	kglget: unpin heap 0	0	1	5
library cache	kglini: child	0	1	0
library cache	kglpin: child: KGLMX	0	1	0
library cache	kglrtl	0	1	0
library cache lock	kgllkdl: child: cleanup	0	639	568
library cache lock	kgllkal: child: multiinstance	0	407	478
library cache lock	kgllkdl: child: no lock handle	0	189	56
library cache lock allocation	kgllkget	0	5	4
library cache pin	kglpndl	0	7,306	5,625
library cache pin	kglpnp: child	0	6,709	7,527
library cache pin	kglpnal: child: alloc space	0	992	1,855
library cache pin allocation	kglpnget	0	1	1
list of block allocation	ktlabl	0	15	16
list of block allocation	ktlbbl	0	2	1
message pool operations parent latch	ksrmalloc()	0	6	2
message pool operations parent latch	ksrmfree()	0	1	5
messages	ksaamb: after wakeup	0	40	21
messages	ksarcv	0	3	23
messages	ksarcv: after wait	0	1	0
mostly latch-free SCN	kcslcu3	0	280	353
mostly latch-free SCN	kcs024	0	5	0
object queue header heap	kcbo_link_q:reget	0	10	7
object queue header heap	kcbw_link_q:alloc	0	5	10
object queue header heap	kcbw_unlink_q	0	2	0
object queue header operation	kcbo_ivbo	0	5,705	1,676
object queue header operation	kcbw_unlink_q	0	782	1,131
object queue header operation	kcbw_link_q	0	551	554
object queue header operation	kcbo_switch_cq	0	76	630
object queue header operation	kcbo_write_q	0	48	0
object queue header operation	kcbo_service_ockpt	0	43	0
object queue header operation	kcbo_switch_q_bg	0	35	286
object queue header operation	kcbo_link_q:reget	0	21	82
object queue header operation	kcbo_swap_buf	0	21	110
object queue header operation	kcbo_swap_buf_bg	0	10	2,167
object queue header operation	kcbo_switch_mq_bg	0	9	899
object stats modification	ksoslinelm	0	8	7
parallel query alloc buffer	kxfpbfre	0	2	2
parallel query alloc buffer	kxfpbalo	0	1	1
parallel query stats	kxfprst: KSLBEGIN:1	0	1	1
parameter table allocation management	ksp_param_table_free	0	28	27
post/wait queue	ksliwat:add:nowait	0	1	0
post/wait queue	ksliwat:remove	0	1	0
process allocation	ksucrp	0	100	0
process allocation	ksuapc	0	25	55
process allocation	ksufap: active procs	0	6	6
process allocation	ksudlp	0	1	71
query server process	kxfpg1srv	0	7	7
redo allocation	kcrfw_redo_gen: redo allocation 1	0	7,855	0
redo allocation	kcrfw_redo_gen: redo allocation 3	0	2,008	8,959
redo allocation	kcrfw_redo_gen: redo allocation 2	0	909	0
redo allocation	kcrfw_redo_write: before write	0	243	1,087
redo allocation	kcrfw_redo_write: more space	0	219	1,188
redo writing	kcrfw_post: rba scn pair	0	32	0
redo writing	kcrfw_post: after write	0	19	3
redo writing	kcrfws: in loop	0	7	7
redo writing	kcrfwcr	0	4	54
redo writing	kcrfw_cal_target_rba	0	3	1
redo writing	kcrfwfl: stop redo	0	1	1
resmgr:actses active list	kgskchclass	0	287	105
resmgr:actses active list	kgskactladd	0	1	151
resmgr:free threads list	kgskthrcreate	0	1	2
resmgr:free threads list	kgskthrsod	0	1	0
row cache objects	kqreqd: reget	0	6,150	524
row cache objects	kqrpre: find obj	0	2,040	6,224
row cache objects	kqreqd	0	971	2,473
row cache objects	kqrso	0	80	28
row cache objects	kqrpiv	0	7	15
row cache objects	kqrpup	0	1	0
sequence cache	kdnssd	0	331	27
sequence cache	kdnnxt: cached seq	0	46	16
sequence cache	kdnss	0	36	368
session allocation	ksuxds: KSUSFCLC not set	0	3,790	38
session allocation	ksuprc	0	1,255	1,536
session allocation	ksucri	0	1,073	2,843
session allocation	ksuxds: not user session	0	938	1,421
session allocation	ksudlc	0	781	2,132
session allocation	ksudlp	0	160	10
session allocation	ksursi	0	10	19
session allocation	kxfpqidqr	0	8	17
session allocation	kxfprdp	0	7	3
session allocation	ksucrp	0	3	10
session allocation	ksuxds: KSUSFCLC set	0	3	0
session allocation	ksusroll	0	2	1
session idle bit	ksupuc: set busy	0	277	115
session idle bit	ksupuc: clear busy	0	135	300
session idle bit	ksuxds	0	26	23
session state list latch	kpseqd	0	179	0
session state list latch	kpscad	0	5	1
session state list latch	kpscdl	0	1	57
shared pool	kghalo	0	535	312
shared pool	kghfrunp: clatch: nowait	0	279	0
shared pool	kghupr1	0	232	397
shared pool	kghfre	0	131	191
shared pool	kghalp	0	19	29
shared pool	kghfrunp: clatch: wait	0	17	10
shared pool	kghfrunp: alloc: wait	0	13	0
shared pool	kghasp	0	1	4
shared pool	kghfrh	0	1	1
shared pool simulator	kglsim_unpin_simhp	0	3	3
sort extent pool	ktstdt: dealloc sort extent	0	51	6
sort extent pool	ktstdt: return extent	0	6	5
sort extent pool	ktstaddextent1	0	4	1
sort extent pool	ktstcrtobj	0	3	0
sort extent pool	ktstsmonmsg	0	3	66
sort extent pool	ktstallobj1	0	2	4
undo global data	kturimugur: child	0	34,683	28,427
undo global data	ktudba: KSLBEGIN	0	4,167	13,071
undo global data	ktusmasp: ktugd_tuux	0	2,340	24
undo global data	ktumof: KSLBEGIN	0	111	1
undo global data	ktudnx:child	0	106	57
undo global data	ktucof: at start	0	93	0
undo global data	ktufrbs: child	0	90	68
undo global data	ktusmupst: KSLBEGIN	0	46	0
undo global data	ktubnd:child	0	38	14
undo global data	ktusm_begin_fu	0	1	0
undo global data	ktuswr: other segs	0	1	0

Back to Latch Statistics
Back to Top

 

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

 

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

 

Segment Statistics

• Segments by Logical Reads
• Segments by Physical Reads
• Segments by Row Lock Waits
• Segments by ITL Waits
• Segments by Buffer Busy Waits

Back to Top

Segments by Logical Reads

• Total Logical Reads: 2,312,580,606
• Captured Segments account for 29.8% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Logical Reads	%Total
GL	APPS_TS_TX_IDX	GL_CODE_COMBINATIONS_U1		INDEX	50,607,472	2.19
AR	APPS_TS_TX_INTERFACE	RA_INTERFACE_LINES_ALL		TABLE	43,285,120	1.87
APPLSYS	APPS_TS_TX_IDX	FND_GRANTS_N9		INDEX	40,490,160	1.75
QP	APPS_TS_TX_IDX	QP_LIST_LINES_N5		INDEX	40,449,568	1.75
INV	APPS_TS_TX_IDX	MTL_SYSTEM_ITEMS_B_N1		INDEX	28,285,568	1.22

Back to Segment Statistics
Back to Top

Segments by Physical Reads

• Total Physical Reads: 1,463,914
• Captured Segments account for 36.8% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Reads	%Total
AR	APPS_TS_TX_INTERFACE	RA_INTERFACE_LINES_ALL		TABLE	379,859	25.95
GL	APPS_ASSM_DATA	GL_JE_LINES		TABLE	37,586	2.57
WSH	APPS_TS_TX_DATA	WSH_DELIVERY_DETAILS		TABLE	14,175	0.97
AR	APPS_ASSM_DATA	RA_CUST_TRX_LINE_GL_DIST_ALL		TABLE	13,208	0.90
AR	APPS_ASSM_DATA	RA_CUSTOMER_TRX_LINES_ALL		TABLE	12,746	0.87

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	Subobject Name	Obj. Type	Row Lock Waits	% of Capture
AR	APPS_ASSM_IDX	RA_CUST_TRX_LINE_GL_DIST_U1		INDEX	5,483	21.20
APPLSYS	APPS_TS_TX_IDX	WF_ITEM_ACTIVITY_STATUSES_N1		INDEX	2,005	7.75
HR	APPS_ASSM_IDX	PAY_RUN_RESULT_VALUES_PK		INDEX	1,755	6.78
HR	APPS_TS_TX_IDX	PAY_ACTION_INTERLOCKS_PK		INDEX	1,696	6.56
APPLSYS	APPS_TS_TX_DATA	FND_CONCURRENT_REQUESTS		TABLE	1,516	5.86

Back to Segment Statistics
Back to Top

Segments by ITL Waits

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

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	ITL Waits	% of Capture
SYS	SYSTEM	COL$		TABLE	803	93.92
AR	APPS_ASSM_IDX	RA_CUST_TRX_LINE_GL_DIST_N5		INDEX	21	2.46
AR	APPS_ASSM_IDX	RA_CUST_TRX_LINE_GL_DIST_N1		INDEX	8	0.94
GL	APPS_ASSM_IDX	GL_INTERFACE_N4		INDEX	4	0.47
AR	APPS_ASSM_IDX	RA_CUST_TRX_LINE_GL_DIST_N6		INDEX	4	0.47

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
APPLSYS	APPS_TS_TX_DATA	WF_ITEM_ATTRIBUTE_VALUES		TABLE	117,456	26.65
AR	APPS_ASSM_IDX	RA_CUST_TRX_LINE_GL_DIST_U1		INDEX	94,067	21.34
AR	APPS_TS_TX_INTERFACE	RA_INTERFACE_LINES_ALL		TABLE	24,728	5.61
AR	APPS_TS_TX_INTERFACE	RA_INTERFACE_LINES_N2		INDEX	20,476	4.65
GL	APPS_ASSM_DATA	GL_JE_LINES		TABLE	19,944	4.53

Back to Segment Statistics
Back to Top

 

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	Scan Reqs	Pct Miss	Mod Reqs	Final Usage
dc_awr_control	5	0.00	0		2	1
dc_constraints	648	47.07	0		648	169
dc_global_oids	7,970,878	0.00	0		0	69
dc_histogram_data	7,119	3.24	0		0	1,478
dc_histogram_defs	470,408	1.81	0		4,042	15,101
dc_object_grants	151,604	0.03	0		0	469
dc_object_ids	13,315,950	0.01	0		57	3,892
dc_objects	237,702	0.37	0		824	2,482
dc_profiles	12,254	0.00	0		0	1
dc_rollback_segments	36,454	0.02	0		21	426
dc_segments	386,764	0.23	0		21,434	4,749
dc_sequences	73,039	0.04	0		73,039	147
dc_table_scns	67,643	0.01	0		0	8
dc_tablespace_quotas	21,281	0.09	0		254	56
dc_tablespaces	6,250,159	0.00	0		0	22
dc_usernames	589,803	0.00	0		0	87
dc_users	17,280,514	0.00	0		0	104
kqlsubheap_object	8	25.00	0		0	2
outstanding_alerts	257	0.00	0		1	41

Back to Top

 

Library Cache Activity

• "Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
BODY	773,154	0.01	43,065,231	-0.03	2	0
CLUSTER	61	0.00	151	0.00	0	0
INDEX	15,820	0.35	16,426	0.57	9	0
JAVA DATA	594	0.00	0		0	0
PIPE	56,759	2.42	79,428	1.72	0	0
SQL AREA	4,824	96.46	116,961,263	-0.08	4,596	316
TABLE/PROCEDURE	457,503	0.13	59,018,826	-0.06	388	0
TRIGGER	31,652	0.05	1,413,838	0.00	1	0

Back to Top

 

Memory Statistics

• Process Memory Summary
• SGA Memory Summary
• SGA breakdown difference

Back to Top

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	35,551.48		10.51	6.37	37	37	3,382	3,382
	SQL	3,416.64	1,734.06	1.01	0.65	4	21	3,376	3,375
	Freeable	2,862.63	0.00	1.05	0.60	9		2,724	2,724
	PL/SQL	2,272.80	211.40	0.67	0.87	3	3	3,382	3,382
	JAVA	273.08	271.74	2.28	0.29	5	7	120	120
E	Other	46,264.70		13.79	7.87	41	41	3,355	3,355
	SQL	4,262.58	2,220.52	1.27	0.73	4	21	3,349	3,348
	Freeable	4,007.19	0.00	1.36	0.75	9		2,948	2,948
	PL/SQL	2,815.16	239.28	0.84	0.94	3	3	3,355	3,355
	JAVA	273.07	271.74	2.28	0.29	5	7	120	120

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	8,388,608,000
Fixed Size	2,065,832
Redo Buffers	31,473,664
Variable Size	3,422,567,000

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	239.87	239.87	0.00
java	joxlod exec hp	15.51	15.51	0.00
shared	ASH buffers	50.00	50.00	0.00
shared	CCursor	41.65	54.23	30.19
shared	KGLS heap	48.47		-100.00
shared	KTI-UNDO	53.19	53.19	0.00
shared	PCursor		33.34
shared	PL/SQL DIANA	43.59	41.92	-3.84
shared	PL/SQL MPCODE	74.87	76.75	2.52
shared	db_block_hash_buckets	240.00	240.00	0.00
shared	event statistics per sess	63.28	63.28	0.00
shared	free memory	624.03	58.55	-90.62
shared	library cache	840.57	1,087.19	29.34
shared	parameter table block	60.46	60.69	0.38
shared	private strands	99.77	99.77	0.00
shared	sessions	36.42	36.42	0.00
shared	sql area	368.85	691.20	87.39
shared	trace buffer	52.63	53.44	1.54
	buffer_cache	8,000.00	8,000.00	0.00
	fixed_sga	1.97	1.97	0.00
	log_buffer	30.02	30.02	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

Back to Top

 

Streams CPU/IO Usage

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

Rule Set

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

Resource Limit Stats

• 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
processes	3,355	3,421	3600	3600

Back to Top

 

init.ora Parameters

Parameter Name	Begin value	End value (if different)
O7_DICTIONARY_ACCESSIBILITY	FALSE
_b_tree_bitmap_plans	FALSE
_db_block_hash_latches	1048576
_fast_full_scan_enabled	FALSE
_kks_use_mutex_pin	TRUE
_like_with_bind_as_equality	TRUE
_sort_elimination_cost_ratio	5
_spin_count	20000
_sqlexec_progression_cost	2147483647
_swrf_mmon_dbfus	FALSE
_swrf_mmon_flush	FALSE
_system_trig_enabled	TRUE
background_dump_dest	/data1/app/admin/VIS/bdump
compatible	10.2.0.3
control_files	/OASB/11.5.10/oracle/data/cntrl01.dbf, /OASB/11.5.10/oracle/data/cntrl02.dbf, /OASB/11.5.10/oracle/data/cntrl03.dbf
core_dump_dest	/data1/app/admin/VIS/cdump
cursor_sharing	exact
cursor_space_for_time	FALSE
db_block_checking	false
db_block_checksum	true
db_block_size	8192
db_cache_advice	off
db_cache_size	8388608000
db_files	130
db_name	VIS
db_writer_processes	1
dml_locks	10000
java_pool_size	268435456
job_queue_processes	10
lock_sga	TRUE
log_buffer	30519296
log_checkpoint_timeout	1200
log_checkpoints_to_alert	TRUE
max_dump_file_size	unlimited
nls_comp	binary
nls_date_format	DD-MON-RR
nls_language	american
nls_length_semantics	BYTE
nls_numeric_characters	.,
nls_sort	binary
nls_territory	america
olap_page_pool_size	4194304
open_cursors	1000
optimizer_secure_view_merging	FALSE
parallel_max_servers	8
pga_aggregate_target	12582912000
plsql_optimize_level	2
processes	3600
replication_dependency_tracking	FALSE
session_cached_cursors	500
sessions	7200
shared_pool_reserved_size	41943040
shared_pool_size	3154116608
timed_statistics	TRUE
trace_enabled	FALSE
undo_management	AUTO
undo_tablespace	APPS_UNDOTS1
user_dump_dest	/data1/app/admin/VIS/udump
utl_file_dir	/usr/tmp
workarea_size_policy	AUTO

Back to Top

End of Report