WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
VIS210556022VIS110.2.0.3.0NOdb1.oasb.cisco

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:131-Jul-10 14:46:18103 28.8
End Snap:831-Jul-10 15:05:15107 24.7
Elapsed:  18.94 (mins)  
DB Time:  135.89 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 19,360M 19,280MStd Block Size: 8K
Shared Pool Size: 2,048M 2,048MLog Buffer: 63,468K

Load Profile

Per SecondPer Transaction
Redo size: 14,273,847.18 26,304.15
Logical reads: 1,059,482.71 1,952.44
Block changes: 84,463.01 155.65
Physical reads: 63.45 0.12
Physical writes: 951.01 1.75
User calls: 170.71 0.31
Parses: 1,761.20 3.25
Hard parses: 3.46 0.01
Sorts: 4,618.16 8.51
Logons: 0.48 0.00
Executes: 40,505.92 74.65
Transactions: 542.65 

% Blocks changed per Read: 7.97Recursive Call %: 99.77
Rollback per transaction %: 0.06Rows per Sort: 3.30

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.87Redo NoWait %: 100.00
Buffer Hit %: 100.00In-memory Sort %: 100.00
Library Hit %: 99.98Soft Parse %: 99.80
Execute to Parse %: 95.65Latch Hit %: 97.93
Parse CPU to Parse Elapsd %: 23.58% Non-Parse CPU: 99.64

Shared Pool Statistics

BeginEnd
Memory Usage %: 21.84 36.37
% SQL with executions>1: 54.25 86.37
% Memory for SQL w/exec>1: 61.11 90.35

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
CPU time  7,517  92.2 
log file parallel write 396,355 193 0 2.4System I/O
db file parallel write 81,587 169 2 2.1System I/O
log file sync 173,814 151 1 1.9Commit
library cache load lock 6,612 132 20 1.6Concurrency

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
sql execute elapsed time 8,138.98 99.83
DB CPU 7,516.65 92.19
PL/SQL execution elapsed time 2,349.48 28.82
Java execution elapsed time 520.94 6.39
parse time elapsed 148.49 1.82
hard parse elapsed time 41.34 0.51
sequence load elapsed time 8.44 0.10
PL/SQL compilation elapsed time 3.95 0.05
repeated bind elapsed time 3.18 0.04
connection management call elapsed time 1.21 0.01
hard parse (sharing criteria) elapsed time 0.57 0.01
hard parse (bind mismatch) elapsed time 0.13 0.00
inbound PL/SQL rpc elapsed time 0.03 0.00
failed parse elapsed time 0.01 0.00
DB time 8,153.17  
background elapsed time 426.02  
background cpu time 68.60  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
System I/O 490,078 0.00 365 1 0.79
Concurrency 1,917,761 0.00 235 0 3.11
Commit 173,814 0.00 151 1 0.28
User I/O 34,897 0.00 113 3 0.06
Application 31,475 0.00 76 2 0.05
Configuration 34,884 0.06 64 2 0.06
Other 155,141 56.80 45 0 0.25
Network 323,112 0.00 1 0 0.52

Back to Wait Events Statistics
Back to Top

Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
log file parallel write 396,355 0.00 193 0 0.64
db file parallel write 81,587 0.00 169 2 0.13
log file sync 173,814 0.00 151 1 0.28
library cache load lock 6,612 0.00 132 20 0.01
enq: TX - row lock contention 20,281 0.00 76 4 0.03
db file sequential read 20,558 0.00 71 3 0.03
enq: TX - allocate ITL entry 838 2.39 58 70 0.00
library cache pin 3,490 0.00 48 14 0.01
buffer busy waits 1,604,830 0.00 37 0 2.60
kksfbc child completion 822 86.25 35 43 0.00
read by other session 5,617 0.00 26 5 0.01
enq: TX - index contention 17,154 0.00 12 1 0.03
db file scattered read 1,395 0.00 10 7 0.00
enq: HW - contention 16,273 0.00 5 0 0.03
direct path write temp 3,554 0.00 5 1 0.01
enq: TX - contention 14,667 0.00 4 0 0.02
latch: cache buffers chains 273,025 0.00 3 0 0.44
buffer deadlock 88,433 98.81 2 0 0.14
control file sequential read 11,606 0.00 2 0 0.02
row cache lock 4,029 0.00 2 1 0.01
LGWR wait for redo copy 45,236 0.00 1 0 0.07
direct path read temp 3,550 0.00 1 0 0.01
enq: SQ - contention 17,773 0.00 1 0 0.03
PX Deq Credit: send blkd 1,674 0.00 1 0 0.00
SQL*Net more data to client 148,268 0.00 1 0 0.24
SQL*Net break/reset to client 11,188 0.00 0 0 0.02
control file parallel write 530 0.00 0 1 0.00
enq: FB - contention 2,924 0.00 0 0 0.00
latch free 578 0.00 0 1 0.00
latch: library cache 1,573 0.00 0 0 0.00
os thread startup 24 0.00 0 12 0.00
latch: In memory undo latch 4,714 0.00 0 0 0.01
PX Deq: Signal ACK 12 33.33 0 8 0.00
SGA: allocation forcing component growth 9 33.33 0 11 0.00
SQL*Net message to client 167,874 0.00 0 0 0.27
enq: CU - contention 7 0.00 0 9 0.00
enq: RO - fast object reuse 6 0.00 0 9 0.00
direct path write 196 0.00 0 0 0.00
latch: library cache pin 442 0.00 0 0 0.00
SQL*Net more data from client 6,970 0.00 0 0 0.01
latch: shared pool 194 0.00 0 0 0.00
latch: redo allocation 293 0.00 0 0 0.00
wait list latch free 3 0.00 0 11 0.00
L1 validation 10 30.00 0 3 0.00
cursor: mutex S 763 0.00 0 0 0.00
latch: row cache objects 135 0.00 0 0 0.00
latch: undo global data 212 0.00 0 0 0.00
cursor: mutex X 757 0.00 0 0 0.00
latch: session allocation 136 0.00 0 0 0.00
latch: enqueue hash chains 56 0.00 0 0 0.00
local write wait 11 0.00 0 1 0.00
reliable message 6 0.00 0 0 0.00
latch: library cache lock 19 0.00 0 0 0.00
latch: object queue header operation 5 0.00 0 0 0.00
latch: cache buffers lru chain 12 0.00 0 0 0.00
direct path read 16 0.00 0 0 0.00
latch: messages 2 0.00 0 0 0.00
enq: PS - contention 5 0.00 0 0 0.00
PX qref latch 36 61.11 0 0 0.00
rdbms ipc reply 1 0.00 0 0 0.00
latch: cache buffer handles 2 0.00 0 0 0.00
SQL*Net message from client 167,869 0.00 67,713 403 0.27
PX Idle Wait 6,341 98.25 12,199 1924 0.01
Streams AQ: waiting for time management or cleanup tasks 829 3.98 5,145 6206 0.00
Streams AQ: waiting for messages in the queue 604 98.34 4,454 7374 0.00
pipe get 795 100.00 3,326 4184 0.00
Streams AQ: qmn slave idle wait 541 0.18 2,815 5204 0.00
PL/SQL lock timer 245 97.96 1,158 4725 0.00
Streams AQ: qmn coordinator idle wait 529 32.70 1,108 2094 0.00
PX Deq: Execution Msg 1,357 0.00 6 5 0.00
PX Deq Credit: need buffer 620 0.00 0 0 0.00
PX Deq: Execute Reply 546 0.00 0 0 0.00
PX Deq: Msg Fragment 1,028 0.00 0 0 0.00
PX Deq: Table Q Normal 385 0.00 0 0 0.00
PX Deq: Parse Reply 47 0.00 0 0 0.00
PX Deq: Join ACK 78 0.00 0 0 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 396,355 0.00 193 0 0.64
db file parallel write 81,587 0.00 169 2 0.13
events in waitclass Other 45,534 0.00 1 0 0.07
control file parallel write 530 0.00 0 1 0.00
control file sequential read 228 0.00 0 0 0.00
buffer busy waits 29 0.00 0 0 0.00
latch: cache buffers chains 8 0.00 0 0 0.00
latch: library cache 5 0.00 0 0 0.00
latch: In memory undo latch 3 0.00 0 0 0.00
enq: TX - index contention 1 0.00 0 0 0.00
latch: library cache pin 2 0.00 0 0 0.00
db file sequential read 92 0.00 -0 -2 0.00
rdbms ipc message 284,254 1.49 10,675 38 0.46
Streams AQ: waiting for time management or cleanup tasks 829 3.98 5,145 6206 0.00
Streams AQ: qmn slave idle wait 312 0.00 1,714 5494 0.00
Streams AQ: qmn coordinator idle wait 529 32.70 1,108 2094 0.00
smon timer 3,976 0.00 1,107 279 0.01
pmon timer 405 99.75 1,107 2734 0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
BUSY_TIME 775,660
IDLE_TIME 1,949,177
IOWAIT_TIME 32,132
NICE_TIME 0
SYS_TIME 20,118
USER_TIME 754,520
LOAD 1
RSRC_MGR_CPU_WAIT_TIME 0
PHYSICAL_MEMORY_BYTES 21,798,880
NUM_CPUS 24
NUM_CPU_SOCKETS 2

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical ReadsLogical Reads
VIS 8,117.50 7,496.00 70,693 1,198,708,354
SYS$USERS 30.60 15.90 1,294 3,052,088
SYS$BACKGROUND 0.00 0.00 266 2,404,637

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
VIS 31718 10053 1917694 23487 0 0 321681 67
SYS$USERS 2919 1214 19 0 0 0 71 0
SYS$BACKGROUND 266 43 48 1 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
2,297 2,169 24 95.71 28.17 4y08a52989vfk WSHPSGL_SUB BEGIN WSH_PICK_LIST.RELEASE_BA...
2,291 2,107 12 190.94 28.10 8zfgv4ck11dw9 FNDWFBG BEGIN WF_ENGINE.BACKGROUNDCONC...
1,242 1,218 100 12.42 15.24 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
946 834 14 67.59 11.61 72yyswsqkzkrm OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
683 667 49,986 0.01 8.38 9wdrypwkpf607 FNDWFBG begin OE_FULFILL_WF.START_FULF...
405 361 14 28.93 4.97 0074pdmwb7fmv WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
395 374 49,925 0.01 4.85 gksvm8wmzk8w0 FNDWFBG begin OE_INVOICE_WF.INVOICE_IN...
301 296 49,989 0.01 3.69 4yak7x2zqz0dh WSHPSGL_SUB BEGIN inv_transfer_order_pvt.f...
266 249 149,858 0.00 3.26 3b3psftuyks81 WSHPSGL_SUB BEGIN INV_TXNSTUB_PUB.postTran...
238 237 49,951 0.00 2.92 gnng1rmpjxzsx FNDWFBG begin OE_CLOSE_WF.CLOSE_LINE (...
206 205 204,743 0.00 2.53 0r0gvtarcjwzz WSHINTERFACES insert into "ASO"."ASO_ORDER_F...
184 184 354,914 0.00 2.26 cdjud36xbtuu5 OEHVIMP SELECT WIAS.PROCESS_ACTIVITY, ...
178 175 49,955 0.00 2.18 assndb4wqnd6r INCTCW BEGIN INV_TXN_MANAGER_PUB.rel_...
172 169 2,816,951 0.00 2.10 66tmsr3446uqn SQL*Plus SELECT WIAS.ACTIVITY_STATUS, ...
137 131 3 45.83 1.69 1wnq9qthbb54q WSHPSRS BEGIN WSH_PICK_LIST.RELEASE_BA...
129 119 24 5.36 1.58 7ptvbaycjtbg4 ARTERRPW BEGIN arp_run.revenue_recognit...
128 48 112 1.14 1.57 1p2p9fdwaujpv INCTCM update MTL_TRANSACTIONS_INTERF...
120 119 5,516 0.02 1.47 8yucb2j07mns1 WSHPSGL_SUB DECLARE l_count number; ...
109 103 1,689,188 0.00 1.34 cd9mbmqyf4qhp OEHVIMP UPDATE WF_ITEM_ACTIVITY_STATUS...
105 105 599,799 0.00 1.29 52zwqr7xyrc2m WSHPSGL_SUB SELECT 'Y' FROM WSH_PR_WORKERS...
104 101 54,987 0.00 1.28 g8102j8yynbwz OEHVIMP begin WF_STANDARD.CONTINUEFLOW...
98 98 4,998 0.02 1.21 54tkzbnhn8gap WSHPSGL_SUB DELETE FROM MTL_SERIAL_NUMBERS...
97 95 2 48.43 1.19 cqc8bmqp529tz RAXTRX begin arp_etax_autoinv_util . ...
84 81 149,990 0.00 1.03 0mdnts20d60yr WSHPSGL_SUB declare v_ret number := 0...

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
2,169 2,297 24 90.39 28.17 4y08a52989vfk WSHPSGL_SUB BEGIN WSH_PICK_LIST.RELEASE_BA...
2,107 2,291 12 175.60 28.10 8zfgv4ck11dw9 FNDWFBG BEGIN WF_ENGINE.BACKGROUNDCONC...
1,218 1,242 100 12.18 15.24 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
834 946 14 59.58 11.61 72yyswsqkzkrm OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
667 683 49,986 0.01 8.38 9wdrypwkpf607 FNDWFBG begin OE_FULFILL_WF.START_FULF...
374 395 49,925 0.01 4.85 gksvm8wmzk8w0 FNDWFBG begin OE_INVOICE_WF.INVOICE_IN...
361 405 14 25.81 4.97 0074pdmwb7fmv WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
296 301 49,989 0.01 3.69 4yak7x2zqz0dh WSHPSGL_SUB BEGIN inv_transfer_order_pvt.f...
249 266 149,858 0.00 3.26 3b3psftuyks81 WSHPSGL_SUB BEGIN INV_TXNSTUB_PUB.postTran...
237 238 49,951 0.00 2.92 gnng1rmpjxzsx FNDWFBG begin OE_CLOSE_WF.CLOSE_LINE (...
205 206 204,743 0.00 2.53 0r0gvtarcjwzz WSHINTERFACES insert into "ASO"."ASO_ORDER_F...
184 184 354,914 0.00 2.26 cdjud36xbtuu5 OEHVIMP SELECT WIAS.PROCESS_ACTIVITY, ...
175 178 49,955 0.00 2.18 assndb4wqnd6r INCTCW BEGIN INV_TXN_MANAGER_PUB.rel_...
169 172 2,816,951 0.00 2.10 66tmsr3446uqn SQL*Plus SELECT WIAS.ACTIVITY_STATUS, ...
131 137 3 43.70 1.69 1wnq9qthbb54q WSHPSRS BEGIN WSH_PICK_LIST.RELEASE_BA...
119 129 24 4.96 1.58 7ptvbaycjtbg4 ARTERRPW BEGIN arp_run.revenue_recognit...
119 120 5,516 0.02 1.47 8yucb2j07mns1 WSHPSGL_SUB DECLARE l_count number; ...
105 105 599,799 0.00 1.29 52zwqr7xyrc2m WSHPSGL_SUB SELECT 'Y' FROM WSH_PR_WORKERS...
103 109 1,689,188 0.00 1.34 cd9mbmqyf4qhp OEHVIMP UPDATE WF_ITEM_ACTIVITY_STATUS...
101 104 54,987 0.00 1.28 g8102j8yynbwz OEHVIMP begin WF_STANDARD.CONTINUEFLOW...
98 98 4,998 0.02 1.21 54tkzbnhn8gap WSHPSGL_SUB DELETE FROM MTL_SERIAL_NUMBERS...
95 97 2 47.40 1.19 cqc8bmqp529tz RAXTRX begin arp_etax_autoinv_util . ...
81 84 149,990 0.00 1.03 0mdnts20d60yr WSHPSGL_SUB declare v_ret number := 0...
48 128 112 0.43 1.57 1p2p9fdwaujpv INCTCM update MTL_TRANSACTIONS_INTERF...

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
424,136,542 24 17,672,355.92 35.22 2169.39 2296.95 4y08a52989vfk WSHPSGL_SUB BEGIN WSH_PICK_LIST.RELEASE_BA...
214,594,501 14 15,328,178.64 17.82 834.16 946.29 72yyswsqkzkrm OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
208,621,586 12 17,385,132.17 17.32 2107.20 2291.24 8zfgv4ck11dw9 FNDWFBG BEGIN WF_ENGINE.BACKGROUNDCONC...
133,021,169 354,914 374.80 11.05 183.84 183.90 cdjud36xbtuu5 OEHVIMP SELECT WIAS.PROCESS_ACTIVITY, ...
94,415,211 100 944,152.11 7.84 1218.10 1242.46 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
80,312,673 599,799 133.90 6.67 105.07 105.09 52zwqr7xyrc2m WSHPSGL_SUB SELECT 'Y' FROM WSH_PR_WORKERS...
64,349,785 2,816,951 22.84 5.34 169.21 171.58 66tmsr3446uqn SQL*Plus SELECT WIAS.ACTIVITY_STATUS, ...
57,854,318 14 4,132,451.29 4.80 361.30 405.02 0074pdmwb7fmv WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
40,701,469 2 20,350,734.50 3.38 56.57 56.63 gccbpwamzp78q RAXTRX declare l_header_rounding_flag...
35,561,776 49,989 711.39 2.95 295.62 301.12 4yak7x2zqz0dh WSHPSGL_SUB BEGIN inv_transfer_order_pvt.f...
31,799,538 24 1,324,980.75 2.64 119.04 128.61 7ptvbaycjtbg4 ARTERRPW BEGIN arp_run.revenue_recognit...
29,065,290 309,703 93.85 2.41 56.00 56.57 b73h3md2wvs09 OEHVIMP SELECT C.INSTANCE_ID FROM WF_P...
27,135,053 50,001 542.69 2.25 40.79 40.84 6h228dtb8hp1t WSHPSGL_SUB SELECT X.ORGANIZATION_ID ORGAN...
27,034,774 49,986 540.85 2.24 667.24 683.26 9wdrypwkpf607 FNDWFBG begin OE_FULFILL_WF.START_FULF...
26,502,879 54,987 481.98 2.20 100.53 104.49 g8102j8yynbwz OEHVIMP begin WF_STANDARD.CONTINUEFLOW...
25,759,883 10,002 2,575.47 2.14 30.77 30.81 by2f4fw8tac6r RAXTRX UPDATE RA_CUST_TRX_LINE_GL_DIS...
25,744,196 149,858 171.79 2.14 248.71 265.82 3b3psftuyks81 WSHPSGL_SUB BEGIN INV_TXNSTUB_PUB.postTran...
23,904,780 5,516 4,333.72 1.99 118.65 119.61 8yucb2j07mns1 WSHPSGL_SUB DECLARE l_count number; ...
21,364,659 1,689,188 12.65 1.77 102.65 108.99 cd9mbmqyf4qhp OEHVIMP UPDATE WF_ITEM_ACTIVITY_STATUS...
19,634,758 4,998 3,928.52 1.63 97.86 98.40 54tkzbnhn8gap WSHPSGL_SUB DELETE FROM MTL_SERIAL_NUMBERS...
19,240,957 49,925 385.40 1.60 374.11 395.43 gksvm8wmzk8w0 FNDWFBG begin OE_INVOICE_WF.INVOICE_IN...
18,307,919 2 9,153,959.50 1.52 94.80 96.86 cqc8bmqp529tz RAXTRX begin arp_etax_autoinv_util . ...
17,823,798 3 5,941,266.00 1.48 131.09 137.50 1wnq9qthbb54q WSHPSRS BEGIN WSH_PICK_LIST.RELEASE_BA...
16,335,862 44,806 364.59 1.36 26.42 26.43 6cx4kvh606rwz FNDWFBG SELECT COUNT(1) FROM WF_ITEM_A...
14,562,542 50,000 291.25 1.21 26.91 27.34 fvcbstf9s6a5r OEHVIMP begin WF_STANDARD.WAITFORFLOW ...
13,060,207 99,717 130.97 1.08 22.32 22.32 asqkrtbkjkb9w WSHPSGL_SUB SELECT NVL(TRX_SOURCE_LINE_ID,...
12,719,570 1 12,719,570.00 1.06 71.64 74.62 5t39uchjqpyfm XLAACCUP BEGIN xla_accounting_pkg.unit_...
12,163,764 9,989 1,217.72 1.01 21.47 21.51 f07y7y34utqz1 WSHPSGL_SUB SELECT SEQUENCE_NUMBER FROM WS...

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
36,266 112 323.80 50.29 47.68 128.19 1p2p9fdwaujpv INCTCM update MTL_TRANSACTIONS_INTERF...
8,152 24 339.67 11.30 2169.39 2296.95 4y08a52989vfk WSHPSGL_SUB BEGIN WSH_PICK_LIST.RELEASE_BA...
7,525 3 2,508.33 10.43 131.09 137.50 1wnq9qthbb54q WSHPSRS BEGIN WSH_PICK_LIST.RELEASE_BA...
5,579 1,020 5.47 7.74 7.42 10.01 cvn54b7yz0s8u   select /*+ index(idl_ub1$ i_id...
4,500 14 321.43 6.24 834.16 946.29 72yyswsqkzkrm OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT...
1,737 1 1,737.00 2.41 1.93 3.18 6kcfnxrpx27hw RAXMTR declare Errbuf VARCHAR2 ( 256 ...
1,521 14 108.64 2.11 361.30 405.02 0074pdmwb7fmv WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
1,460 2,611 0.56 2.02 4.13 6.49 cqgv56fmuj63x   select owner#, name, namespace...
1,443 1 1,443.00 2.00 71.64 74.62 5t39uchjqpyfm XLAACCUP BEGIN xla_accounting_pkg.unit_...
1,273 2 636.50 1.77 94.80 96.86 cqc8bmqp529tz RAXTRX begin arp_etax_autoinv_util . ...
1,032 99,659 0.01 1.43 4.01 5.67 1c0b7sas42w2z WSHPSGL_SUB SELECT NVL(ITEM_COST, 0), ...
954 2,611 0.37 1.32 3.12 3.88 8swypbbr0m372   select order#, columns, types ...
836 496 1.69 1.16 0.94 1.52 4g4k54qrsawn6   select /*+ index(idl_ub1$ i_id...
803 100 8.03 1.11 1218.10 1242.46 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
727 1,020 0.71 1.01 2.43 3.10 ga9j9xk5cy9s0   select /*+ index(idl_sb4$ i_id...

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
2,816,951 1,527,785 0.54 0.00 0.00 66tmsr3446uqn SQL*Plus SELECT WIAS.ACTIVITY_STATUS, ...
1,689,188 1,689,141 1.00 0.00 0.00 cd9mbmqyf4qhp OEHVIMP UPDATE WF_ITEM_ACTIVITY_STATUS...
1,344,450 1,344,426 1.00 0.00 0.00 gnhmcahkmrnzs OEHVIMP INSERT INTO WF_ITEM_ACTIVITY_S...
798,541 799,644 1.00 0.00 0.00 0wrz2kbatczjk WSHINTERFACES SELECT EXECUTE_FLAG FROM JTF_U...
599,799 49,986 0.08 0.00 0.00 52zwqr7xyrc2m WSHPSGL_SUB SELECT 'Y' FROM WSH_PR_WORKERS...
419,592 359,835 0.86 0.00 0.00 f34wj84pszqj0 SQL*Plus SELECT WI.ROOT_ACTIVITY, WI.R...
399,245 399,379 1.00 0.00 0.00 7bdg2fscmus2h WSHINTERFACES SELECT ACCOUNTING_RULE_ID , A...
354,914 0 0.00 0.00 0.00 cdjud36xbtuu5 OEHVIMP SELECT WIAS.PROCESS_ACTIVITY, ...
314,900 314,937 1.00 0.00 0.00 94s62xmg4d6a4 OEHVIMP SELECT TO_DATE(TEXT, :B1 ) FR...
309,703 309,605 1.00 0.00 0.00 b73h3md2wvs09 OEHVIMP SELECT C.INSTANCE_ID FROM WF_P...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
199,966 199,978 9.99 fb13x9qx0ftks OEHVIMP begin OE_STANDARD_WF.OEOL_SELE...
199,791 199,797 9.98 ghmx8n7wgqvfr WSHINTERFACES begin WF_STANDARD.DEFER (:v1, ...
149,877 149,990 7.49 0mdnts20d60yr WSHPSGL_SUB declare v_ret number := 0...
99,985 99,659 4.99 1c0b7sas42w2z WSHPSGL_SUB SELECT NVL(ITEM_COST, 0), ...
99,699 99,880 4.98 1v818hwxjxy58 WSHINTERFACES select FND_FLEX_VALUES_VL.FLEX...
59,997 59,984 3.00 bf7uwg5pa3pj6 WSHINTERFACES begin FND_FLEX_WORKFLOW_APIS.V...
59,995 59,992 3.00 dcvv68fju01g4 WSHINTERFACES begin FND_FLEX_WORKFLOW_APIS.E...
59,994 59,948 3.00 76sw2a4vnc89j WSHINTERFACES begin FND_FLEX_WORKFLOW_APIS.S...
59,993 59,991 3.00 608c0n36kaw62 WSHINTERFACES begin FND_FLEX_WORKFLOW_APIS.C...
54,960 54,987 2.75 g8102j8yynbwz OEHVIMP begin WF_STANDARD.CONTINUEFLOW...
50,000 49,998 2.50 7mrs575bj7a41 OEHVIMP begin OE_OEOL_SCH.BRANCH_ON_SO...
50,000 49,999 2.50 bfbyqwbr4vwms OEHVIMP begin OE_OEOL_SCH.SCHEDULE_LIN...
50,000 50,000 2.50 fvcbstf9s6a5r OEHVIMP begin WF_STANDARD.WAITFORFLOW ...
50,000 49,992 2.50 gdnwgx9fcxggr OEHVIMP begin OE_SHIPPING_WF.START_SHI...
49,990 49,983 2.50 cw171rvngr1w9 WSHINTERFACES begin OE_FLEX_COGS_PUB.GET_COS...
49,982 49,949 2.50 bsuw7pmwrufpy INCTCW SELECT reservation_...
49,980 49,925 2.50 gksvm8wmzk8w0 FNDWFBG begin OE_INVOICE_WF.INVOICE_IN...
49,965 49,986 2.50 9wdrypwkpf607 FNDWFBG begin OE_FULFILL_WF.START_FULF...
49,945 49,951 2.49 gnng1rmpjxzsx FNDWFBG begin OE_CLOSE_WF.CLOSE_LINE (...
49,936 49,789 2.49 a40f9h91scg23 WSHINTERFACES select to_char(CODE_COMBINATIO...
49,822 48,737 2.49 7mz96k4qtxrzr WSHPSGL_SUB SELECT BASE.REVISION , BASE.LO...
49,742 49,929 2.48 g2qs4xk48vcwy WSHINTERFACES select to_char(CODE_COMBINATIO...
45,397 45,396 2.27 4m7m0t6fjcs5x   update seq$ set increment$=:2,...
44,998 44,598 2.25 2skwhauh2cwky   select o.name, u.name from ob...
44,997 44,527 2.25 2jfqzrxhrm93b   select /*+ rule */ c.name, u....

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModuleSQL Text
2,026,998 5,591 0.09 fxz0vtz7p7vy2 STANDARD@db1.oasb.cisco (TNS V1-V3) SELECT R.Conc_Login_Id, R.Req...

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
0074pdmwb7fmvBEGIN WSH_SHIP_CONFIRM_ACTIONS.interface_ALL_wrp(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8); END;
0mdnts20d60yr declare v_ret number := 0; begin if (INV_TABLE_LOCK_PVT.lock_onhand_records(:1, :2, :3, :4, :5, :6, :7, :8)) then v_ret := 1; end if; :9 := v_ret; end;
0r0gvtarcjwzzinsert into "ASO"."ASO_ORDER_FEEDBACK_T" (q_name, msgid, corrid, priority, state, delay, expiration, time_manager_info, local_order_no, chain_no, enq_time, step_no, enq_uid, enq_tid, retry_count, exception_qschema, exception_queue, recipient_key, dequeue_msgid, user_data, sender_name, sender_address, sender_protocol, user_prop, cscn, dscn) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, 0, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25)
0wrz2kbatczjkSELECT EXECUTE_FLAG FROM JTF_USER_HOOKS WHERE PKG_NAME = :B4 AND API_NAME = :B3 AND PROCESSING_TYPE = :B2 AND USER_HOOK_TYPE = :B1
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 ;
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
1p2p9fdwaujpvupdate MTL_TRANSACTIONS_INTERFACE MTI set TRANSACTION_HEADER_ID=:b0, LAST_UPDATE_DATE=SYSDATE, LAST_UPDATED_BY=:b1, LAST_UPDATE_LOGIN=:b2, PROGRAM_APPLICATION_ID=:b3, PROGRAM_ID=:b4, REQUEST_ID=:b5, PROGRAM_UPDATE_DATE=SYSDATE, LOCK_FLAG=1, ERROR_CODE=null , ERROR_EXPLANATION=null where (((((PROCESS_FLAG=1 and NVL(LOCK_FLAG, 2)=2) and TRANSACTION_MODE=3) and ROWNUM<=:b6) and exists (select 'X' from MTL_TRANSACTION_TYPES MTT where (MTT.TRANSACTION_TYPE_ID=MTI.TRANSACTION_TYPE_ID and MTT.TRANSACTION_SOURCE_TYPE_ID in (2, 8, 16)))) and exists (select 1 from ORG_ORGANIZATION_DEFINITIONS OOD where (OOD.ORGANIZATION_ID=MTI.ORGANIZATION_ID and NVL(OOD.DISABLE_DATE, (SYSDATE+1))>SYSDATE)))
1v818hwxjxy58select FND_FLEX_VALUES_VL.FLEX_VALUE, FND_FLEX_VALUES_VL.FLEX_VALUE, FND_FLEX_VALUES_VL.DESCRIPTION, FND_FLEX_VALUES_VL.ENABLED_FLAG, to_char(FND_FLEX_VALUES_VL.START_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), to_char(FND_FLEX_VALUES_VL.END_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), FND_FLEX_VALUES_VL.SUMMARY_FLAG, FND_FLEX_VALUES_VL.COMPILED_VALUE_ATTRIBUTES from FND_FLEX_VALUES_VL FND_FLEX_VALUES_VL where (( FND_FLEX_VALUES_VL.FLEX_VALUE_SET_ID = :FND_BIND1) AND ( ((1=1) AND /* GL_COA_BS_TAG */ (GL_AFF_AWC_API_PKG.gl_valid_flex_values(:FND_BIND2, FND_FLEX_VALUES_VL.Flex_Value) = 'Y') ) )) and FND_FLEX_VALUES_VL.FLEX_VALUE = :FND_BIND3
1wnq9qthbb54qBEGIN WSH_PICK_LIST.RELEASE_BATCH_SRS(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5); END;
2jfqzrxhrm93bselect /*+ rule */ c.name, u.name from con$ c, cdef$ cd, user$ u where c.con# = cd.con# and cd.enabled = :1 and c.owner# = u.user#
2skwhauh2cwkyselect o.name, u.name from obj$ o, user$ u where o.obj# = :1 and o.owner# = u.user#
3b3psftuyks81BEGIN INV_TXNSTUB_PUB.postTransaction(:1, :2, :3); END;
4g4k54qrsawn6select /*+ index(idl_ub1$ i_idl_ub11) +*/ piece#, length, piece from idl_ub1$ where obj#=:1 order by piece#
4m7m0t6fjcs5xupdate seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1
4y08a52989vfkBEGIN WSH_PICK_LIST.RELEASE_BATCH_SUB(:errbuf, :rc, :A0, :A1, :A2, :A3); END;
4yak7x2zqz0dhBEGIN inv_transfer_order_pvt.finalize_pick_confirm(:1, :2, :3, :4, :5, :6, :7); END;
52zwqr7xyrc2mSELECT 'Y' FROM WSH_PR_WORKERS WHERE BATCH_ID = :B3 AND ORGANIZATION_ID = :B2 AND NVL(INVENTORY_ITEM_ID, -99) = NVL(:B1 , -99) AND TYPE = 'PICK' AND PROCESSED = 'N' FOR UPDATE NOWAIT
54tkzbnhn8gapDELETE FROM MTL_SERIAL_NUMBERS_TEMP WHERE TRANSACTION_TEMP_ID IN ( SELECT TRANSACTION_TEMP_ID FROM MTL_MATERIAL_TRANSACTIONS_TEMP WHERE TRANSACTION_HEADER_ID = :B2 AND NVL(TRANSACTION_BATCH_ID, -1)=NVL(:B1, -1) AND PROCESS_FLAG ='Y' AND NVL(ERROR_CODE, '@@') = '@@' AND NVL(TRANSACTION_STATUS, 1) <> 2 AND NOT (TRANSACTION_SOURCE_TYPE_ID IN (2, 8) AND TRANSACTION_ACTION_ID = 28 AND ABS(PRIMARY_QUANTITY) <> 1) UNION ALL SELECT MTLT.SERIAL_TRANSACTION_TEMP_ID FROM MTL_TRANSACTION_LOTS_TEMP MTLT WHERE MTLT.TRANSACTION_TEMP_ID IN ( SELECT MMTT.TRANSACTION_TEMP_ID FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT WHERE MMTT.TRANSACTION_HEADER_ID = :B4 AND NVL(MMTT.TRANSACTION_BATCH_ID, -1)=NVL(:B3, -1) AND MMTT.PROCESS_FLAG ='Y' AND NVL(MMTT.ERROR_CODE, '@@') = '@@' AND NVL(MMTT.TRANSACTION_STATUS, 1) <> 2 AND NOT (MMTT.TRANSACTION_SOURCE_TYPE_ID IN (2, 8) AND MMTT.TRANSACTION_ACTION_ID = 28 AND ABS(MTLT.PRIMARY_QUANTITY) <> 1)))
5t39uchjqpyfmBEGIN xla_accounting_pkg.unit_processor_batch(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8, :A9, :A10, :A11, :A12, :A13, :A14); END;
608c0n36kaw62begin FND_FLEX_WORKFLOW_APIS.COPY_FROM_COMBINATION (:v1, :v2, :v3, :v4, :v5); end;
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
6cx4kvh606rwzSELECT COUNT(1) FROM WF_ITEM_ACTIVITY_STATUSES WIAS, WF_PROCESS_ACTIVITIES WPA, WF_ITEMS WI WHERE WIAS.ITEM_TYPE = :B5 AND WIAS.ITEM_KEY = WI.ITEM_KEY AND WI.PARENT_ITEM_TYPE = :B7 AND WI.PARENT_ITEM_KEY = :B6 AND (WI.ITEM_TYPE <> :B5 OR WI.ITEM_KEY <> :B4 ) AND WI.END_DATE IS NULL AND WIAS.PROCESS_ACTIVITY = WPA.INSTANCE_ID AND WPA.INSTANCE_LABEL = :B3 AND WIAS.ACTIVITY_STATUS IN (:B2 , :B1 )
6h228dtb8hp1t SELECT X.ORGANIZATION_ID ORGANIZATION_ID , X.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , X.REVISION REVISION , NULL LOT_NUMBER , NULL LOT_EXPIRATION_DATE , X.SUBINVENTORY_CODE SUBINVENTORY_CODE , SUB.RESERVABLE_TYPE RESERVABLE_TYPE , X.LOCATOR_ID LOCATOR_ID , SUM(X.PRIMARY_QUANTITY) PRIMARY_QUANTITY , SUM(X.SECONDARY_QUANTITY) SECONDARY_QUANTITY , X.QUANTITY_TYPE QUANTITY_TYPE , X.COST_GROUP_ID COST_GROUP_ID , X.LPN_ID LPN_ID , X.TRANSACTION_ACTION_ID TRANSACTION_ACTION_ID , X.TRANSFER_SUBINVENTORY_CODE TRANSFER_SUBINVENTORY_CODE , X.TRANSFER_LOCATOR_ID TRANSFER_LOCATOR_ID FROM ( SELECT X.ORGANIZATION_ID ORGANIZATION_ID , X.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , DECODE(:B10 , 2, NULL , X.REVISION) REVISION , NULL LOT_NUMBER , X.SUBINVENTORY_CODE SUBINVENTORY_CODE , X.LOCATOR_ID LOCATOR_ID , SUM(X.PRIMARY_QUANTITY) PRIMARY_QUANTITY , SUM(X.SECONDARY_QUANTITY) SECONDARY_QUANTITY , X.QUANTITY_TYPE QUANTITY_TYPE , X.COST_GROUP_ID COST_GROUP_ID , X.LPN_ID LPN_ID , X.TRANSACTION_ACTION_ID TRANSACTION_ACTION_ID , X.TRANSFER_SUBINVENTORY_CODE TRANSFER_SUBINVENTORY_CODE , X.TRANSFER_LOCATOR_ID TRANSFER_LOCATOR_ID FROM ( SELECT MR.ORGANIZATION_ID ORGANIZATION_ID , MR.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , MR.REVISION REVISION , MR.LOT_NUMBER LOT_NUMBER , MR.SUBINVENTORY_CODE SUBINVENTORY_CODE , MR.LOCATOR_ID LOCATOR_ID , MR.PRIMARY_RESERVATION_QUANTITY - NVL(MR.DETAILED_QUANTITY, 0) PRIMARY_QUANTITY , MR.SECONDARY_RESERVATION_QUANTITY - NVL(MR.SECONDARY_DE TAILED_QUANTITY, 0) SECONDARY_QUANTITY , 3 QUANTITY_TYPE , TO_NUMBER(NULL) COST_GROUP_ID , LPN_ID LPN_ID , TO_NUMBER(NULL) TRANSACTION_ACTION_ID , TO_CHAR(NULL) TRANSFER_SUBINVENTORY_CODE , TO_NUMBER(NULL) TRANSFER_LOCATOR_ID FROM MTL_RESERVATIONS MR WHERE NVL(MR.SUPPLY_SOURCE_TYPE_ID, 13) = 13 AND MR.PRIMARY_RESERVATION_QUANTITY > NVL(MR.DETAILED_QUANTITY, 0) AND ((:B7 <>1) OR (:B7 = 1 AND MR.LPN_ID IS NULL)) AND (:B6 <> 3 OR (:B6 = 3 AND NOT (:B5 = MR.DEMAND_SOURCE_TYPE_ID AND :B4 = MR.DEMAND_SOURCE_HEADER_ID AND NVL(:B3 , -9999) = NVL(MR.DEMAND_SOURCE_LINE_ID, -9999) AND NVL(:B2 , '@@@###@@#') = NVL(MR.DEMAND_SOURCE_NAME, '@@@###@@#') AND NVL(:B1 , -9999) = NVL(MR.DEMAND_SOURCE_DELIVERY, -9999) ) )) UNION ALL SELECT MOQ.ORGANIZATION_ID ORGANIZATION_ID , MOQ.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , MOQ.REVISION REVISION , MOQ.LOT_NUMBER LOT_NUMBER , MOQ.SUBINVENTORY_CODE SUBINVENTORY_CODE , MOQ.LOCATOR_ID LOCATOR_ID , MOQ.PRIMARY_TRANSACTION_QUANTITY , MOQ.SECONDARY_TRANSACTION_QUANTITY , 1 QUANTITY_TYPE , MOQ.COST_GROUP_ID COST_GROUP_ID , MOQ.LPN_ID LPN_ID , TO_NUMBER(NULL) TRANSACTION_ACTION_ID , TO_CHAR(NULL) TRANSFER_SUBINVENTORY_CODE , TO_NUMBER(NULL) TRANSFER_LOCATOR_ID FROM MTL_ONHAND_QUANTITIES_DETAIL MOQ UNION ALL SELECT MMTT.ORGANIZATION_ID ORGANIZATION_ID , MMTT.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , MMTT.REVISION REVISION , NULL LOT_NUMBER , MMTT.SUBINVENTORY_CODE SUBINVENTORY_CODE , MMTT.LOCATOR_ID LOCATOR_ID , DECODE(DECO DE(MMTT.TRANSACTION_STATUS, 2, DECODE(NVL(MMTT.WMS_TASK_STATUS, -1), 4, -1, 2), MMTT.TRANSACTION_STATUS), 2, 1, DECODE(MMTT.TRANSACTION_ACTION_ID, 1, -1, 2, -1, 28, -1, 3, -1, SIGN(MMTT.PRIMARY_QUANTITY))) * ROUND(ABS(MMTT.PRIMARY_QUANTITY), 5) , DECODE(DECODE(MMTT.TRANSACTION_STATUS, 2, DECODE(NVL(MMTT.WMS_TASK_STATUS, -1), 4, -1, 2), MMTT.TRANSACTION_STATUS), 2, 1, DECODE(MMTT.TRANSACTION_ACTION_ID, 1, -1, 2, -1, 28, -1, 3, -1, SIGN(MMTT.SECONDARY_TRANSACTION_QUANTITY))) * ROUND(ABS(MMTT.SECONDARY_TRANSACTION_QUANTITY), 5) , DECODE(MMTT.TRANSACTION_STATUS, 2, DECODE(NVL(MMTT.WMS_TASK_STATUS, -1), 4, 1, 5), 1) QUANTITY_TYPE , MMTT.COST_GROUP_ID COST_GROUP_ID , NVL(MMTT.ALLOCATED_LPN_ID, NVL(MMTT.CONTENT_LPN_ID, MMTT.LPN_ID)) LPN_ID , DECODE(MMTT.TRANSACTION_STATUS, 2 , MMTT.TRANSACTION_ACTION_ID, TO_NUMBER(NULL)) TRANSACTION_ACTION_ID , DECODE(MMTT.TRANSACTION_STATUS, 2 , MMTT.TRANSFER_SUBINVENTORY, TO_CHAR(NULL)) TRANSFER_SUBINVENTORY_CODE , DECODE(MMTT.TRANSACTION_STATUS, 2 , MMTT.TRANSFER_TO_LOCATION, TO_NUMBER(NULL)) TRANSFER_LOCATOR_ID FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT WHERE MMTT.POSTING_FLAG = 'Y' AND MMTT.SUBINVENTORY_CODE IS NOT NULL AND (NVL(MMTT.TRANSACTION_STATUS, 0) <> 2 OR NVL(MMTT.TRANSACTION_STATUS, 0) = 2 AND MMTT.TRANSACTION_ACTION_ID IN (1, 2, 28, 3, 21, 29, 32, 34) ) AND MMTT.TRANSACTION_ACTION_ID NOT IN (5, 6, 24, 30) UNION ALL SELECT DECODE(MMTT.TRANSACTION_ACTION_ID , 3, MMTT.TRANSFER_ORGANIZATION , MMTT .ORGANIZATION_ID) ORGANIZATION_ID , MMTT.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , MMTT.REVISION REVISION , NULL LOT_NUMBER , MMTT.TRANSFER_SUBINVENTORY SUBINVENTORY_CODE , MMTT.TRANSFER_TO_LOCATION LOCATOR_ID , ROUND(ABS(MMTT.PRIMARY_QUANTITY), 5) , ROUND(ABS(MMTT.SECONDARY_TRANSACTION_QUANTITY), 5) , 1 QUANTITY_TYPE , MMTT.TRANSFER_COST_GROUP_ID COST_GROUP_ID , NVL(MMTT.CONTENT_LPN_ID, MMTT.TRANSFER_LPN_ID) LPN_ID , TO_NUMBER(NULL) TRANSACTION_ACTION_ID , TO_CHAR(NULL) TRANSFER_SUBINVENTORY_CODE , TO_NUMBER(NULL) TRANSFER_LOCATOR_ID FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT WHERE MMTT.POSTING_FLAG = 'Y' AND NVL(MMTT.TRANSACTION_STATUS, 0) <> 2 AND MMTT.TRANSACTION_ACTION_ID IN (2, 28, 3) AND MMTT.WIP_SUPPLY_TYPE IS NULL ) X WHERE X.ORGANIZATION_ID = :B9 AND X.INVENTORY_ITEM_ID = :B8 GROUP BY X.ORGANIZATION_ID, X.INVENTORY_ITEM_ID, X.REVISION , X.LOT_NUMBER, X.SUBINVENTORY_CODE, X.LOCATOR_ID , X.QUANTITY_TYPE, X.COST_GROUP_ID, X.LPN_ID , X.TRANSACTION_ACTION_ID, X.TRANSFER_SUBINVENTORY_CODE , X.TRANSFER_LOCATOR_ID ) X , MTL_SECONDARY_INVENTORIES SUB WHERE X.ORGANIZATION_ID = SUB.ORGANIZATION_ID (+) AND X.SUBINVENTORY_CODE = SUB.SECONDARY_INVENTORY_NAME (+) AND (:B12 = 2 OR NVL(SUB.ASSET_INVENTORY, 1) = 1) AND ((:B11 =1 AND NVL(SUB.INVENTORY_ATP_CODE, 1) = 1 ) OR (:B11 = 2 AND NVL(SUB.AVAILABILITY_TYPE, 1) = 1 ) OR :B11 =3 OR (:B11 = 4 AND (NVL(SUB.INVENTORY_ATP_CODE, 1) = 1 AND NVL(SUB.AVAILABILITY_TYPE, 1)=1)) ) GROUP BY X.ORGANIZATION_ID , X.IN VENTORY_ITEM_ID , X.REVISION , NULL , NULL , SUB.RESERVABLE_TYPE , X.SUBINVENTORY_CODE , NULL , X.LOCATOR_ID , X.QUANTITY_TYPE , X.COST_GROUP_ID , X.LPN_ID , X.TRANSACTION_ACTION_ID , X.TRANSFER_SUBINVENTORY_CODE , X.TRANSFER_LOCATOR_ID
6kcfnxrpx27hw declare Errbuf VARCHAR2 ( 256 ) ; Retcode VARCHAR2 ( 256 ) ; BEGIN arp_file . write_log ( 'RAXTRX is called from RAXMTR' ) ; ARP_AUTO_RULE . refresh ( Errbuf , Retcode ) ; COMMIT WORK ; arp_file . write_log ( 'Refresh AR periods complete.' ) ; << gather_stats >> DECLARE l_status VARCHAR2 ( 1 ) ; l_schema VARCHAR2 ( 30 ) ; l_industry VARCHAR2 ( 1 ) ; l_tname1 VARCHAR2 ( 30 ) := 'RA_INTERFACE_LINES_ALL' ; l_tname2 VARCHAR2 ( 30 ) := 'RA_INTERFACE_SALESCREDITS_ALL' ; l_tname3 VARCHAR2 ( 30 ) := 'RA_INTERFACE_DISTRIBUTIONS_ALL' ; l_iname1 VARCHAR2 ( 30 ) := 'RA_INTERFACE_LINES_N1' ; l_iname3 VARCHAR2 ( 30 ) := 'RA_INTERFACE_LINES_N2' ; l_iname2 VARCHAR2 ( 30 ) := 'RA_INTERFACE_LINES_U1' ; l_iname4 VARCHAR2 ( 30 ) := 'RA_INTERFACE_DISTRIBUTIONS_U1' ; l_iname5 VARCHAR2 ( 30 ) := 'RA_INTERFACE_DISTRIBUTIONS_N1' ; l_cname1 VARCHAR2 ( 30 ) := 'REQUEST_ID' ; l_cname2 VARCHAR2 ( 30 ) := 'INTERFACE_LINE_ID' ; l_cname3 VARCHAR2 ( 30 ) := 'CUSTOMER_TRX_ID' ; l_cname4 VARCHAR2 ( 30 ) := 'INTERFACE_DISTRIBUTION_ID' ; l_cname5 VARCHAR2 ( 30 ) := 'INTERFACE_LINE_ID' ; c01_dba_tab_rec dba_tables % rowtype ; no_product_info EXCEPTION ; CURSOR c01_dba_tab ( p_owner VARCHAR2 , p_tname VARCHAR2 ) IS SELECT * FROM dba_tables WHERE owner = p_owner AND table_name = p_tname ; BEGIN arp_file . write_log ( 'In gather stats.' ) ; IF ( NOT fnd_installation . get_app_info ( application_short_name => 'AR' , status => l_status , industry => l_industry , oracle_schema => l_schema ) ) THEN arp_file . write_log ( 'EXCEPTION:Failed to get information for AR' ) ; RAISE no_product_info ; END IF ; arp_file . write_log ( 'before gather table stats.' ) ; arp_file . write_log ( 'before [RA_INTERFACE_LINES_ALL].' ) ; fnd_stats . gather_table_stats ( ownname => l_schema , tabname => l_tname1 ) ; arp_file . write_log ( 'before [RA_INTERFACE_DISTRIBUTIONS_ALL].' ) ; fnd_stats . gather_table_stats ( ownname => l_schema , tabname => l_tname2 ) ; arp_file . write_log ( 'before [RA_INTERFACE_SALESCREDITS_ALL].' ) ; fnd_stats . gather_table_stats ( ownname => l_schema , tabname => l_tname3 ) ; OPEN c01_dba_tab ( l_schema , l_tname1 ) ; FETCH c01_dba_tab INTO c01_dba_tab_rec ; CLOSE c01_dba_tab ; arp_file . write_log ( 'before set index stats [N1].' ) ; fnd_stats . set_index_stats ( ownname => l_schema , indname => l_iname1 , numrows => c01_dba_tab_rec . num_rows , numlblks => c01_dba_tab_rec . num_rows / 200 , numdist => :parallel_count , avglblk => null , avgdblk => null , clstfct => c01_dba_tab_rec . num_rows / 100 , indlevel => 2 ) ; arp_file . write_log ( 'before set index stats [N2].' ) ; fnd_stats . set_index_stats ( ownname => l_schema , indname => l_iname3 , numrows => c01_dba_tab_rec . num_rows , numlblks => c01_dba_tab_rec . num_rows / 200 , numdist => c01_dba_tab_rec . num_rows / 10 , avglblk => null , avgdblk => null , clstfct => c01_dba_tab_rec . num_rows / 100 , indlev el => 2 ) ; arp_file . write_log ( 'before set index stats [U1].' ) ; fnd_stats . set_index_stats ( ownname => l_schema , indname => l_iname2 , numrows => c01_dba_tab_rec . num_rows , numlblks => null , numdist => c01_dba_tab_rec . num_rows , avglblk => null , avgdblk => null , clstfct => c01_dba_tab_rec . num_rows , indlevel => null ) ; arp_file . write_log ( 'before set column stats ' || '[RA_INTERFACE_LINES.request_id].' ) ; dbms_stats . set_column_stats ( ownname => l_schema , tabname => l_tname1 , colname => l_cname1 , distcnt => :parallel_count , nullcnt => 0 ) ; arp_file . write_log ( 'before set column stats ' || '[RA_INTERFACE_LINES.INTERFACE_LINE_ID].' ) ; dbms_stats . set_column_stats ( ownname => l_schema , tabname => l_tname1 , colname => l_cname2 , distcnt => c01_dba_tab_rec . num_rows , nullcnt => 0 ) ; arp_file . write_log ( 'before set column stats [RA_INTERFACE_LINES.CUSTOMER_TRX_ID].' ) ; dbms_stats . set_column_stats ( ownname => l_schema , tabname => l_tname1 , colname => l_cname3 , distcnt => c01_dba_tab_rec . num_rows / 10 , nullcnt => 0 ) ; OPEN c01_dba_tab ( l_schema , l_tname3 ) ; FETCH c01_dba_tab INTO c01_dba_tab_rec ; CLOSE c01_dba_tab ; arp_file . write_log ( 'before set index stats [DIST U1]' ) ; fnd_stats . set_index_stats ( ownname => l_schema , indname => l_iname4 , numrows => c01_dba_tab_rec . num_rows , numlblks => null , numdist => c01_dba_tab_rec . num_rows , avglblk => null , avgdblk => null , clstfct => c01_dba_tab_rec . num_rows , indlevel => null ) ; arp_file . write_log ( 'before set index stats [DIST N1].' ) ; fnd_stats . set_index_stats ( ownname => l_schema , indname => l_iname5 , numrows => c01_dba_tab_rec . num_rows , numlblks => c01_dba_tab_rec . num_rows / 200 , numdist => c01_dba_tab_rec . num_rows / 10 , avglblk => null , avgdblk => null , clstfct => c01_dba_tab_rec . num_rows / 100 , indlevel => 2 ) ; arp_file . write_log ( 'before set column stats ' || '[RA_INTERFACE_DISTRIBUTIONS.INTERFACE_DISTRIBUTIONS_ID].' ) ; dbms_stats . set_column_stats ( ownname => l_schema , tabname => l_tname3 , colname => l_cname4 , distcnt => c01_dba_tab_rec . num_rows , nullcnt => 0 ) ; arp_file . write_log ( 'before set column stats ' || '[RA_INTERFACE_DISTRIBUTIONS.INTERFACE_LINE_ID].' ) ; dbms_stats . set_column_stats ( ownname => l_schema , tabname => l_tname3 , colname => l_cname5 , distcnt => c01_dba_tab_rec . num_rows / 10 , nullcnt => 0 ) ; EXCEPTION WHEN OTHERS THEN arp_file . write_log ( 'Error in Gather stats' || SQLERRM ( SQLCODE ) ) ; RAISE ; END gather_stats ; EXCEPTION WHEN OTHERS THEN arp_file . write_log ( SQLERRM ( SQLCODE ) ) ; RAISE ; END ;
72yyswsqkzkrmBEGIN OE_BULK_ORDER_IMPORT_PVT.ORDER_IMPORT_CONC_PGM(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8, :A9, :A10); END;
76sw2a4vnc89jbegin FND_FLEX_WORKFLOW_APIS.START_GENERATION (:v1, :v2, :v3, :v4, :v5); end;
7bdg2fscmus2h SELECT ACCOUNTING_RULE_ID , ACCOUNTING_RULE_DURATION , ACTUAL_ARRIVAL_DATE , ACTUAL_SHIPMENT_DATE , AGREEMENT_ID , ARRIVAL_SET_ID , ATO_LINE_ID , ATTRIBUTE1 , ATTRIBUTE10 , ATTRIBUTE11 , ATTRIBUTE12 , ATTRIBUTE13 , ATTRIBUTE14 , ATTRIBUTE15 , ATTRIBUTE16 , ATTRIBUTE17 , ATTRIBUTE18 , ATTRIBUTE19 , ATTRIBUTE2 , ATTRIBUTE20 , ATTRIBUTE3 , ATTRIBUTE4 , ATTRIBUTE5 , ATTRIBUTE6 , ATTRIBUTE7 , ATTRIBUTE8 , ATTRIBUTE9 , AUTO_SELECTED_QUANTITY , AUTHORIZED_TO_SHIP_FLAG , BOOKED_FLAG , CANCELLED_FLAG , CANCELLED_QUANTITY , COMPONENT_CODE , COMPONENT_NUMBER , COMPONENT_SEQUENCE_ID , CONFIG_HEADER_ID , CONFIG_REV_NBR , CONFIG_DISPLAY_SEQUENCE , CONFIGURATION_ID , CONTEXT , CREATED_BY , CREATION_DATE , CREDIT_INVOICE_LINE_ID , CUSTOMER_DOCK_CODE , CUSTOMER_JOB , CUSTOMER_PRODUCTION_LINE , CUST_PRODUCTION_SEQ_NUM , CUSTOMER_TRX_LINE_ID , CUST_MODEL_SERIAL_NUMBER , CUST_PO_NUMBER , CUSTOMER_LINE_NUMBER , CUSTOMER_SHIPMENT_NUMBER , CUSTOMER_ITEM_NET_PRICE , DELIVERY_LEAD_TIME , DELIVER_TO_CONTACT_ID , DELIVER_TO_ORG_ID , DEMAND_BUCKET_TYPE_CODE , DEMAND_CLASS_CODE , DEP_PLAN_REQUIRED_FLAG , EARLIEST_ACCEPTABLE_DATE , END_ITEM_UNIT_NUMBER , EXPLOSION_DATE , FIRST_ACK_CODE , FIRST_ACK_DATE , FOB_POINT_CODE , FREIGHT_CARRIER_CODE , FREIGHT_TERMS_CODE , FULFILLED_QUANTITY , FULFILLED_FLAG , FULFILLMENT_METHOD_CODE , FULFILLMENT_DATE , GLOBAL_ATTRIBUTE1 , GLOBAL_ATTRIBUTE10 , GLOBAL_ATTRIBUTE11 , GLOBAL_ATTRIBUTE12 , GLOB AL_ATTRIBUTE13 , GLOBAL_ATTRIBUTE14 , GLOBAL_ATTRIBUTE15 , GLOBAL_ATTRIBUTE16 , GLOBAL_ATTRIBUTE17 , GLOBAL_ATTRIBUTE18 , GLOBAL_ATTRIBUTE19 , GLOBAL_ATTRIBUTE2 , GLOBAL_ATTRIBUTE20 , GLOBAL_ATTRIBUTE3 , GLOBAL_ATTRIBUTE4 , GLOBAL_ATTRIBUTE5 , GLOBAL_ATTRIBUTE6 , GLOBAL_ATTRIBUTE7 , GLOBAL_ATTRIBUTE8 , GLOBAL_ATTRIBUTE9 , GLOBAL_ATTRIBUTE_CATEGORY , HEADER_ID , INDUSTRY_ATTRIBUTE1 , INDUSTRY_ATTRIBUTE10 , INDUSTRY_ATTRIBUTE11 , INDUSTRY_ATTRIBUTE12 , INDUSTRY_ATTRIBUTE13 , INDUSTRY_ATTRIBUTE14 , INDUSTRY_ATTRIBUTE15 , INDUSTRY_ATTRIBUTE16 , INDUSTRY_ATTRIBUTE17 , INDUSTRY_ATTRIBUTE18 , INDUSTRY_ATTRIBUTE19 , INDUSTRY_ATTRIBUTE20 , INDUSTRY_ATTRIBUTE21 , INDUSTRY_ATTRIBUTE22 , INDUSTRY_ATTRIBUTE23 , INDUSTRY_ATTRIBUTE24 , INDUSTRY_ATTRIBUTE25 , INDUSTRY_ATTRIBUTE26 , INDUSTRY_ATTRIBUTE27 , INDUSTRY_ATTRIBUTE28 , INDUSTRY_ATTRIBUTE29 , INDUSTRY_ATTRIBUTE30 , INDUSTRY_ATTRIBUTE2 , INDUSTRY_ATTRIBUTE3 , INDUSTRY_ATTRIBUTE4 , INDUSTRY_ATTRIBUTE5 , INDUSTRY_ATTRIBUTE6 , INDUSTRY_ATTRIBUTE7 , INDUSTRY_ATTRIBUTE8 , INDUSTRY_ATTRIBUTE9 , INDUSTRY_CONTEXT , INTMED_SHIP_TO_CONTACT_ID , INTMED_SHIP_TO_ORG_ID , INVENTORY_ITEM_ID , INVOICE_INTERFACE_STATUS_CODE , INVOICE_TO_CONTACT_ID , INVOICE_TO_ORG_ID , INVOICED_QUANTITY , INVOICING_RULE_ID , ORDERED_ITEM_ID , ITEM_IDENTIFIER_TYPE , ORDERED_ITEM , ITEM_REVISION , ITEM_TYPE_CODE , LAST_ACK_CODE , LAST_ACK_DATE , LAST_UPDATED_BY , LAST_UPDATE_DATE , LAST_UPDATE_LOGIN , LAT EST_ACCEPTABLE_DATE , LINE_CATEGORY_CODE , LINE_ID , LINE_NUMBER , LINE_TYPE_ID , LINK_TO_LINE_ID , MODEL_GROUP_NUMBER , MFG_LEAD_TIME , OPEN_FLAG , OPTION_FLAG , OPTION_NUMBER , ORDERED_QUANTITY , ORDERED_QUANTITY2 , ORDER_QUANTITY_UOM , ORDERED_QUANTITY_UOM2 , ORG_ID , ORIG_SYS_DOCUMENT_REF , ORIG_SYS_LINE_REF , ORIG_SYS_SHIPMENT_REF , OVER_SHIP_REASON_CODE , OVER_SHIP_RESOLVED_FLAG , PAYMENT_TERM_ID , PLANNING_PRIORITY , PREFERRED_GRADE , PRICE_LIST_ID , PRICE_REQUEST_CODE , PRICING_ATTRIBUTE1 , PRICING_ATTRIBUTE10 , PRICING_ATTRIBUTE2 , PRICING_ATTRIBUTE3 , PRICING_ATTRIBUTE4 , PRICING_ATTRIBUTE5 , PRICING_ATTRIBUTE6 , PRICING_ATTRIBUTE7 , PRICING_ATTRIBUTE8 , PRICING_ATTRIBUTE9 , PRICING_CONTEXT , PRICING_DATE , PRICING_QUANTITY , PRICING_QUANTITY_UOM , PROGRAM_APPLICATION_ID , PROGRAM_ID , PROGRAM_UPDATE_DATE , PROJECT_ID , PROMISE_DATE , RE_SOURCE_FLAG , REFERENCE_CUSTOMER_TRX_LINE_ID , REFERENCE_HEADER_ID , REFERENCE_LINE_ID , REFERENCE_TYPE , REQUEST_DATE , REQUEST_ID , RETURN_ATTRIBUTE1 , RETURN_ATTRIBUTE10 , RETURN_ATTRIBUTE11 , RETURN_ATTRIBUTE12 , RETURN_ATTRIBUTE13 , RETURN_ATTRIBUTE14 , RETURN_ATTRIBUTE15 , RETURN_ATTRIBUTE2 , RETURN_ATTRIBUTE3 , RETURN_ATTRIBUTE4 , RETURN_ATTRIBUTE5 , RETURN_ATTRIBUTE6 , RETURN_ATTRIBUTE7 , RETURN_ATTRIBUTE8 , RETURN_ATTRIBUTE9 , RETURN_CONTEXT , RETURN_REASON_CODE , RLA_SCHEDULE_TYPE_CODE , SALESREP_ID , SCHEDULE_ARRIVAL_DATE , SCHEDULE_SHIP_DATE , SCHED ULE_STATUS_CODE , SHIPMENT_NUMBER , SHIPMENT_PRIORITY_CODE , SHIPPED_QUANTITY , SHIPPED_QUANTITY2 , SHIPPING_METHOD_CODE , SHIPPING_QUANTITY , SHIPPING_QUANTITY2 , SHIPPING_QUANTITY_UOM , SHIPPING_QUANTITY_UOM2 , SHIP_FROM_ORG_ID , SUBINVENTORY , SHIP_SET_ID , SHIP_TOLERANCE_ABOVE , SHIP_TOLERANCE_BELOW , SHIPPABLE_FLAG , SHIPPING_INTERFACED_FLAG , SHIP_TO_CONTACT_ID , SHIP_TO_ORG_ID , SHIP_MODEL_COMPLETE_FLAG , SOLD_TO_ORG_ID , SOLD_FROM_ORG_ID , SORT_ORDER , SOURCE_DOCUMENT_ID , SOURCE_DOCUMENT_LINE_ID , SOURCE_DOCUMENT_TYPE_ID , SOURCE_TYPE_CODE , SPLIT_FROM_LINE_ID , LINE_SET_ID , SPLIT_BY , MODEL_REMNANT_FLAG , TASK_ID , TAX_CODE , TAX_DATE , TAX_EXEMPT_FLAG , TAX_EXEMPT_NUMBER , TAX_EXEMPT_REASON_CODE , TAX_POINT_CODE , TAX_RATE , TAX_VALUE , TOP_MODEL_LINE_ID , UNIT_LIST_PRICE , UNIT_LIST_PRICE_PER_PQTY , UNIT_SELLING_PRICE , UNIT_SELLING_PRICE_PER_PQTY , VISIBLE_DEMAND_FLAG , VEH_CUS_ITEM_CUM_KEY_ID , SHIPPING_INSTRUCTIONS , PACKING_INSTRUCTIONS , SERVICE_TXN_REASON_CODE , SERVICE_TXN_COMMENTS , SERVICE_DURATION , SERVICE_PERIOD , SERVICE_START_DATE , SERVICE_END_DATE , SERVICE_COTERMINATE_FLAG , UNIT_LIST_PERCENT , UNIT_SELLING_PERCENT , UNIT_PERCENT_BASE_PRICE , SERVICE_NUMBER , SERVICE_REFERENCE_TYPE_CODE , SERVICE_REFERENCE_LINE_ID , SERVICE_REFERENCE_SYSTEM_ID , TP_CONTEXT , TP_ATTRIBUTE1 , TP_ATTRIBUTE2 , TP_ATTRIBUTE3 , TP_ATTRIBUTE4 , TP_ATTRIBUTE5 , TP_ATTRIBUTE6 , TP_ATTRIBUTE7 , TP_ATTRI BUTE8 , TP_ATTRIBUTE9 , TP_ATTRIBUTE10 , TP_ATTRIBUTE11 , TP_ATTRIBUTE12 , TP_ATTRIBUTE13 , TP_ATTRIBUTE14 , TP_ATTRIBUTE15 , FLOW_STATUS_CODE , MARKETING_SOURCE_CODE_ID , CALCULATE_PRICE_FLAG , COMMITMENT_ID , ORDER_SOURCE_ID , UPGRADED_FLAG , ORIGINAL_INVENTORY_ITEM_ID , ORIGINAL_ITEM_IDENTIFIER_TYPE , ORIGINAL_ORDERED_ITEM_ID , ORIGINAL_ORDERED_ITEM , ITEM_RELATIONSHIP_TYPE , ITEM_SUBSTITUTION_TYPE_CODE , LATE_DEMAND_PENALTY_FACTOR , OVERRIDE_ATP_DATE_CODE , FIRM_DEMAND_FLAG , EARLIEST_SHIP_DATE , USER_ITEM_DESCRIPTION , BLANKET_NUMBER , BLANKET_LINE_NUMBER , BLANKET_VERSION_NUMBER , UNIT_COST , LOCK_CONTROL , CHANGE_SEQUENCE , TRANSACTION_PHASE_CODE , SOURCE_DOCUMENT_VERSION_NUMBER , MINISITE_ID , IB_OWNER , IB_INSTALLED_AT_LOCATION , IB_CURRENT_LOCATION , END_CUSTOMER_ID , END_CUSTOMER_CONTACT_ID , END_CUSTOMER_SITE_USE_ID , RETROBILL_REQUEST_ID , ORIGINAL_LIST_PRICE , ORDER_FIRMED_DATE , ACTUAL_FULFILLMENT_DATE , CHARGE_PERIODICITY_CODE , CANCELLED_QUANTITY2 , FULFILLED_QUANTITY2 , CONTINGENCY_ID , REVREC_EVENT_CODE , REVREC_EXPIRATION_DAYS , ACCEPTED_QUANTITY , REVREC_COMMENTS , REVREC_SIGNATURE , REVREC_SIGNATURE_DATE , ACCEPTED_BY , REVREC_REFERENCE_DOCUMENT , REVREC_IMPLICIT_FLAG FROM OE_ORDER_LINES_ALL WHERE LINE_ID = :B1
7mrs575bj7a41begin OE_OEOL_SCH.BRANCH_ON_SOURCE_TYPE (:v1, :v2, :v3, :v4, :v5); end;
7mz96k4qtxrzr SELECT BASE.REVISION , BASE.LOT_NUMBER , BASE.LOT_EXPIRATION_DATE , BASE.SUBINVENTORY_CODE , BASE.LOCATOR_ID , BASE.COST_GROUP_ID , BASE.UOM_CODE , DECODE(:B7 , -9999, NULL, :B7 ) LPN_ID , NULL SERIAL_NUMBER , SUM(BASE.PRIMARY_QUANTITY) , SUM(BASE.SECONDARY_QUANTITY) , BASE.GRADE_CODE , NULL CONSIST_STRING , MSEI.PICKING_ORDER ORDER_BY_STRING FROM OE_ORDER_LINES_ALL OOL , MTL_SECONDARY_INVENTORIES MSEI , MTL_LOT_NUMBERS MLN , WMS_TRX_DETAILS_TMP_V MPTDTV , ( SELECT X.ORGANIZATION_ID ORGANIZATION_ID , X.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , X.REVISION REVISION , X.LOT_NUMBER LOT_NUMBER , X.LOT_EXPIRATION_DATE LOT_EXPIRATION_DATE , X.SUBINVENTORY_CODE SUBINVENTORY_CODE , X.LOCATOR_ID LOCATOR_ID , X.COST_GROUP_ID COST_GROUP_ID , NULL SERIAL_NUMBER , X.LPN_ID LPN_ID , X.PROJECT_ID PROJECT_ID , X.TASK_ID TASK_ID , X.DATE_RECEIVED DATE_RECEIVED , X.PRIMARY_QUANTITY PRIMARY_QUANTITY , X.SECONDARY_QUANTITY SECONDARY_QUANTITY , X.GRADE_CODE GRADE_CODE , X.RESERVABLE_TYPE RESERVABLE_TYPE , NVL(LOC.PICK_UOM_CODE, SUB.PICK_UOM_CODE) UOM_CODE , WMS_RULE_PVT.GETCONVERSIONRATE( NVL(LOC.PICK_UOM_CODE, SUB.PICK_UOM_CODE) , X.ORGANIZATION_ID , X.INVENTORY_ITEM_ID) CONVERSION_RATE , NULL LOCATOR_INVENTORY_ITEM_ID , NULL EMPTY_FLAG , NULL LOCATION_CURRENT_UNITS 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 , X.SECONDARY_QUANTITY SECONDARY_QUANTITY , LOT.GRADE_CODE GRADE_CODE , X.LPN_ID 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 , SUM(MOQ.SECONDARY_TRANSACTION_QUANTITY) SECONDARY_QUANTITY , MOQ.LPN_ID LPN_ID , DECODE(MILS.PROJECT_ID, MILS.PROJECT_ID, MOQ.PROJECT_ID) PROJECT_ID , DECODE(MILS.TASK_ID, MILS.TASK_ID, MOQ.TASK_ID) TASK_ID FROM MTL_ONHAND_QUANTITIES_DETAIL MOQ, MTL_ITEM_LOCATIONS MILS WHERE MOQ.ORGANIZATION_ID = :B2 AND MOQ.INVENTORY_ITEM_ID = :B1 AND MOQ.ORGANIZATION_ID = MILS.ORGANIZATION_ID (+) AND MOQ.SUBINVENTORY_CODE = MILS.SUBINVENTORY_CODE (+) AND MOQ.LOCATOR_ID = MILS.INVENTORY_LOCATION_ID (+) 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.LPN_ID , DECODE(MILS.PROJECT_ID, MILS.PROJECT_ID, MOQ.PROJECT_ID) , DECODE(MILS.TASK_ID, MILS.TASK_ID, MOQ.TASK_ID) ) X , MTL_SECONDARY_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 X.ORGANIZATION_ID = LOT.ORGANIZATION_ID (+) AND X.INVENTORY_ITEM_ID = LOT.INVENTORY_ITEM_I D (+) AND X.LOT_NUMBER = LOT.LOT_NUMBER (+) ) X , MTL_SECONDARY_INVENTORIES SUB , MTL_ITEM_LOCATIONS LOC WHERE X.ORGANIZATION_ID = LOC.ORGANIZATION_ID (+) AND X.LOCATOR_ID = LOC.INVENTORY_LOCATION_ID (+) AND SUB.ORGANIZATION_ID = X.ORGANIZATION_ID AND SUB.SECONDARY_INVENTORY_NAME = X.SUBINVENTORY_CODE ) BASE WHERE BASE.ORGANIZATION_ID = :B2 AND BASE.INVENTORY_ITEM_ID = :B1 AND DECODE(:B11 , '-9999', 'a', BASE.SUBINVENTORY_CODE) = DECODE(:B11 , '-9999', 'a', :B11 ) AND DECODE(:B11 , '-9999', BASE.RESERVABLE_TYPE, 1) = 1 AND DECODE(:B10 , -9999, 1, BASE.LOCATOR_ID) = DECODE(:B10 , -9999, 1, :B10 ) AND DECODE(:B9 , '-99', 'a', BASE.REVISION) = DECODE(:B9 , '-99', 'a', :B9 ) AND DECODE(:B8 , '-9999', 'a', BASE.LOT_NUMBER) = DECODE(:B8 , '-9999', 'a', :B8 ) AND DECODE(:B7 , -9999, 1, BASE.LPN_ID) = DECODE(:B7 , -9999, 1, :B7 ) AND DECODE(:B6 , -9999, 1, BASE.COST_GROUP_ID) = DECODE(:B6 , -9999, 1, :B6 ) AND (DECODE(:B5 , -9999, -1, BASE.PROJECT_ID) = DECODE(:B5 , -9999, -1, :B5 ) OR ( :B5 = -7777 AND BASE.PROJECT_ID IS NULL)) AND (:B5 = -9999 OR NVL(BASE.TASK_ID, -9999) = :B4 OR (:B4 = -7777 AND BASE.TASK_ID IS NULL)) AND MPTDTV.PP_TRANSACTION_TEMP_ID = :B3 AND MLN.ORGANIZATION_ID (+) = BASE.ORGANIZATION_ID AND MLN.INVENTORY_ITEM_ID (+) = BASE.INVENTORY_ITEM_ID AND MLN.LOT_NUMBER (+) = BASE.LOT_NUMBER AND MSEI.ORGANIZATION_ID = BASE.ORGANIZATION_ID AND MSEI.SECONDARY_INVENTORY_NAME = BASE.SUBINVENTORY_CODE AND OOL.LINE_ID = WMS_PARAMETE R_PVT.GETSOHEADERLINEID(MPTDTV.LINE_ID, MPTDTV.TRANSACTION_SOURCE_TYPE_ID, MPTDTV.REFERENCE, MPTDTV.REFERENCE_ID, 'N', 'Y' ) AND ( (( OOL.PREFERRED_GRADE = MLN.GRADE_CODE AND OOL.PREFERRED_GRADE IS NOT NULL ) OR OOL.PREFERRED_GRADE IS NULL ) ) GROUP BY BASE.ORGANIZATION_ID , BASE.INVENTORY_ITEM_ID , BASE.REVISION , BASE.LOT_NUMBER , BASE.LOT_EXPIRATION_DATE , BASE.SUBINVENTORY_CODE , BASE.LOCATOR_ID , BASE.COST_GROUP_ID , BASE.PROJECT_ID , BASE.TASK_ID , BASE.UOM_CODE , BASE.GRADE_CODE , MSEI.PICKING_ORDER, BASE.CONVERSION_RATE , MSEI.PICKING_ORDER ORDER BY MSEI.PICKING_ORDER ASC , BASE.CONVERSION_RATE DESC
7ptvbaycjtbg4BEGIN arp_run.revenue_recognition(:errbuf, :rc, :A0, :A1, :A2); END;
8swypbbr0m372select order#, columns, types from access$ where d_obj#=:1
8yucb2j07mns1 DECLARE l_count number; BEGIN delete from mtl_serial_numbers_temp where transaction_temp_id in ( select transaction_temp_id from mtl_material_transactions_temp where transaction_header_id = :1 AND nvl(TRANSACTION_BATCH_ID, -1)=NVL(:2, -1) and process_flag ='Y' AND nvl(ERROR_CODE, '@@') = '@@' AND NVL(TRANSACTION_STATUS, 1) <> 2 and not (transaction_source_type_id in (2, 8) and transaction_action_id = 28 and abs(primary_quantity) <> 1) UNION ALL select mtlt.serial_transaction_temp_id from mtl_transaction_lots_temp mtlt where mtlt.transaction_temp_id in ( select mmtt.transaction_temp_id from mtl_material_transactions_temp mmtt where mmtt.transaction_header_id = :3 AND NVL(mmtt.TRANSACTION_BATCH_ID, -1)=NVL(:4, -1) and mmtt.process_flag ='Y' AND nvl(mmtt.ERROR_CODE, '@@') = '@@' AND NVL(mmtt.TRANSACTION_STATUS, 1) <> 2 and not (mmtt.transaction_source_type_id in (2, 8) and mmtt.transaction_action_id = 28 and abs(mtlt.primary_quantity) <> 1))); l_count := SQL%ROWCOUNT; inv_log_util.trace(' Deleted '||l_count||' rows from MSNT', 'INV_TRX_MGR'); DELETE from mtl_transaction_lots_temp where transaction_temp_id in ( select transaction_temp_id from MTL_MATERIAL_TRANSACTIONS_TEMP WHERE TRANSACTION_HEADER_ID = :5 AND NVL(TRANSACTION_BATCH_ID, -1)=NVL(:6, -1) AND PROCESS_FLAG = 'Y' AND nvl(ERROR_CODE, '@@') = '@@' AND NVL(TRANSACTION_STATUS, 1) <& gt; 2 ); l_count := SQL%ROWCOUNT; inv_log_util.trace(' Deleted '||l_count||' rows from MTLT', 'INV_TRX_MGR'); DELETE FROM MTL_MATERIAL_TRANSACTIONS_TEMP WHERE TRANSACTION_HEADER_ID = :7 AND NVL(TRANSACTION_BATCH_ID, -1)=NVL(:8, -1) AND PROCESS_FLAG = 'Y' AND nvl(ERROR_CODE, '@@') = '@@' AND NVL(TRANSACTION_STATUS, 1) <> 2 ; l_count := SQL%ROWCOUNT; inv_log_util.trace(' Deleted '||l_count||' rows from MMTT', 'INV_TRX_MGR'); END;
8zfgv4ck11dw9BEGIN WF_ENGINE.BACKGROUNDCONCURRENT(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4); END;
94s62xmg4d6a4SELECT TO_DATE(TEXT, :B1 ) FROM WF_RESOURCES WHERE TYPE='WFTKN' AND NAME = 'WFCACHE_META_UPD' AND LANGUAGE = 'US'
9wdrypwkpf607begin OE_FULFILL_WF.START_FULFILLMENT (:v1, :v2, :v3, :v4, :v5); end;
a40f9h91scg23select to_char(CODE_COMBINATION_ID), nvl(ENABLED_FLAG, 'Y'), nvl(SUMMARY_FLAG, 'N'), to_char(START_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), to_char(END_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), SEGMENT1, SEGMENT2, SEGMENT3, SEGMENT4, SEGMENT5, ACCOUNT_TYPE, REFERENCE3, JGZZ_RECON_FLAG, DETAIL_BUDGETING_ALLOWED_FLAG, DETAIL_POSTING_ALLOWED_FLAG from GL_CODE_COMBINATIONS where CHART_OF_ACCOUNTS_ID = :FND_BIND1 and CODE_COMBINATION_ID = :FND_BIND2
asqkrtbkjkb9wSELECT NVL(TRX_SOURCE_LINE_ID, -999) FROM MTL_MATERIAL_TRANSACTIONS_TEMP WHERE TRANSACTION_TEMP_ID = :B3 AND TRANSACTION_SOURCE_TYPE_ID = :B2 AND TRANSACTION_ACTION_ID = :B1
assndb4wqnd6rBEGIN INV_TXN_MANAGER_PUB.rel_reservations_mrp_update(:1, :2, :3, :4, :5, :6, :7); END;
b73h3md2wvs09SELECT C.INSTANCE_ID FROM WF_PROCESS_ACTIVITIES P, WF_PROCESS_ACTIVITIES C, WF_ACTIVITIES A WHERE P.INSTANCE_ID = :B3 AND P.ACTIVITY_ITEM_TYPE = C.PROCESS_ITEM_TYPE AND P.ACTIVITY_NAME = C.PROCESS_NAME AND C.PROCESS_VERSION = A.VERSION AND A.NAME = C.PROCESS_NAME AND A.ITEM_TYPE = C.PROCESS_ITEM_TYPE AND :B2 >= A.BEGIN_DATE AND :B2 < NVL(A.END_DATE, :B2 +1) AND C.START_END = :B1 AND NOT EXISTS ( SELECT NULL FROM WF_ACTIVITY_TRANSITIONS WAT WHERE WAT.TO_PROCESS_ACTIVITY = C.INSTANCE_ID)
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;
bsuw7pmwrufpy SELECT reservation_id , primary_reservation_quantity - NVL(detailed_quantity, 0) , NVL(secondary_reservation_quantity, 0) - NVL(secondary_detailed_quantity, 0) -- INVCONV 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
by2f4fw8tac6r UPDATE RA_CUST_TRX_LINE_GL_DIST LGD SET (AMOUNT, ACCTD_AMOUNT) = (SELECT NVL(LGD.AMOUNT, 0) - ( SUM(LGD2.AMOUNT) - ( DECODE(LGD.GL_DATE, REC1.GL_DATE, 1, 0) * DECODE(DECODE(LGD2.ACCOUNT_CLASS, 'UNEARN', 'REV', LGD2.ACCOUNT_CLASS), 'REV', CTL.REVENUE_AMOUNT, 'SUSPENSE', CTL.EXTENDED_AMOUNT - CTL.REVENUE_AMOUNT, CTL.EXTENDED_AMOUNT) ) ), NVL(LGD.ACCTD_AMOUNT, 0) - ( SUM(LGD2.ACCTD_AMOUNT) - ( DECODE(LGD.GL_DATE, REC1.GL_DATE, 1, 0) * DECODE(:B2 , NULL, ROUND(DECODE(DECODE(LGD2.ACCOUNT_CLASS, 'UNEARN', 'REV', LGD2.ACCOUNT_CLASS), 'REV', CTL.REVENUE_AMOUNT, 'SUSPENSE', CTL.EXTENDED_AMOUNT - CTL.REVENUE_AMOUNT, CTL.EXTENDED_AMOUNT) * NVL(CT.EXCHANGE_RATE, 1), :B3 ), ROUND( (DECODE(DECODE(LGD2.ACCOUNT_CLASS, 'UNEARN', 'REV', LGD2.ACCOUNT_CLASS), 'REV', CTL.REVENUE_AMOUNT, 'SUSPENSE', CTL.EXTENDED_AMOUNT - CTL.REVENUE_AMOUNT, CTL.EXTENDED_AMOUNT) * NVL(CT.EXCHANGE_RATE, 1) ) / :B2 ) * :B2 ) ) ) FROM RA_CUST_TRX_LINE_GL_DIST LGD2, RA_CUSTOMER_TRX_LINES CTL, RA_CUSTOMER_TRX CT, RA_CUST_TRX_LINE_GL_DIST REC1 WHERE REC1.CUSTOMER_TRX_ID = LGD.CUSTOMER_TRX_ID AND REC1.ACCOUNT_CLASS = 'REC' AND REC1.LATEST_REC_FLAG = 'Y' AND CT.CUSTOMER_TRX_ID = REC1.CUSTOMER_TRX_ID AND CTL.CUSTOMER_TRX_ID = CT.CUSTOMER_TRX_ID AND CTL.CUSTOMER_TRX_LINE_ID = LGD.CUSTOMER_TRX_LINE_ID AND LGD2.CUSTOMER_TRX_LINE_ID = LGD.CUSTOMER_TRX_LINE_ID AND LGD2.ACCOUNT_CLASS = LGD.ACCOUNT_CLASS AND LGD2.ACCOUNT_SET_FLAG = 'N' AND NVL(LGD2.GL_DATE, TO_DATE( 2415021, 'J') ) = NVL(LGD .GL_DATE, TO_DATE( 2415021, 'J') ) GROUP BY CTL.CUSTOMER_TRX_LINE_ID, DECODE(LGD2.ACCOUNT_CLASS, 'UNEARN', 'REV', LGD2.ACCOUNT_CLASS), REC1.GL_DATE, CTL.EXTENDED_AMOUNT, CTL.REVENUE_AMOUNT, CT.EXCHANGE_RATE ), PERCENT = (SELECT DECODE(LGD.ACCOUNT_CLASS || LGD.ACCOUNT_SET_FLAG, 'SUSPENSEN', LGD.PERCENT, 'UNBILLN', LGD.PERCENT, 'UNEARNN', LGD.PERCENT, NVL(LGD.PERCENT, 0) - ( SUM(NVL(LGD4.PERCENT, 0)) - DECODE(REC2.GL_DATE, NVL(LGD.GL_DATE, REC2.GL_DATE), 100, 0) ) ) FROM RA_CUST_TRX_LINE_GL_DIST LGD4, RA_CUST_TRX_LINE_GL_DIST REC2 WHERE REC2.CUSTOMER_TRX_ID = LGD.CUSTOMER_TRX_ID AND REC2.ACCOUNT_CLASS = 'REC' AND REC2.LATEST_REC_FLAG = 'Y' AND LGD4.CUSTOMER_TRX_LINE_ID = LGD.CUSTOMER_TRX_LINE_ID AND LGD4.ACCOUNT_SET_FLAG = LGD.ACCOUNT_SET_FLAG AND DECODE(LGD4.ACCOUNT_SET_FLAG, 'Y', LGD4.ACCOUNT_CLASS, LGD.ACCOUNT_CLASS) = LGD.ACCOUNT_CLASS AND NVL(LGD4.GL_DATE, TO_DATE( 2415021, 'J') ) = NVL(LGD.GL_DATE, TO_DATE( 2415021, 'J') ) GROUP BY REC2.GL_DATE, LGD.GL_DATE ), LAST_UPDATED_BY = :B1 , LAST_UPDATE_DATE = SYSDATE WHERE CUST_TRX_LINE_GL_DIST_ID IN (SELECT MIN(DECODE(LGD3.GL_POSTED_DATE, NULL, LGD3.CUST_TRX_LINE_GL_DIST_ID, NULL) ) FROM RA_CUSTOMER_TRX_LINES CTL, RA_CUST_TRX_LINE_GL_DIST LGD3, RA_CUST_TRX_LINE_GL_DIST REC3, RA_CUSTOMER_TRX T WHERE T.CUSTOMER_TRX_ID = :B5 AND REC3.CUSTOMER_TRX_ID = T.CUSTOMER_TRX_ID AND REC3.ACCOUNT_CLASS = 'REC' AND REC3.LATEST_REC_FLAG = 'Y' AND LGD3.CUSTOMER_TRX_ID = T.CUSTOMER_TRX_ID AND LGD3.ACCOUNT_S ET_FLAG = 'N' AND CTL.CUSTOMER_TRX_LINE_ID = LGD3.CUSTOMER_TRX_LINE_ID AND ( CTL.LINE_TYPE IN ('TAX', 'FREIGHT', 'CHARGES', 'SUSPENSE') OR (CTL.LINE_TYPE = 'LINE' AND CTL.ACCOUNTING_RULE_ID IS NULL) ) AND NVL(T.PREVIOUS_CUSTOMER_TRX_ID, -1) = DECODE(:B4 , 'INV', -1, 'REGULAR_CM', T.PREVIOUS_CUSTOMER_TRX_ID, NVL(T.PREVIOUS_CUSTOMER_TRX_ID, -1) ) GROUP BY CTL.CUSTOMER_TRX_LINE_ID, DECODE(LGD3.ACCOUNT_CLASS, 'UNEARN', 'REV', LGD3.ACCOUNT_CLASS), LGD3.GL_DATE, REC3.GL_DATE, CTL.EXTENDED_AMOUNT, CTL.REVENUE_AMOUNT, T.EXCHANGE_RATE HAVING ( SUM(NVL(LGD3.AMOUNT, 0)) <> DECODE(DECODE(LGD3.ACCOUNT_CLASS, 'UNEARN', 'REV', LGD3.ACCOUNT_CLASS), 'REV', CTL.REVENUE_AMOUNT, 'SUSPENSE', CTL.EXTENDED_AMOUNT - CTL.REVENUE_AMOUNT, CTL.EXTENDED_AMOUNT) * DECODE(LGD3.GL_DATE, REC3.GL_DATE, 1, 0) OR SUM(NVL(LGD3.ACCTD_AMOUNT, 0)) <> DECODE(LGD3.GL_DATE, REC3.GL_DATE, 1, 0) * DECODE(:B2 , NULL, ROUND(DECODE(DECODE(LGD3.ACCOUNT_CLASS, 'UNEARN', 'REV', LGD3.ACCOUNT_CLASS), 'REV', CTL.REVENUE_AMOUNT, 'SUSPENSE', CTL.EXTENDED_AMOUNT - CTL.REVENUE_AMOUNT, CTL.EXTENDED_AMOUNT) * NVL(T.EXCHANGE_RATE, 1), :B3 ), ROUND( (DECODE(DECODE(LGD3.ACCOUNT_CLASS, 'UNEARN', 'REV', LGD3.ACCOUNT_CLASS), 'REV', CTL.REVENUE_AMOUNT, 'SUSPENSE', CTL.EXTENDED_AMOUNT - CTL.REVENUE_AMOUNT, CTL.EXTENDED_AMOUNT) * NVL(T.EXCHANGE_RATE, 1) ) / :B2 ) * :B2 ) ) UNION SELECT TO_NUMBER( MIN(DECODE(LGD5.GL_POSTED_DATE||LGD5.ACCOUNT_CLASS|| LGD5.ACCOUNT_SET_FLAG, 'REVN', LGD 5.CUST_TRX_LINE_GL_DIST_ID, 'REVY', LGD5.CUST_TRX_LINE_GL_DIST_ID, 'TAXN', LGD5.CUST_TRX_LINE_GL_DIST_ID, 'TAXY', LGD5.CUST_TRX_LINE_GL_DIST_ID, 'FREIGHTN', LGD5.CUST_TRX_LINE_GL_DIST_ID, 'FREIGHTY', LGD5.CUST_TRX_LINE_GL_DIST_ID, 'CHARGESN', LGD5.CUST_TRX_LINE_GL_DIST_ID, 'CHARGESY', LGD5.CUST_TRX_LINE_GL_DIST_ID, 'UNEARNY', LGD5.CUST_TRX_LINE_GL_DIST_ID, 'UNBILLY', LGD5.CUST_TRX_LINE_GL_DIST_ID, NULL ) ) ) FROM RA_CUST_TRX_LINE_GL_DIST REC5, RA_CUST_TRX_LINE_GL_DIST LGD5, RA_CUSTOMER_TRX_LINES CTL2 WHERE CTL2.CUSTOMER_TRX_ID = :B5 AND REC5.CUSTOMER_TRX_ID = LGD5.CUSTOMER_TRX_ID AND REC5.ACCOUNT_CLASS = 'REC' AND REC5.LATEST_REC_FLAG = 'Y' AND LGD5.CUSTOMER_TRX_LINE_ID = CTL2.CUSTOMER_TRX_LINE_ID AND ( CTL2.LINE_TYPE IN ('TAX', 'FREIGHT', 'CHARGES', 'SUSPENSE') OR (CTL2.LINE_TYPE = 'LINE' AND (CTL2.ACCOUNTING_RULE_ID IS NULL OR LGD5.ACCOUNT_SET_FLAG = 'Y') ) ) GROUP BY LGD5.CUSTOMER_TRX_LINE_ID, LGD5.GL_DATE, REC5.GL_DATE, LGD5.ACCOUNT_SET_FLAG, DECODE(LGD5.ACCOUNT_SET_FLAG, 'N', NULL, LGD5.ACCOUNT_CLASS) HAVING SUM(NVL(LGD5.PERCENT, 0)) <> DECODE( NVL(LGD5.GL_DATE, REC5.GL_DATE), REC5.GL_DATE, 100, 0) )
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
cdjud36xbtuu5SELECT WIAS.PROCESS_ACTIVITY, WIAS.ACTIVITY_STATUS FROM WF_PROCESS_ACTIVITIES PA, WF_PROCESS_ACTIVITIES PA1, WF_ACTIVITIES A1, WF_ITEM_ACTIVITY_STATUSES WIAS WHERE PA.INSTANCE_ID = :B4 AND PA.ACTIVITY_ITEM_TYPE = PA1.PROCESS_ITEM_TYPE AND PA.ACTIVITY_NAME = PA1.PROCESS_NAME AND PA1.PROCESS_VERSION = A1.VERSION AND PA1.PROCESS_ITEM_TYPE = A1.ITEM_TYPE AND PA1.PROCESS_NAME = A1.NAME AND :B3 >= A1.BEGIN_DATE AND :B3 < NVL(A1.END_DATE, :B3 +1) AND PA1.INSTANCE_ID = WIAS.PROCESS_ACTIVITY AND WIAS.ITEM_TYPE = :B2 AND WIAS.ITEM_KEY = :B1 AND WIAS.ACTIVITY_STATUS <> 'COMPLETE'
cqc8bmqp529tzbegin arp_etax_autoinv_util . calculate_tax ( :request_id , :phase , :num_tax_failures ) ; END ;
cqgv56fmuj63xselect owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#
cvn54b7yz0s8uselect /*+ index(idl_ub1$ i_idl_ub11) +*/ piece#, length, piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece#
cw171rvngr1w9begin OE_FLEX_COGS_PUB.GET_COST_SALE_ITEM_DERIVED (:v1, :v2, :v3, :v4, :v5); end;
dcvv68fju01g4begin FND_FLEX_WORKFLOW_APIS.END_GENERATION (:v1, :v2, :v3, :v4, :v5); end;
f07y7y34utqz1SELECT SEQUENCE_NUMBER FROM WSH_DOCUMENT_INSTANCES WHERE ENTITY_NAME = :B3 AND ENTITY_ID = :B2 AND STATUS <> 'CANCELLED' AND DOCUMENT_TYPE = :B1
f34wj84pszqj0SELECT WI.ROOT_ACTIVITY, WI.ROOT_ACTIVITY_VERSION, WI.BEGIN_DATE, WI.USER_KEY FROM WF_ITEMS WI WHERE WI.ITEM_TYPE = :B2 AND WI.ITEM_KEY = :B1
fb13x9qx0ftksbegin OE_STANDARD_WF.OEOL_SELECTOR (:v1, :v2, :v3, :v4, :v5); end;
fvcbstf9s6a5rbegin WF_STANDARD.WAITFORFLOW (:v1, :v2, :v3, :v4, :v5); end;
fxz0vtz7p7vy2 SELECT R.Conc_Login_Id, R.Request_Id, R.Phase_Code, R.Status_Code, P.Application_ID, P.Concurrent_Program_ID, P.Concurrent_Program_Name, R.Enable_Trace, R.Restart, DECODE(R.Increment_Dates, 'Y', 'Y', 'N'), R.NLS_Compliant, R.OUTPUT_FILE_TYPE, E.Executable_Name, E.Execution_File_Name, A2.Basepath, DECODE(R.Stale, 'Y', 'C', P.Execution_Method_Code), P.Print_Flag, P.Execution_Options, DECODE(P.Srs_Flag, 'Y', 'Y', 'Q', 'Y', 'N'), P.Argument_Method_Code, R.Print_Style, R.Argument_Input_Method_Code, R.Queue_Method_Code, R.Responsibility_ID, R.Responsibility_Application_ID, R.Requested_By, R.Number_Of_Copies, R.Save_Output_Flag, R.Printer, R.Print_Group, R.Priority, U.User_Name, O.Oracle_Username, O.Encrypted_Oracle_Password, R.Cd_Id, A.Basepath, A.Application_Short_Name, TO_CHAR(R.Requested_Start_Date, 'YYYY/MM/DD HH24:MI:SS'), R.Nls_Language, R.Nls_Territory, R.Nls_Numeric_Characters, DECODE(R.Parent_Request_ID, NULL, 0, R.Parent_Request_ID), R.Priority_Request_ID, R.Single_Thread_Flag, R.Has_Sub_Request, R.Is_Sub_Request, R.Req_Information, R.Description, R.Resubmit_Time, TO_CHAR(R.Resubmit_Interval), R.Resubmit_Interval_Type_Code, R.Resubmit_Interval_Unit_Code, TO_CHAR(R.Resubmit_End_Date, 'YYYY/MM/DD HH24:MI:SS'), Decode(E.Execution_File_Name, NULL, 'N', Decode(E.Subroutine_Name, NULL, Decode(E.Execution_Method_Code, 'I', 'Y', 'J', 'Y', 'N'), 'Y')), R.Argument1, R.Argument2, R.Argument3, R.Arg ument4, R.Argument5, R.Argument6, R.Argument7, R.Argument8, R.Argument9, R.Argument10, R.Argument11, R.Argument12, R.Argument13, R.Argument14, R.Argument15, R.Argument16, R.Argument17, R.Argument18, R.Argument19, R.Argument20, R.Argument21, R.Argument22, R.Argument23, R.Argument24, R.Argument25, X.Argument26, X.Argument27, X.Argument28, X.Argument29, X.Argument30, X.Argument31, X.Argument32, X.Argument33, X.Argument34, X.Argument35, X.Argument36, X.Argument37, X.Argument38, X.Argument39, X.Argument40, X.Argument41, X.Argument42, X.Argument43, X.Argument44, X.Argument45, X.Argument46, X.Argument47, X.Argument48, X.Argument49, X.Argument50, X.Argument51, X.Argument52, X.Argument53, X.Argument54, X.Argument55, X.Argument56, X.Argument57, X.Argument58, X.Argument59, X.Argument60, X.Argument61, X.Argument62, X.Argument63, X.Argument64, X.Argument65, X.Argument66, X.Argument67, X.Argument68, X.Argument69, X.Argument70, X.Argument71, X.Argument72, X.Argument73, X.Argument74, X.Argument75, X.Argument76, X.Argument77, X.Argument78, X.Argument79, X.Argument80, X.Argument81, X.Argument82, X.Argument83, X.Argument84, X.Argument85, X.Argument86, X.Argument87, X.Argument88, X.Argument89, X.Argument90, X.Argument91, X.Argument92, X.Argument93, X.Argument94, X.Argument95, X.Argument96, X.Argument97, X.Argument98, X.Argument99, X.Argument100, R.number_of_arguments, C.CD_Name, NVL(R.Security _Group_ID, 0), NVL(R.org_id, 0) FROM fnd_concurrent_requests R, fnd_concurrent_programs P, fnd_application A, fnd_user U, fnd_oracle_userid O, fnd_conflicts_domain C, fnd_concurrent_queues Q, fnd_application A2, fnd_executables E, fnd_conc_request_arguments X WHERE R.Status_code = 'I' And ((R.OPS_INSTANCE is null) or (R.OPS_INSTANCE = -1) or (R.OPS_INSTANCE = decode(:dcp_on, 1, FND_CONC_GLOBAL.OPS_INST_NUM, R.OPS_INSTANCE))) And R.Request_ID = X.Request_ID(+) And R.Program_Application_Id = P.Application_Id(+) And R.Concurrent_Program_Id = P.Concurrent_Program_Id(+) And R.Program_Application_Id = A.Application_Id(+) And P.Executable_Application_Id = E.Application_Id(+) And P.Executable_Id = E.Executable_Id(+) And P.Executable_Application_Id = A2.Application_Id(+) And R.Requested_By = U.User_Id(+) And R.Cd_Id = C.Cd_Id(+) And R.Oracle_Id = O.Oracle_Id(+) And Q.Application_Id = :q_applid And Q.Concurrent_Queue_Id = :queue_id And (P.Enabled_Flag is NULL OR P.Enabled_Flag = 'Y') And R.Hold_Flag = 'N' And R.Requested_Start_Date <= Sysdate And ( R.Enforce_Seriality_Flag = 'N' OR ( C.RunAlone_Flag = P.Run_Alone_Flag And (P.Run_Alone_Flag = 'N' OR Not Exists (Select Null From Fnd_Concurrent_Requests Sr Where Sr.Status_Code In ('R', 'T') And Sr.Enforce_Seriality_Flag = 'Y' And Sr.CD_id = C.CD_Id)))) And Q.Running_Processes <= Q.Max_Processes And R.Rowid = :reqname And ((P.Execution_Method_Code != 'S' OR (R.PROGRAM_APPLICATION_ID, R.CONC URRENT_PROGRAM_ID) IN ((0, 98), (0, 100), (0, 31721), (0, 31722), (0, 31757))) AND ((R.PROGRAM_APPLICATION_ID, R.CONCURRENT_PROGRAM_ID) NOT IN ((510, 40032), (510, 40033), (510, 42156), (510, 42157), (530, 43793), (530, 43794), (535, 42626), (535, 42627), (535, 42628)))) FOR UPDATE OF R.status_code NoWait
g2qs4xk48vcwyselect to_char(CODE_COMBINATION_ID), nvl(ENABLED_FLAG, 'Y'), nvl(SUMMARY_FLAG, 'N'), to_char(START_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), to_char(END_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), SEGMENT1, SEGMENT2, SEGMENT3, SEGMENT4, SEGMENT5, DETAIL_BUDGETING_ALLOWED_FLAG, DETAIL_POSTING_ALLOWED_FLAG, ACCOUNT_TYPE, REFERENCE3, JGZZ_RECON_FLAG from GL_CODE_COMBINATIONS where CHART_OF_ACCOUNTS_ID = :FND_BIND1 and (SEGMENT1 = :FND_BIND2) and (SEGMENT2 = :FND_BIND3) and (SEGMENT3 = :FND_BIND4) and (SEGMENT4 = :FND_BIND5) and (SEGMENT5 = :FND_BIND6)
g8102j8yynbwzbegin WF_STANDARD.CONTINUEFLOW (:v1, :v2, :v3, :v4, :v5); end;
ga9j9xk5cy9s0select /*+ index(idl_sb4$ i_idl_sb41) +*/ piece#, length, piece from idl_sb4$ where obj#=:1 and part=:2 and version=:3 order by piece#
gccbpwamzp78qdeclare l_header_rounding_flag VARCHAR2 ( 1 ) ; BEGIN select trx_header_level_rounding into l_header_rounding_flag from ar_system_parameters ; :return_value:i_return_value := arp_rounding . correct_dist_rounding_errors ( :request_id , NULL , NULL , :rows_processed:i_rows_processed , :error_msg:i_error_msg , NULL , NULL , :trx_class , 'N' , :debug_mode , l_header_rounding_flag , 'N' ) ; END ;
gdnwgx9fcxggrbegin OE_SHIPPING_WF.START_SHIPPING (:v1, :v2, :v3, :v4, :v5); end;
ghmx8n7wgqvfrbegin WF_STANDARD.DEFER (:v1, :v2, :v3, :v4, :v5); end;
gksvm8wmzk8w0begin OE_INVOICE_WF.INVOICE_INTERFACE (:v1, :v2, :v3, :v4, :v5); end;
gnhmcahkmrnzsINSERT INTO WF_ITEM_ACTIVITY_STATUSES ( ITEM_TYPE, ITEM_KEY, PROCESS_ACTIVITY, ACTIVITY_STATUS, ACTIVITY_RESULT_CODE, ASSIGNED_USER, NOTIFICATION_ID, BEGIN_DATE, END_DATE, DUE_DATE, EXECUTION_TIME, OUTBOUND_QUEUE_ID ) VALUES ( :B13 , :B12 , :B11 , :B6 , :B10 , NULL, NULL, :B9 , :B8 , :B7 , DECODE(:B6 , :B5 , :B2 , :B4 , :B2 , :B3 , :B2 , NULL), :B1 )
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 761,527 669.97 1.23
CPU used when call started 760,033 668.66 1.23
CR blocks created 14,851,573 13,066.02 24.08
Cached Commit SCN referenced 26,970,570 23,728.00 43.73
Commit SCN cached 1,141 1.00 0.00
DB time 1,757,702 1,546.38 2.85
DBWR checkpoint buffers written 1,042,017 916.74 1.69
DBWR checkpoints 6 0.01 0.00
DBWR object drop buffers written 1,646 1.45 0.00
DBWR thread checkpoint buffers written 0 0.00 0.00
DBWR transaction table writes 104 0.09 0.00
DBWR undo block writes 697,122 613.31 1.13
DDL statements parallelized 0 0.00 0.00
DFO trees parallelized 4 0.00 0.00
IMU CR rollbacks 5,061,656 4,453.11 8.21
IMU Flushes 377,935 332.50 0.61
IMU Redo allocation size 1,015,103,024 893,060.89 1,645.75
IMU bind flushes 1 0.00 0.00
IMU commits 294,832 259.39 0.48
IMU contention 123,265 108.45 0.20
IMU ktichg flush 363 0.32 0.00
IMU recursive-transaction flush 21 0.02 0.00
IMU undo allocation size 1,576,472,008 1,386,938.54 2,555.88
PX local messages recv'd 7,111 6.26 0.01
PX local messages sent 7,111 6.26 0.01
Parallel operations downgraded 25 to 50 pct 3 0.00 0.00
Parallel operations downgraded 50 to 75 pct 0 0.00 0.00
Parallel operations not downgraded 1 0.00 0.00
SQL*Net roundtrips to/from client 166,522 146.50 0.27
active txn count during cleanout 55,999,627 49,267.00 90.79
application wait time 7,624 6.71 0.01
background checkpoints completed 0 0.00 0.00
background checkpoints started 0 0.00 0.00
background timeouts 4,389 3.86 0.01
branch node splits 298 0.26 0.00
buffer is not pinned count 387,572,665 340,976.22 628.36
buffer is pinned count 237,992,581 209,379.60 385.85
bytes received via SQL*Net from client 49,082,900 43,181.84 79.58
bytes sent via SQL*Net to client 334,134,478 293,962.71 541.72
calls to get snapshot scn: kcmgss 54,238,211 47,717.35 87.93
calls to kcmgas 17,220,509 15,150.15 27.92
calls to kcmgcs 975,697 858.39 1.58
change write time 21,231 18.68 0.03
cleanout - number of ktugct calls 16,358,152 14,391.47 26.52
cleanouts and rollbacks - consistent read gets 13,758,281 12,104.17 22.31
cleanouts only - consistent read gets 60,566 53.28 0.10
cluster key scan block gets 151,982 133.71 0.25
cluster key scans 82,388 72.48 0.13
commit batch/immediate performed 46,518 40.93 0.08
commit batch/immediate requested 46,518 40.93 0.08
commit cleanout failures: block lost 178,273 156.84 0.29
commit cleanout failures: buffer being written 9 0.01 0.00
commit cleanout failures: callback failure 40,860 35.95 0.07
commit cleanout failures: cannot pin 75,623 66.53 0.12
commit cleanouts 5,594,835 4,922.19 9.07
commit cleanouts successfully completed 5,300,070 4,662.86 8.59
commit immediate performed 46,518 40.93 0.08
commit immediate requested 46,518 40.93 0.08
commit txn count during cleanout 510,954 449.52 0.83
concurrency wait time 23,488 20.66 0.04
consistent changes 579,531,782 509,856.79 939.58
consistent gets 1,117,214,384 982,895.78 1,811.30
consistent gets - examination 805,987,395 709,086.47 1,306.72
consistent gets direct 48 0.04 0.00
consistent gets from cache 1,117,214,336 982,895.74 1,811.30
cursor authentications 3,202 2.82 0.01
data blocks consistent reads - undo records applied 574,365,621 505,311.74 931.20
db block changes 96,005,384 84,463.01 155.65
db block gets 87,053,003 76,586.94 141.14
db block gets direct 556 0.49 0.00
db block gets from cache 87,052,447 76,586.45 141.14
deferred (CURRENT) block cleanout applications 1,315,533 1,157.37 2.13
doubling up with imu segment 0 0.00 0.00
enqueue conversions 1,182 1.04 0.00
enqueue releases 3,704,546 3,259.16 6.01
enqueue requests 4,034,988 3,549.88 6.54
enqueue timeouts 330,423 290.70 0.54
enqueue waits 66,032 58.09 0.11
exchange deadlocks 88,461 77.83 0.14
execute count 46,041,302 40,505.92 74.65
failed probes on index block reclamation 311 0.27 0.00
free buffer inspected 702,752 618.26 1.14
free buffer requested 17,127,235 15,068.09 27.77
heap block compress 28,397,793 24,983.63 46.04
immediate (CR) block cleanout applications 13,818,860 12,157.47 22.40
immediate (CURRENT) block cleanout applications 486,971 428.42 0.79
index crx upgrade (found) 42,046 36.99 0.07
index crx upgrade (positioned) 4,749,849 4,178.79 7.70
index fast full scans (full) 0 0.00 0.00
index fast full scans (rowid ranges) 193 0.17 0.00
index fetch by key 95,814,839 84,295.37 155.34
index scans kdiixs1 53,552,683 47,114.24 86.82
java call heap collected bytes 774,872,216 681,712.16 1,256.27
java call heap collected count 10,721,406 9,432.41 17.38
java call heap gc count 2,259 1.99 0.00
java call heap live object count 553,803 487.22 0.90
java call heap live object count max 557,858 490.79 0.90
java call heap live size 211,230,904 185,835.38 342.46
java call heap live size max 211,786,256 186,323.97 343.36
java call heap object count 1,391,427 1,224.14 2.26
java call heap object count max 1,446,792 1,272.85 2.35
java call heap total size 293,601,280 258,302.67 476.01
java call heap total size max 293,601,280 258,302.67 476.01
java call heap used size 267,161,288 235,041.46 433.14
java call heap used size max 272,563,312 239,794.02 441.90
leaf node 90-10 splits 8,629 7.59 0.01
leaf node splits 84,497 74.34 0.14
lob reads 3,019,136 2,656.16 4.89
lob writes 1,311,101 1,153.47 2.13
lob writes unaligned 1,311,101 1,153.47 2.13
logons cumulative 551 0.48 0.00
messages received 479,467 421.82 0.78
messages sent 479,467 421.82 0.78
no buffer to keep pinned count 2 0.00 0.00
no work - consistent read gets 280,788,719 247,030.52 455.23
opened cursors cumulative 837,909 737.17 1.36
parse count (failures) 2 0.00 0.00
parse count (hard) 3,938 3.46 0.01
parse count (total) 2,001,876 1,761.20 3.25
parse time cpu 2,677 2.36 0.00
parse time elapsed 11,354 9.99 0.02
physical read IO requests 23,583 20.75 0.04
physical read bytes 590,774,272 519,747.64 957.80
physical read total IO requests 37,002 32.55 0.06
physical read total bytes 795,779,072 700,105.46 1,290.17
physical read total multi block requests 4,957 4.36 0.01
physical reads 72,116 63.45 0.12
physical reads cache 35,795 31.49 0.06
physical reads cache prefetch 15,781 13.88 0.03
physical reads direct 36,321 31.95 0.06
physical reads direct (lob) 52 0.05 0.00
physical reads direct temporary tablespace 36,266 31.91 0.06
physical reads prefetch warmup 13,015 11.45 0.02
physical write IO requests 86,029 75.69 0.14
physical write bytes 8,855,322,624 7,790,679.52 14,356.83
physical write total IO requests 848,438 746.43 1.38
physical write total bytes 25,852,484,608 22,744,334.79 41,913.75
physical write total multi block requests 822,237 723.38 1.33
physical writes 1,080,972 951.01 1.75
physical writes direct 36,822 32.40 0.06
physical writes direct (lob) 242 0.21 0.00
physical writes direct temporary tablespace 36,561 32.17 0.06
physical writes from cache 1,044,150 918.62 1.69
physical writes non checkpoint 1,006,016 885.07 1.63
pinned buffers inspected 4 0.00 0.00
prefetch warmup blocks flushed out before use 0 0.00 0.00
process last non-idle time 1,352 1.19 0.00
queries parallelized 4 0.00 0.00
recursive aborts on index block reclamation 9 0.01 0.00
recursive calls 84,279,058 74,146.49 136.64
recursive cpu usage 584,583 514.30 0.95
redo blocks written 33,146,702 29,161.60 53.74
redo entries 54,029,438 47,533.68 87.60
redo ordering marks 516,958 454.81 0.84
redo size 16,224,454,040 14,273,847.18 26,304.15
redo subscn max counts 1,125,358 990.06 1.82
redo synch time 15,737 13.84 0.03
redo synch writes 130,057 114.42 0.21
redo wastage 187,252,736 164,740.02 303.59
redo write time 20,813 18.31 0.03
redo writer latching time 145 0.13 0.00
redo writes 396,362 348.71 0.64
rollback changes - undo records applied 51,651 45.44 0.08
rollbacks only - consistent read gets 1,201,609 1,057.14 1.95
rows fetched via callback 32,173,717 28,305.59 52.16
session connect time 0 0.00 0.00
session cursor cache hits 1,876,001 1,650.46 3.04
session logical reads 1,204,267,384 1,059,482.71 1,952.44
session pga memory 165,489,216 145,593.05 268.30
session pga memory max 372,563,232 327,771.32 604.02
session uga memory 23,864,808 20,995.63 38.69
session uga memory max 7,703,216,760 6,777,087.14 12,488.96
shared hash latch upgrades - no wait 22,269,881 19,592.45 36.11
shared hash latch upgrades - wait 124,121 109.20 0.20
sorts (memory) 5,249,259 4,618.16 8.51
sorts (rows) 17,335,472 15,251.29 28.11
sql area purged 21 0.02 0.00
switch current to new buffer 1,086,224 955.63 1.76
table fetch by rowid 229,568,493 201,968.31 372.19
table fetch continued row 17,643,536 15,522.32 28.60
table scan blocks gotten 4,515,090 3,972.26 7.32
table scan rows gotten 197,915,555 174,120.89 320.87
table scans (direct read) 0 0.00 0.00
table scans (long tables) 609 0.54 0.00
table scans (rowid ranges) 609 0.54 0.00
table scans (short tables) 730,466 642.64 1.18
total number of times SMON posted 3,976 3.50 0.01
transaction rollbacks 46,518 40.93 0.08
transaction tables consistent read rollbacks 242 0.21 0.00
transaction tables consistent reads - undo records applied 237,166 208.65 0.38
undo change vector size 5,635,757,896 4,958,191.31 9,137.06
user I/O wait time 11,288 9.93 0.02
user calls 194,033 170.71 0.31
user commits 616,417 542.31 1.00
user rollbacks 385 0.34 0.00
workarea executions - optimal 2,112,320 1,858.36 3.42
write clones created in background 11 0.01 0.00
write clones created in foreground 41 0.04 0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session cursor cache count 5,471 30,478
opened cursors current 2,969 2,644
logons current 103 107

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived) 0 0.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 14 0 2.14 1.00 49,925 44 721,570 0.01
SYSTEM 15,494 14 2.99 1.02 539 0 26,866 0.09
APPS_TS_TX_DATA 1,418 1 5.84 6.09 10,617 9 281,014 0.06
APPS_TS_TX_IDX 1,767 2 5.85 3.68 7,307 6 158,488 0.06
APPS_TS_QUEUES 118 0 6.53 2.05 7,008 6 262,249 0.07
TEMP 3,557 3 2.67 10.28 3,564 3 0 0.00
APPS_TS_SUMMARY 58 0 6.38 1.00 4,742 4 72,543 0.03
APPS_TS_INTERFACE 227 0 9.56 6.00 1,426 1 85,085 0.03
SYSAUX 442 0 2.26 1.22 656 1 0 0.00
APPS_TS_SEED 621 1 5.19 4.02 149 0 1,818 4.25
APPS_TS_ARCHIVE 23 0 3.48 2.48 54 0 25 4.00
APPS_TS_NOLOGGING 6 0 8.33 1.00 12 0 735 0.08

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_TS_ARCHIVE /oracle/visdata/archive1.dbf 23 0 3.48 2.48 54 0 25 4.00
APPS_TS_INTERFACE /oracle/visdata/apps_ts_interface.dbf 5 0 10.00 9.20 69 0 4,114 0.03
APPS_TS_INTERFACE /oracle/visdata/apps_ts_interface10.dbf 4 0 5.00 11.50 63 0 2,295 0.04
APPS_TS_INTERFACE /oracle/visdata/apps_ts_interface11.dbf 7 0 4.29 6.86 62 0 3,909 0.01
APPS_TS_INTERFACE /oracle/visdata/apps_ts_interface13.dbf 3 0 20.00 10.33 59 0 3,064 0.04
APPS_TS_INTERFACE /oracle/visdata/apps_ts_interface15.dbf 6 0 10.00 9.83 61 0 2,641 0.02
APPS_TS_INTERFACE /oracle/visdata/apps_ts_interface16.dbf 6 0 13.33 6.67 61 0 3,254 0.04
APPS_TS_INTERFACE /oracle/visdata/apps_ts_interface17.dbf 2 0 10.00 15.50 56 0 3,907 0.00
APPS_TS_INTERFACE /oracle/visdata/apps_ts_interface18.dbf 8 0 12.50 7.38 63 0 1,613 0.01
APPS_TS_INTERFACE /oracle/visdata/apps_ts_interface21.dbf 5 0 22.00 7.20 54 0 3,089 0.04
APPS_TS_INTERFACE /oracle/visdata/apps_ts_interface22.dbf 7 0 1.43 8.71 53 0 5,178 0.02
APPS_TS_INTERFACE /oracle/visdata/apps_ts_interface26.dbf 23 0 7.39 3.09 17 0 1,082 0.26
APPS_TS_INTERFACE /oracle/visdata/apps_ts_interface27.dbf 51 0 6.86 2.75 86 0 7,963 0.08
APPS_TS_INTERFACE /oracle/visdata/apps_ts_interface28.dbf 32 0 9.38 4.28 83 0 6,616 0.03
APPS_TS_INTERFACE /oracle/visdata/apps_ts_interface29.dbf 8 0 16.25 9.50 69 0 5,486 0.02
APPS_TS_INTERFACE /oracle/visdata/apps_ts_interface30.dbf 11 0 12.73 7.91 66 0 3,528 0.07
APPS_TS_INTERFACE /oracle/visdata/apps_ts_interface31.dbf 15 0 9.33 5.53 73 0 4,346 0.02
APPS_TS_INTERFACE /oracle/visdata/apps_ts_interface32.dbf 5 0 14.00 9.20 73 0 4,679 0.02
APPS_TS_INTERFACE /oracle/visdata/apps_ts_interface33.dbf 6 0 11.67 9.00 71 0 4,286 0.00
APPS_TS_INTERFACE /oracle/visdata/apps_ts_interface34.dbf 4 0 2.50 12.25 74 0 3,982 0.03
APPS_TS_INTERFACE /oracle/visdata/apps_ts_interface35.dbf 6 0 11.67 10.00 72 0 3,872 0.05
APPS_TS_INTERFACE /oracle/visdata/apps_ts_interface36.dbf 6 0 16.67 8.17 70 0 2,449 0.01
APPS_TS_INTERFACE /oracle/visdata/apps_ts_interface4.dbf 7 0 11.43 7.57 71 0 3,732 0.05
APPS_TS_NOLOGGING /oracle/visdata/nologging1.dbf 6 0 8.33 1.00 12 0 735 0.08
APPS_TS_QUEUES /oracle/visdata/queues1.dbf 10 0 6.00 3.20 1,008 1 36,728 0.06
APPS_TS_QUEUES /oracle/visdata/queues2.dbf 6 0 5.00 1.00 1,001 1 32,530 0.08
APPS_TS_QUEUES /oracle/visdata/queues3.dbf 3 0 6.67 1.00 1,000 1 36,880 0.06
APPS_TS_QUEUES /oracle/visdata/queues4.dbf 9 0 5.56 1.78 996 1 33,993 0.09
APPS_TS_QUEUES /oracle/visdata/queues5.dbf 6 0 5.00 1.00 992 1 32,205 0.06
APPS_TS_QUEUES /oracle/visdata/queues6.dbf 74 0 6.49 1.95 1,016 1 47,208 0.07
APPS_TS_QUEUES /oracle/visdata/queues7.dbf 10 0 10.00 3.50 995 1 42,705 0.06
APPS_TS_SEED /oracle/visdata/reference1.dbf 87 0 4.60 4.28 33 0 221 3.89
APPS_TS_SEED /oracle/visdata/reference2.dbf 199 0 4.67 3.63 27 0 587 3.66
APPS_TS_SEED /oracle/visdata/reference3.dbf 73 0 5.34 4.36 29 0 220 3.27
APPS_TS_SEED /oracle/visdata/reference4.dbf 58 0 5.00 4.52 29 0 203 4.14
APPS_TS_SEED /oracle/visdata/reference5.dbf 204 0 5.93 4.01 31 0 587 5.38
APPS_TS_SUMMARY /oracle/visdata/summary1.dbf 2 0 15.00 1.00 394 0 5,042 0.02
APPS_TS_SUMMARY /oracle/visdata/summary10.dbf 2 0 10.00 1.00 397 0 4,965 0.02
APPS_TS_SUMMARY /oracle/visdata/summary11.dbf 2 0 0.00 1.00 385 0 6,338 0.01
APPS_TS_SUMMARY /oracle/visdata/summary12.dbf 1 0 10.00 1.00 386 0 5,115 0.01
APPS_TS_SUMMARY /oracle/visdata/summary13.dbf 2 0 5.00 1.00 393 0 5,124 0.02
APPS_TS_SUMMARY /oracle/visdata/summary2.dbf 2 0 10.00 1.00 390 0 4,929 0.02
APPS_TS_SUMMARY /oracle/visdata/summary3.dbf 27 0 6.30 1.00 66 0 6,878 0.09
APPS_TS_SUMMARY /oracle/visdata/summary4.dbf 4 0 10.00 1.00 392 0 5,975 0.02
APPS_TS_SUMMARY /oracle/visdata/summary5.dbf 2 0 5.00 1.00 382 0 4,704 0.02
APPS_TS_SUMMARY /oracle/visdata/summary6.dbf 6 0 1.67 1.00 388 0 6,167 0.01
APPS_TS_SUMMARY /oracle/visdata/summary7.dbf 4 0 5.00 1.00 391 0 4,774 0.04
APPS_TS_SUMMARY /oracle/visdata/summary8.dbf 1 0 30.00 1.00 382 0 5,623 0.01
APPS_TS_SUMMARY /oracle/visdata/summary9.dbf 3 0 0.00 1.00 396 0 6,909 0.02
APPS_TS_TX_DATA /oracle/visdata/tx_data11.dbf 23 0 8.70 7.09 240 0 6,427 0.03
APPS_TS_TX_DATA /oracle/visdata/tx_data12.dbf 28 0 5.36 6.32 226 0 6,906 0.02
APPS_TS_TX_DATA /oracle/visdata/tx_data13.dbf 24 0 5.42 6.96 242 0 7,657 0.03
APPS_TS_TX_DATA /oracle/visdata/tx_data17.dbf 0 0     59 0 184 0.00
APPS_TS_TX_DATA /oracle/visdata/tx_data19.dbf 16 0 5.00 7.06 67 0 321 0.31
APPS_TS_TX_DATA /oracle/visdata/tx_data2.dbf 21 0 1.90 6.95 223 0 6,510 0.02
APPS_TS_TX_DATA /oracle/visdata/tx_data21.dbf 20 0 7.00 7.10 247 0 6,668 0.02
APPS_TS_TX_DATA /oracle/visdata/tx_data22.dbf 19 0 7.89 6.89 94 0 224 0.00
APPS_TS_TX_DATA /oracle/visdata/tx_data23.dbf 3 0 10.00 5.33 0 0 20 8.50
APPS_TS_TX_DATA /oracle/visdata/tx_data24.dbf 3 0 6.67 5.33 70 0 185 1.03
APPS_TS_TX_DATA /oracle/visdata/tx_data25.dbf 2 0 5.00 5.50 0 0 25 5.20
APPS_TS_TX_DATA /oracle/visdata/tx_data27.dbf 136 0 6.54 2.75 41 0 2,844 0.59
APPS_TS_TX_DATA /oracle/visdata/tx_data28.dbf 59 0 7.29 2.81 20 0 238 5.50
APPS_TS_TX_DATA /oracle/visdata/tx_data29.dbf 17 0 7.06 3.00 6 0 468 1.18
APPS_TS_TX_DATA /oracle/visdata/tx_data30.dbf 15 0 6.67 1.73 5 0 54 0.93
APPS_TS_TX_DATA /oracle/visdata/tx_data31.dbf 14 0 5.00 2.71 9 0 112 2.86
APPS_TS_TX_DATA /oracle/visdata/tx_data32.dbf 62 0 6.13 5.84 156 0 3,708 0.15
APPS_TS_TX_DATA /oracle/visdata/tx_data34.dbf 1 0 0.00 1.00 0 0 0 0.00
APPS_TS_TX_DATA /oracle/visdata/tx_data36.dbf 1 0 0.00 1.00 0 0 0 0.00
APPS_TS_TX_DATA /oracle/visdata/tx_data37.dbf 2 0 5.00 3.50 71 0 213 0.00
APPS_TS_TX_DATA /oracle/visdata/tx_data39.dbf 48 0 7.92 6.42 122 0 460 1.57
APPS_TS_TX_DATA /oracle/visdata/tx_data41.dbf 4 0 5.00 2.50 82 0 279 0.00
APPS_TS_TX_DATA /oracle/visdata/tx_data42.dbf 0 0     85 0 249 0.04
APPS_TS_TX_DATA /oracle/visdata/tx_data43.dbf 40 0 7.75 6.98 286 0 9,164 0.04
APPS_TS_TX_DATA /oracle/visdata/tx_data44.dbf 49 0 5.10 6.43 275 0 8,703 0.18
APPS_TS_TX_DATA /oracle/visdata/tx_data45.dbf 40 0 3.75 7.40 268 0 6,973 0.03
APPS_TS_TX_DATA /oracle/visdata/tx_data46.dbf 33 0 2.73 6.70 273 0 6,825 0.01
APPS_TS_TX_DATA /oracle/visdata/tx_data47.dbf 54 0 4.07 4.98 281 0 6,948 0.03
APPS_TS_TX_DATA /oracle/visdata/tx_data48.dbf 28 0 9.64 7.75 270 0 9,868 0.04
APPS_TS_TX_DATA /oracle/visdata/tx_data49.dbf 22 0 8.18 7.50 279 0 6,791 0.02
APPS_TS_TX_DATA /oracle/visdata/tx_data50.dbf 28 0 7.50 7.18 262 0 6,191 0.18
APPS_TS_TX_DATA /oracle/visdata/tx_data51.dbf 28 0 4.64 6.82 274 0 6,579 0.01
APPS_TS_TX_DATA /oracle/visdata/tx_data52.dbf 0 0     65 0 163 0.00
APPS_TS_TX_DATA /oracle/visdata/tx_data53.dbf 21 0 6.19 7.33 251 0 7,171 0.15
APPS_TS_TX_DATA /oracle/visdata/tx_data54.dbf 28 0 7.14 7.04 241 0 6,264 0.02
APPS_TS_TX_DATA /oracle/visdata/tx_data55.dbf 20 0 11.00 6.65 273 0 6,195 0.03
APPS_TS_TX_DATA /oracle/visdata/tx_data56.dbf 24 0 2.92 6.13 244 0 6,178 0.03
APPS_TS_TX_DATA /oracle/visdata/tx_data57.dbf 24 0 7.08 6.88 247 0 6,240 0.04
APPS_TS_TX_DATA /oracle/visdata/tx_data58.dbf 21 0 4.29 7.43 249 0 6,348 0.03
APPS_TS_TX_DATA /oracle/visdata/tx_data59.dbf 22 0 5.45 6.77 252 0 5,715 0.03
APPS_TS_TX_DATA /oracle/visdata/tx_data60.dbf 24 0 4.17 6.50 215 0 6,471 0.02
APPS_TS_TX_DATA /oracle/visdata/tx_data61.dbf 23 0 4.78 7.70 230 0 7,377 0.02
APPS_TS_TX_DATA /oracle/visdata/tx_data62.dbf 18 0 1.67 8.06 224 0 6,738 0.01
APPS_TS_TX_DATA /oracle/visdata/tx_data63.dbf 22 0 5.45 6.64 248 0 6,664 0.02
APPS_TS_TX_DATA /oracle/visdata/tx_data64.dbf 22 0 5.91 6.50 242 0 6,820 0.01
APPS_TS_TX_DATA /oracle/visdata/tx_data65.dbf 25 0 6.00 7.04 244 0 6,517 0.01
APPS_TS_TX_DATA /oracle/visdata/tx_data66.dbf 22 0 4.09 8.00 227 0 6,375 0.01
APPS_TS_TX_DATA /oracle/visdata/tx_data67.dbf 22 0 5.45 7.36 224 0 5,717 0.03
APPS_TS_TX_DATA /oracle/visdata/tx_data68.dbf 25 0 4.00 7.48 213 0 6,405 0.02
APPS_TS_TX_DATA /oracle/visdata/tx_data69.dbf 23 0 3.91 7.09 216 0 7,332 0.01
APPS_TS_TX_DATA /oracle/visdata/tx_data70.dbf 22 0 2.73 7.36 212 0 7,127 0.03
APPS_TS_TX_DATA /oracle/visdata/tx_data71.dbf 17 0 10.00 7.59 221 0 7,063 0.01
APPS_TS_TX_DATA /oracle/visdata/tx_data72.dbf 25 0 6.00 6.08 215 0 6,661 0.02
APPS_TS_TX_DATA /oracle/visdata/tx_data73.dbf 20 0 3.00 6.65 219 0 6,465 0.02
APPS_TS_TX_DATA /oracle/visdata/tx_data74.dbf 18 0 5.00 8.06 211 0 6,444 0.02
APPS_TS_TX_DATA /oracle/visdata/tx_data75.dbf 22 0 4.09 6.73 230 0 5,877 0.02
APPS_TS_TX_DATA /oracle/visdata/tx_data76.dbf 23 0 8.26 6.35 214 0 5,706 0.03
APPS_TS_TX_DATA /oracle/visdata/tx_data77.dbf 24 0 6.67 6.71 230 0 7,221 0.16
APPS_TS_TX_DATA /oracle/visdata/tx_data78.dbf 21 0 5.24 6.95 227 0 5,966 0.02
APPS_TS_TX_IDX /oracle/visdata/tx_idx1.dbf 11 0 9.09 5.73 100 0 3,319 0.05
APPS_TS_TX_IDX /oracle/visdata/tx_idx10.dbf 10 0 7.00 6.50 100 0 3,360 0.01
APPS_TS_TX_IDX /oracle/visdata/tx_idx11.dbf 11 0 6.36 7.00 106 0 2,903 0.01
APPS_TS_TX_IDX /oracle/visdata/tx_idx12.dbf 12 0 7.50 5.58 99 0 2,965 0.02
APPS_TS_TX_IDX /oracle/visdata/tx_idx13.dbf 12 0 12.50 5.33 96 0 2,642 0.03
APPS_TS_TX_IDX /oracle/visdata/tx_idx14.dbf 12 0 10.00 3.83 102 0 2,906 0.09
APPS_TS_TX_IDX /oracle/visdata/tx_idx15.dbf 10 0 6.00 6.60 88 0 2,972 0.02
APPS_TS_TX_IDX /oracle/visdata/tx_idx16.dbf 15 0 6.67 5.13 91 0 2,592 0.08
APPS_TS_TX_IDX /oracle/visdata/tx_idx17.dbf 13 0 11.54 4.85 95 0 3,098 0.02
APPS_TS_TX_IDX /oracle/visdata/tx_idx18.dbf 8 0 3.75 6.13 83 0 2,935 0.01
APPS_TS_TX_IDX /oracle/visdata/tx_idx19.dbf 9 0 6.67 5.67 85 0 2,918 0.02
APPS_TS_TX_IDX /oracle/visdata/tx_idx2.dbf 13 0 3.85 4.23 86 0 3,035 0.03
APPS_TS_TX_IDX /oracle/visdata/tx_idx20.dbf 9 0 6.67 5.56 84 0 2,288 0.00
APPS_TS_TX_IDX /oracle/visdata/tx_idx21.dbf 10 0 5.00 7.00 81 0 2,444 0.01
APPS_TS_TX_IDX /oracle/visdata/tx_idx22.dbf 11 0 4.55 6.09 91 0 2,430 0.03
APPS_TS_TX_IDX /oracle/visdata/tx_idx23.dbf 21 0 6.67 4.57 90 0 2,764 0.01
APPS_TS_TX_IDX /oracle/visdata/tx_idx24.dbf 11 0 11.82 7.00 90 0 2,208 0.01
APPS_TS_TX_IDX /oracle/visdata/tx_idx25.dbf 16 0 8.75 6.06 83 0 2,310 0.02
APPS_TS_TX_IDX /oracle/visdata/tx_idx26.dbf 16 0 3.75 5.25 97 0 1,953 0.02
APPS_TS_TX_IDX /oracle/visdata/tx_idx27.dbf 256 0 5.59 2.43 151 0 11,274 0.21
APPS_TS_TX_IDX /oracle/visdata/tx_idx28.dbf 38 0 6.05 3.32 105 0 2,506 0.27
APPS_TS_TX_IDX /oracle/visdata/tx_idx29.dbf 509 0 4.75 2.30 221 0 5,862 0.20
APPS_TS_TX_IDX /oracle/visdata/tx_idx3.dbf 93 0 5.91 3.90 135 0 2,501 0.41
APPS_TS_TX_IDX /oracle/visdata/tx_idx30.dbf 37 0 6.22 4.08 1,300 1 4,035 0.01
APPS_TS_TX_IDX /oracle/visdata/tx_idx31.dbf 50 0 7.00 4.02 399 0 3,796 0.03
APPS_TS_TX_IDX /oracle/visdata/tx_idx32.dbf 37 0 7.57 4.78 343 0 3,406 0.04
APPS_TS_TX_IDX /oracle/visdata/tx_idx33.dbf 40 0 7.75 4.30 154 0 3,204 0.17
APPS_TS_TX_IDX /oracle/visdata/tx_idx34.dbf 35 0 4.00 3.86 135 0 2,509 0.03
APPS_TS_TX_IDX /oracle/visdata/tx_idx35.dbf 46 0 6.09 3.35 154 0 4,189 0.06
APPS_TS_TX_IDX /oracle/visdata/tx_idx36.dbf 29 0 7.59 4.90 145 0 4,296 0.04
APPS_TS_TX_IDX /oracle/visdata/tx_idx37.dbf 36 0 4.44 3.22 155 0 6,037 0.02
APPS_TS_TX_IDX /oracle/visdata/tx_idx38.dbf 21 0 3.81 4.48 150 0 3,822 0.02
APPS_TS_TX_IDX /oracle/visdata/tx_idx39.dbf 29 0 4.83 2.83 147 0 3,514 0.01
APPS_TS_TX_IDX /oracle/visdata/tx_idx4.dbf 9 0 6.67 7.11 133 0 2,734 0.01
APPS_TS_TX_IDX /oracle/visdata/tx_idx40.dbf 16 0 3.75 4.94 124 0 3,286 0.00
APPS_TS_TX_IDX /oracle/visdata/tx_idx41.dbf 17 0 5.29 5.88 135 0 2,342 0.01
APPS_TS_TX_IDX /oracle/visdata/tx_idx42.dbf 33 0 7.27 4.48 120 0 1,794 0.02
APPS_TS_TX_IDX /oracle/visdata/tx_idx43.dbf 16 0 8.13 5.94 117 0 2,254 0.02
APPS_TS_TX_IDX /oracle/visdata/tx_idx44.dbf 20 0 12.50 4.55 120 0 3,310 0.01
APPS_TS_TX_IDX /oracle/visdata/tx_idx45.dbf 16 0 7.50 5.06 122 0 3,389 0.00
APPS_TS_TX_IDX /oracle/visdata/tx_idx46.dbf 23 0 8.26 5.00 117 0 3,472 0.07
APPS_TS_TX_IDX /oracle/visdata/tx_idx47.dbf 12 0 6.67 6.75 123 0 2,619 0.01
APPS_TS_TX_IDX /oracle/visdata/tx_idx48.dbf 16 0 3.75 5.88 117 0 2,434 0.01
APPS_TS_TX_IDX /oracle/visdata/tx_idx49.dbf 15 0 4.00 5.00 104 0 2,796 0.03
APPS_TS_TX_IDX /oracle/visdata/tx_idx5.dbf 18 0 6.67 5.50 117 0 2,934 0.01
APPS_TS_TX_IDX /oracle/visdata/tx_idx6.dbf 16 0 3.75 6.38 110 0 3,139 0.01
APPS_TS_TX_IDX /oracle/visdata/tx_idx7.dbf 21 0 4.29 4.86 106 0 3,029 0.02
APPS_TS_TX_IDX /oracle/visdata/tx_idx8.dbf 21 0 7.14 5.62 102 0 2,469 0.01
APPS_TS_TX_IDX /oracle/visdata/tx_idx9.dbf 12 0 6.67 5.67 99 0 3,494 0.02
APPS_UNDOTS1 /oracle/visdata/undo.dbf 11 0 1.82 1.00 17,541 15 262,552 0.01
APPS_UNDOTS1 /oracle/visdata/undo1.dbf 3 0 3.33 1.00 32,384 28 459,018 0.01
SYSAUX /oracle/visdata/sysaux01.dbf 442 0 2.26 1.22 656 1 0 0.00
SYSTEM /oracle/visdata/sys1.dbf 1,459 1 2.95 1.00 31 0 351 0.63
SYSTEM /oracle/visdata/sys10.dbf 2,161 2 2.65 1.00 45 0 39 0.00
SYSTEM /oracle/visdata/sys2.dbf 2,327 2 2.24 1.01 33 0 702 0.06
SYSTEM /oracle/visdata/sys3.dbf 1,311 1 3.49 1.12 98 0 5,939 0.10
SYSTEM /oracle/visdata/sys4.dbf 1,196 1 3.33 1.05 97 0 6,907 0.04
SYSTEM /oracle/visdata/sys5.dbf 1,395 1 2.68 1.01 64 0 4,863 0.07
SYSTEM /oracle/visdata/sys6.dbf 1,030 1 3.76 1.01 40 0 3,258 0.06
SYSTEM /oracle/visdata/sys7.dbf 1,748 2 3.24 1.02 55 0 2,790 0.14
SYSTEM /oracle/visdata/sys8.dbf 1,469 1 3.16 1.01 39 0 726 0.21
SYSTEM /oracle/visdata/sys9.dbf 1,398 1 3.35 1.00 37 0 1,291 0.13
TEMP /oracle/visdata/temp1.dbf 1,427 1 1.68 9.89 1,426 1 0  
TEMP /oracle/visdata/temp2.dbf 2,130 2 3.34 10.54 2,138 2 0  

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,384,695 100 1,203,397,342 35,860 1,044,150 0 0 1,610,439


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 0 10 7514 201080 45298440 45298440    
E 0 294 157532 4156660 45298440 45298440    

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers for EstimateEst Phys Read FactorEstimated Physical Reads
D 1,920 0.10 237,480 1.04 549,777
D 3,840 0.20 474,960 1.02 538,129
D 5,760 0.30 712,440 1.01 535,571
D 7,680 0.40 949,920 1.00 530,150
D 9,600 0.50 1,187,400 1.00 529,661
D 11,520 0.60 1,424,880 1.00 529,154
D 13,440 0.70 1,662,360 1.00 529,129
D 15,360 0.80 1,899,840 1.00 529,129
D 17,280 0.90 2,137,320 1.00 529,129
D 19,200 1.00 2,374,800 1.00 529,129
D 19,280 1.00 2,384,695 1.00 529,129
D 21,120 1.10 2,612,280 1.00 529,129
D 23,040 1.20 2,849,760 1.00 529,129
D 24,960 1.29 3,087,240 1.00 529,129
D 26,880 1.39 3,324,720 1.00 529,129
D 28,800 1.49 3,562,200 1.00 529,129
D 30,720 1.59 3,799,680 1.00 529,129
D 32,640 1.69 4,037,160 1.00 529,129
D 34,560 1.79 4,274,640 1.00 529,129
D 36,480 1.89 4,512,120 1.00 529,129
D 38,400 1.99 4,749,600 0.93 494,122

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
100.00 25,767 0

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 3,072 2,632 335.60 0.00 0.00 0.00 0.00 314,570
E 3,072 2,627 266.00 0.00 0.00 0.00 0.00 314,570

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K 4K 2,084,680 2,084,680 0 0
64K 128K 573 573 0 0
128K 256K 109 109 0 0
256K 512K 401 401 0 0
512K 1024K 21,167 21,167 0 0
1M 2M 909 909 0 0
2M 4M 500 500 0 0
4M 8M 129 129 0 0
8M 16M 12 12 0 0
16M 32M 4 4 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
384 0.13 43,304.94 1,512.18 97.00 29
768 0.25 43,304.94 155.72 100.00 3
1,536 0.50 43,304.94 155.72 100.00 2
2,304 0.75 43,304.94 0.00 100.00 0
3,072 1.00 43,304.94 0.00 100.00 0
3,686 1.20 43,304.94 0.00 100.00 0
4,301 1.40 43,304.94 0.00 100.00 0
4,915 1.60 43,304.94 0.00 100.00 0
5,530 1.80 43,304.94 0.00 100.00 0
6,144 2.00 43,304.94 0.00 100.00 0
9,216 3.00 43,304.94 0.00 100.00 0
12,288 4.00 43,304.94 0.00 100.00 0
18,432 6.00 43,304.94 0.00 100.00 0
24,576 8.00 43,304.94 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
608 0.29 238 10,603 456,433 1.00 176 1.03 42,033,324
816 0.40 339 15,436 456,438 1.00 171 1.00 42,033,866
1,024 0.50 339 15,436 456,438 1.00 171 1.00 42,033,866
1,232 0.60 339 15,436 456,438 1.00 171 1.00 42,033,866
1,440 0.70 339 15,436 456,438 1.00 171 1.00 42,033,866
1,648 0.80 339 15,436 456,438 1.00 171 1.00 42,033,866
1,856 0.90 339 15,436 456,438 1.00 171 1.00 42,033,866
2,064 1.00 339 15,436 456,438 1.00 171 1.00 42,033,866
2,272 1.10 339 15,436 456,438 1.00 171 1.00 42,033,866
2,480 1.20 339 15,436 456,438 1.00 171 1.00 42,033,866
2,688 1.30 339 15,436 456,438 1.00 171 1.00 42,033,866
2,896 1.40 339 15,436 456,438 1.00 171 1.00 42,033,866
3,104 1.50 339 15,436 456,438 1.00 171 1.00 42,033,866
3,312 1.60 339 15,436 456,438 1.00 171 1.00 42,033,866
3,520 1.71 339 15,436 456,438 1.00 171 1.00 42,033,866
3,728 1.81 339 15,436 456,438 1.00 171 1.00 42,033,866
3,936 1.91 339 15,436 456,438 1.00 171 1.00 42,033,866
4,144 2.01 339 15,436 456,438 1.00 171 1.00 42,033,866

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
5,632 0.25 9,698 536,749
11,264 0.50 9,679 528,304
16,896 0.75 9,678 527,829
22,528 1.00 9,678 527,829
28,160 1.25 9,678 527,829
33,792 1.50 9,678 527,829
39,424 1.75 9,600 492,887
45,056 2.00 9,600 492,887

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Size for Est (MB)Size FactorEst Spill CountEst Spill Time (s)Est Unspill CountEst Unspill Time (s)
128 0.13 0 0 0 0
240 0.23 0 0 0 0
352 0.34 0 0 0 0
464 0.45 0 0 0 0
576 0.56 0 0 0 0
688 0.67 0 0 0 0
800 0.78 0 0 0 0
912 0.89 0 0 0 0
1,024 1.00 0 0 0 0
1,136 1.11 0 0 0 0
1,248 1.22 0 0 0 0
1,360 1.33 0 0 0 0
1,472 1.44 0 0 0 0
1,584 1.55 0 0 0 0
1,696 1.66 0 0 0 0
1,808 1.77 0 0 0 0
1,920 1.88 0 0 0 0
2,032 1.98 0 0 0 0
2,144 2.09 0 0 0 0
2,256 2.20 0 0 0 0

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
32 0.33 10 301 6 1.00 172 1.00 254
48 0.50 10 301 6 1.00 172 1.00 254
64 0.67 10 301 6 1.00 172 1.00 254
80 0.83 10 301 6 1.00 172 1.00 254
96 1.00 10 301 6 1.00 172 1.00 254
112 1.17 10 301 6 1.00 172 1.00 254
128 1.33 10 301 6 1.00 172 1.00 254
144 1.50 10 301 6 1.00 172 1.00 254
160 1.67 10 301 6 1.00 172 1.00 254
176 1.83 10 301 6 1.00 172 1.00 254
192 2.00 10 301 6 1.00 172 1.00 254
208 2.17 10 301 6 1.00 172 1.00 254

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
data block 848,269 53 0
undo block 672,248 7 0
segment header 10,073 2 0
1st level bmb 29,330 2 0
2nd level bmb 1,068 1 1
undo header 49,342 1 0
extent map 88 0 0
file header block 1 0 0

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
TX-Transaction (row lock contention) 343,474 13,630 329,844 13,405 77 5.74
TX-Transaction (allocate ITL entry) 666 657 9 660 60 90.15
TX-Transaction (index contention) 14,952 14,952 0 14,861 12 0.81
HW-Segment High Water Mark 76,795 76,769 26 14,216 5 0.33
TX-Transaction 840,883 840,406 0 9,419 4 0.46
SQ-Sequence Cache 42,060 42,060 0 11,651 1 0.09
FB-Format Block 19,851 19,851 0 1,804 0 0.24
RO-Multiple Object Reuse (fast object reuse) 54 54 0 6 0 11.67
CU-Cursor 3,856 3,856 0 7 0 5.71
PS-PX Process Reservation 504 432 72 3 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 677.61 752,216 657 30   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
31-Jul 14:57 547,952 714,181 657 30 33 0/0 0/0/0/0/0/0
31-Jul 14:47 129,662 38,035 0 29 87 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 769 0.00   0 0  
AWR Alerted Metric Element list 10,740 0.00   0 0  
Consistent RBA 397,382 0.15 0.00 0 0  
FOB s.o list latch 19,645 1.21 0.00 0 0  
In memory undo latch 490,242,959 0.82 0.00 0 677,423 0.07
JOX SGA heap latch 1,731,749 0.00 1.00 0 4,557 0.00
JS queue state obj latch 6,810 0.00   0 0  
KMG MMAN ready and startup request latch 935 0.00   0 0  
KMG resize request state object freelist 12 0.00   0 0  
KTF sga latch 0     0 364 0.00
KWQMN job cache list latch 206,353 1.16 0.05 0 0  
KWQP Prop Status 155 0.00   0 0  
MQL Tracking Latch 0     0 23 0.00
Memory Management Latch 610 0.16 0.00 0 929 0.00
NLS data objects 14 85.71 1.00 0 0  
OS process 1,641 0.00   0 0  
OS process allocation 1,452 0.07 0.00 0 0  
OS process: request allocation 978 0.20 0.00 0 0  
PL/SQL warning settings 1,284,895 0.00   0 0  
Policy Hash Table Latch 9 0.00   0 0  
SGA IO buffer pool latch 1,192 0.00   0 1,192 0.08
SQL memory manager latch 7 0.00   0 378 0.00
SQL memory manager workarea list latch 224,446 0.01 0.00 0 0  
Shared B-Tree 774 0.00   0 0  
active checkpoint queue latch 83,630 0.30 0.00 0 0  
active service list 4,855 4.18 0.02 0 405 0.00
begin backup scn array 197 0.00   0 0  
bq:time manger info latch 41 0.00   0 0  
buffer pool 10 0.00   0 0  
bufq statistics 21 0.00   0 0  
cache buffer handles 4,647,441 1.46 0.00 0 0  
cache buffers chains 2,966,203,477 2.68 0.00 3 15,060,299 4.67
cache buffers lru chain 4,351,331 0.33 0.00 0 31,684,430 0.50
cache table scan latch 205 0.49 0.00 0 205 1.46
channel handle pool latch 9,428 0.11 0.00 0 0  
channel operations parent latch 49,673 1.19 0.00 0 0  
checkpoint queue latch 2,345,332 0.02 0.00 0 1,203,679 0.01
client/application info 4,468 0.02 0.00 0 0  
commit callback allocation 222,254 0.15 0.00 0 0  
compile environment latch 29,793 0.00   0 0  
dictionary lookup 12 0.00   0 0  
dml lock allocation 4,981,465 4.31 0.00 0 0  
dummy allocation 1,194 2.76 0.00 0 0  
enqueue hash chains 7,844,073 1.16 0.00 0 182 0.00
enqueues 1,372,760 0.57 0.00 0 0  
error message lists 196 3.57 0.00 0 0  
event group latch 479 0.00   0 0  
file cache latch 21,347 0.01 0.00 0 0  
first spare latch 745,418 2.50 0.00 0 0  
global KZLD latch for mem in SGA 454 0.00   0 0  
global ctx hash table latch 270,874 0.00   0 0  
hash table column usage latch 682 4.84 0.00 0 471,937 0.00
hash table modification latch 166 2.41 0.00 0 0  
job_queue_processes parameter latch 19 0.00   0 0  
kks stats 6,496 0.00   0 0  
ksuosstats global area 90 0.00   0 0  
ktm global data 3,976 0.00   0 0  
kwqbsn:qsga 720 0.00   0 0  
kwqbsn:qxl 1 0.00   0 0  
kwqi:kchunk latch 2 0.00   0 0  
lgwr LWN SCN 399,796 0.56 0.00 0 0  
library cache 238,889,088 1.74 0.00 0 39 0.00
library cache load lock 26,222 1.47 0.00 0 146 0.00
library cache lock 13,072,894 1.03 0.00 0 0  
library cache lock allocation 51,280 0.00 0.00 0 0  
library cache pin 156,849,707 0.68 0.00 0 69 0.00
library cache pin allocation 75,129 0.00   0 0  
list of block allocation 155,283 0.09 0.00 0 0  
loader state object freelist 5,372 0.28 0.00 0 0  
logminer context allocation 7 0.00   0 0  
longop free list parent 4 0.00   0 3 0.00
message pool operations parent latch 9,250 0.18 0.00 0 0  
messages 1,356,929 0.57 0.00 0 0  
mostly latch-free SCN 472,122 13.68 0.00 0 0  
multiblock read objects 2,888 0.28 0.00 0 0  
ncodef allocation latch 19 0.00   0 0  
object queue header heap 351,923 0.00   0 11,553 0.02
object queue header operation 8,472,241 0.04 0.00 0 9,831 0.00
object stats modification 9,552 0.15 0.00 0 0  
parallel query alloc buffer 3,700 4.41 0.00 0 0  
parallel query stats 108 59.26 0.02 0 0  
parameter list 1,467 0.00   0 0  
parameter table allocation management 616 15.42 0.41 0 0  
post/wait queue 331,239 0.18 0.00 0 172,104 0.99
process allocation 982 2.55 0.60 0 470 1.91
process group creation 978 0.10 0.00 0 0  
process queue 2,384 1.47 0.00 0 0  
process queue reference 162,136 0.01 0.00 0 10,448 0.34
qmn state object latch 1 0.00   0 0  
qmn task queue latch 1,445 21.04 0.01 0 0  
query server freelists 2,196 23.09 0.00 0 0  
query server process 24 0.00   0 48 0.00
redo allocation 2,994,226 2.41 0.00 0 53,937,210 2.18
redo copy 0     0 54,031,608 0.09
redo writing 1,635,996 0.01 0.00 0 0  
resmgr group change latch 2,992 0.00   0 0  
resmgr:actses active list 1,648 0.42 0.00 0 0  
resmgr:actses change group 1,447 0.00   0 0  
resmgr:free threads list 1,193 4.44 0.00 0 0  
resmgr:schema config 7 0.00   0 0  
row cache objects 30,693,206 2.13 0.00 0 2 0.00
rules engine aggregate statistics 105,002 3.10 0.00 0 0  
rules engine evaluation context statistics 3 0.00   0 0  
rules engine rule set statistics 419,630 1.41 0.00 0 0  
rules engine rule statistics 209,512 0.00 0.00 0 0  
sequence cache 6,335,578 1.76 0.00 0 0  
session allocation 7,071,951 1.25 0.00 0 0  
session idle bit 417,345 0.01 0.00 0 0  
session state list latch 3,016 1.92 0.12 0 0  
session switching 19 0.00   0 0  
session timer 405 0.00   0 0  
shared pool 19,036,725 0.72 0.00 0 0  
shared pool sim alloc 452 1.55 0.00 0 0  
shared pool simulator 8,026,908 0.02 0.00 0 0  
simulator hash latch 77,142,047 0.01 0.00 0 0  
simulator lru latch 76,882,004 1.34 0.00 0 111,088 0.01
slave class 1 0.00   0 0  
slave class create 3 0.00   0 0  
sort extent pool 32,198 0.41 0.00 0 0  
state object free list 14 0.00   0 0  
statistics aggregation 588 0.00   0 0  
temp lob duration state obj allocation 2 0.00   0 0  
temporary table state object allocation 471 1.70 0.00 0 0  
threshold alerts latch 491 0.00   0 0  
trace latch 14 0.00   0 0  
transaction allocation 12,005 0.01 0.00 0 0  
transaction branch allocation 19 0.00   0 0  
undo global data 672,644,987 1.22 0.00 0 5,024 0.00
user lock 1,806 0.39 0.00 0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
cache buffers chains 2,966,203,477 79,447,821 273,024 79,178,918 0 0 0
undo global data 672,644,987 8,188,374 212 8,188,203 0 0 0
library cache 238,889,088 4,157,334 1,573 4,155,996 0 0 0
In memory undo latch 490,242,959 4,017,208 4,714 4,012,621 0 0 0
library cache pin 156,849,707 1,072,646 442 1,072,283 0 0 0
simulator lru latch 76,882,004 1,027,502 256 1,027,297 0 0 0
row cache objects 30,693,206 654,586 135 654,468 0 0 0
dml lock allocation 4,981,465 214,657 70 214,593 0 0 0
shared pool 19,036,725 137,022 194 136,861 0 0 0
library cache lock 13,072,894 135,251 19 135,236 0 0 0
sequence cache 6,335,578 111,330 5 111,326 0 0 0
enqueue hash chains 7,844,073 91,331 56 91,279 0 0 0
session allocation 7,071,951 88,074 136 87,961 0 0 0
redo allocation 2,994,226 72,028 293 71,747 0 0 0
cache buffer handles 4,647,441 67,901 2 67,899 0 0 0
first spare latch 745,418 18,612 33 18,580 0 0 0
cache buffers lru chain 4,351,331 14,575 12 14,563 0 0 0
simulator hash latch 77,142,047 10,990 4 10,986 0 0 0
enqueues 1,372,760 7,839 7 7,832 0 0 0
messages 1,356,929 7,799 2 7,797 0 0 0
rules engine rule set statistics 419,630 5,922 4 5,920 0 0 0
object queue header operation 8,472,241 3,326 5 3,321 0 0 0
KWQMN job cache list latch 206,353 2,385 114 2,276 0 0 0
shared pool simulator 8,026,908 1,385 2 1,383 0 0 0
qmn task queue latch 1,445 304 3 301 0 0 0
active service list 4,855 203 5 196 0 0 0
parameter table allocation management 616 95 39 62 0 0 0
parallel query stats 108 64 1 63 0 0 0
session state list latch 3,016 58 7 51 0 0 0
process allocation 982 25 15 10 0 0 0
NLS data objects 14 12 12 0 0 0 0
JOX SGA heap latch 1,731,749 1 1 0 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
In memory undo latch ktiFlush: child 0 2,899 2,754
In memory undo latch ktichg: child 0 787 722
In memory undo latch kticmt: child 0 725 17
In memory undo latch kturbk 0 285 1,028
In memory undo latch ktiTxnPoolFree 0 10 1
In memory undo latch ktbgfc 0 8 192
KWQMN job cache list latch kwqmnuji: update job item 0 1,130 1,088
KWQMN job cache list latch kwqmndej: dequeue 0 112 154
Memory Management Latch kmgs_perform_parameter_updates1 0 1 1
NLS data objects klcslod 0 12 12
active service list ksws_event: ksws event 0 30 24
cache buffer handles kcbzgs 0 2 0
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 1,220,271 1,077,542
cache buffers chains kcbgtcr: fast path 0 279,192 16,399
cache buffers chains kcbgtcr: kslbegin excl 0 196,082 98,489
cache buffers chains kcbchg: kslbegin: call CR func 0 147,996 647,560
cache buffers chains kcbgcur: kslbegin 0 68,357 21,176
cache buffers chains kcbget: pin buffer 0 18,551 5,910
cache buffers chains kcbzwb 0 16,595 13,476
cache buffers chains kcbrls: kslbegin 0 13,517 70,037
cache buffers chains kcbzgb: scan from tail. nowait 0 13,024 0
cache buffers chains kcbcge 0 699 13,865
cache buffers chains kcbget: exchange 0 411 787
cache buffers chains kcb_is_private 0 369 6,099
cache buffers chains kcbget: exchange rls 0 231 422
cache buffers chains kcbnlc 0 124 1,896
cache buffers chains kcbesc: escalate 0 41 15
cache buffers chains kcbgtcr: kslbegin shared 0 14 13
cache buffers chains kcbso1: set no access 0 14 37
cache buffers chains kcb_post_apply: kcbhq62 0 12 78
cache buffers chains kcbnew: new latch again 0 12 0
cache buffers chains kcb_pre_apply: kcbhq61 0 4 1,385
cache buffers chains kcbzhngcbk1: get hash chain latch no wait 0 4 0
cache buffers chains kcb_post_apply: kcbhq63 0 1 71
cache buffers chains kcbbic1 0 1 1
cache buffers chains kcbw_next_free 0 1 0
cache buffers lru chain kcbzgws 0 6 0
cache buffers lru chain kcbgtcr:CR Scan:KCBRSKIP 0 3 0
cache buffers lru chain kcbbic2 0 2 8
cache buffers lru chain kcbzgb: posted for free bufs 0 1 2
dml lock allocation ktaiam 0 58 49
dml lock allocation ktaidm 0 12 21
enqueue hash chains ksqgtl3 0 33 23
enqueue hash chains ksqrcl 0 22 31
enqueue hash chains ksqcmi: kslgpl 0 1 0
enqueues ksqgel: failed to get enqueue 0 3 1
enqueues ksqies 0 2 3
enqueues ksqdel 0 1 2
enqueues ksqgel: create enqueue 0 1 1
event range base latch No latch 0 37 37
library cache kglpndl: child: after processing 0 552 31
library cache kglpnc: child 0 293 455
library cache kglpnp: child 0 274 340
library cache kglpndl: child: before processing 0 222 488
library cache kglobpn: child: 0 103 183
library cache kglpin: child: heap processing 0 55 28
library cache kglhdgc: child: 0 24 23
library cache kglScanDependency 0 11 0
library cache kglhdgn: child: 0 9 7
library cache kgldti: 2child 0 6 5
library cache kglprg: child 0 4 0
library cache kglLockCursor 0 3 7
library cache kglget: unpin heap 0 0 3 3
library cache kglrtl 0 3 0
library cache kgldte: child 0 0 2 2
library cache kglpin 0 2 1
library cache lock kgllkal: child: multiinstance 0 15 13
library cache lock kgllkdl: child: no lock handle 0 7 3
library cache lock kgllkdl: child: cleanup 0 4 6
library cache pin kglpndl 0 184 176
library cache pin kglpnc: child 0 114 122
library cache pin kglpnp: child 0 108 112
library cache pin kglpnal: child: alloc space 0 36 33
messages ksarcv 0 1 1
messages ksarcv: after wait 0 1 0
object queue header operation kcbo_switch_mq_bg 0 2 3
object queue header operation kcbw_link_q 0 2 1
object queue header operation kcbo_ivbo 0 1 0
object queue header operation kcbo_swap_buf 0 1 2
object queue header operation kcbo_switch_cq 0 1 0
object queue header operation kcbo_switch_q_bg 0 1 0
parallel query stats kxfprst: KSLBEGIN:1 0 1 1
parameter table allocation management ksp_param_table_free 0 39 39
process allocation ksucrp 0 11 0
process allocation ksudlp 0 4 0
redo allocation kcrfw_redo_gen: redo allocation 1 0 215 0
redo allocation kcrfw_redo_gen: redo allocation 3 0 57 86
redo allocation kcrfw_redo_gen: redo allocation 2 0 15 0
redo allocation kcrfw_redo_write: more space 0 4 139
redo allocation kcrfw_redo_write: before write 0 2 69
row cache objects kqreqd: reget 0 60 2
row cache objects kqrpre: find obj 0 53 114
row cache objects kqreqd 0 22 19
rules engine rule set statistics kwrsoef: find ectx stats 0 4 0
sequence cache kdnnxt: cached seq 0 2 0
sequence cache kdnssd 0 2 0
sequence cache kdnss 0 1 5
session allocation ksuprc 0 59 43
session allocation ksudlc 0 44 62
session allocation ksuxds: KSUSFCLC not set 0 22 19
session allocation kxfprdp 0 5 2
session allocation kxfpqidqr 0 4 1
session allocation ksucri 0 1 1
session allocation ksursi 0 1 8
session state list latch kpseqd 0 5 0
session state list latch kpscad 0 2 5
shared pool kghalo 0 109 84
shared pool kghfre 0 42 62
shared pool kghupr1 0 31 46
shared pool kghfnd: get next extent 0 10 0
shared pool kghalp 0 1 4
shared pool kghfnd: req scan 0 1 0
shared pool simulator kglsim_unpin_simhp 0 2 2
simulator hash latch kcbsacc: lookup dba 0 4 4
simulator lru latch kcbs_simulate: simulate set 0 254 249
simulator lru latch kcbs_shrink_pool 0 2 0
undo global data ktudba: KSLBEGIN 0 107 186
undo global data kturimugur: child 0 93 23
undo global data ktudnx:child 0 12 3

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
APPLSYS APPS_TS_SEED WF_ACTIVITIES_PK   INDEX 83,976,704 6.97
APPLSYS APPS_TS_SEED WF_ACTIVITIES   TABLE 42,943,392 3.57
INV APPS_TS_INTERFACE MTL_TRANSACTIONS_INTERFACE   TABLE 33,159,184 2.75
APPLSYS APPS_TS_TX_IDX WF_ITEM_ACTIVITY_STATUSES_PK WF_ITEM49 INDEX PARTITION 29,558,416 2.45
APPLSYS APPS_TS_SEED WF_PROCESS_ACTIVITIES_PK   INDEX 20,463,696 1.70

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
XLA APPS_TS_TX_DATA XLA_AE_HEADERS AR TABLE PARTITION 770 1.07
AR APPS_TS_INTERFACE RA_INTERFACE_SALESCREDITS_ALL   TABLE 704 0.98
SYS SYSTEM SYS_C001304   INDEX 244 0.34
SYS SYSTEM DBMS_LOCK_ALLOCATED   TABLE 225 0.31
MRP APPS_TS_INTERFACE MRP_RELIEF_INTERFACE_N1   INDEX 189 0.26

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
APPLSYS APPS_TS_QUEUES SYS_IOT_TOP_155893   INDEX 934,923 57.14
WSH APPS_TS_INTERFACE WSH_PR_WORKERS   TABLE 648,503 39.64
APPLSYS APPS_TS_TX_DATA WF_ITEMS   TABLE 25,187 1.54
APPLSYS APPS_TS_TX_DATA FND_CONCURRENT_REQUESTS   TABLE 11,068 0.68
ASO APPS_TS_QUEUES SYS_IOT_TOP_115215   INDEX 3,999 0.24

Back to Segment Statistics
Back to Top

Segments by ITL Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeITL Waits% of Capture
APPLSYS APPS_TS_TX_DATA WF_ITEM_ACTIVITY_STATUSES WF_ITEM49 TABLE PARTITION 606 92.66
ASO APPS_TS_QUEUES SYS_IOT_TOP_115213   INDEX 9 1.38
AR APPS_TS_TX_IDX RA_CUST_TRX_LINE_GL_DIST_N6   INDEX 6 0.92
MRP APPS_TS_TX_IDX MRP_SO_LINES_N1   INDEX 3 0.46
MRP APPS_TS_TX_IDX MRP_SO_LINES_N2   INDEX 3 0.46

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
APPLSYS APPS_TS_QUEUES SYS_IOT_TOP_155893   INDEX 174,673 20.00
APPLSYS APPS_TS_TX_DATA WF_ITEM_ACTIVITY_STATUSES WF_ITEM49 TABLE PARTITION 87,510 10.02
ONT APPS_TS_TX_DATA OE_ORDER_LINES_ALL   TABLE 79,683 9.12
ONT APPS_TS_SUMMARY ONT_DBI_CHANGE_LOG   TABLE 49,421 5.66
INV APPS_TS_INTERFACE MTL_TRANSACTIONS_INTERFACE   TABLE 48,299 5.53

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control 48 0.00 0   14 1
dc_constraints 47 44.68 0   47 9
dc_global_oids 1,204,947 0.00 0   4 78
dc_histogram_data 10,074 4.49 0   4 1,971
dc_histogram_defs 96,916 9.28 0   491 21,983
dc_object_grants 1,835 6.81 0   0 278
dc_object_ids 3,526,763 0.06 0   7 4,825
dc_objects 229,033 1.64 0   67 6,560
dc_profiles 454 0.00 0   0 1
dc_rollback_segments 714 0.00 0   0 50
dc_segments 77,888 3.31 0   18,343 5,331
dc_sequences 45,398 0.12 0   45,398 71
dc_table_scns 206,589 0.01 0   14 15
dc_tablespace_quotas 19,329 0.10 0   0 39
dc_tablespaces 271,979 0.00 0   0 57
dc_usernames 502,344 0.00 0   0 68
dc_users 4,232,858 0.00 0   0 110
outstanding_alerts 221 1.36 0   1 110


Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY 18,100 2.30 10,115,851 0.00 0 0
CLUSTER 42 0.00 56 0.00 0 0
INDEX 748 5.48 1,146 4.10 0 0
JAVA DATA 115 2.61 1,060 2.36 0 0
PIPE 171 0.00 171 0.00 0 0
SQL AREA 9,473 94.48 49,536,174 0.00 249 64
TABLE/PROCEDURE 49,013 8.99 15,275,669 0.07 2 0
TRIGGER 833 2.04 787,970 -0.00 0 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 221.39   1.74 1.95 22 31 127 127
  Freeable 94.94 0.00 0.90 1.57 10   105 105
  SQL 12.17 5.76 0.10 0.16 1 21 120 91
  PL/SQL 7.14 2.58 0.06 0.05 0 4 127 103
E Other 186.34   1.74 2.10 22 31 107 107
  Freeable 57.25 0.00 0.73 1.82 10   78 78
  SQL 15.91 8.08 0.16 0.28 2 6 100 97
  PL/SQL 6.54 2.70 0.06 0.04 0 0 107 107

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers 20,300,431,360 20,216,545,280
Fixed Size 2,115,136  
Redo Buffers 64,991,232  
Variable Size 3,254,782,400 3,338,668,480

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
java free memory 16.00 81.15 407.16
java joxlod exec hp   14.18  
large PX msg pool 1.03 1.03 0.00
large free memory 14.97 14.97 0.00
shared ASH buffers 40.50 40.50 0.00
shared CCursor   24.53  
shared KGLS heap   30.52  
shared PL/SQL MPCODE   39.84  
shared db_block_hash_buckets 180.00 180.00 0.00
shared free memory 1,600.63 1,303.09 -18.59
shared ktcmvcb   24.15  
shared library cache   43.82  
shared private strands 22.17 22.17 0.00
shared sql area 20.95 167.98 701.74
streams free memory 1,023.99 1,023.99 -0.00
  buffer_cache 19,360.00 19,280.00 -0.41
  fixed_sga 2.02 2.02 0.00
  log_buffer 61.98 61.98 0.00

Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

Session TypeCPU TimeUser I/O TimeSys I/O Time
QMON Slaves 14,680,098 -612,610 0
QMON Coordinator 16,249 0 0

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

Queue Schema and NameIncoming per secondOutgoing per secondSpilled per secondDiff Pct Spilled
APPLSYS.WF_CONTROL 0 0 0 0

Back to Streams Statistics
Back to Top

Buffered Subscribers

Subscriber NameIncoming per secondOutgoing per secondSpilled per second
WFBESCL_20638 0 0 0

Back to Streams Statistics
Back to Top

Rule Set

Ruleset NameEvalsFast EvalsSQL ExecsCPU TimeElapsed Time
APPLSYS.WF_DEFERRED_QUEUE_M_R 104,736 0 104,849 830 774
SYS.ALERT_QUE_R 1 0 0 0 0
APPLSYS.FND_CP_GSM_OPP_AQ_R 1 0 0 0 0

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.


Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
_b_tree_bitmap_plans FALSE   
_fast_full_scan_enabled FALSE   
_gby_hash_aggregation_enabled FALSE   
_kks_use_mutex_pin FALSE   
_like_with_bind_as_equality TRUE   
_sort_elimination_cost_ratio 5   
_sqlexec_progression_cost 2147483647   
_system_trig_enabled TRUE   
_trace_files_public TRUE   
aq_tm_processes 4   
background_dump_dest /oracle/db/tech_st/10.2.0/admin/VIS_db1/bdump   
compatible 10.2.0.3   
control_files /raw_links/cntrl01.dbf, /raw_links/cntrl02.dbf, /raw_links/cntrl03.dbf   
core_dump_dest /oracle/db/tech_st/10.2.0/admin/VIS_db1/cdump   
cursor_sharing EXACT   
db_block_checking FALSE   
db_block_checksum TRUE   
db_block_size 8192   
db_files 512   
db_name VIS   
dml_locks 10000   
ifile /oracle/db/tech_st/10.2.0/dbs/VIS_db1_ifile.ora   
job_queue_processes 4   
log_buffer 63021056   
log_checkpoint_interval 0   
log_checkpoint_timeout 0   
log_checkpoints_to_alert TRUE   
max_dump_file_size 20480   
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 600   
optimizer_index_caching 0   
optimizer_index_cost_adj 50   
optimizer_secure_view_merging FALSE   
parallel_max_servers 24   
parallel_min_servers 0   
pga_aggregate_target 3221225472   
plsql_code_type INTERPRETED   
plsql_native_library_dir /oracle/db/tech_st/10.2.0/plsql/nativelib   
plsql_native_library_subdir_count 149   
plsql_optimize_level 2   
processes 800   
session_cached_cursors 500   
sessions 1600   
sga_target 23622320128   
shared_pool_reserved_size 1073741824   
shared_pool_size 2147483648   
streams_pool_size 1073741824   
timed_statistics TRUE   
undo_management AUTO   
undo_retention 36000   
undo_tablespace APPS_UNDOTS1   
user_dump_dest /oracle/db/tech_st/10.2.0/admin/VIS_db1/udump   
utl_file_dir /usr/tmp, /usr/tmp, /oracle/db/tech_st/10.2.0/appsutil/outbound/VIS_db1, /usr/tmp   
workarea_size_policy AUTO   


Back to Top

End of Report