WORKLOAD REPOSITORY report for

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
VIS	127695557	VIS	1	10.2.0.3.0	NO	hpdb1

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	56	21-Dec-07 07:29:58	5224	165.2
End Snap:	57	21-Dec-07 08:30:06	5196	173.2
Elapsed:		60.14 (mins)
DB Time:		731.04 (mins)

 

Report Summary

Cache Sizes

	Begin	End
Buffer Cache:	16,272M	16,240M	Std Block Size:	8K
Shared Pool Size:	3,008M	3,040M	Log Buffer:	16,640K

Load Profile

	Per Second	Per Transaction
Redo size:	9,749,878.59	28,318.58
Logical reads:	577,606.71	1,677.66
Block changes:	56,555.95	164.27
Physical reads:	153.86	0.45
Physical writes:	1,060.48	3.08
User calls:	13,734.63	39.89
Parses:	4,970.41	14.44
Hard parses:	2.55	0.01
Sorts:	3,613.22	10.49
Logons:	3.00	0.01
Executes:	33,426.70	97.09
Transactions:	344.29

% Blocks changed per Read:	9.79	Recursive Call %:	81.43
Rollback per transaction %:	21.38	Rows per Sort:	11.98

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	99.96	Redo NoWait %:	100.00
Buffer Hit %:	99.97	In-memory Sort %:	100.00
Library Hit %:	100.02	Soft Parse %:	99.95
Execute to Parse %:	85.13	Latch Hit %:	98.80
Parse CPU to Parse Elapsd %:	87.70	% Non-Parse CPU:	97.08

Shared Pool Statistics

	Begin	End
Memory Usage %:	71.87	85.39
% SQL with executions>1:	81.94	78.98
% Memory for SQL w/exec>1:	59.00	50.73

Top 5 Timed Events

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
CPU time		40,492		92.3
db file sequential read	374,862	1,798	5	4.1	User I/O
log file sync	495,757	635	1	1.4	Commit
SQL*Net more data from client	2,055,698	563	0	1.3	Network
log file parallel write	924,728	542	1	1.2	System I/O

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): 43862.6s
• 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
DB CPU	40,491.95	92.32
sql execute elapsed time	38,379.14	87.50
PL/SQL execution elapsed time	8,824.01	20.12
inbound PL/SQL rpc elapsed time	8,215.17	18.73
parse time elapsed	1,414.13	3.22
Java execution elapsed time	1,403.03	3.20
hard parse elapsed time	635.81	1.45
repeated bind elapsed time	100.51	0.23
sequence load elapsed time	20.13	0.05
connection management call elapsed time	19.72	0.04
PL/SQL compilation elapsed time	11.06	0.03
hard parse (sharing criteria) elapsed time	6.40	0.01
failed parse elapsed time	3.11	0.01
hard parse (bind mismatch) elapsed time	1.50	0.00
DB time	43,862.61
background elapsed time	2,034.35
background cpu time	968.91

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	432,387	0.00	2,004	5	0.35
System I/O	1,061,996	0.00	699	1	0.85
Commit	495,757	0.00	635	1	0.40
Network	55,857,000	0.00	627	0	44.96
Concurrency	3,255,575	0.16	584	0	2.62
Application	75,570	0.16	481	6	0.06
Other	172,798	28.20	97	1	0.14
Configuration	9,992	40.45	28	3	0.01

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	374,862	0.00	1,798	5	0.30
log file sync	495,757	0.00	635	1	0.40
SQL*Net more data from client	2,055,698	0.00	563	0	1.65
log file parallel write	924,728	0.00	542	1	0.74
enq: TM - contention	114	77.19	311	2724	0.00
latch: cache buffers chains	2,393,035	0.00	193	0	1.93
enq: TX - index contention	52,427	0.00	186	4	0.04
db file parallel write	133,975	0.00	147	1	0.11
db file scattered read	21,897	0.00	135	6	0.02
enq: UL - contention	2,505	1.12	111	44	0.00
cursor: pin S wait on X	5,484	94.00	97	18	0.00
read by other session	33,093	0.00	66	2	0.03
buffer busy waits	774,887	0.00	62	0	0.62
SQL*Net more data to client	1,705,279	0.00	38	0	1.37
PX Deq Credit: send blkd	23,385	0.00	37	2	0.02
enq: TX - row lock contention	483	1.66	36	74	0.00
SQL*Net message to client	52,096,023	0.00	26	0	41.93
enq: TX - allocate ITL entry	101	9.90	25	244	0.00
library cache load lock	838	0.00	24	28	0.00
SQL*Net break/reset to client	72,436	0.00	19	0	0.06
rdbms ipc reply	99	6.06	15	155	0.00
kksfbc child completion	210	81.90	10	46	0.00
os thread startup	75	0.00	8	110	0.00
latch: object queue header operation	47,829	0.00	8	0	0.04
wait list latch free	353	0.00	7	20	0.00
latch: library cache	9,613	0.00	7	1	0.01
control file sequential read	1,570	0.00	7	4	0.00
enq: RO - fast object reuse	32	0.00	5	158	0.00
PX Deq: Signal ACK	531	24.86	5	9	0.00
local write wait	1,444	0.00	4	3	0.00
control file parallel write	1,723	0.00	4	2	0.00
latch: In memory undo latch	12,031	0.00	3	0	0.01
latch: undo global data	3,316	0.00	3	1	0.00
latch: cache buffers lru chain	970	0.00	3	3	0.00
enq: HW - contention	2,693	0.00	2	1	0.00
buffer deadlock	48,439	99.01	2	0	0.04
latch free	2,107	0.00	2	1	0.00
enq: TX - contention	3,151	0.00	2	1	0.00
latch: library cache pin	2,437	0.00	2	1	0.00
LGWR wait for redo copy	31,794	0.00	1	0	0.03
enq: DV - contention	169	0.00	1	4	0.00
row cache lock	1,230	0.00	1	1	0.00
latch: redo allocation	1,859	0.00	1	0	0.00
enq: SQ - contention	3,028	0.00	1	0	0.00
latch: session allocation	1,378	0.00	1	0	0.00
latch: row cache objects	884	0.00	1	1	0.00
latch: object queue header heap	255	0.00	0	2	0.00
cursor: pin S	5,427	0.00	0	0	0.00
latch: library cache lock	457	0.00	0	1	0.00
latch: shared pool	387	0.00	0	1	0.00
enq: FB - contention	581	0.00	0	0	0.00
library cache pin	1,439	0.00	0	0	0.00
SGA: allocation forcing component growth	7	71.43	0	19	0.00
write complete waits	6	16.67	0	21	0.00
latch: messages	146	0.00	0	0	0.00
library cache lock	4	0.00	0	9	0.00
reliable message	35	0.00	0	1	0.00
enq: US - contention	5	0.00	0	5	0.00
latch: cache buffer handles	155	0.00	0	0	0.00
undo segment extension	4,037	99.85	0	0	0.00
latch: redo writing	127	0.00	0	0	0.00
PX qref latch	503	89.46	0	0	0.00
direct path read	608	0.00	0	0	0.00
latch: enqueue hash chains	31	0.00	0	0	0.00
enq: PS - contention	39	0.00	0	0	0.00
Streams AQ: qmn coordinator waiting for slave to start	1	0.00	0	6	0.00
cursor: mutex S	193	0.00	0	0	0.00
latch: checkpoint queue latch	22	0.00	0	0	0.00
cursor: mutex X	154	0.00	0	0	0.00
direct path write	439	0.00	0	0	0.00
direct path write temp	38	0.00	0	0	0.00
latch: parallel query alloc buffer	1	0.00	0	0	0.00
direct path read temp	6	0.00	0	0	0.00
SQL*Net message from client	52,096,046	0.00	10,054,749	193	41.93
pipe get	28,800	14.57	21,165	735	0.02
Streams AQ: qmn slave idle wait	2,246	0.04	12,111	5392	0.00
Streams AQ: waiting for messages in the queue	2,374	100.00	11,632	4900	0.00
PX Idle Wait	3,394	77.31	5,634	1660	0.00
Streams AQ: qmn coordinator idle wait	1,645	31.31	3,518	2139	0.00
PL/SQL lock timer	272	100.00	2,993	11005	0.00
jobq slave wait	706	91.64	2,014	2852	0.00
Streams AQ: waiting for time management or cleanup tasks	754	49.47	1,337	1773	0.00
PX Deq: Execution Msg	12,643	0.00	137	11	0.01
PX Deq: Msg Fragment	9,038	0.00	9	1	0.01
PX Deq: Table Q Normal	8,411	0.00	5	1	0.01
PX Deq: Execute Reply	4,910	0.02	5	1	0.00
PX Deq Credit: need buffer	3,365	0.00	4	1	0.00
PX Deq: Join ACK	614	0.00	1	1	0.00
PX Deq: Parse Reply	333	0.00	0	1	0.00
class slave wait	2	0.00	0	3	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	924,745	0.00	542	1	0.74
db file parallel write	133,975	0.00	147	1	0.11
events in waitclass Other	59,304	0.00	7	0	0.05
os thread startup	59	0.00	6	110	0.00
control file sequential read	815	0.00	5	7	0.00
db file scattered read	1,298	0.00	5	4	0.00
control file parallel write	1,723	0.00	4	2	0.00
db file sequential read	1,127	0.00	3	3	0.00
latch: redo writing	127	0.00	0	0	0.00
latch: cache buffers chains	36	0.00	0	0	0.00
direct path read	608	0.00	0	0	0.00
log file sync	3	0.00	0	2	0.00
direct path write	333	0.00	0	0	0.00
latch: library cache lock	3	0.00	0	0	0.00
buffer busy waits	41	0.00	0	0	0.00
latch: shared pool	1	0.00	0	0	0.00
latch: library cache	1	0.00	0	0	0.00
latch: In memory undo latch	1	0.00	0	0	0.00
rdbms ipc message	2,598,910	0.40	35,894	14	2.09
Streams AQ: qmn slave idle wait	1,608	0.00	8,550	5317	0.00
Streams AQ: qmn coordinator idle wait	1,645	31.31	3,518	2139	0.00
smon timer	129,530	0.00	3,466	27	0.10
pmon timer	1,365	86.74	3,436	2517	0.00
Streams AQ: waiting for time management or cleanup tasks	754	49.47	1,337	1773	0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
AVG_BUSY_TIME	187,751
AVG_IDLE_TIME	172,880
AVG_IOWAIT_TIME	7,391
AVG_SYS_TIME	12,994
AVG_USER_TIME	174,647
BUSY_TIME	4,508,878
IDLE_TIME	4,151,938
IOWAIT_TIME	180,067
SYS_TIME	314,552
USER_TIME	4,194,326
LOAD	0
OS_CPU_WAIT_TIME	1,167,454,200
RSRC_MGR_CPU_WAIT_TIME	0
VM_IN_BYTES	4,481,040
VM_OUT_BYTES	0
PHYSICAL_MEMORY_BYTES	###############
NUM_CPUS	24
NUM_CPU_SOCKETS	24

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
SYS$USERS	43,864.40	40,493.60	548,769	2,082,617,858
SYS$BACKGROUND	0.00	0.00	6,722	1,750,520
VIS	0.00	0.00	0	0

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
SYS$USERS	428992	199575	3255421	57783	0	0	55841824	62679
SYS$BACKGROUND	3370	802	142	651	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
4,106	4,077	8	513.22	9.36	ghw9svn8x4vzu	WSHPSRS	BEGIN WSH_PICK_LIST.RELEASE_BA...
2,293	2,292	10	229.30	5.23	bkxrrs52m7d8p	WSHINTERFACE	BEGIN WSH_SHIP_CONFIRM_ACTIONS...
1,673	1,636	12	139.41	3.81	1g4jfpxpupdt6	OEHVIMP	BEGIN OE_BULK_ORDER_IMPORT_PVT...
1,415	1,414	299	4.73	3.23	0z318y6g3uagc	INCTCW	declare l_retstat varchar2 ( 3...
1,143	1,106	152,843	0.01	2.61	3prk3vg9u0abb	JDBC Thin Client	BEGIN FND_GLOBAL.APPS_INITIA...
1,103	1,069	16	68.91	2.51	7g05xfvc5vp74	ARTERRPW	BEGIN arp_run.revenue_recognit...
828	824	156,128	0.01	1.89	9sf243fdjmdmh	JDBC Thin Client	begin fnd_global.apps_initiali...
817	805	1,446	0.57	1.86	bt0w082dfrm8v	WSHINTERFACE	BEGIN WSH_SHIP_CONFIRM_ACTIONS...
788	756	112,898	0.01	1.80	6h2tpcxpymqu7	JDBC Thin Client	BEGIN :1 := FND_AOLJ_UTIL.is_V...
739	705	64,033	0.01	1.69	g8102j8yynbwz	OEXOETEL	begin WF_STANDARD.CONTINUEFLOW...
551	527	57,230	0.01	1.26	gksvm8wmzk8w0	WSHINTERFACE	begin OE_INVOICE_WF.INVOICE_IN...
549	517	57,210	0.01	1.25	4yak7x2zqz0dh	WSHFRREL	BEGIN inv_transfer_order_pvt.f...
546	545	374,382	0.00	1.25	a29grr748ghc4	fnd.framework.navigate.server.OANavigatePortletA	BEGIN jdr_custom_internal.getA...
534	533	984	0.54	1.22	0qcpgw43yqj5r	WSHPSRS	( SELECT DISTINCT WDD.SOURCE_L...
527	517	6,015	0.09	1.20	a957tvxz9w038	icx.por.req.server.RequisitionAM	BEGIN :1 := por_util_pkg.inter...
475	457	57,230	0.01	1.08	9wdrypwkpf607	WSHINTERFACE	begin OE_FULFILL_WF.START_FULF...
473	432	5,000	0.09	1.08	2fjd6cndjby9p	ARTERRPW	INSERT INTO RA_CUST_TRX_LINE_G...
452	451	11	41.06	1.03	1du9v021t8m46	ARGLTP	insert into gl_interface(creat...
451	407	205,543	0.00	1.03	473dq7tb653mp	CSCCCCRC	declare p varchar2(32767); ...
451	444	292,904	0.00	1.03	4dqasqjrvudqn	JDBC Thin Client	begin dbms_session.reset_packa...

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
4,077	4,106	8	509.62	9.36	ghw9svn8x4vzu	WSHPSRS	BEGIN WSH_PICK_LIST.RELEASE_BA...
2,292	2,293	10	229.24	5.23	bkxrrs52m7d8p	WSHINTERFACE	BEGIN WSH_SHIP_CONFIRM_ACTIONS...
1,636	1,673	12	136.37	3.81	1g4jfpxpupdt6	OEHVIMP	BEGIN OE_BULK_ORDER_IMPORT_PVT...
1,414	1,415	299	4.73	3.23	0z318y6g3uagc	INCTCW	declare l_retstat varchar2 ( 3...
1,106	1,143	152,843	0.01	2.61	3prk3vg9u0abb	JDBC Thin Client	BEGIN FND_GLOBAL.APPS_INITIA...
1,069	1,103	16	66.84	2.51	7g05xfvc5vp74	ARTERRPW	BEGIN arp_run.revenue_recognit...
824	828	156,128	0.01	1.89	9sf243fdjmdmh	JDBC Thin Client	begin fnd_global.apps_initiali...
805	817	1,446	0.56	1.86	bt0w082dfrm8v	WSHINTERFACE	BEGIN WSH_SHIP_CONFIRM_ACTIONS...
756	788	112,898	0.01	1.80	6h2tpcxpymqu7	JDBC Thin Client	BEGIN :1 := FND_AOLJ_UTIL.is_V...
705	739	64,033	0.01	1.69	g8102j8yynbwz	OEXOETEL	begin WF_STANDARD.CONTINUEFLOW...
545	546	374,382	0.00	1.25	a29grr748ghc4	fnd.framework.navigate.server.OANavigatePortletA	BEGIN jdr_custom_internal.getA...
533	534	984	0.54	1.22	0qcpgw43yqj5r	WSHPSRS	( SELECT DISTINCT WDD.SOURCE_L...
527	551	57,230	0.01	1.26	gksvm8wmzk8w0	WSHINTERFACE	begin OE_INVOICE_WF.INVOICE_IN...
517	527	6,015	0.09	1.20	a957tvxz9w038	icx.por.req.server.RequisitionAM	BEGIN :1 := por_util_pkg.inter...
517	549	57,210	0.01	1.25	4yak7x2zqz0dh	WSHFRREL	BEGIN inv_transfer_order_pvt.f...
457	475	57,230	0.01	1.08	9wdrypwkpf607	WSHINTERFACE	begin OE_FULFILL_WF.START_FULF...
451	452	11	41.04	1.03	1du9v021t8m46	ARGLTP	insert into gl_interface(creat...
444	451	292,904	0.00	1.03	4dqasqjrvudqn	JDBC Thin Client	begin dbms_session.reset_packa...
432	473	5,000	0.09	1.08	2fjd6cndjby9p	ARTERRPW	INSERT INTO RA_CUST_TRX_LINE_G...
407	451	205,543	0.00	1.03	473dq7tb653mp	CSCCCCRC	declare p varchar2(32767); ...

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,084,268,988
• Captured SQL account for 22.1% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
282,649,243	8	35,331,155.38	13.56	4076.97	4105.74	ghw9svn8x4vzu	WSHPSRS	BEGIN WSH_PICK_LIST.RELEASE_BA...
170,578,875	10	17,057,887.50	8.18	2292.38	2293.02	bkxrrs52m7d8p	WSHINTERFACE	BEGIN WSH_SHIP_CONFIRM_ACTIONS...
147,890,063	12	12,324,171.92	7.10	1636.43	1672.95	1g4jfpxpupdt6	OEHVIMP	BEGIN OE_BULK_ORDER_IMPORT_PVT...
112,125,556	16	7,007,847.25	5.38	1069.47	1102.58	7g05xfvc5vp74	ARTERRPW	BEGIN arp_run.revenue_recognit...
82,394,152	984	83,733.89	3.95	532.78	533.68	0qcpgw43yqj5r	WSHPSRS	( SELECT DISTINCT WDD.SOURCE_L...
48,660,453	1,446	33,651.77	2.33	805.42	817.17	bt0w082dfrm8v	WSHINTERFACE	BEGIN WSH_SHIP_CONFIRM_ACTIONS...
48,155,508	11	4,377,773.45	2.31	451.49	451.71	1du9v021t8m46	ARGLTP	insert into gl_interface(creat...
48,132,541	299	160,978.40	2.31	1413.75	1414.98	0z318y6g3uagc	INCTCW	declare l_retstat varchar2 ( 3...
46,888,601	64,033	732.26	2.25	704.81	739.24	g8102j8yynbwz	OEXOETEL	begin WF_STANDARD.CONTINUEFLOW...
40,136,637	1,592,991	25.20	1.93	332.31	350.89	66tmsr3446uqn	OEXOETEL	SELECT WIAS.ACTIVITY_STATUS, ...
39,426,070	57,210	689.15	1.89	516.55	549.19	4yak7x2zqz0dh	WSHFRREL	BEGIN inv_transfer_order_pvt.f...
38,859,750	11	3,532,704.55	1.86	312.02	312.02	bp8crdjba8zgt	ARGLTP	update ra_cust_trx_line_gl_dis...
38,137,050	57,230	666.38	1.83	457.08	474.84	9wdrypwkpf607	WSHINTERFACE	begin OE_FULFILL_WF.START_FULF...
36,867,845	5,000	7,373.57	1.77	432.14	473.49	2fjd6cndjby9p	ARTERRPW	INSERT INTO RA_CUST_TRX_LINE_G...
33,039,573	173,995	189.89	1.59	399.49	430.24	3b3psftuyks81	INVTTMTX	BEGIN INV_TXNSTUB_PUB.postTran...
33,035,427	173,995	189.86	1.58	384.53	415.13	gf1u933c95jb5	INVTTMTX	DECLARE l_ret_stat varchar2...
31,281,507	57,230	546.59	1.50	527.24	551.20	gksvm8wmzk8w0	WSHINTERFACE	begin OE_INVOICE_WF.INVOICE_IN...
30,800,765	9,061,718	3.40	1.48	271.21	278.65	c4y7jp0q2awbf	? @blade1.ebs.hp.com (TNS V1-V3)	SELECT PROFILE_OPTION_VALUE FR...
30,461,624	152,843	199.30	1.46	1106.05	1143.26	3prk3vg9u0abb	JDBC Thin Client	BEGIN FND_GLOBAL.APPS_INITIA...
29,948,189	9,075	3,300.08	1.44	310.89	311.19	by0sg8ccaazuk	OEXOETEL	UPDATE MRP_ATP_SCHEDULE_TEMP S...
26,379,689	10,000	2,637.97	1.27	199.50	369.26	64qc329wgjv39	PYUSLV	select /*+ ORDERED INDEX(ASS...
24,825,531	205,543	120.78	1.19	407.41	451.31	473dq7tb653mp	CSCCCCRC	declare p varchar2(32767); ...
21,391,043	156,147	136.99	1.03	336.38	336.45	bcym7s1bp0wxs	OEXOETEL	SELECT WIA.NAME FROM WF_ITEM_A...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

• Total Disk Reads: 555,188
• Captured SQL account for 10.3% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
54,451	10,000	5.45	9.81	199.50	369.26	64qc329wgjv39	PYUSLV	select /*+ ORDERED INDEX(ASS...
36,147	21,635	1.67	6.51	241.48	403.63	1q78dwnrrkf6c	asn.lead.server.LeadUwqAM	BEGIN ASN_SALES_PVT.Lead_Proce...
11,456	205,543	0.06	2.06	407.41	451.31	473dq7tb653mp	CSCCCCRC	declare p varchar2(32767); ...
2,236	12	186.33	0.40	1636.43	1672.95	1g4jfpxpupdt6	OEHVIMP	BEGIN OE_BULK_ORDER_IMPORT_PVT...
1,212	173,995	0.01	0.22	102.54	106.44	25bkagv1j2xf7	INVTTMTX	INSERT INTO MTL_MATERIAL_TRAN...
858	299	2.87	0.15	1413.75	1414.98	0z318y6g3uagc	INCTCW	declare l_retstat varchar2 ( 3...
663	8	82.88	0.12	3.84	5.77	6djyj1t4djs12	RAXMTR	select /*+ parallel(t, 16) par...
641	64,033	0.01	0.12	704.81	739.24	g8102j8yynbwz	OEXOETEL	begin WF_STANDARD.CONTINUEFLOW...
522	8	65.25	0.09	4076.97	4105.74	ghw9svn8x4vzu	WSHPSRS	BEGIN WSH_PICK_LIST.RELEASE_BA...
261	152,843	0.00	0.05	1106.05	1143.26	3prk3vg9u0abb	JDBC Thin Client	BEGIN FND_GLOBAL.APPS_INITIA...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

• Total Executions: 120,618,792
• Captured SQL account for 29.1% of Total

Executions	Rows Processed	Rows per Exec	CPU per Exec (s)	Elap per Exec (s)	SQL Id	SQL Module	SQL Text
9,061,718	3,622,706	0.40	0.00	0.00	c4y7jp0q2awbf	? @blade1.ebs.hp.com (TNS V1-V3)	SELECT PROFILE_OPTION_VALUE FR...
7,378,622	5,990,697	0.81	0.00	0.00	6cjfxb1c4kx16	? @blade1.ebs.hp.com (TNS V1-V3)	SELECT PROFILE_OPTION_ID, APP...
3,018,708	3,018,500	1.00	0.00	0.00	bc7t6t6jfx2n7	? @blade1.ebs.hp.com (TNS V1-V3)	SELECT VERSION FROM FND_CACHE_...
2,817,687	2,817,542	1.00	0.00	0.00	9dvfguzd15kpv	JDBC Thin Client	SELECT VALUE FROM V$NLS_PARAME...
1,592,991	823,344	0.52	0.00	0.00	66tmsr3446uqn	OEXOETEL	SELECT WIAS.ACTIVITY_STATUS, ...
780,657	377,936	0.48	0.00	0.00	4g5vzcyf68n9w	? @blade1.ebs.hp.com (TNS V1-V3)	SELECT PROFILE_OPTION_VALUE FR...
637,675	274,474	0.43	0.00	0.00	0wrz2kbatczjk	CSCCCCRC	SELECT EXECUTE_FLAG FROM JTF_U...
596,235	596,215	1.00	0.00	0.00	avc1jqzz04wpr	JDBC Thin Client	SELECT 'x' FROM DUAL
504,444	504,437	1.00	0.00	0.00	0w785m9gmw41a	? @blade1.ebs.hp.com (TNS V1-V3)	SELECT USERENV('SESSIONID') FR...
503,122	295,353	0.59	0.00	0.00	5as61q63aqmts	? @blade1.ebs.hp.com (TNS V1-V3)	SELECT A.APPLICATION_SHORT_NAM...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 17,935,494
• Captured SQL account for 41.7% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
599,906	7,378,622	3.34	6cjfxb1c4kx16	? @blade1.ebs.hp.com (TNS V1-V3)	SELECT PROFILE_OPTION_ID, APP...
596,218	596,235	3.32	avc1jqzz04wpr	JDBC Thin Client	SELECT 'x' FROM DUAL
554,443	9,061,718	3.09	c4y7jp0q2awbf	? @blade1.ebs.hp.com (TNS V1-V3)	SELECT PROFILE_OPTION_VALUE FR...
374,377	374,382	2.09	a29grr748ghc4	fnd.framework.navigate.server.OANavigatePortletA	BEGIN jdr_custom_internal.getA...
346,937	346,944	1.93	fmfdkztk8vx23		SELECT CATEGORY, SEVERITY, F...
301,279	504,444	1.68	0w785m9gmw41a	? @blade1.ebs.hp.com (TNS V1-V3)	SELECT USERENV('SESSIONID') FR...
299,948	503,120	1.67	29x3dahwzdj8b	? @blade1.ebs.hp.com (TNS V1-V3)	SELECT U.USER_NAME, NVL(U.EMP...
299,948	503,122	1.67	5as61q63aqmts	? @blade1.ebs.hp.com (TNS V1-V3)	SELECT A.APPLICATION_SHORT_NAM...
299,948	3,018,708	1.67	bc7t6t6jfx2n7	? @blade1.ebs.hp.com (TNS V1-V3)	SELECT VERSION FROM FND_CACHE_...
299,947	503,118	1.67	95pbs94n69z3d	? @blade1.ebs.hp.com (TNS V1-V3)	SELECT NVL(MULTI_ORG_FLAG, 'N...
299,944	299,949	1.67	fhqzxap2n0ybj	? @blade1.ebs.hp.com (TNS V1-V3)	select NAME from HR_OPERATING_...
299,942	503,106	1.67	bvyqm6268u2as	? @blade1.ebs.hp.com (TNS V1-V3)	SELECT NODE_NAME FROM FND_NODE...
289,434	289,436	1.61	cwyx16zn1hpfb	JDBC Thin Client	select parameter, value from ...
205,543	205,543	1.15	473dq7tb653mp	CSCCCCRC	declare p varchar2(32767); ...

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
11,605,288	8	0.36	b3an778qn1q49	RAXMTR	select /*+ parallel(t, 16) par...
9,221,664	8	0.29	610p9aymv2pcv	RAXMTR	select /*+ parallel(t, 16) par...
3,405,177	8	0.11	6djyj1t4djs12	RAXMTR	select /*+ parallel(t, 16) par...
1,877,555	7,200	0.06	8ay7m8qubw98j	POXBWVRP	select * from PO_TAX_LINES_SUM...

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
0qcpgw43yqj5r	( SELECT DISTINCT WDD.SOURCE_LINE_ID, WDD.SOURCE_HEADER_ID, WDD.ORGANIZATION_ID, WDD.INVENTORY_ITEM_ID, WDD.MOVE_ORDER_LINE_ID, WDD.DELIVERY_DETAIL_ID, WDD.SHIP_MODEL_COMPLETE_FLAG, WDD.TOP_MODEL_LINE_ID, WDD.SHIP_FROM_LOCATION_ID, NULL SHIP_METHOD_CODE, WDD.SHIPMENT_PRIORITY_CODE, WDD.DATE_SCHEDULED DATE_SCHEDULED, WDD.REQUESTED_QUANTITY, WDD.REQUESTED_QUANTITY_UOM, WDD.PREFERRED_GRADE, WDD.REQUESTED_QUANTITY2, WDD.REQUESTED_QUANTITY_UOM2, WDD.PROJECT_ID, WDD.TASK_ID, WDD.SUBINVENTORY FROM_SUBINVENTORY_CODE, WDD.SUBINVENTORY TO_SUBINVENTORY_CODE, WDD.RELEASED_STATUS RELEASED_STATUS, WDD.SHIP_SET_ID SHIP_SET_ID, WDD.SOURCE_CODE SOURCE_CODE, WDD.SOURCE_HEADER_NUMBER SOURCE_HEADER_NUMBER, NULL PLANNED_DEPARTURE_DATE, WDA.DELIVERY_ID, OL.END_ITEM_UNIT_NUMBER, OL.SOURCE_DOCUMENT_TYPE_ID, MSI.RESERVABLE_TYPE, WDD.LAST_UPDATE_DATE, -1 DEMAND_SOURCE_HEADER_ID, -1 OUTSTANDING_ORDER_VALUE FROM WSH_DELIVERY_DETAILS WDD, WSH_DELIVERY_ASSIGNMENTS WDA, OE_ORDER_LINES_ALL OL, MTL_SYSTEM_ITEMS MSI , MTL_CATEGORY_SETS MCS, MTL_ITEM_CATEGORIES MIC WHERE WDD.DATE_SCHEDULED IS NOT NULL AND WDA.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID AND NVL(WDD.REQUESTED_QUANTITY, 0) > 0 AND WDD.SOURCE_LINE_ID = OL.LINE_ID AND WDD.SOURCE_CODE = 'OE' AND WDD.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID AND WDD.ORGANIZATION_ID = MSI.ORGA NIZATION_ID AND WDD.RELEASED_STATUS IN ( 'R', 'X') AND WDD.SHIP_FROM_LOCATION_ID = :X_ship_from_loc_id AND WDD.ORGANIZATION_ID = :X_org_id AND (WDA.DELIVERY_ID IS NULL ) AND (NVL(WDD.DEP_PLAN_REQUIRED_FLAG, 'N') = 'N' OR (NVL(WDD.DEP_PLAN_REQUIRED_FLAG, 'N') = 'Y' AND EXISTS ( SELECT 1 FROM WSH_NEW_DELIVERIES WDE1 WHERE WDE1.DELIVERY_ID = WDA.DELIVERY_ID AND ( NVL(WDE1.PLANNED_FLAG, 'N') IN ('Y', 'F' ) )) )) AND MCS.category_set_id = MIC.category_set_id AND MCS.category_set_id = :x_CategorySetID AND MIC.category_id = :x_CategoryID AND MIC.organization_id = WDD.organization_id AND MIC.inventory_item_id = WDD.inventory_item_id ) ORDER BY WDD.INVENTORY_ITEM_ID, DATE_SCHEDULED ASC, SHIPMENT_PRIORITY_CODE ASC, to_number(SOURCE_HEADER_NUMBER) ASC, SHIP_FROM_LOCATION_ID
0w785m9gmw41a	SELECT USERENV('SESSIONID') FROM SYS.DUAL
0wrz2kbatczjk	SELECT EXECUTE_FLAG FROM JTF_USER_HOOKS WHERE PKG_NAME = :B4 AND API_NAME = :B3 AND PROCESSING_TYPE = :B2 AND USER_HOOK_TYPE = :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 ;
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))
1g4jfpxpupdt6	BEGIN OE_BULK_ORDER_IMPORT_PVT.ORDER_IMPORT_CONC_PGM( :errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8, :A9, :A10, :A11, :A12); END;
1q78dwnrrkf6c	BEGIN ASN_SALES_PVT.Lead_Process_After_Update( P_Api_Version_Number => 2.0, P_Init_Msg_List => FND_API.G_TRUE, p_Commit => FND_API.G_FALSE, p_Validation_Level => FND_API.G_VALID_LEVEL_NONE, P_Identity_Salesforce_Id => :1, P_Salesgroup_id => :2, P_Sales_Lead_Id => :3, X_Return_Status => :4, X_Msg_Count => :5, X_Msg_Data => :6); END;
25bkagv1j2xf7	INSERT INTO MTL_MATERIAL_TRANSACTIONS ( TRANSACTION_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID, INVENTORY_ITEM_ID, ORGANIZATION_ID, SUBINVENTORY_CODE, LOCATOR_ID, REVISION, TRANSACTION_TYPE_ID, TRANSACTION_ACTION_ID, TRANSACTION_SOURCE_TYPE_ID, TRANSACTION_SOURCE_ID, TRANSACTION_SOURCE_NAME, TRANSACTION_QUANTITY, TRANSACTION_UOM, PRIMARY_QUANTITY, TRANSACTION_DATE, TRANSACTION_COST, ACTUAL_COST, PRIOR_COST, NEW_COST, QUANTITY_ADJUSTED, VARIANCE_AMOUNT, TRANSFER_COST, TRANSPORTATION_COST, TRANSFER_TRANSACTION_ID, TRANSFER_ORGANIZATION_ID, TRANSFER_SUBINVENTORY, TRANSFER_LOCATOR_ID , ACCT_PERIOD_ID, TRANSACTION_REFERENCE, REASON_ID, REPETITIVE_LINE_ID, DEPARTMENT_ID, OPERATION_SEQ_NUM, SHIPMENT_NUMBER, FREIGHT_CODE, WAYBILL_AIRBILL, TRX_SOURCE_LINE_ID, MOVE_ORDER_LINE_ID , COSTED_FLAG , INVOICED_FLAG , DISTRIBUTION_ACCOUNT_ID , ENCUMBRANCE_ACCOUNT , ENCUMBRANCE_A MOUNT , COST_UPDATE_ID , PROJECT_ID , TASK_ID , TO_PROJECT_ID , TO_TASK_ID , LPN_ID , TRANSFER_LPN_ID, CONTENT_LPN_ID , PUT_AWAY_STRATEGY_ID , PUT_AWAY_RULE_ID , PICK_STRATEGY_ID , PICK_RULE_ID , CREATED_BY , COST_GROUP_ID , TRANSFER_COST_GROUP_ID , TRANSACTION_SET_ID , PM_COST_COLLECTED , COST_CATEGORY_ID , ORGANIZATION_TYPE , TRANSFER_ORGANIZATION_TYPE , OWNING_ORGANIZATION_ID , OWNING_TP_TYPE , PLANNING_ORGANIZATION_ID , PLANNING_TP_TYPE , XFR_OWNING_ORGANIZATION_ID , TRANSFER_OWNING_TP_TYPE , XFR_PLANNING_ORGANIZATION_ID , TRANSFER_PLANNING_TP_TYPE , SECONDARY_TRANSACTION_QUANTITY , SECONDARY_UOM_CODE, PICK_SLIP_NUMBER, PICKING_LINE_ID, VENDOR_LOT_NUMBER, SOURCE_CODE, SOURCE_LINE_ID, MOVE_TRANSACTION_ID, RCV_TRANSACTION_ID, COMPLETION_TRANSACTION_ID, CURRENCY_CODE, CURRENCY_CONVERSION_RATE, CURRENCY_CONVERSION_DATE, CURRENCY_CONVERSION_TYPE, MATERIAL_ACCOUNT, MATERIAL_OVERHEAD_ACCOUNT, RESOURCE_ACCOUNT, OUTSIDE_PROCESSING_ACCOUNT, OVERHEAD_ACCOUNT, MOV EMENT_ID, SOURCE_PROJECT_ID, SOURCE_TASK_ID, PA_EXPENDITURE_ORG_ID, EXPENDITURE_TYPE, TRANSFER_PERCENTAGE, ORG_COST_GROUP_ID, COST_TYPE_ID, VALUE_CHANGE, PERCENTAGE_CHANGE, EMPLOYEE_CODE, MASTER_SCHEDULE_UPDATE_CODE, TRX_SOURCE_DELIVERY_ID, RECEIVING_DOCUMENT, TRANSPORTATION_DIST_ACCOUNT, NUMBER_OF_CONTAINERS, RMA_LINE_ID, CYCLE_COUNT_ID, PHYSICAL_ADJUSTMENT_ID, FLOW_SCHEDULE, FINAL_COMPLETION_FLAG, QA_COLLECTION_ID, OVERCOMPLETION_TRANSACTION_QTY, OVERCOMPLETION_PRIMARY_QTY, OVERCOMPLETION_TRANSACTION_ID, COMMON_BOM_SEQ_ID, COMMON_ROUTING_SEQ_ID, MVT_STAT_STATUS, PICK_SLIP_DATE, ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, SHIP_TO_LOCATION_ID, TRANSACTION_MODE, TRANSACTION_BATCH_ID, TRANSACTION_BATCH_SEQ, FOB_POINT, INTRANSIT_ACCOUNT, TRX_FLOW_HEADER_ID, L OGICAL_TRX_TYPE_CODE, ORIGINAL_TRANSACTION_TEMP_ID, SHORTAGE_PROCESS_CODE) VALUES(:1, SYSDATE, :2, SYSDATE, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, ROUND(:17, 5), :18, ROUND(:19, 5), nvl(:20, sysdate), :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, :42, :43, 'N', 'N', :44, :45, :46, :47, :48, :49, :50, :51, :52, :53, :54, :55, :56, :57, :58, :59, :60, :61, :62, :63, :64, :65, :66, :67, :68, :69, :70, :71, :72, :73, :74, :75, :76, :77, :78, :79, :80, :81, :82, :83, :84, :85, :86, :87, :88, :89, :90, :91, :92, :93, :94, :95, :96, :97, :98, :99, :100, :101, :102, :103, :104, :105, :106, :107, :108, :109, :110, :111, :112, :113, :114, :115, :116, :117, :118, :119, :120, 'NEW', :121, :122, :123, :124, :125, :126, :127, :128, :129, :130, :131, :132, :133, :134, :135, :136, :137, :138, :139, :140, :141, :142, :143, :144, :145, :146, :147)
29x3dahwzdj8b	SELECT U.USER_NAME, NVL(U.EMPLOYEE_ID, -1), NVL(U.CUSTOMER_ID, -1), NVL(U.SUPPLIER_ID, -1), NVL(U.PERSON_PARTY_ID, -1) FROM FND_USER U WHERE U.USER_ID = :B1
2fjd6cndjby9p	INSERT INTO RA_CUST_TRX_LINE_GL_DIST ( CUSTOMER_TRX_LINE_ID, CUSTOMER_TRX_ID, CODE_COMBINATION_ID, SET_OF_BOOKS_ID, ACCOUNT_CLASS, ACCOUNT_SET_FLAG, PERCENT, AMOUNT, ACCTD_AMOUNT, GL_DATE, CUST_TRX_LINE_SALESREP_ID, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, POSTING_CONTROL_ID, ORIGINAL_GL_DATE, CUST_TRX_LINE_GL_DIST_ID ) SELECT /*+ ORDERED */ ASS.CUSTOMER_TRX_LINE_ID, LINES.CUSTOMER_TRX_ID, DIST.CODE_COMBINATION_ID, :B12 , ASS.ACCOUNT_CLASS, 'N', ROUND( (DECODE(FC.MINIMUM_ACCOUNTABLE_UNIT, NULL, ROUND( (DIST.PERCENT/100) * DECODE(ASS.AMOUNT, 0, DECODE(ASS.ACCOUNT_CLASS, 'REV', DECODE( LINES.PREVIOUS_CUSTOMER_TRX_ID, NULL, 1, -1 ), DECODE( LINES.PREVIOUS_CUSTOMER_TRX_ID, NULL, -1, 1 ) ), ASS.AMOUNT ), FC.PRECISION), ROUND( ((DIST.PERCENT/100) * DECODE(ASS.AMOUNT, 0, DECODE(ASS.ACCOUNT_CLASS, 'REV', DECODE( LINES.PREVIOUS_CUSTOMER_TRX_ID, NULL, 1, -1), DECODE( LINES.PREVIOUS_CUSTOMER_TRX_ID, NULL, -1, 1) ), ASS.AMOUNT) ) / FC.MINIMUM_ACCOUNTABLE_UNIT) * FC.MINIMUM_ACCOUNTABLE_UNIT) / DECODE(LINES.EXTENDED_AMOUNT, 0, 1, LINES.EXTENDED_AMOUNT)) * DECODE(ASS.AMOUNT, 0, 0, 100), 4), DECODE(FC.MINIMUM_ACCOUNTABLE_UNIT, NULL, ROUND( (DIST.PERCENT/100) * ASS.AMOUNT, FC.PRECISION), ROUND( ((DIST.PERCENT/100) * ASS.AMOUNT) / FC.MINIMUM_ACCOUNTABLE_UNIT) * FC.MINIMUM_ACCOUNTABLE_UNIT), DECODE(:B10 , NULL, ROUND( NVL(HEADER.EXCHANGE_ RATE, 1) * DECODE(FC.MINIMUM_ACCOUNTABLE_UNIT, NULL, ROUND( (DIST.PERCENT/100) * ASS.AMOUNT, FC.PRECISION), ROUND( ((DIST.PERCENT/100) * ASS.AMOUNT) / FC.MINIMUM_ACCOUNTABLE_UNIT) * FC.MINIMUM_ACCOUNTABLE_UNIT ), :B11 ), ROUND( ( NVL(HEADER.EXCHANGE_RATE, 1) * DECODE(FC.MINIMUM_ACCOUNTABLE_UNIT, NULL, ROUND( (DIST.PERCENT/100) * ASS.AMOUNT, FC.PRECISION), ROUND( ( (DIST.PERCENT/100) * ASS.AMOUNT) / FC.MINIMUM_ACCOUNTABLE_UNIT) * FC.MINIMUM_ACCOUNTABLE_UNIT ) ) / :B10 ) * :B10 ), DECODE(REC.GL_DATE, NULL, NULL, ARP_AUTO_RULE.ASSIGN_GL_DATE(ASS.GL_DATE) ), DECODE(DIST.CUSTOMER_TRX_ID, HEADER.CUSTOMER_TRX_ID, DIST.CUST_TRX_LINE_SALESREP_ID, CMSREP.CUST_TRX_LINE_SALESREP_ID), :B9 , :B8 , :B7 , SYSDATE, SYSDATE, :B6 , SYSDATE, :B6 , -3, ASS.GL_DATE, RA_CUST_TRX_LINE_GL_DIST_S.NEXTVAL FROM RA_CUSTOMER_TRX HEADER, FND_CURRENCIES FC, RA_CUSTOMER_TRX_LINES LINES, RA_RULES ACC_RULE, RA_CUST_TRX_LINE_GL_DIST REC, RA_CUST_TRX_LINE_GL_DIST DIST, RA_CUST_TRX_LINE_SALESREPS CMSREP, AR_REVENUE_ASSIGNMENTS ASS WHERE HEADER.CUSTOMER_TRX_ID = :B1 AND HEADER.COMPLETE_FLAG = 'Y' AND FC.CURRENCY_CODE = HEADER.INVOICE_CURRENCY_CODE AND LINES.CUSTOMER_TRX_ID = HEADER.CUSTOMER_TRX_ID AND LINES.AUTORULE_COMPLETE_FLAG||'' = 'N' AND ASS.CUSTOMER_TRX_LINE_ID = LINES.CUSTOMER_TRX_LINE_ID AND ASS.PERIOD_SET_NAME = :B5 AND ACC_RULE.RULE_ID = LINES.ACCOUNTING_RULE_ID AND DECODE(HEADER.INVOICING_RULE_ID, -3, :B3 , DECODE(NVL(ACC_RULE.DEFERRED_REVENUE_FLAG, 'N'), 'Y', :B2 , DECODE(:B4 , 'N', :B3 , DECODE(HEADER.PREVIOUS_CUSTOMER_TRX_ID, NULL, AR_REVENUE_MANAGEMENT_PVT.LINE_COLLECTIBILITY(:B1 , LINES.CUSTOMER_TRX_LINE_ID), AR_REVENUE_MANAGEMENT_PVT.CASH_BASED(HEADER.PREVIOUS_CUSTOMER_TRX_ID))))) <> :B2 AND REC.CUSTOMER_TRX_ID = HEADER.CUSTOMER_TRX_ID AND REC.ACCOUNT_CLASS = 'REC' AND REC.LATEST_REC_FLAG = 'Y' AND DIST.CUSTOMER_TRX_LINE_ID = (SELECT DECODE(COUNT(CUST_TRX_LINE_GL_DIST_ID), 0, NVL(LINES.PREVIOUS_CUSTOMER_TRX_LINE_ID, LINES.CUSTOMER_TRX_LINE_ID), LINES.CUSTOMER_TRX_LINE_ID) FROM RA_CUST_TRX_LINE_GL_DIST SUBDIST2 WHERE SUBDIST2.CUSTOMER_TRX_LINE_ID = LINES.CUSTOMER_TRX_LINE_ID AND SUBDIST2.ACCOUNT_SET_FLAG = 'Y' AND SUBDIST2.GL_DATE IS NULL AND ROWNUM < 2 ) AND DIST.ACCOUNT_CLASS = ASS.ACCOUNT_CLASS AND DIST.ACCOUNT_SET_FLAG = 'Y' AND DIST.CUST_TRX_LINE_SALESREP_ID = CMSREP.PREV_CUST_TRX_LINE_SALESREP_ID (+) AND :B1 = CMSREP.CUSTOMER_TRX_ID (+) AND NOT EXISTS ( SELECT 'distribution exists' FROM RA_CUST_TRX_LINE_GL_DIST SUBDIST WHERE SUBDIST.CUSTOMER_TRX_LINE_ID = ASS.CUSTOMER_TRX_LINE_ID AND SUBDIST.CUSTOMER_TRX_ID + 0 = LINES.CUSTOMER_TRX_ID AND SUBDIST.ACCOUNT_SET_FLAG = 'N' AND SUBDIST.ACCOUNT_CLASS = ASS.ACCOUNT_CLASS AND SUBDIST.ORIGINAL_GL_DATE = ASS.GL_DATE )
3b3psftuyks81	BEGIN INV_TXNSTUB_PUB.postTransaction(:1, :2, :3); END;
3prk3vg9u0abb	BEGIN FND_GLOBAL.APPS_INITIALIZE( user_id=>:1 , resp_id=>:2 , resp_appl_id=>:3 , security_group_id=>:4 , server_id=>:5);END;
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;
4dqasqjrvudqn	begin dbms_session.reset_package; end;
4g5vzcyf68n9w	SELECT PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES WHERE PROFILE_OPTION_ID = :B4 AND APPLICATION_ID = :B3 AND LEVEL_ID = 10003 AND LEVEL_VALUE = :B2 AND LEVEL_VALUE_APPLICATION_ID = :B1
4yak7x2zqz0dh	BEGIN inv_transfer_order_pvt.finalize_pick_confirm(:1, :2, :3, :4, :5, :6, :7); END;
5as61q63aqmts	SELECT A.APPLICATION_SHORT_NAME FROM FND_APPLICATION A WHERE A.APPLICATION_ID = :B1
610p9aymv2pcv	select /*+ parallel(t, 16) parallel_index(t, 16) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*), count("COMMENTS"), count(distinct "COMMENTS"), sum(sys_op_opnsize("COMMENTS")), substrb(dump(min(substrb("COMMENTS", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("COMMENTS", 1, 32)), 16, 0, 32), 1, 120), count("INTERNAL_NOTES"), count(distinct "INTERNAL_NOTES"), sum(sys_op_opnsize("INTERNAL_NOTES")), substrb(dump(min(substrb("INTERNAL_NOTES", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("INTERNAL_NOTES", 1, 32)), 16, 0, 32), 1, 120), count("INITIAL_CUSTOMER_TRX_ID"), count(distinct "INITIAL_CUSTOMER_TRX_ID"), sum(sys_op_opnsize("INITIAL_CUSTOMER_TRX_ID")), substrb(dump(min("INITIAL_CUSTOMER_TRX_ID"), 16, 0, 32), 1, 120), substrb(dump(max("INITIAL_CUSTOMER_TRX_ID"), 16, 0, 32), 1, 120), count("USSGL_TRANSACTION_CODE_CONTEXT"), count(distinct "USSGL_TRANSACTION_CODE_CONTEXT"), sum(sys_op_opnsize("USSGL_TRANSACTION_CODE_CONTEXT")), substrb(dump(min("USSGL_TRANSACTION_CODE_CONTEXT"), 16, 0, 32), 1, 120), substrb(dump(max("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")), su bstrb(dump(min("ACCTD_AMOUNT"), 16, 0, 32), 1, 120), substrb(dump(max("ACCTD_AMOUNT"), 16, 0, 32), 1, 120), count("CUSTOMER_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_ATT RIBUTE8")), 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_ATTRIBUTE10"), 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("REFE RENCE_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(distinct "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_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(du mp(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_LINE_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"), su m(sys_op_opnsize("BATCH_SOURCE_NAME")), substrb(dump(min(substrb("BATCH_SOURCE_NAME", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("BATCH_SOURCE_NAME", 1, 32)), 16, 0, 32), 1, 120), count("SET_OF_BOOKS_ID"), count(distinct "SET_OF_BOOKS_ID"), sum(sys_op_opnsize("SET_OF_BOOKS_ID")), substrb(dump(min("SET_OF_BOOKS_ID"), 16, 0, 32), 1, 120), substrb(dump(max("SET_OF_BOOKS_ID"), 16, 0, 32), 1, 120), count(distinct "LINE_TYPE"), sum(sys_op_opnsize("LINE_TYPE")), substrb(dump(min("LINE_TYPE"), 16, 0, 32), 1, 120), substrb(dump(max("LINE_TYPE"), 16, 0, 32), 1, 120), count(distinct "DESCRIPTION"), sum(sys_op_opnsize("DESCRIPTION")), substrb(dump(min(substrb("DESCRIPTION", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("DESCRIPTION", 1, 32)), 16, 0, 32), 1, 120), count(distinct "CURRENCY_CODE"), sum(sys_op_opnsize("CURRENCY_CODE")), substrb(dump(min("CURRENCY_CODE"), 16, 0, 32), 1, 120), substrb(dump(max("CURRENCY_CODE"), 16, 0, 32), 1, 120), count("AMOUNT"), count(distinct "AMOUNT"), sum(sys_op_opnsize("AMOUNT")), substrb(dump(min("AMOUNT"), 16, 0, 32), 1, 120), substrb(dump(max("AMOUNT"), 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(su bstrb("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(distinct "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_LINE_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_METHO D_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(dump(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_opnsi ze("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"), count(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_MET HOD_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), substrb(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("RULE_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(substrb("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), c ount("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"), sum(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(subst rb("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("????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? ????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????
64qc329wgjv39	select /*+ ORDERED INDEX(ASSBAL PAY_ASSIGNMENT_LATEST_BALA_N1) INDEX(DEFBAL PAY_DEFINED_BALANCES_PK) INDEX(ACT PAY_ASSIGNMENT_ACTIONS_PK) INDEX(PACT PAY_PAYROLL_ACTIONS_PK) INDEX(VALUE PAY_BALANCE_CONTEXT_VALUES_PK) USE_NL(ASSBAL DEFBAL ACT PACT VALUE) +*/ ASSBAL.defined_balance_id , DEFBAL.balance_dimension_id , to_char(ASSBAL.value) , ASSBAL.latest_balance_id , ASSBAL.rowid , to_char(ASSBAL.assignment_action_id) , ACT.payroll_action_id , to_char(PACT.effective_date, :b0) , to_number(to_char(PACT.effective_date, 'J')) , nvl(VALUE.context_id, 0) , nvl(VALUE.value, 'NULL') , to_char(ASSBAL.expired_assignment_action_id) , to_char(ASSBAL.expired_value) , to_char(ASSBAL.prev_assignment_action_id) , to_char(ASSBAL.prev_balance_value) from pay_assignment_latest_balances ASSBAL , pay_defined_balances DEFBAL , pay_assignment_actions ACT , pay_payroll_actions PACT , pay_balance_context_values VALUE where ((((ASSBAL.assignment_id=:b1 and ACT.assignment_action_id=ASSBAL.assignment_action_id) and PACT.payroll_action_id=ACT.payroll_action_id) and DEFBAL.defined_balance_id=ASSBAL.defined_balance_id) and VALUE.latest_balance_id(+)=ASSBAL.latest_balance_id) union all select /*+ ORDERED INDEX(PERBAL PAY_PERSON_LATEST_BALANCES_N2) INDEX(DEFBAL PAY_DEFINED_BALANCES_PK) INDEX(ACT PAY_ASSIGNMENT_ACTIONS_PK) INDEX(VALUE PAY_BALANCE_CONTEXT_VALUES_PK) INDEX(PACT PAY_PAYROLL_ACTIONS_PK) USE_NL(PERBAL DEFBAL ACT PACT VALUE) +*/ PERBAL.defined_balance_id , DEFBAL.balance_dimension_id , to_char (PERBAL.value) , PERBAL.latest_balance_id , PERBAL.rowid , to_char(PERBAL.assignment_action_id) , ACT.payroll_action_id , to_char(PACT.effective_date, :b0) , to_number(to_char(PACT.effective_date, 'J')) , nvl(VALUE.context_id, 0) , nvl(VALUE.value, 'NULL') , to_char(PERBAL.expired_assignment_action_id) , to_char(PERBAL.expired_value) , to_char(PERBAL.prev_assignment_action_id) , to_char(PERBAL.prev_balance_value) from pay_person_latest_balances PERBAL , pay_defined_balances DEFBAL , pay_assignment_actions ACT , pay_payroll_actions PACT , pay_balance_context_values VALUE where ((((PERBAL.person_id=:b3 and ACT.assignment_action_id=PERBAL.assignment_action_id) and PACT.payroll_action_id=ACT.payroll_action_id) and DEFBAL.defined_balance_id=PERBAL.defined_balance_id) and VALUE.latest_balance_id(+)=PERBAL.latest_balance_id) order by 6, 2, 1, 4, 10 desc
66tmsr3446uqn	SELECT WIAS.ACTIVITY_STATUS, WIAS.ACTIVITY_RESULT_CODE, WIAS.ASSIGNED_USER, WIAS.NOTIFICATION_ID, WIAS.BEGIN_DATE, WIAS.END_DATE, WIAS.DUE_DATE, WIAS.ERROR_NAME, WIAS.ERROR_MESSAGE, WIAS.ERROR_STACK FROM WF_ITEM_ACTIVITY_STATUSES WIAS WHERE WIAS.ITEM_TYPE = :B3 AND WIAS.ITEM_KEY = :B2 AND WIAS.PROCESS_ACTIVITY = :B1
6cjfxb1c4kx16	SELECT PROFILE_OPTION_ID, APPLICATION_ID, SITE_ENABLED_FLAG , APP_ENABLED_FLAG , RESP_ENABLED_FLAG , USER_ENABLED_FLAG, ORG_ENABLED_FLAG , SERVER_ENABLED_FLAG, HIERARCHY_TYPE FROM FND_PROFILE_OPTIONS WHERE PROFILE_OPTION_NAME = UPPER(:B1 ) AND START_DATE_ACTIVE <= SYSDATE AND NVL(END_DATE_ACTIVE, SYSDATE) >= SYSDATE
6djyj1t4djs12	select /*+ parallel(t, 16) parallel_index(t, 16) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*), count("INTERFACE_SALESCREDIT_ID"), sum(sys_op_opnsize("INTERFACE_SALESCREDIT_ID")), substrb(dump(min("INTERFACE_SALESCREDIT_ID"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_SALESCREDIT_ID"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ID"), count(distinct "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_ATTRIB UTE3")), 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_LINE_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("SALESREP_NUMB ER"), count(distinct "SALESREP_NUMBER"), sum(sys_op_opnsize("SALESREP_NUMBER")), substrb(dump(min("SALESREP_NUMBER"), 16, 0, 32), 1, 120), substrb(dump(max("SALESREP_NUMBER"), 16, 0, 32), 1, 120), count("SALESREP_ID"), count(distinct "SALESREP_ID"), sum(sys_op_opnsize("SALESREP_ID")), substrb(dump(min("SALESREP_ID"), 16, 0, 32), 1, 120), substrb(dump(max("SALESREP_ID"), 16, 0, 32), 1, 120), count("SALES_CREDIT_TYPE_NAME"), count(distinct "SALES_CREDIT_TYPE_NAME"), sum(sys_op_opnsize("SALES_CREDIT_TYPE_NAME")), substrb(dump(min("SALES_CREDIT_TYPE_NAME"), 16, 0, 32), 1, 120), substrb(dump(max("SALES_CREDIT_TYPE_NAME"), 16, 0, 32), 1, 120), count("SALES_CREDIT_TYPE_ID"), count(distinct "SALES_CREDIT_TYPE_ID"), sum(sys_op_opnsize("SALES_CREDIT_TYPE_ID")), substrb(dump(min("SALES_CREDIT_TYPE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("SALES_CREDIT_TYPE_ID"), 16, 0, 32), 1, 120), count("SALES_CREDIT_AMOUNT_SPLIT"), count(distinct "SALES_CREDIT_AMOUNT_SPLIT"), sum(sys_op_opnsize("SALES_CREDIT_AMOUNT_SPLIT")), substrb(dump(min("SALES_CREDIT_AMOUNT_SPLIT"), 16, 0, 32), 1, 120), substrb(dump(max("SALES_CREDIT_AMOUNT_SPLIT"), 16, 0, 32), 1, 120), count("SALES_CREDIT_PERCENT_SPLIT"), count(distinct "SALES_CREDIT_PERCENT_SPLIT"), sum(sys_op_opnsize("SALES_CREDIT_PERCENT_SPLIT")), substrb(dump(min("SALES_CREDIT_PERCENT_SPLIT"), 16, 0, 32), 1, 120), substrb(dump(max("SALES_CREDIT_PERCENT_SPLIT"), 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("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(substrb("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(dist inct "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(substr b("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("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), 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("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("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("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("SALESGROUP_ID"), count(distinct "SALESGROUP_ID"), sum(sys_op_opnsize("SALESGROUP_ID")), substrb(dump(min("SALESGROUP_ID"), 16, 0, 32), 1, 120), substrb(dump(max("SALESGROUP_ID"), 16, 0, 32), 1, 120) from "AR"."RA_INTERFACE_SALESCREDITS_ALL" sample ( 10.0000000000) t
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;
7g05xfvc5vp74	BEGIN arp_run.revenue_recognition( :errbuf, :rc, :A0, :A1, :A2); END;
8ay7m8qubw98j	select * from PO_TAX_LINES_SUMMARY_V where trx_header_id = :b1 ORDER BY trx_header_id, trx_line_id, trx_shipment_id , trx_distribution_id
95pbs94n69z3d	SELECT NVL(MULTI_ORG_FLAG, 'N'), NVL(MULTI_CURRENCY_FLAG, 'N') FROM FND_PRODUCT_GROUPS
9dvfguzd15kpv	SELECT VALUE FROM V$NLS_PARAMETERS WHERE PARAMETER = :B1
9sf243fdjmdmh	begin fnd_global.apps_initialize(-1, -1, -1, :1); end;
9wdrypwkpf607	begin OE_FULFILL_WF.START_FULFILLMENT (:v1, :v2, :v3, :v4, :v5); end;
a29grr748ghc4	BEGIN jdr_custom_internal.getActiveLayers(:1, :2, :3, :4, :5); END;
a957tvxz9w038	BEGIN :1 := por_util_pkg.interface_START_WORKFLOW( :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, :42, :43, :44, :45, :46, :47, :48, :49, :50, :51, :52, :53, :54, :55, :56, :57, :58, :59, :60, :61, :62, :63, :64, :65, :66, :67, :68, :69, :70, :71, :72, :73, :74, :75, :76, :77, :78, :79, :80, :81, :82, :83, :84, :85, :86, :87, :88, :89, :90, :91, :92, :93, :94, :95, :96, :97, :98, :99, :100, :101, :102) ; END;
avc1jqzz04wpr	SELECT 'x' FROM DUAL
b3an778qn1q49	select /*+ parallel(t, 16) parallel_index(t, 16) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*), 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), 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_o p_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("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("HEA DER_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_opnsize("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("H EADER_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_ATTRIBUTE15", 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_ATTRIBUTE20", 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_ATTRIBU TE23"), 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(distinct "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")), substrb(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_ATTRIB UTE2", 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")), subst rb(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"), count(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")), subst rb(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, 1 20), 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("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_ITEMS_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("MT L_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"), count(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_ATTRIBUTE3"), 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_SEGMENT4"), 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(d????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? ???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? ??????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????, 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(substrb("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("HEADER_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")), substrb(dump(min(substrb("HEADER_ATTRIBUTE10", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE10", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE11"), count(distinct "HEADER_ATTRIBUTE11"), sum(sys_op_opnsize("HEADER_ATTRIBUTE11")), substrb(dump(min(substrb("HEADER_ATTRIBUTE11", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE11", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE12"), count(distinct "HEADER_ATTRIBUTE12"), sum(sys_op_opnsize("HEADER_ATTRIBUTE12")), substrb(dump(min(substrb("HEADER_ATTRIBUTE12", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE12", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE13"), count(distinct "HEADER_ATTRIBUTE13"), sum(sys_op_opnsize("HEADER_ATTRIBUTE13")), substrb(dump(min(substrb("HEADER_ATTRIBUTE13", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE13", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE14"), count(distinct "HEADER_ATTRIBUTE14"), sum(sys_op_opnsize("HEADER_ATTRIBUTE14")), substrb(dump(min(substrb("HEADER_ATTRIBUTE14", 1 , 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE14", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE15"), count(distinct "HEADER_ATTRIBUTE15"), sum(sys_op_opnsize("HEADER_ATTRIBUTE15")), substrb(dump(min(substrb("HEADER_ATTRIBUTE15", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE15", 1, 32)), 16, 0, 32), 1, 120) from "AR"."RA_INTERFACE_LINES_ALL" sample ( 10.0000000000) t
bc7t6t6jfx2n7	SELECT VERSION FROM FND_CACHE_VERSIONS WHERE NAME = :B1
bcym7s1bp0wxs	SELECT WIA.NAME FROM WF_ITEM_ATTRIBUTES WIA WHERE WIA.ITEM_TYPE = :B1 AND WIA.TYPE = 'EVENT'
bkxrrs52m7d8p	BEGIN WSH_SHIP_CONFIRM_ACTIONS.interface_ALL_wrp( :errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8); END;
bp8crdjba8zgt	update ra_cust_trx_line_gl_dist set gl_posted_date=:b0, posting_control_id=:b1, last_update_date=sysdate , last_updated_by=:b2 where (cust_trx_line_gl_dist_id in (select to_number(reference23) from gl_interface where ((((user_je_source_name=:b3 and set_of_books_id=:b4) and group_id=:b1) and (reference30||'')='RA_CUST_TRX_LINE_GL_DIST') and accounting_date between to_date((:b6||' 00:00:00'), 'DD-MON-RR HH24:MI:SS') and to_date((:b7||' 23:59:59'), 'DD-MON-RR HH24:MI:SS'))) and set_of_books_id=:b4)
bt0w082dfrm8v	BEGIN WSH_SHIP_CONFIRM_ACTIONS.interface_ALL_wrp( :errbuf, :rc, :A0, :A1, :A2, :A3); END;
bvyqm6268u2as	SELECT NODE_NAME FROM FND_NODES WHERE NODE_ID = :B1
by0sg8ccaazuk	UPDATE MRP_ATP_SCHEDULE_TEMP SET SCENARIO_ID = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), NVL(:B44 , -1), SCENARIO_ID), INVENTORY_ITEM_ID = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B43 , INVENTORY_ITEM_ID), INVENTORY_ITEM_NAME = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B42 , INVENTORY_ITEM_NAME), SOURCE_ORGANIZATION_ID =DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B40 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B41 , NULL)), SOURCE_ORGANIZATION_CODE = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B38 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B39 , NULL)), ORDER_HEADER_ID = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), NVL(:B37 , -1), NULL), DEMAND_SOURCE_TYPE = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B36 , NULL), DELIVERY_LEAD_TIME = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B34 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B35 , NULL)), SHIP_METHOD = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B32 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B33 , NULL)), DEMAND_CLASS = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B31 , NULL), SCHEDULED_SHIP_DATE = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B29 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B30 , NULL)), AVAILABLE_QUANTITY = DECO DE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B28 , NULL), REQUESTED_DATE_QUANTITY = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B27 , NULL), GROUP_SHIP_DATE = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B25 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B26 , NULL)), GROUP_ARRIVAL_DATE = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B23 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B24 , NULL)), ERROR_CODE = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B21 , DECODE(ERROR_CODE, NULL, DECODE(:B22 , 150, 0, 61, 0, 0, 0, :B51 ))), ERROR_MESSAGE = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B20 , NULL), STATUS_FLAG = 2, END_PEGGING_ID = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B18 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B19 , NULL)), SCHEDULED_ARRIVAL_DATE = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B16 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B17 , NULL)), ORGANIZATION_ID = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B15 , NULL), REQUEST_ITEM_ID = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B14 , NULL), REQUEST_ITEM_NAME = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B13 , NULL), REQ_ITEM_REQ_DATE_QTY = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B12 , NULL), REQ_ITEM_A VAILABLE_DATE_QTY = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B11 , NULL), REQ_ITEM_AVAILABLE_DATE =DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B10 , NULL), SALES_REP = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B9 , NULL), CUSTOMER_CONTACT = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B8 , NULL), COMPILE_DESIGNATOR = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), DECODE(:B50 , 4, :B7 , NULL), NULL), SUBST_FLAG = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B6 , NULL), MATCH_ITEM_ID = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B5 , NULL), MATCHED_ITEM_NAME = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B4 , NULL), PLAN_ID = :B3 , FIRST_VALID_SHIP_ARRIVAL_DATE = :B2 , ATP_LEAD_TIME = DECODE(ATO_MODEL_LINE_ID, NULL, NULL, ORDER_LINE_ID, 0, :B1 ) WHERE SESSION_ID = :B49 AND STATUS_FLAG = 99 AND NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID) = :B48 AND NVL(:B47 , 2) = 2 AND NVL(SOURCE_ORGANIZATION_ID, NVL(:B45 , -1)) = NVL(:B46 , -1)
c4y7jp0q2awbf	SELECT PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES WHERE PROFILE_OPTION_ID = :B4 AND APPLICATION_ID = :B3 AND LEVEL_ID = :B2 AND LEVEL_VALUE = :B1
cwyx16zn1hpfb	select parameter, value from nls_session_parameters
fhqzxap2n0ybj	select NAME from HR_OPERATING_UNITS where ORGANIZATION_ID = :zorg_id
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
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;
ghw9svn8x4vzu	BEGIN WSH_PICK_LIST.RELEASE_BATCH_SRS( :errbuf, :rc, :A0, :A1, :A2); END;
gksvm8wmzk8w0	begin OE_INVOICE_WF.INVOICE_INTERFACE (:v1, :v2, :v3, :v4, :v5); end;

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	4,125,715	1,143.35	3.32
CPU used when call started	4,103,409	1,137.16	3.30
CR blocks created	16,670,460	4,619.83	13.42
Cached Commit SCN referenced	897,260	248.65	0.72
Commit SCN cached	465	0.13	0.00
DB time	8,489,288	2,352.61	6.83
DBWR checkpoint buffers written	3,738,614	1,036.07	3.01
DBWR checkpoints	34	0.01	0.00
DBWR object drop buffers written	57,036	15.81	0.05
DBWR revisited being-written buffer	52	0.01	0.00
DBWR thread checkpoint buffers written	581,973	161.28	0.47
DBWR transaction table writes	2,838	0.79	0.00
DBWR undo block writes	1,750,959	485.24	1.41
DFO trees parallelized	48	0.01	0.00
IMU CR rollbacks	26,002,475	7,205.98	20.93
IMU Flushes	348,840	96.67	0.28
IMU Redo allocation size	2,484,065,280	688,400.96	1,999.46
IMU commits	649,882	180.10	0.52
IMU contention	40,675	11.27	0.03
IMU ktichg flush	9,313	2.58	0.01
IMU pool not allocated	0	0.00	0.00
IMU recursive-transaction flush	1,781	0.49	0.00
IMU undo allocation size	5,743,990,600	1,591,813.51	4,623.43
IMU- failed to get a private strand	0	0.00	0.00
PX local messages recv'd	69,933	19.38	0.06
PX local messages sent	69,933	19.38	0.06
Parallel operations downgraded 25 to 50 pct	40	0.01	0.00
Parallel operations not downgraded	8	0.00	0.00
SMON posted for undo segment shrink	1	0.00	0.00
SQL*Net roundtrips to/from client	52,077,783	14,432.15	41.92
active txn count during cleanout	94,511,365	26,191.63	76.07
application wait time	48,106	13.33	0.04
background checkpoints completed	3	0.00	0.00
background checkpoints started	2	0.00	0.00
background timeouts	13,770	3.82	0.01
branch node splits	870	0.24	0.00
buffer is not pinned count	630,203,141	174,646.16	507.26
buffer is pinned count	1,145,055,345	317,325.48	921.67
bytes received via SQL*Net from client	9,707,645,911	2,690,248.47	7,813.84
bytes sent via SQL*Net to client	9,251,604,084	2,563,867.07	7,446.77
calls to get snapshot scn: kcmgss	134,318,154	37,223.15	108.11
calls to kcmgas	21,007,523	5,821.75	16.91
calls to kcmgcs	10,634,384	2,947.07	8.56
change write time	81,587	22.61	0.07
cleanout - number of ktugct calls	25,554,226	7,081.76	20.57
cleanouts and rollbacks - consistent read gets	14,546,539	4,031.24	11.71
cleanouts only - consistent read gets	174,895	48.47	0.14
cluster key scan block gets	1,476,850	409.27	1.19
cluster key scans	170,291	47.19	0.14
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	5,414	1.50	0.00
commit batch/immediate requested	5,414	1.50	0.00
commit cleanout failures: block lost	297,906	82.56	0.24
commit cleanout failures: buffer being written	1,474	0.41	0.00
commit cleanout failures: callback failure	113,384	31.42	0.09
commit cleanout failures: cannot pin	38,588	10.69	0.03
commit cleanouts	10,069,709	2,790.59	8.11
commit cleanouts successfully completed	9,618,357	2,665.50	7.74
commit immediate performed	5,414	1.50	0.00
commit immediate requested	5,414	1.50	0.00
commit txn count during cleanout	1,455,745	403.43	1.17
concurrency wait time	58,433	16.19	0.05
consistent changes	731,821,136	202,807.22	589.05
consistent gets	1,858,241,344	514,968.40	1,495.73
consistent gets - examination	1,270,704,202	352,146.14	1,022.81
consistent gets from cache	1,858,241,326	514,968.40	1,495.73
cursor authentications	2,031	0.56	0.00
data blocks consistent reads - undo records applied	726,840,790	201,427.03	585.05
db block changes	204,079,698	56,555.95	164.27
db block gets	226,026,982	62,638.13	181.93
db block gets direct	4,329	1.20	0.00
db block gets from cache	226,022,659	62,636.93	181.93
deferred (CURRENT) block cleanout applications	1,617,264	448.19	1.30
dirty buffers inspected	11,562	3.20	0.01
doubling up with imu segment	0	0.00	0.00
enqueue conversions	11,112	3.08	0.01
enqueue releases	5,022,057	1,391.75	4.04
enqueue requests	5,030,086	1,393.97	4.05
enqueue timeouts	7,899	2.19	0.01
enqueue waits	57,848	16.03	0.05
exchange deadlocks	48,440	13.42	0.04
execute count	120,618,792	33,426.70	97.09
failed probes on index block reclamation	8,003	2.22	0.01
free buffer inspected	3,671,675	1,017.52	2.96
free buffer requested	21,578,987	5,980.11	17.37
heap block compress	28,787,446	7,977.77	23.17
hot buffers moved to head of LRU	1,574,375	436.30	1.27
immediate (CR) block cleanout applications	14,721,446	4,079.71	11.85
immediate (CURRENT) block cleanout applications	1,329,734	368.50	1.07
index crx upgrade (found)	51,814	14.36	0.04
index crx upgrade (positioned)	12,867,696	3,565.98	10.36
index fast full scans (rowid ranges)	1,680	0.47	0.00
index fetch by key	203,108,329	56,286.75	163.49
index scans kdiixs1	152,787,516	42,341.51	122.98
java call heap collected bytes	1,311,309,240	363,398.88	1,055.49
java call heap collected count	16,290,686	4,514.59	13.11
java call heap gc count	5,250	1.45	0.00
java call heap live object count	1,634,014	452.83	1.32
java call heap live object count max	1,633,569	452.71	1.31
java call heap live size	509,852,192	141,293.69	410.39
java call heap live size max	510,115,544	141,366.67	410.60
java call heap object count	3,585,045	993.51	2.89
java call heap object count max	3,591,484	995.30	2.89
java call heap total size	687,821,824	190,613.83	553.64
java call heap total size max	687,548,160	190,537.99	553.42
java call heap used size	638,171,392	176,854.37	513.67
java call heap used size max	639,148,376	177,125.12	514.46
leaf node 90-10 splits	21,496	5.96	0.02
leaf node splits	251,262	69.63	0.20
lob reads	23,815	6.60	0.02
lob writes	41,091	11.39	0.03
lob writes unaligned	41,091	11.39	0.03
logons cumulative	10,839	3.00	0.01
messages received	2,849,643	789.71	2.29
messages sent	2,849,643	789.71	2.29
no buffer to keep pinned count	16	0.00	0.00
no work - consistent read gets	531,974,806	147,424.45	428.20
opened cursors cumulative	13,683,746	3,792.13	11.01
parse count (failures)	3,605	1.00	0.00
parse count (hard)	9,192	2.55	0.01
parse count (total)	17,935,494	4,970.41	14.44
parse time cpu	118,138	32.74	0.10
parse time elapsed	134,713	37.33	0.11
physical read IO requests	397,303	110.10	0.32
physical read bytes	4,548,100,096	1,260,400.25	3,660.84
physical read total IO requests	398,984	110.57	0.32
physical read total bytes	4,574,732,288	1,267,780.74	3,682.28
physical read total multi block requests	21,845	6.05	0.02
physical reads	555,188	153.86	0.45
physical reads cache	554,394	153.64	0.45
physical reads cache prefetch	157,705	43.70	0.13
physical reads direct	794	0.22	0.00
physical reads direct temporary tablespace	186	0.05	0.00
physical reads prefetch warmup	111,133	30.80	0.09
physical write IO requests	1,317,978	365.25	1.06
physical write bytes	31,348,432,896	8,687,489.67	25,232.87
physical write total IO requests	2,825,127	782.92	2.27
physical write total bytes	68,032,442,368	18,853,610.38	54,760.43
physical write total multi block requests	1,791,907	496.59	1.44
physical writes	3,826,713	1,060.48	3.08
physical writes direct	4,848	1.34	0.00
physical writes direct (lob)	218	0.06	0.00
physical writes direct temporary tablespace	4,185	1.16	0.00
physical writes from cache	3,821,865	1,059.14	3.08
physical writes non checkpoint	2,525,271	699.82	2.03
pinned buffers inspected	4,592	1.27	0.00
prefetch warmup blocks aged out before use	324,838	90.02	0.26
prefetched blocks aged out before use	45	0.01	0.00
process last non-idle time	3,610	1.00	0.00
queries parallelized	48	0.01	0.00
recursive aborts on index block reclamation	8	0.00	0.00
recursive calls	217,257,879	60,207.97	174.87
recursive cpu usage	2,326,806	644.82	1.87
redo blocks written	35,741,396	9,904.90	28.77
redo buffer allocation retries	0	0.00	0.00
redo entries	104,714,350	29,019.15	84.29
redo log space requests	0	0.00	0.00
redo log space wait time	0	0.00	0.00
redo ordering marks	1,278,630	354.34	1.03
redo size	35,182,017,664	9,749,878.59	28,318.58
redo subscn max counts	2,660,016	737.16	2.14
redo synch time	65,191	18.07	0.05
redo synch writes	2,983,625	826.84	2.40
redo wastage	826,272,480	228,982.22	665.08
redo write time	56,140	15.56	0.05
redo writer latching time	120	0.03	0.00
redo writes	924,663	256.25	0.74
rollback changes - undo records applied	197,994	54.87	0.16
rollbacks only - consistent read gets	2,252,258	624.16	1.81
rows fetched via callback	105,197,215	29,152.96	84.67
session connect time	0	0.00	0.00
session cursor cache hits	7,712,963	2,137.47	6.21
session logical reads	2,084,268,988	577,606.71	1,677.66
session pga memory	7,239,739,096	2,006,325.44	5,827.38
session pga memory max	9,813,890,840	2,719,691.78	7,899.36
session uga memory	###############	71,648,852.54	208,104.55
session uga memory max	77,315,301,432	21,426,139.05	62,232.36
shared hash latch upgrades - no wait	35,773,838	9,913.89	28.79
shared hash latch upgrades - wait	75,647	20.96	0.06
sorts (memory)	13,038,165	3,613.22	10.49
sorts (rows)	156,206,663	43,289.05	125.73
sql area evicted	840	0.23	0.00
sql area purged	3,774	1.05	0.00
summed dirty queue length	232,992	64.57	0.19
switch current to new buffer	1,521,764	421.72	1.22
table fetch by rowid	722,803,209	200,308.11	581.80
table fetch continued row	37,200,004	10,309.12	29.94
table scan blocks gotten	103,591,924	28,708.09	83.38
table scan rows gotten	5,276,641,571	1,462,298.59	4,247.26
table scans (long tables)	4,670	1.29	0.00
table scans (rowid ranges)	4,668	1.29	0.00
table scans (short tables)	7,184,792	1,991.10	5.78
total number of times SMON posted	129,495	35.89	0.10
transaction rollbacks	5,414	1.50	0.00
transaction tables consistent read rollbacks	127	0.04	0.00
transaction tables consistent reads - undo records applied	6,956	1.93	0.01
undo change vector size	12,429,558,656	3,444,563.33	10,004.76
user I/O wait time	200,396	55.54	0.16
user calls	49,560,825	13,734.63	39.89
user commits	976,767	270.69	0.79
user rollbacks	265,598	73.60	0.21
workarea executions - onepass	2	0.00	0.00
workarea executions - optimal	8,206,325	2,274.19	6.61
write clones created in background	1,433	0.40	0.00
write clones created in foreground	13,047	3.62	0.01

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	471,483	1,309,594
opened cursors current	863,226	900,004
workarea memory allocated	4,679	2,112
logons current	5,224	5,196

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)	0	0.00

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_UNDOTS1	100	0	6.90	1.00	411,627	114	261,453	0.05
APPS_TS_TX_IDX	138,677	38	5.50	1.45	217,565	60	86,987	0.31
APPS_TS_TX_DATA	169,115	47	4.95	1.31	172,898	48	110,490	0.29
APPS_ASSM_DATA	33,074	9	2.62	1.98	283,019	78	52,225	0.37
APPS_ASSM_IDX	39,850	11	4.07	1.00	145,945	40	282,114	0.11
APPS_TS_TX_INTERFACE	820	0	6.33	2.24	30,813	9	3,182	0.10
APPS_TS_QUEUES	3,447	1	8.09	1.50	24,025	7	104	0.48
SYSTEM	7,709	2	4.98	1.51	5,298	1	7,302	0.47
TEMP	971	0	4.20	4.77	10,172	3	88	6.59
APPS_TS_SEED	2,537	1	7.67	1.47	4,459	1	834	3.25
APPS_TS_SUMMARY	61	0	9.02	1.00	4,653	1	2,888	0.05
CTXSYS	199	0	6.78	1.28	4,496	1	0	0.00
APPS_TS_ARCHIVE	65	0	8.15	1.00	2,163	1	146	5.00
SYSAUX	536	0	3.19	1.85	636	0	0	0.00
APPS_TS_NOLOGGING	32	0	4.06	1.44	67	0	2	0.00
APPS_TS_MEDIA	9	0	10.00	1.00	9	0	0	0.00
ODM	7	0	4.29	1.00	3	0	0	0.00
OLAP	7	0	1.43	1.00	3	0	0	0.00
OWAPUB	7	0	5.71	1.00	3	0	0	0.00
PORTAL	7	0	4.29	1.00	3	0	0	0.00
SYNCSERVER	7	0	2.86	1.00	3	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	/oracle/visdata/apps_assm_data.dbf	33,074	9	2.62	1.98	283,019	78	52,225	0.37
APPS_ASSM_IDX	/oracle/visdata/apps_assm_idx.dbf	39,850	11	4.07	1.00	145,945	40	282,114	0.11
APPS_TS_ARCHIVE	/oasb_data/archive1.dbf	18	0	15.00	1.00	1,183	0	50	4.40
APPS_TS_ARCHIVE	/oasb_data/archive2.dbf	47	0	5.53	1.00	980	0	96	5.31
APPS_TS_MEDIA	/oasb_data/media1.dbf	3	0	13.33	1.00	3	0	0	0.00
APPS_TS_MEDIA	/oasb_data/media2.dbf	3	0	6.67	1.00	3	0	0	0.00
APPS_TS_MEDIA	/oasb_data/media3.dbf	3	0	10.00	1.00	3	0	0	0.00
APPS_TS_NOLOGGING	/oasb_data/nologging1.dbf	16	0	6.88	1.88	61	0	2	0.00
APPS_TS_NOLOGGING	/oasb_data/nologging2.dbf	8	0	1.25	1.00	3	0	0	0.00
APPS_TS_NOLOGGING	/oasb_data/nologging3.dbf	8	0	1.25	1.00	3	0	0	0.00
APPS_TS_QUEUES	/oasb_data/queues1.dbf	465	0	8.22	1.50	3,152	1	1	0.00
APPS_TS_QUEUES	/oasb_data/queues2.dbf	537	0	7.23	1.51	3,869	1	12	0.83
APPS_TS_QUEUES	/oasb_data/queues3.dbf	477	0	8.99	1.51	3,676	1	55	0.73
APPS_TS_QUEUES	/oasb_data/queues4.dbf	456	0	9.93	1.41	3,271	1	14	0.00
APPS_TS_QUEUES	/oasb_data/queues5.dbf	495	0	7.64	1.65	3,327	1	15	0.00
APPS_TS_QUEUES	/oasb_data/queues6.dbf	514	0	7.67	1.51	3,542	1	7	0.00
APPS_TS_QUEUES	/oasb_data/queues7.dbf	503	0	7.24	1.42	3,188	1	0	0.00
APPS_TS_SEED	/oasb_data/reference1.dbf	216	0	6.57	1.91	372	0	167	3.35
APPS_TS_SEED	/oasb_data/reference10.dbf	181	0	9.61	1.46	305	0	0	0.00
APPS_TS_SEED	/oasb_data/reference2.dbf	360	0	5.42	1.52	351	0	568	3.75
APPS_TS_SEED	/oasb_data/reference3.dbf	238	0	8.19	1.50	500	0	6	3.33
APPS_TS_SEED	/oasb_data/reference4.dbf	263	0	8.21	1.26	470	0	90	0.00
APPS_TS_SEED	/oasb_data/reference5.dbf	254	0	7.99	1.59	477	0	0	0.00
APPS_TS_SEED	/oasb_data/reference6.dbf	260	0	7.50	1.65	545	0	0	0.00
APPS_TS_SEED	/oasb_data/reference7.dbf	255	0	8.78	1.25	470	0	0	0.00
APPS_TS_SEED	/oasb_data/reference8.dbf	277	0	7.47	1.24	458	0	3	0.00
APPS_TS_SEED	/oasb_data/reference9.dbf	233	0	8.33	1.43	511	0	0	0.00
APPS_TS_SUMMARY	/oasb_data/summary1.dbf	20	0	8.00	1.00	534	0	318	0.00
APPS_TS_SUMMARY	/oasb_data/summary2.dbf	4	0	5.00	1.00	84	0	27	0.00
APPS_TS_SUMMARY	/oasb_data/summary3.dbf	4	0	20.00	1.00	965	0	305	0.00
APPS_TS_SUMMARY	/oasb_data/summary4.dbf	5	0	10.00	1.00	788	0	474	0.08
APPS_TS_SUMMARY	/oasb_data/summary5.dbf	4	0	15.00	1.00	627	0	819	0.01
APPS_TS_SUMMARY	/oasb_data/summary6.dbf	8	0	8.75	1.00	561	0	361	0.22
APPS_TS_SUMMARY	/oasb_data/summary7.dbf	8	0	6.25	1.00	572	0	232	0.09
APPS_TS_SUMMARY	/oasb_data/summary8.dbf	8	0	7.50	1.00	522	0	352	0.00
APPS_TS_TX_DATA	/oasb_data/tx_data1.dbf	586	0	5.67	1.82	7,392	2	4,933	0.45
APPS_TS_TX_DATA	/oasb_data/tx_data10.dbf	411	0	3.70	1.69	7,625	2	5,178	0.39
APPS_TS_TX_DATA	/oasb_data/tx_data11.dbf	615	0	4.07	1.70	8,225	2	5,943	0.56
APPS_TS_TX_DATA	/oasb_data/tx_data12.dbf	15,462	4	4.93	1.31	8,777	2	5,623	0.26
APPS_TS_TX_DATA	/oasb_data/tx_data13.dbf	15,498	4	5.13	1.27	8,761	2	5,227	0.08
APPS_TS_TX_DATA	/oasb_data/tx_data14.dbf	15,476	4	4.96	1.30	8,937	2	5,489	0.06
APPS_TS_TX_DATA	/oasb_data/tx_data15.dbf	15,288	4	5.14	1.29	9,212	3	5,831	0.07
APPS_TS_TX_DATA	/oasb_data/tx_data16.dbf	15,425	4	5.05	1.30	9,229	3	5,905	0.15
APPS_TS_TX_DATA	/oasb_data/tx_data17.dbf	15,593	4	5.05	1.28	9,023	3	3,983	0.18
APPS_TS_TX_DATA	/oasb_data/tx_data18.dbf	15,318	4	4.92	1.29	9,009	2	4,499	0.15
APPS_TS_TX_DATA	/oasb_data/tx_data19.dbf	15,300	4	5.08	1.28	8,549	2	5,054	0.18
APPS_TS_TX_DATA	/oasb_data/tx_data2.dbf	642	0	3.32	2.19	7,897	2	5,561	0.49
APPS_TS_TX_DATA	/oasb_data/tx_data20.dbf	15,440	4	4.92	1.29	8,654	2	5,017	0.12
APPS_TS_TX_DATA	/oasb_data/tx_data21.dbf	15,273	4	5.17	1.28	8,795	2	5,677	0.18
APPS_TS_TX_DATA	/oasb_data/tx_data3.dbf	1,044	0	3.14	1.68	7,750	2	5,476	0.53
APPS_TS_TX_DATA	/oasb_data/tx_data4.dbf	1,250	0	2.98	1.61	8,051	2	4,531	0.34
APPS_TS_TX_DATA	/oasb_data/tx_data5.dbf	3,628	1	4.98	1.32	7,319	2	4,558	0.38
APPS_TS_TX_DATA	/oasb_data/tx_data6.dbf	1,293	0	3.34	1.59	7,515	2	4,690	0.40
APPS_TS_TX_DATA	/oasb_data/tx_data7.dbf	3,406	1	4.43	1.24	7,059	2	4,842	0.53
APPS_TS_TX_DATA	/oasb_data/tx_data8.dbf	1,029	0	3.29	1.59	8,113	2	6,704	0.31
APPS_TS_TX_DATA	/oasb_data/tx_data9.dbf	1,138	0	3.15	1.54	7,006	2	5,769	0.29
APPS_TS_TX_IDX	/oasb_data/tx_idx1.dbf	571	0	4.69	1.00	4,920	1	2,344	0.49
APPS_TS_TX_IDX	/oasb_data/tx_idx10.dbf	641	0	5.77	1.06	13,176	4	1,768	0.55
APPS_TS_TX_IDX	/oasb_data/tx_idx11.dbf	1,073	0	4.67	1.10	11,075	3	3,167	1.12
APPS_TS_TX_IDX	/oasb_data/tx_idx12.dbf	12,652	4	5.39	1.51	13,587	4	5,647	0.15
APPS_TS_TX_IDX	/oasb_data/tx_idx13.dbf	12,768	4	5.52	1.48	12,894	4	5,938	0.21
APPS_TS_TX_IDX	/oasb_data/tx_idx14.dbf	12,700	4	5.50	1.38	12,445	3	5,169	0.20
APPS_TS_TX_IDX	/oasb_data/tx_idx15.dbf	12,725	4	5.49	1.35	12,170	3	5,916	0.22
APPS_TS_TX_IDX	/oasb_data/tx_idx16.dbf	12,675	4	5.38	1.44	11,592	3	5,000	0.18
APPS_TS_TX_IDX	/oasb_data/tx_idx17.dbf	12,548	3	5.52	1.39	11,997	3	4,891	0.16
APPS_TS_TX_IDX	/oasb_data/tx_idx18.dbf	12,395	3	5.48	1.51	11,403	3	4,990	0.19
APPS_TS_TX_IDX	/oasb_data/tx_idx19.dbf	12,539	3	5.64	1.55	11,798	3	4,993	0.17
APPS_TS_TX_IDX	/oasb_data/tx_idx2.dbf	736	0	4.99	1.07	8,973	2	7,865	0.39
APPS_TS_TX_IDX	/oasb_data/tx_idx20.dbf	12,268	3	5.49	1.53	11,202	3	5,612	0.17
APPS_TS_TX_IDX	/oasb_data/tx_idx21.dbf	12,414	3	5.62	1.50	11,036	3	5,603	0.15
APPS_TS_TX_IDX	/oasb_data/tx_idx3.dbf	1,123	0	5.26	1.25	10,241	3	1,972	0.61
APPS_TS_TX_IDX	/oasb_data/tx_idx4.dbf	1,591	0	5.21	1.36	9,133	3	2,089	0.65
APPS_TS_TX_IDX	/oasb_data/tx_idx5.dbf	1,524	0	6.10	1.37	8,360	2	2,182	0.60
APPS_TS_TX_IDX	/oasb_data/tx_idx6.dbf	1,508	0	5.58	1.41	8,235	2	1,944	0.35
APPS_TS_TX_IDX	/oasb_data/tx_idx7.dbf	1,454	0	5.79	1.41	7,540	2	3,306	0.41
APPS_TS_TX_IDX	/oasb_data/tx_idx8.dbf	1,384	0	5.53	1.39	8,778	2	3,807	0.42
APPS_TS_TX_IDX	/oasb_data/tx_idx9.dbf	1,388	0	5.94	1.38	7,010	2	2,784	0.39
APPS_TS_TX_INTERFACE	/oasb_data/ts_tx_inte.dbf	468	0	5.34	2.53	7,240	2	819	0.32
APPS_TS_TX_INTERFACE	/oasb_data/ts_tx_inte2.dbf	79	0	8.99	1.80	5,113	1	555	0.07
APPS_TS_TX_INTERFACE	/oasb_data/ts_tx_inte3.dbf	53	0	6.98	1.96	4,698	1	527	0.02
APPS_TS_TX_INTERFACE	/oasb_data/ts_tx_inte4.dbf	74	0	7.30	1.74	4,861	1	557	0.02
APPS_TS_TX_INTERFACE	/oasb_data/ts_tx_inte5.dbf	63	0	6.83	2.05	4,402	1	434	0.02
APPS_TS_TX_INTERFACE	/oasb_data/ts_tx_inte6.dbf	83	0	7.71	1.82	4,499	1	290	0.00
APPS_UNDOTS1	/oasb_data/undo01.dbf	3	0	10.00	1.00	39,067	11	23,108	0.04
APPS_UNDOTS1	/oasb_data/undo02.dbf	5	0	8.00	1.00	41,658	12	26,757	0.04
APPS_UNDOTS1	/oasb_data/undo03.dbf	3	0	13.33	1.00	38,343	11	27,853	0.04
APPS_UNDOTS1	/oasb_data/undo04.dbf	8	0	10.00	1.00	40,546	11	32,879	0.10
APPS_UNDOTS1	/oasb_data/undo05.dbf	13	0	9.23	1.00	40,910	11	29,676	0.05
APPS_UNDOTS1	/oasb_data/undo06.dbf	15	0	7.33	1.00	40,259	11	28,465	0.05
APPS_UNDOTS1	/oasb_data/undo07.dbf	19	0	5.26	1.00	41,709	12	23,405	0.05
APPS_UNDOTS1	/oasb_data/undo08.dbf	12	0	6.67	1.00	44,106	12	23,824	0.07
APPS_UNDOTS1	/oasb_data/undo09.dbf	12	0	4.17	1.00	43,585	12	24,349	0.05
APPS_UNDOTS1	/oracle/visdata/undo10.dbf	10	0	4.00	1.00	41,444	11	21,137	0.05
CTXSYS	/oasb_data/ctx1.dbf	68	0	5.88	1.71	522	0	0	0.00
CTXSYS	/oasb_data/ctx2.dbf	131	0	7.25	1.06	3,974	1	0	0.00
ODM	/oasb_data/odm.dbf	7	0	4.29	1.00	3	0	0	0.00
OLAP	/oasb_data/olap.dbf	7	0	1.43	1.00	3	0	0	0.00
OWAPUB	/oasb_data/owa1.dbf	7	0	5.71	1.00	3	0	0	0.00
PORTAL	/oasb_data/portal.dbf	7	0	4.29	1.00	3	0	0	0.00
SYNCSERVER	/oasb_data/mobile01.dbf	7	0	2.86	1.00	3	0	0	0.00
SYSAUX	/oasb_data/sysaux01.dbf	190	0	3.26	1.74	76	0	0	0.00
SYSAUX	/oasb_data/sysaux02.dbf	346	0	3.15	1.90	560	0	0	0.00
SYSTEM	/oasb_data/sys1.dbf	999	0	5.24	1.67	501	0	76	3.42
SYSTEM	/oasb_data/sys2.dbf	1,186	0	5.02	1.48	584	0	139	4.53
SYSTEM	/oasb_data/sys3.dbf	1,035	0	4.71	1.48	725	0	156	3.59
SYSTEM	/oasb_data/sys4.dbf	1,208	0	5.07	1.41	869	0	142	3.87
SYSTEM	/oasb_data/sys5.dbf	1,075	0	4.79	1.51	954	0	77	3.77
SYSTEM	/oasb_data/sys6.dbf	1,097	0	4.95	1.53	821	0	292	1.20
SYSTEM	/oasb_data/sys7.dbf	979	0	5.10	1.58	541	0	80	2.38
SYSTEM	/oasb_data/sys8.dbf	78	0	4.62	1.00	108	0	4,946	0.08
SYSTEM	/oasb_data/sys9.dbf	52	0	5.00	1.08	195	0	1,394	0.11
TEMP	/oracle/visdata/temp1.dbf	179	0	4.02	3.41	2,509	1	47	5.74
TEMP	/oracle/visdata/temp2.dbf	230	0	4.87	4.73	2,534	1	21	4.76
TEMP	/oracle/visdata/temp3.dbf	443	0	3.45	6.35	2,651	1	12	15.00
TEMP	/oracle/visdata/temp4.dbf	119	0	5.97	1.00	2,478	1	8	3.75

Back to IO Stats
Back to Top

 

Buffer Pool Statistics

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

P	Number of Buffers	Pool Hit%	Buffer Gets	Physical Reads	Physical Writes	Free Buff Wait	Writ Comp Wait	Buffer Busy Waits
D	2,008,685	100	2,082,171,005	554,536	3,822,412	0	0	807,944

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	180	135	55790	671243	2493918	47178000	2493918
E	180	154	74108	868901	5728448	47178000	5728448

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	643,612	5

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	20,480	1,280	41,897.75	1.12	0.00	100.00	0.00	1,048,576
E	20,480	1,280	46,495.30	1.37	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	7,550,414	7,550,414	0	0
64K	128K	11,969	11,969	0	0
128K	256K	1,505	1,505	0	0
256K	512K	935	935	0	0
512K	1024K	253,740	253,740	0	0
1M	2M	386,871	386,871	0	0
2M	4M	80	78	2	0
4M	8M	20	20	0	0
8M	16M	18	18	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
2,560	0.13	904,896.81	10,579.71	99.00	1,260
5,120	0.25	904,896.81	10,479.90	99.00	1,223
10,240	0.50	904,896.81	10,353.75	99.00	1,153
15,360	0.75	904,896.81	10,185.20	99.00	1,106
20,480	1.00	904,896.81	0.00	100.00	1,057
24,576	1.20	904,896.81	0.00	100.00	1,014
28,672	1.40	904,896.81	0.00	100.00	936
32,768	1.60	904,896.81	0.00	100.00	177
36,864	1.80	904,896.81	0.00	100.00	0
40,960	2.00	904,896.81	0.00	100.00	0
61,440	3.00	904,896.81	0.00	100.00	0
81,920	4.00	904,896.81	0.00	100.00	0
122,880	6.00	904,896.81	0.00	100.00	0
163,840	8.00	904,896.81	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
320	0.10	320	14,930	6,609,314	1.00	5,546	2.29	218,061,546
624	0.20	618	18,969	6,611,200	1.00	3,660	1.51	218,129,999
928	0.30	920	21,534	6,612,435	1.00	2,425	1.00	218,175,135
1,232	0.40	1,191	25,690	6,612,442	1.00	2,418	1.00	218,176,042
1,536	0.50	1,330	33,444	6,612,443	1.00	2,417	1.00	218,176,194
1,840	0.60	1,330	33,444	6,612,443	1.00	2,417	1.00	218,176,194
2,144	0.70	1,330	33,444	6,612,443	1.00	2,417	1.00	218,176,194
2,448	0.80	1,330	33,444	6,612,443	1.00	2,417	1.00	218,176,194
2,752	0.90	1,330	33,444	6,612,443	1.00	2,417	1.00	218,176,194
3,056	1.00	1,330	33,444	6,612,443	1.00	2,417	1.00	218,176,194
3,360	1.10	1,330	33,444	6,612,443	1.00	2,417	1.00	218,176,194
3,664	1.20	1,330	33,444	6,612,443	1.00	2,417	1.00	218,176,194
3,968	1.30	1,330	33,444	6,612,443	1.00	2,417	1.00	218,176,194
4,272	1.40	1,330	33,444	6,612,443	1.00	2,417	1.00	218,176,194
4,576	1.50	1,330	33,444	6,612,443	1.00	2,417	1.00	218,176,194
4,880	1.60	1,330	33,444	6,612,443	1.00	2,417	1.00	218,176,194
5,184	1.70	1,330	33,444	6,612,443	1.00	2,417	1.00	218,176,194
5,488	1.80	1,330	33,444	6,612,443	1.00	2,417	1.00	218,176,194
5,792	1.90	1,330	33,444	6,612,443	1.00	2,417	1.00	218,176,194
6,096	1.99	1,330	33,444	6,612,443	1.00	2,417	1.00	218,176,194

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
4,864	0.25	55,014
9,728	0.50	55,014
14,592	0.75	55,032
19,456	1.00	55,012
24,320	1.25	55,033
29,184	1.50	55,035
34,048	1.75	55,043
38,912	2.00	55,045

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Size for Est (MB)	Size Factor	Est Spill Count	Est Spill Time (s)	Est Unspill Count	Est Unspill Time (s)
16	0.50	0	0	0	0
32	1.00	0	0	0	0
48	1.50	0	0	0	0
64	2.00	0	0	0	0
80	2.50	0	0	0	0
96	3.00	0	0	0	0
112	3.50	0	0	0	0
128	4.00	0	0	0	0
144	4.50	0	0	0	0
160	5.00	0	0	0	0
176	5.50	0	0	0	0
192	6.00	0	0	0	0
208	6.50	0	0	0	0
224	7.00	0	0	0	0
240	7.50	0	0	0	0
256	8.00	0	0	0	0
272	8.50	0	0	0	0
288	9.00	0	0	0	0
304	9.50	0	0	0	0
320	10.00	0	0	0	0

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
32	0.33	11	315	1,875	1.00	2,417	1.00	17,404
48	0.50	12	321	1,875	1.00	2,417	1.00	17,404
64	0.67	12	321	1,875	1.00	2,417	1.00	17,404
80	0.83	12	321	1,875	1.00	2,417	1.00	17,404
96	1.00	12	321	1,875	1.00	2,417	1.00	17,404
112	1.17	12	321	1,875	1.00	2,417	1.00	17,404
128	1.33	12	321	1,875	1.00	2,417	1.00	17,404
144	1.50	12	321	1,875	1.00	2,417	1.00	17,404
160	1.67	12	321	1,875	1.00	2,417	1.00	17,404
176	1.83	12	321	1,875	1.00	2,417	1.00	17,404
192	2.00	12	321	1,875	1.00	2,417	1.00	17,404
208	2.17	12	321	1,875	1.00	2,417	1.00	17,404

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	539,146	115	0
undo block	214,851	10	0
undo header	46,538	4	0
file header block	89	1	7
1st level bmb	3,824	0	0
segment header	3,136	0	0
2nd level bmb	205	0	0
extent map	11	0	0

Back to Wait Statistics
Back to Top

Enqueue Activity

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

Enqueue Type (Request Reason)	Requests	Succ Gets	Failed Gets	Waits	Wt Time (s)	Av Wt Time(ms)
TM-DML	2,164,716	2,164,716	0	25	318	12,719.84
TX-Transaction (index contention)	51,048	51,048	0	47,335	191	4.04
UL-User-defined	69,589	68,781	808	2,450	114	46.33
TX-Transaction (row lock contention)	6,911	468	6,443	423	37	86.47
TX-Transaction (allocate ITL entry)	206	201	5	91	25	277.43
RO-Multiple Object Reuse (fast object reuse)	288	288	0	32	5	161.97
HW-Segment High Water Mark	314,283	314,280	3	2,354	2	0.98
TX-Transaction	1,381,907	1,381,911	0	2,133	2	0.93
DV-Diana Versioning	32,222	32,222	0	148	1	5.24
SQ-Sequence Cache	44,285	44,285	0	2,414	1	0.28
FB-Format Block	33,331	33,331	0	402	0	0.55
US-Undo Segment	20,090	20,090	0	5	0	4.60
PS-PX Process Reservation	3,728	3,088	640	37	0	0.22

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,759.00	1,373,700	2,585	395		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
21-Dec 08:28	213,318	203,534	806	383	175	0/0	0/0/0/0/0/0
21-Dec 08:18	116,046	155,297	646	381	177	0/0	0/0/0/0/0/0
21-Dec 08:08	517,663	236,394	491	384	169	0/0	0/0/0/0/0/0
21-Dec 07:58	336,380	227,837	2,331	384	222	0/0	0/0/0/0/0/0
21-Dec 07:48	231,911	245,126	2,585	383	277	0/0	0/0/0/0/0/0
21-Dec 07:38	343,684	305,512	2,226	395	338	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,512	0.00		0	0
AWR Alerted Metric Element list	330,314	0.00		0	0
Consistent RBA	925,509	0.06	0.01	0	0
FOB s.o list latch	67,736	0.01	0.00	0	0
In memory undo latch	695,086,355	1.56	0.00	3	1,346,536	0.00
JOX SGA heap latch	1,967,191	0.00		0	0
JS mem alloc latch	0			0	2	0.00
JS queue state obj latch	20,820	0.00		0	0
JS slv state obj latch	171	0.00		0	0
KMG MMAN ready and startup request latch	1,233	0.00		0	0
KMG resize request state object freelist	4	0.00		0	0
KTF sga latch	12	0.00		0	1,215	0.00
KWQMN job cache list latch	10,632	0.03	1.00	0	0
KWQP Prop Status	453	0.00		0	0
MQL Tracking Latch	0			0	72	0.00
Memory Management Latch	72	0.00		0	1,231	0.00
Memory Queue	2	0.00		0	0
OS process	16,194	0.00		0	0
OS process allocation	11,963	0.00		0	0
OS process: request allocation	10,465	0.00		0	0
PL/SQL warning settings	5,501,651	0.00		0	0
SGA IO buffer pool latch	88,872	0.02	0.00	0	104,673	0.32
SQL memory manager latch	1	0.00		0	1,191	0.00
SQL memory manager workarea list latch	7,200,172	0.01	0.00	0	0
Shared B-Tree	2,355	0.00		0	0
active checkpoint queue latch	1,927,911	2.71	0.00	0	2	0.00
active service list	52,837	0.23	0.00	0	1,333	0.00
alert log latch	0			0	2	0.00
begin backup scn array	196	0.00		0	0
bq:time manger info latch	129	0.00		0	0
buffer pool	4	0.00		0	0
bufq statistics	2	0.00		0	0
cache buffer handles	23,401,433	1.96	0.00	0	0
cache buffers chains	4,837,971,881	1.33	0.04	193	18,447,828	2.58
cache buffers lru chain	11,897,334	0.51	0.02	3	37,681,940	0.63
cache table scan latch	0			0	7,750	0.03
channel handle pool latch	445,316	0.09	0.01	0	0
channel operations parent latch	1,806,462	0.60	0.01	0	0
checkpoint queue latch	36,957,681	0.02	0.00	0	3,860,557	0.06
client/application info	2,813,299	0.00	0.00	0	0
commit callback allocation	87,428	0.00		0	0
compile environment latch	3,722,430	0.00		0	0
dictionary lookup	78	0.00		0	0
dml lock allocation	4,312,126	0.34	0.00	0	0
dummy allocation	21,737	0.26	0.00	0	0
enqueue hash chains	10,130,897	0.21	0.00	0	996	0.00
enqueue sob latch	1	0.00		0	0
enqueues	6,584,650	0.29	0.00	0	0
error message lists	1,584	1.26	0.00	0	0
event group latch	5,217	0.00		0	0
file cache latch	24,700	0.00		0	0
global KZLD latch for mem in SGA	9,949	0.00		0	0
global ctx hash table latch	24,534	0.00		0	0
hash table column usage latch	1,661	0.30	0.00	0	16,054,438	0.00
hash table modification latch	140	0.00		0	2	0.00
internal temp table object number allocation latc	3	0.00		0	0
job workq parent latch	0			0	118	0.00
job_queue_processes free list latch	0			0	2	0.00
job_queue_processes parameter latch	117	0.00		0	0
kks stats	21,314	0.00	0.00	0	0
ksuosstats global area	242	0.00		0	0
ktm global data	129,525	0.00		0	0
kwqbsn:qsga	2,221	0.00		0	0
lgwr LWN SCN	931,048	0.22	0.00	0	0
library cache	449,966,437	1.01	0.00	7	14,172	61.01
library cache load lock	6,557	1.54	0.02	0	21	0.00
library cache lock	128,137,902	0.19	0.00	0	1	0.00
library cache lock allocation	5,751,837	0.03	0.00	0	0
library cache pin	261,679,612	0.41	0.00	2	25	0.00
library cache pin allocation	3,589,290	0.02	0.00	0	0
list of block allocation	489,743	0.03	0.00	0	0
loader state object freelist	345,212	0.01	0.00	0	0
logminer context allocation	1	0.00		0	0
longop free list parent	36	0.00		0	36	0.00
message pool operations parent latch	452,502	0.12	0.00	0	0
messages	8,581,846	0.99	0.00	0	0
mostly latch-free SCN	1,108,892	11.44	0.00	0	0
multiblock read objects	48,225	0.00	0.00	0	2	0.00
ncodef allocation latch	223	0.00		0	0
object queue header heap	8,143,767	0.04	0.08	0	436,381	0.12
object queue header operation	51,645,398	0.19	0.49	8	3,819	0.00
object stats modification	442,052	0.08	0.00	0	4	0.00
parallel query alloc buffer	23,516	4.09	0.00	0	0
parallel query stats	912	8.77	0.03	0	0
parameter table allocation management	25,125	1.91	0.80	1	0
post/wait queue	1,269,046	0.08	0.00	0	496,395	0.03
process allocation	10,513	0.21	0.86	0	5,214	0.06
process group creation	10,465	0.01	1.00	0	0
process queue	15,146	1.85	0.00	0	0
process queue reference	1,444,075	0.05	0.00	0	104,005	0.48
qmn state object latch	2	0.00		0	0
qmn task queue latch	5,107	19.91	0.84	0	0
query server freelists	13,488	24.26	0.00	0	0
query server process	16	0.00		0	16	0.00
redo allocation	6,635,700	7.65	0.00	1	104,156,731	4.59
redo copy	0			0	104,719,148	0.05
redo writing	5,412,397	2.65	0.00	0	0
resmgr group change latch	1,288,521	0.00		0	0
resmgr:actses active list	31,603	0.78	0.96	0	0
resmgr:actses change group	30,515	0.00		0	0
resmgr:free threads list	21,733	0.52	0.11	0	0
resmgr:schema config	1	0.00		0	0
row cache objects	127,959,043	1.13	0.00	1	4,319	0.39
rules engine aggregate statistics	41,406	0.00	0.00	0	0
rules engine evaluation context statistics	0			0	2	0.00
rules engine rule set statistics	133,225	0.01	0.00	0	0
rules engine rule statistics	50,313	0.00		0	0
sequence cache	16,731,779	0.66	0.00	0	0
session allocation	22,407,268	0.90	0.01	1	0
session idle bit	102,839,951	0.03	0.00	0	0
session state list latch	61,257	0.15	0.15	0	0
session switching	15,436	0.00		0	0
session timer	1,333	0.00		0	0
shared pool	7,988,527	0.25	0.02	0	0
shared pool sim alloc	384	0.52	0.00	0	0
shared pool simulator	2,389,788	0.01	0.01	0	0
sim partition latch	1	0.00		0	24,734	0.16
simulator lru latch	412	0.00		0	0
slave class	2	0.00		0	0
slave class create	8	0.00		0	0
sort extent pool	1,490,620	0.18	0.00	0	0
state object free list	12	0.00		0	0
statistics aggregation	112	0.00		0	0
temp lob duration state obj allocation	531	0.00		0	0
temporary table state object allocation	13,494	0.01	0.00	0	0
threshold alerts latch	582	0.00		0	0
trace latch	2	0.00		0	0
transaction allocation	124,964	0.00	0.00	0	0
transaction branch allocation	223	0.00		0	0
undo global data	901,694,190	1.01	0.00	3	10,972	0.17
user lock	39,980	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	4,837,971,881	64,355,692	2,393,030	62,235,136	0	0	0
In memory undo latch	695,086,355	10,843,323	12,031	10,833,032	0	0	0
undo global data	901,694,190	9,108,115	3,317	9,105,068	0	0	0
library cache	449,966,437	4,522,935	9,616	4,513,799	0	0	0
row cache objects	127,959,043	1,440,182	884	1,439,319	0	0	0
library cache pin	261,679,612	1,080,504	2,437	1,078,150	0	0	0
redo allocation	6,635,700	507,888	1,859	506,110	0	0	0
cache buffer handles	23,401,433	458,621	155	458,478	0	0	0
library cache lock	128,137,902	247,879	457	247,429	0	0	0
session allocation	22,407,268	202,038	1,378	200,705	0	0	0
redo writing	5,412,397	143,529	127	143,402	0	0	0
mostly latch-free SCN	1,108,892	126,885	112	126,773	0	0	0
sequence cache	16,731,779	111,001	60	110,942	0	0	0
object queue header operation	51,645,398	98,227	47,827	52,031	0	0	0
messages	8,581,846	85,071	146	84,925	0	0	0
cache buffers lru chain	11,897,334	60,165	970	59,230	0	0	0
active checkpoint queue latch	1,927,911	52,239	22	52,217	0	0	0
session idle bit	102,839,951	29,072	139	28,936	0	0	0
enqueue hash chains	10,130,897	21,390	31	21,359	0	0	0
shared pool	7,988,527	19,952	389	19,576	0	0	0
enqueues	6,584,650	19,259	75	19,186	0	0	0
dml lock allocation	4,312,126	14,839	70	14,771	0	0	0
channel operations parent latch	1,806,462	10,806	61	10,747	0	0	0
checkpoint queue latch	36,957,681	7,912	22	7,890	0	0	0
query server freelists	13,488	3,272	4	3,268	0	0	0
object queue header heap	8,143,767	3,219	255	2,980	0	0	0
sort extent pool	1,490,620	2,684	8	2,676	0	0	0
lgwr LWN SCN	931,048	2,043	4	2,039	0	0	0
library cache lock allocation	5,751,837	1,664	5	1,659	0	0	0
qmn task queue latch	5,107	1,017	859	171	0	0	0
parallel query alloc buffer	23,516	962	1	961	0	0	0
post/wait queue	1,269,046	952	2	950	0	0	0
SQL memory manager workarea list latch	7,200,172	675	3	672	0	0	0
library cache pin allocation	3,589,290	615	2	613	0	0	0
message pool operations parent latch	452,502	534	2	532	0	0	0
Consistent RBA	925,509	512	4	508	0	0	0
parameter table allocation management	25,125	481	383	174	0	0	0
channel handle pool latch	445,316	404	4	400	0	0	0
resmgr:actses active list	31,603	245	236	13	0	0	0
shared pool simulator	2,389,788	225	2	224	0	0	0
resmgr:free threads list	21,733	113	12	101	0	0	0
library cache load lock	6,557	101	2	99	0	0	0
session state list latch	61,257	91	14	77	0	0	0
parallel query stats	912	80	2	78	0	0	0
process allocation	10,513	22	19	3	0	0	0
KWQMN job cache list latch	10,632	3	3	0	0	0	0
process group creation	10,465	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
In memory undo latch	ktiFlush: child	0	6,917	1,912
In memory undo latch	kturbk	0	3,798	5,418
In memory undo latch	kticmt: child	0	746	390
In memory undo latch	ktichg: child	0	478	4,084
In memory undo latch	ktiTxnPoolFree	0	76	0
In memory undo latch	ktbgfc	0	14	232
In memory undo latch	ktiBRacquire	0	2	0
KWQMN job cache list latch	kwqmnuji: update job item	0	3	2
SQL memory manager workarea list latch	qesmmIRegisterWorkArea	0	2	2
SQL memory manager workarea list latch	qesmmIUnRegisterWorkArea	0	1	1
active checkpoint queue latch	kcbbacq: scan active checkpoints	0	22	22
active service list	ksws_event: ksws event	0	2	3
active service list	kswsgsnp: get service name ptr	0	1	0
cache buffer handles	kcbzgs	0	81	104
cache buffer handles	kcbzfs	0	74	51
cache buffers chains	kcbchg: kslbegin: bufs not pinned	0	1,910,026	2,546,048
cache buffers chains	kcbgtcr: fast path	0	1,047,351	56,831
cache buffers chains	kcbchg: kslbegin: call CR func	0	914,190	1,553,775
cache buffers chains	kcbgtcr: kslbegin excl	0	574,206	313,818
cache buffers chains	kcbrls: kslbegin	0	244,327	384,999
cache buffers chains	kcbzgb: scan from tail. nowait	0	123,925	0
cache buffers chains	kcbgcur: kslbegin	0	43,076	22,854
cache buffers chains	kcbget: pin buffer	0	33,202	15,472
cache buffers chains	kcbget: exchange rls	0	12,972	12,894
cache buffers chains	kcbzwb	0	10,046	6,566
cache buffers chains	kcbget: exchange	0	9,128	15,302
cache buffers chains	kcbcge	0	4,822	12,749
cache buffers chains	kcbnlc	0	2,604	2,638
cache buffers chains	kcbso1: set no access	0	1,157	159
cache buffers chains	kcb_is_private	0	788	6,026
cache buffers chains	kcbnew: new latch again	0	215	19
cache buffers chains	kcbesc: escalate	0	200	117
cache buffers chains	kcbgtcr: kslbegin shared	0	168	131
cache buffers chains	kcbbxsv	0	83	31
cache buffers chains	kcbgkcbcr	0	52	88
cache buffers chains	kcbbic2	0	41	13
cache buffers chains	kcb_pre_apply: kcbhq61	0	20	1,244
cache buffers chains	kcbzib: exchange rls	0	17	24
cache buffers chains	kcbzhngcbk1: get hash chain latch no wait	0	14	0
cache buffers chains	kcb_post_apply: kcbhq62	0	9	237
cache buffers chains	kcb_post_apply: kcbhq63	0	4	200
cache buffers chains	kcbzib: finish free bufs	0	4	9
cache buffers chains	kcbzib: multi-block read: nowait	0	4	0
cache buffers chains	kcbbic1	0	2	27
cache buffers chains	kcbrlb1	0	1	11
cache buffers chains	kcbw_next_free	0	1	0
cache buffers lru chain	kcbzgws	0	597	0
cache buffers lru chain	kcbo_link_q	0	108	23
cache buffers lru chain	kcbgtcr:CR Scan:KCBRSKIP	0	89	0
cache buffers lru chain	kcbbxsv: move to being written	0	84	277
cache buffers lru chain	kcbzgb: posted for free bufs	0	38	242
cache buffers lru chain	kcbzswcu	0	23	56
cache buffers lru chain	kcbo_ivd_proc	0	17	201
cache buffers lru chain	kcbbic2	0	14	192
channel handle pool latch	ksrchconnect()	0	26	16
channel handle pool latch	ksrchdelete()	0	1	18
channel operations parent latch	ksrchdelete()	0	136	49
channel operations parent latch	ksrapublish()	0	102	19
channel operations parent latch	ksrsconsume()	0	33	53
channel operations parent latch	ksrwait()	0	18	30
channel operations parent latch	ksrmfree()	0	11	189
channel operations parent latch	ksrchconnect()	0	10	32
checkpoint queue latch	kcbklbc: Link buffer into ckpt queue	0	11	0
checkpoint queue latch	kcbkubc	0	5	6
checkpoint queue latch	kcbbwthc: thread checkpoint buffers	0	3	11
checkpoint queue latch	kcbswcu: Switch buffers	0	3	4
dml lock allocation	ktaiam	0	55	28
dml lock allocation	ktaidm	0	15	42
enqueue hash chains	ksqgtl3	0	19	8
enqueue hash chains	ksqrcl	0	11	18
enqueue hash chains	ksqcmi: get hash chain latch after wait	0	1	5
enqueues	ksqgel: create enqueue	0	34	7
enqueues	ksqies	0	26	55
enqueues	ksqdel	0	14	13
enqueues	ksqgtl2	0	1	0
event range base latch	No latch	0	859	859
lgwr LWN SCN	kcs023	0	20	0
library cache	kglpndl: child: after processing	0	3,476	224
library cache	kglpnp: child	0	2,716	3,232
library cache	kglobpn: child:	0	1,083	1,851
library cache	kglpin	0	640	224
library cache	kglpndl: child: before processing	0	510	3,181
library cache	kglLockCursor	0	397	518
library cache	kglScanDependency	0	298	0
library cache	kglhdgn: child:	0	126	162
library cache	kgldte: child 0	0	61	148
library cache	kglic	0	25	0
library cache	kgldti: 2child	0	13	3
library cache	kglhdgc: child:	0	12	8
library cache	kglhdiv0: child	0	12	0
library cache	kglivl: child	0	10	0
library cache	kglhdiv0: parent: invalidate	0	7	2
library cache	kglhdiv: child	0	7	6
library cache	kglupd: child	0	4	0
library cache	kglget: unpin heap 0	0	1	0
library cache	kglobld	0	1	6
library cache	kglrtl	0	1	0
library cache load lock	kglllal: llatch	0	1	0
library cache load lock	kglllal: llatch: in loop	0	1	2
library cache lock	kgllkdl: child: cleanup	0	272	243
library cache lock	kgllkal: child: multiinstance	0	185	214
library cache lock	kgllkdl: child: no lock handle	0	79	43
library cache lock allocation	kgllkget	0	4	0
library cache lock allocation	kgllkrel	0	1	5
library cache pin	kglpndl	0	1,145	1,024
library cache pin	kglpnp: child	0	961	910
library cache pin	kglpnal: child: alloc space	0	330	503
library cache pin	kglpnal: child: check granted	0	1	0
library cache pin allocation	kglpnget	0	1	2
library cache pin allocation	kglpnrel	0	1	0
message pool operations parent latch	ksrmalloc()	0	5	4
message pool operations parent latch	ksrmfree()	0	2	3
messages	ksarcv: after wait	0	67	51
messages	ksarcv	0	49	87
messages	ksaamb: after wakeup	0	30	8
mostly latch-free SCN	kcslcu3	0	92	116
mostly latch-free SCN	kcs01	0	4	4
mostly latch-free SCN	kcs024	0	4	0
object queue header heap	kcbo_link_q:reget	0	240	10
object queue header heap	kcbw_link_q:alloc	0	12	245
object queue header heap	kcbw_unlink_q	0	3	0
object queue header operation	kcbo_ivbo	0	48,136	11,679
object queue header operation	kcbw_link_q	0	6,266	4,327
object queue header operation	kcbw_unlink_q	0	2,106	6,308
object queue header operation	kcbo_switch_cq	0	356	4,333
object queue header operation	kcbo_switch_q_bg	0	341	2,234
object queue header operation	kcbo_switch_mq_bg	0	149	3,755
object queue header operation	kcbo_swap_buf_bg	0	62	23,851
object queue header operation	kcbo_link_q:reget	0	31	271
object queue header operation	kcbo_write_q	0	15	0
object queue header operation	kcbo_service_ockpt	0	11	0
object queue header operation	kcbo_swap_buf	0	4	756
parallel query alloc buffer	kxfpbalo	0	1	1
parallel query stats	kxfprst: KSLBEGIN:1	0	2	2
parameter table allocation management	ksp_param_table_free	0	381	379
parameter table allocation management	kspptval	0	2	4
post/wait queue	ksliwat:add:nowait	0	2	0
process allocation	ksucrp	0	17	0
process allocation	ksudlp	0	2	15
process group creation	ksupgpadd	0	1	0
query server freelists	kxfpobrmf	0	4	4
redo allocation	kcrfw_redo_gen: redo allocation 1	0	1,245	0
redo allocation	kcrfw_redo_gen: redo allocation 3	0	464	1,195
redo allocation	kcrfw_redo_gen: redo allocation 2	0	111	0
redo allocation	kcrfw_redo_write: before write	0	20	358
redo allocation	kcrfw_redo_write: more space	0	19	381
redo writing	kcrfwcr	0	109	56
redo writing	kcrfw_post: rba scn pair	0	14	0
redo writing	kcrfw_post: after write	0	3	63
redo writing	kcrfw_cal_target_rba	0	1	9
resmgr:actses active list	kgskchclass	0	236	95
resmgr:free threads list	kgskthrsod	0	9	9
resmgr:free threads list	kgskthrcreate	0	3	3
row cache objects	kqreqd: reget	0	684	45
row cache objects	kqrpre: find obj	0	125	666
row cache objects	kqreqd	0	63	171
row cache objects	kqrso	0	4	2
sequence cache	kdnssd	0	50	0
sequence cache	kdnnxt: cached seq	0	9	2
sequence cache	kdnss	0	1	57
session allocation	ksuxds: KSUSFCLC not set	0	676	40
session allocation	ksucri	0	179	319
session allocation	ksuprc	0	162	200
session allocation	ksuxds: not user session	0	153	279
session allocation	ksudlc	0	89	351
session allocation	ksursi	0	46	96
session allocation	kxfprdp	0	27	32
session allocation	kxfpqidqr	0	26	57
session allocation	ksudlp	0	16	3
session allocation	kspallmod	0	3	0
session allocation	ksucrp	0	2	1
session idle bit	ksupuc: set busy	0	195	73
session idle bit	ksupuc: clear busy	0	108	220
session idle bit	ksuxds	0	8	18
session state list latch	kpseqd	0	13	0
session state list latch	kpscad	0	1	2
shared pool	kghalo	0	233	122
shared pool	kghfrunp: clatch: nowait	0	135	0
shared pool	kghupr1	0	115	200
shared pool	kghfre	0	18	52
shared pool	kghfrunp: alloc: wait	0	16	0
shared pool	kghfrunp: clatch: wait	0	10	8
shared pool	kghalp	0	7	14
shared pool simulator	kglsim_unpin_simhp	0	2	2
sort extent pool	ktstdt: dealloc sort extent	0	4	0
sort extent pool	ktstaddextent1	0	1	0
sort extent pool	ktstallobj1	0	1	2
sort extent pool	ktstcrtobj	0	1	0
sort extent pool	ktstdt: return extent	0	1	2
undo global data	kturimugur: child	0	2,764	1,991
undo global data	ktudba: KSLBEGIN	0	476	1,297
undo global data	ktucof: at start	0	40	0
undo global data	ktusmasp: ktugd_tuux	0	23	3
undo global data	ktufrbs: child	0	7	16
undo global data	ktudnx:child	0	4	10
undo global data	ktubnd:child	0	2	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,084,268,988
• Captured Segments account for 32.2% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Logical Reads	%Total
AR	APPS_TS_TX_INTERFACE	RA_INTERFACE_LINES_ALL		TABLE	69,181,536	3.32
INV	APPS_TS_TX_IDX	MTL_ITEM_CATEGORIES_U1		INDEX	51,523,504	2.47
APPLSYS	APPS_TS_TX_IDX	FND_PROFILE_OPTION_VALUES_U1		INDEX	31,080,944	1.49
APPLSYS	APPS_TS_SEED	WF_ITEM_ATTRIBUTES		TABLE	23,040,528	1.11
ONT	APPS_TS_TX_DATA	OE_ORDER_LINES_ALL		TABLE	22,159,056	1.06

Back to Segment Statistics
Back to Top

Segments by Physical Reads

• Total Physical Reads: 555,188
• Captured Segments account for 19.6% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Reads	%Total
GL	APPS_ASSM_DATA	GL_JE_LINES		TABLE	35,261	6.35
HR	APPS_ASSM_IDX	PAY_RUN_RESULT_VALUES_PK		INDEX	13,608	2.45
AR	APPS_ASSM_DATA	RA_CUSTOMER_TRX_LINES_ALL		TABLE	12,373	2.23
HR	APPS_ASSM_IDX	PAY_RUN_RESULT_VALUES_N50		INDEX	8,784	1.58
HR	APPS_ASSM_DATA	PAY_RUN_RESULTS		TABLE	7,216	1.30

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
WSH	APPS_TS_TX_DATA	WSH_TRIP_STOPS		TABLE	12,450	19.23
APPLSYS	APPS_TS_TX_IDX	WF_ITEM_ACTIVITY_STATUSES_N1		INDEX	9,670	14.94
HR	APPS_ASSM_IDX	PAY_RUN_RESULT_VALUES_N50		INDEX	9,390	14.51
AR	APPS_ASSM_IDX	RA_CUST_TRX_LINE_GL_DIST_U1		INDEX	9,098	14.06
HR	APPS_ASSM_IDX	PAY_RUN_RESULTS_N50		INDEX	4,155	6.42

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
AR	APPS_ASSM_IDX	RA_CUST_TRX_LINE_GL_DIST_N6		INDEX	23	32.39
APPLSYS	APPS_TS_TX_IDX	WF_ITEM_ATTRIBUTE_VALUES_PK		INDEX	18	25.35
GL	APPS_ASSM_IDX	GL_INTERFACE_N1		INDEX	5	7.04
AR	APPS_ASSM_IDX	RA_CUST_TRX_LINE_GL_DIST_N5		INDEX	5	7.04
GL	APPS_ASSM_IDX	GL_INTERFACE_N2		INDEX	4	5.63

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
AR	APPS_ASSM_IDX	RA_CUST_TRX_LINE_GL_DIST_U1		INDEX	193,157	41.28
APPLSYS	APPS_TS_TX_DATA	WF_ITEM_ATTRIBUTE_VALUES		TABLE	62,027	13.26
AR	APPS_ASSM_IDX	RA_CUST_TRX_LINE_GL_DIST_N6		INDEX	30,584	6.54
HR	APPS_ASSM_IDX	PAY_RUN_RESULT_VALUES_N50		INDEX	17,685	3.78
GL	APPS_ASSM_DATA	GL_JE_LINES		TABLE	15,404	3.29

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	4	0.00	0		2	1
dc_constraints	648	47.07	0		648	169
dc_free_extents	38	36.84	9	0.00	15	9
dc_global_oids	7,572,464	0.00	0		0	64
dc_histogram_data	247,924	0.59	0		0	6,525
dc_histogram_defs	426,988	1.98	0		4,042	10,391
dc_object_grants	73,325	0.04	0		0	248
dc_object_ids	12,529,208	0.01	0		57	3,444
dc_objects	243,077	0.41	0		345	2,714
dc_profiles	10,010	0.00	0		0	1
dc_rollback_segments	54,184	0.00	0		28	838
dc_segments	377,109	0.22	0		18,118	5,012
dc_sequences	55,168	0.05	0		55,168	142
dc_table_scns	80,813	0.01	0		0	14
dc_tablespace_quotas	18,013	0.07	0		215	55
dc_tablespaces	6,037,570	0.00	0		0	22
dc_used_extents	5	100.00	0		5	5
dc_usernames	580,244	0.00	0		0	52
dc_users	15,095,596	0.00	0		0	80
kqlsubheap_object	6	33.33	0		0	2
outstanding_alerts	256	0.00	0		0	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	1,850,276	0.01	47,731,973	-0.02	2	0
CLUSTER	60	0.00	163	0.00	0	0
INDEX	15,814	0.35	16,626	0.53	4	0
JAVA DATA	616	0.00	1	0.00	0	0
PIPE	51,381	2.53	75,080	1.73	0	0
SQL AREA	5,859	95.65	134,202,265	-0.03	3,656	313
TABLE/PROCEDURE	795,524	0.11	65,995,926	-0.02	279	0
TRIGGER	29,920	0.06	1,405,314	0.00	0	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	33,330.09		10.88	5.99	30	31	3,064	3,064
	Freeable	3,308.06	0.00	1.26	0.64	9		2,631	2,631
	SQL	2,626.47	1,304.76	0.86	0.51	4	22	3,056	3,054
	PL/SQL	2,337.32	178.39	0.76	0.95	3	3	3,064	3,064
	JAVA	299.24	297.84	2.47	0.43	5	7	121	121
E	Other	37,206.22		12.27	6.45	42	42	3,033	3,033
	Freeable	3,588.94	0.00	1.35	0.74	9		2,665	2,665
	SQL	2,787.90	1,408.71	0.92	0.51	5	22	3,026	3,023
	PL/SQL	2,644.03	194.74	0.87	0.98	3	3	3,033	3,033
	JAVA	283.50	282.10	2.36	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	17,062,428,672	17,028,874,240
Fixed Size	2,229,152
Redo Buffers	17,039,360
Variable Size	3,319,397,472	3,352,951,904

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	80.97	80.96	-0.01
java	joxlod exec hp	14.40	14.41	0.05
large	PX msg pool	0.49	0.49	0.00
large	free memory	15.51	15.51	0.00
shared	ASH buffers	40.50	40.50	0.00
shared	CCursor	42.96	55.44	29.05
shared	Heap0: KGL		28.33
shared	KGLS heap	48.63		-100.00
shared	KTI-UNDO	57.62	57.62	0.00
shared	PCursor		31.30
shared	PL/SQL MPCODE	68.82	73.58	6.91
shared	event statistics per sess	68.55	68.55	0.00
shared	free memory	846.23	444.20	-47.51
shared	library cache	710.33	776.60	9.33
shared	parameter table block	57.46	57.11	-0.59
shared	sql area	455.70	822.32	80.45
shared	trace buffer	48.45	48.48	0.06
streams	free memory	31.99	31.99	0.00
	buffer_cache	16,272.00	16,240.00	-0.20
	fixed_sga	2.13	2.13	0.00
	log_buffer	16.25	16.25	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

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

Session Type	CPU Time	User I/O Time	Sys I/O Time
QMON Slaves	12,904,133	533,503	0
QMON Coordinator	1,468,788	0	0

Back to Streams Statistics
Back to Top

 

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

• The Spill Rate should be very close to zero
• The Diff in Percentage Spilled should be very close to zero or negative

Queue Schema and Name	Incoming per second	Outgoing per second	Spilled per second	Diff Pct Spilled
APPLSYS.WF_CONTROL	0	0	0	0

Back to Streams Statistics
Back to Top

 

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

• Rule Sets ordered by Evaluations

Ruleset Name	Evals	Fast Evals	SQL Execs	CPU Time	Elapsed Time
APPLSYS.WF_DEFERRED_R	30,941	0	0	280	224
APPLSYS.WF_DEFERRED_QUEUE_M_R	8,908	0	8,908	168	160
APPLSYS.WF_JAVA_DEFERRED_R	1,558	0	0	17	12
SYS.ALERT_QUE_R	0	0	0	0	0

Back to Streams Statistics
Back to Top

 

 

Resource Limit Stats

No data exists for this section of the report.

Back to Top

 

init.ora Parameters

Parameter Name	Begin value	End value (if different)
O7_DICTIONARY_ACCESSIBILITY	FALSE
_b_tree_bitmap_plans	FALSE
_fast_full_scan_enabled	FALSE
_like_with_bind_as_equality	TRUE
_sort_elimination_cost_ratio	5
_sqlexec_progression_cost	2147483647
_swrf_mmon_dbfus	FALSE
_swrf_mmon_flush	FALSE
_system_trig_enabled	TRUE
aq_tm_processes	1
background_dump_dest	/oracle/visdb/10.2.0/admin/VIS/bdump
compatible	10.2.0.3
control_files	/oracle/visdata/cntrl01.dbf, /oracle/visdata/cntrl02.dbf, /oracle/visdata/cntrl03.dbf
core_dump_dest	/oracle/visdb/10.2.0/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_file_multiblock_read_count	8
db_files	130
db_name	VIS
db_writer_processes	3
dml_locks	10000
fast_start_mttr_target	180
filesystemio_options	setall
hpux_sched_noage	178
java_pool_size	67108864
job_queue_processes	2
lock_sga	TRUE
log_buffer	16777216
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	16
pga_aggregate_target	21474836480
plsql_code_type	INTERPRETED
plsql_native_library_dir	/oracle/visdb/10.2.0/native
plsql_native_library_subdir_count	300
plsql_optimize_level	2
processes	3900
remote_login_passwordfile	EXCLUSIVE
replication_dependency_tracking	FALSE
session_cached_cursors	500
sessions	7800
sga_target	20401094656
shared_pool_reserved_size	314572800
shared_pool_size	3154116608
timed_statistics	TRUE
trace_enabled	FALSE
undo_management	AUTO
undo_tablespace	APPS_UNDOTS1
user_dump_dest	/oracle/visdb/10.2.0/admin/VIS/udump
utl_file_dir	/usr/tmp
workarea_size_policy	AUTO

Back to Top

End of Report