WORKLOAD REPOSITORY report for

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

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

 

Report Summary

Cache Sizes

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

Load Profile

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

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

Instance Efficiency Percentages (Target 100%)

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

Shared Pool Statistics

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

Top 5 Timed Events

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

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

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

Back to Wait Events Statistics
Back to Top

Wait Class

Wait Class Waits %Time -outs Total Wait Time (s) Avg wait (ms) Waits /txn
User I/O 432,387 0.00 2,004 5 0.35
System I/O 1,061,996 0.00 699 1 0.85
Commit 495,757 0.00 635 1 0.40
Network 55,857,000 0.00 627 0 44.96
Concurrency 3,255,575 0.16 584 0 2.62
Application 75,570 0.16 481 6 0.06
Other 172,798 28.20 97 1 0.14
Configuration 9,992 40.45 28 3 0.01

Back to Wait Events Statistics
Back to Top

Wait Events

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

Back to Wait Events Statistics
Back to Top

Background Wait Events

Event Waits %Time -outs Total Wait Time (s) Avg wait (ms) Waits /txn
log file parallel write 924,745 0.00 542 1 0.74
db file parallel write 133,975 0.00 147 1 0.11
events in waitclass Other 59,304 0.00 7 0 0.05
os thread startup 59 0.00 6 110 0.00
control file sequential read 815 0.00 5 7 0.00
db file scattered read 1,298 0.00 5 4 0.00
control file parallel write 1,723 0.00 4 2 0.00
db file sequential read 1,127 0.00 3 3 0.00
latch: redo writing 127 0.00 0 0 0.00
latch: cache buffers chains 36 0.00 0 0 0.00
direct path read 608 0.00 0 0 0.00
log file sync 3 0.00 0 2 0.00
direct path write 333 0.00 0 0 0.00
latch: library cache lock 3 0.00 0 0 0.00
buffer busy waits 41 0.00 0 0 0.00
latch: shared pool 1 0.00 0 0 0.00
latch: library cache 1 0.00 0 0 0.00
latch: In memory undo latch 1 0.00 0 0 0.00
rdbms ipc message 2,598,910 0.40 35,894 14 2.09
Streams AQ: qmn slave idle wait 1,608 0.00 8,550 5317 0.00
Streams AQ: qmn coordinator idle wait 1,645 31.31 3,518 2139 0.00
smon timer 129,530 0.00 3,466 27 0.10
pmon timer 1,365 86.74 3,436 2517 0.00
Streams AQ: waiting for time management or cleanup tasks 754 49.47 1,337 1773 0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

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

Back to Wait Events Statistics
Back to Top

Service Statistics

Service Name DB Time (s) DB CPU (s) Physical Reads Logical Reads
SYS$USERS 43,864.40 40,493.60 548,769 2,082,617,858
SYS$BACKGROUND 0.00 0.00 6,722 1,750,520
VIS 0.00 0.00 0 0

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

Service Name User I/O Total Wts User I/O Wt Time Concurcy Total Wts Concurcy Wt Time Admin Total Wts Admin Wt Time Network Total Wts Network Wt Time
SYS$USERS 428992 199575 3255421 57783 0 0 55841824 62679
SYS$BACKGROUND 3370 802 142 651 0 0 0 0

Back to Wait Events Statistics
Back to Top

 

SQL Statistics

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

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

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

Back to SQL Statistics
Back to Top

SQL ordered by Gets

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

Back to SQL Statistics
Back to Top

SQL ordered by Reads

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

Back to SQL Statistics
Back to Top

SQL ordered by Executions

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

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

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

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b) Executions % Total SQL Id SQL Module SQL Text
11,605,288 8 0.36 b3an778qn1q49 RAXMTR select /*+ parallel(t, 16) par...
9,221,664 8 0.29 610p9aymv2pcv RAXMTR select /*+ parallel(t, 16) par...
3,405,177 8 0.11 6djyj1t4djs12 RAXMTR select /*+ parallel(t, 16) par...
1,877,555 7,200 0.06 8ay7m8qubw98j POXBWVRP select * from PO_TAX_LINES_SUM...

Back to SQL Statistics
Back to Top

 

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

 

Complete List of SQL Text

SQL Id SQL Text
0qcpgw43yqj5r ( SELECT DISTINCT WDD.SOURCE_LINE_ID, WDD.SOURCE_HEADER_ID, WDD.ORGANIZATION_ID, WDD.INVENTORY_ITEM_ID, WDD.MOVE_ORDER_LINE_ID, WDD.DELIVERY_DETAIL_ID, WDD.SHIP_MODEL_COMPLETE_FLAG, WDD.TOP_MODEL_LINE_ID, WDD.SHIP_FROM_LOCATION_ID, NULL SHIP_METHOD_CODE, WDD.SHIPMENT_PRIORITY_CODE, WDD.DATE_SCHEDULED DATE_SCHEDULED, WDD.REQUESTED_QUANTITY, WDD.REQUESTED_QUANTITY_UOM, WDD.PREFERRED_GRADE, WDD.REQUESTED_QUANTITY2, WDD.REQUESTED_QUANTITY_UOM2, WDD.PROJECT_ID, WDD.TASK_ID, WDD.SUBINVENTORY FROM_SUBINVENTORY_CODE, WDD.SUBINVENTORY TO_SUBINVENTORY_CODE, WDD.RELEASED_STATUS RELEASED_STATUS, WDD.SHIP_SET_ID SHIP_SET_ID, WDD.SOURCE_CODE SOURCE_CODE, WDD.SOURCE_HEADER_NUMBER SOURCE_HEADER_NUMBER, NULL PLANNED_DEPARTURE_DATE, WDA.DELIVERY_ID, OL.END_ITEM_UNIT_NUMBER, OL.SOURCE_DOCUMENT_TYPE_ID, MSI.RESERVABLE_TYPE, WDD.LAST_UPDATE_DATE, -1 DEMAND_SOURCE_HEADER_ID, -1 OUTSTANDING_ORDER_VALUE FROM WSH_DELIVERY_DETAILS WDD, WSH_DELIVERY_ASSIGNMENTS WDA, OE_ORDER_LINES_ALL OL, MTL_SYSTEM_ITEMS MSI , MTL_CATEGORY_SETS MCS, MTL_ITEM_CATEGORIES MIC WHERE WDD.DATE_SCHEDULED IS NOT NULL AND WDA.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID AND NVL(WDD.REQUESTED_QUANTITY, 0) > 0 AND WDD.SOURCE_LINE_ID = OL.LINE_ID AND WDD.SOURCE_CODE = 'OE' AND WDD.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID AND WDD.ORGANIZATION_ID = MSI.ORGA NIZATION_ID AND WDD.RELEASED_STATUS IN ( 'R', 'X') AND WDD.SHIP_FROM_LOCATION_ID = :X_ship_from_loc_id AND WDD.ORGANIZATION_ID = :X_org_id AND (WDA.DELIVERY_ID IS NULL ) AND (NVL(WDD.DEP_PLAN_REQUIRED_FLAG, 'N') = 'N' OR (NVL(WDD.DEP_PLAN_REQUIRED_FLAG, 'N') = 'Y' AND EXISTS ( SELECT 1 FROM WSH_NEW_DELIVERIES WDE1 WHERE WDE1.DELIVERY_ID = WDA.DELIVERY_ID AND ( NVL(WDE1.PLANNED_FLAG, 'N') IN ('Y', 'F' ) )) )) AND MCS.category_set_id = MIC.category_set_id AND MCS.category_set_id = :x_CategorySetID AND MIC.category_id = :x_CategoryID AND MIC.organization_id = WDD.organization_id AND MIC.inventory_item_id = WDD.inventory_item_id ) ORDER BY WDD.INVENTORY_ITEM_ID, DATE_SCHEDULED ASC, SHIPMENT_PRIORITY_CODE ASC, to_number(SOURCE_HEADER_NUMBER) ASC, SHIP_FROM_LOCATION_ID
0w785m9gmw41a SELECT USERENV('SESSIONID') FROM SYS.DUAL
0wrz2kbatczjk SELECT EXECUTE_FLAG FROM JTF_USER_HOOKS WHERE PKG_NAME = :B4 AND API_NAME = :B3 AND PROCESSING_TYPE = :B2 AND USER_HOOK_TYPE = :B1
0z318y6g3uagc declare l_retstat varchar2 ( 3 ) ; l_msg_data varchar2 ( 244 ) ; l_msg_cnt number ; l_trx_cnt number ; BEGIN :retval := INV_TXN_MANAGER_PUB . process_Transactions ( p_api_version => 1.0 , p_commit => fnd_api . g_true , x_return_status => l_retstat , x_msg_count => l_msg_cnt , x_msg_data => l_msg_data , x_trans_count => l_trx_cnt , p_table => 1 , p_header_id => :header_id ) ; END ;
1du9v021t8m46 insert into gl_interface(created_by, date_created, status, actual_flag, group_id, set_of_books_id, user_je_source_name, user_je_category_name, accounting_date, subledger_doc_sequence_id, subledger_doc_sequence_value, ussgl_transaction_code, currency_code, code_combination_id, entered_dr, entered_cr, accounted_dr, accounted_cr, reference1, reference10, reference21, reference22, reference23, reference24, reference25, reference26, reference27, reference28, reference29, reference30, request_id)select /*+ ORDERED USE_NL (l ctlgd ct ctt cust) INDEX (ctlgd, RA_CUST_TRX_LINE_GL_DIST_N5) +*/ :b0 created_by , trunc(sysdate ) date_created , :b1 status , :b2 actual_flag , :b3 group_id , :b4 sob_id , :b5 source_name , decode(ctt.type, 'CM', :b6, 'DM', :b7, 'CB', :b8, :b9) category , ctlgd.gl_date gl_date , ct.doc_sequence_id doc_seqid , ct.doc_sequence_value doc_num , ctlgd.ussgl_transaction_code ussgl , ct.invoice_currency_code currency , ctlgd.code_combination_id ccid , decode(ctlgd.account_class, 'REC', decode(sign(nvl(ctlgd.amount, 0)), (-1), null , nvl(ctlgd.amount, 0)), 'ROUND', decode(sign(nvl(ctlgd.acctd_amount, 0)), (-1), (-nvl(ctlgd.amount, 0)), null ), decode(sign(nvl(ctlgd.amount, 0)), (-1), (-nvl(ctlgd.amount, 0)), null )) entered_dr , decode(ctlgd.account_class, 'REC', decode(sign(nvl(ctlgd.amount, 0)), (-1), (-nvl(ctlgd.amount, 0)), null ), 'ROUND', decode(sign(nvl(ctlgd.acctd_amount, 0)), (-1), null , nvl(ctlgd.amount, 0)), decode(sign(nvl(ctlgd.amount , 0)), (-1), null , nvl(ctlgd.amount, 0))) entered_cr , decode(ctlgd.account_class, 'REC', decode(sign(nvl(ctlgd.amount, 0)), (-1), null , nvl(ctlgd.acctd_amount, 0)), 'ROUND', decode(sign(nvl(ctlgd.acctd_amount, 0)), (-1), (-nvl(ctlgd.acctd_amount, 0)), null ), decode(sign(nvl(ctlgd.amount, 0)), (-1), (-nvl(ctlgd.acctd_amount, 0)), null )) acctd_dr , decode(ctlgd.account_class, 'REC', decode(sign(nvl(ctlgd.amount, 0)), (-1), (-nvl(ctlgd.acctd_amount, 0)), null ), 'ROUND', decode(sign(nvl(ctlgd.acctd_amount, 0)), (-1), null , nvl(ctlgd.acctd_amount, 0)), decode(sign(nvl(ctlgd.amount, 0)), (-1), null , nvl(ctlgd.acctd_amount, 0))) acctd_cr , (:b10||to_char(:b3)) ref1 , decode(:b12, 'Y', null , ((((((l.meaning||' ')||:b13)||decode(ctt.type, 'CB', :b14, 'CM', :b15, 'DEP', :b16, 'DM', :b17, 'GUAR', :b18, 'INV', :b19, null ))||' ')||ct.trx_number)||:b20)) ref10 , to_char(:b3) ref21 , to_char(ct.customer_trx_id) ref22 , to_char(ctlgd.cust_trx_line_gl_dist_id) ref23 , ct.trx_number ref24 , cust.account_number ref25 , 'CUSTOMER' ref26 , to_char(ct.bill_to_customer_id) ref27 , decode(ctt.type, 'CM', 'CM', 'DM', 'DM', 'CB', 'CB', 'INV') ref28 , (decode(ctt.type, 'CM', 'CM_', 'DM', 'DM_', 'CB', 'CB_', 'INV_')||ctlgd.account_class) ref29 , 'RA_CUST_TRX_LINE_GL_DIST' ref30 , :b22 from ra_cust_trx_line_gl_dist ctlgd , ra_cust_trx_line_gl_dist rec , ar_lookups l , ra_customer_trx ct , ra_cust_trx_types ctt , hz_cust_accounts cust where ((((((((((((((((ctlgd.cust_trx_line_gl_dist_id+0)<: b23 and ctlgd.gl_date between to_date((:b24||' 00:00:00'), 'DD-MON-RR HH24:MI:SS') and to_date((:b25||' 23:59:59'), 'DD-MON-RR HH24:MI:SS')) and ctlgd.posting_control_id=(-3)) and ctlgd.set_of_books_id=:b4) and ctlgd.account_set_flag='N') and ctlgd.customer_trx_id=ct.customer_trx_id) and l.lookup_type='AUTOGL_TYPE') and l.lookup_code=nvl(ctlgd.account_class, 'REV')) and ct.complete_flag='Y') and ct.bill_to_customer_id=cust.cust_account_id) and ct.cust_trx_type_id=ctt.cust_trx_type_id) and ctlgd.customer_trx_id=rec.customer_trx_id) and rec.account_class='REC') and rec.latest_rec_flag='Y') and rec.account_set_flag='N') and 'NOT_MFAR_TYPE'=AR_MFAR_PKG.ar_mfar_trx_post(ctlgd.customer_trx_id, :b0, :b1, :b2, :b3, :b4, :b5, :b6, :b7, :b8, :b9, :b10, :b12, :b13, :b20, :b14, :b15, :b17, :b16, :b18, :b19, :b24, :b25, :b23))
1g4jfpxpupdt6 BEGIN OE_BULK_ORDER_IMPORT_PVT.ORDER_IMPORT_CONC_PGM( :errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8, :A9, :A10, :A11, :A12); END;
1q78dwnrrkf6c BEGIN ASN_SALES_PVT.Lead_Process_After_Update( P_Api_Version_Number => 2.0, P_Init_Msg_List => FND_API.G_TRUE, p_Commit => FND_API.G_FALSE, p_Validation_Level => FND_API.G_VALID_LEVEL_NONE, P_Identity_Salesforce_Id => :1, P_Salesgroup_id => :2, P_Sales_Lead_Id => :3, X_Return_Status => :4, X_Msg_Count => :5, X_Msg_Data => :6); END;
25bkagv1j2xf7 INSERT INTO MTL_MATERIAL_TRANSACTIONS ( TRANSACTION_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID, INVENTORY_ITEM_ID, ORGANIZATION_ID, SUBINVENTORY_CODE, LOCATOR_ID, REVISION, TRANSACTION_TYPE_ID, TRANSACTION_ACTION_ID, TRANSACTION_SOURCE_TYPE_ID, TRANSACTION_SOURCE_ID, TRANSACTION_SOURCE_NAME, TRANSACTION_QUANTITY, TRANSACTION_UOM, PRIMARY_QUANTITY, TRANSACTION_DATE, TRANSACTION_COST, ACTUAL_COST, PRIOR_COST, NEW_COST, QUANTITY_ADJUSTED, VARIANCE_AMOUNT, TRANSFER_COST, TRANSPORTATION_COST, TRANSFER_TRANSACTION_ID, TRANSFER_ORGANIZATION_ID, TRANSFER_SUBINVENTORY, TRANSFER_LOCATOR_ID , ACCT_PERIOD_ID, TRANSACTION_REFERENCE, REASON_ID, REPETITIVE_LINE_ID, DEPARTMENT_ID, OPERATION_SEQ_NUM, SHIPMENT_NUMBER, FREIGHT_CODE, WAYBILL_AIRBILL, TRX_SOURCE_LINE_ID, MOVE_ORDER_LINE_ID , COSTED_FLAG , INVOICED_FLAG , DISTRIBUTION_ACCOUNT_ID , ENCUMBRANCE_ACCOUNT , ENCUMBRANCE_A MOUNT , COST_UPDATE_ID , PROJECT_ID , TASK_ID , TO_PROJECT_ID , TO_TASK_ID , LPN_ID , TRANSFER_LPN_ID, CONTENT_LPN_ID , PUT_AWAY_STRATEGY_ID , PUT_AWAY_RULE_ID , PICK_STRATEGY_ID , PICK_RULE_ID , CREATED_BY , COST_GROUP_ID , TRANSFER_COST_GROUP_ID , TRANSACTION_SET_ID , PM_COST_COLLECTED , COST_CATEGORY_ID , ORGANIZATION_TYPE , TRANSFER_ORGANIZATION_TYPE , OWNING_ORGANIZATION_ID , OWNING_TP_TYPE , PLANNING_ORGANIZATION_ID , PLANNING_TP_TYPE , XFR_OWNING_ORGANIZATION_ID , TRANSFER_OWNING_TP_TYPE , XFR_PLANNING_ORGANIZATION_ID , TRANSFER_PLANNING_TP_TYPE , SECONDARY_TRANSACTION_QUANTITY , SECONDARY_UOM_CODE, PICK_SLIP_NUMBER, PICKING_LINE_ID, VENDOR_LOT_NUMBER, SOURCE_CODE, SOURCE_LINE_ID, MOVE_TRANSACTION_ID, RCV_TRANSACTION_ID, COMPLETION_TRANSACTION_ID, CURRENCY_CODE, CURRENCY_CONVERSION_RATE, CURRENCY_CONVERSION_DATE, CURRENCY_CONVERSION_TYPE, MATERIAL_ACCOUNT, MATERIAL_OVERHEAD_ACCOUNT, RESOURCE_ACCOUNT, OUTSIDE_PROCESSING_ACCOUNT, OVERHEAD_ACCOUNT, MOV EMENT_ID, SOURCE_PROJECT_ID, SOURCE_TASK_ID, PA_EXPENDITURE_ORG_ID, EXPENDITURE_TYPE, TRANSFER_PERCENTAGE, ORG_COST_GROUP_ID, COST_TYPE_ID, VALUE_CHANGE, PERCENTAGE_CHANGE, EMPLOYEE_CODE, MASTER_SCHEDULE_UPDATE_CODE, TRX_SOURCE_DELIVERY_ID, RECEIVING_DOCUMENT, TRANSPORTATION_DIST_ACCOUNT, NUMBER_OF_CONTAINERS, RMA_LINE_ID, CYCLE_COUNT_ID, PHYSICAL_ADJUSTMENT_ID, FLOW_SCHEDULE, FINAL_COMPLETION_FLAG, QA_COLLECTION_ID, OVERCOMPLETION_TRANSACTION_QTY, OVERCOMPLETION_PRIMARY_QTY, OVERCOMPLETION_TRANSACTION_ID, COMMON_BOM_SEQ_ID, COMMON_ROUTING_SEQ_ID, MVT_STAT_STATUS, PICK_SLIP_DATE, ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, SHIP_TO_LOCATION_ID, TRANSACTION_MODE, TRANSACTION_BATCH_ID, TRANSACTION_BATCH_SEQ, FOB_POINT, INTRANSIT_ACCOUNT, TRX_FLOW_HEADER_ID, L OGICAL_TRX_TYPE_CODE, ORIGINAL_TRANSACTION_TEMP_ID, SHORTAGE_PROCESS_CODE) VALUES(:1, SYSDATE, :2, SYSDATE, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, ROUND(:17, 5), :18, ROUND(:19, 5), nvl(:20, sysdate), :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, :42, :43, 'N', 'N', :44, :45, :46, :47, :48, :49, :50, :51, :52, :53, :54, :55, :56, :57, :58, :59, :60, :61, :62, :63, :64, :65, :66, :67, :68, :69, :70, :71, :72, :73, :74, :75, :76, :77, :78, :79, :80, :81, :82, :83, :84, :85, :86, :87, :88, :89, :90, :91, :92, :93, :94, :95, :96, :97, :98, :99, :100, :101, :102, :103, :104, :105, :106, :107, :108, :109, :110, :111, :112, :113, :114, :115, :116, :117, :118, :119, :120, 'NEW', :121, :122, :123, :124, :125, :126, :127, :128, :129, :130, :131, :132, :133, :134, :135, :136, :137, :138, :139, :140, :141, :142, :143, :144, :145, :146, :147)
29x3dahwzdj8b SELECT U.USER_NAME, NVL(U.EMPLOYEE_ID, -1), NVL(U.CUSTOMER_ID, -1), NVL(U.SUPPLIER_ID, -1), NVL(U.PERSON_PARTY_ID, -1) FROM FND_USER U WHERE U.USER_ID = :B1
2fjd6cndjby9p INSERT INTO RA_CUST_TRX_LINE_GL_DIST ( CUSTOMER_TRX_LINE_ID, CUSTOMER_TRX_ID, CODE_COMBINATION_ID, SET_OF_BOOKS_ID, ACCOUNT_CLASS, ACCOUNT_SET_FLAG, PERCENT, AMOUNT, ACCTD_AMOUNT, GL_DATE, CUST_TRX_LINE_SALESREP_ID, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, POSTING_CONTROL_ID, ORIGINAL_GL_DATE, CUST_TRX_LINE_GL_DIST_ID ) SELECT /*+ ORDERED */ ASS.CUSTOMER_TRX_LINE_ID, LINES.CUSTOMER_TRX_ID, DIST.CODE_COMBINATION_ID, :B12 , ASS.ACCOUNT_CLASS, 'N', ROUND( (DECODE(FC.MINIMUM_ACCOUNTABLE_UNIT, NULL, ROUND( (DIST.PERCENT/100) * DECODE(ASS.AMOUNT, 0, DECODE(ASS.ACCOUNT_CLASS, 'REV', DECODE( LINES.PREVIOUS_CUSTOMER_TRX_ID, NULL, 1, -1 ), DECODE( LINES.PREVIOUS_CUSTOMER_TRX_ID, NULL, -1, 1 ) ), ASS.AMOUNT ), FC.PRECISION), ROUND( ((DIST.PERCENT/100) * DECODE(ASS.AMOUNT, 0, DECODE(ASS.ACCOUNT_CLASS, 'REV', DECODE( LINES.PREVIOUS_CUSTOMER_TRX_ID, NULL, 1, -1), DECODE( LINES.PREVIOUS_CUSTOMER_TRX_ID, NULL, -1, 1) ), ASS.AMOUNT) ) / FC.MINIMUM_ACCOUNTABLE_UNIT) * FC.MINIMUM_ACCOUNTABLE_UNIT) / DECODE(LINES.EXTENDED_AMOUNT, 0, 1, LINES.EXTENDED_AMOUNT)) * DECODE(ASS.AMOUNT, 0, 0, 100), 4), DECODE(FC.MINIMUM_ACCOUNTABLE_UNIT, NULL, ROUND( (DIST.PERCENT/100) * ASS.AMOUNT, FC.PRECISION), ROUND( ((DIST.PERCENT/100) * ASS.AMOUNT) / FC.MINIMUM_ACCOUNTABLE_UNIT) * FC.MINIMUM_ACCOUNTABLE_UNIT), DECODE(:B10 , NULL, ROUND( NVL(HEADER.EXCHANGE_ RATE, 1) * DECODE(FC.MINIMUM_ACCOUNTABLE_UNIT, NULL, ROUND( (DIST.PERCENT/100) * ASS.AMOUNT, FC.PRECISION), ROUND( ((DIST.PERCENT/100) * ASS.AMOUNT) / FC.MINIMUM_ACCOUNTABLE_UNIT) * FC.MINIMUM_ACCOUNTABLE_UNIT ), :B11 ), ROUND( ( NVL(HEADER.EXCHANGE_RATE, 1) * DECODE(FC.MINIMUM_ACCOUNTABLE_UNIT, NULL, ROUND( (DIST.PERCENT/100) * ASS.AMOUNT, FC.PRECISION), ROUND( ( (DIST.PERCENT/100) * ASS.AMOUNT) / FC.MINIMUM_ACCOUNTABLE_UNIT) * FC.MINIMUM_ACCOUNTABLE_UNIT ) ) / :B10 ) * :B10 ), DECODE(REC.GL_DATE, NULL, NULL, ARP_AUTO_RULE.ASSIGN_GL_DATE(ASS.GL_DATE) ), DECODE(DIST.CUSTOMER_TRX_ID, HEADER.CUSTOMER_TRX_ID, DIST.CUST_TRX_LINE_SALESREP_ID, CMSREP.CUST_TRX_LINE_SALESREP_ID), :B9 , :B8 , :B7 , SYSDATE, SYSDATE, :B6 , SYSDATE, :B6 , -3, ASS.GL_DATE, RA_CUST_TRX_LINE_GL_DIST_S.NEXTVAL FROM RA_CUSTOMER_TRX HEADER, FND_CURRENCIES FC, RA_CUSTOMER_TRX_LINES LINES, RA_RULES ACC_RULE, RA_CUST_TRX_LINE_GL_DIST REC, RA_CUST_TRX_LINE_GL_DIST DIST, RA_CUST_TRX_LINE_SALESREPS CMSREP, AR_REVENUE_ASSIGNMENTS ASS WHERE HEADER.CUSTOMER_TRX_ID = :B1 AND HEADER.COMPLETE_FLAG = 'Y' AND FC.CURRENCY_CODE = HEADER.INVOICE_CURRENCY_CODE AND LINES.CUSTOMER_TRX_ID = HEADER.CUSTOMER_TRX_ID AND LINES.AUTORULE_COMPLETE_FLAG||'' = 'N' AND ASS.CUSTOMER_TRX_LINE_ID = LINES.CUSTOMER_TRX_LINE_ID AND ASS.PERIOD_SET_NAME = :B5 AND ACC_RULE.RULE_ID = LINES.ACCOUNTING_RULE_ID AND DECODE(HEADER.INVOICING_RULE_ID, -3, :B3 , DECODE(NVL(ACC_RULE.DEFERRED_REVENUE_FLAG, 'N'), 'Y', :B2 , DECODE(:B4 , 'N', :B3 , DECODE(HEADER.PREVIOUS_CUSTOMER_TRX_ID, NULL, AR_REVENUE_MANAGEMENT_PVT.LINE_COLLECTIBILITY(:B1 , LINES.CUSTOMER_TRX_LINE_ID), AR_REVENUE_MANAGEMENT_PVT.CASH_BASED(HEADER.PREVIOUS_CUSTOMER_TRX_ID))))) <> :B2 AND REC.CUSTOMER_TRX_ID = HEADER.CUSTOMER_TRX_ID AND REC.ACCOUNT_CLASS = 'REC' AND REC.LATEST_REC_FLAG = 'Y' AND DIST.CUSTOMER_TRX_LINE_ID = (SELECT DECODE(COUNT(CUST_TRX_LINE_GL_DIST_ID), 0, NVL(LINES.PREVIOUS_CUSTOMER_TRX_LINE_ID, LINES.CUSTOMER_TRX_LINE_ID), LINES.CUSTOMER_TRX_LINE_ID) FROM RA_CUST_TRX_LINE_GL_DIST SUBDIST2 WHERE SUBDIST2.CUSTOMER_TRX_LINE_ID = LINES.CUSTOMER_TRX_LINE_ID AND SUBDIST2.ACCOUNT_SET_FLAG = 'Y' AND SUBDIST2.GL_DATE IS NULL AND ROWNUM < 2 ) AND DIST.ACCOUNT_CLASS = ASS.ACCOUNT_CLASS AND DIST.ACCOUNT_SET_FLAG = 'Y' AND DIST.CUST_TRX_LINE_SALESREP_ID = CMSREP.PREV_CUST_TRX_LINE_SALESREP_ID (+) AND :B1 = CMSREP.CUSTOMER_TRX_ID (+) AND NOT EXISTS ( SELECT 'distribution exists' FROM RA_CUST_TRX_LINE_GL_DIST SUBDIST WHERE SUBDIST.CUSTOMER_TRX_LINE_ID = ASS.CUSTOMER_TRX_LINE_ID AND SUBDIST.CUSTOMER_TRX_ID + 0 = LINES.CUSTOMER_TRX_ID AND SUBDIST.ACCOUNT_SET_FLAG = 'N' AND SUBDIST.ACCOUNT_CLASS = ASS.ACCOUNT_CLASS AND SUBDIST.ORIGINAL_GL_DATE = ASS.GL_DATE )
3b3psftuyks81 BEGIN INV_TXNSTUB_PUB.postTransaction(:1, :2, :3); END;
3prk3vg9u0abb BEGIN FND_GLOBAL.APPS_INITIALIZE( user_id=>:1 , resp_id=>:2 , resp_appl_id=>:3 , security_group_id=>:4 , server_id=>:5);END;
473dq7tb653mp declare p varchar2(32767); begin p := FND_GENERIC_POLICY.GET_PREDICATE(:sn, :on); :v1 := substr(p, 1, 4000); :v2 := substr(p, 4001, 4000); :v3 := substr(p, 8001, 4000); :v4 := substr(p, 12001, 4000); :v5 := substr(p, 16001, 4000); :v6 := substr(p, 20001, 4000); :v7 := substr(p, 24001, 4000); :v8 := substr(p, 28001, 4000); :v9 := substr(p, 32001, 767); :v10 := substr(p, 4001, 1); :v11 := substr(p, 8001, 1); :v12 := substr(p, 12001, 1); :v13 := substr(p, 16001, 1); :v14 := substr(p, 20001, 1); :v15 := substr(p, 24001, 1); :v16 := substr(p, 28001, 1); :v17 := substr(p, 32001, 1); end;
4dqasqjrvudqn begin dbms_session.reset_package; end;
4g5vzcyf68n9w SELECT PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES WHERE PROFILE_OPTION_ID = :B4 AND APPLICATION_ID = :B3 AND LEVEL_ID = 10003 AND LEVEL_VALUE = :B2 AND LEVEL_VALUE_APPLICATION_ID = :B1
4yak7x2zqz0dh BEGIN inv_transfer_order_pvt.finalize_pick_confirm(:1, :2, :3, :4, :5, :6, :7); END;
5as61q63aqmts SELECT A.APPLICATION_SHORT_NAME FROM FND_APPLICATION A WHERE A.APPLICATION_ID = :B1
610p9aymv2pcv select /*+ parallel(t, 16) parallel_index(t, 16) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*), count("COMMENTS"), count(distinct "COMMENTS"), sum(sys_op_opnsize("COMMENTS")), substrb(dump(min(substrb("COMMENTS", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("COMMENTS", 1, 32)), 16, 0, 32), 1, 120), count("INTERNAL_NOTES"), count(distinct "INTERNAL_NOTES"), sum(sys_op_opnsize("INTERNAL_NOTES")), substrb(dump(min(substrb("INTERNAL_NOTES", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("INTERNAL_NOTES", 1, 32)), 16, 0, 32), 1, 120), count("INITIAL_CUSTOMER_TRX_ID"), count(distinct "INITIAL_CUSTOMER_TRX_ID"), sum(sys_op_opnsize("INITIAL_CUSTOMER_TRX_ID")), substrb(dump(min("INITIAL_CUSTOMER_TRX_ID"), 16, 0, 32), 1, 120), substrb(dump(max("INITIAL_CUSTOMER_TRX_ID"), 16, 0, 32), 1, 120), count("USSGL_TRANSACTION_CODE_CONTEXT"), count(distinct "USSGL_TRANSACTION_CODE_CONTEXT"), sum(sys_op_opnsize("USSGL_TRANSACTION_CODE_CONTEXT")), substrb(dump(min("USSGL_TRANSACTION_CODE_CONTEXT"), 16, 0, 32), 1, 120), substrb(dump(max("USSGL_TRANSACTION_CODE_CONTEXT"), 16, 0, 32), 1, 120), count("USSGL_TRANSACTION_CODE"), count(distinct "USSGL_TRANSACTION_CODE"), sum(sys_op_opnsize("USSGL_TRANSACTION_CODE")), substrb(dump(min("USSGL_TRANSACTION_CODE"), 16, 0, 32), 1, 120), substrb(dump(max("USSGL_TRANSACTION_CODE"), 16, 0, 32), 1, 120), count("ACCTD_AMOUNT"), count(distinct "ACCTD_AMOUNT"), sum(sys_op_opnsize("ACCTD_AMOUNT")), su bstrb(dump(min("ACCTD_AMOUNT"), 16, 0, 32), 1, 120), substrb(dump(max("ACCTD_AMOUNT"), 16, 0, 32), 1, 120), count("CUSTOMER_BANK_ACCOUNT_ID"), count(distinct "CUSTOMER_BANK_ACCOUNT_ID"), sum(sys_op_opnsize("CUSTOMER_BANK_ACCOUNT_ID")), substrb(dump(min("CUSTOMER_BANK_ACCOUNT_ID"), 16, 0, 32), 1, 120), substrb(dump(max("CUSTOMER_BANK_ACCOUNT_ID"), 16, 0, 32), 1, 120), count("CUSTOMER_BANK_ACCOUNT_NAME"), count(distinct "CUSTOMER_BANK_ACCOUNT_NAME"), sum(sys_op_opnsize("CUSTOMER_BANK_ACCOUNT_NAME")), substrb(dump(min(substrb("CUSTOMER_BANK_ACCOUNT_NAME", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("CUSTOMER_BANK_ACCOUNT_NAME", 1, 32)), 16, 0, 32), 1, 120), count("UOM_CODE"), count(distinct "UOM_CODE"), sum(sys_op_opnsize("UOM_CODE")), substrb(dump(min("UOM_CODE"), 16, 0, 32), 1, 120), substrb(dump(max("UOM_CODE"), 16, 0, 32), 1, 120), count("UOM_NAME"), count(distinct "UOM_NAME"), sum(sys_op_opnsize("UOM_NAME")), substrb(dump(min("UOM_NAME"), 16, 0, 32), 1, 120), substrb(dump(max("UOM_NAME"), 16, 0, 32), 1, 120), count("DOCUMENT_NUMBER_SEQUENCE_ID"), count(distinct "DOCUMENT_NUMBER_SEQUENCE_ID"), sum(sys_op_opnsize("DOCUMENT_NUMBER_SEQUENCE_ID")), substrb(dump(min("DOCUMENT_NUMBER_SEQUENCE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("DOCUMENT_NUMBER_SEQUENCE_ID"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE10"), count(distinct "LINK_TO_LINE_ATTRIBUTE10"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE10")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE10"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE10"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE11"), count(distinct "LINK_TO_LINE_ATTRIBUTE11"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE11")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE11"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE11"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE12"), count(distinct "LINK_TO_LINE_ATTRIBUTE12"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE12")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE12"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE12"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE13"), count(distinct "LINK_TO_LINE_ATTRIBUTE13"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE13")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE13"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE13"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE14"), count(distinct "LINK_TO_LINE_ATTRIBUTE14"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE14")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE14"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE14"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE15"), count(distinct "LINK_TO_LINE_ATTRIBUTE15"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE15")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE15"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE15"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE8"), count(distinct "LINK_TO_LINE_ATTRIBUTE8"), sum(sys_op_opnsize("LINK_TO_LINE_ATT RIBUTE8")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE8"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE8"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE9"), count(distinct "LINK_TO_LINE_ATTRIBUTE9"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE9")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE9"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE9"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE10"), count(distinct "REFERENCE_LINE_ATTRIBUTE10"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE10")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE10"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE10"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE11"), count(distinct "REFERENCE_LINE_ATTRIBUTE11"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE11")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE11"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE11"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE12"), count(distinct "REFERENCE_LINE_ATTRIBUTE12"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE12")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE12"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE12"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE13"), count(distinct "REFERENCE_LINE_ATTRIBUTE13"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE13")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE13"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE13"), 16, 0, 32), 1, 120), count("REFE RENCE_LINE_ATTRIBUTE14"), count(distinct "REFERENCE_LINE_ATTRIBUTE14"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE14")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE14"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE14"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE15"), count(distinct "REFERENCE_LINE_ATTRIBUTE15"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE15")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE15"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE15"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE8"), count(distinct "REFERENCE_LINE_ATTRIBUTE8"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE8")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE8"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE8"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE9"), count(distinct "REFERENCE_LINE_ATTRIBUTE9"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE9")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE9"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE9"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE10"), count(distinct "INTERFACE_LINE_ATTRIBUTE10"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE10")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE10"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE10"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE11"), count(distinct "INTERFACE_LINE_ATTRIBUTE11"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE11")), substrb(dump(min("INTERFACE _LINE_ATTRIBUTE11"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE11"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE12"), count(distinct "INTERFACE_LINE_ATTRIBUTE12"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE12")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE12"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE12"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ID"), sum(sys_op_opnsize("INTERFACE_LINE_ID")), substrb(dump(min("INTERFACE_LINE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ID"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_CONTEXT"), count(distinct "INTERFACE_LINE_CONTEXT"), sum(sys_op_opnsize("INTERFACE_LINE_CONTEXT")), substrb(dump(min("INTERFACE_LINE_CONTEXT"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_CONTEXT"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE1"), count(distinct "INTERFACE_LINE_ATTRIBUTE1"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE1")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE1"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE1"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE2"), count(distinct "INTERFACE_LINE_ATTRIBUTE2"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE2")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE2"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE2"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE3"), count(distinct "INTERFACE_LINE_ATTRIBUTE3"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE3")), substrb(du mp(min("INTERFACE_LINE_ATTRIBUTE3"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE3"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE4"), count(distinct "INTERFACE_LINE_ATTRIBUTE4"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE4")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE4"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE4"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE5"), count(distinct "INTERFACE_LINE_ATTRIBUTE5"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE5")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE5"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE5"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE6"), count(distinct "INTERFACE_LINE_ATTRIBUTE6"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE6")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE6"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE6"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE7"), count(distinct "INTERFACE_LINE_ATTRIBUTE7"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE7")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE7"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE7"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE8"), count(distinct "INTERFACE_LINE_ATTRIBUTE8"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE8")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE8"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE8"), 16, 0, 32), 1, 120), count(distinct "BATCH_SOURCE_NAME"), su m(sys_op_opnsize("BATCH_SOURCE_NAME")), substrb(dump(min(substrb("BATCH_SOURCE_NAME", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("BATCH_SOURCE_NAME", 1, 32)), 16, 0, 32), 1, 120), count("SET_OF_BOOKS_ID"), count(distinct "SET_OF_BOOKS_ID"), sum(sys_op_opnsize("SET_OF_BOOKS_ID")), substrb(dump(min("SET_OF_BOOKS_ID"), 16, 0, 32), 1, 120), substrb(dump(max("SET_OF_BOOKS_ID"), 16, 0, 32), 1, 120), count(distinct "LINE_TYPE"), sum(sys_op_opnsize("LINE_TYPE")), substrb(dump(min("LINE_TYPE"), 16, 0, 32), 1, 120), substrb(dump(max("LINE_TYPE"), 16, 0, 32), 1, 120), count(distinct "DESCRIPTION"), sum(sys_op_opnsize("DESCRIPTION")), substrb(dump(min(substrb("DESCRIPTION", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("DESCRIPTION", 1, 32)), 16, 0, 32), 1, 120), count(distinct "CURRENCY_CODE"), sum(sys_op_opnsize("CURRENCY_CODE")), substrb(dump(min("CURRENCY_CODE"), 16, 0, 32), 1, 120), substrb(dump(max("CURRENCY_CODE"), 16, 0, 32), 1, 120), count("AMOUNT"), count(distinct "AMOUNT"), sum(sys_op_opnsize("AMOUNT")), substrb(dump(min("AMOUNT"), 16, 0, 32), 1, 120), substrb(dump(max("AMOUNT"), 16, 0, 32), 1, 120), count("CUST_TRX_TYPE_NAME"), count(distinct "CUST_TRX_TYPE_NAME"), sum(sys_op_opnsize("CUST_TRX_TYPE_NAME")), substrb(dump(min("CUST_TRX_TYPE_NAME"), 16, 0, 32), 1, 120), substrb(dump(max("CUST_TRX_TYPE_NAME"), 16, 0, 32), 1, 120), count("CUST_TRX_TYPE_ID"), count(distinct "CUST_TRX_TYPE_ID"), sum(sys_op_opnsize("CUST_TRX_TYPE_ID")), substrb(dump(min("CUST_TRX _TYPE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("CUST_TRX_TYPE_ID"), 16, 0, 32), 1, 120), count("TERM_NAME"), count(distinct "TERM_NAME"), sum(sys_op_opnsize("TERM_NAME")), substrb(dump(min("TERM_NAME"), 16, 0, 32), 1, 120), substrb(dump(max("TERM_NAME"), 16, 0, 32), 1, 120), count("TERM_ID"), count(distinct "TERM_ID"), sum(sys_op_opnsize("TERM_ID")), substrb(dump(min("TERM_ID"), 16, 0, 32), 1, 120), substrb(dump(max("TERM_ID"), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_BATCH_NAME"), count(distinct "ORIG_SYSTEM_BATCH_NAME"), sum(sys_op_opnsize("ORIG_SYSTEM_BATCH_NAME")), substrb(dump(min(substrb("ORIG_SYSTEM_BATCH_NAME", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ORIG_SYSTEM_BATCH_NAME", 1, 32)), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_BILL_CUSTOMER_REF"), count(distinct "ORIG_SYSTEM_BILL_CUSTOMER_REF"), sum(sys_op_opnsize("ORIG_SYSTEM_BILL_CUSTOMER_REF")), substrb(dump(min(substrb("ORIG_SYSTEM_BILL_CUSTOMER_REF", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ORIG_SYSTEM_BILL_CUSTOMER_REF", 1, 32)), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_BILL_CUSTOMER_ID"), count(distinct "ORIG_SYSTEM_BILL_CUSTOMER_ID"), sum(sys_op_opnsize("ORIG_SYSTEM_BILL_CUSTOMER_ID")), substrb(dump(min("ORIG_SYSTEM_BILL_CUSTOMER_ID"), 16, 0, 32), 1, 120), substrb(dump(max("ORIG_SYSTEM_BILL_CUSTOMER_ID"), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_BILL_ADDRESS_REF"), count(distinct "ORIG_SYSTEM_BILL_ADDRESS_REF"), sum(sys_op_opnsize("ORIG_SYSTEM_BILL_ADDRESS_REF")), substrb(dump(min(su bstrb("ORIG_SYSTEM_BILL_ADDRESS_REF", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ORIG_SYSTEM_BILL_ADDRESS_REF", 1, 32)), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_BILL_ADDRESS_ID"), count(distinct "ORIG_SYSTEM_BILL_ADDRESS_ID"), sum(sys_op_opnsize("ORIG_SYSTEM_BILL_ADDRESS_ID")), substrb(dump(min("ORIG_SYSTEM_BILL_ADDRESS_ID"), 16, 0, 32), 1, 120), substrb(dump(max("ORIG_SYSTEM_BILL_ADDRESS_ID"), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_BILL_CONTACT_REF"), count(distinct "ORIG_SYSTEM_BILL_CONTACT_REF"), sum(sys_op_opnsize("ORIG_SYSTEM_BILL_CONTACT_REF")), substrb(dump(min(substrb("ORIG_SYSTEM_BILL_CONTACT_REF", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ORIG_SYSTEM_BILL_CONTACT_REF", 1, 32)), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_BILL_CONTACT_ID"), count(distinct "ORIG_SYSTEM_BILL_CONTACT_ID"), sum(sys_op_opnsize("ORIG_SYSTEM_BILL_CONTACT_ID")), substrb(dump(min("ORIG_SYSTEM_BILL_CONTACT_ID"), 16, 0, 32), 1, 120), substrb(dump(max("ORIG_SYSTEM_BILL_CONTACT_ID"), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_SHIP_CUSTOMER_REF"), count(distinct "ORIG_SYSTEM_SHIP_CUSTOMER_REF"), sum(sys_op_opnsize("ORIG_SYSTEM_SHIP_CUSTOMER_REF")), substrb(dump(min(substrb("ORIG_SYSTEM_SHIP_CUSTOMER_REF", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ORIG_SYSTEM_SHIP_CUSTOMER_REF", 1, 32)), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_SHIP_CUSTOMER_ID"), count(distinct "ORIG_SYSTEM_SHIP_CUSTOMER_ID"), sum(sys_op_opnsize("ORIG_SYSTEM_SHIP_CUSTOMER_ID")), substrb(dump(min(" ORIG_SYSTEM_SHIP_CUSTOMER_ID"), 16, 0, 32), 1, 120), substrb(dump(max("ORIG_SYSTEM_SHIP_CUSTOMER_ID"), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_SHIP_ADDRESS_REF"), count(distinct "ORIG_SYSTEM_SHIP_ADDRESS_REF"), sum(sys_op_opnsize("ORIG_SYSTEM_SHIP_ADDRESS_REF")), substrb(dump(min(substrb("ORIG_SYSTEM_SHIP_ADDRESS_REF", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ORIG_SYSTEM_SHIP_ADDRESS_REF", 1, 32)), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_SHIP_ADDRESS_ID"), count(distinct "ORIG_SYSTEM_SHIP_ADDRESS_ID"), sum(sys_op_opnsize("ORIG_SYSTEM_SHIP_ADDRESS_ID")), substrb(dump(min("ORIG_SYSTEM_SHIP_ADDRESS_ID"), 16, 0, 32), 1, 120), substrb(dump(max("ORIG_SYSTEM_SHIP_ADDRESS_ID"), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_SHIP_CONTACT_REF"), count(distinct "ORIG_SYSTEM_SHIP_CONTACT_REF"), sum(sys_op_opnsize("ORIG_SYSTEM_SHIP_CONTACT_REF")), substrb(dump(min(substrb("ORIG_SYSTEM_SHIP_CONTACT_REF", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ORIG_SYSTEM_SHIP_CONTACT_REF", 1, 32)), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_SHIP_CONTACT_ID"), count(distinct "ORIG_SYSTEM_SHIP_CONTACT_ID"), sum(sys_op_opnsize("ORIG_SYSTEM_SHIP_CONTACT_ID")), substrb(dump(min("ORIG_SYSTEM_SHIP_CONTACT_ID"), 16, 0, 32), 1, 120), substrb(dump(max("ORIG_SYSTEM_SHIP_CONTACT_ID"), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_SOLD_CUSTOMER_REF"), count(distinct "ORIG_SYSTEM_SOLD_CUSTOMER_REF"), sum(sys_op_opnsize("ORIG_SYSTEM_SOLD_CUSTOMER_REF")), substrb(dump(min(substrb("ORIG_SYSTEM_SOLD_CUSTOMER _REF", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ORIG_SYSTEM_SOLD_CUSTOMER_REF", 1, 32)), 16, 0, 32), 1, 120), count("ORIG_SYSTEM_SOLD_CUSTOMER_ID"), count(distinct "ORIG_SYSTEM_SOLD_CUSTOMER_ID"), sum(sys_op_opnsize("ORIG_SYSTEM_SOLD_CUSTOMER_ID")), substrb(dump(min("ORIG_SYSTEM_SOLD_CUSTOMER_ID"), 16, 0, 32), 1, 120), substrb(dump(max("ORIG_SYSTEM_SOLD_CUSTOMER_ID"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ID"), count(distinct "LINK_TO_LINE_ID"), sum(sys_op_opnsize("LINK_TO_LINE_ID")), substrb(dump(min("LINK_TO_LINE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ID"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_CONTEXT"), count(distinct "LINK_TO_LINE_CONTEXT"), sum(sys_op_opnsize("LINK_TO_LINE_CONTEXT")), substrb(dump(min("LINK_TO_LINE_CONTEXT"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_CONTEXT"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE1"), count(distinct "LINK_TO_LINE_ATTRIBUTE1"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE1")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE1"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE1"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE2"), count(distinct "LINK_TO_LINE_ATTRIBUTE2"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE2")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE2"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE2"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE3"), count(distinct "LINK_TO_LINE_ATTRIBUTE3"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE3 ")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE3"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE3"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE4"), count(distinct "LINK_TO_LINE_ATTRIBUTE4"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE4")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE4"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE4"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE5"), count(distinct "LINK_TO_LINE_ATTRIBUTE5"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE5")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE5"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE5"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE6"), count(distinct "LINK_TO_LINE_ATTRIBUTE6"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE6")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE6"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE6"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE7"), count(distinct "LINK_TO_LINE_ATTRIBUTE7"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE7")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE7"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE7"), 16, 0, 32), 1, 120), count("RECEIPT_METHOD_NAME"), count(distinct "RECEIPT_METHOD_NAME"), sum(sys_op_opnsize("RECEIPT_METHOD_NAME")), substrb(dump(min("RECEIPT_METHOD_NAME"), 16, 0, 32), 1, 120), substrb(dump(max("RECEIPT_METHOD_NAME"), 16, 0, 32), 1, 120), count("RECEIPT_METHOD_ID"), count(distinct "RECEIPT_METHOD_ID"), sum(sys_op_opnsize("RECEIPT_METHO D_ID")), substrb(dump(min("RECEIPT_METHOD_ID"), 16, 0, 32), 1, 120), substrb(dump(max("RECEIPT_METHOD_ID"), 16, 0, 32), 1, 120), count(distinct "CONVERSION_TYPE"), sum(sys_op_opnsize("CONVERSION_TYPE")), substrb(dump(min("CONVERSION_TYPE"), 16, 0, 32), 1, 120), substrb(dump(max("CONVERSION_TYPE"), 16, 0, 32), 1, 120), count("CONVERSION_DATE"), count(distinct "CONVERSION_DATE"), substrb(dump(min("CONVERSION_DATE"), 16, 0, 32), 1, 120), substrb(dump(max("CONVERSION_DATE"), 16, 0, 32), 1, 120), count("CONVERSION_RATE"), count(distinct "CONVERSION_RATE"), sum(sys_op_opnsize("CONVERSION_RATE")), substrb(dump(min("CONVERSION_RATE"), 16, 0, 32), 1, 120), substrb(dump(max("CONVERSION_RATE"), 16, 0, 32), 1, 120), count("CUSTOMER_TRX_ID"), count(distinct "CUSTOMER_TRX_ID"), sum(sys_op_opnsize("CUSTOMER_TRX_ID")), substrb(dump(min("CUSTOMER_TRX_ID"), 16, 0, 32), 1, 120), substrb(dump(max("CUSTOMER_TRX_ID"), 16, 0, 32), 1, 120), count("TRX_DATE"), count(distinct "TRX_DATE"), substrb(dump(min("TRX_DATE"), 16, 0, 32), 1, 120), substrb(dump(max("TRX_DATE"), 16, 0, 32), 1, 120), count("GL_DATE"), count(distinct "GL_DATE"), substrb(dump(min("GL_DATE"), 16, 0, 32), 1, 120), substrb(dump(max("GL_DATE"), 16, 0, 32), 1, 120), count("DOCUMENT_NUMBER"), count(distinct "DOCUMENT_NUMBER"), sum(sys_op_opnsize("DOCUMENT_NUMBER")), substrb(dump(min("DOCUMENT_NUMBER"), 16, 0, 32), 1, 120), substrb(dump(max("DOCUMENT_NUMBER"), 16, 0, 32), 1, 120), count("TRX_NUMBER"), count(distinct "TRX_NUMBER"), sum(sys _op_opnsize("TRX_NUMBER")), substrb(dump(min("TRX_NUMBER"), 16, 0, 32), 1, 120), substrb(dump(max("TRX_NUMBER"), 16, 0, 32), 1, 120), count("LINE_NUMBER"), count(distinct "LINE_NUMBER"), sum(sys_op_opnsize("LINE_NUMBER")), substrb(dump(min("LINE_NUMBER"), 16, 0, 32), 1, 120), substrb(dump(max("LINE_NUMBER"), 16, 0, 32), 1, 120), count("QUANTITY"), count(distinct "QUANTITY"), sum(sys_op_opnsize("QUANTITY")), substrb(dump(min("QUANTITY"), 16, 0, 32), 1, 120), substrb(dump(max("QUANTITY"), 16, 0, 32), 1, 120), count("QUANTITY_ORDERED"), count(distinct "QUANTITY_ORDERED"), sum(sys_op_opnsize("QUANTITY_ORDERED")), substrb(dump(min("QUANTITY_ORDERED"), 16, 0, 32), 1, 120), substrb(dump(max("QUANTITY_ORDERED"), 16, 0, 32), 1, 120), count("UNIT_SELLING_PRICE"), count(distinct "UNIT_SELLING_PRICE"), sum(sys_op_opnsize("UNIT_SELLING_PRICE")), substrb(dump(min("UNIT_SELLING_PRICE"), 16, 0, 32), 1, 120), substrb(dump(max("UNIT_SELLING_PRICE"), 16, 0, 32), 1, 120), count("UNIT_STANDARD_PRICE"), count(distinct "UNIT_STANDARD_PRICE"), sum(sys_op_opnsize("UNIT_STANDARD_PRICE")), substrb(dump(min("UNIT_STANDARD_PRICE"), 16, 0, 32), 1, 120), substrb(dump(max("UNIT_STANDARD_PRICE"), 16, 0, 32), 1, 120), count("PRINTING_OPTION"), count(distinct "PRINTING_OPTION"), sum(sys_op_opnsize("PRINTING_OPTION")), substrb(dump(min("PRINTING_OPTION"), 16, 0, 32), 1, 120), substrb(dump(max("PRINTING_OPTION"), 16, 0, 32), 1, 120), count("INTERFACE_STATUS"), count(distinct "INTERFACE_STATUS"), sum(sys_op_opnsi ze("INTERFACE_STATUS")), substrb(dump(min("INTERFACE_STATUS"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_STATUS"), 16, 0, 32), 1, 120), count("REQUEST_ID"), count(distinct "REQUEST_ID"), sum(sys_op_opnsize("REQUEST_ID")), substrb(dump(min("REQUEST_ID"), 16, 0, 32), 1, 120), substrb(dump(max("REQUEST_ID"), 16, 0, 32), 1, 120), count("RELATED_BATCH_SOURCE_NAME"), count(distinct "RELATED_BATCH_SOURCE_NAME"), sum(sys_op_opnsize("RELATED_BATCH_SOURCE_NAME")), substrb(dump(min(substrb("RELATED_BATCH_SOURCE_NAME", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("RELATED_BATCH_SOURCE_NAME", 1, 32)), 16, 0, 32), 1, 120), count("RELATED_TRX_NUMBER"), count(distinct "RELATED_TRX_NUMBER"), sum(sys_op_opnsize("RELATED_TRX_NUMBER")), substrb(dump(min("RELATED_TRX_NUMBER"), 16, 0, 32), 1, 120), substrb(dump(max("RELATED_TRX_NUMBER"), 16, 0, 32), 1, 120), count("RELATED_CUSTOMER_TRX_ID"), count(distinct "RELATED_CUSTOMER_TRX_ID"), sum(sys_op_opnsize("RELATED_CUSTOMER_TRX_ID")), substrb(dump(min("RELATED_CUSTOMER_TRX_ID"), 16, 0, 32), 1, 120), substrb(dump(max("RELATED_CUSTOMER_TRX_ID"), 16, 0, 32), 1, 120), count("PREVIOUS_CUSTOMER_TRX_ID"), count(distinct "PREVIOUS_CUSTOMER_TRX_ID"), sum(sys_op_opnsize("PREVIOUS_CUSTOMER_TRX_ID")), substrb(dump(min("PREVIOUS_CUSTOMER_TRX_ID"), 16, 0, 32), 1, 120), substrb(dump(max("PREVIOUS_CUSTOMER_TRX_ID"), 16, 0, 32), 1, 120), count("CREDIT_METHOD_FOR_ACCT_RULE"), count(distinct "CREDIT_METHOD_FOR_ACCT_RULE"), sum(sys_op_opnsize("CREDIT_MET HOD_FOR_ACCT_RULE")), substrb(dump(min("CREDIT_METHOD_FOR_ACCT_RULE"), 16, 0, 32), 1, 120), substrb(dump(max("CREDIT_METHOD_FOR_ACCT_RULE"), 16, 0, 32), 1, 120), count("CREDIT_METHOD_FOR_INSTALLMENTS"), count(distinct "CREDIT_METHOD_FOR_INSTALLMENTS"), sum(sys_op_opnsize("CREDIT_METHOD_FOR_INSTALLMENTS")), substrb(dump(min("CREDIT_METHOD_FOR_INSTALLMENTS"), 16, 0, 32), 1, 120), substrb(dump(max("CREDIT_METHOD_FOR_INSTALLMENTS"), 16, 0, 32), 1, 120), count("REASON_CODE"), count(distinct "REASON_CODE"), sum(sys_op_opnsize("REASON_CODE")), substrb(dump(min("REASON_CODE"), 16, 0, 32), 1, 120), substrb(dump(max("REASON_CODE"), 16, 0, 32), 1, 120), count("TAX_RATE"), count(distinct "TAX_RATE"), sum(sys_op_opnsize("TAX_RATE")), substrb(dump(min("TAX_RATE"), 16, 0, 32), 1, 120), substrb(dump(max("TAX_RATE"), 16, 0, 32), 1, 120), count("TAX_CODE"), count(distinct "TAX_CODE"), sum(sys_op_opnsize("TAX_CODE")), substrb(dump(min(substrb("TAX_CODE", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("TAX_CODE", 1, 32)), 16, 0, 32), 1, 120), count("TAX_PRECEDENCE"), count(distinct "TAX_PRECEDENCE"), sum(sys_op_opnsize("TAX_PRECEDENCE")), substrb(dump(min("TAX_PRECEDENCE"), 16, 0, 32), 1, 120), substrb(dump(max("TAX_PRECEDENCE"), 16, 0, 32), 1, 120), count("EXCEPTION_ID"), count(distinct "EXCEPTION_ID"), sum(sys_op_opnsize("EXCEPTION_ID")), substrb(dump(min("EXCEPTION_ID"), 16, 0, 32), 1, 120), substrb(dump(max("EXCEPTION_ID"), 16, 0, 32), 1, 120), count("EXEMPTION_ID"), count(distinct " EXEMPTION_ID"), sum(sys_op_opnsize("EXEMPTION_ID")), substrb(dump(min("EXEMPTION_ID"), 16, 0, 32), 1, 120), substrb(dump(max("EXEMPTION_ID"), 16, 0, 32), 1, 120), count("SHIP_DATE_ACTUAL"), count(distinct "SHIP_DATE_ACTUAL"), substrb(dump(min("SHIP_DATE_ACTUAL"), 16, 0, 32), 1, 120), substrb(dump(max("SHIP_DATE_ACTUAL"), 16, 0, 32), 1, 120), count("FOB_POINT"), count(distinct "FOB_POINT"), sum(sys_op_opnsize("FOB_POINT")), substrb(dump(min("FOB_POINT"), 16, 0, 32), 1, 120), substrb(dump(max("FOB_POINT"), 16, 0, 32), 1, 120), count("SHIP_VIA"), count(distinct "SHIP_VIA"), sum(sys_op_opnsize("SHIP_VIA")), substrb(dump(min("SHIP_VIA"), 16, 0, 32), 1, 120), substrb(dump(max("SHIP_VIA"), 16, 0, 32), 1, 120), count("WAYBILL_NUMBER"), count(distinct "WAYBILL_NUMBER"), sum(sys_op_opnsize("WAYBILL_NUMBER")), substrb(dump(min(substrb("WAYBILL_NUMBER", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("WAYBILL_NUMBER", 1, 32)), 16, 0, 32), 1, 120), count("INVOICING_RULE_NAME"), count(distinct "INVOICING_RULE_NAME"), sum(sys_op_opnsize("INVOICING_RULE_NAME")), substrb(dump(min("INVOICING_RULE_NAME"), 16, 0, 32), 1, 120), substrb(dump(max("INVOICING_RULE_NAME"), 16, 0, 32), 1, 120), count("INVOICING_RULE_ID"), count(distinct "INVOICING_RULE_ID"), sum(sys_op_opnsize("INVOICING_RULE_ID")), substrb(dump(min("INVOICING_RULE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("INVOICING_RULE_ID"), 16, 0, 32), 1, 120), count("ACCOUNTING_RULE_NAME"), count(distinct "ACCOUNTING_RULE_NAME"), sum(sys_ op_opnsize("ACCOUNTING_RULE_NAME")), substrb(dump(min("ACCOUNTING_RULE_NAME"), 16, 0, 32), 1, 120), substrb(dump(max("ACCOUNTING_RULE_NAME"), 16, 0, 32), 1, 120), count("ACCOUNTING_RULE_ID"), count(distinct "ACCOUNTING_RULE_ID"), sum(sys_op_opnsize("ACCOUNTING_RULE_ID")), substrb(dump(min("ACCOUNTING_RULE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("ACCOUNTING_RULE_ID"), 16, 0, 32), 1, 120), count("ACCOUNTING_RULE_DURATION"), count(distinct "ACCOUNTING_RULE_DURATION"), sum(sys_op_opnsize("ACCOUNTING_RULE_DURATION")), substrb(dump(min("ACCOUNTING_RULE_DURATION"), 16, 0, 32), 1, 120), substrb(dump(max("ACCOUNTING_RULE_DURATION"), 16, 0, 32), 1, 120), count("RULE_START_DATE"), count(distinct "RULE_START_DATE"), substrb(dump(min("RULE_START_DATE"), 16, 0, 32), 1, 120), substrb(dump(max("RULE_START_DATE"), 16, 0, 32), 1, 120), count("PRIMARY_SALESREP_NUMBER"), count(distinct "PRIMARY_SALESREP_NUMBER"), sum(sys_op_opnsize("PRIMARY_SALESREP_NUMBER")), substrb(dump(min("PRIMARY_SALESREP_NUMBER"), 16, 0, 32), 1, 120), substrb(dump(max("PRIMARY_SALESREP_NUMBER"), 16, 0, 32), 1, 120), count("PRIMARY_SALESREP_ID"), count(distinct "PRIMARY_SALESREP_ID"), sum(sys_op_opnsize("PRIMARY_SALESREP_ID")), substrb(dump(min("PRIMARY_SALESREP_ID"), 16, 0, 32), 1, 120), substrb(dump(max("PRIMARY_SALESREP_ID"), 16, 0, 32), 1, 120), count("SALES_ORDER"), count(distinct "SALES_ORDER"), sum(sys_op_opnsize("SALES_ORDER")), substrb(dump(min(substrb("SALES_ORDER", 1, 32)), 16, 0, 32), 1, 120), substrb(dump( max(substrb("SALES_ORDER", 1, 32)), 16, 0, 32), 1, 120), count("SALES_ORDER_LINE"), count(distinct "SALES_ORDER_LINE"), sum(sys_op_opnsize("SALES_ORDER_LINE")), substrb(dump(min("SALES_ORDER_LINE"), 16, 0, 32), 1, 120), substrb(dump(max("SALES_ORDER_LINE"), 16, 0, 32), 1, 120), count("SALES_ORDER_DATE"), count(distinct "SALES_ORDER_DATE"), substrb(dump(min("SALES_ORDER_DATE"), 16, 0, 32), 1, 120), substrb(dump(max("SALES_ORDER_DATE"), 16, 0, 32), 1, 120), count("SALES_ORDER_SOURCE"), count(distinct "SALES_ORDER_SOURCE"), sum(sys_op_opnsize("SALES_ORDER_SOURCE")), substrb(dump(min(substrb("SALES_ORDER_SOURCE", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("SALES_ORDER_SOURCE", 1, 32)), 16, 0, 32), 1, 120), count("SALES_ORDER_REVISION"), count(distinct "SALES_ORDER_REVISION"), sum(sys_op_opnsize("SALES_ORDER_REVISION")), substrb(dump(min("SALES_ORDER_REVISION"), 16, 0, 32), 1, 120), substrb(dump(max("SALES_ORDER_REVISION"), 16, 0, 32), 1, 120), count("PURCHASE_ORDER"), count(distinct "PURCHASE_ORDER"), sum(sys_op_opnsize("PURCHASE_ORDER")), substrb(dump(min(substrb("PURCHASE_ORDER", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("PURCHASE_ORDER", 1, 32)), 16, 0, 32), 1, 120), count("PURCHASE_ORDER_REVISION"), count(distinct "PURCHASE_ORDER_REVISION"), sum(sys_op_opnsize("PURCHASE_ORDER_REVISION")), substrb(dump(min(substrb("PURCHASE_ORDER_REVISION", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("PURCHASE_ORDER_REVISION", 1, 32)), 16, 0, 32), 1, 120), c ount("PURCHASE_ORDER_DATE"), count(distinct "PURCHASE_ORDER_DATE"), substrb(dump(min("PURCHASE_ORDER_DATE"), 16, 0, 32), 1, 120), substrb(dump(max("PURCHASE_ORDER_DATE"), 16, 0, 32), 1, 120), count("AGREEMENT_NAME"), count(distinct "AGREEMENT_NAME"), sum(sys_op_opnsize("AGREEMENT_NAME")), substrb(dump(min("AGREEMENT_NAME"), 16, 0, 32), 1, 120), substrb(dump(max("AGREEMENT_NAME"), 16, 0, 32), 1, 120), count("AGREEMENT_ID"), count(distinct "AGREEMENT_ID"), sum(sys_op_opnsize("AGREEMENT_ID")), substrb(dump(min("AGREEMENT_ID"), 16, 0, 32), 1, 120), substrb(dump(max("AGREEMENT_ID"), 16, 0, 32), 1, 120), count("MEMO_LINE_NAME"), count(distinct "MEMO_LINE_NAME"), sum(sys_op_opnsize("MEMO_LINE_NAME")), substrb(dump(min(substrb("MEMO_LINE_NAME", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MEMO_LINE_NAME", 1, 32)), 16, 0, 32), 1, 120), count("MEMO_LINE_ID"), count(distinct "MEMO_LINE_ID"), sum(sys_op_opnsize("MEMO_LINE_ID")), substrb(dump(min("MEMO_LINE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("MEMO_LINE_ID"), 16, 0, 32), 1, 120), count("INVENTORY_ITEM_ID"), count(distinct "INVENTORY_ITEM_ID"), sum(sys_op_opnsize("INVENTORY_ITEM_ID")), substrb(dump(min("INVENTORY_ITEM_ID"), 16, 0, 32), 1, 120), substrb(dump(max("INVENTORY_ITEM_ID"), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG1"), count(distinct "MTL_SYSTEM_ITEMS_SEG1"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG1")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG1", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(subst rb("MTL_SYSTEM_ITEMS_SEG1", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG2"), count(distinct "MTL_SYSTEM_ITEMS_SEG2"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG2")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG2", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG2", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG3"), count(distinct "MTL_SYSTEM_ITEMS_SEG3"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG3")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG3", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG3", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG4"), count(distinct "MTL_SYSTEM_ITEMS_SEG4"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG4")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG4", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG4", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG5"), count(distinct "MTL_SYSTEM_ITEMS_SEG5"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG5")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG5", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG5", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG6"), count(distinct "MTL_SYSTEM_ITEMS_SEG6"), sum(sys_op_opnsize("????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? ????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????
64qc329wgjv39 select /*+ ORDERED INDEX(ASSBAL PAY_ASSIGNMENT_LATEST_BALA_N1) INDEX(DEFBAL PAY_DEFINED_BALANCES_PK) INDEX(ACT PAY_ASSIGNMENT_ACTIONS_PK) INDEX(PACT PAY_PAYROLL_ACTIONS_PK) INDEX(VALUE PAY_BALANCE_CONTEXT_VALUES_PK) USE_NL(ASSBAL DEFBAL ACT PACT VALUE) +*/ ASSBAL.defined_balance_id , DEFBAL.balance_dimension_id , to_char(ASSBAL.value) , ASSBAL.latest_balance_id , ASSBAL.rowid , to_char(ASSBAL.assignment_action_id) , ACT.payroll_action_id , to_char(PACT.effective_date, :b0) , to_number(to_char(PACT.effective_date, 'J')) , nvl(VALUE.context_id, 0) , nvl(VALUE.value, 'NULL') , to_char(ASSBAL.expired_assignment_action_id) , to_char(ASSBAL.expired_value) , to_char(ASSBAL.prev_assignment_action_id) , to_char(ASSBAL.prev_balance_value) from pay_assignment_latest_balances ASSBAL , pay_defined_balances DEFBAL , pay_assignment_actions ACT , pay_payroll_actions PACT , pay_balance_context_values VALUE where ((((ASSBAL.assignment_id=:b1 and ACT.assignment_action_id=ASSBAL.assignment_action_id) and PACT.payroll_action_id=ACT.payroll_action_id) and DEFBAL.defined_balance_id=ASSBAL.defined_balance_id) and VALUE.latest_balance_id(+)=ASSBAL.latest_balance_id) union all select /*+ ORDERED INDEX(PERBAL PAY_PERSON_LATEST_BALANCES_N2) INDEX(DEFBAL PAY_DEFINED_BALANCES_PK) INDEX(ACT PAY_ASSIGNMENT_ACTIONS_PK) INDEX(VALUE PAY_BALANCE_CONTEXT_VALUES_PK) INDEX(PACT PAY_PAYROLL_ACTIONS_PK) USE_NL(PERBAL DEFBAL ACT PACT VALUE) +*/ PERBAL.defined_balance_id , DEFBAL.balance_dimension_id , to_char (PERBAL.value) , PERBAL.latest_balance_id , PERBAL.rowid , to_char(PERBAL.assignment_action_id) , ACT.payroll_action_id , to_char(PACT.effective_date, :b0) , to_number(to_char(PACT.effective_date, 'J')) , nvl(VALUE.context_id, 0) , nvl(VALUE.value, 'NULL') , to_char(PERBAL.expired_assignment_action_id) , to_char(PERBAL.expired_value) , to_char(PERBAL.prev_assignment_action_id) , to_char(PERBAL.prev_balance_value) from pay_person_latest_balances PERBAL , pay_defined_balances DEFBAL , pay_assignment_actions ACT , pay_payroll_actions PACT , pay_balance_context_values VALUE where ((((PERBAL.person_id=:b3 and ACT.assignment_action_id=PERBAL.assignment_action_id) and PACT.payroll_action_id=ACT.payroll_action_id) and DEFBAL.defined_balance_id=PERBAL.defined_balance_id) and VALUE.latest_balance_id(+)=PERBAL.latest_balance_id) order by 6, 2, 1, 4, 10 desc
66tmsr3446uqn SELECT WIAS.ACTIVITY_STATUS, WIAS.ACTIVITY_RESULT_CODE, WIAS.ASSIGNED_USER, WIAS.NOTIFICATION_ID, WIAS.BEGIN_DATE, WIAS.END_DATE, WIAS.DUE_DATE, WIAS.ERROR_NAME, WIAS.ERROR_MESSAGE, WIAS.ERROR_STACK FROM WF_ITEM_ACTIVITY_STATUSES WIAS WHERE WIAS.ITEM_TYPE = :B3 AND WIAS.ITEM_KEY = :B2 AND WIAS.PROCESS_ACTIVITY = :B1
6cjfxb1c4kx16 SELECT PROFILE_OPTION_ID, APPLICATION_ID, SITE_ENABLED_FLAG , APP_ENABLED_FLAG , RESP_ENABLED_FLAG , USER_ENABLED_FLAG, ORG_ENABLED_FLAG , SERVER_ENABLED_FLAG, HIERARCHY_TYPE FROM FND_PROFILE_OPTIONS WHERE PROFILE_OPTION_NAME = UPPER(:B1 ) AND START_DATE_ACTIVE <= SYSDATE AND NVL(END_DATE_ACTIVE, SYSDATE) >= SYSDATE
6djyj1t4djs12 select /*+ parallel(t, 16) parallel_index(t, 16) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*), count("INTERFACE_SALESCREDIT_ID"), sum(sys_op_opnsize("INTERFACE_SALESCREDIT_ID")), substrb(dump(min("INTERFACE_SALESCREDIT_ID"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_SALESCREDIT_ID"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ID"), count(distinct "INTERFACE_LINE_ID"), sum(sys_op_opnsize("INTERFACE_LINE_ID")), substrb(dump(min("INTERFACE_LINE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ID"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_CONTEXT"), count(distinct "INTERFACE_LINE_CONTEXT"), sum(sys_op_opnsize("INTERFACE_LINE_CONTEXT")), substrb(dump(min("INTERFACE_LINE_CONTEXT"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_CONTEXT"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE1"), count(distinct "INTERFACE_LINE_ATTRIBUTE1"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE1")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE1"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE1"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE2"), count(distinct "INTERFACE_LINE_ATTRIBUTE2"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE2")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE2"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE2"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE3"), count(distinct "INTERFACE_LINE_ATTRIBUTE3"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIB UTE3")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE3"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE3"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE4"), count(distinct "INTERFACE_LINE_ATTRIBUTE4"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE4")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE4"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE4"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE5"), count(distinct "INTERFACE_LINE_ATTRIBUTE5"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE5")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE5"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE5"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE6"), count(distinct "INTERFACE_LINE_ATTRIBUTE6"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE6")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE6"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE6"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE7"), count(distinct "INTERFACE_LINE_ATTRIBUTE7"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE7")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE7"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE7"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE8"), count(distinct "INTERFACE_LINE_ATTRIBUTE8"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE8")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE8"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE8"), 16, 0, 32), 1, 120), count("SALESREP_NUMB ER"), count(distinct "SALESREP_NUMBER"), sum(sys_op_opnsize("SALESREP_NUMBER")), substrb(dump(min("SALESREP_NUMBER"), 16, 0, 32), 1, 120), substrb(dump(max("SALESREP_NUMBER"), 16, 0, 32), 1, 120), count("SALESREP_ID"), count(distinct "SALESREP_ID"), sum(sys_op_opnsize("SALESREP_ID")), substrb(dump(min("SALESREP_ID"), 16, 0, 32), 1, 120), substrb(dump(max("SALESREP_ID"), 16, 0, 32), 1, 120), count("SALES_CREDIT_TYPE_NAME"), count(distinct "SALES_CREDIT_TYPE_NAME"), sum(sys_op_opnsize("SALES_CREDIT_TYPE_NAME")), substrb(dump(min("SALES_CREDIT_TYPE_NAME"), 16, 0, 32), 1, 120), substrb(dump(max("SALES_CREDIT_TYPE_NAME"), 16, 0, 32), 1, 120), count("SALES_CREDIT_TYPE_ID"), count(distinct "SALES_CREDIT_TYPE_ID"), sum(sys_op_opnsize("SALES_CREDIT_TYPE_ID")), substrb(dump(min("SALES_CREDIT_TYPE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("SALES_CREDIT_TYPE_ID"), 16, 0, 32), 1, 120), count("SALES_CREDIT_AMOUNT_SPLIT"), count(distinct "SALES_CREDIT_AMOUNT_SPLIT"), sum(sys_op_opnsize("SALES_CREDIT_AMOUNT_SPLIT")), substrb(dump(min("SALES_CREDIT_AMOUNT_SPLIT"), 16, 0, 32), 1, 120), substrb(dump(max("SALES_CREDIT_AMOUNT_SPLIT"), 16, 0, 32), 1, 120), count("SALES_CREDIT_PERCENT_SPLIT"), count(distinct "SALES_CREDIT_PERCENT_SPLIT"), sum(sys_op_opnsize("SALES_CREDIT_PERCENT_SPLIT")), substrb(dump(min("SALES_CREDIT_PERCENT_SPLIT"), 16, 0, 32), 1, 120), substrb(dump(max("SALES_CREDIT_PERCENT_SPLIT"), 16, 0, 32), 1, 120), count("INTERFACE_STATUS"), count(distinct "INTERFACE_STATUS"), sum(sys_op _opnsize("INTERFACE_STATUS")), substrb(dump(min("INTERFACE_STATUS"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_STATUS"), 16, 0, 32), 1, 120), count("REQUEST_ID"), count(distinct "REQUEST_ID"), sum(sys_op_opnsize("REQUEST_ID")), substrb(dump(min("REQUEST_ID"), 16, 0, 32), 1, 120), substrb(dump(max("REQUEST_ID"), 16, 0, 32), 1, 120), count("ATTRIBUTE_CATEGORY"), count(distinct "ATTRIBUTE_CATEGORY"), sum(sys_op_opnsize("ATTRIBUTE_CATEGORY")), substrb(dump(min("ATTRIBUTE_CATEGORY"), 16, 0, 32), 1, 120), substrb(dump(max("ATTRIBUTE_CATEGORY"), 16, 0, 32), 1, 120), count("ATTRIBUTE1"), count(distinct "ATTRIBUTE1"), sum(sys_op_opnsize("ATTRIBUTE1")), substrb(dump(min(substrb("ATTRIBUTE1", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE1", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE2"), count(distinct "ATTRIBUTE2"), sum(sys_op_opnsize("ATTRIBUTE2")), substrb(dump(min(substrb("ATTRIBUTE2", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE2", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE3"), count(distinct "ATTRIBUTE3"), sum(sys_op_opnsize("ATTRIBUTE3")), substrb(dump(min(substrb("ATTRIBUTE3", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE3", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE4"), count(distinct "ATTRIBUTE4"), sum(sys_op_opnsize("ATTRIBUTE4")), substrb(dump(min(substrb("ATTRIBUTE4", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE4", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE5"), count(dist inct "ATTRIBUTE5"), sum(sys_op_opnsize("ATTRIBUTE5")), substrb(dump(min(substrb("ATTRIBUTE5", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE5", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE6"), count(distinct "ATTRIBUTE6"), sum(sys_op_opnsize("ATTRIBUTE6")), substrb(dump(min(substrb("ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE7"), count(distinct "ATTRIBUTE7"), sum(sys_op_opnsize("ATTRIBUTE7")), substrb(dump(min(substrb("ATTRIBUTE7", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE7", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE8"), count(distinct "ATTRIBUTE8"), sum(sys_op_opnsize("ATTRIBUTE8")), substrb(dump(min(substrb("ATTRIBUTE8", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE8", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE9"), count(distinct "ATTRIBUTE9"), sum(sys_op_opnsize("ATTRIBUTE9")), substrb(dump(min(substrb("ATTRIBUTE9", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE9", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE10"), count(distinct "ATTRIBUTE10"), sum(sys_op_opnsize("ATTRIBUTE10")), substrb(dump(min(substrb("ATTRIBUTE10", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE10", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE11"), count(distinct "ATTRIBUTE11"), sum(sys_op_opnsize("ATTRIBUTE11")), substrb(dump(min(substrb("ATTRIBUTE11", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substr b("ATTRIBUTE11", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE12"), count(distinct "ATTRIBUTE12"), sum(sys_op_opnsize("ATTRIBUTE12")), substrb(dump(min(substrb("ATTRIBUTE12", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE12", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE13"), count(distinct "ATTRIBUTE13"), sum(sys_op_opnsize("ATTRIBUTE13")), substrb(dump(min(substrb("ATTRIBUTE13", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE13", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE14"), count(distinct "ATTRIBUTE14"), sum(sys_op_opnsize("ATTRIBUTE14")), substrb(dump(min(substrb("ATTRIBUTE14", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE14", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE15"), count(distinct "ATTRIBUTE15"), sum(sys_op_opnsize("ATTRIBUTE15")), substrb(dump(min(substrb("ATTRIBUTE15", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE15", 1, 32)), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE10"), count(distinct "INTERFACE_LINE_ATTRIBUTE10"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE10")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE10"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE10"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE11"), count(distinct "INTERFACE_LINE_ATTRIBUTE11"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE11")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE11"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE11"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE12"), count(distinct "INTERFACE_LINE_ATTRIBUTE12"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE12")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE12"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE12"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE13"), count(distinct "INTERFACE_LINE_ATTRIBUTE13"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE13")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE13"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE13"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE14"), count(distinct "INTERFACE_LINE_ATTRIBUTE14"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE14")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE14"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE14"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE15"), count(distinct "INTERFACE_LINE_ATTRIBUTE15"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE15")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE15"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE15"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE9"), count(distinct "INTERFACE_LINE_ATTRIBUTE9"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE9")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE9"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE9"), 16, 0, 32), 1, 120), count("CREATED_BY"), count(distinct "CREATED_BY"), sum(sys_op_opnsize("CREATED_BY")), substrb(dump(min("CREATED_BY"), 16, 0, 32), 1, 120), substrb(dump(max("CREATED_BY"), 16, 0, 32), 1, 120), count("CREATION_DATE"), count(distinct "CREATION_DATE"), substrb(dump(min("CREATION_DATE"), 16, 0, 32), 1, 120), substrb(dump(max("CREATION_DATE"), 16, 0, 32), 1, 120), count("LAST_UPDATED_BY"), count(distinct "LAST_UPDATED_BY"), sum(sys_op_opnsize("LAST_UPDATED_BY")), substrb(dump(min("LAST_UPDATED_BY"), 16, 0, 32), 1, 120), substrb(dump(max("LAST_UPDATED_BY"), 16, 0, 32), 1, 120), count("LAST_UPDATE_DATE"), count(distinct "LAST_UPDATE_DATE"), substrb(dump(min("LAST_UPDATE_DATE"), 16, 0, 32), 1, 120), substrb(dump(max("LAST_UPDATE_DATE"), 16, 0, 32), 1, 120), count("LAST_UPDATE_LOGIN"), count(distinct "LAST_UPDATE_LOGIN"), sum(sys_op_opnsize("LAST_UPDATE_LOGIN")), substrb(dump(min("LAST_UPDATE_LOGIN"), 16, 0, 32), 1, 120), substrb(dump(max("LAST_UPDATE_LOGIN"), 16, 0, 32), 1, 120), count("ORG_ID"), count(distinct "ORG_ID"), sum(sys_op_opnsize("ORG_ID")), substrb(dump(min("ORG_ID"), 16, 0, 32), 1, 120), substrb(dump(max("ORG_ID"), 16, 0, 32), 1, 120), count("SALESGROUP_ID"), count(distinct "SALESGROUP_ID"), sum(sys_op_opnsize("SALESGROUP_ID")), substrb(dump(min("SALESGROUP_ID"), 16, 0, 32), 1, 120), substrb(dump(max("SALESGROUP_ID"), 16, 0, 32), 1, 120) from "AR"."RA_INTERFACE_SALESCREDITS_ALL" sample ( 10.0000000000) t
6h2tpcxpymqu7 BEGIN :1 := FND_AOLJ_UTIL.is_Valid_ICX(:2, NULL, 'Y', TRUE, TRUE, NULL, NULL, NULL, NULL, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, TRUE);:19 := fnd_session_management.g_enc_key;:20 := fnd_session_management.g_mac_key;END;
7g05xfvc5vp74 BEGIN arp_run.revenue_recognition( :errbuf, :rc, :A0, :A1, :A2); END;
8ay7m8qubw98j select * from PO_TAX_LINES_SUMMARY_V where trx_header_id = :b1 ORDER BY trx_header_id, trx_line_id, trx_shipment_id , trx_distribution_id
95pbs94n69z3d SELECT NVL(MULTI_ORG_FLAG, 'N'), NVL(MULTI_CURRENCY_FLAG, 'N') FROM FND_PRODUCT_GROUPS
9dvfguzd15kpv SELECT VALUE FROM V$NLS_PARAMETERS WHERE PARAMETER = :B1
9sf243fdjmdmh begin fnd_global.apps_initialize(-1, -1, -1, :1); end;
9wdrypwkpf607 begin OE_FULFILL_WF.START_FULFILLMENT (:v1, :v2, :v3, :v4, :v5); end;
a29grr748ghc4 BEGIN jdr_custom_internal.getActiveLayers(:1, :2, :3, :4, :5); END;
a957tvxz9w038 BEGIN :1 := por_util_pkg.interface_START_WORKFLOW( :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, :42, :43, :44, :45, :46, :47, :48, :49, :50, :51, :52, :53, :54, :55, :56, :57, :58, :59, :60, :61, :62, :63, :64, :65, :66, :67, :68, :69, :70, :71, :72, :73, :74, :75, :76, :77, :78, :79, :80, :81, :82, :83, :84, :85, :86, :87, :88, :89, :90, :91, :92, :93, :94, :95, :96, :97, :98, :99, :100, :101, :102) ; END;
avc1jqzz04wpr SELECT 'x' FROM DUAL
b3an778qn1q49 select /*+ parallel(t, 16) parallel_index(t, 16) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*), count("INTERFACE_LINE_ATTRIBUTE13"), count(distinct "INTERFACE_LINE_ATTRIBUTE13"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE13")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE13"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE13"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE14"), count(distinct "INTERFACE_LINE_ATTRIBUTE14"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE14")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE14"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE14"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE15"), count(distinct "INTERFACE_LINE_ATTRIBUTE15"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE15")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE15"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE15"), 16, 0, 32), 1, 120), count("INTERFACE_LINE_ATTRIBUTE9"), count(distinct "INTERFACE_LINE_ATTRIBUTE9"), sum(sys_op_opnsize("INTERFACE_LINE_ATTRIBUTE9")), substrb(dump(min("INTERFACE_LINE_ATTRIBUTE9"), 16, 0, 32), 1, 120), substrb(dump(max("INTERFACE_LINE_ATTRIBUTE9"), 16, 0, 32), 1, 120), count("VAT_TAX_ID"), count(distinct "VAT_TAX_ID"), sum(sys_op_opnsize("VAT_TAX_ID")), substrb(dump(min("VAT_TAX_ID"), 16, 0, 32), 1, 120), substrb(dump(max("VAT_TAX_ID"), 16, 0, 32), 1, 120), count("REASON_CODE_MEANING"), count(distinct "REASON_CODE_MEANING"), sum(sys_o p_opnsize("REASON_CODE_MEANING")), substrb(dump(min(substrb("REASON_CODE_MEANING", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("REASON_CODE_MEANING", 1, 32)), 16, 0, 32), 1, 120), count("LAST_PERIOD_TO_CREDIT"), count(distinct "LAST_PERIOD_TO_CREDIT"), sum(sys_op_opnsize("LAST_PERIOD_TO_CREDIT")), substrb(dump(min("LAST_PERIOD_TO_CREDIT"), 16, 0, 32), 1, 120), substrb(dump(max("LAST_PERIOD_TO_CREDIT"), 16, 0, 32), 1, 120), count("PAYING_CUSTOMER_ID"), count(distinct "PAYING_CUSTOMER_ID"), sum(sys_op_opnsize("PAYING_CUSTOMER_ID")), substrb(dump(min("PAYING_CUSTOMER_ID"), 16, 0, 32), 1, 120), substrb(dump(max("PAYING_CUSTOMER_ID"), 16, 0, 32), 1, 120), count("PAYING_SITE_USE_ID"), count(distinct "PAYING_SITE_USE_ID"), sum(sys_op_opnsize("PAYING_SITE_USE_ID")), substrb(dump(min("PAYING_SITE_USE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("PAYING_SITE_USE_ID"), 16, 0, 32), 1, 120), count("TAX_EXEMPT_FLAG"), count(distinct "TAX_EXEMPT_FLAG"), sum(sys_op_opnsize("TAX_EXEMPT_FLAG")), substrb(dump(min("TAX_EXEMPT_FLAG"), 16, 0, 32), 1, 120), substrb(dump(max("TAX_EXEMPT_FLAG"), 16, 0, 32), 1, 120), count("TAX_EXEMPT_REASON_CODE"), count(distinct "TAX_EXEMPT_REASON_CODE"), sum(sys_op_opnsize("TAX_EXEMPT_REASON_CODE")), substrb(dump(min("TAX_EXEMPT_REASON_CODE"), 16, 0, 32), 1, 120), substrb(dump(max("TAX_EXEMPT_REASON_CODE"), 16, 0, 32), 1, 120), count("TAX_EXEMPT_REASON_CODE_MEANING"), count(distinct "TAX_EXEMPT_REASON_CODE_MEANING"), sum(sys_op_opnsize("TAX_EXEMPT_REASON_ CODE_MEANING")), substrb(dump(min(substrb("TAX_EXEMPT_REASON_CODE_MEANING", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("TAX_EXEMPT_REASON_CODE_MEANING", 1, 32)), 16, 0, 32), 1, 120), count("TAX_EXEMPT_NUMBER"), count(distinct "TAX_EXEMPT_NUMBER"), sum(sys_op_opnsize("TAX_EXEMPT_NUMBER")), substrb(dump(min(substrb("TAX_EXEMPT_NUMBER", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("TAX_EXEMPT_NUMBER", 1, 32)), 16, 0, 32), 1, 120), count("SALES_TAX_ID"), count(distinct "SALES_TAX_ID"), sum(sys_op_opnsize("SALES_TAX_ID")), substrb(dump(min("SALES_TAX_ID"), 16, 0, 32), 1, 120), substrb(dump(max("SALES_TAX_ID"), 16, 0, 32), 1, 120), count("CREATED_BY"), count(distinct "CREATED_BY"), sum(sys_op_opnsize("CREATED_BY")), substrb(dump(min("CREATED_BY"), 16, 0, 32), 1, 120), substrb(dump(max("CREATED_BY"), 16, 0, 32), 1, 120), count("CREATION_DATE"), count(distinct "CREATION_DATE"), substrb(dump(min("CREATION_DATE"), 16, 0, 32), 1, 120), substrb(dump(max("CREATION_DATE"), 16, 0, 32), 1, 120), count("LAST_UPDATED_BY"), count(distinct "LAST_UPDATED_BY"), sum(sys_op_opnsize("LAST_UPDATED_BY")), substrb(dump(min("LAST_UPDATED_BY"), 16, 0, 32), 1, 120), substrb(dump(max("LAST_UPDATED_BY"), 16, 0, 32), 1, 120), count("LAST_UPDATE_DATE"), count(distinct "LAST_UPDATE_DATE"), substrb(dump(min("LAST_UPDATE_DATE"), 16, 0, 32), 1, 120), substrb(dump(max("LAST_UPDATE_DATE"), 16, 0, 32), 1, 120), count("LAST_UPDATE_LOGIN"), count(distinct "LAST_UPDATE_LOGIN"), sum(sys_op_opnsize(" LAST_UPDATE_LOGIN")), substrb(dump(min("LAST_UPDATE_LOGIN"), 16, 0, 32), 1, 120), substrb(dump(max("LAST_UPDATE_LOGIN"), 16, 0, 32), 1, 120), count("LOCATION_SEGMENT_ID"), count(distinct "LOCATION_SEGMENT_ID"), sum(sys_op_opnsize("LOCATION_SEGMENT_ID")), substrb(dump(min("LOCATION_SEGMENT_ID"), 16, 0, 32), 1, 120), substrb(dump(max("LOCATION_SEGMENT_ID"), 16, 0, 32), 1, 120), count("MOVEMENT_ID"), count(distinct "MOVEMENT_ID"), sum(sys_op_opnsize("MOVEMENT_ID")), substrb(dump(min("MOVEMENT_ID"), 16, 0, 32), 1, 120), substrb(dump(max("MOVEMENT_ID"), 16, 0, 32), 1, 120), count("ORG_ID"), count(distinct "ORG_ID"), sum(sys_op_opnsize("ORG_ID")), substrb(dump(min("ORG_ID"), 16, 0, 32), 1, 120), substrb(dump(max("ORG_ID"), 16, 0, 32), 1, 120), count("AMOUNT_INCLUDES_TAX_FLAG"), count(distinct "AMOUNT_INCLUDES_TAX_FLAG"), sum(sys_op_opnsize("AMOUNT_INCLUDES_TAX_FLAG")), substrb(dump(min("AMOUNT_INCLUDES_TAX_FLAG"), 16, 0, 32), 1, 120), substrb(dump(max("AMOUNT_INCLUDES_TAX_FLAG"), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTR_CATEGORY"), count(distinct "HEADER_GDF_ATTR_CATEGORY"), sum(sys_op_opnsize("HEADER_GDF_ATTR_CATEGORY")), substrb(dump(min("HEADER_GDF_ATTR_CATEGORY"), 16, 0, 32), 1, 120), substrb(dump(max("HEADER_GDF_ATTR_CATEGORY"), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE1"), count(distinct "HEADER_GDF_ATTRIBUTE1"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE1")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE1", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEA DER_GDF_ATTRIBUTE1", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE2"), count(distinct "HEADER_GDF_ATTRIBUTE2"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE2")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE2", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE2", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE3"), count(distinct "HEADER_GDF_ATTRIBUTE3"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE3")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE3", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE3", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE4"), count(distinct "HEADER_GDF_ATTRIBUTE4"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE4")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE4", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE4", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE5"), count(distinct "HEADER_GDF_ATTRIBUTE5"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE5")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE5", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE5", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE6"), count(distinct "HEADER_GDF_ATTRIBUTE6"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE6")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE7"), count(distinct "HEADER _GDF_ATTRIBUTE7"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE7")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE7", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE7", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE8"), count(distinct "HEADER_GDF_ATTRIBUTE8"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE8")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE8", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE8", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE9"), count(distinct "HEADER_GDF_ATTRIBUTE9"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE9")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE9", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE9", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE10"), count(distinct "HEADER_GDF_ATTRIBUTE10"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE10")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE10", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE10", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE11"), count(distinct "HEADER_GDF_ATTRIBUTE11"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE11")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE11", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE11", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE12"), count(distinct "HEADER_GDF_ATTRIBUTE12"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE12")), substrb(dump(min(substrb("H EADER_GDF_ATTRIBUTE12", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE12", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE13"), count(distinct "HEADER_GDF_ATTRIBUTE13"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE13")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE13", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE13", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE14"), count(distinct "HEADER_GDF_ATTRIBUTE14"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE14")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE14", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE14", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE15"), count(distinct "HEADER_GDF_ATTRIBUTE15"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE15")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE15", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE15", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE16"), count(distinct "HEADER_GDF_ATTRIBUTE16"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE16")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE16", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE16", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE17"), count(distinct "HEADER_GDF_ATTRIBUTE17"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE17")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE17", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb(" HEADER_GDF_ATTRIBUTE17", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE18"), count(distinct "HEADER_GDF_ATTRIBUTE18"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE18")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE18", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE18", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE19"), count(distinct "HEADER_GDF_ATTRIBUTE19"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE19")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE19", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE19", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE20"), count(distinct "HEADER_GDF_ATTRIBUTE20"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE20")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE20", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE20", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE21"), count(distinct "HEADER_GDF_ATTRIBUTE21"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE21")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE21", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE21", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE22"), count(distinct "HEADER_GDF_ATTRIBUTE22"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE22")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE22", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE22", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBU TE23"), count(distinct "HEADER_GDF_ATTRIBUTE23"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE23")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE23", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE23", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE24"), count(distinct "HEADER_GDF_ATTRIBUTE24"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE24")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE24", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE24", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE25"), count(distinct "HEADER_GDF_ATTRIBUTE25"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE25")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE25", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE25", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE26"), count(distinct "HEADER_GDF_ATTRIBUTE26"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE26")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE26", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE26", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE27"), count(distinct "HEADER_GDF_ATTRIBUTE27"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE27")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE27", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE27", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE28"), count(distinct "HEADER_GDF_ATTRIBUTE28"), sum(sys_op_opnsize("HEADER_GDF _ATTRIBUTE28")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE28", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE28", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE29"), count(distinct "HEADER_GDF_ATTRIBUTE29"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE29")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE29", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE29", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE30"), count(distinct "HEADER_GDF_ATTRIBUTE30"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE30")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE30", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE30", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTR_CATEGORY"), count(distinct "LINE_GDF_ATTR_CATEGORY"), sum(sys_op_opnsize("LINE_GDF_ATTR_CATEGORY")), substrb(dump(min("LINE_GDF_ATTR_CATEGORY"), 16, 0, 32), 1, 120), substrb(dump(max("LINE_GDF_ATTR_CATEGORY"), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE1"), count(distinct "LINE_GDF_ATTRIBUTE1"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE1")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE1", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE1", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE2"), count(distinct "LINE_GDF_ATTRIBUTE2"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE2")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE2", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIB UTE2", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE3"), count(distinct "LINE_GDF_ATTRIBUTE3"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE3")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE3", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE3", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE4"), count(distinct "LINE_GDF_ATTRIBUTE4"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE4")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE4", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE4", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE5"), count(distinct "LINE_GDF_ATTRIBUTE5"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE5")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE5", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE5", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE6"), count(distinct "LINE_GDF_ATTRIBUTE6"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE6")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE7"), count(distinct "LINE_GDF_ATTRIBUTE7"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE7")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE7", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE7", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE8"), count(distinct "LINE_GDF_ATTRIBUTE8"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE8")), subst rb(dump(min(substrb("LINE_GDF_ATTRIBUTE8", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE8", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE9"), count(distinct "LINE_GDF_ATTRIBUTE9"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE9")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE9", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE9", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE10"), count(distinct "LINE_GDF_ATTRIBUTE10"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE10")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE10", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE10", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE11"), count(distinct "LINE_GDF_ATTRIBUTE11"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE11")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE11", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE11", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE12"), count(distinct "LINE_GDF_ATTRIBUTE12"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE12")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE12", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE12", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE13"), count(distinct "LINE_GDF_ATTRIBUTE13"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE13")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE13", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE13", 1, 32)), 16, 0 , 32), 1, 120), count("LINE_GDF_ATTRIBUTE14"), count(distinct "LINE_GDF_ATTRIBUTE14"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE14")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE14", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE14", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE15"), count(distinct "LINE_GDF_ATTRIBUTE15"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE15")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE15", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE15", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE16"), count(distinct "LINE_GDF_ATTRIBUTE16"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE16")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE16", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE16", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE17"), count(distinct "LINE_GDF_ATTRIBUTE17"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE17")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE17", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE17", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE18"), count(distinct "LINE_GDF_ATTRIBUTE18"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE18")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE18", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE18", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE19"), count(distinct "LINE_GDF_ATTRIBUTE19"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE19")) , substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE19", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE19", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE20"), count(distinct "LINE_GDF_ATTRIBUTE20"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE20")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE20", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE20", 1, 32)), 16, 0, 32), 1, 120), count("RESET_TRX_DATE_FLAG"), count(distinct "RESET_TRX_DATE_FLAG"), sum(sys_op_opnsize("RESET_TRX_DATE_FLAG")), substrb(dump(min("RESET_TRX_DATE_FLAG"), 16, 0, 32), 1, 120), substrb(dump(max("RESET_TRX_DATE_FLAG"), 16, 0, 32), 1, 120), count("PAYMENT_SERVER_ORDER_NUM"), count(distinct "PAYMENT_SERVER_ORDER_NUM"), sum(sys_op_opnsize("PAYMENT_SERVER_ORDER_NUM")), substrb(dump(min(substrb("PAYMENT_SERVER_ORDER_NUM", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("PAYMENT_SERVER_ORDER_NUM", 1, 32)), 16, 0, 32), 1, 120), count("APPROVAL_CODE"), count(distinct "APPROVAL_CODE"), sum(sys_op_opnsize("APPROVAL_CODE")), substrb(dump(min(substrb("APPROVAL_CODE", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("APPROVAL_CODE", 1, 32)), 16, 0, 32), 1, 120), count("ADDRESS_VERIFICATION_CODE"), count(distinct "ADDRESS_VERIFICATION_CODE"), sum(sys_op_opnsize("ADDRESS_VERIFICATION_CODE")), substrb(dump(min(substrb("ADDRESS_VERIFICATION_CODE", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ADDRESS_VERIFICATION_CODE", 1, 32)), 16, 0, 32), 1, 120 ), count("WAREHOUSE_ID"), count(distinct "WAREHOUSE_ID"), sum(sys_op_opnsize("WAREHOUSE_ID")), substrb(dump(min("WAREHOUSE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("WAREHOUSE_ID"), 16, 0, 32), 1, 120), count("TRANSLATED_DESCRIPTION"), count(distinct "TRANSLATED_DESCRIPTION"), sum(sys_op_opnsize("TRANSLATED_DESCRIPTION")), substrb(dump(min(substrb("TRANSLATED_DESCRIPTION", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("TRANSLATED_DESCRIPTION", 1, 32)), 16, 0, 32), 1, 120), count("CONS_BILLING_NUMBER"), count(distinct "CONS_BILLING_NUMBER"), sum(sys_op_opnsize("CONS_BILLING_NUMBER")), substrb(dump(min("CONS_BILLING_NUMBER"), 16, 0, 32), 1, 120), substrb(dump(max("CONS_BILLING_NUMBER"), 16, 0, 32), 1, 120), count("PROMISED_COMMITMENT_AMOUNT"), count(distinct "PROMISED_COMMITMENT_AMOUNT"), sum(sys_op_opnsize("PROMISED_COMMITMENT_AMOUNT")), substrb(dump(min("PROMISED_COMMITMENT_AMOUNT"), 16, 0, 32), 1, 120), substrb(dump(max("PROMISED_COMMITMENT_AMOUNT"), 16, 0, 32), 1, 120), count("PAYMENT_SET_ID"), count(distinct "PAYMENT_SET_ID"), sum(sys_op_opnsize("PAYMENT_SET_ID")), substrb(dump(min("PAYMENT_SET_ID"), 16, 0, 32), 1, 120), substrb(dump(max("PAYMENT_SET_ID"), 16, 0, 32), 1, 120), count("ORIGINAL_GL_DATE"), count(distinct "ORIGINAL_GL_DATE"), substrb(dump(min("ORIGINAL_GL_DATE"), 16, 0, 32), 1, 120), substrb(dump(max("ORIGINAL_GL_DATE"), 16, 0, 32), 1, 120), count("CONTRACT_LINE_ID"), count(distinct "CONTRACT_LINE_ID"), sum(sys_op_opnsize("CONTRACT_LINE_ID")), subst rb(dump(min("CONTRACT_LINE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("CONTRACT_LINE_ID"), 16, 0, 32), 1, 120), count("CONTRACT_ID"), count(distinct "CONTRACT_ID"), sum(sys_op_opnsize("CONTRACT_ID")), substrb(dump(min("CONTRACT_ID"), 16, 0, 32), 1, 120), substrb(dump(max("CONTRACT_ID"), 16, 0, 32), 1, 120), count("SOURCE_DATA_KEY1"), count(distinct "SOURCE_DATA_KEY1"), sum(sys_op_opnsize("SOURCE_DATA_KEY1")), substrb(dump(min(substrb("SOURCE_DATA_KEY1", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("SOURCE_DATA_KEY1", 1, 32)), 16, 0, 32), 1, 120), count("SOURCE_DATA_KEY2"), count(distinct "SOURCE_DATA_KEY2"), sum(sys_op_opnsize("SOURCE_DATA_KEY2")), substrb(dump(min(substrb("SOURCE_DATA_KEY2", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("SOURCE_DATA_KEY2", 1, 32)), 16, 0, 32), 1, 120), count("SOURCE_DATA_KEY3"), count(distinct "SOURCE_DATA_KEY3"), sum(sys_op_opnsize("SOURCE_DATA_KEY3")), substrb(dump(min(substrb("SOURCE_DATA_KEY3", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("SOURCE_DATA_KEY3", 1, 32)), 16, 0, 32), 1, 120), count("SOURCE_DATA_KEY4"), count(distinct "SOURCE_DATA_KEY4"), sum(sys_op_opnsize("SOURCE_DATA_KEY4")), substrb(dump(min(substrb("SOURCE_DATA_KEY4", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("SOURCE_DATA_KEY4", 1, 32)), 16, 0, 32), 1, 120), count("SOURCE_DATA_KEY5"), count(distinct "SOURCE_DATA_KEY5"), sum(sys_op_opnsize("SOURCE_DATA_KEY5")), substrb(dump(min(substrb("SOURCE_DATA_KEY5", 1, 32)), 16, 0, 32), 1, 1 20), substrb(dump(max(substrb("SOURCE_DATA_KEY5", 1, 32)), 16, 0, 32), 1, 120), count("INVOICED_LINE_ACCTG_LEVEL"), count(distinct "INVOICED_LINE_ACCTG_LEVEL"), sum(sys_op_opnsize("INVOICED_LINE_ACCTG_LEVEL")), substrb(dump(min("INVOICED_LINE_ACCTG_LEVEL"), 16, 0, 32), 1, 120), substrb(dump(max("INVOICED_LINE_ACCTG_LEVEL"), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG10"), count(distinct "MTL_SYSTEM_ITEMS_SEG10"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG10")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG10", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG10", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG11"), count(distinct "MTL_SYSTEM_ITEMS_SEG11"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG11")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG11", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG11", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG12"), count(distinct "MTL_SYSTEM_ITEMS_SEG12"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG12")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG12", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG12", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG13"), count(distinct "MTL_SYSTEM_ITEMS_SEG13"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG13")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG13", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG13", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM _ITEMS_SEG14"), count(distinct "MTL_SYSTEM_ITEMS_SEG14"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG14")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG14", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG14", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG15"), count(distinct "MTL_SYSTEM_ITEMS_SEG15"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG15")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG15", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG15", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG16"), count(distinct "MTL_SYSTEM_ITEMS_SEG16"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG16")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG16", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG16", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG17"), count(distinct "MTL_SYSTEM_ITEMS_SEG17"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG17")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG17", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG17", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG18"), count(distinct "MTL_SYSTEM_ITEMS_SEG18"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG18")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG18", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG18", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG19"), count(distinct "MTL_SYSTEM_ITEMS_SEG19"), sum(sys_op_opnsize("MT L_SYSTEM_ITEMS_SEG19")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG19", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG19", 1, 32)), 16, 0, 32), 1, 120), count("MTL_SYSTEM_ITEMS_SEG20"), count(distinct "MTL_SYSTEM_ITEMS_SEG20"), sum(sys_op_opnsize("MTL_SYSTEM_ITEMS_SEG20")), substrb(dump(min(substrb("MTL_SYSTEM_ITEMS_SEG20", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MTL_SYSTEM_ITEMS_SEG20", 1, 32)), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ID"), count(distinct "REFERENCE_LINE_ID"), sum(sys_op_opnsize("REFERENCE_LINE_ID")), substrb(dump(min("REFERENCE_LINE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ID"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_CONTEXT"), count(distinct "REFERENCE_LINE_CONTEXT"), sum(sys_op_opnsize("REFERENCE_LINE_CONTEXT")), substrb(dump(min("REFERENCE_LINE_CONTEXT"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_CONTEXT"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE1"), count(distinct "REFERENCE_LINE_ATTRIBUTE1"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE1")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE1"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE1"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE2"), count(distinct "REFERENCE_LINE_ATTRIBUTE2"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE2")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE2"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE2"), 16, 0, 32), 1, 120), count("REFERENCE _LINE_ATTRIBUTE3"), count(distinct "REFERENCE_LINE_ATTRIBUTE3"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE3")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE3"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE3"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE4"), count(distinct "REFERENCE_LINE_ATTRIBUTE4"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE4")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE4"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE4"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE5"), count(distinct "REFERENCE_LINE_ATTRIBUTE5"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE5")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE5"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE5"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE6"), count(distinct "REFERENCE_LINE_ATTRIBUTE6"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE6")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE6"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE6"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE7"), count(distinct "REFERENCE_LINE_ATTRIBUTE7"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE7")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE7"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE7"), 16, 0, 32), 1, 120), count("TERRITORY_ID"), count(distinct "TERRITORY_ID"), sum(sys_op_opnsize("TERRITORY_ID")), substrb(dump(min("TERRITORY_ID"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_ID"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT1"), count(distinct "TERRITORY_SEGMENT1"), sum(sys_op_opnsize("TERRITORY_SEGMENT1")), substrb(dump(min("TERRITORY_SEGMENT1"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT1"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT2"), count(distinct "TERRITORY_SEGMENT2"), sum(sys_op_opnsize("TERRITORY_SEGMENT2")), substrb(dump(min("TERRITORY_SEGMENT2"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT2"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT3"), count(distinct "TERRITORY_SEGMENT3"), sum(sys_op_opnsize("TERRITORY_SEGMENT3")), substrb(dump(min("TERRITORY_SEGMENT3"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT3"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT4"), count(distinct "TERRITORY_SEGMENT4"), sum(sys_op_opnsize("TERRITORY_SEGMENT4")), substrb(dump(min("TERRITORY_SEGMENT4"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT4"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT5"), count(distinct "TERRITORY_SEGMENT5"), sum(sys_op_opnsize("TERRITORY_SEGMENT5")), substrb(dump(min("TERRITORY_SEGMENT5"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT5"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT6"), count(distinct "TERRITORY_SEGMENT6"), sum(sys_op_opnsize("TERRITORY_SEGMENT6")), substrb(dump(min("TERRITORY_SEGMENT6"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT6"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT7"), count(distinct "TERRITORY_SEGMENT7"), sum(sys_op_opnsize(" TERRITORY_SEGMENT7")), substrb(dump(min("TERRITORY_SEGMENT7"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT7"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT8"), count(distinct "TERRITORY_SEGMENT8"), sum(sys_op_opnsize("TERRITORY_SEGMENT8")), substrb(dump(min("TERRITORY_SEGMENT8"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT8"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT9"), count(distinct "TERRITORY_SEGMENT9"), sum(sys_op_opnsize("TERRITORY_SEGMENT9")), substrb(dump(min("TERRITORY_SEGMENT9"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT9"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT10"), count(distinct "TERRITORY_SEGMENT10"), sum(sys_op_opnsize("TERRITORY_SEGMENT10")), substrb(dump(min("TERRITORY_SEGMENT10"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT10"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT11"), count(distinct "TERRITORY_SEGMENT11"), sum(sys_op_opnsize("TERRITORY_SEGMENT11")), substrb(dump(min("TERRITORY_SEGMENT11"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT11"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT12"), count(distinct "TERRITORY_SEGMENT12"), sum(sys_op_opnsize("TERRITORY_SEGMENT12")), substrb(dump(min("TERRITORY_SEGMENT12"), 16, 0, 32), 1, 120), substrb(d????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? ???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? ??????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????, 1, 120), substrb(dump(max(substrb("ATTRIBUTE1", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE2"), count(distinct "ATTRIBUTE2"), sum(sys_op_opnsize("ATTRIBUTE2")), substrb(dump(min(substrb("ATTRIBUTE2", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE2", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE3"), count(distinct "ATTRIBUTE3"), sum(sys_op_opnsize("ATTRIBUTE3")), substrb(dump(min(substrb("ATTRIBUTE3", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE3", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE4"), count(distinct "ATTRIBUTE4"), sum(sys_op_opnsize("ATTRIBUTE4")), substrb(dump(min(substrb("ATTRIBUTE4", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE4", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE5"), count(distinct "ATTRIBUTE5"), sum(sys_op_opnsize("ATTRIBUTE5")), substrb(dump(min(substrb("ATTRIBUTE5", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE5", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE6"), count(distinct "ATTRIBUTE6"), sum(sys_op_opnsize("ATTRIBUTE6" )), substrb(dump(min(substrb("ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE7"), count(distinct "ATTRIBUTE7"), sum(sys_op_opnsize("ATTRIBUTE7")), substrb(dump(min(substrb("ATTRIBUTE7", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE7", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE8"), count(distinct "ATTRIBUTE8"), sum(sys_op_opnsize("ATTRIBUTE8")), substrb(dump(min(substrb("ATTRIBUTE8", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE8", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE9"), count(distinct "ATTRIBUTE9"), sum(sys_op_opnsize("ATTRIBUTE9")), substrb(dump(min(substrb("ATTRIBUTE9", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE9", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE10"), count(distinct "ATTRIBUTE10"), sum(sys_op_opnsize("ATTRIBUTE10")), substrb(dump(min(substrb("ATTRIBUTE10", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE10", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE11"), count(distinct "ATTRIBUTE11"), sum(sys_op_opnsize("ATTRIBUTE11")), substrb(dump(min(substrb("ATTRIBUTE11", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE11", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE12"), count(distinct "ATTRIBUTE12"), sum(sys_op_opnsize("ATTRIBUTE12")), substrb(dump(min(substrb("ATTRIBUTE12", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE12", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE13"), count(distinct "ATTRIBUTE13"), sum(sys_op_opnsize("ATTRIBUTE13")), substrb(dump(min(substrb("ATTRIBUTE13", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE13", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE14"), count(distinct "ATTRIBUTE14"), sum(sys_op_opnsize("ATTRIBUTE14")), substrb(dump(min(substrb("ATTRIBUTE14", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE14", 1, 32)), 16, 0, 32), 1, 120), count("ATTRIBUTE15"), count(distinct "ATTRIBUTE15"), sum(sys_op_opnsize("ATTRIBUTE15")), substrb(dump(min(substrb("ATTRIBUTE15", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ATTRIBUTE15", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE_CATEGORY"), count(distinct "HEADER_ATTRIBUTE_CATEGORY"), sum(sys_op_opnsize("HEADER_ATTRIBUTE_CATEGORY")), substrb(dump(min("HEADER_ATTRIBUTE_CATEGORY"), 16, 0, 32), 1, 120), substrb(dump(max("HEADER_ATTRIBUTE_CATEGORY"), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE1"), count(distinct "HEADER_ATTRIBUTE1"), sum(sys_op_opnsize("HEADER_ATTRIBUTE1")), substrb(dump(min(substrb("HEADER_ATTRIBUTE1", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE1", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE2"), count(distinct "HEADER_ATTRIBUTE2"), sum(sys_op_opnsize("HEADER_ATTRIBUTE2")), substrb(dump(min(substrb("HEADER_ATTRIBUTE2", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE2", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE3"), count(distinct "HEADER_ATTRIBUTE3"), sum(sys_op_opnsize("HEADER_ATTRIBUTE3")), substrb(dump(min(substrb("HEADER_ATTRIBUTE3", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE3", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE4"), count(distinct "HEADER_ATTRIBUTE4"), sum(sys_op_opnsize("HEADER_ATTRIBUTE4")), substrb(dump(min(substrb("HEADER_ATTRIBUTE4", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE4", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE5"), count(distinct "HEADER_ATTRIBUTE5"), sum(sys_op_opnsize("HEADER_ATTRIBUTE5")), substrb(dump(min(substrb("HEADER_ATTRIBUTE5", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE5", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE6"), count(distinct "HEADER_ATTRIBUTE6"), sum(sys_op_opnsize("HEADER_ATTRIBUTE6")), substrb(dump(min(substrb("HEADER_ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE7"), count(distinct "HEADER_ATTRIBUTE7"), sum(sys_op_opnsize("HEADER_ATTRIBUTE7")), substrb(dump(min(substrb("HEADER_ATTRIBUTE7", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE7", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE8"), count(distinct "HEADER_ATTRIBUTE8"), sum(sys_op_opnsize("HEADER_ATTRIBUTE8")), substrb(dump(min(substrb("HEADER_ATTRIBUTE8", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE8", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE9"), count(distinct "HEADER_ATTRIBUTE9"), sum(sys_op_opnsize("HEADER_ATTRIBUTE9")), substrb(dump(min(substrb("HEADER_ATTRIBUTE9", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE9", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE10"), count(distinct "HEADER_ATTRIBUTE10"), sum(sys_op_opnsize("HEADER_ATTRIBUTE10")), substrb(dump(min(substrb("HEADER_ATTRIBUTE10", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE10", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE11"), count(distinct "HEADER_ATTRIBUTE11"), sum(sys_op_opnsize("HEADER_ATTRIBUTE11")), substrb(dump(min(substrb("HEADER_ATTRIBUTE11", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE11", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE12"), count(distinct "HEADER_ATTRIBUTE12"), sum(sys_op_opnsize("HEADER_ATTRIBUTE12")), substrb(dump(min(substrb("HEADER_ATTRIBUTE12", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE12", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE13"), count(distinct "HEADER_ATTRIBUTE13"), sum(sys_op_opnsize("HEADER_ATTRIBUTE13")), substrb(dump(min(substrb("HEADER_ATTRIBUTE13", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE13", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE14"), count(distinct "HEADER_ATTRIBUTE14"), sum(sys_op_opnsize("HEADER_ATTRIBUTE14")), substrb(dump(min(substrb("HEADER_ATTRIBUTE14", 1 , 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE14", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_ATTRIBUTE15"), count(distinct "HEADER_ATTRIBUTE15"), sum(sys_op_opnsize("HEADER_ATTRIBUTE15")), substrb(dump(min(substrb("HEADER_ATTRIBUTE15", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_ATTRIBUTE15", 1, 32)), 16, 0, 32), 1, 120) from "AR"."RA_INTERFACE_LINES_ALL" sample ( 10.0000000000) t
bc7t6t6jfx2n7 SELECT VERSION FROM FND_CACHE_VERSIONS WHERE NAME = :B1
bcym7s1bp0wxs SELECT WIA.NAME FROM WF_ITEM_ATTRIBUTES WIA WHERE WIA.ITEM_TYPE = :B1 AND WIA.TYPE = 'EVENT'
bkxrrs52m7d8p BEGIN WSH_SHIP_CONFIRM_ACTIONS.interface_ALL_wrp( :errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8); END;
bp8crdjba8zgt update ra_cust_trx_line_gl_dist set gl_posted_date=:b0, posting_control_id=:b1, last_update_date=sysdate , last_updated_by=:b2 where (cust_trx_line_gl_dist_id in (select to_number(reference23) from gl_interface where ((((user_je_source_name=:b3 and set_of_books_id=:b4) and group_id=:b1) and (reference30||'')='RA_CUST_TRX_LINE_GL_DIST') and accounting_date between to_date((:b6||' 00:00:00'), 'DD-MON-RR HH24:MI:SS') and to_date((:b7||' 23:59:59'), 'DD-MON-RR HH24:MI:SS'))) and set_of_books_id=:b4)
bt0w082dfrm8v BEGIN WSH_SHIP_CONFIRM_ACTIONS.interface_ALL_wrp( :errbuf, :rc, :A0, :A1, :A2, :A3); END;
bvyqm6268u2as SELECT NODE_NAME FROM FND_NODES WHERE NODE_ID = :B1
by0sg8ccaazuk UPDATE MRP_ATP_SCHEDULE_TEMP SET SCENARIO_ID = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), NVL(:B44 , -1), SCENARIO_ID), INVENTORY_ITEM_ID = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B43 , INVENTORY_ITEM_ID), INVENTORY_ITEM_NAME = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B42 , INVENTORY_ITEM_NAME), SOURCE_ORGANIZATION_ID =DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B40 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B41 , NULL)), SOURCE_ORGANIZATION_CODE = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B38 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B39 , NULL)), ORDER_HEADER_ID = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), NVL(:B37 , -1), NULL), DEMAND_SOURCE_TYPE = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B36 , NULL), DELIVERY_LEAD_TIME = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B34 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B35 , NULL)), SHIP_METHOD = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B32 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B33 , NULL)), DEMAND_CLASS = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B31 , NULL), SCHEDULED_SHIP_DATE = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B29 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B30 , NULL)), AVAILABLE_QUANTITY = DECO DE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B28 , NULL), REQUESTED_DATE_QUANTITY = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B27 , NULL), GROUP_SHIP_DATE = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B25 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B26 , NULL)), GROUP_ARRIVAL_DATE = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B23 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B24 , NULL)), ERROR_CODE = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B21 , DECODE(ERROR_CODE, NULL, DECODE(:B22 , 150, 0, 61, 0, 0, 0, :B51 ))), ERROR_MESSAGE = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B20 , NULL), STATUS_FLAG = 2, END_PEGGING_ID = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B18 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B19 , NULL)), SCHEDULED_ARRIVAL_DATE = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B16 , DECODE(NVL(CASCADE_MODEL_INFO_TO_COMP, 1), 1, :B17 , NULL)), ORGANIZATION_ID = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B15 , NULL), REQUEST_ITEM_ID = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B14 , NULL), REQUEST_ITEM_NAME = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B13 , NULL), REQ_ITEM_REQ_DATE_QTY = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B12 , NULL), REQ_ITEM_A VAILABLE_DATE_QTY = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B11 , NULL), REQ_ITEM_AVAILABLE_DATE =DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B10 , NULL), SALES_REP = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B9 , NULL), CUSTOMER_CONTACT = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B8 , NULL), COMPILE_DESIGNATOR = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), DECODE(:B50 , 4, :B7 , NULL), NULL), SUBST_FLAG = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B6 , NULL), MATCH_ITEM_ID = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B5 , NULL), MATCHED_ITEM_NAME = DECODE(ORDER_LINE_ID, NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID), :B4 , NULL), PLAN_ID = :B3 , FIRST_VALID_SHIP_ARRIVAL_DATE = :B2 , ATP_LEAD_TIME = DECODE(ATO_MODEL_LINE_ID, NULL, NULL, ORDER_LINE_ID, 0, :B1 ) WHERE SESSION_ID = :B49 AND STATUS_FLAG = 99 AND NVL(ATO_MODEL_LINE_ID, ORDER_LINE_ID) = :B48 AND NVL(:B47 , 2) = 2 AND NVL(SOURCE_ORGANIZATION_ID, NVL(:B45 , -1)) = NVL(:B46 , -1)
c4y7jp0q2awbf SELECT PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES WHERE PROFILE_OPTION_ID = :B4 AND APPLICATION_ID = :B3 AND LEVEL_ID = :B2 AND LEVEL_VALUE = :B1
cwyx16zn1hpfb select parameter, value from nls_session_parameters
fhqzxap2n0ybj select NAME from HR_OPERATING_UNITS where ORGANIZATION_ID = :zorg_id
fmfdkztk8vx23 SELECT CATEGORY, SEVERITY, FND_LOG_SEVERITY FROM FND_NEW_MESSAGES WHERE MESSAGE_NAME = :B1 AND APPLICATION_ID = :B2 AND LANGUAGE_CODE = :B3 AND ROWNUM = 1
g8102j8yynbwz begin WF_STANDARD.CONTINUEFLOW (:v1, :v2, :v3, :v4, :v5); end;
gf1u933c95jb5 DECLARE l_ret_stat varchar2(56); BEGIN CSI_INV_TXN_HOOK_PKG.postTransaction( p_header_id => :1 , p_transaction_id => :2 , x_return_status => l_ret_stat ); INV_TXNSTUB_PUB.g_ret_status := l_ret_stat; END;
ghw9svn8x4vzu BEGIN WSH_PICK_LIST.RELEASE_BATCH_SRS( :errbuf, :rc, :A0, :A1, :A2); END;
gksvm8wmzk8w0 begin OE_INVOICE_WF.INVOICE_INTERFACE (:v1, :v2, :v3, :v4, :v5); end;

Back to SQL Statistics
Back to Top

 

Instance Activity Statistics

Back to Top

Instance Activity Stats

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

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistic Begin Value End Value
session cursor cache count 471,483 1,309,594
opened cursors current 863,226 900,004
workarea memory allocated 4,679 2,112
logons current 5,224 5,196

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

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 100 0 6.90 1.00 411,627 114 261,453 0.05
APPS_TS_TX_IDX 138,677 38 5.50 1.45 217,565 60 86,987 0.31
APPS_TS_TX_DATA 169,115 47 4.95 1.31 172,898 48 110,490 0.29
APPS_ASSM_DATA 33,074 9 2.62 1.98 283,019 78 52,225 0.37
APPS_ASSM_IDX 39,850 11 4.07 1.00 145,945 40 282,114 0.11
APPS_TS_TX_INTERFACE 820 0 6.33 2.24 30,813 9 3,182 0.10
APPS_TS_QUEUES 3,447 1 8.09 1.50 24,025 7 104 0.48
SYSTEM 7,709 2 4.98 1.51 5,298 1 7,302 0.47
TEMP 971 0 4.20 4.77 10,172 3 88 6.59
APPS_TS_SEED 2,537 1 7.67 1.47 4,459 1 834 3.25
APPS_TS_SUMMARY 61 0 9.02 1.00 4,653 1 2,888 0.05
CTXSYS 199 0 6.78 1.28 4,496 1 0 0.00
APPS_TS_ARCHIVE 65 0 8.15 1.00 2,163 1 146 5.00
SYSAUX 536 0 3.19 1.85 636 0 0 0.00
APPS_TS_NOLOGGING 32 0 4.06 1.44 67 0 2 0.00
APPS_TS_MEDIA 9 0 10.00 1.00 9 0 0 0.00
ODM 7 0 4.29 1.00 3 0 0 0.00
OLAP 7 0 1.43 1.00 3 0 0 0.00
OWAPUB 7 0 5.71 1.00 3 0 0 0.00
PORTAL 7 0 4.29 1.00 3 0 0 0.00
SYNCSERVER 7 0 2.86 1.00 3 0 0 0.00

Back to IO Stats
Back to Top

File IO Stats

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

Back to IO Stats
Back to Top

 

Buffer Pool Statistics

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


Back to Top

 

Advisory Statistics

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

Back to Advisory Statistics
Back to Top

 

Buffer Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit % W/A MB Processed Extra W/A MB Read/Written
100.00 643,612 5

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

  PGA Aggr Target(M) Auto PGA Target(M) PGA Mem Alloc(M) W/A PGA Used(M) %PGA W/A Mem %Auto W/A Mem %Man W/A Mem Global Mem Bound(K)
B 20,480 1,280 41,897.75 1.12 0.00 100.00 0.00 1,048,576
E 20,480 1,280 46,495.30 1.37 0.00 100.00 0.00 1,048,576

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High Optimal Total Execs Optimal Execs 1-Pass Execs M-Pass Execs
2K 4K 7,550,414 7,550,414 0 0
64K 128K 11,969 11,969 0 0
128K 256K 1,505 1,505 0 0
256K 512K 935 935 0 0
512K 1024K 253,740 253,740 0 0
1M 2M 386,871 386,871 0 0
2M 4M 80 78 2 0
4M 8M 20 20 0 0
8M 16M 18 18 0 0
32M 64M 8 8 0 0
64M 128M 6 6 0 0
128M 256M 2 2 0 0

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

PGA Target Est (MB) Size Factr W/A MB Processed Estd Extra W/A MB Read/ Written to Disk Estd PGA Cache Hit % Estd PGA Overalloc Count
2,560 0.13 904,896.81 10,579.71 99.00 1,260
5,120 0.25 904,896.81 10,479.90 99.00 1,223
10,240 0.50 904,896.81 10,353.75 99.00 1,153
15,360 0.75 904,896.81 10,185.20 99.00 1,106
20,480 1.00 904,896.81 0.00 100.00 1,057
24,576 1.20 904,896.81 0.00 100.00 1,014
28,672 1.40 904,896.81 0.00 100.00 936
32,768 1.60 904,896.81 0.00 100.00 177
36,864 1.80 904,896.81 0.00 100.00 0
40,960 2.00 904,896.81 0.00 100.00 0
61,440 3.00 904,896.81 0.00 100.00 0
81,920 4.00 904,896.81 0.00 100.00 0
122,880 6.00 904,896.81 0.00 100.00 0
163,840 8.00 904,896.81 0.00 100.00 0

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

Shared Pool Size(M) SP Size Factr Est LC Size (M) Est LC Mem Obj Est LC Time Saved (s) Est LC Time Saved Factr Est LC Load Time (s) Est LC Load Time Factr Est LC Mem Obj Hits
320 0.10 320 14,930 6,609,314 1.00 5,546 2.29 218,061,546
624 0.20 618 18,969 6,611,200 1.00 3,660 1.51 218,129,999
928 0.30 920 21,534 6,612,435 1.00 2,425 1.00 218,175,135
1,232 0.40 1,191 25,690 6,612,442 1.00 2,418 1.00 218,176,042
1,536 0.50 1,330 33,444 6,612,443 1.00 2,417 1.00 218,176,194
1,840 0.60 1,330 33,444 6,612,443 1.00 2,417 1.00 218,176,194
2,144 0.70 1,330 33,444 6,612,443 1.00 2,417 1.00 218,176,194
2,448 0.80 1,330 33,444 6,612,443 1.00 2,417 1.00 218,176,194
2,752 0.90 1,330 33,444 6,612,443 1.00 2,417 1.00 218,176,194
3,056 1.00 1,330 33,444 6,612,443 1.00 2,417 1.00 218,176,194
3,360 1.10 1,330 33,444 6,612,443 1.00 2,417 1.00 218,176,194
3,664 1.20 1,330 33,444 6,612,443 1.00 2,417 1.00 218,176,194
3,968 1.30 1,330 33,444 6,612,443 1.00 2,417 1.00 218,176,194
4,272 1.40 1,330 33,444 6,612,443 1.00 2,417 1.00 218,176,194
4,576 1.50 1,330 33,444 6,612,443 1.00 2,417 1.00 218,176,194
4,880 1.60 1,330 33,444 6,612,443 1.00 2,417 1.00 218,176,194
5,184 1.70 1,330 33,444 6,612,443 1.00 2,417 1.00 218,176,194
5,488 1.80 1,330 33,444 6,612,443 1.00 2,417 1.00 218,176,194
5,792 1.90 1,330 33,444 6,612,443 1.00 2,417 1.00 218,176,194
6,096 1.99 1,330 33,444 6,612,443 1.00 2,417 1.00 218,176,194

Back to Advisory Statistics
Back to Top

SGA Target Advisory

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

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

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

Back to Advisory Statistics
Back to Top

Java Pool Advisory

Java Pool Size(M) JP Size Factr Est LC Size (M) Est LC Mem Obj Est LC Time Saved (s) Est LC Time Saved Factr Est LC Load Time (s) Est LC Load Time Factr Est LC Mem Obj Hits
32 0.33 11 315 1,875 1.00 2,417 1.00 17,404
48 0.50 12 321 1,875 1.00 2,417 1.00 17,404
64 0.67 12 321 1,875 1.00 2,417 1.00 17,404
80 0.83 12 321 1,875 1.00 2,417 1.00 17,404
96 1.00 12 321 1,875 1.00 2,417 1.00 17,404
112 1.17 12 321 1,875 1.00 2,417 1.00 17,404
128 1.33 12 321 1,875 1.00 2,417 1.00 17,404
144 1.50 12 321 1,875 1.00 2,417 1.00 17,404
160 1.67 12 321 1,875 1.00 2,417 1.00 17,404
176 1.83 12 321 1,875 1.00 2,417 1.00 17,404
192 2.00 12 321 1,875 1.00 2,417 1.00 17,404
208 2.17 12 321 1,875 1.00 2,417 1.00 17,404

Back to Advisory Statistics
Back to Top

 

Wait Statistics

Back to Top

Buffer Wait Statistics

Class Waits Total Wait Time (s) Avg Time (ms)
data block 539,146 115 0
undo block 214,851 10 0
undo header 46,538 4 0
file header block 89 1 7
1st level bmb 3,824 0 0
segment header 3,136 0 0
2nd level bmb 205 0 0
extent map 11 0 0

Back to Wait Statistics
Back to Top

Enqueue Activity

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

Back to Wait Statistics
Back to Top

 

Undo Statistics

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,759.00 1,373,700 2,585 395   0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

End Time Num Undo Blocks Number of Transactions Max Qry Len (s) Max Tx Concy Tun Ret (mins) STO/ OOS uS/uR/uU/ eS/eR/eU
21-Dec 08:28 213,318 203,534 806 383 175 0/0 0/0/0/0/0/0
21-Dec 08:18 116,046 155,297 646 381 177 0/0 0/0/0/0/0/0
21-Dec 08:08 517,663 236,394 491 384 169 0/0 0/0/0/0/0/0
21-Dec 07:58 336,380 227,837 2,331 384 222 0/0 0/0/0/0/0/0
21-Dec 07:48 231,911 245,126 2,585 383 277 0/0 0/0/0/0/0/0
21-Dec 07:38 343,684 305,512 2,226 395 338 0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

 

Latch Statistics

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,512 0.00   0 0  
AWR Alerted Metric Element list 330,314 0.00   0 0  
Consistent RBA 925,509 0.06 0.01 0 0  
FOB s.o list latch 67,736 0.01 0.00 0 0  
In memory undo latch 695,086,355 1.56 0.00 3 1,346,536 0.00
JOX SGA heap latch 1,967,191 0.00   0 0  
JS mem alloc latch 0     0 2 0.00
JS queue state obj latch 20,820 0.00   0 0  
JS slv state obj latch 171 0.00   0 0  
KMG MMAN ready and startup request latch 1,233 0.00   0 0  
KMG resize request state object freelist 4 0.00   0 0  
KTF sga latch 12 0.00   0 1,215 0.00
KWQMN job cache list latch 10,632 0.03 1.00 0 0  
KWQP Prop Status 453 0.00   0 0  
MQL Tracking Latch 0     0 72 0.00
Memory Management Latch 72 0.00   0 1,231 0.00
Memory Queue 2 0.00   0 0  
OS process 16,194 0.00   0 0  
OS process allocation 11,963 0.00   0 0  
OS process: request allocation 10,465 0.00   0 0  
PL/SQL warning settings 5,501,651 0.00   0 0  
SGA IO buffer pool latch 88,872 0.02 0.00 0 104,673 0.32
SQL memory manager latch 1 0.00   0 1,191 0.00
SQL memory manager workarea list latch 7,200,172 0.01 0.00 0 0  
Shared B-Tree 2,355 0.00   0 0  
active checkpoint queue latch 1,927,911 2.71 0.00 0 2 0.00
active service list 52,837 0.23 0.00 0 1,333 0.00
alert log latch 0     0 2 0.00
begin backup scn array 196 0.00   0 0  
bq:time manger info latch 129 0.00   0 0  
buffer pool 4 0.00   0 0  
bufq statistics 2 0.00   0 0  
cache buffer handles 23,401,433 1.96 0.00 0 0  
cache buffers chains 4,837,971,881 1.33 0.04 193 18,447,828 2.58
cache buffers lru chain 11,897,334 0.51 0.02 3 37,681,940 0.63
cache table scan latch 0     0 7,750 0.03
channel handle pool latch 445,316 0.09 0.01 0 0  
channel operations parent latch 1,806,462 0.60 0.01 0 0  
checkpoint queue latch 36,957,681 0.02 0.00 0 3,860,557 0.06
client/application info 2,813,299 0.00 0.00 0 0  
commit callback allocation 87,428 0.00   0 0  
compile environment latch 3,722,430 0.00   0 0  
dictionary lookup 78 0.00   0 0  
dml lock allocation 4,312,126 0.34 0.00 0 0  
dummy allocation 21,737 0.26 0.00 0 0  
enqueue hash chains 10,130,897 0.21 0.00 0 996 0.00
enqueue sob latch 1 0.00   0 0  
enqueues 6,584,650 0.29 0.00 0 0  
error message lists 1,584 1.26 0.00 0 0  
event group latch 5,217 0.00   0 0  
file cache latch 24,700 0.00   0 0  
global KZLD latch for mem in SGA 9,949 0.00   0 0  
global ctx hash table latch 24,534 0.00   0 0  
hash table column usage latch 1,661 0.30 0.00 0 16,054,438 0.00
hash table modification latch 140 0.00   0 2 0.00
internal temp table object number allocation latc 3 0.00   0 0  
job workq parent latch 0     0 118 0.00
job_queue_processes free list latch 0     0 2 0.00
job_queue_processes parameter latch 117 0.00   0 0  
kks stats 21,314 0.00 0.00 0 0  
ksuosstats global area 242 0.00   0 0  
ktm global data 129,525 0.00   0 0  
kwqbsn:qsga 2,221 0.00   0 0  
lgwr LWN SCN 931,048 0.22 0.00 0 0  
library cache 449,966,437 1.01 0.00 7 14,172 61.01
library cache load lock 6,557 1.54 0.02 0 21 0.00
library cache lock 128,137,902 0.19 0.00 0 1 0.00
library cache lock allocation 5,751,837 0.03 0.00 0 0  
library cache pin 261,679,612 0.41 0.00 2 25 0.00
library cache pin allocation 3,589,290 0.02 0.00 0 0  
list of block allocation 489,743 0.03 0.00 0 0  
loader state object freelist 345,212 0.01 0.00 0 0  
logminer context allocation 1 0.00   0 0  
longop free list parent 36 0.00   0 36 0.00
message pool operations parent latch 452,502 0.12 0.00 0 0  
messages 8,581,846 0.99 0.00 0 0  
mostly latch-free SCN 1,108,892 11.44 0.00 0 0  
multiblock read objects 48,225 0.00 0.00 0 2 0.00
ncodef allocation latch 223 0.00   0 0  
object queue header heap 8,143,767 0.04 0.08 0 436,381 0.12
object queue header operation 51,645,398 0.19 0.49 8 3,819 0.00
object stats modification 442,052 0.08 0.00 0 4 0.00
parallel query alloc buffer 23,516 4.09 0.00 0 0  
parallel query stats 912 8.77 0.03 0 0  
parameter table allocation management 25,125 1.91 0.80 1 0  
post/wait queue 1,269,046 0.08 0.00 0 496,395 0.03
process allocation 10,513 0.21 0.86 0 5,214 0.06
process group creation 10,465 0.01 1.00 0 0  
process queue 15,146 1.85 0.00 0 0  
process queue reference 1,444,075 0.05 0.00 0 104,005 0.48
qmn state object latch 2 0.00   0 0  
qmn task queue latch 5,107 19.91 0.84 0 0  
query server freelists 13,488 24.26 0.00 0 0  
query server process 16 0.00   0 16 0.00
redo allocation 6,635,700 7.65 0.00 1 104,156,731 4.59
redo copy 0     0 104,719,148 0.05
redo writing 5,412,397 2.65 0.00 0 0  
resmgr group change latch 1,288,521 0.00   0 0  
resmgr:actses active list 31,603 0.78 0.96 0 0  
resmgr:actses change group 30,515 0.00   0 0  
resmgr:free threads list 21,733 0.52 0.11 0 0  
resmgr:schema config 1 0.00   0 0  
row cache objects 127,959,043 1.13 0.00 1 4,319 0.39
rules engine aggregate statistics 41,406 0.00 0.00 0 0  
rules engine evaluation context statistics 0     0 2 0.00
rules engine rule set statistics 133,225 0.01 0.00 0 0  
rules engine rule statistics 50,313 0.00   0 0  
sequence cache 16,731,779 0.66 0.00 0 0  
session allocation 22,407,268 0.90 0.01 1 0  
session idle bit 102,839,951 0.03 0.00 0 0  
session state list latch 61,257 0.15 0.15 0 0  
session switching 15,436 0.00   0 0  
session timer 1,333 0.00   0 0  
shared pool 7,988,527 0.25 0.02 0 0  
shared pool sim alloc 384 0.52 0.00 0 0  
shared pool simulator 2,389,788 0.01 0.01 0 0  
sim partition latch 1 0.00   0 24,734 0.16
simulator lru latch 412 0.00   0 0  
slave class 2 0.00   0 0  
slave class create 8 0.00   0 0  
sort extent pool 1,490,620 0.18 0.00 0 0  
state object free list 12 0.00   0 0  
statistics aggregation 112 0.00   0 0  
temp lob duration state obj allocation 531 0.00   0 0  
temporary table state object allocation 13,494 0.01 0.00 0 0  
threshold alerts latch 582 0.00   0 0  
trace latch 2 0.00   0 0  
transaction allocation 124,964 0.00 0.00 0 0  
transaction branch allocation 223 0.00   0 0  
undo global data 901,694,190 1.01 0.00 3 10,972 0.17
user lock 39,980 0.03 0.00 0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch Name Get Requests Misses Sleeps Spin Gets Sleep1 Sleep2 Sleep3
cache buffers chains 4,837,971,881 64,355,692 2,393,030 62,235,136 0 0 0
In memory undo latch 695,086,355 10,843,323 12,031 10,833,032 0 0 0
undo global data 901,694,190 9,108,115 3,317 9,105,068 0 0 0
library cache 449,966,437 4,522,935 9,616 4,513,799 0 0 0
row cache objects 127,959,043 1,440,182 884 1,439,319 0 0 0
library cache pin 261,679,612 1,080,504 2,437 1,078,150 0 0 0
redo allocation 6,635,700 507,888 1,859 506,110 0 0 0
cache buffer handles 23,401,433 458,621 155 458,478 0 0 0
library cache lock 128,137,902 247,879 457 247,429 0 0 0
session allocation 22,407,268 202,038 1,378 200,705 0 0 0
redo writing 5,412,397 143,529 127 143,402 0 0 0
mostly latch-free SCN 1,108,892 126,885 112 126,773 0 0 0
sequence cache 16,731,779 111,001 60 110,942 0 0 0
object queue header operation 51,645,398 98,227 47,827 52,031 0 0 0
messages 8,581,846 85,071 146 84,925 0 0 0
cache buffers lru chain 11,897,334 60,165 970 59,230 0 0 0
active checkpoint queue latch 1,927,911 52,239 22 52,217 0 0 0
session idle bit 102,839,951 29,072 139 28,936 0 0 0
enqueue hash chains 10,130,897 21,390 31 21,359 0 0 0
shared pool 7,988,527 19,952 389 19,576 0 0 0
enqueues 6,584,650 19,259 75 19,186 0 0 0
dml lock allocation 4,312,126 14,839 70 14,771 0 0 0
channel operations parent latch 1,806,462 10,806 61 10,747 0 0 0
checkpoint queue latch 36,957,681 7,912 22 7,890 0 0 0
query server freelists 13,488 3,272 4 3,268 0 0 0
object queue header heap 8,143,767 3,219 255 2,980 0 0 0
sort extent pool 1,490,620 2,684 8 2,676 0 0 0
lgwr LWN SCN 931,048 2,043 4 2,039 0 0 0
library cache lock allocation 5,751,837 1,664 5 1,659 0 0 0
qmn task queue latch 5,107 1,017 859 171 0 0 0
parallel query alloc buffer 23,516 962 1 961 0 0 0
post/wait queue 1,269,046 952 2 950 0 0 0
SQL memory manager workarea list latch 7,200,172 675 3 672 0 0 0
library cache pin allocation 3,589,290 615 2 613 0 0 0
message pool operations parent latch 452,502 534 2 532 0 0 0
Consistent RBA 925,509 512 4 508 0 0 0
parameter table allocation management 25,125 481 383 174 0 0 0
channel handle pool latch 445,316 404 4 400 0 0 0
resmgr:actses active list 31,603 245 236 13 0 0 0
shared pool simulator 2,389,788 225 2 224 0 0 0
resmgr:free threads list 21,733 113 12 101 0 0 0
library cache load lock 6,557 101 2 99 0 0 0
session state list latch 61,257 91 14 77 0 0 0
parallel query stats 912 80 2 78 0 0 0
process allocation 10,513 22 19 3 0 0 0
KWQMN job cache list latch 10,632 3 3 0 0 0 0
process group creation 10,465 1 1 0 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch Name Where NoWait Misses Sleeps Waiter Sleeps
In memory undo latch ktiFlush: child 0 6,917 1,912
In memory undo latch kturbk 0 3,798 5,418
In memory undo latch kticmt: child 0 746 390
In memory undo latch ktichg: child 0 478 4,084
In memory undo latch ktiTxnPoolFree 0 76 0
In memory undo latch ktbgfc 0 14 232
In memory undo latch ktiBRacquire 0 2 0
KWQMN job cache list latch kwqmnuji: update job item 0 3 2
SQL memory manager workarea list latch qesmmIRegisterWorkArea 0 2 2
SQL memory manager workarea list latch qesmmIUnRegisterWorkArea 0 1 1
active checkpoint queue latch kcbbacq: scan active checkpoints 0 22 22
active service list ksws_event: ksws event 0 2 3
active service list kswsgsnp: get service name ptr 0 1 0
cache buffer handles kcbzgs 0 81 104
cache buffer handles kcbzfs 0 74 51
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 1,910,026 2,546,048
cache buffers chains kcbgtcr: fast path 0 1,047,351 56,831
cache buffers chains kcbchg: kslbegin: call CR func 0 914,190 1,553,775
cache buffers chains kcbgtcr: kslbegin excl 0 574,206 313,818
cache buffers chains kcbrls: kslbegin 0 244,327 384,999
cache buffers chains kcbzgb: scan from tail. nowait 0 123,925 0
cache buffers chains kcbgcur: kslbegin 0 43,076 22,854
cache buffers chains kcbget: pin buffer 0 33,202 15,472
cache buffers chains kcbget: exchange rls 0 12,972 12,894
cache buffers chains kcbzwb 0 10,046 6,566
cache buffers chains kcbget: exchange 0 9,128 15,302
cache buffers chains kcbcge 0 4,822 12,749
cache buffers chains kcbnlc 0 2,604 2,638
cache buffers chains kcbso1: set no access 0 1,157 159
cache buffers chains kcb_is_private 0 788 6,026
cache buffers chains kcbnew: new latch again 0 215 19
cache buffers chains kcbesc: escalate 0 200 117
cache buffers chains kcbgtcr: kslbegin shared 0 168 131
cache buffers chains kcbbxsv 0 83 31
cache buffers chains kcbgkcbcr 0 52 88
cache buffers chains kcbbic2 0 41 13
cache buffers chains kcb_pre_apply: kcbhq61 0 20 1,244
cache buffers chains kcbzib: exchange rls 0 17 24
cache buffers chains kcbzhngcbk1: get hash chain latch no wait 0 14 0
cache buffers chains kcb_post_apply: kcbhq62 0 9 237
cache buffers chains kcb_post_apply: kcbhq63 0 4 200
cache buffers chains kcbzib: finish free bufs 0 4 9
cache buffers chains kcbzib: multi-block read: nowait 0 4 0
cache buffers chains kcbbic1 0 2 27
cache buffers chains kcbrlb1 0 1 11
cache buffers chains kcbw_next_free 0 1 0
cache buffers lru chain kcbzgws 0 597 0
cache buffers lru chain kcbo_link_q 0 108 23
cache buffers lru chain kcbgtcr:CR Scan:KCBRSKIP 0 89 0
cache buffers lru chain kcbbxsv: move to being written 0 84 277
cache buffers lru chain kcbzgb: posted for free bufs 0 38 242
cache buffers lru chain kcbzswcu 0 23 56
cache buffers lru chain kcbo_ivd_proc 0 17 201
cache buffers lru chain kcbbic2 0 14 192
channel handle pool latch ksrchconnect() 0 26 16
channel handle pool latch ksrchdelete() 0 1 18
channel operations parent latch ksrchdelete() 0 136 49
channel operations parent latch ksrapublish() 0 102 19
channel operations parent latch ksrsconsume() 0 33 53
channel operations parent latch ksrwait() 0 18 30
channel operations parent latch ksrmfree() 0 11 189
channel operations parent latch ksrchconnect() 0 10 32
checkpoint queue latch kcbklbc: Link buffer into ckpt queue 0 11 0
checkpoint queue latch kcbkubc 0 5 6
checkpoint queue latch kcbbwthc: thread checkpoint buffers 0 3 11
checkpoint queue latch kcbswcu: Switch buffers 0 3 4
dml lock allocation ktaiam 0 55 28
dml lock allocation ktaidm 0 15 42
enqueue hash chains ksqgtl3 0 19 8
enqueue hash chains ksqrcl 0 11 18
enqueue hash chains ksqcmi: get hash chain latch after wait 0 1 5
enqueues ksqgel: create enqueue 0 34 7
enqueues ksqies 0 26 55
enqueues ksqdel 0 14 13
enqueues ksqgtl2 0 1 0
event range base latch No latch 0 859 859
lgwr LWN SCN kcs023 0 20 0
library cache kglpndl: child: after processing 0 3,476 224
library cache kglpnp: child 0 2,716 3,232
library cache kglobpn: child: 0 1,083 1,851
library cache kglpin 0 640 224
library cache kglpndl: child: before processing 0 510 3,181
library cache kglLockCursor 0 397 518
library cache kglScanDependency 0 298 0
library cache kglhdgn: child: 0 126 162
library cache kgldte: child 0 0 61 148
library cache kglic 0 25 0
library cache kgldti: 2child 0 13 3
library cache kglhdgc: child: 0 12 8
library cache kglhdiv0: child 0 12 0
library cache kglivl: child 0 10 0
library cache kglhdiv0: parent: invalidate 0 7 2
library cache kglhdiv: child 0 7 6
library cache kglupd: child 0 4 0
library cache kglget: unpin heap 0 0 1 0
library cache kglobld 0 1 6
library cache kglrtl 0 1 0
library cache load lock kglllal: llatch 0 1 0
library cache load lock kglllal: llatch: in loop 0 1 2
library cache lock kgllkdl: child: cleanup 0 272 243
library cache lock kgllkal: child: multiinstance 0 185 214
library cache lock kgllkdl: child: no lock handle 0 79 43
library cache lock allocation kgllkget 0 4 0
library cache lock allocation kgllkrel 0 1 5
library cache pin kglpndl 0 1,145 1,024
library cache pin kglpnp: child 0 961 910
library cache pin kglpnal: child: alloc space 0 330 503
library cache pin kglpnal: child: check granted 0 1 0
library cache pin allocation kglpnget 0 1 2
library cache pin allocation kglpnrel 0 1 0
message pool operations parent latch ksrmalloc() 0 5 4
message pool operations parent latch ksrmfree() 0 2 3
messages ksarcv: after wait 0 67 51
messages ksarcv 0 49 87
messages ksaamb: after wakeup 0 30 8
mostly latch-free SCN kcslcu3 0 92 116
mostly latch-free SCN kcs01 0 4 4
mostly latch-free SCN kcs024 0 4 0
object queue header heap kcbo_link_q:reget 0 240 10
object queue header heap kcbw_link_q:alloc 0 12 245
object queue header heap kcbw_unlink_q 0 3 0
object queue header operation kcbo_ivbo 0 48,136 11,679
object queue header operation kcbw_link_q 0 6,266 4,327
object queue header operation kcbw_unlink_q 0 2,106 6,308
object queue header operation kcbo_switch_cq 0 356 4,333
object queue header operation kcbo_switch_q_bg 0 341 2,234
object queue header operation kcbo_switch_mq_bg 0 149 3,755
object queue header operation kcbo_swap_buf_bg 0 62 23,851
object queue header operation kcbo_link_q:reget 0 31 271
object queue header operation kcbo_write_q 0 15 0
object queue header operation kcbo_service_ockpt 0 11 0
object queue header operation kcbo_swap_buf 0 4 756
parallel query alloc buffer kxfpbalo 0 1 1
parallel query stats kxfprst: KSLBEGIN:1 0 2 2
parameter table allocation management ksp_param_table_free 0 381 379
parameter table allocation management kspptval 0 2 4
post/wait queue ksliwat:add:nowait 0 2 0
process allocation ksucrp 0 17 0
process allocation ksudlp 0 2 15
process group creation ksupgpadd 0 1 0
query server freelists kxfpobrmf 0 4 4
redo allocation kcrfw_redo_gen: redo allocation 1 0 1,245 0
redo allocation kcrfw_redo_gen: redo allocation 3 0 464 1,195
redo allocation kcrfw_redo_gen: redo allocation 2 0 111 0
redo allocation kcrfw_redo_write: before write 0 20 358
redo allocation kcrfw_redo_write: more space 0 19 381
redo writing kcrfwcr 0 109 56
redo writing kcrfw_post: rba scn pair 0 14 0
redo writing kcrfw_post: after write 0 3 63
redo writing kcrfw_cal_target_rba 0 1 9
resmgr:actses active list kgskchclass 0 236 95
resmgr:free threads list kgskthrsod 0 9 9
resmgr:free threads list kgskthrcreate 0 3 3
row cache objects kqreqd: reget 0 684 45
row cache objects kqrpre: find obj 0 125 666
row cache objects kqreqd 0 63 171
row cache objects kqrso 0 4 2
sequence cache kdnssd 0 50 0
sequence cache kdnnxt: cached seq 0 9 2
sequence cache kdnss 0 1 57
session allocation ksuxds: KSUSFCLC not set 0 676 40
session allocation ksucri 0 179 319
session allocation ksuprc 0 162 200
session allocation ksuxds: not user session 0 153 279
session allocation ksudlc 0 89 351
session allocation ksursi 0 46 96
session allocation kxfprdp 0 27 32
session allocation kxfpqidqr 0 26 57
session allocation ksudlp 0 16 3
session allocation kspallmod 0 3 0
session allocation ksucrp 0 2 1
session idle bit ksupuc: set busy 0 195 73
session idle bit ksupuc: clear busy 0 108 220
session idle bit ksuxds 0 8 18
session state list latch kpseqd 0 13 0
session state list latch kpscad 0 1 2
shared pool kghalo 0 233 122
shared pool kghfrunp: clatch: nowait 0 135 0
shared pool kghupr1 0 115 200
shared pool kghfre 0 18 52
shared pool kghfrunp: alloc: wait 0 16 0
shared pool kghfrunp: clatch: wait 0 10 8
shared pool kghalp 0 7 14
shared pool simulator kglsim_unpin_simhp 0 2 2
sort extent pool ktstdt: dealloc sort extent 0 4 0
sort extent pool ktstaddextent1 0 1 0
sort extent pool ktstallobj1 0 1 2
sort extent pool ktstcrtobj 0 1 0
sort extent pool ktstdt: return extent 0 1 2
undo global data kturimugur: child 0 2,764 1,991
undo global data ktudba: KSLBEGIN 0 476 1,297
undo global data ktucof: at start 0 40 0
undo global data ktusmasp: ktugd_tuux 0 23 3
undo global data ktufrbs: child 0 7 16
undo global data ktudnx:child 0 4 10
undo global data ktubnd:child 0 2 0

Back to Latch Statistics
Back to Top

 

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

 

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

 

Segment Statistics

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 69,181,536 3.32
INV APPS_TS_TX_IDX MTL_ITEM_CATEGORIES_U1   INDEX 51,523,504 2.47
APPLSYS APPS_TS_TX_IDX FND_PROFILE_OPTION_VALUES_U1   INDEX 31,080,944 1.49
APPLSYS APPS_TS_SEED WF_ITEM_ATTRIBUTES   TABLE 23,040,528 1.11
ONT APPS_TS_TX_DATA OE_ORDER_LINES_ALL   TABLE 22,159,056 1.06

Back to Segment Statistics
Back to Top

Segments by Physical Reads

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

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

Owner Tablespace Name Object Name Subobject Name Obj. Type Row Lock Waits % of Capture
WSH APPS_TS_TX_DATA WSH_TRIP_STOPS   TABLE 12,450 19.23
APPLSYS APPS_TS_TX_IDX WF_ITEM_ACTIVITY_STATUSES_N1   INDEX 9,670 14.94
HR APPS_ASSM_IDX PAY_RUN_RESULT_VALUES_N50   INDEX 9,390 14.51
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_U1   INDEX 9,098 14.06
HR APPS_ASSM_IDX PAY_RUN_RESULTS_N50   INDEX 4,155 6.42

Back to Segment Statistics
Back to Top

Segments by ITL Waits

Owner Tablespace Name Object Name Subobject Name Obj. Type ITL Waits % of Capture
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N6   INDEX 23 32.39
APPLSYS APPS_TS_TX_IDX WF_ITEM_ATTRIBUTE_VALUES_PK   INDEX 18 25.35
GL APPS_ASSM_IDX GL_INTERFACE_N1   INDEX 5 7.04
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N5   INDEX 5 7.04
GL APPS_ASSM_IDX GL_INTERFACE_N2   INDEX 4 5.63

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

Owner Tablespace Name Object Name Subobject Name Obj. Type Buffer Busy Waits % of Capture
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_U1   INDEX 193,157 41.28
APPLSYS APPS_TS_TX_DATA WF_ITEM_ATTRIBUTE_VALUES   TABLE 62,027 13.26
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N6   INDEX 30,584 6.54
HR APPS_ASSM_IDX PAY_RUN_RESULT_VALUES_N50   INDEX 17,685 3.78
GL APPS_ASSM_DATA GL_JE_LINES   TABLE 15,404 3.29

Back to Segment Statistics
Back to Top

 

Dictionary Cache Stats

Cache Get Requests Pct Miss Scan Reqs Pct Miss Mod Reqs Final Usage
dc_awr_control 4 0.00 0   2 1
dc_constraints 648 47.07 0   648 169
dc_free_extents 38 36.84 9 0.00 15 9
dc_global_oids 7,572,464 0.00 0   0 64
dc_histogram_data 247,924 0.59 0   0 6,525
dc_histogram_defs 426,988 1.98 0   4,042 10,391
dc_object_grants 73,325 0.04 0   0 248
dc_object_ids 12,529,208 0.01 0   57 3,444
dc_objects 243,077 0.41 0   345 2,714
dc_profiles 10,010 0.00 0   0 1
dc_rollback_segments 54,184 0.00 0   28 838
dc_segments 377,109 0.22 0   18,118 5,012
dc_sequences 55,168 0.05 0   55,168 142
dc_table_scns 80,813 0.01 0   0 14
dc_tablespace_quotas 18,013 0.07 0   215 55
dc_tablespaces 6,037,570 0.00 0   0 22
dc_used_extents 5 100.00 0   5 5
dc_usernames 580,244 0.00 0   0 52
dc_users 15,095,596 0.00 0   0 80
kqlsubheap_object 6 33.33 0   0 2
outstanding_alerts 256 0.00 0   0 41


Back to Top

 

Library Cache Activity

Namespace Get Requests Pct Miss Pin Requests Pct Miss Reloads Invali- dations
BODY 1,850,276 0.01 47,731,973 -0.02 2 0
CLUSTER 60 0.00 163 0.00 0 0
INDEX 15,814 0.35 16,626 0.53 4 0
JAVA DATA 616 0.00 1 0.00 0 0
PIPE 51,381 2.53 75,080 1.73 0 0
SQL AREA 5,859 95.65 134,202,265 -0.03 3,656 313
TABLE/PROCEDURE 795,524 0.11 65,995,926 -0.02 279 0
TRIGGER 29,920 0.06 1,405,314 0.00 0 0


Back to Top

 

Memory Statistics

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 33,330.09   10.88 5.99 30 31 3,064 3,064
  Freeable 3,308.06 0.00 1.26 0.64 9   2,631 2,631
  SQL 2,626.47 1,304.76 0.86 0.51 4 22 3,056 3,054
  PL/SQL 2,337.32 178.39 0.76 0.95 3 3 3,064 3,064
  JAVA 299.24 297.84 2.47 0.43 5 7 121 121
E Other 37,206.22   12.27 6.45 42 42 3,033 3,033
  Freeable 3,588.94 0.00 1.35 0.74 9   2,665 2,665
  SQL 2,787.90 1,408.71 0.92 0.51 5 22 3,026 3,023
  PL/SQL 2,644.03 194.74 0.87 0.98 3 3 3,033 3,033
  JAVA 283.50 282.10 2.36 0.29 5 7 120 120

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions Begin Size (Bytes) End Size (Bytes) (if different)
Database Buffers 17,062,428,672 17,028,874,240
Fixed Size 2,229,152  
Redo Buffers 17,039,360  
Variable Size 3,319,397,472 3,352,951,904

Back to Memory Statistics
Back to Top

SGA breakdown difference

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

Back to Memory Statistics
Back to Top

 

Streams Statistics

Back to Top

Streams CPU/IO Usage

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

Back to Streams Statistics
Back to Top

 

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

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 30,941 0 0 280 224
APPLSYS.WF_DEFERRED_QUEUE_M_R 8,908 0 8,908 168 160
APPLSYS.WF_JAVA_DEFERRED_R 1,558 0 0 17 12
SYS.ALERT_QUE_R 0 0 0 0 0

Back to Streams Statistics
Back to Top

 

 

Resource Limit Stats

No data exists for this section of the report.


Back to Top

 

init.ora Parameters

Parameter Name Begin value End value (if different)
O7_DICTIONARY_ACCESSIBILITY FALSE   
_b_tree_bitmap_plans FALSE   
_fast_full_scan_enabled FALSE   
_like_with_bind_as_equality TRUE   
_sort_elimination_cost_ratio 5   
_sqlexec_progression_cost 2147483647   
_swrf_mmon_dbfus FALSE   
_swrf_mmon_flush FALSE   
_system_trig_enabled TRUE   
aq_tm_processes 1   
background_dump_dest /oracle/visdb/10.2.0/admin/VIS/bdump   
compatible 10.2.0.3   
control_files /oracle/visdata/cntrl01.dbf, /oracle/visdata/cntrl02.dbf, /oracle/visdata/cntrl03.dbf   
core_dump_dest /oracle/visdb/10.2.0/admin/VIS/cdump   
cursor_sharing exact   
cursor_space_for_time FALSE   
db_block_checking false   
db_block_checksum TRUE   
db_block_size 8192   
db_cache_advice off   
db_file_multiblock_read_count 8   
db_files 130   
db_name VIS   
db_writer_processes 3   
dml_locks 10000   
fast_start_mttr_target 180   
filesystemio_options setall   
hpux_sched_noage 178   
java_pool_size 67108864   
job_queue_processes 2   
lock_sga TRUE   
log_buffer 16777216   
log_checkpoint_timeout 1200   
log_checkpoints_to_alert TRUE   
max_dump_file_size unlimited   
nls_comp binary   
nls_date_format DD-MON-RR   
nls_language american   
nls_length_semantics BYTE   
nls_numeric_characters .,   
nls_sort binary   
nls_territory america   
olap_page_pool_size 4194304   
open_cursors 1000   
optimizer_secure_view_merging FALSE   
parallel_max_servers 16   
pga_aggregate_target 21474836480   
plsql_code_type INTERPRETED   
plsql_native_library_dir /oracle/visdb/10.2.0/native   
plsql_native_library_subdir_count 300   
plsql_optimize_level 2   
processes 3900   
remote_login_passwordfile EXCLUSIVE   
replication_dependency_tracking FALSE   
session_cached_cursors 500   
sessions 7800   
sga_target 20401094656   
shared_pool_reserved_size 314572800   
shared_pool_size 3154116608   
timed_statistics TRUE   
trace_enabled FALSE   
undo_management AUTO   
undo_tablespace APPS_UNDOTS1   
user_dump_dest /oracle/visdb/10.2.0/admin/VIS/udump   
utl_file_dir /usr/tmp   
workarea_size_policy AUTO   


Back to Top

End of Report