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 27-Dec-07 17:46:59 4740 165.7
End Snap: 57 27-Dec-07 18:47:06 4706 173.8
Elapsed:   60.13 (mins)    
DB Time:   654.40 (mins)    

 

Report Summary

Cache Sizes

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

Load Profile

  Per Second Per Transaction
Redo size: 9,551,197.40 29,947.68
Logical reads: 539,578.07 1,691.84
Block changes: 55,164.58 172.97
Physical reads: 152.85 0.48
Physical writes: 1,010.36 3.17
User calls: 12,417.84 38.94
Parses: 4,531.33 14.21
Hard parses: 2.35 0.01
Sorts: 3,382.50 10.61
Logons: 2.77 0.01
Executes: 31,049.68 97.36
Transactions: 318.93  

% Blocks changed per Read: 10.22 Recursive Call %: 81.80
Rollback per transaction %: 20.78 Rows per Sort: 11.89

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.41 Latch Hit %: 98.58
Parse CPU to Parse Elapsd %: 88.06 % Non-Parse CPU: 97.22

Shared Pool Statistics

  Begin End
Memory Usage %: 68.44 84.91
% SQL with executions>1: 82.56 80.20
% Memory for SQL w/exec>1: 60.22 54.33

Top 5 Timed Events

Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class
CPU time   36,116   92.0  
db file sequential read 365,581 1,755 5 4.5 User I/O
log file sync 455,003 538 1 1.4 Commit
log file parallel write 867,343 516 1 1.3 System I/O
SQL*Net more data from client 1,871,620 508 0 1.3 Network

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic Name Time (s) % of DB Time
DB CPU 36,116.23 91.98
sql execute elapsed time 34,637.93 88.22
PL/SQL execution elapsed time 7,650.56 19.49
inbound PL/SQL rpc elapsed time 7,061.29 17.98
Java execution elapsed time 1,370.99 3.49
parse time elapsed 1,202.28 3.06
hard parse elapsed time 569.11 1.45
repeated bind elapsed time 81.33 0.21
sequence load elapsed time 17.87 0.05
connection management call elapsed time 16.74 0.04
PL/SQL compilation elapsed time 10.97 0.03
hard parse (sharing criteria) elapsed time 6.25 0.02
failed parse elapsed time 2.59 0.01
hard parse (bind mismatch) elapsed time 1.39 0.00
DB time 39,263.72  
background elapsed time 1,845.55  
background cpu time 870.13  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait Class Waits %Time -outs Total Wait Time (s) Avg wait (ms) Waits /txn
User I/O 417,686 0.00 1,970 5 0.36
System I/O 982,000 0.00 639 1 0.85
Network 50,555,476 0.00 563 0 43.94
Commit 455,003 0.00 538 1 0.40
Application 68,516 0.20 515 8 0.06
Concurrency 3,700,005 0.11 483 0 3.22
Other 149,351 34.20 92 1 0.13
Configuration 5,738 0.00 2 0 0.00

Back to Wait Events Statistics
Back to Top

Wait Events

Event Waits %Time -outs Total Wait Time (s) Avg wait (ms) Waits /txn
db file sequential read 365,581 0.00 1,755 5 0.32
log file sync 455,003 0.00 538 1 0.40
log file parallel write 867,343 0.00 516 1 0.75
SQL*Net more data from client 1,871,620 0.00 508 0 1.63
enq: TM - contention 116 78.45 323 2783 0.00
enq: TX - index contention 53,530 0.00 173 3 0.05
db file scattered read 26,473 0.00 155 6 0.02
latch: cache buffers chains 2,819,429 0.00 139 0 2.45
enq: UL - contention 2,211 1.58 121 55 0.00
db file parallel write 111,352 0.00 115 1 0.10
cursor: pin S wait on X 4,444 93.77 78 17 0.00
read by other session 23,327 0.00 56 2 0.02
buffer busy waits 799,267 0.00 51 0 0.69
enq: TX - row lock contention 456 2.41 45 99 0.00
SQL*Net more data to client 1,590,172 0.00 35 0 1.38
PX Deq Credit: send blkd 22,666 0.00 34 2 0.02
library cache load lock 927 0.00 28 31 0.00
SQL*Net message to client 47,093,684 0.00 20 0 40.93
rdbms ipc reply 9 77.78 16 1759 0.00
SQL*Net break/reset to client 65,700 0.00 14 0 0.06
enq: RO - fast object reuse 33 3.03 12 357 0.00
kksfbc child completion 189 84.66 9 47 0.00
wait list latch free 393 0.00 8 20 0.00
os thread startup 77 0.00 6 73 0.00
control file sequential read 1,576 0.00 5 3 0.00
Streams AQ: qmn coordinator waiting for slave to start 2 50.00 5 2453 0.00
PX Deq: Signal ACK 421 23.52 4 10 0.00
local write wait 1,213 0.00 4 3 0.00
latch: library cache 6,011 0.00 3 1 0.01
latch: object queue header operation 27,620 0.00 3 0 0.02
latch: undo global data 3,322 0.00 3 1 0.00
control file parallel write 1,729 0.00 3 2 0.00
enq: TX - contention 3,311 0.00 2 1 0.00
enq: DV - contention 230 0.00 2 7 0.00
latch free 2,160 0.00 2 1 0.00
latch: In memory undo latch 10,422 0.00 1 0 0.01
buffer deadlock 48,666 99.30 1 0 0.04
library cache lock 13 0.00 1 94 0.00
enq: HW - contention 2,410 0.00 1 0 0.00
latch: cache buffers lru chain 372 0.00 1 3 0.00
LGWR wait for redo copy 30,871 0.01 1 0 0.03
latch: library cache pin 1,561 0.00 1 1 0.00
enq: SQ - contention 3,000 0.00 1 0 0.00
latch: redo allocation 1,655 0.00 1 0 0.00
enq: TX - allocate ITL entry 238 0.00 1 2 0.00
row cache lock 1,060 0.00 0 0 0.00
latch: row cache objects 579 0.00 0 1 0.00
cursor: pin S 2,716 0.00 0 0 0.00
latch: session allocation 935 0.00 0 0 0.00
enq: FB - contention 758 0.00 0 0 0.00
library cache pin 1,698 0.00 0 0 0.00
latch: object queue header heap 78 0.00 0 1 0.00
latch: shared pool 349 0.00 0 0 0.00
latch: library cache lock 185 0.00 0 0 0.00
direct path read 608 0.00 0 0 0.00
latch: messages 119 0.00 0 0 0.00
reliable message 36 0.00 0 1 0.00
enq: CU - contention 4 0.00 0 7 0.00
latch: cache buffer handles 216 0.00 0 0 0.00
L1 validation 1 100.00 0 22 0.00
write complete waits 5 0.00 0 4 0.00
PX qref latch 2,523 98.22 0 0 0.00
cursor: pin X 1 100.00 0 12 0.00
latch: redo writing 85 0.00 0 0 0.00
enq: PS - contention 40 0.00 0 0 0.00
latch: checkpoint queue latch 10 0.00 0 1 0.00
cursor: mutex S 138 0.00 0 0 0.00
cursor: mutex X 315 0.00 0 0 0.00
latch: enqueue hash chains 20 0.00 0 0 0.00
latch: parallel query alloc buffer 6 0.00 0 0 0.00
direct path write 440 0.00 0 0 0.00
enq: US - contention 1 0.00 0 0 0.00
direct path write temp 38 0.00 0 0 0.00
direct path read temp 6 0.00 0 0 0.00
SQL*Net message from client 47,093,712 0.00 9,091,630 193 40.93
pipe get 26,901 16.14 21,176 787 0.02
Streams AQ: qmn slave idle wait 2,305 0.04 12,755 5534 0.00
Streams AQ: waiting for messages in the queue 2,386 100.00 11,692 4900 0.00
PX Idle Wait 3,398 77.22 5,668 1668 0.00
Streams AQ: qmn coordinator idle wait 1,650 31.94 3,514 2130 0.00
Streams AQ: waiting for time management or cleanup tasks 2,629 41.12 3,496 1330 0.00
PL/SQL lock timer 272 99.63 2,985 10973 0.00
jobq slave wait 708 91.81 2,035 2874 0.00
PX Deq: Execution Msg 12,527 0.00 120 10 0.01
PX Deq: Msg Fragment 9,091 0.00 4 0 0.01
PX Deq: Execute Reply 4,812 0.00 4 1 0.00
PX Deq Credit: need buffer 3,399 0.00 4 1 0.00
PX Deq: Table Q Normal 7,783 0.00 3 0 0.01
PX Deq: Join ACK 569 0.00 0 1 0.00
PX Deq: Parse Reply 325 0.00 0 1 0.00
class slave wait 3 0.00 0 2 0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

Event Waits %Time -outs Total Wait Time (s) Avg wait (ms) Waits /txn
log file parallel write 867,347 0.00 516 1 0.75
db file parallel write 111,352 0.00 115 1 0.10
events in waitclass Other 45,668 0.01 8 0 0.04
db file scattered read 1,193 0.00 5 4 0.00
control file sequential read 821 0.00 5 6 0.00
os thread startup 61 0.00 4 74 0.00
db file sequential read 1,114 0.00 4 3 0.00
control file parallel write 1,729 0.00 3 2 0.00
direct path read 608 0.00 0 0 0.00
latch: redo writing 85 0.00 0 0 0.00
buffer busy waits 11 0.00 0 1 0.00
latch: cache buffers chains 25 0.00 0 0 0.00
log file sync 2 0.00 0 0 0.00
direct path write 333 0.00 0 0 0.00
latch: library cache 1 0.00 0 0 0.00
rdbms ipc message 2,175,416 0.50 36,834 17 1.89
Streams AQ: qmn slave idle wait 1,867 0.00 10,226 5477 0.00
Streams AQ: qmn coordinator idle wait 1,650 31.94 3,514 2130 0.00
Streams AQ: waiting for time management or cleanup tasks 2,629 41.12 3,496 1330 0.00
smon timer 102,733 0.00 3,474 34 0.09
pmon timer 1,452 80.37 3,419 2355 0.00
class slave wait 1 0.00 0 2 0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic Total
AVG_BUSY_TIME 166,547
AVG_IDLE_TIME 194,006
AVG_IOWAIT_TIME 7,875
AVG_SYS_TIME 10,699
AVG_USER_TIME 155,735
BUSY_TIME 3,999,849
IDLE_TIME 4,658,935
IOWAIT_TIME 191,727
SYS_TIME 259,534
USER_TIME 3,740,315
LOAD 0
OS_CPU_WAIT_TIME 138,852,100
RSRC_MGR_CPU_WAIT_TIME 0
VM_IN_BYTES 413,688
VM_OUT_BYTES 0
PHYSICAL_MEMORY_BYTES ###############
NUM_CPUS 24
NUM_CPU_SOCKETS 24

Back to Wait Events Statistics
Back to Top

Service Statistics

Service Name DB Time (s) DB CPU (s) Physical Reads Logical Reads
SYS$USERS 39,279.50 36,125.90 545,456 1,944,265,005
SYS$BACKGROUND 0.00 0.00 6,336 2,979,455
VIS 0.00 0.00 0 0

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

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 414438 196142 3699969 47823 0 0 50540188 56252
SYS$BACKGROUND 3250 876 98 450 0 0 0 0

Back to Wait Events Statistics
Back to Top

 

SQL Statistics

Back to Top

SQL ordered by Elapsed Time

Elapsed Time (s) CPU Time (s) Executions Elap per Exec (s) % Total DB Time SQL Id SQL Module SQL Text
3,897 3,888 8 487.14 9.93 ghw9svn8x4vzu WSHPSRS BEGIN WSH_PICK_LIST.RELEASE_BA...
2,211 2,216 10 221.06 5.63 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
1,498 1,484 12 124.82 3.81 1g4jfpxpupdt6 OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
1,350 1,348 299 4.52 3.44 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
1,082 1,066 16 67.65 2.76 7g05xfvc5vp74 ARTERRPW BEGIN arp_run.revenue_recognit...
958 934 137,477 0.01 2.44 3prk3vg9u0abb JDBC Thin Client BEGIN FND_GLOBAL.APPS_INITIA...
690 687 140,771 0.00 1.76 9sf243fdjmdmh JDBC Thin Client begin fnd_global.apps_initiali...
657 636 101,266 0.01 1.67 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
609 603 1,296 0.47 1.55 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
595 586 63,101 0.01 1.51 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
533 532 984 0.54 1.36 0qcpgw43yqj5r WSHPSRS ( SELECT DISTINCT WDD.SOURCE_L...
494 479 56,480 0.01 1.26 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...
487 463 56,500 0.01 1.24 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
472 471 338,128 0.00 1.20 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
448 440 5,405 0.08 1.14 a957tvxz9w038 icx.por.req.server.RequisitionAM BEGIN :1 := por_util_pkg.inter...
447 446 11 40.60 1.14 1du9v021t8m46 ARGLTP insert into gl_interface(creat...
445 422 5,000 0.09 1.13 2fjd6cndjby9p ARTERRPW INSERT INTO RA_CUST_TRX_LINE_G...
442 427 56,476 0.01 1.13 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
415 394 171,683 0.00 1.06 3b3psftuyks81 INVTTMTX BEGIN INV_TXNSTUB_PUB.postTran...
414 404 8 51.80 1.06 8vmj377jqyqwq WSHASCSRS BEGIN WSH_BATCH_PROCESS.CONFIR...
402 380 171,685 0.00 1.02 gf1u933c95jb5 INVTTMTX DECLARE l_ret_stat varchar2...
395 355 185,008 0.00 1.00 473dq7tb653mp CSCCCCRC declare p varchar2(32767); ...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

CPU Time (s) Elapsed Time (s) Executions CPU per Exec (s) % Total DB Time SQL Id SQL Module SQL Text
3,888 3,897 8 486.02 9.93 ghw9svn8x4vzu WSHPSRS BEGIN WSH_PICK_LIST.RELEASE_BA...
2,216 2,211 10 221.62 5.63 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
1,484 1,498 12 123.65 3.81 1g4jfpxpupdt6 OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
1,348 1,350 299 4.51 3.44 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
1,066 1,082 16 66.62 2.76 7g05xfvc5vp74 ARTERRPW BEGIN arp_run.revenue_recognit...
934 958 137,477 0.01 2.44 3prk3vg9u0abb JDBC Thin Client BEGIN FND_GLOBAL.APPS_INITIA...
687 690 140,771 0.00 1.76 9sf243fdjmdmh JDBC Thin Client begin fnd_global.apps_initiali...
636 657 101,266 0.01 1.67 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
603 609 1,296 0.47 1.55 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
586 595 63,101 0.01 1.51 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
532 533 984 0.54 1.36 0qcpgw43yqj5r WSHPSRS ( SELECT DISTINCT WDD.SOURCE_L...
479 494 56,480 0.01 1.26 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...
471 472 338,128 0.00 1.20 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
463 487 56,500 0.01 1.24 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
446 447 11 40.57 1.14 1du9v021t8m46 ARGLTP insert into gl_interface(creat...
440 448 5,405 0.08 1.14 a957tvxz9w038 icx.por.req.server.RequisitionAM BEGIN :1 := por_util_pkg.inter...
427 442 56,476 0.01 1.13 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
422 445 5,000 0.08 1.13 2fjd6cndjby9p ARTERRPW INSERT INTO RA_CUST_TRX_LINE_G...
404 414 8 50.45 1.06 8vmj377jqyqwq WSHASCSRS BEGIN WSH_BATCH_PROCESS.CONFIR...
394 415 171,683 0.00 1.06 3b3psftuyks81 INVTTMTX BEGIN INV_TXNSTUB_PUB.postTran...
380 402 171,685 0.00 1.02 gf1u933c95jb5 INVTTMTX DECLARE l_ret_stat varchar2...
355 395 185,008 0.00 1.00 473dq7tb653mp CSCCCCRC declare p varchar2(32767); ...

Back to SQL Statistics
Back to Top

SQL ordered by Gets

Buffer Gets Executions Gets per Exec %Total CPU Time (s) Elapsed Time (s) SQL Id SQL Module SQL Text
276,115,411 8 34,514,426.38 14.18 3888.20 3897.12 ghw9svn8x4vzu WSHPSRS BEGIN WSH_PICK_LIST.RELEASE_BA...
170,656,737 10 17,065,673.70 8.77 2216.17 2210.59 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
134,957,197 12 11,246,433.08 6.93 1483.83 1497.84 1g4jfpxpupdt6 OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
114,754,452 16 7,172,153.25 5.89 1065.99 1082.46 7g05xfvc5vp74 ARTERRPW BEGIN arp_run.revenue_recognit...
82,233,640 984 83,570.77 4.22 532.48 532.89 0qcpgw43yqj5r WSHPSRS ( SELECT DISTINCT WDD.SOURCE_L...
48,840,959 11 4,440,087.18 2.51 446.30 446.60 1du9v021t8m46 ARGLTP insert into gl_interface(creat...
47,508,766 299 158,892.19 2.44 1348.23 1350.00 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
45,569,532 60 759,492.20 2.34 275.55 275.56 3n8tvc1tsqua0 WSHINTERFACES SELECT DISTINCT WTS.STOP_ID FR...
39,989,961 1,525,131 26.22 2.05 325.29 343.11 66tmsr3446uqn OEXOETEL SELECT WIAS.ACTIVITY_STATUS, ...
39,676,939 63,101 628.78 2.04 586.23 594.73 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
37,035,121 5,000 7,407.02 1.90 421.67 444.66 2fjd6cndjby9p ARTERRPW INSERT INTO RA_CUST_TRX_LINE_G...
36,867,036 56,476 652.79 1.89 427.39 441.73 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
36,771,039 56,500 650.81 1.89 463.11 486.64 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
33,104,249 11 3,009,477.18 1.70 264.57 264.85 bp8crdjba8zgt ARGLTP update ra_cust_trx_line_gl_dis...
32,976,352 171,683 192.08 1.69 394.03 415.29 3b3psftuyks81 INVTTMTX BEGIN INV_TXNSTUB_PUB.postTran...
32,974,932 171,685 192.07 1.69 380.50 401.65 gf1u933c95jb5 INVTTMTX DECLARE l_ret_stat varchar2...
32,164,270 1,296 24,818.11 1.65 602.98 609.38 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
28,407,357 56,480 502.96 1.46 479.41 494.16 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...
27,703,036 8,146,376 3.40 1.42 225.18 230.43 c4y7jp0q2awbf ? @blade1.ebs.hp.com (TNS V1-V3) SELECT PROFILE_OPTION_VALUE FR...
27,390,224 137,477 199.23 1.41 934.17 958.33 3prk3vg9u0abb JDBC Thin Client BEGIN FND_GLOBAL.APPS_INITIA...
26,384,544 10,000 2,638.45 1.36 197.15 361.31 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
22,335,099 185,008 120.73 1.15 355.23 394.57 473dq7tb653mp CSCCCCRC declare p varchar2(32767); ...
20,808,793 151,978 136.92 1.07 314.78 314.85 bcym7s1bp0wxs OEXOETEL SELECT WIA.NAME FROM WF_ITEM_A...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical Reads Executions Reads per Exec %Total CPU Time (s) Elapsed Time (s) SQL Id SQL Module SQL Text
54,454 10,000 5.45 9.87 197.15 361.31 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
43,999 2,166 20.31 7.98 178.30 354.59 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
29,147 19,482 1.50 5.29 207.27 341.29 1q78dwnrrkf6c asn.lead.server.LeadUwqAM BEGIN ASN_SALES_PVT.Lead_Proce...
28,495 119,999 0.24 5.17 181.88 318.83 5qtxtsar19v4k PYUSLV insert into pay_run_result_val...
10,269 185,008 0.06 1.86 355.23 394.57 473dq7tb653mp CSCCCCRC declare p varchar2(32767); ...
2,120 12 176.67 0.38 1483.83 1497.84 1g4jfpxpupdt6 OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
1,087 171,685 0.01 0.20 95.00 98.48 25bkagv1j2xf7 INVTTMTX INSERT INTO MTL_MATERIAL_TRAN...
702 63,101 0.01 0.13 586.23 594.73 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
668 299 2.23 0.12 1348.23 1350.00 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
665 8 83.13 0.12 4.01 5.90 6djyj1t4djs12 RAXMTR select /*+ parallel(t, 16) par...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows Processed Rows per Exec CPU per Exec (s) Elap per Exec (s) SQL Id SQL Module SQL Text
8,146,376 3,263,810 0.40 0.00 0.00 c4y7jp0q2awbf ? @blade1.ebs.hp.com (TNS V1-V3) SELECT PROFILE_OPTION_VALUE FR...
6,620,799 5,378,102 0.81 0.00 0.00 6cjfxb1c4kx16 ? @blade1.ebs.hp.com (TNS V1-V3) SELECT PROFILE_OPTION_ID, APP...
2,716,298 2,716,159 1.00 0.00 0.00 bc7t6t6jfx2n7 ? @blade1.ebs.hp.com (TNS V1-V3) SELECT VERSION FROM FND_CACHE_...
2,527,534 2,527,219 1.00 0.00 0.00 9dvfguzd15kpv JDBC Thin Client SELECT VALUE FROM V$NLS_PARAME...
1,525,131 788,577 0.52 0.00 0.00 66tmsr3446uqn OEXOETEL SELECT WIAS.ACTIVITY_STATUS, ...
700,686 339,727 0.48 0.00 0.00 4g5vzcyf68n9w ? @blade1.ebs.hp.com (TNS V1-V3) SELECT PROFILE_OPTION_VALUE FR...
573,713 246,905 0.43 0.00 0.00 0wrz2kbatczjk CSCCCCRC SELECT EXECUTE_FLAG FROM JTF_U...
536,981 536,970 1.00 0.00 0.00 avc1jqzz04wpr JDBC Thin Client SELECT 'x' FROM DUAL
453,941 453,925 1.00 0.00 0.00 0w785m9gmw41a ? @blade1.ebs.hp.com (TNS V1-V3) SELECT USERENV('SESSIONID') FR...
452,721 265,618 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

Parse Calls Executions % Total Parses SQL Id SQL Module SQL Text
540,413 6,620,799 3.31 6cjfxb1c4kx16 ? @blade1.ebs.hp.com (TNS V1-V3) SELECT PROFILE_OPTION_ID, APP...
536,977 536,981 3.28 avc1jqzz04wpr JDBC Thin Client SELECT 'x' FROM DUAL
499,569 8,146,376 3.06 c4y7jp0q2awbf ? @blade1.ebs.hp.com (TNS V1-V3) SELECT PROFILE_OPTION_VALUE FR...
338,135 338,128 2.07 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
317,878 317,875 1.94 fmfdkztk8vx23   SELECT CATEGORY, SEVERITY, F...
271,425 453,941 1.66 0w785m9gmw41a ? @blade1.ebs.hp.com (TNS V1-V3) SELECT USERENV('SESSIONID') FR...
270,205 452,721 1.65 5as61q63aqmts ? @blade1.ebs.hp.com (TNS V1-V3) SELECT A.APPLICATION_SHORT_NAM...
270,204 2,716,298 1.65 bc7t6t6jfx2n7 ? @blade1.ebs.hp.com (TNS V1-V3) SELECT VERSION FROM FND_CACHE_...
270,203 452,718 1.65 29x3dahwzdj8b ? @blade1.ebs.hp.com (TNS V1-V3) SELECT U.USER_NAME, NVL(U.EMP...
270,203 452,718 1.65 95pbs94n69z3d ? @blade1.ebs.hp.com (TNS V1-V3) SELECT NVL(MULTI_ORG_FLAG, 'N...
270,202 270,205 1.65 fhqzxap2n0ybj ? @blade1.ebs.hp.com (TNS V1-V3) select NAME from HR_OPERATING_...
270,201 452,714 1.65 bvyqm6268u2as ? @blade1.ebs.hp.com (TNS V1-V3) SELECT NODE_NAME FROM FND_NODE...
260,599 260,599 1.59 cwyx16zn1hpfb JDBC Thin Client select parameter, value from ...
185,009 185,008 1.13 473dq7tb653mp CSCCCCRC declare p varchar2(32767); ...
171,685 171,685 1.05 6gnth2mfbs2nq INVTTMTX declare v_ret number := 0...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b) Executions % Total SQL Id SQL Module SQL Text
11,605,288 8 0.37 b3an778qn1q49 RAXMTR select /*+ parallel(t, 16) par...
9,221,664 8 0.29 610p9aymv2pcv RAXMTR select /*+ parallel(t, 16) par...
3,405,153 8 0.11 6djyj1t4djs12 RAXMTR select /*+ parallel(t, 16) par...
1,077,898 25,971 0.03 dzt4ys8ynkyrj CSCCCCRC INSERT INTO CS_INCIDENTS_AUDIT...

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;
3n8tvc1tsqua0 SELECT DISTINCT WTS.STOP_ID FROM WSH_TRIP_STOPS WTS, WSH_TRIP_STOPS WTS2, WSH_DELIVERY_LEGS WDL, WSH_DELIVERY_LEGS WDL2, WSH_DELIVERY_ASSIGNMENTS WDA, WSH_DELIVERY_ASSIGNMENTS WDA2, WSH_DELIVERY_DETAILS WDD, WSH_DELIVERY_DETAILS WDD2 WHERE WTS.BATCH_ID = :B1 AND WTS.STOP_ID = WDL.PICK_UP_STOP_ID AND WDA.DELIVERY_ID = WDL.DELIVERY_ID AND WDA.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID AND WDD.SOURCE_CODE = 'OE' AND NVL(WDD.OE_INTERFACED_FLAG, 'N') <> 'Y' AND WDD.RELEASED_STATUS <> 'D' AND WTS2.BATCH_ID = :B1 AND WTS2.STOP_ID = WDL2.PICK_UP_STOP_ID AND WDA2.DELIVERY_ID = WDL2.DELIVERY_ID AND WDA2.DELIVERY_DETAIL_ID = WDD2.DELIVERY_DETAIL_ID AND WDD2.SOURCE_LINE_ID = WDD.SOURCE_LINE_ID AND WDD2.SOURCE_CODE = 'OE' AND NVL(WDD2.OE_INTERFACED_FLAG, 'N') <> 'Y' AND WDD2.RELEASED_STATUS <> 'D' AND WTS2.STOP_ID <> WTS.STOP_ID
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;
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
5qtxtsar19v4k insert into pay_run_result_values(input_value_id, run_result_id, result_value, formula_result_flag) values (:b1, :b2, :b3:b4, :b5:b6)
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
6gnth2mfbs2nq declare v_ret number := 0; begin if (INV_TABLE_LOCK_PVT.lock_onhand_records(:1, :2, :3, :4, :5, :6, :7) ) then v_ret := 1; end if; :8 := v_ret; end;
6h2tpcxpymqu7 BEGIN :1 := FND_AOLJ_UTIL.is_Valid_ICX(:2, NULL, 'Y', TRUE, TRUE, NULL, NULL, NULL, NULL, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, TRUE);:19 := fnd_session_management.g_enc_key;:20 := fnd_session_management.g_mac_key;END;
7g05xfvc5vp74 BEGIN arp_run.revenue_recognition( :errbuf, :rc, :A0, :A1, :A2); END;
8c8cf4vtv4tx2 SELECT * FROM ( SELECT LeadEO.sales_lead_id as SalesLeadId , to_char(hz_timezone_pub.convert_datetime(:1, hcp.timezone_id, SYSDATE), 'HH:MI AM ') ||' '||ht.standard_time_short_code as PrimaryContactLocalTime , SUBSTRB(LeadEO.description, 1, 240) as Description , hp.party_name as ContactName , custParty.party_name as CustomerName , aslt.meaning as RankName , ast.meaning as LeadStatus , ROUND(SYSDATE - LeadEO.creation_date) as Age , DECODE(LeadEO.status_code, 'CONVERTED_TO_OPPORTUNITY', 'ASNCnvToOpptyDsbld', 'ASNCnvToOpptyEnbld') as ASNLeadLstCnvToOppty , LeadEO.customer_id , hp.party_id , LeadEO.primary_contact_party_id , hr.relationship_id FROM as_sales_leads LeadEO , ( SELECT /*+ no_merge */ distinct aaa.sales_lead_id, aaa.customer_id FROM as_accesses_all aaa WHERE aaa.sales_lead_id IS NOT NULL AND aaa.lead_id IS NULL AND aaa.salesforce_id = :2) secu , as_statuses_tl ast , as_sales_lead_ranks_tl aslt , hz_parties CustParty , hz_parties hp, hz_relationships hr , hz_contact_points hcp , hz_timezones ht , ams_source_codes amsc WHERE LeadEO.sales_lead_id = secu.sales_lead_id AND LeadEO.customer_id = secu.customer_id AND LeadEO.status_code = ast.status_code AND ast.language = USERENV('LANG') AND LeadEO.lead_rank_id = aslt.rank_id (+) AND aslt.language (+) = USERENV('LANG') AND LeadEO.customer_id = CustParty.party_id AND LeadEO.primary_contact_party_id = hr.party_id(+) AND hr.subject_id = hp.party_id (+) AND hr.subject_table_name (+) = 'HZ_PARTIES' AND hr.object_id(+) = LeadEO.customer_id AND hr.object_table_name (+) = 'HZ_PARTIES' AND LeadEO.primary_contact_party_id = hcp.owner_table_id(+) AND hcp.owner_table_name (+) = 'HZ_PARTIES' AND hcp.primary_flag (+) = 'Y' AND hcp.contact_point_type (+) = 'PHONE' AND hcp.timezone_id = ht.timezone_id (+) AND LeadEO.source_promotion_id = amsc.source_code_id AND amsc.source_code_for_id = :3 AND LeadEO.status_code = :4 ORDER BY age )
8vmj377jqyqwq BEGIN WSH_BATCH_PROCESS.CONFIRM_DELIVERY_SRS( :errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8, :A9, :A10, :A11, :A12, :A13, :A14, :A15, :A16, :A17, :A18, :A19, :A20, :A21, :A22); END;
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
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
dzt4ys8ynkyrj INSERT INTO CS_INCIDENTS_AUDIT_B ( INCIDENT_AUDIT_ID , INCIDENT_ID , LAST_UPDATE_DATE , LAST_UPDATED_BY , CREATION_DATE , CREATED_BY , LAST_UPDATE_LOGIN , CREATION_TIME , INCIDENT_STATUS_ID , OLD_INCIDENT_STATUS_ID , CHANGE_INCIDENT_STATUS_FLAG , INCIDENT_TYPE_ID , OLD_INCIDENT_TYPE_ID , CHANGE_INCIDENT_TYPE_FLAG , INCIDENT_URGENCY_ID , OLD_INCIDENT_URGENCY_ID , CHANGE_INCIDENT_URGENCY_FLAG , INCIDENT_SEVERITY_ID , OLD_INCIDENT_SEVERITY_ID , CHANGE_INCIDENT_SEVERITY_FLAG, INCIDENT_OWNER_ID , OLD_INCIDENT_OWNER_ID , CHANGE_INCIDENT_OWNER_FLAG , CREATE_MANUAL_ACTION , ACTION_ID , EXPECTED_RESOLUTION_DATE , OLD_EXPECTED_RESOLUTION_DATE , CHANGE_RESOLUTION_FLAG , NEW_WORKFLOW_FLAG , WORKFLOW_PROCESS_NAME , WORKFLOW_PROCESS_ITEMKEY , GROUP_ID, OLD_GROUP_ID, CHANGE_GROUP_FLAG, GROUP_TYPE, OLD_GROUP_TYPE, CHANGE_GROUP_TYPE_FLAG, INV_PLATFORM_ORG_ID, OLD_INV_PLATFORM_ORG_ID, CHANGE_PLATFORM_ORG_ID_FLAG, OWNER_ASSIGNED_TIME, OLD_OWNER_ASSIGNED_TIME, CHANGE_ASSIGNED_TIME_FLAG, OBLIGATION_DATE, OLD_OBLIGATION_DATE, CHANGE_OBLIGATION_FLAG, SITE_ID, OLD_SITE_ID, CHANGE_SITE_FLAG, BILL_TO_CONTACT_ID, OLD_BILL_TO_CONTACT_ID, CHANGE_BILL_TO_FLAG, SHIP_TO_CONTACT_ID, OLD_SHIP_TO_CONTACT_ID, CHANGE_SHIP_TO_FLAG, CLOSE_DATE, OLD_CLOSE_DATE, CHANGE_CLOSE_DATE_FLAG, CUSTOMER_PRODUCT_ID, OLD_CUSTOMER_PRODUCT_ID, CHANGE_CUSTOMER_PRODUCT_FLAG, PLATFORM_ID, OLD_PLATFORM_ID, CHANGE_PLATFORM_ID_FLAG, PRODUCT_REVISION, OLD_PRODUCT_REVISION , CHANGE_PRODUCT_REVISION_FLAG, COMPONENT_VERSION, OLD_COMPONENT_VERSION, CHANGE_COMP_VER_FLAG, SUBCOMPONENT_VERSION, OLD_SUBCOMPONENT_VERSION, CHANGE_SUBCOMP_VER_FLAG, CP_COMPONENT_ID, OLD_CP_COMPONENT_ID, CHANGE_CP_COMPONENT_ID_FLAG, CP_COMPONENT_VERSION_ID, OLD_CP_COMPONENT_VERSION_ID, CHANGE_CP_COMP_VER_ID_FLAG, CP_SUBCOMPONENT_ID, OLD_CP_SUBCOMPONENT_ID, CHANGE_CP_SUBCOMPONENT_ID_FLAG, CP_SUBCOMPONENT_VERSION_ID, OLD_CP_SUBCOMPONENT_VERSION_ID, CHANGE_CP_SUBCOMP_VER_ID_FLAG, CP_REVISION_ID, OLD_CP_REVISION_ID, CHANGE_CP_REVISION_ID_FLAG, INV_ITEM_REVISION, OLD_INV_ITEM_REVISION, CHANGE_INV_ITEM_REVISION, INV_COMPONENT_ID, OLD_INV_COMPONENT_ID, CHANGE_INV_COMPONENT_ID, INV_COMPONENT_VERSION, OLD_INV_COMPONENT_VERSION, CHANGE_INV_COMPONENT_VERSION, INV_SUBCOMPONENT_ID, OLD_INV_SUBCOMPONENT_ID, CHANGE_INV_SUBCOMPONENT_ID, INV_SUBCOMPONENT_VERSION, OLD_INV_SUBCOMPONENT_VERSION, CHANGE_INV_SUBCOMP_VERSION, TERRITORY_ID, OLD_TERRITORY_ID, CHANGE_TERRITORY_ID_FLAG, RESOURCE_TYPE, OLD_RESOURCE_TYPE, CHANGE_RESOURCE_TYPE_FLAG, OBJECT_VERSION_NUMBER, AUDIT_FIELD, INVENTORY_ITEM_ID , OLD_INVENTORY_ITEM_ID, CHANGE_INVENTORY_ITEM_FLAG, INV_ORGANIZATION_ID, OLD_INV_ORGANIZATION_ID, CHANGE_INV_ORGANIZATION_FLAG, STATUS_FLAG , OLD_STATUS_FLAG , CHANGE_STATUS_FLAG , INCIDENT_DATE, OLD_INCIDENT_DATE, CHANGE_INCIDENT_DATE_FLAG, PLATFORM_VERSION_ID, OLD_PLATFORM_VERSION_ID, CHANGE_PLAT_VER_ID_FLAG, LANGUAGE_ID, OLD_LANGUAGE_ID, CHANGE_LANGUAGE_ID_FLAG, UPGRADE_FLAG_FOR_CREATE , OLD_INCIDENT_NUMBER , INCIDENT_NUMBER , OLD_CUSTOMER_ID , CUSTOMER_ID , OLD_BILL_TO_SITE_USE_ID , BILL_TO_SITE_USE_ID , OLD_EMPLOYEE_ID , EMPLOYEE_ID , OLD_SHIP_TO_SITE_USE_ID , SHIP_TO_SITE_USE_ID , OLD_PROBLEM_CODE , PROBLEM_CODE , OLD_ACTUAL_RESOLUTION_DATE , ACTUAL_RESOLUTION_DATE , OLD_INSTALL_SITE_USE_ID , INSTALL_SITE_USE_ID , OLD_CURRENT_SERIAL_NUMBER , CURRENT_SERIAL_NUMBER , OLD_SYSTEM_ID , SYSTEM_ID , OLD_INCIDENT_ATTRIBUTE_1 , INCIDENT_ATTRIBUTE_1 , OLD_INCIDENT_ATTRIBUTE_2 , INCIDENT_ATTRIBUTE_2 , OLD_INCIDENT_ATTRIBUTE_3 , INCIDENT_ATTRIBUTE_3 , OLD_INCIDENT_ATTRIBUTE_4 , INCIDENT_ATTRIBUTE_4 , OLD_INCIDENT_ATTRIBUTE_5 , INCIDENT_ATTRIBUTE_5 , OLD_INCIDENT_ATTRIBUTE_6 , INCIDENT_ATTRIBUTE_6 , OLD_INCIDENT_ATTRIBUTE_7 , INCIDENT_ATTRIBUTE_7 , OLD_INCIDENT_ATTRIBUTE_8 , INCIDENT_ATTRIBUTE_8 , OLD_INCIDENT_ATTRIBUTE_9 , INCIDENT_ATTRIBUTE_9 , OLD_INCIDENT_ATTRIBUTE_10 , INCIDENT_ATTRIBUTE_10 , OLD_INCIDENT_ATTRIBUTE_11 , INCIDENT_ATTRIBUTE_11 , OLD_INCIDENT_ATTRIBUTE_12 , INCIDENT_ATTRIBUTE_12 , OLD_INCIDENT_ATTRIBUTE_13 , INCIDENT_ATTRIBUTE_13 , OLD_INCIDENT_ATTRIBUTE_14 , INCIDENT_ATTRIBUTE_14 , OLD_INCIDENT_ATTRIBUTE_15 , INCIDENT_ATTRIBUTE_15 , OLD_INCIDENT_CONTEXT , INCIDENT_CONTEXT , OLD_RESOLUTION_CODE , RESOLUTION_CODE , OLD_ORIGINAL_ORDER_NUMBER , ORIGINAL_ORDER_NUMBER , OLD_ORG_ID , ORG_ID , OLD_PURCHASE_ORDER_NUMBER , PURCHASE_ORDER_NUMBER , O LD_PUBLISH_FLAG , PUBLISH_FLAG , OLD_QA_COLLECTION_ID , QA_COLLECTION_ID , OLD_CONTRACT_ID , CONTRACT_ID , OLD_CONTRACT_NUMBER , CONTRACT_NUMBER , OLD_CONTRACT_SERVICE_ID , CONTRACT_SERVICE_ID , OLD_TIME_ZONE_ID , TIME_ZONE_ID , OLD_ACCOUNT_ID , ACCOUNT_ID , OLD_TIME_DIFFERENCE , TIME_DIFFERENCE , OLD_CUSTOMER_PO_NUMBER , CUSTOMER_PO_NUMBER , OLD_CUSTOMER_TICKET_NUMBER , CUSTOMER_TICKET_NUMBER , OLD_CUSTOMER_SITE_ID , CUSTOMER_SITE_ID , OLD_CALLER_TYPE , CALLER_TYPE , OLD_SECURITY_GROUP_ID , OLD_ORIG_SYSTEM_REFERENCE , ORIG_SYSTEM_REFERENCE , OLD_ORIG_SYSTEM_REFERENCE_ID , ORIG_SYSTEM_REFERENCE_ID , REQUEST_ID , PROGRAM_APPLICATION_ID , PROGRAM_ID , PROGRAM_UPDATE_DATE , OLD_PROJECT_NUMBER , PROJECT_NUMBER , OLD_PLATFORM_VERSION , PLATFORM_VERSION , OLD_DB_VERSION , DB_VERSION , OLD_CUST_PREF_LANG_ID , CUST_PREF_LANG_ID , OLD_TIER , TIER , OLD_CATEGORY_ID , CATEGORY_ID , OLD_OPERATING_SYSTEM , OPERATING_SYSTEM , OLD_OPERATING_SYSTEM_VERSION , OPERATING_SYSTEM_VERSION , OLD_DATABASE , DATABASE , OLD_GROUP_TERRITORY_ID , GROUP_TERRITORY_ID , OLD_COMM_PREF_CODE , COMM_PREF_CODE , OLD_LAST_UPDATE_CHANNEL , LAST_UPDATE_CHANNEL , OLD_CUST_PREF_LANG_CODE , CUST_PREF_LANG_CODE , OLD_ERROR_CODE , ERROR_CODE , OLD_CATEGORY_SET_ID , CATEGORY_SET_ID , OLD_EXTERNAL_REFERENCE , EXTERNAL_REFERENCE , OLD_INCIDENT_OCCURRED_DATE , INCIDENT_OCCURRED_DATE , OLD_INCIDENT_RESOLVED_DATE , INCIDENT_RESOLVED_DATE , OLD_INC_RESPONDED _BY_DATE , INC_RESPONDED_BY_DATE , OLD_INCIDENT_LOCATION_ID , INCIDENT_LOCATION_ID , OLD_INCIDENT_ADDRESS , INCIDENT_ADDRESS , OLD_INCIDENT_CITY , INCIDENT_CITY , OLD_INCIDENT_STATE , INCIDENT_STATE , OLD_INCIDENT_COUNTRY , INCIDENT_COUNTRY , OLD_INCIDENT_PROVINCE , INCIDENT_PROVINCE , OLD_INCIDENT_POSTAL_CODE , INCIDENT_POSTAL_CODE , OLD_INCIDENT_COUNTY , INCIDENT_COUNTY , OLD_SR_CREATION_CHANNEL , SR_CREATION_CHANNEL , OLD_DEF_DEFECT_ID , DEF_DEFECT_ID , OLD_DEF_DEFECT_ID2 , DEF_DEFECT_ID2 , OLD_EXTERNAL_ATTRIBUTE_1 , EXTERNAL_ATTRIBUTE_1 , OLD_EXTERNAL_ATTRIBUTE_2 , EXTERNAL_ATTRIBUTE_2 , OLD_EXTERNAL_ATTRIBUTE_3 , EXTERNAL_ATTRIBUTE_3 , OLD_EXTERNAL_ATTRIBUTE_4 , EXTERNAL_ATTRIBUTE_4 , OLD_EXTERNAL_ATTRIBUTE_5 , EXTERNAL_ATTRIBUTE_5 , OLD_EXTERNAL_ATTRIBUTE_6 , EXTERNAL_ATTRIBUTE_6 , OLD_EXTERNAL_ATTRIBUTE_7 , EXTERNAL_ATTRIBUTE_7 , OLD_EXTERNAL_ATTRIBUTE_8 , EXTERNAL_ATTRIBUTE_8 , OLD_EXTERNAL_ATTRIBUTE_9 , EXTERNAL_ATTRIBUTE_9 , OLD_EXTERNAL_ATTRIBUTE_10 , EXTERNAL_ATTRIBUTE_10 , OLD_EXTERNAL_ATTRIBUTE_11 , EXTERNAL_ATTRIBUTE_11 , OLD_EXTERNAL_ATTRIBUTE_12 , EXTERNAL_ATTRIBUTE_12 , OLD_EXTERNAL_ATTRIBUTE_13 , EXTERNAL_ATTRIBUTE_13 , OLD_EXTERNAL_ATTRIBUTE_14 , EXTERNAL_ATTRIBUTE_14 , OLD_EXTERNAL_ATTRIBUTE_15 , EXTERNAL_ATTRIBUTE_15 , OLD_EXTERNAL_CONTEXT , EXTERNAL_CONTEXT , OLD_LAST_UPDATE_PROGRAM_CODE , LAST_UPDATE_PROGRAM_CODE , OLD_CREATION_PROGRAM_CODE , CREATION_PROGRAM_CODE , OLD_COVERAGE_TYPE , COVERA GE_TYPE , OLD_BILL_TO_ACCOUNT_ID , BILL_TO_ACCOUNT_ID , OLD_SHIP_TO_ACCOUNT_ID , SHIP_TO_ACCOUNT_ID , OLD_CUSTOMER_EMAIL_ID , CUSTOMER_EMAIL_ID , OLD_CUSTOMER_PHONE_ID , CUSTOMER_PHONE_ID , OLD_BILL_TO_PARTY_ID , BILL_TO_PARTY_ID , OLD_SHIP_TO_PARTY_ID , SHIP_TO_PARTY_ID , OLD_BILL_TO_SITE_ID , BILL_TO_SITE_ID , OLD_SHIP_TO_SITE_ID , SHIP_TO_SITE_ID , OLD_PROGRAM_LOGIN_ID , PROGRAM_LOGIN_ID , OLD_INCIDENT_POINT_OF_INTEREST , INCIDENT_POINT_OF_INTEREST , OLD_INCIDENT_CROSS_STREET , INCIDENT_CROSS_STREET , OLD_INCIDENT_DIRECTION_QUALIF , INCIDENT_DIRECTION_QUALIF , OLD_INCIDENT_DISTANCE_QUALIF , INCIDENT_DISTANCE_QUALIF , OLD_INCIDENT_DISTANCE_QUAL_UOM , INCIDENT_DISTANCE_QUAL_UOM , OLD_INCIDENT_ADDRESS2 , INCIDENT_ADDRESS2 , OLD_INCIDENT_ADDRESS3 , INCIDENT_ADDRESS3 , OLD_INCIDENT_ADDRESS4 , INCIDENT_ADDRESS4 , OLD_INCIDENT_ADDRESS_STYLE , INCIDENT_ADDRESS_STYLE , OLD_INCIDENT_ADDR_LNS_PHONETIC , INCIDENT_ADDR_LNS_PHONETIC , OLD_INCIDENT_PO_BOX_NUMBER , INCIDENT_PO_BOX_NUMBER , OLD_INCIDENT_HOUSE_NUMBER , INCIDENT_HOUSE_NUMBER , OLD_INCIDENT_STREET_SUFFIX , INCIDENT_STREET_SUFFIX , OLD_INCIDENT_STREET , INCIDENT_STREET , OLD_INCIDENT_STREET_NUMBER , INCIDENT_STREET_NUMBER , OLD_INCIDENT_FLOOR , INCIDENT_FLOOR , OLD_INCIDENT_SUITE , INCIDENT_SUITE , OLD_INCIDENT_POSTAL_PLUS4_CODE , INCIDENT_POSTAL_PLUS4_CODE , OLD_INCIDENT_POSITION , INCIDENT_POSITION , OLD_INCIDENT_LOC_DIRECTIONS , INCIDENT_LOC_DIRECTIONS , OLD_INCIDEN T_LOC_DESCRIPTION , INCIDENT_LOC_DESCRIPTION , OLD_INSTALL_SITE_ID , INSTALL_SITE_ID , INCIDENT_LAST_MODIFIED_DATE , UPDATED_ENTITY_CODE , UPDATED_ENTITY_ID , ENTITY_ACTIVITY_CODE , OLD_TIER_VERSION , TIER_VERSION , OLD_INC_OBJECT_VERSION_NUMBER , INC_OBJECT_VERSION_NUMBER , OLD_INC_REQUEST_ID , INC_REQUEST_ID , OLD_INC_PROGRAM_APPLICATION_ID , INC_PROGRAM_APPLICATION_ID , OLD_INC_PROGRAM_ID , INC_PROGRAM_ID , OLD_INC_PROGRAM_UPDATE_DATE , INC_PROGRAM_UPDATE_DATE , OLD_OWNING_DEPARTMENT_ID , OWNING_DEPARTMENT_ID , OLD_ITEM_SERIAL_NUMBER , ITEM_SERIAL_NUMBER , OLD_INCIDENT_LOCATION_TYPE , INCIDENT_LOCATION_TYPE , OLD_UNASSIGNED_INDICATOR , UNASSIGNED_INDICATOR ) VALUES( :B403 , :B402 , :B401 , :B400 , :B401 , :B400 , :B399 , TO_CHAR(:B398 , 'HH24:MI:SS'), :B397 , :B396 , :B395 , :B394 , :B393 , :B392 , :B391 , :B390 , :B389 , :B388 , :B387 , :B386 , :B385 , :B384 , :B383 , :B382 , :B381 , :B380 , :B379 , :B378 , :B377 , :B376 , :B375 , :B374 , :B373 , :B372 , :B371 , :B370 , :B369 , :B368 , :B367 , :B366 , :B365 , :B364 , :B363 , :B362 , :B361 , :B360 , :B359 , :B358 , :B357 , :B356 , :B355 , :B354 , :B353 , :B352 , :B351 , :B350 , :B349 , :B348 , :B347 , :B346 , :B345 , :B344 , :B343 , :B342 , :B341 , :B340 , :B339 , :B338 , :B337 , :B336 , :B335 , :B334 , :B333 , :B332 , :B331 , :B330 , :B329 , :B328 , :B327 , :B326 , :B325 , :B324 , :B323 , :B322 , :B321 , :B320 , :B319 , :B318 , :B317 , :B316 , :B315 , :B314 , :B313 , :B312 , :B311 , :B310 , :B309 , :B308 , :B307 , :B306 , :B305 , :B304 , :B303 , :B302 , :B301 , :B300 , :B299 , :B298 , :B297 , 1, '', :B296 , :B295 , :B294 , :B293 , :B292 , :B291 , :B290 , :B289 , :B288 , :B287 , :B286 , :B285 , :B284 , :B283 , :B282 , :B281 , :B280 , :B279 , :B278 , :B277 , :B276 , :B275 , :B274 , :B273 , :B272 , :B271 , :B270 , :B269 , :B268 , :B267 , :B266 , :B265 , :B264 , :B263 , :B262 , :B261 , :B260 , :B259 , :B258 , :B257 , :B256 , :B255 , :B254 , :B253 , :B252 , :B251 , :B250 , :B249 , :B248 , :B247 , :B246 , :B245 , :B244 , :B243 , :B242 , :B241 , :B240 , :B239 , :B238 , :B237 , :B236 , :B235 , :B234 , :B233 , :B232 , :B231 , :B230 , :B229 , :B228 , :B227 , :B226 , :B225 , :B224 , :B223 , :B222 , :B221 , :B220 , :B219 , :B218 , :B217 , :B216 , :B215 , :B214 , :B213 , :B212 , :B211 , :B210 , :B209 , :B208 , :B207 , :B206 , :B205 , :B204 , :B203 , :B202 , :B201 , :B200 , :B199 , :B198 , :B197 , :B196 , :B195 , :B194 , :B193 , :B192 , :B191 , :B190 , :B189 , :B188 , :B187 , :B186 , :B185 , :B184 , :B183 , :B182 , :B181 , :B180 , :B179 , :B178 , :B177 , :B176 , :B175 , :B174 , :B173 , :B172 , :B171 , :B170 , :B169 , :B168 , :B167 , :B166 , :B165 , :B164 , :B163 , :B162 , :B161 , :B160 , :B159 , :B158 , :B157 , :B156 , :B155 , :B15 4 , :B153 , :B152 , :B151 , :B150 , :B149 , :B148 , :B147 , :B146 , :B145 , :B144 , :B143 , :B142 , :B141 , :B140 , :B139 , :B138 , :B137 , :B136 , :B135 , :B134 , :B133 , :B132 , :B131 , :B130 , :B129 , :B128 , :B127 , :B126 , :B125 , :B124 , :B123 , :B122 , :B121 , :B120 , :B119 , :B118 , :B117 , :B116 , :B115 , :B114 , :B113 , :B112 , :B111 , :B110 , :B109 , :B108 , :B107 , :B106 , :B105 , :B104 , :B103 , :B102 , :B101 , :B100 , :B99 , :B98 , :B97 , :B96 , :B95 , :B94 , :B93 , :B92 , :B91 , :B90 , :B89 , :B88 , :B87 , :B86 , :B85 , :B84 , :B83 , :B82 , :B81 , :B80 , :B79 , :B78 , :B77 , :B76 , :B75 , :B74 , :B73 , :B72 , :B71 , :B70 , :B69 , :B68 , :B67 , :B66 , :B65 , :B64 , :B63 , :B62 , :B61 , :B60 , :B59 , :B58 , :B57 , :B56 , :B55 , :B54 , :B53 , :B52 , :B51 , :B50 , :B49 , :B48 , :B47 , :B46 , :B45 , :B44 , :B43 , :B42 , :B41 , :B40 , :B39 , :B38 , :B37 , :B36 , :B35 , :B34 , :B33 , :B32 , :B31 , :B30 , :B29 , :B28 , :B27 , :B26 , :B25 , :B24 , :B23 , :B22 , :B21 , :B20 , :B19 , :B18 , :B17 , :B16 , :B15 , :B14 , :B13 , :B12 , :B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 ) RETURNING INCIDENT_AUDIT_ID INTO :O0
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

Back to Top

Instance Activity Stats

Statistic Total per Second per Trans
CPU used by this session 3,679,326 1,019.83 3.20
CPU used when call started 3,660,214 1,014.53 3.18
CR blocks created 15,937,697 4,417.60 13.85
Cached Commit SCN referenced 891,889 247.21 0.78
Commit SCN cached 465 0.13 0.00
DB time 7,994,338 2,215.86 6.95
DBWR checkpoint buffers written 3,555,652 985.55 3.09
DBWR checkpoints 34 0.01 0.00
DBWR object drop buffers written 57,489 15.93 0.05
DBWR revisited being-written buffer 85 0.02 0.00
DBWR thread checkpoint buffers written 517,326 143.39 0.45
DBWR transaction table writes 3,340 0.93 0.00
DBWR undo block writes 1,715,288 475.44 1.49
DFO trees parallelized 48 0.01 0.00
IMU CR rollbacks 27,503,521 7,623.40 23.90
IMU Flushes 328,222 90.98 0.29
IMU Redo allocation size 2,366,117,080 655,838.13 2,056.37
IMU commits 604,013 167.42 0.52
IMU contention 37,942 10.52 0.03
IMU ktichg flush 8,544 2.37 0.01
IMU pool not allocated 0 0.00 0.00
IMU recursive-transaction flush 1,668 0.46 0.00
IMU undo allocation size 5,342,639,592 1,480,867.88 4,643.25
IMU- failed to get a private strand 0 0.00 0.00
PX local messages recv'd 69,457 19.25 0.06
PX local messages sent 69,457 19.25 0.06
Parallel operations downgraded 25 to 50 pct 40 0.01 0.00
Parallel operations not downgraded 8 0.00 0.00
SQL*Net roundtrips to/from client 47,076,322 13,048.57 40.91
active txn count during cleanout 83,297,222 23,088.25 72.39
application wait time 51,193 14.19 0.04
background checkpoints completed 3 0.00 0.00
background checkpoints started 2 0.00 0.00
background timeouts 13,777 3.82 0.01
branch node splits 845 0.23 0.00
buffer is not pinned count 604,835,445 167,647.73 525.66
buffer is pinned count 1,104,162,503 306,050.74 959.62
bytes received via SQL*Net from client 8,827,271,773 2,446,734.99 7,671.71
bytes sent via SQL*Net to client 8,463,520,403 2,345,910.72 7,355.58
calls to get snapshot scn: kcmgss 124,783,175 34,587.28 108.45
calls to kcmgas 20,123,283 5,577.75 17.49
calls to kcmgcs 9,780,418 2,710.93 8.50
change write time 77,768 21.56 0.07
cleanout - number of ktugct calls 23,949,821 6,638.39 20.81
cleanouts and rollbacks - consistent read gets 13,773,837 3,817.82 11.97
cleanouts only - consistent read gets 166,659 46.19 0.14
cluster key scan block gets 1,465,256 406.14 1.27
cluster key scans 168,926 46.82 0.15
commit batch performed 0 0.00 0.00
commit batch requested 0 0.00 0.00
commit batch/immediate performed 5,569 1.54 0.00
commit batch/immediate requested 5,569 1.54 0.00
commit cleanout failures: block lost 278,448 77.18 0.24
commit cleanout failures: buffer being written 1,807 0.50 0.00
commit cleanout failures: callback failure 110,527 30.64 0.10
commit cleanout failures: cannot pin 36,406 10.09 0.03
commit cleanouts 9,578,732 2,655.02 8.32
commit cleanouts successfully completed 9,151,544 2,536.62 7.95
commit immediate performed 5,569 1.54 0.00
commit immediate requested 5,569 1.54 0.00
commit txn count during cleanout 1,417,782 392.98 1.23
concurrency wait time 48,282 13.38 0.04
consistent changes 663,234,818 183,834.81 576.41
consistent gets 1,726,547,427 478,562.81 1,500.53
consistent gets - examination 1,166,823,394 323,419.02 1,014.08
consistent gets from cache 1,726,547,383 478,562.80 1,500.53
cursor authentications 1,967 0.55 0.00
data blocks consistent reads - undo records applied 658,708,070 182,580.09 572.48
db block changes 199,021,431 55,164.58 172.97
db block gets 220,124,791 61,013.99 191.31
db block gets direct 4,285 1.19 0.00
db block gets from cache 220,120,506 61,012.80 191.30
deferred (CURRENT) block cleanout applications 1,525,545 422.85 1.33
dirty buffers inspected 10,997 3.05 0.01
enqueue conversions 10,406 2.88 0.01
enqueue releases 4,666,710 1,293.51 4.06
enqueue requests 4,677,012 1,296.37 4.06
enqueue timeouts 10,237 2.84 0.01
enqueue waits 58,115 16.11 0.05
exchange deadlocks 48,657 13.49 0.04
execute count 112,020,295 31,049.68 97.36
failed probes on index block reclamation 9,373 2.60 0.01
free buffer inspected 3,613,282 1,001.53 3.14
free buffer requested 20,696,993 5,736.77 17.99
heap block compress 26,612,790 7,376.51 23.13
hot buffers moved to head of LRU 1,597,393 442.76 1.39
immediate (CR) block cleanout applications 13,940,497 3,864.01 12.12
immediate (CURRENT) block cleanout applications 1,290,317 357.65 1.12
index crx upgrade (found) 61,817 17.13 0.05
index crx upgrade (positioned) 11,889,375 3,295.49 10.33
index fast full scans (rowid ranges) 1,648 0.46 0.00
index fetch by key 193,738,004 53,700.12 168.38
index scans kdiixs1 143,608,228 39,805.20 124.81
java call heap collected bytes 1,234,039,392 342,049.89 1,072.49
java call heap collected count 15,462,001 4,285.74 13.44
java call heap gc count 5,068 1.40 0.00
java call heap live object count 1,633,233 452.70 1.42
java call heap live object count max 1,630,520 451.95 1.42
java call heap live size 507,185,400 140,581.18 440.79
java call heap live size max 506,888,808 140,498.97 440.53
java call heap object count 3,562,582 987.47 3.10
java call heap object count max 3,565,783 988.36 3.10
java call heap total size 683,885,824 189,558.84 594.36
java call heap total size max 683,090,432 189,338.37 593.67
java call heap used size 634,020,224 175,737.14 551.02
java call heap used size max 634,341,984 175,826.32 551.30
leaf node 90-10 splits 20,614 5.71 0.02
leaf node splits 245,776 68.12 0.21
lob reads 21,557 5.98 0.02
lob writes 37,058 10.27 0.03
lob writes unaligned 37,058 10.27 0.03
logons cumulative 9,996 2.77 0.01
messages received 2,395,159 663.89 2.08
messages sent 2,395,159 663.89 2.08
no buffer to keep pinned count 16 0.00 0.00
no work - consistent read gets 507,287,515 140,609.48 440.88
opened cursors cumulative 12,412,865 3,440.59 10.79
parse count (failures) 3,243 0.90 0.00
parse count (hard) 8,471 2.35 0.01
parse count (total) 16,348,027 4,531.33 14.21
parse time cpu 100,332 27.81 0.09
parse time elapsed 113,939 31.58 0.10
physical read IO requests 392,576 108.81 0.34
physical read bytes 4,517,494,784 1,252,155.01 3,926.12
physical read total IO requests 394,263 109.28 0.34
physical read total bytes 4,544,225,280 1,259,564.14 3,949.35
physical read total multi block requests 26,421 7.32 0.02
physical reads 551,452 152.85 0.48
physical reads cache 550,658 152.63 0.48
physical reads cache prefetch 158,696 43.99 0.14
physical reads direct 794 0.22 0.00
physical reads direct temporary tablespace 186 0.05 0.00
physical reads prefetch warmup 113,841 31.55 0.10
physical write IO requests 1,383,080 383.36 1.20
physical write bytes 29,861,101,568 8,276,872.39 25,952.05
physical write total IO requests 2,719,927 753.91 2.36
physical write total bytes 65,746,881,536 18,223,659.54 57,140.10
physical write total multi block requests 1,663,123 460.98 1.45
physical writes 3,645,154 1,010.36 3.17
physical writes direct 4,804 1.33 0.00
physical writes direct (lob) 218 0.06 0.00
physical writes direct temporary tablespace 4,153 1.15 0.00
physical writes from cache 3,640,350 1,009.03 3.16
physical writes non checkpoint 2,471,743 685.12 2.15
pinned buffers inspected 4,492 1.25 0.00
prefetch warmup blocks aged out before use 306,342 84.91 0.27
prefetched blocks aged out before use 45 0.01 0.00
process last non-idle time 3,606 1.00 0.00
queries parallelized 48 0.01 0.00
recursive aborts on index block reclamation 2 0.00 0.00
recursive calls 201,297,374 55,795.42 174.95
recursive cpu usage 2,063,672 572.01 1.79
redo blocks written 34,961,177 9,690.51 30.38
redo buffer allocation retries 0 0.00 0.00
redo entries 102,140,485 28,311.20 88.77
redo log space requests 0 0.00 0.00
redo log space wait time 0 0.00 0.00
redo ordering marks 1,283,056 355.64 1.12
redo size 34,458,580,744 9,551,197.40 29,947.68
redo subscn max counts 2,556,167 708.52 2.22
redo synch time 55,233 15.31 0.05
redo synch writes 2,692,642 746.34 2.34
redo wastage 763,633,792 211,663.31 663.67
redo write time 53,634 14.87 0.05
redo writer latching time 90 0.02 0.00
redo writes 867,351 240.41 0.75
rollback changes - undo records applied 247,574 68.62 0.22
rollbacks only - consistent read gets 2,333,213 646.72 2.03
rows fetched via callback 100,093,891 27,743.93 86.99
session connect time 0 0.00 0.00
session cursor cache hits 7,109,044 1,970.48 6.18
session logical reads 1,946,676,812 539,578.07 1,691.84
session pga memory 6,392,002,664 1,771,729.36 5,555.24
session pga memory max 8,707,344,680 2,413,493.71 7,567.48
session uga memory ############### 71,486,193.66 224,144.23
session uga memory max 70,544,248,456 19,553,389.25 61,309.45
shared hash latch upgrades - no wait 34,116,163 9,456.29 29.65
shared hash latch upgrades - wait 86,109 23.87 0.07
sorts (memory) 12,203,293 3,382.50 10.61
sorts (rows) 145,144,897 40,231.13 126.14
sql area evicted 714 0.20 0.00
sql area purged 3,412 0.95 0.00
summed dirty queue length 285,199 79.05 0.25
switch current to new buffer 1,451,255 402.26 1.26
table fetch by rowid 698,310,882 193,557.16 606.90
table fetch continued row 32,774,346 9,084.36 28.48
table scan blocks gotten 95,551,842 26,484.97 83.04
table scan rows gotten 4,988,928,267 1,382,826.50 4,335.84
table scans (long tables) 4,642 1.29 0.00
table scans (rowid ranges) 4,640 1.29 0.00
table scans (short tables) 6,532,275 1,810.61 5.68
total number of times SMON posted 102,471 28.40 0.09
transaction rollbacks 5,569 1.54 0.00
transaction tables consistent read rollbacks 138 0.04 0.00
transaction tables consistent reads - undo records applied 6,301 1.75 0.01
undo change vector size 12,150,718,224 3,367,924.79 10,560.09
user I/O wait time 197,020 54.61 0.17
user calls 44,800,794 12,417.84 38.94
user commits 911,546 252.66 0.79
user rollbacks 239,080 66.27 0.21
workarea executions - onepass 2 0.00 0.00
workarea executions - optimal 7,464,516 2,069.01 6.49
write clones created in background 1,219 0.34 0.00
write clones created in foreground 17,959 4.98 0.02

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistic Begin Value End Value
session cursor cache count 426,435 1,195,346
opened cursors current 785,547 817,820
workarea memory allocated 4,977 1,141
logons current 4,740 4,706

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

Statistic Total per Hour
log switches (derived) 0 0.00

Back to Instance Activity Statistics
Back to Top

 

IO Stats

Back to Top

Tablespace IO Stats

Tablespace Reads Av Reads/s Av Rd(ms) Av Blks/Rd Writes Av Writes/s Buffer Waits Av Buf Wt(ms)
APPS_UNDOTS1 64 0 5.47 1.00 491,869 136 259,175 0.04
APPS_TS_TX_DATA 183,337 51 4.85 1.30 223,367 62 104,693 0.30
APPS_TS_TX_IDX 131,028 36 5.31 1.38 222,930 62 82,503 0.31
APPS_ASSM_DATA 22,257 6 3.25 2.95 212,119 59 53,967 0.04
APPS_ASSM_IDX 39,535 11 4.14 1.01 141,888 39 307,012 0.09
APPS_TS_TX_INTERFACE 723 0 6.80 2.75 35,967 10 2,953 0.06
APPS_TS_QUEUES 3,022 1 8.40 1.50 22,822 6 96 1.04
SYSTEM 8,126 2 5.28 1.44 5,526 2 8,418 0.73
TEMP 973 0 3.51 4.71 9,020 3 68 32.50
APPS_TS_SEED 2,615 1 7.73 1.52 4,359 1 1,396 2.15
APPS_TS_SUMMARY 56 0 5.89 1.00 5,802 2 2,237 0.04
CTXSYS 202 0 6.83 1.32 4,540 1 0 0.00
APPS_TS_ARCHIVE 64 0 7.50 1.50 2,132 1 120 5.08
SYSAUX 498 0 3.31 1.93 675 0 0 0.00
APPS_TS_NOLOGGING 34 0 3.53 1.35 68 0 39 7.44
APPS_TS_MEDIA 9 0 5.56 1.00 9 0 0 0.00
ODM 7 0 4.29 1.00 3 0 0 0.00
OLAP 7 0 4.29 1.00 3 0 0 0.00
OWAPUB 7 0 5.71 1.00 3 0 0 0.00
PORTAL 7 0 0.00 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

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 22,257 6 3.25 2.95 212,119 59 53,967 0.04
APPS_ASSM_IDX /oracle/visdata/apps_assm_idx.dbf 39,535 11 4.14 1.01 141,888 39 307,012 0.09
APPS_TS_ARCHIVE /oasb_data/archive1.dbf 17 0 7.06 1.53 1,025 0 59 5.76
APPS_TS_ARCHIVE /oasb_data/archive2.dbf 47 0 7.66 1.49 1,107 0 61 4.43
APPS_TS_MEDIA /oasb_data/media1.dbf 3 0 3.33 1.00 3 0 0 0.00
APPS_TS_MEDIA /oasb_data/media2.dbf 3 0 13.33 1.00 3 0 0 0.00
APPS_TS_MEDIA /oasb_data/media3.dbf 3 0 0.00 1.00 3 0 0 0.00
APPS_TS_NOLOGGING /oasb_data/nologging1.dbf 18 0 5.56 1.67 62 0 39 7.44
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 418 0 7.30 1.37 2,864 1 4 10.00
APPS_TS_QUEUES /oasb_data/queues2.dbf 477 0 9.35 1.59 3,764 1 15 0.00
APPS_TS_QUEUES /oasb_data/queues3.dbf 440 0 8.16 1.47 3,340 1 13 0.77
APPS_TS_QUEUES /oasb_data/queues4.dbf 418 0 7.32 1.47 3,362 1 57 0.53
APPS_TS_QUEUES /oasb_data/queues5.dbf 448 0 8.19 1.57 3,056 1 1 0.00
APPS_TS_QUEUES /oasb_data/queues6.dbf 402 0 7.99 1.54 3,224 1 5 0.00
APPS_TS_QUEUES /oasb_data/queues7.dbf 419 0 10.38 1.52 3,212 1 1 20.00
APPS_TS_SEED /oasb_data/reference1.dbf 217 0 9.17 1.69 355 0 460 1.41
APPS_TS_SEED /oasb_data/reference10.dbf 187 0 7.17 1.52 318 0 0 0.00
APPS_TS_SEED /oasb_data/reference2.dbf 304 0 6.15 1.54 328 0 852 2.70
APPS_TS_SEED /oasb_data/reference3.dbf 280 0 7.96 1.56 500 0 19 1.58
APPS_TS_SEED /oasb_data/reference4.dbf 259 0 8.38 1.54 422 0 65 0.31
APPS_TS_SEED /oasb_data/reference5.dbf 265 0 7.96 1.66 394 0 0 0.00
APPS_TS_SEED /oasb_data/reference6.dbf 292 0 7.95 1.52 590 0 0 0.00
APPS_TS_SEED /oasb_data/reference7.dbf 276 0 7.39 1.42 469 0 0 0.00
APPS_TS_SEED /oasb_data/reference8.dbf 273 0 8.06 1.35 465 0 0 0.00
APPS_TS_SEED /oasb_data/reference9.dbf 262 0 7.44 1.44 518 0 0 0.00
APPS_TS_SUMMARY /oasb_data/summary1.dbf 13 0 9.23 1.00 782 0 251 0.08
APPS_TS_SUMMARY /oasb_data/summary2.dbf 4 0 5.00 1.00 166 0 7 0.00
APPS_TS_SUMMARY /oasb_data/summary3.dbf 4 0 15.00 1.00 1,089 0 277 0.00
APPS_TS_SUMMARY /oasb_data/summary4.dbf 6 0 1.67 1.00 919 0 246 0.00
APPS_TS_SUMMARY /oasb_data/summary5.dbf 4 0 5.00 1.00 768 0 792 0.00
APPS_TS_SUMMARY /oasb_data/summary6.dbf 8 0 6.25 1.00 645 0 235 0.09
APPS_TS_SUMMARY /oasb_data/summary7.dbf 9 0 2.22 1.00 694 0 279 0.11
APPS_TS_SUMMARY /oasb_data/summary8.dbf 8 0 3.75 1.00 739 0 150 0.13
APPS_TS_TX_DATA /oasb_data/tx_data1.dbf 523 0 4.51 1.90 9,656 3 5,118 0.32
APPS_TS_TX_DATA /oasb_data/tx_data10.dbf 398 0 3.82 1.55 10,104 3 4,032 0.41
APPS_TS_TX_DATA /oasb_data/tx_data11.dbf 577 0 3.19 1.63 10,447 3 5,255 0.47
APPS_TS_TX_DATA /oasb_data/tx_data12.dbf 16,687 5 4.71 1.27 11,271 3 4,458 0.33
APPS_TS_TX_DATA /oasb_data/tx_data13.dbf 16,741 5 4.91 1.27 11,469 3 4,584 0.08
APPS_TS_TX_DATA /oasb_data/tx_data14.dbf 16,630 5 4.98 1.28 11,347 3 4,954 0.06
APPS_TS_TX_DATA /oasb_data/tx_data15.dbf 16,600 5 4.97 1.28 11,567 3 4,882 0.06
APPS_TS_TX_DATA /oasb_data/tx_data16.dbf 16,594 5 4.97 1.27 11,620 3 4,347 0.08
APPS_TS_TX_DATA /oasb_data/tx_data17.dbf 16,660 5 4.83 1.27 11,201 3 4,283 0.16
APPS_TS_TX_DATA /oasb_data/tx_data18.dbf 16,705 5 4.95 1.28 10,677 3 4,935 0.09
APPS_TS_TX_DATA /oasb_data/tx_data19.dbf 16,458 5 5.10 1.28 10,906 3 4,866 0.07
APPS_TS_TX_DATA /oasb_data/tx_data2.dbf 616 0 3.33 2.09 9,947 3 4,995 0.69
APPS_TS_TX_DATA /oasb_data/tx_data20.dbf 16,674 5 4.92 1.30 10,999 3 4,693 0.20
APPS_TS_TX_DATA /oasb_data/tx_data21.dbf 16,594 5 4.93 1.29 11,065 3 4,061 0.18
APPS_TS_TX_DATA /oasb_data/tx_data3.dbf 1,017 0 2.81 1.62 10,464 3 5,242 0.55
APPS_TS_TX_DATA /oasb_data/tx_data4.dbf 1,262 0 3.09 1.54 10,549 3 4,906 0.45
APPS_TS_TX_DATA /oasb_data/tx_data5.dbf 4,586 1 5.07 1.38 9,974 3 5,405 0.36
APPS_TS_TX_DATA /oasb_data/tx_data6.dbf 1,434 0 3.38 1.47 9,872 3 4,894 0.44
APPS_TS_TX_DATA /oasb_data/tx_data7.dbf 4,420 1 4.86 1.32 9,792 3 5,855 0.35
APPS_TS_TX_DATA /oasb_data/tx_data8.dbf 990 0 3.40 1.54 10,803 3 7,439 0.34
APPS_TS_TX_DATA /oasb_data/tx_data9.dbf 1,171 0 2.50 1.47 9,637 3 5,489 0.38
APPS_TS_TX_IDX /oasb_data/tx_idx1.dbf 552 0 4.55 1.22 5,517 2 2,086 0.40
APPS_TS_TX_IDX /oasb_data/tx_idx10.dbf 683 0 5.27 1.19 13,660 4 1,530 0.46
APPS_TS_TX_IDX /oasb_data/tx_idx11.dbf 1,085 0 4.83 1.12 11,188 3 3,365 1.11
APPS_TS_TX_IDX /oasb_data/tx_idx12.dbf 12,036 3 5.15 1.40 13,539 4 5,771 0.12
APPS_TS_TX_IDX /oasb_data/tx_idx13.dbf 12,038 3 5.14 1.38 12,611 3 5,212 0.16
APPS_TS_TX_IDX /oasb_data/tx_idx14.dbf 11,859 3 5.38 1.34 12,309 3 4,624 0.29
APPS_TS_TX_IDX /oasb_data/tx_idx15.dbf 11,940 3 5.35 1.32 12,521 3 4,743 0.11
APPS_TS_TX_IDX /oasb_data/tx_idx16.dbf 11,766 3 5.18 1.36 11,434 3 4,542 0.14
APPS_TS_TX_IDX /oasb_data/tx_idx17.dbf 11,822 3 5.21 1.33 11,693 3 4,250 0.18
APPS_TS_TX_IDX /oasb_data/tx_idx18.dbf 11,617 3 5.42 1.42 11,376 3 4,099 0.09
APPS_TS_TX_IDX /oasb_data/tx_idx19.dbf 11,802 3 5.48 1.45 11,904 3 5,231 0.10
APPS_TS_TX_IDX /oasb_data/tx_idx2.dbf 696 0 4.24 1.16 9,576 3 8,378 0.39
APPS_TS_TX_IDX /oasb_data/tx_idx20.dbf 11,570 3 5.30 1.44 11,296 3 4,940 0.23
APPS_TS_TX_IDX /oasb_data/tx_idx21.dbf 11,773 3 5.60 1.42 11,198 3 5,823 0.09
APPS_TS_TX_IDX /oasb_data/tx_idx3.dbf 1,137 0 5.05 1.27 10,888 3 1,922 1.10
APPS_TS_TX_IDX /oasb_data/tx_idx4.dbf 1,561 0 5.19 1.32 9,734 3 1,993 1.11
APPS_TS_TX_IDX /oasb_data/tx_idx5.dbf 1,542 0 5.76 1.27 8,701 2 1,917 0.71
APPS_TS_TX_IDX /oasb_data/tx_idx6.dbf 1,496 0 5.16 1.42 8,644 2 2,170 0.30
APPS_TS_TX_IDX /oasb_data/tx_idx7.dbf 1,435 0 5.46 1.29 8,160 2 3,199 0.45
APPS_TS_TX_IDX /oasb_data/tx_idx8.dbf 1,321 0 5.40 1.33 9,539 3 3,536 0.40
APPS_TS_TX_IDX /oasb_data/tx_idx9.dbf 1,297 0 5.57 1.42 7,442 2 3,172 0.22
APPS_TS_TX_INTERFACE /oasb_data/ts_tx_inte.dbf 312 0 6.70 3.83 7,819 2 836 0.10
APPS_TS_TX_INTERFACE /oasb_data/ts_tx_inte2.dbf 89 0 5.84 1.98 5,861 2 572 0.07
APPS_TS_TX_INTERFACE /oasb_data/ts_tx_inte3.dbf 76 0 7.63 1.97 5,701 2 420 0.00
APPS_TS_TX_INTERFACE /oasb_data/ts_tx_inte4.dbf 75 0 7.73 1.87 5,625 2 470 0.09
APPS_TS_TX_INTERFACE /oasb_data/ts_tx_inte5.dbf 70 0 6.57 2.19 5,474 2 238 0.00
APPS_TS_TX_INTERFACE /oasb_data/ts_tx_inte6.dbf 101 0 6.83 1.75 5,487 2 417 0.05
APPS_UNDOTS1 /oasb_data/undo01.dbf 4 0 15.00 1.00 47,116 13 25,443 0.08
APPS_UNDOTS1 /oasb_data/undo02.dbf 3 0 6.67 1.00 48,236 13 27,652 0.06
APPS_UNDOTS1 /oasb_data/undo03.dbf 3 0 6.67 1.00 47,628 13 29,515 0.03
APPS_UNDOTS1 /oasb_data/undo04.dbf 4 0 15.00 1.00 50,748 14 27,733 0.03
APPS_UNDOTS1 /oasb_data/undo05.dbf 8 0 5.00 1.00 52,002 14 22,567 0.03
APPS_UNDOTS1 /oasb_data/undo06.dbf 8 0 1.25 1.00 53,536 15 32,672 0.04
APPS_UNDOTS1 /oasb_data/undo07.dbf 9 0 3.33 1.00 50,981 14 25,606 0.04
APPS_UNDOTS1 /oasb_data/undo08.dbf 8 0 3.75 1.00 48,818 14 26,162 0.04
APPS_UNDOTS1 /oasb_data/undo09.dbf 9 0 6.67 1.00 47,583 13 22,770 0.04
APPS_UNDOTS1 /oracle/visdata/undo10.dbf 8 0 2.50 1.00 45,221 13 19,055 0.02
CTXSYS /oasb_data/ctx1.dbf 79 0 6.84 1.38 541 0 0 0.00
CTXSYS /oasb_data/ctx2.dbf 123 0 6.83 1.28 3,999 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 4.29 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 0.00 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 183 0 3.06 1.76 93 0 0 0.00
SYSAUX /oasb_data/sysaux02.dbf 315 0 3.46 2.03 582 0 0 0.00
SYSTEM /oasb_data/sys1.dbf 1,091 0 5.57 1.58 512 0 217 2.44
SYSTEM /oasb_data/sys2.dbf 1,230 0 5.15 1.43 633 0 278 3.63
SYSTEM /oasb_data/sys3.dbf 1,094 0 5.19 1.40 782 0 323 3.68
SYSTEM /oasb_data/sys4.dbf 1,246 0 5.61 1.37 917 0 297 2.66
SYSTEM /oasb_data/sys5.dbf 1,133 0 5.07 1.44 1,003 0 187 2.67
SYSTEM /oasb_data/sys6.dbf 1,137 0 4.98 1.46 830 0 223 3.63
SYSTEM /oasb_data/sys7.dbf 1,081 0 5.44 1.48 566 0 300 3.03
SYSTEM /oasb_data/sys8.dbf 62 0 4.52 1.00 77 0 4,894 0.06
SYSTEM /oasb_data/sys9.dbf 52 0 4.42 1.08 206 0 1,699 0.06
TEMP /oracle/visdata/temp1.dbf 174 0 3.33 3.51 2,428 1 4 0.00
TEMP /oracle/visdata/temp2.dbf 259 0 2.82 4.27 2,096 1 23 13.91
TEMP /oracle/visdata/temp3.dbf 168 0 4.76 4.61 1,824 1 12 56.67
TEMP /oracle/visdata/temp4.dbf 372 0 3.52 5.63 2,672 1 29 41.72

Back to IO Stats
Back to Top

 

Buffer Pool Statistics

P Number of Buffers Pool Hit% Buffer Gets Physical Reads Physical Writes Free Buff Wait Writ Comp Wait Buffer Busy Waits
D 2,012,643 100 1,944,829,389 550,809 3,640,248 0 0 822,340


Back to Top

 

Advisory Statistics

Back to Top

Instance Recovery Stats

  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 120 51139 606284 2295709 47178000 2295709  
E 180 139 69215 806741 5688423 47178000 5688423  

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 % W/A MB Processed Extra W/A MB Read/Written
100.00 581,082 5

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

  PGA Aggr Target(M) Auto PGA Target(M) PGA Mem Alloc(M) W/A PGA Used(M) %PGA W/A Mem %Auto W/A Mem %Man W/A Mem Global Mem Bound(K)
B 20,480 1,280 37,762.79 5.38 0.01 100.00 0.00 1,048,576
E 20,480 1,280 41,857.51 1.11 0.00 100.00 0.00 1,048,576

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High Optimal Total Execs Optimal Execs 1-Pass Execs M-Pass Execs
2K 4K 6,872,697 6,872,697 0 0
64K 128K 11,861 11,861 0 0
128K 256K 1,473 1,473 0 0
256K 512K 913 913 0 0
512K 1024K 229,985 229,985 0 0
1M 2M 348,553 348,553 0 0
2M 4M 62 60 2 0
4M 8M 20 20 0 0
8M 16M 2 2 0 0
32M 64M 8 8 0 0
64M 128M 6 6 0 0
128M 256M 2 2 0 0

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

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 819,133.94 9,345.29 99.00 1,214
5,120 0.25 819,133.94 9,240.08 99.00 1,170
10,240 0.50 819,133.94 9,122.01 99.00 1,117
15,360 0.75 819,133.94 9,011.11 99.00 1,070
20,480 1.00 819,133.94 2.73 100.00 1,013
24,576 1.20 819,133.94 2.73 100.00 961
28,672 1.40 819,133.94 2.73 100.00 384
32,768 1.60 819,133.94 0.00 100.00 0
36,864 1.80 819,133.94 0.00 100.00 0
40,960 2.00 819,133.94 0.00 100.00 0
61,440 3.00 819,133.94 0.00 100.00 0
81,920 4.00 819,133.94 0.00 100.00 0
122,880 6.00 819,133.94 0.00 100.00 0
163,840 8.00 819,133.94 0.00 100.00 0

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

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
1,504 0.50 366 15,256 5,937,807 1.00 3,852 1.81 206,350,749
1,808 0.60 619 18,727 5,939,525 1.00 2,134 1.00 206,414,010
2,112 0.70 921 21,502 5,939,531 1.00 2,128 1.00 206,414,706
2,416 0.80 1,188 27,045 5,939,533 1.00 2,126 1.00 206,415,028
2,720 0.90 1,260 32,750 5,939,533 1.00 2,126 1.00 206,415,029
3,024 1.00 1,260 32,750 5,939,533 1.00 2,126 1.00 206,415,029
3,328 1.10 1,260 32,750 5,939,533 1.00 2,126 1.00 206,415,029
3,632 1.20 1,260 32,750 5,939,533 1.00 2,126 1.00 206,415,029
3,936 1.30 1,260 32,750 5,939,533 1.00 2,126 1.00 206,415,029
4,240 1.40 1,260 32,750 5,939,533 1.00 2,126 1.00 206,415,029
4,544 1.50 1,260 32,750 5,939,533 1.00 2,126 1.00 206,415,029
4,848 1.60 1,260 32,750 5,939,533 1.00 2,126 1.00 206,415,029
5,152 1.70 1,260 32,750 5,939,533 1.00 2,126 1.00 206,415,029
5,456 1.80 1,260 32,750 5,939,533 1.00 2,126 1.00 206,415,029
5,760 1.90 1,260 32,750 5,939,533 1.00 2,126 1.00 206,415,029
6,064 2.01 1,260 32,750 5,939,533 1.00 2,126 1.00 206,415,029

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 49,197  
9,728 0.50 49,197  
14,592 0.75 49,197  
19,456 1.00 49,196  
24,320 1.25 49,207  
29,184 1.50 49,208  
34,048 1.75 49,214  
38,912 2.00 49,215  

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 15 212 559 1.00 2,127 1.00 13,823
48 0.50 16 216 559 1.00 2,127 1.00 13,823
64 0.67 16 216 559 1.00 2,127 1.00 13,823
80 0.83 16 216 559 1.00 2,127 1.00 13,823
96 1.00 16 216 559 1.00 2,127 1.00 13,823
112 1.17 16 216 559 1.00 2,127 1.00 13,823
128 1.33 16 216 559 1.00 2,127 1.00 13,823
144 1.50 16 216 559 1.00 2,127 1.00 13,823
160 1.67 16 216 559 1.00 2,127 1.00 13,823
176 1.83 16 216 559 1.00 2,127 1.00 13,823
192 2.00 16 216 559 1.00 2,127 1.00 13,823
208 2.17 16 216 559 1.00 2,127 1.00 13,823

Back to Advisory Statistics
Back to Top

 

Wait Statistics

Back to Top

Buffer Wait Statistics

Class Waits Total Wait Time (s) Avg Time (ms)
data block 554,942 96 0
undo block 212,759 6 0
undo header 46,378 4 0
file header block 68 2 33
1st level bmb 4,557 0 0
segment header 3,535 0 0
2nd level bmb 309 0 0
extent map 9 0 0

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason) Requests Succ Gets Failed Gets Waits Wt Time (s) Av Wt Time(ms)
TM-DML 2,002,450 2,002,433 1 24 334 13,899.75
TX-Transaction (index contention) 50,397 50,397 0 47,930 178 3.70
UL-User-defined 68,630 67,786 844 2,114 124 58.64
TX-Transaction (row lock contention) 9,175 428 8,747 391 46 118.33
RO-Multiple Object Reuse (fast object reuse) 288 288 0 32 12 376.69
TX-Transaction 1,307,537 1,307,544 0 2,273 2 0.78
DV-Diana Versioning 29,273 29,273 0 206 2 8.08
HW-Segment High Water Mark 287,048 287,043 5 2,002 1 0.53
SQ-Sequence Cache 42,056 42,056 0 2,375 1 0.34
TX-Transaction (allocate ITL entry) 296 296 0 211 1 2.64
FB-Format Block 32,881 32,881 0 519 0 0.42
CU-Cursor 8,241 8,241 0 3 0 10.00
PS-PX Process Reservation 3,728 3,088 640 37 0 0.22
US-Undo Segment 20,078 20,078 0 1 0 0.00

Back to Wait Statistics
Back to Top

 

Undo Statistics

Back to Top

Undo Segment Summary

Undo TS# Num Undo Blocks (K) Number of Transactions Max Qry Len (s) Max Tx Concurcy Min/Max TR (mins) STO/ OOS uS/uR/uU/ eS/eR/eU
1 1,722.31 1,298,315 2,671 358 173.05/333.2 0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

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
27-Dec 18:46 189,075 183,046 385 346 179 0/0 0/0/0/0/0/0
27-Dec 18:36 119,395 135,729 680 344 179 0/0 0/0/0/0/0/0
27-Dec 18:26 515,872 234,457 517 351 173 0/0 0/0/0/0/0/0
27-Dec 18:16 324,386 216,255 2,648 355 226 0/0 0/0/0/0/0/0
27-Dec 18:06 215,015 211,682 2,671 353 281 0/0 0/0/0/0/0/0
27-Dec 17:56 358,570 317,146 2,208 358 333 0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

 

Latch Statistics

Back to Top

Latch Activity

Latch Name Get Requests Pct Get Miss Avg Slps /Miss Wait Time (s) NoWait Requests Pct NoWait Miss
ASM db client latch 2,451 0.00   0 0  
AWR Alerted Metric Element list 300,653 0.00   0 0  
Consistent RBA 867,954 0.05 0.00 0 0  
FOB s.o list latch 63,114 0.01 0.00 0 0  
In memory undo latch 626,061,000 1.70 0.00 1 1,247,132 0.00
JOX SGA heap latch 1,938,150 0.00   0 0  
JS mem alloc latch 0     0 2 0.00
JS queue state obj latch 21,030 0.00   0 0  
JS slv state obj latch 176 0.00   0 0  
KMG MMAN ready and startup request latch 1,199 0.00   0 0  
KTF sga latch 12 0.00   0 1,215 0.00
KWQMN job cache list latch 13,504 0.05 0.86 0 0  
KWQP Prop Status 451 0.00   0 0  
MQL Tracking Latch 0     0 72 0.00
Memory Management Latch 0     0 1,199 0.00
Memory Queue 2 0.00   0 0  
OS process 15,111 0.00   0 0  
OS process allocation 11,252 0.01 0.00 0 0  
OS process: request allocation 9,745 0.01 0.00 0 0  
PL/SQL warning settings 5,057,957 0.00   0 0  
SGA IO buffer pool latch 99,065 0.01 0.00 0 125,896 0.28
SQL memory manager latch 1 0.00   0 1,192 0.00
SQL memory manager workarea list latch 6,594,917 0.01 0.00 0 0  
Shared B-Tree 2,347 0.00   0 0  
active checkpoint queue latch 1,530,933 3.18 0.00 0 0  
active service list 49,529 0.37 0.00 0 1,409 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  
bufq statistics 2 0.00   0 0  
cache buffer handles 23,071,698 2.28 0.00 0 0  
cache buffers chains 4,515,693,232 1.64 0.04 139 17,782,526 2.61
cache buffers lru chain 11,339,249 0.47 0.01 1 36,157,942 0.59
cache table scan latch 0     0 7,359 0.04
channel handle pool latch 402,110 0.06 0.02 0 0  
channel operations parent latch 1,595,423 0.88 0.00 0 0  
checkpoint queue latch 30,256,478 0.02 0.00 0 3,669,975 0.05
client/application info 2,548,977 0.00 0.00 0 0  
commit callback allocation 80,371 0.00   0 0  
compile environment latch 3,359,966 0.00   0 0  
dictionary lookup 78 0.00   0 0  
dml lock allocation 3,989,479 0.29 0.00 0 0  
dummy allocation 20,059 0.38 0.00 0 0  
enqueue hash chains 9,424,235 0.24 0.00 0 963 0.21
enqueue sob latch 2 0.00   0 0  
enqueues 5,995,588 0.27 0.00 0 0  
error message lists 1,584 1.70 0.00 0 0  
event group latch 4,862 0.00   0 0  
file cache latch 23,885 0.00   0 0  
global KZLD latch for mem in SGA 9,111 0.00   0 0  
global ctx hash table latch 22,096 0.00   0 0  
hash table column usage latch 1,621 0.00   0 14,462,930 0.00
hash table modification latch 152 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 17,108 0.00   0 0  
ksuosstats global area 243 0.00   0 0  
ktm global data 102,563 0.00   0 0  
kwqbsn:qsga 2,213 0.00   0 0  
lgwr LWN SCN 871,846 0.24 0.00 0 0  
library cache 411,584,836 0.84 0.00 3 12,302 2.13
library cache load lock 6,216 1.54 0.00 0 27 0.00
library cache lock 115,694,882 0.14 0.00 0 12 0.00
library cache lock allocation 5,198,705 0.02 0.00 0 0  
library cache pin 239,794,060 0.36 0.00 1 34 0.00
library cache pin allocation 3,236,541 0.01 0.00 0 0  
list of block allocation 475,482 0.02 0.00 0 0  
loader state object freelist 310,866 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 408,338 0.20 0.01 0 0  
messages 7,217,774 0.82 0.00 0 0  
mostly latch-free SCN 1,002,070 11.65 0.00 0 0  
multiblock read objects 69,943 0.01 0.00 0 2 0.00
ncodef allocation latch 327 0.00   0 0  
object queue header heap 6,508,395 0.02 0.05 0 389,471 0.06
object queue header operation 46,953,581 0.14 0.43 3 0  
object stats modification 398,512 0.06 0.00 0 4 0.00
parallel query alloc buffer 23,516 4.57 0.01 0 0  
parallel query stats 912 9.54 0.00 0 0  
parameter table allocation management 22,886 2.36 0.79 0 0  
post/wait queue 1,156,942 0.07 0.00 0 455,372 0.03
process allocation 9,793 0.27 0.96 0 4,860 0.04
process group creation 9,745 0.00   0 0  
process queue 15,146 1.79 0.00 0 0  
process queue reference 1,401,568 0.07 0.00 0 102,700 2.46
qmn state object latch 3 0.00   0 0  
qmn task queue latch 5,167 23.92 0.86 0 0  
query server freelists 13,488 25.14 0.00 0 0  
query server process 16 0.00   0 16 0.00
redo allocation 6,272,452 8.99 0.00 1 101,522,853 4.78
redo copy 0     0 102,149,913 0.05
redo writing 4,776,664 2.97 0.00 0 0  
resmgr group change latch 1,160,771 0.00   0 0  
resmgr:actses active list 29,070 0.67 0.98 0 0  
resmgr:actses change group 27,967 0.00   0 0  
resmgr:free threads list 20,055 0.54 0.04 0 0  
resmgr:schema config 1 0.00   0 0  
row cache objects 116,105,212 1.06 0.00 0 3,604 0.44
rules engine aggregate statistics 37,825 0.02 0.00 0 0  
rules engine evaluation context statistics 0     0 2 0.00
rules engine rule set statistics 122,092 0.01 0.00 0 0  
rules engine rule statistics 46,342 0.00   0 0  
sequence cache 16,439,700 1.04 0.00 0 0  
session allocation 20,680,834 0.80 0.01 0 0  
session idle bit 92,953,014 0.02 0.00 0 0  
session state list latch 56,161 0.20 0.10 0 0  
session switching 14,005 0.00   0 0  
session timer 1,409 0.00   0 0  
shared pool 7,205,111 0.23 0.02 0 0  
shared pool sim alloc 354 0.28 0.00 0 0  
shared pool simulator 1,839,806 0.01 0.02 0 0  
sim partition latch 1 0.00   0 23,129 0.17
slave class 2 0.00   0 0  
slave class create 9 0.00   0 0  
sort extent pool 1,329,057 0.16 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 467 0.00   0 0  
temporary table state object allocation 12,254 0.00   0 0  
threshold alerts latch 581 0.00   0 0  
trace latch 8 0.00   0 0  
transaction allocation 114,136 0.00   0 0  
transaction branch allocation 327 0.00   0 0  
undo global data 810,847,500 1.17 0.00 3 20,376 0.14
user lock 36,616 0.01 0.00 0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch Name Get Requests Misses Sleeps Spin Gets Sleep1 Sleep2 Sleep3
cache buffers chains 4,515,693,232 73,963,955 2,818,525 71,537,362 0 0 0
In memory undo latch 626,061,000 10,651,845 10,422 10,642,948 0 0 0
undo global data 810,847,500 9,519,636 3,322 9,516,577 0 0 0
library cache 411,584,836 3,466,146 6,127 3,460,413 0 0 0
row cache objects 116,105,212 1,227,741 579 1,227,174 0 0 0
library cache pin 239,794,060 858,618 1,561 857,124 0 0 0
redo allocation 6,272,452 564,168 1,654 562,605 0 0 0
cache buffer handles 23,071,698 527,100 216 526,895 0 0 0
sequence cache 16,439,700 171,641 57 171,586 0 0 0
session allocation 20,680,834 166,437 935 165,543 0 0 0
library cache lock 115,694,882 165,245 185 165,064 0 0 0
redo writing 4,776,664 141,843 85 141,758 0 0 0
mostly latch-free SCN 1,002,070 116,735 90 116,651 0 0 0
object queue header operation 46,953,581 64,275 27,509 37,869 0 0 0
messages 7,217,774 59,416 119 59,297 0 0 0
cache buffers lru chain 11,339,249 53,342 372 52,989 0 0 0
active checkpoint queue latch 1,530,933 48,647 28 48,619 0 0 0
enqueue hash chains 9,424,235 22,500 20 22,480 0 0 0
session idle bit 92,953,014 20,488 92 20,399 0 0 0
shared pool 7,205,111 16,748 349 16,420 0 0 0
enqueues 5,995,588 15,938 33 15,905 0 0 0
channel operations parent latch 1,595,423 13,993 59 13,937 0 0 0
dml lock allocation 3,989,479 11,438 44 11,394 0 0 0
checkpoint queue latch 30,256,478 6,571 10 6,561 0 0 0
query server freelists 13,488 3,391 3 3,388 0 0 0
sort extent pool 1,329,057 2,097 5 2,092 0 0 0
lgwr LWN SCN 871,846 2,064 4 2,060 0 0 0
object queue header heap 6,508,395 1,562 78 1,492 0 0 0
qmn task queue latch 5,167 1,236 1,059 183 0 0 0
library cache lock allocation 5,198,705 1,219 4 1,215 0 0 0
parallel query alloc buffer 23,516 1,075 6 1,069 0 0 0
message pool operations parent latch 408,338 831 5 827 0 0 0
post/wait queue 1,156,942 776 3 773 0 0 0
parameter table allocation management 22,886 539 427 206 0 0 0
Consistent RBA 867,954 417 1 416 0 0 0
channel handle pool latch 402,110 234 4 230 0 0 0
object stats modification 398,512 234 1 233 0 0 0
resmgr:actses active list 29,070 196 193 11 0 0 0
shared pool simulator 1,839,806 122 2 120 0 0 0
session state list latch 56,161 115 11 104 0 0 0
resmgr:free threads list 20,055 109 4 106 0 0 0
process allocation 9,793 26 25 2 0 0 0
KWQMN job cache list latch 13,504 7 6 1 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch Name Where NoWait Misses Sleeps Waiter Sleeps
In memory undo latch ktiFlush: child 0 5,969 1,557
In memory undo latch kturbk 0 3,483 4,863
In memory undo latch kticmt: child 0 518 296
In memory undo latch ktichg: child 0 390 3,538
In memory undo latch ktiTxnPoolFree 0 44 0
In memory undo latch ktbgfc 0 14 169
In memory undo latch ktiBRacquire 0 3 0
KWQMN job cache list latch kwqmnuji: update job item 0 7 6
active checkpoint queue latch kcbbacq: scan active checkpoints 0 28 28
active service list ksws_event: ksws event 0 2 4
active service list kswsgetso: get service object 0 2 0
cache buffer handles kcbzgs 0 122 135
cache buffer handles kcbzfs 0 94 81
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 2,374,720 2,965,804
cache buffers chains kcbchg: kslbegin: call CR func 0 1,404,773 2,041,397
cache buffers chains kcbgtcr: fast path 0 1,094,817 80,910
cache buffers chains kcbgtcr: kslbegin excl 0 715,879 467,260
cache buffers chains kcbrls: kslbegin 0 395,617 560,793
cache buffers chains kcbzgb: scan from tail. nowait 0 79,645 0
cache buffers chains kcbgcur: kslbegin 0 44,038 24,253
cache buffers chains kcbget: pin buffer 0 31,858 14,668
cache buffers chains kcbget: exchange rls 0 15,522 15,791
cache buffers chains kcbget: exchange 0 12,337 17,603
cache buffers chains kcbzwb 0 10,404 6,444
cache buffers chains kcbcge 0 6,609 14,905
cache buffers chains kcbnlc 0 2,504 2,483
cache buffers chains kcbso1: set no access 0 1,108 209
cache buffers chains kcb_is_private 0 650 4,225
cache buffers chains kcbesc: escalate 0 193 112
cache buffers chains kcbnew: new latch again 0 179 12
cache buffers chains kcbgkcbcr 0 164 848
cache buffers chains kcbgtcr: kslbegin shared 0 151 109
cache buffers chains kcb_pre_apply: kcbhq61 0 77 1,223
cache buffers chains kcbbxsv 0 66 30
cache buffers chains kcb_post_apply: kcbhq63 0 61 203
cache buffers chains kcbbic2 0 23 10
cache buffers chains kcbzib: exchange rls 0 19 25
cache buffers chains kcb_post_apply: kcbhq62 0 16 228
cache buffers chains kcbzib: multi-block read: nowait 0 6 0
cache buffers chains kcbzib: finish free bufs 0 4 2
cache buffers chains kcbo_ivd_process 0 2 89
cache buffers chains kcbnew_1 0 1 11
cache buffers chains kcbzhngcbk1: get hash chain latch no wait 0 1 0
cache buffers lru chain kcbzgws 0 217 0
cache buffers lru chain kcbgtcr:CR Scan:KCBRSKIP 0 39 0
cache buffers lru chain kcbbxsv: move to being written 0 37 93
cache buffers lru chain kcbo_link_q 0 32 6
cache buffers lru chain kcbzgb: posted for free bufs 0 23 105
cache buffers lru chain kcbo_ivd_proc 0 15 101
cache buffers lru chain kcbzswcu 0 4 24
cache buffers lru chain kcbbic2 0 3 50
cache buffers lru chain kcbzib 0 2 0
channel handle pool latch ksrchconnect() 0 17 10
channel handle pool latch ksrchdelete() 0 1 8
channel operations parent latch ksrchdelete() 0 118 32
channel operations parent latch ksrwait() 0 31 15
channel operations parent latch ksrsconsume() 0 27 14
channel operations parent latch ksrapublish() 0 23 26
channel operations parent latch ksrmfree() 0 10 81
channel operations parent latch ksrchconnect() 0 5 46
checkpoint queue latch kcbklbc: Link buffer into ckpt queue 0 4 0
checkpoint queue latch kcbkubc 0 3 1
checkpoint queue latch kcbbwthc: thread checkpoint buffers 0 2 5
checkpoint queue latch kcbswcu: Switch buffers 0 1 4
dml lock allocation ktaiam 0 26 13
dml lock allocation ktaidm 0 18 32
enqueue hash chains ksqgtl3 0 10 5
enqueue hash chains ksqrcl 0 8 16
enqueue hash chains ksqcmi: get hash chain latch after wait 0 2 5
enqueues ksqgel: create enqueue 0 12 6
enqueues ksqies 0 11 19
enqueues ksqdel 0 10 9
event range base latch No latch 0 1,059 1,059
lgwr LWN SCN kcs023 0 19 0
library cache kglpndl: child: after processing 0 2,195 135
library cache kglpnp: child 0 1,712 2,067
library cache kglobpn: child: 0 660 1,185
library cache kglScanDependency 0 360 0
library cache kglpin 0 343 134
library cache kglpndl: child: before processing 0 304 2,008
library cache kglLockCursor 0 260 353
library cache kglhdgn: child: 0 65 110
library cache kgldte: child 0 0 49 99
library cache kglic 0 20 0
library cache kgldti: 2child 0 9 2
library cache kglhdgc: child: 0 9 4
library cache kglivl: child 0 9 0
library cache kglhdiv: child 0 6 0
library cache kglobld 0 4 0
library cache kglukp: child 0 2 0
library cache kglupd: child 0 2 0
library cache kgldtld: 2child 0 1 0
library cache kglget: unpin heap 0 0 1 0
library cache lock kgllkdl: child: cleanup 0 104 109
library cache lock kgllkal: child: multiinstance 0 81 76
library cache lock kgllkdl: child: no lock handle 0 39 26
library cache lock allocation kgllkget 0 3 1
library cache lock allocation kgllkrel 0 1 3
library cache pin kglpnp: child 0 658 611
library cache pin kglpndl 0 654 647
library cache pin kglpnal: child: alloc space 0 249 303
message pool operations parent latch ksrmalloc() 0 7 8
message pool operations parent latch ksrmfree() 0 5 6
messages ksarcv: after wait 0 57 46
messages ksarcv 0 41 59
messages ksaamb: after wakeup 0 21 14
mostly latch-free SCN kcslcu3 0 71 94
mostly latch-free SCN kcs024 0 4 0
mostly latch-free SCN kcsnew_scn_rba 0 1 0
object queue header heap kcbo_link_q:reget 0 74 2
object queue header heap kcbw_link_q:alloc 0 4 81
object queue header operation kcbo_ivbo 0 28,886 7,115
object queue header operation kcbw_link_q 0 3,174 2,840
object queue header operation kcbw_unlink_q 0 1,029 4,341
object queue header operation kcbo_switch_q_bg 0 174 1,741
object queue header operation kcbo_switch_cq 0 145 2,969
object queue header operation kcbo_switch_mq_bg 0 102 2,164
object queue header operation kcbo_service_ockpt 0 33 0
object queue header operation kcbo_swap_buf_bg 0 30 12,495
object queue header operation kcbo_write_q 0 25 0
object queue header operation kcbo_link_q:reget 0 17 152
object queue header operation kcbo_swap_buf 0 4 468
object stats modification ksoslinelm 0 1 1
parallel query alloc buffer kxfpbfre 0 5 5
parallel query alloc buffer kxfpbalo 0 1 1
parameter table allocation management ksp_param_table_free 0 426 421
parameter table allocation management kspptval 0 1 6
post/wait queue ksliwat:add:nowait 0 3 0
process allocation ksucrp 0 24 0
process allocation ksuapc 0 1 22
query server freelists kxfpobrmf 0 3 3
redo allocation kcrfw_redo_gen: redo allocation 1 0 1,080 0
redo allocation kcrfw_redo_gen: redo allocation 3 0 435 1,173
redo allocation kcrfw_redo_gen: redo allocation 2 0 106 0
redo allocation kcrfw_redo_write: more space 0 18 286
redo allocation kcrfw_redo_write: before write 0 15 232
redo writing kcrfwcr 0 73 38
redo writing kcrfw_post: rba scn pair 0 12 0
resmgr:actses active list kgskchclass 0 192 82
resmgr:actses active list kgskactladd 0 1 88
resmgr:free threads list kgskthrcreate 0 2 1
resmgr:free threads list kgskthrsod 0 2 4
row cache objects kqreqd: reget 0 436 35
row cache objects kqrpre: find obj 0 86 470
row cache objects kqreqd 0 48 72
row cache objects kqrso 0 4 0
sequence cache kdnssd 0 46 3
sequence cache kdnnxt: cached seq 0 10 1
sequence cache kdnss 0 1 53
session allocation ksuxds: KSUSFCLC not set 0 471 33
session allocation ksucri 0 97 199
session allocation ksuprc 0 91 144
session allocation ksuxds: not user session 0 87 161
session allocation ksudlc 0 61 218
session allocation ksursi 0 47 99
session allocation kxfprdp 0 35 22
session allocation kxfpqidqr 0 31 52
session allocation ksudlp 0 10 3
session allocation ksucrp 0 3 0
session allocation ksusin 0 2 6
session idle bit ksupuc: set busy 0 124 49
session idle bit ksupuc: clear busy 0 66 137
session idle bit ksuxds 0 3 7
session state list latch kpseqd 0 11 0
shared pool kghalo 0 234 135
shared pool kghfrunp: clatch: nowait 0 72 0
shared pool kghupr1 0 70 160
shared pool kghfrunp: alloc: wait 0 17 2
shared pool kghfre 0 15 26
shared pool kghalp 0 12 23
shared pool kghfrunp: clatch: wait 0 10 3
shared pool kghasp 0 1 1
shared pool simulator kglsim_unpin_simhp 0 2 2
sort extent pool ktstdt: dealloc sort extent 0 2 0
sort extent pool ktstaddextent1 0 1 0
sort extent pool ktstallobj1 0 1 1
sort extent pool ktstcrtobj 0 1 0
undo global data kturimugur: child 0 2,821 2,146
undo global data ktudba: KSLBEGIN 0 398 1,155
undo global data ktucof: at start 0 63 0
undo global data ktusmasp: ktugd_tuux 0 25 2
undo global data ktudnx:child 0 6 14
undo global data ktubnd:child 0 5 1
undo global data ktufrbs: child 0 2 6
undo global data ktumof: KSLBEGIN 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

Back to Top

Segments by Logical Reads

Owner Tablespace Name Object Name Subobject Name Obj. Type Logical Reads %Total
AR APPS_TS_TX_INTERFACE RA_INTERFACE_LINES_ALL   TABLE 64,144,336 3.30
INV APPS_TS_TX_IDX MTL_ITEM_CATEGORIES_U1   INDEX 51,376,768 2.64
APPLSYS APPS_TS_TX_IDX FND_PROFILE_OPTION_VALUES_U1   INDEX 27,954,560 1.44
APPLSYS APPS_TS_SEED WF_ITEM_ATTRIBUTES   TABLE 22,400,560 1.15
ONT APPS_TS_TX_DATA OE_ORDER_LINES_ALL   TABLE 22,192,080 1.14

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Owner Tablespace Name Object Name Subobject Name Obj. Type Physical Reads %Total
GL APPS_ASSM_DATA GL_JE_LINES   TABLE 35,269 6.40
HR APPS_ASSM_IDX PAY_RUN_RESULT_VALUES_PK   INDEX 13,680 2.48
AR APPS_ASSM_DATA RA_CUSTOMER_TRX_LINES_ALL   TABLE 13,154 2.39
HR APPS_ASSM_IDX PAY_RUN_RESULT_VALUES_N50   INDEX 8,738 1.58
HR APPS_ASSM_DATA PAY_RUN_RESULTS   TABLE 7,061 1.28

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

Owner Tablespace Name Object Name Subobject Name Obj. Type Row Lock Waits % of Capture
WSH APPS_TS_TX_DATA WSH_TRIP_STOPS   TABLE 17,128 24.02
APPLSYS APPS_TS_TX_IDX WF_ITEM_ACTIVITY_STATUSES_N1   INDEX 10,670 14.96
HR APPS_ASSM_IDX PAY_RUN_RESULT_VALUES_N50   INDEX 9,323 13.07
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_U1   INDEX 9,267 13.00
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N6   INDEX 4,754 6.67

Back to Segment Statistics
Back to Top

Segments by ITL Waits

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 27 50.00
APPLSYS APPS_TS_TX_IDX WF_ITEM_ATTRIBUTE_VALUES_PK   INDEX 8 14.81
GL APPS_ASSM_IDX GL_INTERFACE_N2   INDEX 3 5.56
HR APPS_ASSM_IDX PAY_RUN_RESULT_VALUES_N50   INDEX 3 5.56
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N5   INDEX 3 5.56

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

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 204,717 41.32
APPLSYS APPS_TS_TX_DATA WF_ITEM_ATTRIBUTE_VALUES   TABLE 59,647 12.04
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N6   INDEX 40,108 8.10
GL APPS_ASSM_DATA GL_JE_LINES   TABLE 27,617 5.57
HR APPS_ASSM_IDX PAY_RUN_RESULT_VALUES_N50   INDEX 18,925 3.82

Back to Segment Statistics
Back to Top

 

Dictionary Cache Stats

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 35 37.14 8 0.00 12 9
dc_global_oids 6,831,966 0.00 0   0 78
dc_histogram_data 224,246 0.55 0   0 6,259
dc_histogram_defs 388,155 1.92 0   4,042 16,499
dc_object_grants 65,972 0.04 0   0 248
dc_object_ids 11,326,031 0.01 0   57 3,481
dc_objects 222,362 0.43 0   345 2,848
dc_profiles 9,170 0.00 0   0 1
dc_rollback_segments 53,527 0.00 0   26 838
dc_segments 344,754 0.22 0   17,663 5,139
dc_sequences 52,660 0.04 0   52,660 139
dc_table_scns 75,515 0.01 0   0 14
dc_tablespace_quotas 17,558 0.08 0   214 55
dc_tablespaces 5,562,087 0.00 0   0 22
dc_used_extents 4 100.00 0   4 4
dc_usernames 527,260 0.00 0   0 55
dc_users 13,671,726 0.00 0   0 91
kqlsubheap_object 6 33.33 0   0 2
outstanding_alerts 256 0.00 0   0 41


Back to Top

 

Library Cache Activity

Namespace Get Requests Pct Miss Pin Requests Pct Miss Reloads Invali- dations
BODY 1,669,348 0.01 43,731,959 -0.01 0 0
CLUSTER 56 0.00 154 0.00 0 0
INDEX 14,353 0.38 15,165 0.55 0 0
JAVA DATA 614 0.00 0   0 0
PIPE 46,356 2.59 67,864 1.76 0 0
SQL AREA 5,565 95.80 124,522,089 -0.02 3,245 312
TABLE/PROCEDURE 718,592 0.12 60,664,047 -0.02 93 0
TRIGGER 27,452 0.06 1,354,613 0.00 0 0


Back to Top

 

Memory Statistics

Back to Top

Process Memory Summary

  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 30,020.95   10.82 6.01 28 31 2,774 2,774
  Freeable 2,996.25 0.00 1.26 0.64 9   2,385 2,385
  SQL 2,400.68 1,195.65 0.87 0.53 5 22 2,766 2,763
  PL/SQL 2,107.50 162.74 0.76 0.95 3 3 2,774 2,774
  JAVA 267.16 265.90 2.47 0.46 5 8 108 108
E Other 33,478.32   12.17 6.59 57 57 2,751 2,751
  Freeable 3,215.56 0.00 1.33 0.73 9   2,418 2,418
  SQL 2,535.14 1,281.36 0.92 0.52 5 22 2,743 2,740
  PL/SQL 2,364.70 174.93 0.86 0.98 3 3 2,751 2,751
  JAVA 257.94 256.70 2.39 0.38 5 8 108 108

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  
Fixed Size 2,229,152  
Redo Buffers 17,039,360  
Variable Size 3,319,397,472  

Back to Memory Statistics
Back to Top

SGA breakdown difference

Pool Name Begin MB End MB % Diff
java free memory 80.97 80.97 0.00
java joxlod exec hp 14.40 14.40 0.00
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.03 57.70 37.27
shared KGLS heap 48.80   -100.00
shared KTI-UNDO 57.62 57.62 0.00
shared PCursor   33.41  
shared PL/SQL MPCODE 68.88 74.64 8.36
shared event statistics per sess 68.55 68.55 0.00
shared free memory 949.41 453.77 -52.20
shared library cache 646.21 710.87 10.01
shared parameter table block 52.07 51.76 -0.59
shared sql area 435.87 852.35 95.55
shared trace buffer 43.70 43.83 0.29
streams free memory 31.99 31.99 0.00
  buffer_cache 16,272.00 16,272.00 0.00
  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

Back to Top

Streams CPU/IO Usage

Session Type CPU Time User I/O Time Sys I/O Time
QMON Slaves 24,120,667 451,267 0
QMON Coordinator 1,438,383 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

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

Ruleset Name Evals Fast Evals SQL Execs CPU Time Elapsed Time
APPLSYS.WF_DEFERRED_R 27,872 0 0 212 207
APPLSYS.WF_DEFERRED_QUEUE_M_R 8,514 0 8,514 146 133
APPLSYS.WF_JAVA_DEFERRED_R 1,407 0 0 15 18
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