AWR Report

WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
VIS187584551VIS110.2.0.3.0NOhpdb1

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:115-Feb-08 17:33:372621 201.7
End Snap:215-Feb-08 18:33:432632 241.7
Elapsed:  60.08 (mins)  
DB Time:  385.09 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 18,384M 18,304MStd Block Size: 8K
Shared Pool Size: 2,000M 2,080MLog Buffer: 14,320K

Load Profile

Per SecondPer Transaction
Redo size: 7,943,529.02 38,191.53
Logical reads: 465,426.27 2,237.71
Block changes: 48,587.92 233.60
Physical reads: 111.45 0.54
Physical writes: 771.38 3.71
User calls: 6,765.27 32.53
Parses: 1,476.18 7.10
Hard parses: 1.65 0.01
Sorts: 1,888.60 9.08
Logons: 1.65 0.01
Executes: 18,621.11 89.53
Transactions: 207.99 

% Blocks changed per Read: 10.44Recursive Call %: 81.83
Rollback per transaction %: 16.63Rows per Sort: 13.20

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.95Redo NoWait %: 100.00
Buffer Hit %: 99.98In-memory Sort %: 100.00
Library Hit %: 99.77Soft Parse %: 99.89
Execute to Parse %: 92.07Latch Hit %: 98.45
Parse CPU to Parse Elapsd %: 82.49% Non-Parse CPU: 98.06

Shared Pool Statistics

BeginEnd
Memory Usage %: 80.55 85.90
% SQL with executions>1: 87.02 89.58
% Memory for SQL w/exec>1: 73.57 67.54

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
CPU time  19,163  82.9 
db file sequential read 225,225 1,905 8 8.2User I/O
log file sync 271,997 405 1 1.8Commit
db file scattered read 15,052 396 26 1.7User I/O
enq: RO - fast object reuse 151 363 2,405 1.6Application

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
sql execute elapsed time 20,529.51 88.85
DB CPU 19,162.81 82.94
PL/SQL execution elapsed time 4,186.32 18.12
inbound PL/SQL rpc elapsed time 3,560.49 15.41
Java execution elapsed time 579.79 2.51
parse time elapsed 503.83 2.18
hard parse elapsed time 228.04 0.99
repeated bind elapsed time 57.88 0.25
sequence load elapsed time 14.80 0.06
connection management call elapsed time 8.59 0.04
PL/SQL compilation elapsed time 8.23 0.04
hard parse (sharing criteria) elapsed time 3.61 0.02
hard parse (bind mismatch) elapsed time 0.93 0.00
failed parse elapsed time 0.91 0.00
DB time 23,105.24  
background elapsed time 1,179.35  
background cpu time 413.31  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
User I/O 286,114 0.02 2,602 9 0.38
Application 39,996 0.42 559 14 0.05
Commit 271,997 0.00 405 1 0.36
Network 28,134,141 0.00 351 0 37.52
Concurrency 2,360,002 0.22 328 0 3.15
System I/O 602,985 0.00 284 0 0.80
Other 119,062 38.26 85 1 0.16
Configuration 8,069 0.40 15 2 0.01

Back to Wait Events Statistics
Back to Top

Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
db file sequential read 225,225 0.00 1,905 8 0.30
log file sync 271,997 0.00 405 1 0.36
db file scattered read 15,052 0.00 396 26 0.02
enq: RO - fast object reuse 151 78.81 363 2405 0.00
SQL*Net more data from client 1,291,919 0.00 294 0 1.72
log file parallel write 571,839 0.00 278 0 0.76
read by other session 42,265 0.00 168 4 0.06
buffer busy waits 777,495 0.01 160 0 1.04
local write wait 1,399 4.50 133 95 0.00
enq: UL - contention 2,346 1.45 119 51 0.00
enq: TX - row lock contention 330 4.24 62 189 0.00
cursor: pin S wait on X 5,577 92.43 56 10 0.01
rdbms ipc reply 25 88.00 45 1798 0.00
latch: cache buffers chains 1,520,002 0.00 41 0 2.03
enq: TX - index contention 28,005 0.00 34 1 0.04
SQL*Net message to client 25,548,492 0.00 32 0 34.07
library cache load lock 773 0.00 27 35 0.00
SQL*Net more data to client 1,293,730 0.00 25 0 1.73
PX Deq Credit: send blkd 21,129 0.00 21 1 0.03
enq: HW - contention 3,238 0.00 10 3 0.00
enq: TM - contention 7 28.57 7 1071 0.00
SQL*Net break/reset to client 37,162 0.00 7 0 0.05
control file parallel write 1,829 0.00 6 3 0.00
kksfbc child completion 139 83.45 6 42 0.00
write complete waits 37 86.49 3 89 0.00
os thread startup 78 0.00 3 37 0.00
wait list latch free 237 0.00 3 11 0.00
latch: library cache 5,625 0.00 2 0 0.01
row cache lock 1,075 0.00 2 2 0.00
latch: In memory undo latch 17,199 0.00 2 0 0.02
PX Deq: Signal ACK 210 30.48 1 7 0.00
latch: undo global data 7,303 0.00 1 0 0.01
enq: TX - contention 2,717 0.00 1 0 0.00
latch free 2,537 0.00 1 0 0.00
enq: DV - contention 183 0.00 1 5 0.00
LGWR wait for redo copy 23,022 0.00 1 0 0.03
enq: SQ - contention 4,222 0.00 1 0 0.01
latch: library cache pin 1,659 0.00 1 0 0.00
latch: session allocation 1,314 0.00 1 0 0.00
latch: object queue header operation 7,237 0.00 1 0 0.01
PX qref latch 983 95.93 1 1 0.00
buffer deadlock 45,106 98.43 1 0 0.06
latch: redo allocation 2,057 0.00 1 0 0.00
log file switch completion 40 0.00 0 11 0.00
enq: TX - allocate ITL entry 132 0.00 0 2 0.00
enq: FB - contention 920 0.00 0 0 0.00
control file sequential read 29,305 0.00 0 0 0.04
SGA: allocation forcing component growth 21 66.67 0 10 0.00
latch: row cache objects 508 0.00 0 0 0.00
latch: cache buffers lru chain 427 0.00 0 0 0.00
latch: messages 55 0.00 0 3 0.00
latch: redo writing 400 0.00 0 0 0.00
library cache pin 1,159 0.00 0 0 0.00
latch: shared pool 274 0.00 0 0 0.00
latch: cache buffer handles 214 0.00 0 0 0.00
latch: object queue header heap 166 0.00 0 0 0.00
latch: library cache lock 100 0.00 0 1 0.00
cursor: pin S 2,920 0.00 0 0 0.00
library cache lock 2 0.00 0 17 0.00
cursor: mutex S 201 0.00 0 0 0.00
reliable message 35 0.00 0 0 0.00
latch: enqueue hash chains 28 0.00 0 0 0.00
enq: CU - contention 2 0.00 0 1 0.00
enq: PS - contention 48 0.00 0 0 0.00
direct path read 1,464 0.00 0 0 0.00
latch: parallel query alloc buffer 6 0.00 0 0 0.00
cursor: mutex X 270 0.00 0 0 0.00
log file single write 6 0.00 0 0 0.00
direct path write 665 0.00 0 0 0.00
kkdlgon 3 0.00 0 0 0.00
log file sequential read 6 0.00 0 0 0.00
latch: checkpoint queue latch 18 0.00 0 0 0.00
direct path write temp 38 0.00 0 0 0.00
direct path read temp 6 0.00 0 0 0.00
SQL*Net message from client 25,548,488 0.00 5,052,173 198 34.07
pipe get 16,884 28.71 21,092 1249 0.02
Streams AQ: waiting for messages in the queue 2,390 100.00 11,664 4880 0.00
PX Idle Wait 3,279 76.61 5,167 1576 0.00
Streams AQ: waiting for time management or cleanup tasks 1,772 37.58 3,507 1979 0.00
Streams AQ: qmn slave idle wait 128 0.00 3,500 27346 0.00
Streams AQ: qmn coordinator idle wait 256 50.00 3,500 13673 0.00
PL/SQL lock timer 247 99.19 2,721 11018 0.00
jobq slave wait 616 99.51 1,803 2927 0.00
PX Deq: Execution Msg 11,908 0.00 56 5 0.02
PX Deq: Execute Reply 4,587 0.00 2 1 0.01
PX Deq Credit: need buffer 3,589 0.00 2 1 0.00
PX Deq: Msg Fragment 9,333 0.00 2 0 0.01
PX Deq: Table Q Normal 8,065 0.00 1 0 0.01
PX Deq: Parse Reply 340 0.00 0 1 0.00
PX Deq: Join ACK 240 0.00 0 0 0.00
class slave wait 1 0.00 0 1 0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
log file parallel write 571,838 0.00 278 0 0.76
control file parallel write 1,829 0.00 6 3 0.00
db file sequential read 1,041 0.00 2 2 0.00
os thread startup 62 0.00 2 37 0.00
events in waitclass Other 27,763 0.00 2 0 0.04
db file scattered read 68 0.00 0 3 0.00
latch: redo writing 400 0.00 0 0 0.00
control file sequential read 968 0.00 0 0 0.00
latch: cache buffers chains 34 0.00 0 0 0.00
direct path read 1,464 0.00 0 0 0.00
buffer busy waits 12 0.00 0 0 0.00
log file single write 6 0.00 0 0 0.00
log file sequential read 6 0.00 0 0 0.00
direct path write 555 0.00 0 0 0.00
log file sync 1 0.00 0 1 0.00
latch: shared pool 2 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 917,595 1.12 29,885 33 1.22
pmon timer 1,251 97.28 3,512 2807 0.00
smon timer 72,971 0.00 3,509 48 0.10
Streams AQ: waiting for time management or cleanup tasks 1,772 37.58 3,507 1979 0.00
Streams AQ: qmn slave idle wait 128 0.00 3,500 27346 0.00
Streams AQ: qmn coordinator idle wait 256 50.00 3,500 13673 0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
BUSY_TIME 2,095,131
IDLE_TIME 3,664,295
IOWAIT_TIME 146,130
NICE_TIME 19,424
SYS_TIME 123,525
USER_TIME 1,889,740
LOAD 4
RSRC_MGR_CPU_WAIT_TIME 0
PHYSICAL_MEMORY_BYTES 27,792
NUM_CPUS 16
NUM_CPU_SOCKETS 4

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical ReadsLogical Reads
SYS$USERS 23,101.10 19,159.20 398,669 1,675,585,569
SYS$BACKGROUND 0.00 0.00 3,034 2,165,127
VIS 0.00 0.00 0 0

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

Service NameUser I/O Total WtsUser I/O Wt TimeConcurcy Total WtsConcurcy Wt TimeAdmin Total WtsAdmin Wt TimeNetwork Total WtsNetwork Wt Time
SYS$USERS 282982 259898 2359859 32541 0 0 28120093 35087
SYS$BACKGROUND 3130 254 112 231 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 IdSQL ModuleSQL Text
1,785 1,783 10 178.46 7.72 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
826 826 299 2.76 3.58 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
645 610 16 40.29 2.79 7g05xfvc5vp74 ARTERRPW BEGIN arp_run.revenue_recognit...
462 458 53,349 0.01 2.00 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
446 147 9,999 0.04 1.93 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
418 417 53,334 0.01 1.81 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...
411 4 56 7.34 1.78 9k7t8q4kfcb7y SQL*Plus begin GL.apps_ddl.apps_ddl(:dd...
406 2 8 50.81 1.76 0smgkw5kuqj00 GLLEZL begin ad_ddl.do_ddl(:schema, ...
393 392 53,338 0.01 1.70 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
389 75 1,120 0.35 1.68 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
332 11 1,120 0.30 1.44 3dssuqfjsynrk asn.lead.server.LeadUwqAM SELECT count(1) FROM (SELECT *...
328 306 5,000 0.07 1.42 2fjd6cndjby9p ARTERRPW INSERT INTO RA_CUST_TRX_LINE_G...
314 296 52,308 0.01 1.36 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
313 265 94,752 0.00 1.35 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
297 297 8 37.09 1.28 1nj7kuvxgpwah RAXTRX begin ARP_TAX . SET_DEFAULT_TA...
270 269 44,196 0.01 1.17 auzgm2ap4faw2 JDBC Thin Client (SELECT SUB.GUID SUB_GUID, DE...
263 262 172,413 0.00 1.14 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
245 239 161,219 0.00 1.06 3b3psftuyks81 INVTTMTX BEGIN INV_TXNSTUB_PUB.postTran...
240 181 124,481 0.00 1.04 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
233 102 10,086 0.02 1.01 1q78dwnrrkf6c asn.lead.server.LeadUwqAM BEGIN ASN_SALES_PVT.Lead_Proce...

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 IdSQL ModuleSQL Text
1,783 1,785 10 178.27 7.72 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
826 826 299 2.76 3.58 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
610 645 16 38.10 2.79 7g05xfvc5vp74 ARTERRPW BEGIN arp_run.revenue_recognit...
458 462 53,349 0.01 2.00 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
417 418 53,334 0.01 1.81 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...
392 393 53,338 0.01 1.70 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
306 328 5,000 0.06 1.42 2fjd6cndjby9p ARTERRPW INSERT INTO RA_CUST_TRX_LINE_G...
297 297 8 37.08 1.28 1nj7kuvxgpwah RAXTRX begin ARP_TAX . SET_DEFAULT_TA...
296 314 52,308 0.01 1.36 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
269 270 44,196 0.01 1.17 auzgm2ap4faw2 JDBC Thin Client (SELECT SUB.GUID SUB_GUID, DE...
265 313 94,752 0.00 1.35 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
262 263 172,413 0.00 1.14 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
239 245 161,219 0.00 1.06 3b3psftuyks81 INVTTMTX BEGIN INV_TXNSTUB_PUB.postTran...
181 240 124,481 0.00 1.04 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
147 446 9,999 0.01 1.93 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
102 233 10,086 0.01 1.01 1q78dwnrrkf6c asn.lead.server.LeadUwqAM BEGIN ASN_SALES_PVT.Lead_Proce...
75 389 1,120 0.07 1.68 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
11 332 1,120 0.01 1.44 3dssuqfjsynrk asn.lead.server.LeadUwqAM SELECT count(1) FROM (SELECT *...
4 411 56 0.06 1.78 9k7t8q4kfcb7y SQL*Plus begin GL.apps_ddl.apps_ddl(:dd...
2 406 8 0.23 1.76 0smgkw5kuqj00 GLLEZL begin ad_ddl.do_ddl(:schema, ...

Back to SQL Statistics
Back to Top

SQL ordered by Gets

Buffer Gets Executions Gets per Exec %TotalCPU Time (s)Elapsed Time (s) SQL IdSQL ModuleSQL Text
150,878,984 10 15,087,898.40 8.99 1782.70 1784.65 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
107,328,966 44,196 2,428.48 6.40 268.67 269.70 auzgm2ap4faw2 JDBC Thin Client (SELECT SUB.GUID SUB_GUID, DE...
99,157,718 16 6,197,357.38 5.91 609.67 644.68 7g05xfvc5vp74 ARTERRPW BEGIN arp_run.revenue_recognit...
73,651,467 8 9,206,433.38 4.39 296.62 296.73 1nj7kuvxgpwah RAXTRX begin ARP_TAX . SET_DEFAULT_TA...
50,075,499 153,363 326.52 2.98 188.44 189.09 5kqw5535fjvw6 ARXTWMAI SELECT NVL(RCTT.ATTRIBUTE10, ...
45,664,423 53,349 855.96 2.72 458.17 461.80 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
40,740,264 299 136,255.06 2.43 826.19 826.23 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
39,303,830 11 3,573,075.45 2.34 187.35 188.36 1du9v021t8m46 ARGLTP insert into gl_interface(creat...
36,485,627 5,000 7,297.13 2.17 306.07 328.39 2fjd6cndjby9p ARTERRPW INSERT INTO RA_CUST_TRX_LINE_G...
35,651,731 94,752 376.26 2.12 264.89 312.57 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
34,608,551 124,481 278.02 2.06 181.43 240.40 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
32,279,300 53,338 605.18 1.92 392.29 393.46 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
31,330,523 161,219 194.34 1.87 238.65 244.60 3b3psftuyks81 INVTTMTX BEGIN INV_TXNSTUB_PUB.postTran...
31,321,042 161,208 194.29 1.87 224.11 230.04 gf1u933c95jb5 INVTTMTX DECLARE l_ret_stat varchar2...
26,396,650 9,999 2,639.93 1.57 147.39 445.56 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
25,237,182 11 2,294,289.27 1.50 125.88 125.96 bp8crdjba8zgt ARGLTP update ra_cust_trx_line_gl_dis...
23,549,746 1,234,017 19.08 1.40 126.32 126.82 66tmsr3446uqn ap.oie.server.WebExpensesAM SELECT WIAS.ACTIVITY_STATUS, ...
23,140,818 53,334 433.88 1.38 416.69 417.79 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...
20,363,655 3,368 6,046.22 1.21 121.59 168.68 8jb36w62w5hqf ibuSRDetailsActions.jsp BEGIN IBU_REQ_PKG.UpdateServic...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical ReadsExecutionsReads per Exec %TotalCPU Time (s)Elapsed Time (s) SQL IdSQL ModuleSQL Text
45,240 9,999 4.52 11.26 147.39 445.56 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
40,661 1,120 36.30 10.12 10.53 331.92 3dssuqfjsynrk asn.lead.server.LeadUwqAM SELECT count(1) FROM (SELECT *...
29,930 1,120 26.72 7.45 74.51 388.97 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
16,224 10,086 1.61 4.04 102.48 232.93 1q78dwnrrkf6c asn.lead.server.LeadUwqAM BEGIN ASN_SALES_PVT.Lead_Proce...
10,288 124,481 0.08 2.56 181.43 240.40 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
8,127 3,368 2.41 2.02 121.59 168.68 8jb36w62w5hqf ibuSRDetailsActions.jsp BEGIN IBU_REQ_PKG.UpdateServic...
8,089 94,752 0.09 2.01 264.89 312.57 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
4,600 10,000 0.46 1.14 183.18 214.85 csvvv0fmhr1yc PYUSLV BEGIN FFP1893_01010001.FORMULA...
4,510 10,000 0.45 1.12 152.28 180.31 63t8zpm02skgh PYUSLV SELECT DECODE(COUNT(PRR.RUN_RE...
670 9,942 0.07 0.17 131.89 141.22 4ds53shhfcynn PYUSLV declare begin hr_pre_pay....

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows ProcessedRows per ExecCPU per Exec (s)Elap per Exec (s) SQL IdSQL ModuleSQL Text
1,234,017 639,979 0.52 0.00 0.00 66tmsr3446uqn ap.oie.server.WebExpensesAM SELECT WIAS.ACTIVITY_STATUS, ...
708,213 708,147 1.00 0.00 0.00 cd9mbmqyf4qhp ap.oie.server.WebExpensesAM UPDATE WF_ITEM_ACTIVITY_STATUS...
282,568 282,562 1.00 0.00 0.00 avc1jqzz04wpr JDBC Thin Client SELECT 'x' FROM DUAL
194,356 155,670 0.80 0.00 0.00 fmfdkztk8vx23   SELECT CATEGORY, SEVERITY, F...
172,413 172,406 1.00 0.00 0.00 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
161,220 161,206 1.00 0.00 0.00 6gnth2mfbs2nq INVTTMTX declare v_ret number := 0...
161,219 161,205 1.00 0.00 0.00 3b3psftuyks81 INVTTMTX BEGIN INV_TXNSTUB_PUB.postTran...
161,208 161,206 1.00 0.00 0.00 gf1u933c95jb5 INVTTMTX DECLARE l_ret_stat varchar2...
153,363 153,356 1.00 0.00 0.00 5kqw5535fjvw6 ARXTWMAI SELECT NVL(RCTT.ATTRIBUTE10, ...
138,366 2,352,126 17.00 0.00 0.00 cwyx16zn1hpfb JDBC Thin Client select parameter, value from ...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
282,566 282,568 5.31 avc1jqzz04wpr JDBC Thin Client SELECT 'x' FROM DUAL
194,355 194,356 3.65 fmfdkztk8vx23   SELECT CATEGORY, SEVERITY, F...
172,415 172,413 3.24 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
161,010 161,220 3.03 6gnth2mfbs2nq INVTTMTX declare v_ret number := 0...
138,365 138,366 2.60 cwyx16zn1hpfb JDBC Thin Client select parameter, value from ...
111,595 111,764 2.10 fb13x9qx0ftks OEXOETEL begin OE_STANDARD_WF.OEOL_SELE...
107,802 107,867 2.03 1c0b7sas42w2z INVTTMTX SELECT NVL(ITEM_COST, 0), ...
94,750 94,752 1.78 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
79,231 79,279 1.49 76sw2a4vnc89j icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.S...
76,464 76,471 1.44 608c0n36kaw62 icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.C...
76,453 79,275 1.44 dcvv68fju01g4 icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.E...
76,452 76,461 1.44 bf7uwg5pa3pj6 icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.V...
69,997 69,993 1.32 97mt0g20bcfc3 PYUSLV begin ...
59,103 59,199 1.11 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
56,208 56,209 1.06 162ttnv4ubqun OEXOETEL begin OE_DS_PVT.Check_PO_Appr...
54,176 54,196 1.02 gdnwgx9fcxggr OEXOETEL begin OE_SHIPPING_WF.START_SHI...
54,174 54,195 1.02 7mrs575bj7a41 OEXOETEL begin OE_OEOL_SCH.BRANCH_ON_SO...
54,163 54,209 1.02 fvcbstf9s6a5r OEXOETEL begin WF_STANDARD.WAITFORFLOW ...
54,160 54,190 1.02 bfbyqwbr4vwms OEXOETEL begin OE_OEOL_SCH.SCHEDULE_LIN...
53,395 53,395 1.00 fr38pcatsbj6x INCTCW SELECT reservation_...
53,323 53,338 1.00 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
53,322 53,355 1.00 cw171rvngr1w9 WSHINTERFACE begin OE_FLEX_COGS_PUB.GET_COS...
53,319 53,359 1.00 d0a8mm8y38yaw WSHFRREL SELECT base.revision ...
53,290 53,334 1.00 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...
53,243 53,334 1.00 gnng1rmpjxzsx WSHINTERFACE begin OE_CLOSE_WF.CLOSE_LINE (...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModuleSQL Text
10,103,127 7 0.46 5d5cajabcjp4v RAXMTR select /*+ parallel(t, 16) par...

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 IdSQL Text
0smgkw5kuqj00begin ad_ddl.do_ddl(:schema, :tappl, ad_ddl.truncate_table , :stmnt, :obj); end;
0z318y6g3uagcdeclare l_retstat varchar2 ( 3 ) ; l_msg_data varchar2 ( 244 ) ; l_msg_cnt number ; l_trx_cnt number ; BEGIN :retval := INV_TXN_MANAGER_PUB . process_Transactions ( p_api_version => 1.0 , p_commit => fnd_api . g_true , x_return_status => l_retstat , x_msg_count => l_msg_cnt , x_msg_data => l_msg_data , x_trans_count => l_trx_cnt , p_table => 1 , p_header_id => :header_id ) ; END ;
162ttnv4ubqun begin OE_DS_PVT.Check_PO_Approved( :t_application_id, :t_entity_short_name, :t_validation_entity_short_name, :t_validation_tmplt_short_name, :t_record_set_short_name, :t_scope, :t_result ); end;
1c0b7sas42w2z SELECT NVL(ITEM_COST, 0), COST_UPDATE_ID FROM CST_ITEM_COSTS WHERE INVENTORY_ITEM_ID = :1 AND ORGANIZATION_ID = :2 AND COST_TYPE_ID = :3
1du9v021t8m46 insert into gl_interface(created_by, date_created, status, actual_flag, group_id, set_of_books_id, user_je_source_name, user_je_category_name, accounting_date, subledger_doc_sequence_id, subledger_doc_sequence_value, ussgl_transaction_code, currency_code, code_combination_id, entered_dr, entered_cr, accounted_dr, accounted_cr, reference1, reference10, reference21, reference22, reference23, reference24, reference25, reference26, reference27, reference28, reference29, reference30, request_id)select /*+ ORDERED USE_NL (l ctlgd ct ctt cust) INDEX (ctlgd, RA_CUST_TRX_LINE_GL_DIST_N5) +*/ :b0 created_by , trunc(sysdate ) date_created , :b1 status , :b2 actual_flag , :b3 group_id , :b4 sob_id , :b5 source_name , decode(ctt.type, 'CM', :b6, 'DM', :b7, 'CB', :b8, :b9) category , ctlgd.gl_date gl_date , ct.doc_sequence_id doc_seqid , ct.doc_sequence_value doc_num , ctlgd.ussgl_transaction_code ussgl , ct.invoice_currency_code currency , ctlgd.code_combination_id ccid , decode(ctlgd.account_class, 'REC', decode(sign(nvl(ctlgd.amount, 0)), (-1), null , nvl(ctlgd.amount, 0)), 'ROUND', decode(sign(nvl(ctlgd.acctd_amount, 0)), (-1), (-nvl(ctlgd.amount, 0)), null ), decode(sign(nvl(ctlgd.amount, 0)), (-1), (-nvl(ctlgd.amount, 0)), null )) entered_dr , decode(ctlgd.account_class, 'REC', decode(sign(nvl(ctlgd.amount, 0)), (-1), (-nvl(ctlgd.amount, 0)), null ), 'ROUND', decode(sign(nvl(ctlgd.acctd_amount, 0)), (-1), null , nvl(ctlgd.amount, 0)), decode(sign(nvl(ctlgd.amount , 0)), (-1), null , nvl(ctlgd.amount, 0))) entered_cr , decode(ctlgd.account_class, 'REC', decode(sign(nvl(ctlgd.amount, 0)), (-1), null , nvl(ctlgd.acctd_amount, 0)), 'ROUND', decode(sign(nvl(ctlgd.acctd_amount, 0)), (-1), (-nvl(ctlgd.acctd_amount, 0)), null ), decode(sign(nvl(ctlgd.amount, 0)), (-1), (-nvl(ctlgd.acctd_amount, 0)), null )) acctd_dr , decode(ctlgd.account_class, 'REC', decode(sign(nvl(ctlgd.amount, 0)), (-1), (-nvl(ctlgd.acctd_amount, 0)), null ), 'ROUND', decode(sign(nvl(ctlgd.acctd_amount, 0)), (-1), null , nvl(ctlgd.acctd_amount, 0)), decode(sign(nvl(ctlgd.amount, 0)), (-1), null , nvl(ctlgd.acctd_amount, 0))) acctd_cr , (:b10||to_char(:b3)) ref1 , decode(:b12, 'Y', null , ((((((l.meaning||' ')||:b13)||decode(ctt.type, 'CB', :b14, 'CM', :b15, 'DEP', :b16, 'DM', :b17, 'GUAR', :b18, 'INV', :b19, null ))||' ')||ct.trx_number)||:b20)) ref10 , to_char(:b3) ref21 , to_char(ct.customer_trx_id) ref22 , to_char(ctlgd.cust_trx_line_gl_dist_id) ref23 , ct.trx_number ref24 , cust.account_number ref25 , 'CUSTOMER' ref26 , to_char(ct.bill_to_customer_id) ref27 , decode(ctt.type, 'CM', 'CM', 'DM', 'DM', 'CB', 'CB', 'INV') ref28 , (decode(ctt.type, 'CM', 'CM_', 'DM', 'DM_', 'CB', 'CB_', 'INV_')||ctlgd.account_class) ref29 , 'RA_CUST_TRX_LINE_GL_DIST' ref30 , :b22 from ra_cust_trx_line_gl_dist ctlgd , ra_cust_trx_line_gl_dist rec , ar_lookups l , ra_customer_trx ct , ra_cust_trx_types ctt , hz_cust_accounts cust where ((((((((((((((((ctlgd.cust_trx_line_gl_dist_id+0)<: b23 and ctlgd.gl_date between to_date((:b24||' 00:00:00'), 'DD-MON-RR HH24:MI:SS') and to_date((:b25||' 23:59:59'), 'DD-MON-RR HH24:MI:SS')) and ctlgd.posting_control_id=(-3)) and ctlgd.set_of_books_id=:b4) and ctlgd.account_set_flag='N') and ctlgd.customer_trx_id=ct.customer_trx_id) and l.lookup_type='AUTOGL_TYPE') and l.lookup_code=nvl(ctlgd.account_class, 'REV')) and ct.complete_flag='Y') and ct.bill_to_customer_id=cust.cust_account_id) and ct.cust_trx_type_id=ctt.cust_trx_type_id) and ctlgd.customer_trx_id=rec.customer_trx_id) and rec.account_class='REC') and rec.latest_rec_flag='Y') and rec.account_set_flag='N') and 'NOT_MFAR_TYPE'=AR_MFAR_PKG.ar_mfar_trx_post(ctlgd.customer_trx_id, :b0, :b1, :b2, :b3, :b4, :b5, :b6, :b7, :b8, :b9, :b10, :b12, :b13, :b20, :b14, :b15, :b17, :b16, :b18, :b19, :b24, :b25, :b23))
1nj7kuvxgpwahbegin ARP_TAX . SET_DEFAULT_TAX_CODE ( :setSql , :updSql ) ; END ;
1q78dwnrrkf6cBEGIN 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;
25wzrzwd46a44SELECT 1 FROM DUAL WHERE EXISTS ( SELECT 1 FROM FND_GRANTS G, WF_USER_ROLES R WHERE G.GRANTEE_KEY = R.ROLE_NAME AND R.USER_NAME IN (SELECT INCRNS.NAME FROM WF_LOCAL_ROLES SRC , WF_LOCAL_ROLES INCRNS WHERE SRC.NAME = :B4 AND SRC.PARENT_ORIG_SYSTEM = INCRNS.PARENT_ORIG_SYSTEM AND SRC.PARENT_ORIG_SYSTEM_ID = INCRNS.PARENT_ORIG_SYSTEM_ID) AND G.OBJECT_ID = :B3 AND ((:B2 = -1) OR (G.MENU_ID IN (SELECT CMF.MENU_ID FROM FND_COMPILED_MENU_FUNCTIONS CMF WHERE CMF.FUNCTION_ID = :B2 ))) AND ( G.CTX_SECGRP_ID = -1 OR G.CTX_SECGRP_ID = SYS_CONTEXT('FND', 'SECURITY_GROUP_ID')) AND ( G.CTX_RESP_ID = -1 OR G.CTX_RESP_ID = SYS_CONTEXT('FND', 'RESP_ID')) AND ( G.CTX_RESP_APPL_ID = -1 OR G.CTX_RESP_APPL_ID = SYS_CONTEXT('FND', 'RESP_APPL_ID')) AND ( G.CTX_ORG_ID = -1 OR G.CTX_ORG_ID = SYS_CONTEXT('FND', 'ORG_ID')) AND G.START_DATE <= SYSDATE AND ( G.END_DATE IS NULL OR G.END_DATE >= SYSDATE ) AND G.INSTANCE_TYPE = :B1 )
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 )
3b3psftuyks81BEGIN INV_TXNSTUB_PUB.postTransaction(:1, :2, :3); END;
3dssuqfjsynrk SELECT count(1) FROM (SELECT * FROM ( SELECT LeadEO.sales_lead_id as SalesLeadId , to_char(hz_timezone_pub.convert_datetime(:1, hcp.timezone_id, SYSDATE), 'HH:MI AM ') ||' '||ht.standard_time_short_code as PrimaryContactLocalTime , SUBSTRB(LeadEO.description, 1, 240) as Description , hp.party_name as ContactName , custParty.party_name as CustomerName , aslt.meaning as RankName , ast.meaning as LeadStatus , ROUND(SYSDATE - LeadEO.creation_date) as Age , DECODE(LeadEO.status_code, 'CONVERTED_TO_OPPORTUNITY', 'ASNCnvToOpptyDsbld', 'ASNCnvToOpptyEnbld') as ASNLeadLstCnvToOppty , LeadEO.customer_id , hp.party_id , LeadEO.primary_contact_party_id , hr.relationship_id FROM as_sales_leads LeadEO , ( SELECT /*+ no_merge */ distinct aaa.sales_lead_id, aaa.customer_id FROM as_accesses_all aaa WHERE aaa.sales_lead_id IS NOT NULL AND aaa.lead_id IS NULL AND aaa.salesforce_id = :2) secu , as_statuses_tl ast , as_sales_lead_ranks_tl aslt , hz_parties CustParty , hz_parties hp, hz_relationships hr , hz_contact_points hcp , hz_timezones ht , ams_source_codes amsc WHERE LeadEO.sales_lead_id = secu.sales_lead_id AND LeadEO.customer_id = secu.customer_id AND LeadEO.status_code = ast.status_code AND ast.language = USERENV('LANG') AND LeadEO.lead_rank_id = aslt.rank_id (+) AND aslt.language (+) = USERENV('LANG') AND LeadEO.customer_id = CustParty.party_id AND LeadEO.primary_contact_party_id = hr.party_id(+) AND hr.subject_ id = hp.party_id (+) AND hr.subject_table_name (+) = 'HZ_PARTIES' AND hr.object_id(+) = LeadEO.customer_id AND hr.object_table_name (+) = 'HZ_PARTIES' AND LeadEO.primary_contact_party_id = hcp.owner_table_id(+) AND hcp.owner_table_name (+) = 'HZ_PARTIES' AND hcp.primary_flag (+) = 'Y' AND hcp.contact_point_type (+) = 'PHONE' AND hcp.timezone_id = ht.timezone_id (+) AND LeadEO.source_promotion_id = amsc.source_code_id AND amsc.source_code_for_id = :3 AND LeadEO.status_code = :4 ORDER BY age ) )
4ds53shhfcynndeclare begin hr_pre_pay.do_prepayment(:p1, :p2, :p3, :p4, :5, :p6:p6ind, :p7); end;
4yak7x2zqz0dhBEGIN inv_transfer_order_pvt.finalize_pick_confirm(:1, :2, :3, :4, :5, :6, :7); END;
5d5cajabcjp4v select /*+ parallel(t, 16) parallel_index(t, 16) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*), 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("HEADER_GDF_ATTRIBUTE12", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb ("HEADER_GDF_ATTRIBUTE12", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE13"), count(distinct "HEADER_GDF_ATTRIBUTE13"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE13")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE13", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE13", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE14"), count(distinct "HEADER_GDF_ATTRIBUTE14"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE14")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE14", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE14", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE15"), count(distinct "HEADER_GDF_ATTRIBUTE15"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE15")), substrb(dump(min(substrb("HEADER_GDF_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_ATTRI BUTE18"), 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_ATTRIBUTE23"), count(distinct "HEADER_GDF_ATTRIBUTE23"), sum(sys_op_opnsize("HEADER_G DF_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)), 1 6, 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_ATTRIBUTE2", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE3"), count(disti nct "LINE_GDF_ATTRIBUTE3"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE3")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE3", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE3", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE4"), count(distinct "LINE_GDF_ATTRIBUTE4"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE4")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE4", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE4", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE5"), count(distinct "LINE_GDF_ATTRIBUTE5"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE5")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE5", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE5", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE6"), count(distinct "LINE_GDF_ATTRIBUTE6"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE6")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE7"), count(distinct "LINE_GDF_ATTRIBUTE7"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE7")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE7", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("LINE_GDF_ATTRIBUTE7", 1, 32)), 16, 0, 32), 1, 120), count("LINE_GDF_ATTRIBUTE8"), count(distinct "LINE_GDF_ATTRIBUTE8"), sum(sys_op_opnsize("LINE_GDF_ATTRIBUTE8")), substrb(dump(min(substrb("LINE_GDF_ATTRIBUTE8", 1, 32)), 16, 0, 32), 1, 120), subst rb(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_ATTRIB UTE14"), 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")), substrb(dump(min("CONTRACT_LINE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("CONTRA CT_LINE_ID"), 16, 0, 32), 1, 120), count("CONTRACT_ID"), count(distinct "CONTRACT_ID"), sum(sys_op_opnsize("CONTRACT_ID")), substrb(dump(min("CONTRACT_ID"), 16, 0, 32), 1, 120), substrb(dump(max("CONTRACT_ID"), 16, 0, 32), 1, 120), count("SOURCE_DATA_KEY1"), count(distinct "SOURCE_DATA_KEY1"), sum(sys_op_opnsize("SOURCE_DATA_KEY1")), substrb(dump(min(substrb("SOURCE_DATA_KEY1", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("SOURCE_DATA_KEY1", 1, 32)), 16, 0, 32), 1, 120), count("SOURCE_DATA_KEY2"), count(distinct "SOURCE_DATA_KEY2"), sum(sys_op_opnsize("SOURCE_DATA_KEY2")), substrb(dump(min(substrb("SOURCE_DATA_KEY2", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("SOURCE_DATA_KEY2", 1, 32)), 16, 0, 32), 1, 120), count("SOURCE_DATA_KEY3"), count(distinct "SOURCE_DATA_KEY3"), sum(sys_op_opnsize("SOURCE_DATA_KEY3")), substrb(dump(min(substrb("SOURCE_DATA_KEY3", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("SOURCE_DATA_KEY3", 1, 32)), 16, 0, 32), 1, 120), count("SOURCE_DATA_KEY4"), count(distinct "SOURCE_DATA_KEY4"), sum(sys_op_opnsize("SOURCE_DATA_KEY4")), substrb(dump(min(substrb("SOURCE_DATA_KEY4", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("SOURCE_DATA_KEY4", 1, 32)), 16, 0, 32), 1, 120), count("SOURCE_DATA_KEY5"), count(distinct "SOURCE_DATA_KEY5"), sum(sys_op_opnsize("SOURCE_DATA_KEY5")), substrb(dump(min(substrb("SOURCE_DATA_KEY5", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("SOURCE_DATA_KEY5", 1, 32)), 16, 0, 32), 1, 120) , count("INVOICED_LINE_ACCTG_LEVEL"), count(distinct "INVOICED_LINE_ACCTG_LEVEL"), sum(sys_op_opnsize("INVOICED_LINE_ACCTG_LEVEL")), substrb(dump(min("INVOICED_LINE_ACCTG_LEVEL"), 16, 0, 32), 1, 120), substrb(dump(max("INVOICED_LINE_ACCTG_LEVEL"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT11"), count(distinct "TERRITORY_SEGMENT11"), sum(sys_op_opnsize("TERRITORY_SEGMENT11")), substrb(dump(min("TERRITORY_SEGMENT11"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT11"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT12"), count(distinct "TERRITORY_SEGMENT12"), sum(sys_op_opnsize("TERRITORY_SEGMENT12")), substrb(dump(min("TERRITORY_SEGMENT12"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT12"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT13"), count(distinct "TERRITORY_SEGMENT13"), sum(sys_op_opnsize("TERRITORY_SEGMENT13")), substrb(dump(min("TERRITORY_SEGMENT13"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT13"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT14"), count(distinct "TERRITORY_SEGMENT14"), sum(sys_op_opnsize("TERRITORY_SEGMENT14")), substrb(dump(min("TERRITORY_SEGMENT14"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT14"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT15"), count(distinct "TERRITORY_SEGMENT15"), sum(sys_op_opnsize("TERRITORY_SEGMENT15")), substrb(dump(min("TERRITORY_SEGMENT15"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT15"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT16"), count(distinct " TERRITORY_SEGMENT16"), sum(sys_op_opnsize("TERRITORY_SEGMENT16")), substrb(dump(min("TERRITORY_SEGMENT16"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT16"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT17"), count(distinct "TERRITORY_SEGMENT17"), sum(sys_op_opnsize("TERRITORY_SEGMENT17")), substrb(dump(min("TERRITORY_SEGMENT17"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT17"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT18"), count(distinct "TERRITORY_SEGMENT18"), sum(sys_op_opnsize("TERRITORY_SEGMENT18")), substrb(dump(min("TERRITORY_SEGMENT18"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT18"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT19"), count(distinct "TERRITORY_SEGMENT19"), sum(sys_op_opnsize("TERRITORY_SEGMENT19")), substrb(dump(min("TERRITORY_SEGMENT19"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT19"), 16, 0, 32), 1, 120), count("TERRITORY_SEGMENT20"), count(distinct "TERRITORY_SEGMENT20"), sum(sys_op_opnsize("TERRITORY_SEGMENT20")), substrb(dump(min("TERRITORY_SEGMENT20"), 16, 0, 32), 1, 120), substrb(dump(max("TERRITORY_SEGMENT20"), 16, 0, 32), 1, 120), count("ATTRIBUTE_CATEGORY"), count(distinct "ATTRIBUTE_CATEGORY"), sum(sys_op_opnsize("ATTRIBUTE_CATEGORY")), substrb(dump(min("ATTRIBUTE_CATEGORY"), 16, 0, 32), 1, 120), substrb(dump(max("ATTRIBUTE_CATEGORY"), 16, 0, 32), 1, 120), count("ATTRIBUTE1"), count(distinct "ATTRIBUTE1"), sum(sys_op_opnsize("ATTRIBUTE1")), substrb(dump(min(substrb("ATTRIBUTE1", 1, 3 2)), 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(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("HEADE R_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), 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")), substrb(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_opnsiz e("CUSTOMER_BANK_ACCOUNT_ID")), substrb(dump(min("CUSTOMER_BANK_ACCOUNT_ID"), 16, 0, 32), 1, 120), substrb(dump(max("CUSTOMER_BANK_ACCOUNT_ID"), 16, 0, 32), 1, 120), count("CUSTOMER_BANK_ACCOUNT_NAME"), count(distinct "CUSTOMER_BANK_ACCOUNT_NAME"), sum(sys_op_opnsize("CUSTOMER_BANK_ACCOUNT_NAME")), substrb(dump(min(substrb("CUSTOMER_BANK_ACCOUNT_NAME", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("CUSTOMER_BANK_ACCOUNT_NAME", 1, 32)), 16, 0, 32), 1, 120), count("UOM_CODE"), count(distinct "UOM_CODE"), sum(sys_op_opnsize("UOM_CODE")), substrb(dump(min("UOM_CODE"), 16, 0, 32), 1, 120), substrb(dump(max("UOM_CODE"), 16, 0, 32), 1, 120), count("UOM_NAME"), count(distinct "UOM_NAME"), sum(sys_op_opnsize("UOM_NAME")), substrb(dump(min("UOM_NAME"), 16, 0, 32), 1, 120), substrb(dump(max("UOM_NAME"), 16, 0, 32), 1, 120), count("DOCUMENT_NUMBER_SEQUENCE_ID"), count(distinct "DOCUMENT_NUMBER_SEQUENCE_ID"), sum(sys_op_opnsize("DOCUMENT_NUMBER_SEQUENCE_ID")), substrb(dump(min("DOCUMENT_NUMBER_SEQUENCE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("DOCUMENT_NUMBER_SEQUENCE_ID"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE10"), count(distinct "LINK_TO_LINE_ATTRIBUTE10"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE10")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE10"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE10"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE11"), count(distinct "LINK_TO_LINE_ATTRIBUTE11"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE11")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE11"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE11"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE12"), count(distinct "LINK_TO_LINE_ATTRIBUTE12"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE12")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE12"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE12"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE13"), count(distinct "LINK_TO_LINE_ATTRIBUTE13"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE13")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE13"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE13"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE14"), count(distinct "LINK_TO_LINE_ATTRIBUTE14"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE14")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE14"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE14"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE15"), count(distinct "LINK_TO_LINE_ATTRIBUTE15"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE15")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE15"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE15"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE8"), count(distinct "LINK_TO_LINE_ATTRIBUTE8"), sum(sys_op_opnsize("LINK_TO_LINE_ATTRIBUTE8")), substrb(dump(min("LINK_TO_LINE_ATTRIBUTE8"), 16, 0, 32), 1, 120), substrb(dump(max("LINK_TO_LINE_ATTRIBUTE8"), 16, 0, 32), 1, 120), count("LINK_TO_LINE_ATTRIBUTE9"), count(distinct "LINK_TO_LI NE_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("REFERENCE_LINE_ATTRIBUTE14"), count(distinct "REFERENCE_LINE_ATTRIBUTE14"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE14")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE14"), 16, 0, 32), 1, 120), substrb(dump (max("REFERENCE_LINE_ATTRIBUTE14"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE15"), count(distinct "REFERENCE_LINE_ATTRIBUTE15"), sum(sys_op_opnsize("REFERENCE_LINE_ATTRIBUTE15")), substrb(dump(min("REFERENCE_LINE_ATTRIBUTE15"), 16, 0, 32), 1, 120), substrb(dump(max("REFERENCE_LINE_ATTRIBUTE15"), 16, 0, 32), 1, 120), count("REFERENCE_LINE_ATTRIBUTE8"), count(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_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_op_opnsize("REASON_CODE_MEANING")), substrb(dump(min(substrb("REASON_CODE_MEANING", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("REASON_CODE_MEANING", 1, 32)), 16, 0, 32), 1, 120), count("LAST_PERIOD_TO_CREDIT"), count(distinct "LAST_PERIOD_TO_CREDIT"), sum(sys_op_opnsize("LAST_PERIOD_TO_CREDIT")), substrb(dump(min("LAST_PERIOD_TO_CREDIT"), 16, 0, 32), 1, 120), substrb(dump(max("LAST_PERIOD_TO_CREDIT"), 16, 0, 32), 1, 120), count("PAYING_CUSTOMER_ID"), count(distinct "PAYING_CUSTOMER_ID"), sum(sys_op_opnsize("PAYING_CUSTOMER_ID")), substrb(dump(min("PAYING_CUSTOMER_ID"), 16, 0, 32), 1, 120), substrb(dump(max("PAYING_CUSTOMER_ID"), 16, 0, 32), 1, 120), count("PAYING_SITE_USE_ID"), count(distinct "PAYING_SITE_USE_ID"), sum(sys_op_opnsize("PAYING_SITE_USE_ID")), substrb(dump(min("PAYING_SITE_USE_ID"), 16, 0, 32), 1, 120), substrb(dump(max("PAYING_SITE_USE_ID"), 16, 0, 32), 1, 120), count("TAX_EXEMPT_FLAG"), count(distinct "TAX_EXEMPT_FLAG"), sum(sys_op_opnsize("TAX_EXEMPT_FLAG")), substrb(dump(min("TAX_EXEMPT_FLAG"), 16, 0, 32), 1, 120), substrb(dump(max("TAX_EXEMPT_FLAG"), 16, 0, 32), 1, 120), count("TAX_EXEMPT_REASON_CODE"), count(distinct "TAX_EXEMPT_REASON_CODE"), sum(sys_op_opnsize("TAX_EXEMPT_REASON_CODE")), substrb(dump(min("TAX_EXEMPT_REASON_CODE"), 16, 0, 32), 1, 120), substrb(dump(max("TAX_EXEMPT_REASON_CODE"), 16, 0, 32), 1, 120), count("TAX_EXEMPT_REASON_CODE_MEANING"), count(distinct "TAX_EXEMPT_REASON_CODE_MEANING"), sum(sy s_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_UPDA TE_LOGIN"), sum(sys_op_opnsize("LAST_UPDATE_LOGIN")), substrb(dump(min("LAST_UPDATE_LOGIN"), 16, 0, 32), 1, 120), substrb(dump(max("LAST_UPDATE_LOGIN"), 16, 0, 32), 1, 120), count("LOCATION_SEGMENT_ID"), count(distinct "LOCATION_SEGMENT_ID"), sum(sys_op_opnsize("LOCATION_SEGMENT_ID")), substrb(dump(min("LOCATION_SEGMENT_ID"), 16, 0, 32), 1, 120), substrb(dump(max("LOCATION_SEGMENT_ID"), 16, 0, 32), 1, 120), count("MOVEMENT_ID"), count(distinct "MOVEMENT_ID"), sum(sys_op_opnsize("MOVEMENT_ID")), substrb(dump(min("MOVEMENT_ID"), 16, 0, 32), 1, 120), substrb(dump(max("MOVEMENT_ID"), 16, 0, 32), 1, 120), count("ORG_ID"), count(distinct "ORG_ID"), sum(sys_op_opnsize("ORG_ID")), substrb(dump(min("ORG_ID"), 16, 0, 32), 1, 120), substrb(dump(max("ORG_ID"), 16, 0, 32), 1, 120), count("AMOUNT_INCLUDES_TAX_FLAG"), count(distinct "AMOUNT_INCLUDES_TAX_FLAG"), sum(sys_op_opnsize("AMOUNT_INCLUDES_TAX_FLAG")), substrb(dump(min("AMOUNT_INCLUDES_TAX_FLAG"), 16, 0, 32), 1, 120), substrb(dump(max("AMOUNT_INCLUDES_TAX_FLAG"), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTR_CATEGORY"), count(distinct "HEADER_GDF_ATTR_CATEGORY"), sum(sys_op_opnsize("HEADER_GDF_ATTR_CATEGORY")), substrb(dump(min("HEADER_GDF_ATTR_CATEGORY"), 16, 0, 32), 1, 120), substrb(dump(max("HEADER_GDF_ATTR_CATEGORY"), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE1"), count(distinct "HEADER_GDF_ATTRIBUTE1"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE1")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE1", 1, 32)), 16, 0, 32), 1, 120 ), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE1", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE2"), count(distinct "HEADER_GDF_ATTRIBUTE2"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE2")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE2", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE2", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE3"), count(distinct "HEADER_GDF_ATTRIBUTE3"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE3")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE3", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE3", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE4"), count(distinct "HEADER_GDF_ATTRIBUTE4"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE4")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE4", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE4", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE5"), count(distinct "HEADER_GDF_ATTRIBUTE5"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE5")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE5", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE5", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTRIBUTE6"), count(distinct "HEADER_GDF_ATTRIBUTE6"), sum(sys_op_opnsize("HEADER_GDF_ATTRIBUTE6")), substrb(dump(min(substrb("HEADER_GDF_ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("HEADER_GDF_ATTRIBUTE6", 1, 32)), 16, 0, 32), 1, 120), count("HEADER_GDF_ATTR IBUTE7"), 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("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) from "AR"."RA_INTERFACE_LINES_ALL" sample ( 10.0000000000) t
5kqw5535fjvw6SELECT NVL(RCTT.ATTRIBUTE10, ' ') FROM RA_CUST_TRX_TYPES_ALL RCTT, RA_CUSTOMER_TRX_ALL RCT WHERE RCT.CUSTOMER_TRX_ID = :B1 AND RCT.CUST_TRX_TYPE_ID = RCTT.CUST_TRX_TYPE_ID
608c0n36kaw62begin FND_FLEX_WORKFLOW_APIS.COPY_FROM_COMBINATION (:v1, :v2, :v3, :v4, :v5); end;
63t8zpm02skghSELECT DECODE(COUNT(PRR.RUN_RESULT_ID), 0, 'N', 'Y') FROM PAY_RUN_RESULTS PRR, PAY_ASSIGNMENT_ACTIONS ASA, PAY_PAYROLL_ACTIONS PPA WHERE PRR.SOURCE_ID = :B3 AND PRR.SOURCE_TYPE IN ('E', 'I') AND PRR.STATUS IN ('P', 'PA', 'R', 'O') AND ASA.ASSIGNMENT_ACTION_ID = PRR.ASSIGNMENT_ACTION_ID AND PPA.PAYROLL_ACTION_ID = ASA.PAYROLL_ACTION_ID AND NOT EXISTS (SELECT NULL FROM PAY_RUN_RESULTS PRR2 WHERE PRR2.SOURCE_ID = PRR.RUN_RESULT_ID AND PRR2.SOURCE_TYPE IN ('R', 'V')) AND PPA.DATE_EARNED BETWEEN :B2 AND :B1
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
66tmsr3446uqnSELECT 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
6gnth2mfbs2nq declare v_ret number := 0; begin if (INV_TABLE_LOCK_PVT.lock_onhand_records(:1, :2, :3, :4, :5, :6, :7) ) then v_ret := 1; end if; :8 := v_ret; end;
6h2tpcxpymqu7BEGIN :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;
76sw2a4vnc89jbegin FND_FLEX_WORKFLOW_APIS.START_GENERATION (:v1, :v2, :v3, :v4, :v5); end;
7g05xfvc5vp74BEGIN arp_run.revenue_recognition( :errbuf, :rc, :A0, :A1, :A2); END;
7mrs575bj7a41begin OE_OEOL_SCH.BRANCH_ON_SOURCE_TYPE (:v1, :v2, :v3, :v4, :v5); end;
827gtfny5uagbbegin :con := FND_GENERIC_POLICY.GET_PREDICATE(:sn, :on); end;
8c8cf4vtv4tx2 SELECT * FROM ( SELECT LeadEO.sales_lead_id as SalesLeadId , to_char(hz_timezone_pub.convert_datetime(:1, hcp.timezone_id, SYSDATE), 'HH:MI AM ') ||' '||ht.standard_time_short_code as PrimaryContactLocalTime , SUBSTRB(LeadEO.description, 1, 240) as Description , hp.party_name as ContactName , custParty.party_name as CustomerName , aslt.meaning as RankName , ast.meaning as LeadStatus , ROUND(SYSDATE - LeadEO.creation_date) as Age , DECODE(LeadEO.status_code, 'CONVERTED_TO_OPPORTUNITY', 'ASNCnvToOpptyDsbld', 'ASNCnvToOpptyEnbld') as ASNLeadLstCnvToOppty , LeadEO.customer_id , hp.party_id , LeadEO.primary_contact_party_id , hr.relationship_id FROM as_sales_leads LeadEO , ( SELECT /*+ no_merge */ distinct aaa.sales_lead_id, aaa.customer_id FROM as_accesses_all aaa WHERE aaa.sales_lead_id IS NOT NULL AND aaa.lead_id IS NULL AND aaa.salesforce_id = :2) secu , as_statuses_tl ast , as_sales_lead_ranks_tl aslt , hz_parties CustParty , hz_parties hp, hz_relationships hr , hz_contact_points hcp , hz_timezones ht , ams_source_codes amsc WHERE LeadEO.sales_lead_id = secu.sales_lead_id AND LeadEO.customer_id = secu.customer_id AND LeadEO.status_code = ast.status_code AND ast.language = USERENV('LANG') AND LeadEO.lead_rank_id = aslt.rank_id (+) AND aslt.language (+) = USERENV('LANG') AND LeadEO.customer_id = CustParty.party_id AND LeadEO.primary_contact_party_id = hr.party_id(+) AND hr.subject_id = hp.party_id (+) AND hr.subject_table_name (+) = 'HZ_PARTIES' AND hr.object_id(+) = LeadEO.customer_id AND hr.object_table_name (+) = 'HZ_PARTIES' AND LeadEO.primary_contact_party_id = hcp.owner_table_id(+) AND hcp.owner_table_name (+) = 'HZ_PARTIES' AND hcp.primary_flag (+) = 'Y' AND hcp.contact_point_type (+) = 'PHONE' AND hcp.timezone_id = ht.timezone_id (+) AND LeadEO.source_promotion_id = amsc.source_code_id AND amsc.source_code_for_id = :3 AND LeadEO.status_code = :4 ORDER BY age )
8jb36w62w5hqfBEGIN IBU_REQ_PKG.UpdateServiceRequest(:1, :2, -1, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16); END;
97mt0g20bcfc3 begin pay_US_rules.get_default_jurisdiction (:asgact, :eeid, :defval:defvalind); end;
9k7t8q4kfcb7ybegin GL.apps_ddl.apps_ddl(:ddl_text); end;
9wdrypwkpf607begin OE_FULFILL_WF.START_FULFILLMENT (:v1, :v2, :v3, :v4, :v5); end;
a29grr748ghc4BEGIN jdr_custom_internal.getActiveLayers(:1, :2, :3, :4, :5); END;
auzgm2ap4faw2 (SELECT SUB.GUID SUB_GUID, DECODE(SUB.RULE_FUNCTION, NULL, DECODE(SUB.JAVA_RULE_FUNC, NULL, NULL, :B5 || SUB.JAVA_RULE_FUNC), SUB.RULE_FUNCTION) RULE_FUNC, SUB.SOURCE_TYPE SOURCE_TYPE, NVL(SUB.PHASE, 0) PHASE, SUB.RULE_DATA RULE_DATA, SUB.PRIORITY PRIORITY FROM WF_EVENT_SUBSCRIPTIONS SUB, WF_EVENTS EVT WHERE SUB.SYSTEM_GUID = :B4 AND SUB.STATUS = 'ENABLED' AND SUB.LICENSED_FLAG = 'Y' AND SUB.SOURCE_TYPE = :B3 AND ((SUB.SOURCE_AGENT_GUID IS NOT NULL AND SUB.SOURCE_AGENT_GUID = NVL(:B2 , SUB.SOURCE_AGENT_GUID)) OR SUB.SOURCE_AGENT_GUID IS NULL) AND SUB.EVENT_FILTER_GUID = EVT.GUID AND EVT.NAME IN (:B1 , 'oracle.apps.wf.event.any') AND EVT.TYPE = 'EVENT' AND EVT.STATUS = 'ENABLED' AND EVT.LICENSED_FLAG = 'Y') UNION ALL (SELECT SUB.GUID SUB_GUID, DECODE(SUB.RULE_FUNCTION, NULL, DECODE(SUB.JAVA_RULE_FUNC, NULL, NULL, :B5 || SUB.JAVA_RULE_FUNC), SUB.RULE_FUNCTION) RULE_FUNC, SUB.SOURCE_TYPE SOURCE_TYPE, NVL(SUB.PHASE, 0) PHASE, SUB.RULE_DATA RULE_DATA, SUB.PRIORITY PRIORITY FROM WF_EVENT_SUBSCRIPTIONS SUB, WF_EVENT_GROUPS EGRP, WF_EVENTS GRP, WF_EVENTS EVT WHERE SUB.SYSTEM_GUID = :B4 AND SUB.STATUS = 'ENABLED' AND SUB.LICENSED_FLAG = 'Y' AND SUB.SOURCE_TYPE = :B3 AND ((SUB.SOURCE_AGENT_GUID IS NOT NULL AND SUB.SOURCE_AGENT_GUID = NVL(:B2 , SUB.SOURCE_AGENT_GUID)) OR SUB.SOURCE_AGENT_GUID IS NULL) AND GRP.GUID = SUB.EVENT_FILTER_GUID AND GRP.TYPE = 'GROUP' AND GRP.STATUS = 'ENABLED' AND EGRP.GROUP_GUID = GRP.GUID AND EGRP.MEMBER_GUID = EVT.GUID AND EVT.NA ME = :B1 AND EVT.TYPE = 'EVENT' AND EVT.STATUS = 'ENABLED' AND EVT.LICENSED_FLAG = 'Y') ORDER BY 4
avc1jqzz04wprSELECT 'x' FROM DUAL
bf7uwg5pa3pj6begin FND_FLEX_WORKFLOW_APIS.VALIDATE_COMBINATION (:v1, :v2, :v3, :v4, :v5); end;
bfbyqwbr4vwmsbegin OE_OEOL_SCH.SCHEDULE_LINE (:v1, :v2, :v3, :v4, :v5); end;
bkxrrs52m7d8pBEGIN WSH_SHIP_CONFIRM_ACTIONS.interface_ALL_wrp( :errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8); END;
bp8crdjba8zgtupdate 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)
cd9mbmqyf4qhpUPDATE WF_ITEM_ACTIVITY_STATUSES SET ACTIVITY_STATUS = :B8 , ACTIVITY_RESULT_CODE = NVL(:B13 , ACTIVITY_RESULT_CODE), BEGIN_DATE = NVL(:B11 , BEGIN_DATE), END_DATE = NVL(:B12 , END_DATE), DUE_DATE = DECODE(:B11 , TO_DATE(NULL), DUE_DATE, :B10 ), OUTBOUND_QUEUE_ID = :B9 , EXECUTION_TIME = DECODE(:B8 , :B7 , :B4 , :B6 , NVL(EXECUTION_TIME, :B4 ), :B5 , NVL(EXECUTION_TIME, :B4 ), EXECUTION_TIME) WHERE ITEM_TYPE = :B3 AND ITEM_KEY = :B2 AND PROCESS_ACTIVITY = :B1
csvvv0fmhr1ycBEGIN FFP1893_01010001.FORMULA( :N1, :N4, :T1, :I1, :D1, :T2, :I2, :T7, :I7, :T8, :I8, :T5, :I5, :N3, :T4, :I4, :N2, :N5, :T3, :I3, :T6, :I6, :FFERLN, :FFERCD, :FFERMT); END;
cw171rvngr1w9begin OE_FLEX_COGS_PUB.GET_COST_SALE_ITEM_DERIVED (:v1, :v2, :v3, :v4, :v5); end;
cwyx16zn1hpfbselect parameter, value from nls_session_parameters
d0a8mm8y38yaw SELECT base.revision , base.lot_number , base.lot_expiration_date , base.subinventory_code , base.locator_id , base.cost_group_id , base.date_received , base.primary_quantity , msi.picking_order FROM ( SELECT x.organization_id , x.inventory_item_id , x.revision , x.lot_number , lot.expiration_date lot_expiration_date , x.subinventory_code , sub.reservable_type , x.locator_id , x.cost_group_id , x.date_received date_received , x.primary_quantity primary_quantity , NULL lpn_id , x.project_id project_id , x.task_id task_id FROM (SELECT moq.organization_id , moq.inventory_item_id , moq.revision , moq.lot_number , moq.subinventory_code , moq.locator_id , moq.cost_group_id , min(NVL(moq.orig_date_received, moq.date_received)) date_received , sum(moq.primary_transaction_quantity) primary_quantity , moq.project_id , moq.task_id FROM MTL_ONHAND_QUANTITIES_DETAIL moq WHERE moq.organization_id = :n1 AND moq.inventory_item_id = :n2 GROUP BY moq.organization_id, moq.inventory_item_id , moq.revision, moq.lot_number , moq.subinventory_code, moq.locator_id , moq.cost_group_id , moq.project_id , moq.task_id ) x , mtl_seconda ry_inventories sub , mtl_lot_numbers lot WHERE x.primary_quantity > 0 AND x.organization_id = sub.organization_id AND x.subinventory_code = sub.secondary_inventory_name AND NVL(sub.disable_date, sysdate+1) > sysdate AND x.organization_id = lot.organization_id (+) AND x.inventory_item_id = lot.inventory_item_id (+) AND x.lot_number = lot.lot_number (+) ) base , mtl_secondary_inventories msi where 1=1 AND NVL(base.reservable_type, 2) = 1 AND base.subinventory_code = msi.secondary_inventory_name AND base.organization_id = msi.organization_id AND ((base.locator_id IS NULL) OR (base.locator_id IS NOT NULL AND (EXISTS ( SELECT inventory_location_id FROM mtl_item_locations WHERE inventory_location_id = base.locator_id AND organization_id = base.organization_id AND project_id IS NULL AND task_id IS NULL)))) order by msi.picking_order , base.date_received
dcvv68fju01g4begin FND_FLEX_WORKFLOW_APIS.END_GENERATION (:v1, :v2, :v3, :v4, :v5); end;
fb13x9qx0ftksbegin OE_STANDARD_WF.OEOL_SELECTOR (:v1, :v2, :v3, :v4, :v5); end;
fmfdkztk8vx23SELECT CATEGORY, SEVERITY, FND_LOG_SEVERITY FROM FND_NEW_MESSAGES WHERE MESSAGE_NAME = :B1 AND APPLICATION_ID = :B2 AND LANGUAGE_CODE = :B3 AND ROWNUM = 1
fr38pcatsbj6x SELECT reservation_id , primary_reservation_quantity - NVL(detailed_quantity, 0) FROM mtl_reservations WHERE demand_source_header_id = :demand_source_header_id AND demand_source_line_id = :demand_source_line_id AND demand_source_type_id = :demand_source_type_id AND supply_source_type_id = :supply_source_type_id AND (:demand_source_delivery = :l_miss_num OR :demand_source_delivery IS NULL AND demand_source_delivery IS NULL OR :demand_source_delivery = demand_source_delivery) AND (:organization_id = :l_miss_num OR :organization_id IS NULL AND organization_id IS NULL OR :organization_id = organization_id) AND (:inventory_item_id = :l_miss_num OR :inventory_item_id IS NULL AND inventory_item_id IS NULL OR :inventory_item_id = inventory_item_id) AND (:subinventory_code = :l_miss_char OR :subinventory_code IS NULL AND subinventory_code IS NULL OR :subinventory_code = subinventory_code) AND (:locator_id = :l_miss_num OR :locator_id IS NULL AND locator_id IS NULL OR :locator_id = locator_id) AND (:lot_number = :l_miss_char OR :lot_number IS NULL AND lot_number IS NULL OR :lot_number = lot_number) AND (:revision = :l_miss_char OR :revision IS NULL AND revision IS NULL OR :revision = revision) AND (:lpn_id = :l_ miss_num OR ((lpn_id IS NULL) OR (:lpn_id = lpn_id))) AND (:demand_source_name = :l_miss_char OR :demand_source_name IS NULL AND demand_source_name IS NULL OR :demand_source_name = demand_source_name) AND (primary_reservation_quantity - NVL(detailed_quantity, 0)) > 0 ORDER BY NVL(lpn_id, 0) DESC, reservation_id FOR UPDATE
fvcbstf9s6a5rbegin WF_STANDARD.WAITFORFLOW (:v1, :v2, :v3, :v4, :v5); end;
g8102j8yynbwzbegin WF_STANDARD.CONTINUEFLOW (:v1, :v2, :v3, :v4, :v5); end;
gdnwgx9fcxggrbegin OE_SHIPPING_WF.START_SHIPPING (:v1, :v2, :v3, :v4, :v5); end;
gf1u933c95jb5DECLARE 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;
gksvm8wmzk8w0begin OE_INVOICE_WF.INVOICE_INTERFACE (:v1, :v2, :v3, :v4, :v5); end;
gnng1rmpjxzsxbegin OE_CLOSE_WF.CLOSE_LINE (:v1, :v2, :v3, :v4, :v5); end;

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
CPU used by this session 1,921,617 533.03 2.56
CPU used when call started 1,919,213 532.36 2.56
CR blocks created 13,042,256 3,617.74 17.39
Cached Commit SCN referenced 44,930 12.46 0.06
Commit SCN cached 8 0.00 0.00
DB time 6,230,958 1,728.38 8.31
DBWR checkpoint buffers written 2,734,887 758.62 3.65
DBWR checkpoints 37 0.01 0.00
DBWR object drop buffers written 28,105 7.80 0.04
DBWR revisited being-written buffer 12 0.00 0.00
DBWR thread checkpoint buffers written 1,090,563 302.51 1.45
DBWR transaction table writes 1,491 0.41 0.00
DBWR undo block writes 1,427,189 395.88 1.90
DFO trees parallelized 48 0.01 0.00
IMU CR rollbacks 25,658,956 7,117.44 34.22
IMU Flushes 243,086 67.43 0.32
IMU Redo allocation size 1,633,211,620 453,030.24 2,178.12
IMU commits 397,828 110.35 0.53
IMU contention 25,995 7.21 0.03
IMU ktichg flush 5,855 1.62 0.01
IMU pool not allocated 1,567 0.43 0.00
IMU recursive-transaction flush 1,198 0.33 0.00
IMU undo allocation size 3,613,465,960 1,002,325.32 4,819.06
IMU- failed to get a private strand 1,567 0.43 0.00
PX local messages recv'd 66,880 18.55 0.09
PX local messages sent 66,880 18.55 0.09
Parallel operations downgraded 25 to 50 pct 40 0.01 0.00
Parallel operations not downgraded 8 0.00 0.00
SQL*Net roundtrips to/from client 25,548,363 7,086.76 34.07
active txn count during cleanout 80,681,056 22,379.81 107.60
application wait time 55,946 15.52 0.07
background checkpoints completed 5 0.00 0.00
background checkpoints started 5 0.00 0.00
background timeouts 11,462 3.18 0.02
branch node splits 995 0.28 0.00
buffer is not pinned count 592,216,866 164,272.74 789.80
buffer is pinned count 1,271,830,720 352,788.19 1,696.16
bytes received via SQL*Net from client 5,764,442,451 1,598,976.35 7,687.69
bytes sent via SQL*Net to client 5,665,232,216 1,571,456.81 7,555.38
calls to get snapshot scn: kcmgss 75,121,093 20,837.55 100.18
calls to kcmgas 16,310,693 4,524.36 21.75
calls to kcmgcs 15,194,913 4,214.86 20.26
change write time 56,521 15.68 0.08
cleanout - number of ktugct calls 26,807,310 7,435.98 35.75
cleanouts and rollbacks - consistent read gets 11,131,075 3,087.61 14.84
cleanouts only - consistent read gets 117,528 32.60 0.16
cluster key scan block gets 763,519 211.79 1.02
cluster key scans 219,263 60.82 0.29
commit batch/immediate performed 3,435 0.95 0.00
commit batch/immediate requested 3,435 0.95 0.00
commit cleanout failures: block lost 176,261 48.89 0.24
commit cleanout failures: buffer being written 3,005 0.83 0.00
commit cleanout failures: callback failure 98,593 27.35 0.13
commit cleanout failures: cannot pin 26,605 7.38 0.04
commit cleanouts 7,024,368 1,948.46 9.37
commit cleanouts successfully completed 6,719,904 1,864.01 8.96
commit immediate performed 3,435 0.95 0.00
commit immediate requested 3,435 0.95 0.00
commit txn count during cleanout 1,069,156 296.57 1.43
concurrency wait time 32,774 9.09 0.04
consistent changes 610,445,929 169,329.23 814.11
consistent gets 1,473,725,636 408,791.04 1,965.42
consistent gets - examination 1,009,551,418 280,035.55 1,346.38
consistent gets from cache 1,473,725,640 408,791.04 1,965.42
cursor authentications 1,724 0.48 0.00
data blocks consistent reads - undo records applied 608,186,478 168,702.49 811.10
db block changes 175,163,478 48,587.92 233.60
db block gets 204,175,013 56,635.32 272.30
db block gets direct 4,068 1.13 0.01
db block gets from cache 204,170,948 56,634.19 272.29
deferred (CURRENT) block cleanout applications 1,204,973 334.24 1.61
dirty buffers inspected 6,061 1.68 0.01
doubling up with imu segment 0 0.00 0.00
enqueue conversions 7,385 2.05 0.01
enqueue releases 2,888,019 801.10 3.85
enqueue requests 2,895,609 803.20 3.86
enqueue timeouts 7,411 2.06 0.01
enqueue waits 35,587 9.87 0.05
exchange deadlocks 45,108 12.51 0.06
execute count 67,130,659 18,621.11 89.53
failed probes on index block reclamation 12,055 3.34 0.02
free buffer inspected 2,174,769 603.25 2.90
free buffer requested 16,791,441 4,657.71 22.39
heap block compress 28,055,751 7,782.28 37.42
hot buffers moved to head of LRU 818,716 227.10 1.09
immediate (CR) block cleanout applications 11,248,616 3,120.21 15.00
immediate (CURRENT) block cleanout applications 993,420 275.56 1.32
index crx upgrade (found) 23,336 6.47 0.03
index crx upgrade (positioned) 6,527,732 1,810.70 8.71
index fast full scans (rowid ranges) 1,832 0.51 0.00
index fetch by key 161,946,631 44,921.75 215.98
index scans kdiixs1 109,555,219 30,389.10 146.11
java call heap collected bytes 1,055,350,184 292,739.50 1,407.46
java call heap collected count 13,354,020 3,704.22 17.81
java call heap gc count 3,753 1.04 0.01
java call heap live object count 1,396,579 387.39 1.86
java call heap live object count max 1,503,419 417.03 2.01
java call heap live size 337,656,776 93,661.30 450.31
java call heap live size max 358,833,480 99,535.43 478.55
java call heap object count 3,531,223 979.51 4.71
java call heap object count max 3,556,958 986.65 4.74
java call heap total size 434,765,824 120,598.01 579.82
java call heap total size max 461,504,512 128,014.95 615.48
java call heap used size 476,160,104 132,080.21 635.03
java call heap used size max 490,703,800 136,114.43 654.42
leaf node 90-10 splits 16,896 4.69 0.02
leaf node splits 219,678 60.94 0.29
lob reads 11,029 3.06 0.01
lob writes 19,467 5.40 0.03
lob writes unaligned 19,467 5.40 0.03
logons cumulative 5,944 1.65 0.01
messages received 1,026,780 284.81 1.37
messages sent 1,026,780 284.81 1.37
no buffer to keep pinned count 16 0.00 0.00
no work - consistent read gets 427,663,315 118,627.87 570.35
opened cursors cumulative 3,274,713 908.36 4.37
parse count (failures) 1,682 0.47 0.00
parse count (hard) 5,936 1.65 0.01
parse count (total) 5,321,765 1,476.18 7.10
parse time cpu 37,132 10.30 0.05
parse time elapsed 45,012 12.49 0.06
physical read IO requests 241,723 67.05 0.32
physical read bytes 3,291,406,336 912,990.45 4,389.55
physical read total IO requests 271,145 75.21 0.36
physical read total bytes 3,772,451,840 1,046,425.79 5,031.09
physical read total multi block requests 15,056 4.18 0.02
physical reads 401,782 111.45 0.54
physical reads cache 400,133 110.99 0.53
physical reads cache prefetch 159,880 44.35 0.21
physical reads direct 1,650 0.46 0.00
physical reads direct temporary tablespace 186 0.05 0.00
physical reads prefetch warmup 102,305 28.38 0.14
physical write IO requests 1,288,070 357.29 1.72
physical write bytes 22,781,108,224 6,319,163.31 30,381.78
physical write total IO requests 1,936,856 537.26 2.58
physical write total bytes 52,716,112,384 14,622,718.09 70,304.27
physical write total multi block requests 1,140,023 316.23 1.52
physical writes 2,780,897 771.38 3.71
physical writes direct 4,809 1.33 0.01
physical writes direct (lob) 236 0.07 0.00
physical writes direct temporary tablespace 3,958 1.10 0.01
physical writes from cache 2,776,088 770.05 3.70
physical writes non checkpoint 2,069,001 573.91 2.76
pinned buffers inspected 1,320 0.37 0.00
prefetch clients - default 1 0.00 0.00
prefetch warmup blocks aged out before use 213,373 59.19 0.28
prefetched blocks aged out before use 120 0.03 0.00
process last non-idle time 3,607 1.00 0.00
queries parallelized 48 0.01 0.00
recursive calls 109,858,341 30,473.18 146.51
recursive cpu usage 1,121,591 311.11 1.50
redo blocks written 58,291,215 16,169.17 77.74
redo buffer allocation retries 22 0.01 0.00
redo entries 90,598,685 25,130.82 120.83
redo log space requests 41 0.01 0.00
redo log space wait time 44 0.01 0.00
redo ordering marks 1,150,926 319.25 1.53
redo size 28,637,081,416 7,943,529.02 38,191.53
redo subscn max counts 2,169,484 601.78 2.89
redo synch time 41,827 11.60 0.06
redo synch writes 1,163,130 322.64 1.55
redo wastage 231,428,264 64,194.99 308.64
redo write time 33,835 9.39 0.05
redo writer latching time 79 0.02 0.00
redo writes 571,908 158.64 0.76
rollback changes - undo records applied 259,009 71.85 0.35
rollbacks only - consistent read gets 2,092,177 580.34 2.79
rows fetched via callback 94,985,527 26,347.67 126.68
session connect time 0 0.00 0.00
session cursor cache hits 3,562,996 988.33 4.75
session logical reads 1,677,900,325 465,426.27 2,237.71
session pga memory 7,851,048,128 2,177,771.81 10,470.47
session pga memory max 10,122,244,000 2,807,770.03 13,499.42
session uga memory ############### 74,219,990.80 356,840.80
session uga memory max 41,497,908,240 11,510,943.92 55,343.24
shared hash latch upgrades - no wait 25,747,815 7,142.09 34.34
shared hash latch upgrades - wait 42,103 11.68 0.06
sorts (memory) 6,808,575 1,888.60 9.08
sorts (rows) 89,848,680 24,922.78 119.83
sql area evicted 1,372 0.38 0.00
sql area purged 1,851 0.51 0.00
summed dirty queue length 20,465 5.68 0.03
switch current to new buffer 1,112,171 308.50 1.48
table fetch by rowid 792,898,506 219,939.04 1,057.44
table fetch continued row 30,871,573 8,563.35 41.17
table scan blocks gotten 40,686,807 11,285.96 54.26
table scan rows gotten 1,192,455,185 330,770.52 1,590.30
table scans (long tables) 4,149 1.15 0.01
table scans (rowid ranges) 4,147 1.15 0.01
table scans (short tables) 3,177,900 881.51 4.24
total number of times SMON posted 72,986 20.25 0.10
transaction rollbacks 3,435 0.95 0.00
transaction tables consistent read rollbacks 77 0.02 0.00
transaction tables consistent reads - undo records applied 5,246 1.46 0.01
undo change vector size 9,949,568,396 2,759,872.21 13,269.13
user I/O wait time 260,176 72.17 0.35
user calls 24,389,362 6,765.27 32.53
user commits 625,155 173.41 0.83
user rollbacks 124,673 34.58 0.17
workarea executions - onepass 2 0.00 0.00
workarea executions - optimal 3,657,619 1,014.57 4.88
write clones created in background 1,341 0.37 0.00
write clones created in foreground 21,817 6.05 0.03

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session cursor cache count 193,200 570,141
opened cursors current 528,628 636,074
workarea memory allocated 687 2,087
logons current 2,621 2,632

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived) 3 3.00

Back to Instance Activity Statistics
Back to Top

IO Stats

Back to Top

Tablespace IO Stats

TablespaceReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
APPS_UNDOTS1 51 0 0.00 1.00 540,909 150 273,305 0.03
APPS_TS_TX_DATA 152,175 42 10.18 1.38 170,061 47 136,413 0.41
APPS_ASSM_DATA 8,605 2 6.60 6.66 284,046 79 51,287 1.18
APPS_TS_TX_IDX 65,875 18 9.20 1.63 111,812 31 65,373 0.58
APPS_ASSM_IDX 6,183 2 5.49 1.06 138,846 39 252,648 0.12
APPS_TS_TX_INTERFACE 1,074 0 2.52 2.21 20,650 6 18,234 0.09
TEMP 230 0 0.22 17.97 6,374 2 238 555.17
SYSTEM 3,754 1 6.75 1.57 2,034 1 18,716 0.17
APPS_TS_SEED 1,854 1 11.29 2.75 3,308 1 795 6.45
APPS_TS_QUEUES 1,163 0 3.80 1.67 3,330 1 261 2.91
APPS_TS_SUMMARY 107 0 0.09 1.00 3,751 1 2,295 0.02
SYSAUX 274 0 3.76 1.08 1,477 0 0 0.00
APPS_TS_ARCHIVE 58 0 3.28 1.31 1,394 0 42 2.14
APPS_TS_NOLOGGING 37 0 1.89 1.38 65 0 0 0.00
CTXSYS 48 0 0.00 1.00 10 0 0 0.00
APPS_TS_MEDIA 24 0 0.00 1.00 15 0 0 0.00
ODM 24 0 0.00 1.00 5 0 0 0.00
OLAP 24 0 0.00 1.00 5 0 0 0.00
OWAPUB 24 0 0.00 1.00 5 0 0 0.00
PORTAL 24 0 0.00 1.00 5 0 0 0.00
SYNCSERVER 24 0 0.00 1.00 5 0 0 0.00

Back to IO Stats
Back to Top

File IO Stats

TablespaceFilenameReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
APPS_ASSM_DATA /DB/visdata/apps_assm_data.dbf 8,605 2 6.60 6.66 284,046 79 51,287 1.18
APPS_ASSM_IDX /DB/visdata/apps_assm_idx.dbf 6,183 2 5.49 1.06 138,846 39 252,648 0.12
APPS_TS_ARCHIVE /DB/visdata/archive1.dbf 23 0 3.48 1.30 1,156 0 38 2.37
APPS_TS_ARCHIVE /DB/visdata/archive2.dbf 35 0 3.14 1.31 238 0 4 0.00
APPS_TS_MEDIA /DB/visdata/media1.dbf 8 0 0.00 1.00 5 0 0 0.00
APPS_TS_MEDIA /DB/visdata/media2.dbf 8 0 0.00 1.00 5 0 0 0.00
APPS_TS_MEDIA /DB/visdata/media3.dbf 8 0 0.00 1.00 5 0 0 0.00
APPS_TS_NOLOGGING /DB/visdata/nologging1.dbf 8 0 0.00 1.00 5 0 0 0.00
APPS_TS_NOLOGGING /DB/visdata/nologging2.dbf 19 0 2.63 1.00 49 0 0 0.00
APPS_TS_NOLOGGING /DB/visdata/nologging3.dbf 10 0 2.00 2.40 11 0 0 0.00
APPS_TS_QUEUES /DB/visdata/queues1.dbf 214 0 2.80 1.13 519 0 123 0.41
APPS_TS_QUEUES /DB/visdata/queues2.dbf 147 0 2.65 1.76 578 0 86 1.05
APPS_TS_QUEUES /DB/visdata/queues3.dbf 138 0 5.43 1.98 425 0 3 0.00
APPS_TS_QUEUES /DB/visdata/queues4.dbf 142 0 3.52 1.74 365 0 5 0.00
APPS_TS_QUEUES /DB/visdata/queues5.dbf 145 0 2.83 1.77 404 0 0 0.00
APPS_TS_QUEUES /DB/visdata/queues6.dbf 131 0 3.44 1.98 467 0 1 0.00
APPS_TS_QUEUES /DB/visdata/queues7.dbf 246 0 5.37 1.65 572 0 43 14.42
APPS_TS_SEED /DB/visdata/reference1.dbf 164 0 13.05 3.65 317 0 47 13.19
APPS_TS_SEED /DB/visdata/reference10.dbf 172 0 10.06 3.07 355 0 37 5.41
APPS_TS_SEED /DB/visdata/reference2.dbf 185 0 8.76 2.37 312 0 31 5.48
APPS_TS_SEED /DB/visdata/reference3.dbf 283 0 8.41 2.37 461 0 455 3.80
APPS_TS_SEED /DB/visdata/reference4.dbf 180 0 13.17 2.84 335 0 47 11.49
APPS_TS_SEED /DB/visdata/reference5.dbf 201 0 11.09 2.34 347 0 67 21.34
APPS_TS_SEED /DB/visdata/reference6.dbf 180 0 14.72 2.79 346 0 32 5.00
APPS_TS_SEED /DB/visdata/reference7.dbf 166 0 16.02 3.25 264 0 20 5.00
APPS_TS_SEED /DB/visdata/reference8.dbf 155 0 13.10 2.75 275 0 25 2.80
APPS_TS_SEED /DB/visdata/reference9.dbf 168 0 6.73 2.51 296 0 34 3.24
APPS_TS_SUMMARY /DB/visdata/summary1.dbf 11 0 0.00 1.00 429 0 306 0.00
APPS_TS_SUMMARY /DB/visdata/summary2.dbf 11 0 0.00 1.00 416 0 218 0.00
APPS_TS_SUMMARY /DB/visdata/summary3.dbf 17 0 0.59 1.00 447 0 152 0.00
APPS_TS_SUMMARY /DB/visdata/summary4.dbf 13 0 0.00 1.00 408 0 195 0.00
APPS_TS_SUMMARY /DB/visdata/summary5.dbf 13 0 0.00 1.00 375 0 300 0.00
APPS_TS_SUMMARY /DB/visdata/summary6.dbf 13 0 0.00 1.00 643 0 592 0.05
APPS_TS_SUMMARY /DB/visdata/summary7.dbf 16 0 0.00 1.00 530 0 309 0.00
APPS_TS_SUMMARY /DB/visdata/summary8.dbf 13 0 0.00 1.00 503 0 223 0.09
APPS_TS_TX_DATA /DB/visdata/tx_data1.dbf 2,710 1 12.55 1.44 222 0 0 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data10.dbf 2,563 1 13.37 1.35 86 0 0 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data11.dbf 2,496 1 11.64 1.34 87 0 0 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data12.dbf 11,723 3 8.06 1.24 1,818 1 3,904 1.69
APPS_TS_TX_DATA /DB/visdata/tx_data13.dbf 15,426 4 12.44 1.50 2,689 1 2,904 1.64
APPS_TS_TX_DATA /DB/visdata/tx_data14.dbf 11,753 3 8.77 1.42 26,357 7 18,080 0.31
APPS_TS_TX_DATA /DB/visdata/tx_data15.dbf 8,374 2 10.40 1.50 23,755 7 18,786 0.39
APPS_TS_TX_DATA /DB/visdata/tx_data16.dbf 8,416 2 9.87 1.48 22,847 6 17,697 0.31
APPS_TS_TX_DATA /DB/visdata/tx_data17.dbf 8,445 2 10.14 1.50 22,701 6 17,243 0.29
APPS_TS_TX_DATA /DB/visdata/tx_data18.dbf 8,488 2 10.43 1.48 21,908 6 18,103 0.29
APPS_TS_TX_DATA /DB/visdata/tx_data19.dbf 8,301 2 8.60 1.46 22,294 6 18,087 0.23
APPS_TS_TX_DATA /DB/visdata/tx_data2.dbf 6,234 2 7.87 1.19 480 0 1,999 2.50
APPS_TS_TX_DATA /DB/visdata/tx_data20.dbf 8,189 2 8.78 1.51 21,940 6 18,098 0.22
APPS_TS_TX_DATA /DB/visdata/tx_data21.dbf 20,942 6 10.90 1.20 1,178 0 1,458 1.97
APPS_TS_TX_DATA /DB/visdata/tx_data3.dbf 2,652 1 12.15 1.45 269 0 6 8.33
APPS_TS_TX_DATA /DB/visdata/tx_data4.dbf 12,452 3 8.91 1.33 234 0 10 6.00
APPS_TS_TX_DATA /DB/visdata/tx_data5.dbf 2,605 1 9.58 1.27 230 0 4 10.00
APPS_TS_TX_DATA /DB/visdata/tx_data6.dbf 2,521 1 12.24 1.34 135 0 9 5.56
APPS_TS_TX_DATA /DB/visdata/tx_data7.dbf 2,562 1 9.84 1.37 326 0 20 5.50
APPS_TS_TX_DATA /DB/visdata/tx_data8.dbf 2,612 1 13.78 1.25 346 0 5 4.00
APPS_TS_TX_DATA /DB/visdata/tx_data9.dbf 2,711 1 13.63 1.46 159 0 0 0.00
APPS_TS_TX_IDX /DB/visdata/tx_idx1.dbf 2,170 1 7.73 1.32 1,561 0 1,756 0.75
APPS_TS_TX_IDX /DB/visdata/tx_idx10.dbf 2,098 1 9.50 1.32 1,057 0 1,663 0.94
APPS_TS_TX_IDX /DB/visdata/tx_idx11.dbf 2,107 1 8.04 1.35 1,124 0 1,857 0.89
APPS_TS_TX_IDX /DB/visdata/tx_idx12.dbf 6,712 2 13.70 2.18 14,333 4 1,597 0.46
APPS_TS_TX_IDX /DB/visdata/tx_idx13.dbf 6,613 2 5.64 1.44 16,441 5 3,369 0.40
APPS_TS_TX_IDX /DB/visdata/tx_idx14.dbf 3,456 1 10.08 1.82 9,905 3 3,486 0.28
APPS_TS_TX_IDX /DB/visdata/tx_idx15.dbf 3,559 1 10.21 1.80 8,423 2 4,290 0.32
APPS_TS_TX_IDX /DB/visdata/tx_idx16.dbf 3,482 1 12.11 1.81 7,308 2 3,377 0.33
APPS_TS_TX_IDX /DB/visdata/tx_idx17.dbf 3,380 1 9.50 1.73 7,296 2 4,004 0.37
APPS_TS_TX_IDX /DB/visdata/tx_idx18.dbf 3,395 1 8.93 1.73 7,223 2 4,516 0.29
APPS_TS_TX_IDX /DB/visdata/tx_idx19.dbf 3,438 1 11.50 1.86 7,039 2 4,291 0.26
APPS_TS_TX_IDX /DB/visdata/tx_idx2.dbf 2,384 1 8.02 1.61 1,169 0 2,220 0.43
APPS_TS_TX_IDX /DB/visdata/tx_idx20.dbf 3,434 1 10.46 1.75 6,561 2 3,103 0.38
APPS_TS_TX_IDX /DB/visdata/tx_idx21.dbf 2,328 1 11.01 2.04 8,373 2 2,216 1.85
APPS_TS_TX_IDX /DB/visdata/tx_idx3.dbf 3,669 1 6.88 1.23 1,344 0 2,778 1.40
APPS_TS_TX_IDX /DB/visdata/tx_idx4.dbf 2,329 1 7.17 1.30 2,444 1 3,007 1.21
APPS_TS_TX_IDX /DB/visdata/tx_idx5.dbf 2,335 1 6.78 1.35 3,859 1 10,042 0.27
APPS_TS_TX_IDX /DB/visdata/tx_idx6.dbf 2,338 1 7.10 1.41 2,053 1 2,815 0.66
APPS_TS_TX_IDX /DB/visdata/tx_idx7.dbf 2,265 1 7.72 1.36 2,016 1 1,856 1.07
APPS_TS_TX_IDX /DB/visdata/tx_idx8.dbf 2,223 1 7.99 1.43 1,089 0 1,535 1.18
APPS_TS_TX_IDX /DB/visdata/tx_idx9.dbf 2,160 1 8.09 1.36 1,194 0 1,595 1.10
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte.dbf 211 0 2.27 1.70 3,001 1 6,691 0.03
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte2.dbf 292 0 2.47 2.10 4,175 1 4,098 0.28
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte3.dbf 164 0 3.29 2.51 3,763 1 2,733 0.02
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte4.dbf 129 0 2.87 2.63 3,195 1 1,837 0.04
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte5.dbf 149 0 2.82 2.30 3,186 1 1,888 0.02
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte6.dbf 129 0 1.40 2.44 3,330 1 987 0.05
APPS_UNDOTS1 /DB/visdata/undo01.dbf 5 0 0.00 1.00 54,648 15 24,576 0.03
APPS_UNDOTS1 /DB/visdata/undo02.dbf 5 0 0.00 1.00 54,112 15 22,625 0.02
APPS_UNDOTS1 /DB/visdata/undo03.dbf 6 0 0.00 1.00 53,836 15 24,408 0.03
APPS_UNDOTS1 /DB/visdata/undo04.dbf 5 0 0.00 1.00 52,077 14 26,422 0.03
APPS_UNDOTS1 /DB/visdata/undo05.dbf 5 0 0.00 1.00 54,841 15 32,256 0.04
APPS_UNDOTS1 /DB/visdata/undo06.dbf 5 0 0.00 1.00 53,406 15 25,345 0.02
APPS_UNDOTS1 /DB/visdata/undo07.dbf 5 0 0.00 1.00 58,481 16 27,185 0.03
APPS_UNDOTS1 /DB/visdata/undo08.dbf 5 0 0.00 1.00 53,684 15 28,234 0.03
APPS_UNDOTS1 /DB/visdata/undo09.dbf 5 0 0.00 1.00 52,521 15 31,168 0.03
APPS_UNDOTS1 /DB/visdata/undo10.dbf 5 0 0.00 1.00 53,303 15 31,086 0.03
CTXSYS /DB/visdata/ctx1.dbf 24 0 0.00 1.00 5 0 0 0.00
CTXSYS /DB/visdata/ctx2.dbf 24 0 0.00 1.00 5 0 0 0.00
ODM /DB/visdata/odm.dbf 24 0 0.00 1.00 5 0 0 0.00
OLAP /DB/visdata/olap.dbf 24 0 0.00 1.00 5 0 0 0.00
OWAPUB /DB/visdata/owa1.dbf 24 0 0.00 1.00 5 0 0 0.00
PORTAL /DB/visdata/portal.dbf 24 0 0.00 1.00 5 0 0 0.00
SYNCSERVER /DB/visdata/mobile01.dbf 24 0 0.00 1.00 5 0 0 0.00
SYSAUX /DB/visdata/sysaux01.dbf 17 0 8.82 1.88 597 0 0 0.00
SYSAUX /DB/visdata/sysaux02.dbf 257 0 3.42 1.03 880 0 0 0.00
SYSTEM /DB/visdata/sys1.dbf 411 0 7.10 1.60 95 0 241 0.29
SYSTEM /DB/visdata/sys2.dbf 391 0 7.26 1.54 152 0 274 0.36
SYSTEM /DB/visdata/sys3.dbf 479 0 4.59 1.53 187 0 99 2.93
SYSTEM /DB/visdata/sys4.dbf 495 0 6.69 1.48 195 0 25 3.20
SYSTEM /DB/visdata/sys5.dbf 456 0 7.70 1.49 605 0 1,033 0.45
SYSTEM /DB/visdata/sys6.dbf 393 0 7.28 1.55 47 0 33 17.88
SYSTEM /DB/visdata/sys7.dbf 331 0 5.05 1.76 124 0 104 0.38
SYSTEM /DB/visdata/sys8.dbf 296 0 8.48 1.84 331 0 16,672 0.08
SYSTEM /DB/visdata/sys9.dbf 502 0 6.99 1.48 298 0 235 0.85
TEMP /DB/visdata/temp1.dbf 43 0 0.23 11.74 1,838 1 92 445.11
TEMP /DB/visdata/temp2.dbf 58 0 0.52 33.10 1,390 0 41 537.56
TEMP /DB/visdata/temp3.dbf 59 0 0.17 24.73 1,464 0 48 737.71
TEMP /DB/visdata/temp4.dbf 70 0 0.00 3.57 1,682 0 57 591.75

Back to IO Stats
Back to Top

Buffer Pool Statistics

PNumber of BuffersPool Hit%Buffer GetsPhysical ReadsPhysical WritesFree Buff WaitWrit Comp WaitBuffer Busy Waits
D 2,263,976 100 1,660,917,174 400,114 2,776,276 0 0 819,685


Back to Top

Advisory Statistics

Back to Top

Instance Recovery Stats

Targt MTTR (s) Estd MTTR (s)Recovery Estd IOsActual Redo BlksTarget Redo BlksLog File Size Redo BlksLog Ckpt Timeout Redo BlksLog Ckpt Interval Redo Blks
B 180 78 24886 543573 2064405 35156250 2064405  
E 180 101 40601 907881 7712032 35156250 7712032  

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 ProcessedExtra W/A MB Read/Written
100.00 310,054 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 MemGlobal Mem Bound(K)
B 20,480 4,275 21,636.62 0.67 0.00 100.00 0.00 1,048,576
E 20,480 1,280 27,752.98 1.15 0.00 100.00 0.00 1,048,576

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K 4K 3,337,956 3,337,956 0 0
64K 128K 11,326 11,326 0 0
128K 256K 1,264 1,264 0 0
256K 512K 739 739 0 0
512K 1024K 100,308 100,308 0 0
1M 2M 204,247 204,247 0 0
2M 4M 76 74 2 0
4M 8M 21 21 0 0
8M 16M 2 2 0 0
32M 64M 8 8 0 0
64M 128M 6 6 0 0
128M 256M 2 2 0 0

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

PGA Target Est (MB)Size FactrW/A MB ProcessedEstd Extra W/A MB Read/ Written to Disk Estd PGA Cache Hit %Estd PGA Overalloc Count
2,560 0.13 412,443.92 7,217.39 98.00 861
5,120 0.25 412,443.92 7,083.20 98.00 819
10,240 0.50 412,443.92 6,960.70 98.00 765
15,360 0.75 412,443.92 6,709.79 98.00 676
20,480 1.00 412,443.92 2.73 100.00 62
24,576 1.20 412,443.92 0.00 100.00 0
28,672 1.40 412,443.92 0.00 100.00 0
32,768 1.60 412,443.92 0.00 100.00 0
36,864 1.80 412,443.92 0.00 100.00 0
40,960 2.00 412,443.92 0.00 100.00 0
61,440 3.00 412,443.92 0.00 100.00 0
81,920 4.00 412,443.92 0.00 100.00 0
122,880 6.00 412,443.92 0.00 100.00 0
163,840 8.00 412,443.92 0.00 100.00 0

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

Shared Pool Size(M)SP Size FactrEst LC Size (M)Est LC Mem ObjEst LC Time Saved (s)Est LC Time Saved FactrEst LC Load Time (s)Est LC Load Time FactrEst LC Mem Obj Hits
1,248 0.60 241 12,038 2,045,883 0.99 16,383 17.83 107,094,170
1,456 0.70 420 15,127 2,053,989 1.00 8,277 9.01 107,496,518
1,664 0.80 627 18,393 2,061,337 1.00 929 1.01 107,861,191
1,872 0.90 828 25,407 2,061,346 1.00 920 1.00 107,862,184
2,080 1.00 897 29,168 2,061,347 1.00 919 1.00 107,862,349
2,288 1.10 898 29,457 2,061,347 1.00 919 1.00 107,862,379
2,496 1.20 898 29,457 2,061,347 1.00 919 1.00 107,862,379
2,704 1.30 898 29,457 2,061,347 1.00 919 1.00 107,862,379
2,912 1.40 898 29,457 2,061,347 1.00 919 1.00 107,862,379
3,120 1.50 898 29,457 2,061,347 1.00 919 1.00 107,862,379
3,328 1.60 898 29,457 2,061,347 1.00 919 1.00 107,862,379
3,536 1.70 898 29,457 2,061,347 1.00 919 1.00 107,862,379
3,744 1.80 898 29,457 2,061,347 1.00 919 1.00 107,862,379
3,952 1.90 898 29,457 2,061,347 1.00 919 1.00 107,862,379
4,160 2.00 898 29,457 2,061,347 1.00 919 1.00 107,862,379

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
5,120 0.25 27,725  
10,240 0.50 27,725  
15,360 0.75 27,725  
20,480 1.00 27,724  
25,600 1.25 27,729  
30,720 1.50 27,729  
35,840 1.75 27,729  
40,960 2.00 27,729  

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Java Pool Advisory

Java Pool Size(M)JP Size FactrEst LC Size (M)Est LC Mem ObjEst LC Time Saved (s)Est LC Time Saved FactrEst LC Load Time (s)Est LC Load Time FactrEst LC Mem Obj Hits
16 0.25 13 226 597 1.00 919 1.00 5,159
32 0.50 13 226 597 1.00 919 1.00 5,159
48 0.75 13 226 597 1.00 919 1.00 5,159
64 1.00 13 226 597 1.00 919 1.00 5,159
80 1.25 13 226 597 1.00 919 1.00 5,159
96 1.50 13 226 597 1.00 919 1.00 5,159
112 1.75 13 226 597 1.00 919 1.00 5,159
128 2.00 13 226 597 1.00 919 1.00 5,159

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
data block 536,988 194 0
file header block 237 132 558
undo block 217,771 6 0
undo header 55,530 2 0
segment header 2,711 1 0
1st level bmb 5,568 1 0
2nd level bmb 765 0 0
bitmap index block 7 0 0
extent map 4 0 0

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
RO-Multiple Object Reuse (fast object reuse) 287 288 0 32 372 11,616.25
UL-User-defined 63,696 62,734 962 2,286 122 53.44
TX-Transaction (row lock contention) 6,074 290 5,784 284 64 225.04
TX-Transaction (index contention) 26,521 26,521 0 24,332 36 1.46
HW-Segment High Water Mark 151,584 151,580 4 2,700 10 3.67
TM-DML 1,273,297 1,273,209 20 5 8 1,538.00
TX-Transaction 926,168 926,147 0 1,887 1 0.69
DV-Diana Versioning 15,571 15,571 0 182 1 6.54
SQ-Sequence Cache 32,213 32,213 0 3,075 1 0.27
TX-Transaction (allocate ITL entry) 190 190 0 112 0 2.50
FB-Format Block 34,282 34,281 0 659 0 0.33
PS-PX Process Reservation 3,728 3,088 640 31 0 0.00
CU-Cursor 5,675 5,674 0 2 0 0.00

Back to Wait Statistics
Back to Top

Undo Statistics

Back to Top

Undo Segment Summary

Undo TS#Num Undo Blocks (K)Number of TransactionsMax Qry Len (s)Max Tx ConcurcyMin/Max TR (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
1 1,427.15 920,319 2,680 192 216.6/551.4 0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

End TimeNum Undo BlocksNumber of TransactionsMax Qry Len (s)Max Tx ConcyTun Ret (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
15-Feb 18:28 187,700 119,429 678 192 228 0/0 0/0/0/0/0/0
15-Feb 18:18 46,125 61,547 524 184 235 0/0 0/0/0/0/0/0
15-Feb 18:08 423,765 135,283 2,501 192 217 0/0 0/0/0/0/0/0
15-Feb 17:58 303,439 192,394 2,680 188 288 0/0 0/0/0/0/0/0
15-Feb 17:48 209,030 211,480 2,206 189 392 0/0 0/0/0/0/0/0
15-Feb 17:38 257,095 200,186 1,676 191 551 0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

Back to Top

Latch Activity

Latch NameGet RequestsPct Get MissAvg Slps /MissWait Time (s)NoWait RequestsPct NoWait Miss
ASM db client latch 2,465 0.00   0 0  
AWR Alerted Metric Element list 177,565 0.00   0 0  
Consistent RBA 572,090 0.02 0.23 0 0  
FOB s.o list latch 37,083 0.01 0.00 0 0  
In memory undo latch 588,957,293 2.44 0.00 2 771,712 0.00
JOX SGA heap latch 1,800,724 0.00   0 0  
JS mem alloc latch 0     0 2 0.00
JS queue state obj latch 21,600 0.00   0 0  
JS slv state obj latch 183 0.00   0 0  
KMG MMAN ready and startup request latch 1,849 0.00   0 0  
KMG resize request state object freelist 10 0.00   0 0  
KTF sga latch 12 0.00   0 1,214 0.00
KWQMN job cache list latch 10,076 0.35 0.86 0 0  
MQL Tracking Latch 0     0 71 0.00
Memory Management Latch 760 0.26 1.00 0 1,844 0.00
OS process 9,099 0.00   0 0  
OS process allocation 7,272 0.00   0 0  
OS process: request allocation 5,759 0.02 0.00 0 0  
PL/SQL warning settings 2,752,009 0.00   0 0  
SGA IO buffer pool latch 70,201 0.00   0 118,440 0.00
SQL memory manager latch 1 0.00   0 1,199 0.00
SQL memory manager workarea list latch 3,909,880 0.01 0.01 0 0  
Shared B-Tree 128 0.00   0 0  
active checkpoint queue latch 455,204 0.00   0 2 0.00
active service list 33,388 0.44 0.00 0 1,240 0.00
alert log latch 0     0 2 0.00
begin backup scn array 155 0.00   0 0  
buffer pool 10 0.00   0 0  
cache buffer handles 19,793,125 1.94 0.00 0 0  
cache buffers chains 3,969,151,456 1.51 0.03 41 14,974,758 2.99
cache buffers lru chain 8,435,257 0.39 0.01 0 29,501,601 0.65
cache table scan latch 1,714 0.00   0 1,714 0.00
channel handle pool latch 200,638 0.05 0.05 0 0  
channel operations parent latch 882,876 0.66 0.00 0 0  
checkpoint queue latch 18,774,578 0.01 0.01 0 2,804,572 0.03
client/application info 932,544 0.00 0.00 0 0  
commit callback allocation 43,000 0.00   0 0  
compile environment latch 1,525,391 0.00   0 0  
dictionary lookup 85 2.35 0.00 0 0  
dml lock allocation 2,537,333 0.24 0.01 0 0  
dummy allocation 11,907 1.60 0.00 0 0  
enqueue hash chains 5,834,070 0.16 0.00 0 735 0.00
enqueues 2,844,792 0.22 0.01 0 0  
error message lists 1,584 3.98 0.00 0 0  
event group latch 2,882 0.00   0 0  
file cache latch 18,502 0.00   0 0  
global KZLD latch for mem in SGA 5,051 0.00   0 0  
global ctx hash table latch 11,433 0.00   0 0  
hash table column usage latch 2,111 0.19 0.00 0 7,757,426 0.00
hash table modification latch 155 0.00   0 2 0.00
internal temp table object number allocation latc 3 0.00   0 0  
job workq parent latch 0     0 122 0.00
job_queue_processes free list latch 0     0 2 0.00
job_queue_processes parameter latch 120 0.00   0 0  
kks stats 18,799 0.03 0.00 0 0  
ksuosstats global area 242 0.00   0 0  
ktm global data 73,003 0.00   0 0  
kwqbsn:qsga 128 0.00   0 0  
lgwr LWN SCN 574,961 0.11 0.03 0 0  
library cache 202,185,781 0.44 0.01 2 14,366 240.69
library cache load lock 7,197 1.00 0.13 0 33 0.00
library cache lock 29,875,169 0.07 0.01 0 0  
library cache lock allocation 802,126 0.01 0.00 0 0  
library cache pin 126,601,447 0.17 0.01 1 19 0.00
library cache pin allocation 286,374 0.00 0.00 0 0  
list of block allocation 384,844 0.02 0.00 0 0  
loader state object freelist 154,828 0.00 0.00 0 0  
longop free list parent 34 0.00   0 34 0.00
message pool operations parent latch 202,818 0.04 0.05 0 0  
messages 3,127,168 0.05 0.03 0 0  
mostly latch-free SCN 629,200 6.44 0.04 1 0  
multiblock read objects 33,066 0.01 0.00 0 2 0.00
ncodef allocation latch 85 0.00   0 0  
object queue header heap 3,843,612 0.01 0.29 0 204,687 0.05
object queue header operation 25,923,407 0.10 0.27 1 9,600 0.00
object stats modification 198,806 0.02 0.00 0 4 0.00
parallel query alloc buffer 23,520 5.07 0.01 0 0  
parallel query stats 912 26.32 0.06 0 0  
parameter table allocation management 12,640 2.84 0.56 0 0  
post/wait queue 673,000 0.05 0.01 0 272,208 0.02
process allocation 5,807 0.07 0.75 0 2,881 0.03
process group creation 5,759 0.00   0 0  
process queue 15,146 1.18 0.00 0 0  
process queue reference 1,331,609 0.07 0.00 0 99,067 0.99
qmn task queue latch 512 0.00   0 0  
query server freelists 13,488 24.11 0.00 0 0  
query server process 16 0.00   0 16 0.00
redo allocation 3,874,558 6.47 0.01 1 90,296,950 2.93
redo copy 0     0 90,598,316 0.03
redo writing 2,529,957 0.02 0.67 0 0  
resmgr group change latch 407,614 0.00   0 0  
resmgr:actses active list 16,929 0.09 1.00 0 0  
resmgr:actses change group 15,927 0.00   0 0  
resmgr:free threads list 11,905 1.68 0.01 0 0  
resmgr:schema config 1 0.00   0 0  
row cache objects 63,824,293 0.21 0.00 0 7,445 0.15
rules engine aggregate statistics 22,121 0.01 0.00 0 0  
rules engine evaluation context statistics 0     0 2 0.00
rules engine rule set statistics 73,178 0.01 0.14 0 0  
rules engine rule statistics 28,939 0.00   0 0  
sequence cache 15,098,425 0.96 0.00 0 0  
session allocation 12,201,028 0.65 0.02 1 0  
session idle bit 50,280,547 0.02 0.03 0 0  
session state list latch 32,063 0.41 0.03 0 0  
session switching 7,179 0.01 0.00 0 0  
session timer 1,241 0.00   0 0  
shared pool 4,962,604 0.19 0.03 0 0  
shared pool sim alloc 288 0.00   0 0  
shared pool simulator 1,578,036 0.00 0.04 0 0  
sim partition latch 1 0.00   0 20,473 0.10
simulator lru latch 690 0.00   0 0  
slave class 1 0.00   0 0  
slave class create 4 0.00   0 0  
sort extent pool 684,630 0.10 0.01 0 0  
state object free list 12 0.00   0 0  
statistics aggregation 84 0.00   0 0  
temp lob duration state obj allocation 166 0.00   0 0  
temporary table state object allocation 6,432 0.00   0 0  
threshold alerts latch 607 0.00   0 0  
trace latch 24 0.00   0 0  
transaction allocation 58,879 0.00   0 0  
transaction branch allocation 85 0.00   0 0  
undo global data 731,508,388 2.02 0.00 1 23,645 0.04
user lock 20,304 0.00   0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
cache buffers chains 3,969,151,456 60,084,929 1,519,998 58,618,249 0 0 0
undo global data 731,508,388 14,797,935 7,305 14,791,422 0 0 0
In memory undo latch 588,957,293 14,376,042 17,199 14,361,177 0 0 0
library cache 202,185,781 888,423 5,625 883,385 0 0 0
cache buffer handles 19,793,125 384,592 214 384,404 0 0 0
redo allocation 3,874,558 250,665 2,057 248,967 0 0 0
library cache pin 126,601,447 214,434 1,659 212,926 0 0 0
sequence cache 15,098,425 144,870 101 144,783 0 0 0
row cache objects 63,824,293 136,164 508 135,677 0 0 0
session allocation 12,201,028 79,061 1,315 77,917 0 0 0
mostly latch-free SCN 629,200 40,537 1,729 39,006 0 0 0
cache buffers lru chain 8,435,257 32,613 427 32,198 0 0 0
object queue header operation 25,923,407 27,127 7,237 20,170 0 0 0
library cache lock 29,875,169 19,879 100 19,781 0 0 0
session idle bit 50,280,547 9,714 244 9,471 0 0 0
shared pool 4,962,604 9,524 274 9,269 0 0 0
enqueue hash chains 5,834,070 9,259 28 9,233 0 0 0
enqueues 2,844,792 6,256 50 6,208 0 0 0
dml lock allocation 2,537,333 6,161 35 6,128 0 0 0
channel operations parent latch 882,876 5,827 18 5,810 0 0 0
query server freelists 13,488 3,252 12 3,245 0 0 0
checkpoint queue latch 18,774,578 1,959 18 1,941 0 0 0
messages 3,127,168 1,585 55 1,534 0 0 0
parallel query alloc buffer 23,520 1,193 6 1,187 0 0 0
process queue reference 1,331,609 898 2 490 0 0 0
sort extent pool 684,630 710 7 703 0 0 0
lgwr LWN SCN 574,961 618 19 601 0 0 0
redo writing 2,529,957 598 400 199 0 0 0
object queue header heap 3,843,612 569 166 411 0 0 0
parameter table allocation management 12,640 359 200 176 0 0 0
post/wait queue 673,000 313 2 311 0 0 0
parallel query stats 912 240 14 227 0 0 0
SQL memory manager workarea list latch 3,909,880 230 2 228 0 0 0
resmgr:free threads list 11,905 200 1 199 0 0 0
session state list latch 32,063 133 4 129 0 0 0
Consistent RBA 572,090 110 25 87 0 0 0
channel handle pool latch 200,638 95 5 91 0 0 0
message pool operations parent latch 202,818 85 4 81 0 0 0
library cache load lock 7,197 72 9 63 0 0 0
shared pool simulator 1,578,036 54 2 52 0 0 0
KWQMN job cache list latch 10,076 35 30 5 0 0 0
resmgr:actses active list 16,929 16 16 1 0 0 0
rules engine rule set statistics 73,178 7 1 6 0 0 0
process allocation 5,807 4 3 1 0 0 0
Memory Management Latch 760 2 2 0 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
In memory undo latch kturbk 0 6,667 9,013
In memory undo latch ktiFlush: child 0 5,731 3,786
In memory undo latch kticmt: child 0 3,500 791
In memory undo latch ktichg: child 0 1,132 3,579
In memory undo latch ktiTxnPoolFree 0 149 0
In memory undo latch ktiBRacquire 0 13 0
In memory undo latch ktbgfc 0 2 26
KWQMN job cache list latch kwqmnuji: update job item 0 34 6
Memory Management Latch kmgs_perform_parameter_updates1 0 2 2
SQL memory manager workarea list latch qesmmIRegisterWorkArea 0 1 4
SQL memory manager workarea list latch qesmmIUnRegisterWorkArea 0 1 0
active service list ksws_event: ksws event 0 1 1
cache buffer handles kcbzgs 0 142 118
cache buffer handles kcbzfs 0 72 98
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 1,689,228 1,969,473
cache buffers chains kcbchg: kslbegin: call CR func 0 696,317 1,272,097
cache buffers chains kcbgtcr: fast path 0 619,344 28,572
cache buffers chains kcbgtcr: kslbegin excl 0 175,338 94,158
cache buffers chains kcbzgb: scan from tail. nowait 0 135,375 0
cache buffers chains kcbrls: kslbegin 0 76,042 122,603
cache buffers chains kcbgcur: kslbegin 0 44,709 23,068
cache buffers chains kcbget: pin buffer 0 24,777 8,913
cache buffers chains kcbget: exchange 0 13,196 16,221
cache buffers chains kcbget: exchange rls 0 13,136 13,255
cache buffers chains kcbzwb 0 9,048 7,313
cache buffers chains kcbcge 0 4,207 7,855
cache buffers chains kcbnlc 0 1,157 1,264
cache buffers chains kcbso1: set no access 0 315 118
cache buffers chains kcbgtcr: kslbegin shared 0 105 97
cache buffers chains kcbesc: escalate 0 87 52
cache buffers chains kcb_is_private 0 84 1,147
cache buffers chains kcb_pre_apply: kcbhq61 0 50 1,122
cache buffers chains kcb_post_apply: kcbhq63 0 48 207
cache buffers chains kcbnew: new latch again 0 42 2
cache buffers chains kcbbxsv 0 23 10
cache buffers chains kcbbic2 0 7 7
cache buffers chains kcb_post_apply: kcbhq62 0 6 204
cache buffers chains kcbbic1 0 1 6
cache buffers chains kcbgtcr 0 1 0
cache buffers chains kcbrlb1 0 1 3
cache buffers chains kcbzhngcbk1: get hash chain latch no wait 0 1 0
cache buffers chains kcbzib: exchange rls 0 1 1
cache buffers lru chain kcbzgws 0 218 0
cache buffers lru chain kcbo_link_q 0 123 8
cache buffers lru chain kcbgtcr:CR Scan:KCBRSKIP 0 37 0
cache buffers lru chain kcbbxsv: move to being written 0 17 125
cache buffers lru chain kcbzgb: posted for free bufs 0 14 116
cache buffers lru chain kcbo_ivd_proc 0 5 54
cache buffers lru chain kcbbic2 0 4 81
cache buffers lru chain kcbzswcu 0 4 34
cache buffers lru chain kcbzib 0 3 0
cache buffers lru chain kcbzar: KSLNBEGIN 0 1 0
cache buffers lru chain kcbzgpwb: KSLBEGIN use prewarm buffers 0 1 16
channel handle pool latch ksrchconnect() 0 10 11
channel handle pool latch ksrchdelete() 0 2 1
channel operations parent latch ksrchdelete() 0 8 8
channel operations parent latch ksrmfree() 0 7 3
channel operations parent latch ksrapublish() 0 6 0
channel operations parent latch ksrchconnect() 0 5 5
channel operations parent latch ksrsconsume() 0 4 8
channel operations parent latch ksrwait() 0 2 15
checkpoint queue latch kcbbwthc: thread checkpoint buffers 0 14 2
checkpoint queue latch kcbklbc: Link buffer into ckpt queue 0 4 0
dml lock allocation ktaiam 0 18 26
dml lock allocation ktaidm 0 17 9
enqueue hash chains ksqrcl 0 15 7
enqueue hash chains ksqgtl3 0 12 12
enqueue hash chains ksqcmi: get hash chain latch after wait 0 1 9
enqueues ksqies 0 20 34
enqueues ksqgel: create enqueue 0 18 11
enqueues ksqdel 0 12 5
lgwr LWN SCN kcs023 0 444 0
library cache kglpndl: child: after processing 0 2,159 153
library cache kglpnp: child 0 2,028 2,754
library cache kglobpn: child: 0 536 834
library cache kglpndl: child: before processing 0 305 1,491
library cache kglScanDependency 0 166 0
library cache kglLockCursor 0 130 165
library cache kglpin 0 49 25
library cache kgldte: child 0 0 44 74
library cache kglhdgn: child: 0 38 80
library cache kglhdiv0: child 0 24 0
library cache kgldti: 2child 0 19 6
library cache kglic 0 19 0
library cache kglhdiv0: parent: invalidate 0 13 9
library cache kglhdgc: child: 0 7 3
library cache kglivl: child 0 3 0
library cache kglupd: child 0 2 0
library cache kgldrp: child 0 1 0
library cache kglhdiv: child 0 1 18
library cache load lock kglllal: llatch: in loop 0 7 9
library cache load lock kglllal: llatch 0 2 0
library cache lock kgllkdl: child: cleanup 0 67 62
library cache lock kgllkdl: child: no lock handle 0 35 10
library cache lock kgllkal: child: multiinstance 0 33 38
library cache pin kglpndl 0 772 500
library cache pin kglpnp: child 0 763 918
library cache pin kglpnal: child: alloc space 0 124 241
message pool operations parent latch ksrmalloc() 0 4 6
message pool operations parent latch ksrmfree() 0 3 3
messages ksaamb: after wakeup 0 28 45
messages ksarcv 0 15 8
messages ksarcv: after wait 0 12 2
mostly latch-free SCN kcslcu3 0 1,286 1,748
mostly latch-free SCN kcs024 0 19 0
mostly latch-free SCN kcsnew_scn_rba 0 13 0
mostly latch-free SCN kcs01 0 12 25
object queue header heap kcbo_link_q:reget 0 163 2
object queue header heap kcbw_link_q:alloc 0 3 166
object queue header operation kcbo_ivbo 0 8,267 924
object queue header operation kcbw_link_q 0 1,888 611
object queue header operation kcbw_unlink_q 0 318 1,735
object queue header operation kcbo_switch_q_bg 0 91 942
object queue header operation kcbo_switch_mq_bg 0 88 1,225
object queue header operation kcbo_switch_cq 0 61 1,190
object queue header operation kcbo_link_q:reget 0 29 44
object queue header operation kcbo_service_ockpt 0 7 0
object queue header operation kcbo_swap_buf 0 6 272
object queue header operation kcbo_swap_buf_bg 0 6 3,935
object queue header operation kcbo_write_q 0 2 0
parallel query alloc buffer kxfpbfre 0 5 3
parallel query alloc buffer kxfpbalo 0 1 3
parallel query stats kxfprst: KSLBEGIN:1 0 14 14
parameter table allocation management ksp_param_table_free 0 200 200
post/wait queue ksliwat:remove 0 2 0
process allocation ksucrp 0 2 0
process allocation ksudlp 0 1 4
process queue reference kxfpqrsnd 0 2 0
query server freelists kxfpobadf 0 10 10
query server freelists kxfpobrmf 0 2 2
redo allocation kcrfw_redo_gen: redo allocation 1 0 1,172 0
redo allocation kcrfw_redo_gen: redo allocation 3 0 474 1,949
redo allocation kcrfw_redo_gen: redo allocation 2 0 186 0
redo allocation kcrfw_redo_write: more space 0 114 52
redo allocation kcrfw_redo_write: before write 0 108 57
redo writing kcrfw_post: after write 0 314 0
redo writing kcrfw_post: rba scn pair 0 79 0
redo writing kcrfw_cal_target_rba 0 7 0
resmgr:actses active list kgskchclass 0 16 9
resmgr:free threads list kgskthrcreate 0 1 0
row cache objects kqreqd: reget 0 392 4
row cache objects kqrpre: find obj 0 83 372
row cache objects kqreqd 0 29 130
row cache objects kqrso 0 1 1
rules engine rule set statistics kwrsoef: find ectx stats 0 1 0
sequence cache kdnssd 0 75 10
sequence cache kdnnxt: cached seq 0 23 1
sequence cache kdnss 0 3 91
session allocation ksuxds: KSUSFCLC not set 0 631 327
session allocation ksursi 0 186 379
session allocation kxfprdp 0 99 39
session allocation ksuprc 0 96 107
session allocation kxfpqidqr 0 95 146
session allocation ksudlc 0 68 149
session allocation ksucri 0 62 103
session allocation ksuxds: not user session 0 62 59
session allocation ksudlp 0 10 7
session allocation kspallmod 0 5 0
session allocation ksusin 0 1 2
session idle bit ksupuc: set busy 0 220 100
session idle bit ksupuc: clear busy 0 100 213
session idle bit ksuxds 0 8 15
session state list latch kpseqd 0 4 0
shared pool kghalo 0 137 72
shared pool kghupr1 0 105 162
shared pool kghfrunp: clatch: nowait 0 44 0
shared pool kghfrunp: alloc: wait 0 16 0
shared pool kghfre 0 9 29
shared pool kghalp 0 6 10
shared pool kghfrunp: clatch: wait 0 5 1
shared pool kghfrunp: alloc: cursor dur 0 1 0
shared pool simulator kglsim_unpin_simhp 0 2 2
sort extent pool ktstdt: dealloc sort extent 0 6 0
sort extent pool ktstsmonmsg 0 1 8
undo global data kturimugur: child 0 6,092 4,896
undo global data ktudba: KSLBEGIN 0 1,168 2,394
undo global data ktucof: at start 0 14 0
undo global data ktudnx:child 0 13 3
undo global data ktubnd:child 0 7 4
undo global data ktusmasp: ktugd_tuux 0 6 1
undo global data ktufrbs: child 0 2 6

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

OwnerTablespace NameObject NameSubobject NameObj. TypeLogical Reads%Total
AR APPS_TS_TX_INTERFACE RA_INTERFACE_LINES_ALL   TABLE 64,754,096 3.86
APPLSYS APPS_TS_SEED WF_EVENTS_U1   INDEX 37,509,792 2.24
APPLSYS APPS_TS_SEED WF_EVENTS   TABLE 37,434,336 2.23
APPLSYS APPS_TS_SEED WF_EVENT_SUBSCRIPTIONS   TABLE 31,756,176 1.89
WSH APPS_TS_TX_DATA WSH_DELIVERY_DETAILS   TABLE 24,218,432 1.44

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
GL APPS_ASSM_DATA GL_JE_LINES   TABLE 35,090 8.73
AR APPS_ASSM_DATA RA_CUSTOMER_TRX_LINES_ALL   TABLE 13,030 3.24
WSH APPS_TS_TX_DATA WSH_DELIVERY_DETAILS   TABLE 9,554 2.38
HR APPS_TS_TX_DATA PAY_ASSIGNMENT_LATEST_BALANCES   TABLE 6,366 1.58
HR APPS_TS_TX_IDX PAY_PERSON_LATEST_BALA_N50   INDEX 4,777 1.19

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
APPLSYS APPS_TS_TX_IDX WF_ITEM_ACTIVITY_STATUSES_N1   INDEX 13,637 29.93
WSH APPS_TS_TX_DATA WSH_TRIP_STOPS   TABLE 10,623 23.32
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_U1   INDEX 10,112 22.19
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N6   INDEX 2,896 6.36
HR APPS_ASSM_IDX PAY_RUN_RESULT_VALUES_PK   INDEX 1,758 3.86

Back to Segment Statistics
Back to Top

Segments by ITL Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeITL Waits% of Capture
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N6   INDEX 21 28.77
GL APPS_ASSM_IDX GL_IMPORT_REFERENCES_N1   INDEX 14 19.18
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N5   INDEX 7 9.59
APPLSYS APPS_TS_TX_IDX WF_ITEM_ATTRIBUTE_VALUES_PK   INDEX 6 8.22
GL APPS_ASSM_IDX GL_IMPORT_REFERENCES_N3   INDEX 4 5.48

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_U1   INDEX 187,312 40.96
APPLSYS APPS_TS_TX_DATA WF_ITEM_ATTRIBUTE_VALUES   TABLE 86,689 18.96
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N6   INDEX 22,724 4.97
GL APPS_ASSM_DATA GL_JE_LINES   TABLE 19,924 4.36
SYS SYSTEM DBMS_LOCK_ALLOCATED   TABLE 16,636 3.64

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control 6 0.00 0   2 1
dc_constraints 648 47.07 0   648 169
dc_files 6,660 0.00 0   0 111
dc_global_oids 3,665,839 0.00 0   0 51
dc_histogram_data 3,820 2.07 0   0 765
dc_histogram_defs 238,642 3.40 0   4,042 8,550
dc_object_grants 34,620 0.09 0   0 248
dc_object_ids 6,241,907 0.01 0   57 2,692
dc_objects 97,211 1.15 0   345 1,594
dc_profiles 5,112 0.00 0   0 1
dc_rollback_segments 18,896 0.06 0   33 194
dc_segments 204,444 0.53 0   13,992 1,968
dc_sequences 40,696 0.08 0   40,696 127
dc_table_scns 13,890 0.06 0   0 5
dc_tablespace_quotas 13,821 0.15 0   208 55
dc_tablespaces 3,269,238 0.00 0   0 22
dc_usernames 254,704 0.00 0   0 23
dc_users 7,413,316 0.00 0   0 69
outstanding_alerts 270 0.74 0   3 43


Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY 333,877 0.03 24,017,148 -0.02 8 0
CLUSTER 75 0.00 178 0.56 1 0
INDEX 7,497 0.73 8,310 1.12 9 0
JAVA DATA 614 0.00 0   0 0
PIPE 24,495 2.55 35,682 1.69 0 0
SQL AREA 4,663 91.31 72,692,129 0.44 1,787 323
TABLE/PROCEDURE 213,666 0.39 33,856,776 -0.03 521 0
TRIGGER 15,221 0.14 1,139,755 0.00 10 0


Back to Top

Memory Statistics

Back to Top

Process Memory Summary

CategoryAlloc (MB)Used (MB)Avg Alloc (MB)Std Dev Alloc (MB)Max Alloc (MB)Hist Max Alloc (MB)Num ProcNum Alloc
B Other 17,248.85   10.70 6.50 35 35 1,612 1,612
  SQL 1,647.49 842.20 1.03 0.69 4 21 1,606 1,604
  Freeable 1,520.56 0.00 1.13 0.75 9   1,345 1,345
  PL/SQL 1,099.97 97.01 0.68 0.91 3 3 1,612 1,612
  JAVA 125.46 124.99 2.24 0.43 5 8 56 56
E Other 22,111.33   13.67 8.50 56 56 1,617 1,617
  Freeable 2,140.38 0.00 1.51 0.93 9   1,414 1,414
  SQL 2,034.68 1,064.76 1.26 0.78 5 21 1,611 1,609
  PL/SQL 1,344.38 113.01 0.83 0.96 3 3 1,617 1,617
  JAVA 125.08 124.61 2.23 0.42 5 8 56 56

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers 19,277,021,184 19,193,135,104
Fixed Size 2,111,120  
Redo Buffers 14,663,680  
Variable Size 2,181,040,496 2,264,926,576

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
java free memory 51.29 51.29 0.00
java joxlod exec hp 12.09 12.09 0.00
large PX msg pool 0.49 0.49 0.00
large free memory 15.51 15.51 0.00
shared ASH buffers 29.00 29.00 0.00
shared CCursor 35.51 38.46 8.29
shared Heap0: KGL 20.16 22.95 13.86
shared KGLS heap 48.56   -100.00
shared KTI-UNDO 44.33 44.33 0.00
shared PCursor 22.33 24.87 11.38
shared PL/SQL MPCODE 67.84 70.87 4.46
shared db_block_hash_buckets 180.00 180.00 0.00
shared event statistics per sess 52.73 52.73 0.00
shared free memory 389.02 293.29 -24.61
shared library cache 419.67 529.13 26.08
shared parameter table block 28.80 28.91 0.38
shared private strands 83.14 83.14 0.00
shared sessions 30.35 30.35 0.00
shared sql area 311.53 417.21 33.92
shared trace buffer 25.25 25.63 1.49
  buffer_cache 18,384.00 18,304.00 -0.44
  fixed_sga 2.01 2.01 0.00
  log_buffer 13.98 13.98 0.00

Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.


Back to Top

init.ora Parameters

Parameter NameBegin valueEnd 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 /DB/oracle/product/10.2.0/db_1/admin/VIS/bdump   
compatible 10.2.0.3   
control_files /DB/visdata/cntrl01.dbf, /DB/visdata/cntrl02.dbf, /DB/visdata/cntrl03.dbf   
core_dump_dest /DB/oracle/product/10.2.0/db_1/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_files 130   
db_name VIS   
db_writer_processes 1   
dml_locks 10000   
fast_start_mttr_target 180   
java_pool_size 67108864   
job_queue_processes 2   
lock_sga FALSE   
log_buffer 14219264   
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 /DB/oracle/product/10.2.0/db_1/native   
plsql_native_library_subdir_count 300   
plsql_optimize_level 2   
processes 3000   
remote_login_passwordfile EXCLUSIVE   
replication_dependency_tracking FALSE   
session_cached_cursors 500   
sessions 6000   
sga_target 21474836480   
shared_pool_reserved_size 209715200   
shared_pool_size 2097152000   
timed_statistics TRUE   
trace_enabled FALSE   
undo_management AUTO   
undo_tablespace APPS_UNDOTS1   
user_dump_dest /DB/oracle/product/10.2.0/db_1/admin/VIS/udump   
utl_file_dir /usr/tmp   
workarea_size_policy AUTO   


Back to Top

End of Report