WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host
VIS 187584551 VIS 1 10.2.0.3.0 NO hpdb1.zko.hp

  Snap Id Snap Time Sessions Cursors/Session
Begin Snap: 1 17-Apr-09 12:03:50 5268 210.3
End Snap: 2 17-Apr-09 13:03:54 5294 235.3
Elapsed:   60.07 (mins)    
DB Time:   369.01 (mins)    

 

Report Summary

Cache Sizes

  Begin End    
Buffer Cache: 17,840M 17,648M Std Block Size: 8K
Shared Pool Size: 2,544M 2,736M Log Buffer: 14,320K

Load Profile

  Per Second Per Transaction
Redo size: 8,970,575.12 25,845.15
Logical reads: 578,414.73 1,666.47
Block changes: 55,995.82 161.33
Physical reads: 127.67 0.37
Physical writes: 868.27 2.50
User calls: 13,799.82 39.76
Parses: 2,572.39 7.41
Hard parses: 2.61 0.01
Sorts: 3,063.47 8.83
Logons: 2.83 0.01
Executes: 29,118.89 83.89
Transactions: 347.09  

% Blocks changed per Read: 9.68 Recursive Call %: 77.33
Rollback per transaction %: 21.19 Rows per Sort: 12.36

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.97 Redo NoWait %: 100.00
Buffer Hit %: 99.98 In-memory Sort %: 100.00
Library Hit %: 99.78 Soft Parse %: 99.90
Execute to Parse %: 91.17 Latch Hit %: 99.08
Parse CPU to Parse Elapsd %: 91.08 % Non-Parse CPU: 97.77

Shared Pool Statistics

  Begin End
Memory Usage %: 86.68 86.85
% SQL with executions>1: 88.80 89.52
% Memory for SQL w/exec>1: 64.34 65.02

Top 5 Timed Events

Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class
CPU time   19,953   90.1  
db file sequential read 295,831 1,176 4 5.3 User I/O
log file sync 556,025 947 2 4.3 Commit
log file parallel write 866,325 540 1 2.4 System I/O
SQL*Net more data from client 2,573,113 212 0 1.0 Network

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic Name Time (s) % of DB Time
DB CPU 19,953.03 90.12
sql execute elapsed time 18,608.44 84.05
PL/SQL execution elapsed time 4,513.11 20.38
inbound PL/SQL rpc elapsed time 4,378.59 19.78
parse time elapsed 555.23 2.51
Java execution elapsed time 487.66 2.20
hard parse elapsed time 289.99 1.31
repeated bind elapsed time 88.35 0.40
sequence load elapsed time 13.33 0.06
connection management call elapsed time 10.05 0.05
PL/SQL compilation elapsed time 6.55 0.03
hard parse (sharing criteria) elapsed time 3.42 0.02
failed parse elapsed time 1.46 0.01
hard parse (bind mismatch) elapsed time 0.93 0.00
DB time 22,140.75  
background elapsed time 1,170.46  
background cpu time 333.56  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait Class Waits %Time -outs Total Wait Time (s) Avg wait (ms) Waits /txn
User I/O 350,784 0.00 1,318 4 0.28
Commit 556,025 0.00 947 2 0.44
System I/O 1,143,990 0.00 750 1 0.91
Network 56,709,685 0.00 280 0 45.33
Concurrency 2,031,397 0.17 170 0 1.62
Application 70,504 0.02 112 2 0.06
Other 130,873 19.81 38 0 0.10
Configuration 7,165 0.00 3 0 0.01

Back to Wait Events Statistics
Back to Top

Wait Events

Event Waits %Time -outs Total Wait Time (s) Avg wait (ms) Waits /txn
db file sequential read 295,831 0.00 1,176 4 0.24
log file sync 556,025 0.00 947 2 0.44
log file parallel write 866,325 0.00 540 1 0.69
SQL*Net more data from client 2,573,113 0.00 212 0 2.06
db file parallel write 246,771 0.00 199 1 0.20
db file scattered read 12,429 0.00 76 6 0.01
read by other session 39,515 0.00 64 2 0.03
SQL*Net message to client 52,095,478 0.00 52 0 41.64
enq: UL - contention 2,108 0.62 49 23 0.00
latch: cache buffers chains 1,300,031 0.00 48 0 1.04
cursor: pin S wait on X 3,829 90.36 38 10 0.00
enq: TX - row lock contention 687 0.44 37 54 0.00
buffer busy waits 643,254 0.00 28 0 0.51
enq: TX - index contention 27,817 0.00 22 1 0.02
SQL*Net more data to client 2,041,094 0.00 17 0 1.63
SQL*Net break/reset to client 67,672 0.00 14 0 0.05
latch: In memory undo latch 35,100 0.00 11 0 0.03
library cache load lock 539 0.00 10 18 0.00
control file sequential read 29,155 0.00 9 0 0.02
PX Deq Credit: send blkd 21,172 0.00 8 0 0.02
latch: library cache 11,556 0.00 8 1 0.01
rdbms ipc reply 5 60.00 7 1433 0.00
enq: RO - fast object reuse 32 0.00 6 186 0.00
enq: TM - contention 5 0.00 5 1074 0.00
latch: undo global data 9,378 0.00 4 0 0.01
latch: object queue header operation 21,468 0.00 3 0 0.02
kksfbc child completion 71 84.51 3 42 0.00
PX Deq: Signal ACK 253 37.15 3 10 0.00
latch: library cache pin 3,051 0.00 2 1 0.00
LGWR wait for redo copy 32,110 0.02 2 0 0.03
os thread startup 70 0.00 2 29 0.00
latch: cache buffers lru chain 2,121 0.00 2 1 0.00
enq: HW - contention 2,587 0.00 1 1 0.00
local write wait 1,773 0.00 1 1 0.00
control file parallel write 1,739 0.00 1 1 0.00
latch: row cache objects 1,064 0.00 1 1 0.00
enq: TX - contention 2,827 0.00 1 0 0.00
log buffer space 127 0.00 1 6 0.00
latch free 999 0.00 1 1 0.00
buffer deadlock 25,785 98.73 1 0 0.02
library cache pin 2,107 0.00 1 0 0.00
enq: SQ - contention 4,335 0.00 1 0 0.00
latch: redo allocation 1,071 0.00 1 0 0.00
latch: session allocation 875 0.00 0 1 0.00
wait list latch free 40 0.00 0 11 0.00
row cache lock 2,067 0.00 0 0 0.00
SGA: allocation forcing component growth 28 42.86 0 10 0.00
direct path read 732 0.00 0 0 0.00
enq: DV - contention 87 0.00 0 3 0.00
latch: shared pool 598 0.00 0 0 0.00
cursor: pin S 10,766 0.00 0 0 0.01
latch: library cache lock 193 0.00 0 1 0.00
latch: object queue header heap 291 0.00 0 0 0.00
latch: cache buffer handles 243 0.00 0 0 0.00
enq: FB - contention 650 0.00 0 0 0.00
enq: TX - allocate ITL entry 86 0.00 0 1 0.00
PX qref latch 350 83.43 0 0 0.00
latch: enqueue hash chains 20 0.00 0 3 0.00
latch: messages 143 0.00 0 0 0.00
enq: CU - contention 1 0.00 0 38 0.00
library cache lock 3 0.00 0 11 0.00
L1 validation 2 100.00 0 12 0.00
reliable message 32 0.00 0 1 0.00
cursor: mutex S 111 0.00 0 0 0.00
direct path write 432 0.00 0 0 0.00
enq: PS - contention 51 0.00 0 0 0.00
latch: checkpoint queue latch 34 0.00 0 0 0.00
latch: redo writing 25 0.00 0 0 0.00
write complete waits 5 0.00 0 0 0.00
direct path write temp 52 0.00 0 0 0.00
direct path read temp 20 0.00 0 0 0.00
cursor: mutex X 7 0.00 0 0 0.00
SQL*Net message from client 52,095,463 0.00 10,248,458 197 41.64
pipe get 29,351 14.94 21,071 718 0.02
Streams AQ: waiting for time management or cleanup tasks 2,904 40.05 3,505 1207 0.00
Streams AQ: qmn slave idle wait 129 0.00 3,505 27167 0.00
Streams AQ: qmn coordinator idle wait 258 50.00 3,505 13584 0.00
PX Idle Wait 1,596 75.69 2,517 1577 0.00
PL/SQL lock timer 201 100.00 2,295 11419 0.00
jobq slave wait 616 99.51 1,801 2923 0.00
PX Deq: Execution Msg 5,111 0.00 34 7 0.00
PX Deq: Execute Reply 2,779 0.00 3 1 0.00
PX Deq Credit: need buffer 5,463 0.00 1 0 0.00
PX Deq: Msg Fragment 4,424 0.00 1 0 0.00
PX Deq: Table Q Normal 6,542 0.00 0 0 0.01
PX Deq: Parse Reply 236 0.00 0 0 0.00
PX Deq: Join ACK 253 0.00 0 0 0.00
class slave wait 1 0.00 0 0 0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

Event Waits %Time -outs Total Wait Time (s) Avg wait (ms) Waits /txn
log file parallel write 866,334 0.00 540 1 0.69
db file parallel write 246,771 0.00 199 1 0.20
events in waitclass Other 41,022 0.01 4 0 0.03
control file sequential read 827 0.00 2 3 0.00
db file scattered read 525 0.00 2 4 0.00
os thread startup 62 0.00 2 29 0.00
control file parallel write 1,739 0.00 1 1 0.00
db file sequential read 209 0.00 1 3 0.00
direct path read 732 0.00 0 0 0.00
latch: cache buffers chains 92 0.00 0 0 0.00
direct path write 333 0.00 0 0 0.00
latch: library cache 2 0.00 0 2 0.00
latch: redo writing 25 0.00 0 0 0.00
log file sync 1 0.00 0 0 0.00
latch: row cache objects 1 0.00 0 0 0.00
buffer busy waits 8 0.00 0 0 0.00
rdbms ipc message 1,564,206 0.78 37,068 24 1.25
pmon timer 1,359 89.33 3,510 2583 0.00
Streams AQ: waiting for time management or cleanup tasks 2,904 40.05 3,505 1207 0.00
Streams AQ: qmn slave idle wait 129 0.00 3,505 27167 0.00
Streams AQ: qmn coordinator idle wait 258 50.00 3,505 13584 0.00
smon timer 161,229 0.00 3,502 22 0.13

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic Total
BUSY_TIME 2,141,670
IDLE_TIME 3,625,294
IOWAIT_TIME 92,020
NICE_TIME 0
SYS_TIME 97,206
USER_TIME 1,980,807
LOAD 4
RSRC_MGR_CPU_WAIT_TIME 0
PHYSICAL_MEMORY_BYTES 46,593,552
NUM_CPUS 16
NUM_CPU_SOCKETS 4

Back to Wait Events Statistics
Back to Top

Service Statistics

Service Name DB Time (s) DB CPU (s) Physical Reads Logical Reads
SYS$USERS 22,135.00 19,948.00 445,019 2,080,730,187
SYS$BACKGROUND 0.00 0.00 15,051 3,813,076
VIS 0.00 0.00 0 0

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

Service Name User I/O Total Wts User I/O Wt Time Concurcy Total Wts Concurcy Wt Time Admin Total Wts Admin Wt Time Network Total Wts Network Wt Time
SYS$USERS 348982 131537 2031226 16835 0 0 56694236 28018
SYS$BACKGROUND 1801 289 165 183 0 0 0 0

Back to Wait Events Statistics
Back to Top

 

SQL Statistics

Back to Top

SQL ordered by Elapsed Time

Elapsed Time (s) CPU Time (s) Executions Elap per Exec (s) % Total DB Time SQL Id SQL Module SQL Text
708 694 305 2.32 3.20 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
446 404 112,871 0.00 2.01 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
378 374 64,056 0.01 1.71 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
372 366 57,199 0.01 1.68 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
363 353 1,451 0.25 1.64 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
347 342 57,253 0.01 1.57 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...
317 313 57,253 0.01 1.43 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
316 314 375,999 0.00 1.43 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
248 247 50,456 0.00 1.12 6ubqcscr1gk1b asnDispContainer.jsp select name, value from icx_s...
243 155 21,638 0.01 1.10 1q78dwnrrkf6c asn.lead.server.LeadUwqAM BEGIN ASN_SALES_PVT.Lead_Proce...
228 95 2,400 0.10 1.03 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
226 216 81,155 0.00 1.02 3prk3vg9u0abb FNDOAMCOL BEGIN FND_GLOBAL.APPS_INITIA...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

CPU Time (s) Elapsed Time (s) Executions CPU per Exec (s) % Total DB Time SQL Id SQL Module SQL Text
694 708 305 2.28 3.20 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
404 446 112,871 0.00 2.01 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
374 378 64,056 0.01 1.71 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
366 372 57,199 0.01 1.68 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
353 363 1,451 0.24 1.64 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
342 347 57,253 0.01 1.57 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...
314 316 375,999 0.00 1.43 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
313 317 57,253 0.01 1.43 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
247 248 50,456 0.00 1.12 6ubqcscr1gk1b asnDispContainer.jsp select name, value from icx_s...
216 226 81,155 0.00 1.02 3prk3vg9u0abb FNDOAMCOL BEGIN FND_GLOBAL.APPS_INITIA...
155 243 21,638 0.01 1.10 1q78dwnrrkf6c asn.lead.server.LeadUwqAM BEGIN ASN_SALES_PVT.Lead_Proce...
95 228 2,400 0.04 1.03 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....

Back to SQL Statistics
Back to Top

SQL ordered by Gets

Buffer Gets Executions Gets per Exec %Total CPU Time (s) Elapsed Time (s) SQL Id SQL Module SQL Text
51,621,475 157,197 328.39 2.48 144.61 146.13 5kqw5535fjvw6 ARXTWMAI SELECT NVL(RCTT.ATTRIBUTE10, ...
47,417,249 57,199 828.99 2.27 365.73 371.57 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
44,828,497 64,056 699.83 2.15 373.62 378.48 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
44,346,595 305 145,398.67 2.13 693.90 707.77 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
41,083,538 1,451 28,313.95 1.97 352.67 362.53 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
38,288,263 57,253 668.76 1.84 313.41 316.59 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
31,798,640 1,583,829 20.08 1.53 111.73 113.20 66tmsr3446uqn ap.oie.server.WebExpensesAM SELECT WIAS.ACTIVITY_STATUS, ...
30,368,144 57,253 530.42 1.46 342.47 346.87 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...
30,072,957 174,003 172.83 1.44 160.78 164.61 3b3psftuyks81 INVTTMTX BEGIN INV_TXNSTUB_PUB.postTran...
30,068,228 173,998 172.81 1.44 149.70 153.47 gf1u933c95jb5 INVTTMTX DECLARE l_ret_stat varchar2...
26,397,356 10,000 2,639.74 1.27 75.64 168.31 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
25,942,712 202,488 128.12 1.24 190.71 220.41 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
24,624,453 50,456 488.04 1.18 246.58 247.63 6ubqcscr1gk1b asnDispContainer.jsp select name, value from icx_s...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical Reads Executions Reads per Exec %Total CPU Time (s) Elapsed Time (s) SQL Id SQL Module SQL Text
45,240 10,000 4.52 9.83 75.64 168.31 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
39,413 2,400 16.42 8.57 13.42 177.61 3dssuqfjsynrk asn.lead.server.LeadUwqAM SELECT count(1) FROM (SELECT *...
37,227 2,400 15.51 8.09 95.45 228.20 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
23,413 21,638 1.08 5.09 154.71 243.26 1q78dwnrrkf6c asn.lead.server.LeadUwqAM BEGIN ASN_SALES_PVT.Lead_Proce...
11,883 722 16.46 2.58 81.22 125.64 dk0sqcvc2xjvs qotSCopHdrUpd.jsp BEGIN ASO_QUOTE_PUB_W.Create_Q...
9,770 7,210 1.36 2.12 110.18 154.92 8jb36w62w5hqf ibuSRDetailsActions.jsp BEGIN IBU_REQ_PKG.UpdateServic...
9,739 202,488 0.05 2.12 190.71 220.41 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
4,594 10,000 0.46 1.00 119.24 131.22 csvvv0fmhr1yc PYUSLV BEGIN FFP1893_01010001.FORMULA...
4,512 10,000 0.45 0.98 98.03 107.48 63t8zpm02skgh PYUSLV SELECT DECODE(COUNT(PRR.RUN_RE...
1,497 100,946 0.01 0.33 113.47 117.64 7dtkxnqpkqszw jtfavald.jsp SELECT DISTINCT a.PERMISSION_...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows Processed Rows per Exec CPU per Exec (s) Elap per Exec (s) SQL Id SQL Module SQL Text
1,583,829 818,530 0.52 0.00 0.00 66tmsr3446uqn ap.oie.server.WebExpensesAM SELECT WIAS.ACTIVITY_STATUS, ...
895,548 895,548 1.00 0.00 0.00 cd9mbmqyf4qhp ap.oie.server.WebExpensesAM UPDATE WF_ITEM_ACTIVITY_STATUS...
596,391 596,384 1.00 0.00 0.00 avc1jqzz04wpr JDBC Thin Client SELECT 'x' FROM DUAL
464,100 464,047 1.00 0.00 0.00 821fx90awyvj7 OEXOETEL SELECT ACCOUNTING_RULE_ID , A...
375,999 375,998 1.00 0.00 0.00 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
344,477 263,219 0.76 0.00 0.00 fmfdkztk8vx23   SELECT CATEGORY, SEVERITY, F...
291,050 4,947,762 17.00 0.00 0.00 cwyx16zn1hpfb JDBC Thin Client select parameter, value from ...
202,488 202,483 1.00 0.00 0.00 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
174,004 174,004 1.00 0.00 0.00 6gnth2mfbs2nq INVTTMTX declare v_ret number := 0...
174,003 174,003 1.00 0.00 0.00 3b3psftuyks81 INVTTMTX BEGIN INV_TXNSTUB_PUB.postTran...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse Calls Executions % Total Parses SQL Id SQL Module SQL Text
596,391 596,391 6.43 avc1jqzz04wpr JDBC Thin Client SELECT 'x' FROM DUAL
375,989 375,999 4.06 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
344,486 344,477 3.72 fmfdkztk8vx23   SELECT CATEGORY, SEVERITY, F...
291,050 291,050 3.14 cwyx16zn1hpfb JDBC Thin Client select parameter, value from ...
202,492 202,488 2.18 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
174,005 174,004 1.88 6gnth2mfbs2nq INVTTMTX declare v_ret number := 0...
125,263 125,262 1.35 fb13x9qx0ftks OEXOETEL begin OE_STANDARD_WF.OEOL_SELE...
120,370 120,370 1.30 162ttnv4ubqun OEXOETEL begin OE_DS_PVT.Check_PO_Appr...
116,805 116,805 1.26 1c0b7sas42w2z INVTTMTX SELECT NVL(ITEM_COST, 0), ...
111,365 111,365 1.20 8camsgjsr9zya OEXOETEL begin OE_TRANSACTION_TYPES_PK...
101,455 101,455 1.09 76sw2a4vnc89j icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.S...
95,425 95,423 1.03 608c0n36kaw62 icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.C...
95,425 95,419 1.03 bf7uwg5pa3pj6 icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.V...
95,425 101,452 1.03 dcvv68fju01g4 icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.E...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b) Executions % Total SQL Id SQL Module SQL Text
1,260,735 20,915 0.04 8q8zmrwmrccz4 OEXOETEL SELECT /*+ ORDERED USE_NL(adj ...

Back to SQL Statistics
Back to Top

 

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

 

Complete List of SQL Text

SQL Id SQL Text
0z318y6g3uagc declare l_retstat varchar2 ( 3 ) ; l_msg_data varchar2 ( 244 ) ; l_msg_cnt number ; l_trx_cnt number ; BEGIN :retval := INV_TXN_MANAGER_PUB . process_Transactions ( p_api_version => 1.0 , p_commit => fnd_api . g_true , x_return_status => l_retstat , x_msg_count => l_msg_cnt , x_msg_data => l_msg_data , x_trans_count => l_trx_cnt , p_table => 1 , p_header_id => :header_id ) ; END ;
162ttnv4ubqun begin OE_DS_PVT.Check_PO_Approved( :t_application_id, :t_entity_short_name, :t_validation_entity_short_name, :t_validation_tmplt_short_name, :t_record_set_short_name, :t_scope, :t_result ); end;
1c0b7sas42w2z SELECT NVL(ITEM_COST, 0), COST_UPDATE_ID FROM CST_ITEM_COSTS WHERE INVENTORY_ITEM_ID = :1 AND ORGANIZATION_ID = :2 AND COST_TYPE_ID = :3
1q78dwnrrkf6c BEGIN ASN_SALES_PVT.Lead_Process_After_Update( P_Api_Version_Number => 2.0, P_Init_Msg_List => FND_API.G_TRUE, p_Commit => FND_API.G_FALSE, p_Validation_Level => FND_API.G_VALID_LEVEL_NONE, P_Identity_Salesforce_Id => :1, P_Salesgroup_id => :2, P_Sales_Lead_Id => :3, X_Return_Status => :4, X_Msg_Count => :5, X_Msg_Data => :6); END;
3b3psftuyks81 BEGIN INV_TXNSTUB_PUB.postTransaction(:1, :2, :3); END;
3dssuqfjsynrk SELECT count(1) FROM (SELECT * FROM ( SELECT LeadEO.sales_lead_id as SalesLeadId , to_char(hz_timezone_pub.convert_datetime(:1, hcp.timezone_id, SYSDATE), 'HH:MI AM ') ||' '||ht.standard_time_short_code as PrimaryContactLocalTime , SUBSTRB(LeadEO.description, 1, 240) as Description , hp.party_name as ContactName , custParty.party_name as CustomerName , aslt.meaning as RankName , ast.meaning as LeadStatus , ROUND(SYSDATE - LeadEO.creation_date) as Age , DECODE(LeadEO.status_code, 'CONVERTED_TO_OPPORTUNITY', 'ASNCnvToOpptyDsbld', 'ASNCnvToOpptyEnbld') as ASNLeadLstCnvToOppty , LeadEO.customer_id , hp.party_id , LeadEO.primary_contact_party_id , hr.relationship_id FROM as_sales_leads LeadEO , ( SELECT /*+ no_merge */ distinct aaa.sales_lead_id, aaa.customer_id FROM as_accesses_all aaa WHERE aaa.sales_lead_id IS NOT NULL AND aaa.lead_id IS NULL AND aaa.salesforce_id = :2) secu , as_statuses_tl ast , as_sales_lead_ranks_tl aslt , hz_parties CustParty , hz_parties hp, hz_relationships hr , hz_contact_points hcp , hz_timezones ht , ams_source_codes amsc WHERE LeadEO.sales_lead_id = secu.sales_lead_id AND LeadEO.customer_id = secu.customer_id AND LeadEO.status_code = ast.status_code AND ast.language = USERENV('LANG') AND LeadEO.lead_rank_id = aslt.rank_id (+) AND aslt.language (+) = USERENV('LANG') AND LeadEO.customer_id = CustParty.party_id AND LeadEO.primary_contact_party_id = hr.party_id(+) AND hr.subject_ id = hp.party_id (+) AND hr.subject_table_name (+) = 'HZ_PARTIES' AND hr.object_id(+) = LeadEO.customer_id AND hr.object_table_name (+) = 'HZ_PARTIES' AND LeadEO.primary_contact_party_id = hcp.owner_table_id(+) AND hcp.owner_table_name (+) = 'HZ_PARTIES' AND hcp.primary_flag (+) = 'Y' AND hcp.contact_point_type (+) = 'PHONE' AND hcp.timezone_id = ht.timezone_id (+) AND LeadEO.source_promotion_id = amsc.source_code_id AND amsc.source_code_for_id = :3 AND LeadEO.status_code = :4 ORDER BY age ) )
3prk3vg9u0abb BEGIN FND_GLOBAL.APPS_INITIALIZE( user_id=>:1 , resp_id=>:2 , resp_appl_id=>:3 , security_group_id=>:4 , server_id=>:5);END;
4yak7x2zqz0dh BEGIN inv_transfer_order_pvt.finalize_pick_confirm(:1, :2, :3, :4, :5, :6, :7); END;
5kqw5535fjvw6 SELECT NVL(RCTT.ATTRIBUTE10, ' ') FROM RA_CUST_TRX_TYPES_ALL RCTT, RA_CUSTOMER_TRX_ALL RCT WHERE RCT.CUSTOMER_TRX_ID = :B1 AND RCT.CUST_TRX_TYPE_ID = RCTT.CUST_TRX_TYPE_ID
608c0n36kaw62 begin FND_FLEX_WORKFLOW_APIS.COPY_FROM_COMBINATION (:v1, :v2, :v3, :v4, :v5); end;
63t8zpm02skgh SELECT DECODE(COUNT(PRR.RUN_RESULT_ID), 0, 'N', 'Y') FROM PAY_RUN_RESULTS PRR, PAY_ASSIGNMENT_ACTIONS ASA, PAY_PAYROLL_ACTIONS PPA WHERE PRR.SOURCE_ID = :B3 AND PRR.SOURCE_TYPE IN ('E', 'I') AND PRR.STATUS IN ('P', 'PA', 'R', 'O') AND ASA.ASSIGNMENT_ACTION_ID = PRR.ASSIGNMENT_ACTION_ID AND PPA.PAYROLL_ACTION_ID = ASA.PAYROLL_ACTION_ID AND NOT EXISTS (SELECT NULL FROM PAY_RUN_RESULTS PRR2 WHERE PRR2.SOURCE_ID = PRR.RUN_RESULT_ID AND PRR2.SOURCE_TYPE IN ('R', 'V')) AND PPA.DATE_EARNED BETWEEN :B2 AND :B1
64qc329wgjv39 select /*+ ORDERED INDEX(ASSBAL PAY_ASSIGNMENT_LATEST_BALA_N1) INDEX(DEFBAL PAY_DEFINED_BALANCES_PK) INDEX(ACT PAY_ASSIGNMENT_ACTIONS_PK) INDEX(PACT PAY_PAYROLL_ACTIONS_PK) INDEX(VALUE PAY_BALANCE_CONTEXT_VALUES_PK) USE_NL(ASSBAL DEFBAL ACT PACT VALUE) +*/ ASSBAL.defined_balance_id , DEFBAL.balance_dimension_id , to_char(ASSBAL.value) , ASSBAL.latest_balance_id , ASSBAL.rowid , to_char(ASSBAL.assignment_action_id) , ACT.payroll_action_id , to_char(PACT.effective_date, :b0) , to_number(to_char(PACT.effective_date, 'J')) , nvl(VALUE.context_id, 0) , nvl(VALUE.value, 'NULL') , to_char(ASSBAL.expired_assignment_action_id) , to_char(ASSBAL.expired_value) , to_char(ASSBAL.prev_assignment_action_id) , to_char(ASSBAL.prev_balance_value) from pay_assignment_latest_balances ASSBAL , pay_defined_balances DEFBAL , pay_assignment_actions ACT , pay_payroll_actions PACT , pay_balance_context_values VALUE where ((((ASSBAL.assignment_id=:b1 and ACT.assignment_action_id=ASSBAL.assignment_action_id) and PACT.payroll_action_id=ACT.payroll_action_id) and DEFBAL.defined_balance_id=ASSBAL.defined_balance_id) and VALUE.latest_balance_id(+)=ASSBAL.latest_balance_id) union all select /*+ ORDERED INDEX(PERBAL PAY_PERSON_LATEST_BALANCES_N2) INDEX(DEFBAL PAY_DEFINED_BALANCES_PK) INDEX(ACT PAY_ASSIGNMENT_ACTIONS_PK) INDEX(VALUE PAY_BALANCE_CONTEXT_VALUES_PK) INDEX(PACT PAY_PAYROLL_ACTIONS_PK) USE_NL(PERBAL DEFBAL ACT PACT VALUE) +*/ PERBAL.defined_balance_id , DEFBAL.balance_dimension_id , to_char (PERBAL.value) , PERBAL.latest_balance_id , PERBAL.rowid , to_char(PERBAL.assignment_action_id) , ACT.payroll_action_id , to_char(PACT.effective_date, :b0) , to_number(to_char(PACT.effective_date, 'J')) , nvl(VALUE.context_id, 0) , nvl(VALUE.value, 'NULL') , to_char(PERBAL.expired_assignment_action_id) , to_char(PERBAL.expired_value) , to_char(PERBAL.prev_assignment_action_id) , to_char(PERBAL.prev_balance_value) from pay_person_latest_balances PERBAL , pay_defined_balances DEFBAL , pay_assignment_actions ACT , pay_payroll_actions PACT , pay_balance_context_values VALUE where ((((PERBAL.person_id=:b3 and ACT.assignment_action_id=PERBAL.assignment_action_id) and PACT.payroll_action_id=ACT.payroll_action_id) and DEFBAL.defined_balance_id=PERBAL.defined_balance_id) and VALUE.latest_balance_id(+)=PERBAL.latest_balance_id) order by 6, 2, 1, 4, 10 desc
66tmsr3446uqn SELECT WIAS.ACTIVITY_STATUS, WIAS.ACTIVITY_RESULT_CODE, WIAS.ASSIGNED_USER, WIAS.NOTIFICATION_ID, WIAS.BEGIN_DATE, WIAS.END_DATE, WIAS.DUE_DATE, WIAS.ERROR_NAME, WIAS.ERROR_MESSAGE, WIAS.ERROR_STACK FROM WF_ITEM_ACTIVITY_STATUSES WIAS WHERE WIAS.ITEM_TYPE = :B3 AND WIAS.ITEM_KEY = :B2 AND WIAS.PROCESS_ACTIVITY = :B1
6gnth2mfbs2nq declare v_ret number := 0; begin if (INV_TABLE_LOCK_PVT.lock_onhand_records(:1, :2, :3, :4, :5, :6, :7) ) then v_ret := 1; end if; :8 := v_ret; end;
6h2tpcxpymqu7 BEGIN :1 := FND_AOLJ_UTIL.is_Valid_ICX(:2, NULL, 'Y', TRUE, TRUE, NULL, NULL, NULL, NULL, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, TRUE);:19 := fnd_session_management.g_enc_key;:20 := fnd_session_management.g_mac_key;END;
6ubqcscr1gk1b select name, value from icx_session_attributes where session_id = :1
76sw2a4vnc89j begin FND_FLEX_WORKFLOW_APIS.START_GENERATION (:v1, :v2, :v3, :v4, :v5); end;
7dtkxnqpkqszw SELECT DISTINCT a.PERMISSION_NAME, dom.DOMAIN_NAME, a.MAINTENANCE_MODE_FLAG FROM JTF_AUTH_PERMISSIONS_B A, JTF_AUTH_PRINCIPAL_MAPS B, JTF_AUTH_ROLE_PERMS C, JTF_AUTH_PRINCIPALS_B D, JTF_AUTH_PRINCIPALS_B E, JTF_AUTH_DOMAINS_B dom WHERE D.PRINCIPAL_NAME = :1 AND D.IS_USER_FLAG = 1 AND D.JTF_AUTH_PRINCIPAL_ID = B.JTF_AUTH_PRINCIPAL_ID AND B.JTF_AUTH_PARENT_PRINCIPAL_ID=E.JTF_AUTH_PRINCIPAL_ID AND E.IS_USER_FLAG = 0 AND E.JTF_AUTH_PRINCIPAL_ID = C.JTF_AUTH_PRINCIPAL_ID AND C.JTF_AUTH_PERMISSION_ID = A.JTF_AUTH_PERMISSION_ID AND C.POSITIVE_FLAG=1 AND B.JTF_AUTH_DOMAIN_ID = dom.JTF_AUTH_DOMAIN_ID ORDER BY A.PERMISSION_NAME
821fx90awyvj7 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 , 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_ATTRIBUTE8 , 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 FROM OE_ORDER_LINES_ALL WHERE LINE_ID = :B1
827gtfny5uagb begin :con := FND_GENERIC_POLICY.GET_PREDICATE(:sn, :on); end;
8c8cf4vtv4tx2 SELECT * FROM ( SELECT LeadEO.sales_lead_id as SalesLeadId , to_char(hz_timezone_pub.convert_datetime(:1, hcp.timezone_id, SYSDATE), 'HH:MI AM ') ||' '||ht.standard_time_short_code as PrimaryContactLocalTime , SUBSTRB(LeadEO.description, 1, 240) as Description , hp.party_name as ContactName , custParty.party_name as CustomerName , aslt.meaning as RankName , ast.meaning as LeadStatus , ROUND(SYSDATE - LeadEO.creation_date) as Age , DECODE(LeadEO.status_code, 'CONVERTED_TO_OPPORTUNITY', 'ASNCnvToOpptyDsbld', 'ASNCnvToOpptyEnbld') as ASNLeadLstCnvToOppty , LeadEO.customer_id , hp.party_id , LeadEO.primary_contact_party_id , hr.relationship_id FROM as_sales_leads LeadEO , ( SELECT /*+ no_merge */ distinct aaa.sales_lead_id, aaa.customer_id FROM as_accesses_all aaa WHERE aaa.sales_lead_id IS NOT NULL AND aaa.lead_id IS NULL AND aaa.salesforce_id = :2) secu , as_statuses_tl ast , as_sales_lead_ranks_tl aslt , hz_parties CustParty , hz_parties hp, hz_relationships hr , hz_contact_points hcp , hz_timezones ht , ams_source_codes amsc WHERE LeadEO.sales_lead_id = secu.sales_lead_id AND LeadEO.customer_id = secu.customer_id AND LeadEO.status_code = ast.status_code AND ast.language = USERENV('LANG') AND LeadEO.lead_rank_id = aslt.rank_id (+) AND aslt.language (+) = USERENV('LANG') AND LeadEO.customer_id = CustParty.party_id AND LeadEO.primary_contact_party_id = hr.party_id(+) AND hr.subject_id = hp.party_id (+) AND hr.subject_table_name (+) = 'HZ_PARTIES' AND hr.object_id(+) = LeadEO.customer_id AND hr.object_table_name (+) = 'HZ_PARTIES' AND LeadEO.primary_contact_party_id = hcp.owner_table_id(+) AND hcp.owner_table_name (+) = 'HZ_PARTIES' AND hcp.primary_flag (+) = 'Y' AND hcp.contact_point_type (+) = 'PHONE' AND hcp.timezone_id = ht.timezone_id (+) AND LeadEO.source_promotion_id = amsc.source_code_id AND amsc.source_code_for_id = :3 AND LeadEO.status_code = :4 ORDER BY age )
8camsgjsr9zya begin OE_TRANSACTION_TYPES_PKG.Val_Ord_Change( :t_application_id, :t_entity_short_name, :t_validation_entity_short_name, :t_validation_tmplt_short_name, :t_record_set_short_name, :t_scope, :t_result ); end;
8jb36w62w5hqf BEGIN IBU_REQ_PKG.UpdateServiceRequest(:1, :2, -1, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16); END;
8q8zmrwmrccz4 SELECT /*+ ORDERED USE_NL(adj qplh) */ ADJ.LIST_LINE_ID CREATED_FROM_LIST_LINE_ID , LINE.LINE_INDEX LINE_IND , LINE.LINE_INDEX CURR_LINE_INDEX , LINE.LINE_ID LINE_ID , ADJ.PRICE_ADJUSTMENT_ID LINE_DETAIL_INDEX , ADJ.LIST_LINE_TYPE_CODE CREATED_FROM_LIST_LINE_TYPE , ADJ.LIST_HEADER_ID CREATED_FROM_LIST_HEADER_ID , ADJ.APPLIED_FLAG , (LINE.UPDATED_ADJUSTED_UNIT_PRICE - LINE.ADJUSTED_UNIT_PRICE) AMOUNT_CHANGED , LINE.ADJUSTED_UNIT_PRICE , ADJ.RANGE_BREAK_QUANTITY PRICED_QUANTITY , LINE.PRICED_QUANTITY LINE_PRICED_QUANTITY , LINE.UPDATED_ADJUSTED_UNIT_PRICE , ADJ.AUTOMATIC_FLAG , ADJ.UPDATE_ALLOWED OVERRIDE_FLAG , ADJ.PRICING_GROUP_SEQUENCE , ADJ.ARITHMETIC_OPERATOR OPERAND_CALCULATION_CODE , NVL(ADJ.OPERAND_PER_PQTY, ADJ.OPERAND) OPERAND_VALUE , ADJ.ADJUSTED_AMOUNT_PER_PQTY ADJUSTMENT_AMOUNT , LINE.UNIT_PRICE , ADJ.ACCRUAL_FLAG , NVL(ADJ.UPDATED_FLAG, :B16 ) , 'N' PROCESS_CODE , 'N' PRICING_STATUS_CODE , ' ' PRICING_STATUS_TEXT , ADJ.PRICE_BREAK_TYPE_CODE , ADJ.CHARGE_TYPE_CODE , ADJ.CHARGE_SUBTYPE_CODE , LINE.ROUNDING_FACTOR , ADJ.PRICING_PHASE_ID , '' CREATED_FROM_LIST_TYPE_CODE , '' LIMIT_CODE , '' LIMIT_TEXT , ADJ.LIST_LINE_NO , ADJ.MODIFIER_LEVEL_CODE , ADJ.RANGE_BREAK_QUANTITY GROUP_QUANTITY , ADJ.RANGE_BREAK_QUANTITY GROUP_AMOUNT , LINE.PRICING_STATUS_CODE LINE_PRICING_STATUS_CODE , :B15 IS_LDET_REC , LINE.LINE_TYPE_CODE , NULL NET_AMOUNT_FLAG , NULL CALCULATION_CODE , LINE.CATCHWEIGHT_QTY , LINE.ACTUAL_ORDER_QUANTITY , LINE.LI NE_UNIT_PRICE , LINE.LINE_QUANTITY ORDERED_QTY , NULL LINE_DETAIL_TYPE_CODE , LINE.LINE_CATEGORY , LINE.PRICE_FLAG FROM QP_NPREQ_LINES_TMP LINE, OE_PRICE_ADJUSTMENTS ADJ, QP_LIST_HEADERS_B QPLH WHERE :B14 = :B7 AND LINE.PROCESS_STATUS IN (:B12 , :B13 , :B10 , 'NEW'||:B10 , 'OLD'||:B10 ) AND ADJ.LINE_ID = LINE.LINE_ID AND LINE.PRICING_STATUS_CODE IN (:B12 , :B11 , :B10 ) AND (LINE.PRICE_FLAG IN (:B7 , :B9 , :B6 ) OR NVL(LINE.PROCESSED_CODE, '0') = :B8 ) AND LINE.LINE_TYPE_CODE = :B4 AND LINE.UNIT_PRICE IS NOT NULL AND (ADJ.UPDATED_FLAG = :B7 OR LINE.PRICE_FLAG = :B6 OR (:B5 IS NULL AND ADJ.UPDATED_FLAG IS NULL) OR ADJ.PRICING_PHASE_ID NOT IN (SELECT PH.PRICING_PHASE_ID FROM QP_EVENT_PHASES EV, QP_PRICING_PHASES PH WHERE PH.PRICING_PHASE_ID = EV.PRICING_PHASE_ID AND (EV.END_DATE_ACTIVE IS NULL OR (EV.END_DATE_ACTIVE IS NOT NULL AND EV.END_DATE_ACTIVE > LINE.PRICING_EFFECTIVE_DATE)) AND ((:B17 = :B7 AND PH.FREIGHT_EXISTS = :B7 ) OR (:B17 = :B16 )) AND INSTR(:B5 , EV.PRICING_EVENT_CODE||', ') > 0 AND (NVL(QP_PREQ_PUB.GET_BUY_LINE_PRICE_FLAG(ADJ.LIST_LINE_ID, LINE.LINE_INDEX), LINE.PRICE_FLAG) = :B7 OR (NVL(QP_PREQ_PUB.GET_BUY_LINE_PRICE_FLAG(ADJ.LIST_LINE_ID, LINE.LINE_INDEX), LINE.PRICE_FLAG) = :B9 AND NVL(PH.USER_FREEZE_OVERRIDE_FLAG, PH.FREEZE_OVERRIDE_FLAG) = :B7 )))) AND ADJ.MODIFIER_LEVEL_CODE IN (:B4 , :B3 ) AND QPLH.LIST_HEADER_ID = ADJ.LIST_HEADER_ID AND QPLH.LIST_TYPE_CODE NOT IN (:B2 , :B1 ) AND NOT EXISTS (SELECT 'x' FROM OE_PRICE_ADJ_ASSOCS A, O E_PRICE_ADJUSTMENTS B WHERE A.RLTD_PRICE_ADJ_ID = ADJ.PRICE_ADJUSTMENT_ID AND B.PRICE_ADJUSTMENT_ID = A.PRICE_ADJUSTMENT_ID AND B.LIST_LINE_TYPE_CODE = :B18 ) UNION SELECT /*+ ORDERED USE_NL(adj line qplh) */ ADJ.LIST_LINE_ID CREATED_FROM_LIST_LINE_ID , LINE.LINE_INDEX LINE_IND , LINE.LINE_INDEX CURR_LINE_INDEX , LINE.LINE_ID LINE_ID , ADJ.PRICE_ADJUSTMENT_ID LINE_DETAIL_INDEX , ADJ.LIST_LINE_TYPE_CODE CREATED_FROM_LIST_LINE_TYPE , ADJ.LIST_HEADER_ID CREATED_FROM_LIST_HEADER_ID , ADJ.APPLIED_FLAG , (LINE.UPDATED_ADJUSTED_UNIT_PRICE - LINE.ADJUSTED_UNIT_PRICE) AMOUNT_CHANGED , LINE.ADJUSTED_UNIT_PRICE , ADJ.RANGE_BREAK_QUANTITY PRICED_QUANTITY , LINE.PRICED_QUANTITY LINE_PRICED_QUANTITY , LINE.UPDATED_ADJUSTED_UNIT_PRICE , ADJ.AUTOMATIC_FLAG , ADJ.UPDATE_ALLOWED OVERRIDE_FLAG , ADJ.PRICING_GROUP_SEQUENCE , ADJ.ARITHMETIC_OPERATOR OPERAND_CALCULATION_CODE , NVL(ADJ.OPERAND_PER_PQTY, ADJ.OPERAND) OPERAND_VALUE , ADJ.ADJUSTED_AMOUNT_PER_PQTY ADJUSTMENT_AMOUNT , LINE.UNIT_PRICE , ADJ.ACCRUAL_FLAG , NVL(ADJ.UPDATED_FLAG, :B16 ) , 'N' PROCESS_CODE , 'N' PRICING_STATUS_CODE , ' ' PRICING_STATUS_TEXT , ADJ.PRICE_BREAK_TYPE_CODE , ADJ.CHARGE_TYPE_CODE , ADJ.CHARGE_SUBTYPE_CODE , LINE.ROUNDING_FACTOR , ADJ.PRICING_PHASE_ID , '' CREATED_FROM_LIST_TYPE_CODE , '' LIMIT_CODE , '' LIMIT_TEXT , ADJ.LIST_LINE_NO , ADJ.MODIFIER_LEVEL_CODE , ADJ.RANGE_BREAK_QUANTITY GROUP_QUANTITY , ADJ.RANGE_BREAK_QUANTITY GROUP_AMOUNT , LINE.PRICING_STATUS_CODE LINE_PRICI NG_STATUS_CODE , :B20 IS_LDET_REC , LINE.LINE_TYPE_CODE , NULL NET_AMOUNT_FLAG , NULL CALCULATION_CODE , LINE.CATCHWEIGHT_QTY , LINE.ACTUAL_ORDER_QUANTITY , LINE.LINE_UNIT_PRICE , LINE.LINE_QUANTITY ORDERED_QTY , NULL LINE_DETAIL_TYPE_CODE , LINE.LINE_CATEGORY , LINE.PRICE_FLAG FROM QP_NPREQ_LINES_TMP LINE1, OE_PRICE_ADJUSTMENTS ADJ , QP_NPREQ_LINES_TMP LINE, QP_LIST_HEADERS_B QPLH WHERE :B14 = :B7 AND LINE1.PROCESS_STATUS IN (:B12 , :B13 , :B10 , 'NEW'||:B10 , 'OLD'||:B10 ) AND LINE.PROCESS_STATUS IN (:B12 , :B13 , :B10 , 'NEW'||:B10 , 'OLD'||:B10 ) AND LINE1.LINE_ID = ADJ.HEADER_ID AND LINE1.PRICING_STATUS_CODE IN (:B12 , :B11 , :B10 ) AND LINE1.LINE_TYPE_CODE = :B19 AND (LINE1.PRICE_FLAG IN (:B7 , :B9 , :B6 ) OR NVL(LINE1.PROCESSED_CODE, '0') = :B8 ) AND (LINE.PRICE_FLAG IN (:B7 , :B9 , :B6 ) OR NVL(LINE.PROCESSED_CODE, '0') = :B8 ) AND LINE.PRICING_STATUS_CODE IN (:B12 , :B11 , :B10 ) AND (LINE.UNIT_PRICE IS NOT NULL OR LINE.LINE_TYPE_CODE = :B19 ) AND (ADJ.UPDATED_FLAG = :B7 OR LINE.PRICE_FLAG = :B6 OR (:B5 IS NULL AND ADJ.UPDATED_FLAG IS NULL) OR ADJ.PRICING_PHASE_ID NOT IN (SELECT PH.PRICING_PHASE_ID FROM QP_EVENT_PHASES EV, QP_PRICING_PHASES PH WHERE PH.PRICING_PHASE_ID = EV.PRICING_PHASE_ID AND (EV.END_DATE_ACTIVE IS NULL OR (EV.END_DATE_ACTIVE IS NOT NULL AND EV.END_DATE_ACTIVE > LINE.PRICING_EFFECTIVE_DATE)) AND ((:B17 = :B7 AND PH.FREIGHT_EXISTS = :B7 ) OR (:B17 = :B16 )) AND INSTR(:B5 , EV.PRICING_EVENT_CODE||', ') > 0 AND (NVL(QP_ PREQ_PUB.GET_BUY_LINE_PRICE_FLAG(ADJ.LIST_LINE_ID, LINE1.LINE_INDEX), LINE1.PRICE_FLAG) = :B7 OR (NVL(QP_PREQ_PUB.GET_BUY_LINE_PRICE_FLAG(ADJ.LIST_LINE_ID, LINE1.LINE_INDEX), LINE1.PRICE_FLAG) = :B9 AND NVL(PH.USER_FREEZE_OVERRIDE_FLAG, PH.FREEZE_OVERRIDE_FLAG) = :B7 )))) AND ADJ.MODIFIER_LEVEL_CODE = :B19 AND ADJ.LINE_ID IS NULL AND QPLH.LIST_HEADER_ID = ADJ.LIST_HEADER_ID AND QPLH.LIST_TYPE_CODE NOT IN (:B2 , :B1 ) UNION SELECT /*+ ORDERED USE_NL(ldet) */ LDET.CREATED_FROM_LIST_LINE_ID , LINE.LINE_INDEX LINE_IND , LINE.LINE_INDEX CURR_LINE_INDEX , LINE.LINE_ID LINE_ID , LDET.LINE_DETAIL_INDEX , LDET.CREATED_FROM_LIST_LINE_TYPE , LDET.CREATED_FROM_LIST_HEADER_ID , LDET.APPLIED_FLAG , (LINE.UPDATED_ADJUSTED_UNIT_PRICE - LINE.ADJUSTED_UNIT_PRICE) AMOUNT_CHANGED , LINE.ADJUSTED_UNIT_PRICE , LDET.LINE_QUANTITY PRICED_QUANTITY , LINE.PRICED_QUANTITY LINE_PRICED_QUANTITY , LINE.UPDATED_ADJUSTED_UNIT_PRICE , LDET.AUTOMATIC_FLAG , LDET.OVERRIDE_FLAG , LDET.PRICING_GROUP_SEQUENCE , LDET.OPERAND_CALCULATION_CODE , LDET.OPERAND_VALUE , LDET.ADJUSTMENT_AMOUNT , LINE.UNIT_PRICE , LDET.ACCRUAL_FLAG , NVL(LDET.UPDATED_FLAG, :B16 ) , LDET.PROCESS_CODE , LDET.PRICING_STATUS_CODE , LDET.PRICING_STATUS_TEXT , LDET.PRICE_BREAK_TYPE_CODE , LDET.CHARGE_TYPE_CODE , LDET.CHARGE_SUBTYPE_CODE , LINE.ROUNDING_FACTOR , LDET.PRICING_PHASE_ID , LDET.CREATED_FROM_LIST_TYPE_CODE , LDET.LIMIT_CODE , SUBSTR(LDET.LIMIT_TEXT, 1, 240) , LDET.LIST_LINE_NO , LDET.MODIFIER_LE VEL_CODE , LDET.GROUP_QUANTITY GROUP_QUANTITY , LDET.GROUP_AMOUNT GROUP_AMOUNT , LINE.PRICING_STATUS_CODE LINE_PRICING_STATUS_CODE , :B23 IS_LDET_REC , LINE.LINE_TYPE_CODE , LDET.NET_AMOUNT_FLAG NET_AMOUNT_FLAG , LDET.CALCULATION_CODE CALCULATION_CODE , LINE.CATCHWEIGHT_QTY , LINE.ACTUAL_ORDER_QUANTITY , LINE.LINE_UNIT_PRICE , LINE.LINE_QUANTITY ORDERED_QTY , LDET.LINE_DETAIL_TYPE_CODE LINE_DETAIL_TYPE_CODE , LINE.LINE_CATEGORY , LINE.PRICE_FLAG FROM QP_NPREQ_LINES_TMP LINE, QP_NPREQ_LDETS_TMP LDET WHERE LINE.LINE_INDEX = LDET.LINE_INDEX AND LINE.PROCESS_STATUS IN (:B12 , :B13 , :B10 , 'NEW'||:B10 , 'OLD'||:B10 ) AND LINE.PRICING_STATUS_CODE IN (:B12 , :B11 , :B10 ) AND (LINE.PRICE_FLAG IN (:B7 , :B9 ) OR NVL(LINE.PROCESSED_CODE, '0') = :B8 ) AND LINE.LINE_TYPE_CODE = :B4 AND LINE.UNIT_PRICE IS NOT NULL AND LDET.PRICING_STATUS_CODE IN (:B13 , :B12 ) AND (LDET.APPLIED_FLAG = :B7 OR (LDET.APPLIED_FLAG = :B16 AND LDET.CREATED_FROM_LIST_LINE_TYPE = :B22 AND LDET.AUTOMATIC_FLAG = :B16 )) AND LDET.CREATED_FROM_LIST_TYPE_CODE NOT IN (:B2 , :B1 ) AND LDET.MODIFIER_LEVEL_CODE IN (:B4 , :B3 ) AND NVL(LDET.LINE_DETAIL_TYPE_CODE, 'NULL') <> :B21 UNION SELECT /*+ ORDERED USE_NL(ldet line) */ LDET.CREATED_FROM_LIST_LINE_ID , LINE.LINE_INDEX LINE_IND , LINE.LINE_INDEX CURR_LINE_INDEX , LINE.LINE_ID LINE_ID , LDET.LINE_DETAIL_INDEX , LDET.CREATED_FROM_LIST_LINE_TYPE , LDET.CREATED_FROM_LIST_HEADER_ID , LDET.APPLIED_FLAG , (LINE.UPDATED_ADJUSTED_UNIT_PRICE - LINE.ADJUSTED_UNIT_PRICE) AMOUNT_CHANGED , LINE.ADJUSTED_UNIT_PRICE , LDET.LINE_QUANTITY PRICED_QUANTITY , LINE.PRICED_QUANTITY LINE_PRICED_QUANTITY , LINE.UPDATED_ADJUSTED_UNIT_PRICE , LDET.AUTOMATIC_FLAG , LDET.OVERRIDE_FLAG , LDET.PRICING_GROUP_SEQUENCE , LDET.OPERAND_CALCULATION_CODE , LDET.OPERAND_VALUE , LDET.ADJUSTMENT_AMOUNT , LINE.UNIT_PRICE , LDET.ACCRUAL_FLAG , NVL(LDET.UPDATED_FLAG, :B16 ) , LDET.PROCESS_CODE , LDET.PRICING_STATUS_CODE , LDET.PRICING_STATUS_TEXT , LDET.PRICE_BREAK_TYPE_CODE , LDET.CHARGE_TYPE_CODE , LDET.CHARGE_SUBTYPE_CODE , LINE.ROUNDING_FACTOR , LDET.PRICING_PHASE_ID , LDET.CREATED_FROM_LIST_TYPE_CODE , LDET.LIMIT_CODE , SUBSTR(LDET.LIMIT_TEXT, 1, 240) , LDET.LIST_LINE_NO , LDET.MODIFIER_LEVEL_CODE , LDET.GROUP_QUANTITY GROUP_QUANTITY , LDET.GROUP_AMOUNT GROUP_AMOUNT , LINE.PRICING_STATUS_CODE LINE_PRICING_STATUS_CODE , :B24 IS_LDET_REC , LINE.LINE_TYPE_CODE , LDET.NET_AMOUNT_FLAG NET_AMOUNT_FLAG , LDET.CALCULATION_CODE CALCULATION_CODE , LINE.CATCHWEIGHT_QTY , LINE.ACTUAL_ORDER_QUANTITY , LINE.LINE_UNIT_PRICE , LINE.LINE_QUANTITY ORDERED_QTY , LDET.LINE_DETAIL_TYPE_CODE LINE_DETAIL_TYPE_CODE , LINE.LINE_CATEGORY , LINE.PRICE_FLAG FROM QP_NPREQ_LINES_TMP LINE1, QP_NPREQ_LDETS_TMP LDET , QP_NPREQ_LINES_TMP LINE WHERE LDET.LINE_INDEX = LINE1.LINE_INDEX AND LINE1.PROCESS_STATUS IN (:B12 , :B13 , :B10 , 'NEW'||:B10 , 'OLD'||:B10 ) AND LINE.PROCESS_STATUS IN (:B12 , :B13 , :B10 , 'NEW'||:B10 , 'OLD '||:B10 ) AND LINE1.PRICING_STATUS_CODE IN (:B12 , :B11 , :B10 ) AND LINE1.PRICE_FLAG IN (:B7 , :B9 ) AND LINE1.LINE_TYPE_CODE = :B19 AND (LINE.UNIT_PRICE IS NOT NULL OR LINE.LINE_TYPE_CODE = :B19 ) AND LINE.PRICING_STATUS_CODE IN (:B12 , :B11 , :B10 ) AND LDET.PRICING_STATUS_CODE IN (:B13 , :B12 ) AND (LDET.APPLIED_FLAG = :B7 OR (LDET.APPLIED_FLAG = :B16 AND LDET.CREATED_FROM_LIST_LINE_TYPE = :B22 AND LDET.AUTOMATIC_FLAG = :B16 )) AND (LINE.PRICE_FLAG IN (:B7 , :B9 , :B6 ) OR NVL(LINE.PROCESSED_CODE, '0') = :B8 ) AND LDET.MODIFIER_LEVEL_CODE = :B19 AND LDET.CREATED_FROM_LIST_TYPE_CODE NOT IN (:B2 , :B1 ) UNION SELECT /*+ ORDERED USE_NL(ldet qplh) */ LDET.CREATED_FROM_LIST_LINE_ID , LINE.LINE_INDEX LINE_IND , LINE.LINE_INDEX CURR_LINE_INDEX , LINE.LINE_ID LINE_ID , LDET.LINE_DETAIL_INDEX , LDET.CREATED_FROM_LIST_LINE_TYPE , LDET.CREATED_FROM_LIST_HEADER_ID , LDET.APPLIED_FLAG , (LINE.UPDATED_ADJUSTED_UNIT_PRICE - LINE.ADJUSTED_UNIT_PRICE) AMOUNT_CHANGED , LINE.ADJUSTED_UNIT_PRICE , LDET.LINE_QUANTITY PRICED_QUANTITY , LINE.PRICED_QUANTITY LINE_PRICED_QUANTITY , LINE.UPDATED_ADJUSTED_UNIT_PRICE , LDET.AUTOMATIC_FLAG , LDET.OVERRIDE_FLAG , LDET.PRICING_GROUP_SEQUENCE , LDET.OPERAND_CALCULATION_CODE , LDET.OPERAND_VALUE , LDET.ADJUSTMENT_AMOUNT , LINE.UNIT_PRICE , LDET.ACCRUAL_FLAG , NVL(LDET.UPDATED_FLAG, :B16 ) , LDET.PROCESS_CODE , LDET.PRICING_STATUS_CODE , LDET.PRICING_STATUS_TEXT , LDET.PRICE_BREAK_TYPE_CODE , LDET.CHARGE_TYPE_CODE , LDET.CH ARGE_SUBTYPE_CODE , LINE.ROUNDING_FACTOR , LDET.PRICING_PHASE_ID , LDET.CREATED_FROM_LIST_TYPE_CODE , LDET.LIMIT_CODE , SUBSTR(LDET.LIMIT_TEXT, 1, 240) , LDET.LIST_LINE_NO , LDET.MODIFIER_LEVEL_CODE , LDET.GROUP_QUANTITY GROUP_QUANTITY , LDET.GROUP_AMOUNT GROUP_AMOUNT , LINE.PRICING_STATUS_CODE LINE_PRICING_STATUS_CODE , :B25 IS_LDET_REC , LINE.LINE_TYPE_CODE , LDET.NET_AMOUNT_FLAG NET_AMOUNT_FLAG , LDET.CALCULATION_CODE CALCULATION_CODE , LINE.CATCHWEIGHT_QTY , LINE.ACTUAL_ORDER_QUANTITY , LINE.LINE_UNIT_PRICE , LINE.LINE_QUANTITY ORDERED_QTY , LDET.LINE_DETAIL_TYPE_CODE LINE_DETAIL_TYPE_CODE , LINE.LINE_CATEGORY , LINE.PRICE_FLAG FROM QP_NPREQ_LINES_TMP LINE, QP_NPREQ_LDETS_TMP LDET, QP_LIST_HEADERS_B QPLH WHERE NVL(:B14 , :B16 ) <> :B7 AND LINE.PRICING_STATUS_CODE IN (:B12 , :B11 , :B10 ) AND LINE.PROCESS_STATUS IN (:B12 , :B13 , :B10 , 'NEW'||:B10 , 'OLD'||:B10 ) AND (LINE.PRICE_FLAG IN (:B7 , :B9 , :B6 ) OR NVL(LINE.PROCESSED_CODE, '0') = :B8 ) AND LINE.LINE_TYPE_CODE = :B4 AND LINE.UNIT_PRICE IS NOT NULL AND LDET.LINE_INDEX = LINE.LINE_INDEX AND LDET.PRICING_STATUS_CODE = :B10 AND (LDET.UPDATED_FLAG = :B7 OR LINE.PRICE_FLAG = :B6 OR LDET.PRICING_PHASE_ID NOT IN (SELECT PH.PRICING_PHASE_ID FROM QP_EVENT_PHASES EV, QP_PRICING_PHASES PH WHERE PH.PRICING_PHASE_ID = EV.PRICING_PHASE_ID AND (EV.END_DATE_ACTIVE IS NULL OR (EV.END_DATE_ACTIVE IS NOT NULL AND EV.END_DATE_ACTIVE > LINE.PRICING_EFFECTIVE_DATE)) AND ((:B17 = :B7 AND PH.FREIGHT _EXISTS = :B7 ) OR (:B17 = :B16 )) AND INSTR(:B5 , EV.PRICING_EVENT_CODE||', ') > 0 AND (NVL(QP_PREQ_PUB.GET_BUY_LINE_PRICE_FLAG(LDET.CREATED_FROM_LIST_LINE_ID, LINE.LINE_INDEX), LINE.PRICE_FLAG) = :B7 OR (NVL(QP_PREQ_PUB.GET_BUY_LINE_PRICE_FLAG(LDET.CREATED_FROM_LIST_LINE_ID, LINE.LINE_INDEX), LINE.PRICE_FLAG) = :B9 AND NVL(PH.USER_FREEZE_OVERRIDE_FLAG, PH.FREEZE_OVERRIDE_FLAG) = :B7 )))) AND LDET.MODIFIER_LEVEL_CODE IN (:B4 , :B3 ) AND QPLH.LIST_HEADER_ID = LDET.CREATED_FROM_LIST_HEADER_ID AND QPLH.LIST_TYPE_CODE NOT IN (:B2 , :B1 ) AND NVL(LDET.LINE_DETAIL_TYPE_CODE, 'NULL') <> :B21 UNION SELECT /*+ ORDERED USE_NL(ldet line qplh) */ LDET.CREATED_FROM_LIST_LINE_ID , LINE.LINE_INDEX LINE_IND , LINE.LINE_INDEX CURR_LINE_INDEX , LINE.LINE_ID LINE_ID , LDET.LINE_DETAIL_INDEX , LDET.CREATED_FROM_LIST_LINE_TYPE , LDET.CREATED_FROM_LIST_HEADER_ID , LDET.APPLIED_FLAG , (LINE.UPDATED_ADJUSTED_UNIT_PRICE - LINE.ADJUSTED_UNIT_PRICE) AMOUNT_CHANGED , LINE.ADJUSTED_UNIT_PRICE , LDET.LINE_QUANTITY PRICED_QUANTITY , LINE.PRICED_QUANTITY LINE_PRICED_QUANTITY , LINE.UPDATED_ADJUSTED_UNIT_PRICE , LDET.AUTOMATIC_FLAG , LDET.OVERRIDE_FLAG , LDET.PRICING_GROUP_SEQUENCE , LDET.OPERAND_CALCULATION_CODE , LDET.OPERAND_VALUE , LDET.ADJUSTMENT_AMOUNT , LINE.UNIT_PRICE , LDET.ACCRUAL_FLAG , NVL(LDET.UPDATED_FLAG, :B16 ) , LDET.PROCESS_CODE , LDET.PRICING_STATUS_CODE , LDET.PRICING_STATUS_TEXT , LDET.PRICE_BREAK_TYPE_CODE , LDET.CHARGE_TYPE_CODE , LDET.CHARGE_SU BTYPE_CODE , LINE.ROUNDING_FACTOR , LDET.PRICING_PHASE_ID , LDET.CREATED_FROM_LIST_TYPE_CODE , LDET.LIMIT_CODE , SUBSTR(LDET.LIMIT_TEXT, 1, 240) , LDET.LIST_LINE_NO , LDET.MODIFIER_LEVEL_CODE , LDET.GROUP_QUANTITY GROUP_QUANTITY , LDET.GROUP_AMOUNT GROUP_AMOUNT , LINE.PRICING_STATUS_CODE LINE_PRICING_STATUS_CODE , :B26 IS_LDET_REC , LINE.LINE_TYPE_CODE , LDET.NET_AMOUNT_FLAG NET_AMOUNT_FLAG , LDET.CALCULATION_CODE CALCULATION_CODE , LINE.CATCHWEIGHT_QTY , LINE.ACTUAL_ORDER_QUANTITY , LINE.LINE_UNIT_PRICE , LINE.LINE_QUANTITY ORDERED_QTY , LDET.LINE_DETAIL_TYPE_CODE LINE_DETAIL_TYPE_CODE , LINE.LINE_CATEGORY , LINE.PRICE_FLAG FROM QP_NPREQ_LINES_TMP LINE1, QP_NPREQ_LDETS_TMP LDET , QP_NPREQ_LINES_TMP LINE, QP_LIST_HEADERS_B QPLH WHERE NVL(:B14 , :B16 ) <> :B7 AND LINE1.PRICING_STATUS_CODE IN (:B12 , :B11 , :B10 ) AND LINE1.PROCESS_STATUS IN (:B12 , :B13 , :B10 , 'NEW'||:B10 , 'OLD'||:B10 ) AND LINE.PROCESS_STATUS IN (:B12 , :B13 , :B10 , 'NEW'||:B10 , 'OLD'||:B10 ) AND LINE1.LINE_TYPE_CODE = :B19 AND (LINE1.PRICE_FLAG IN (:B7 , :B9 , :B6 ) OR NVL(LINE1.PROCESSED_CODE, '0') = :B8 ) AND (LINE.PRICE_FLAG IN (:B7 , :B9 , :B6 ) OR NVL(LINE.PROCESSED_CODE, '0') = :B8 ) AND (LINE.UNIT_PRICE IS NOT NULL OR LINE.LINE_TYPE_CODE = :B19 ) AND LINE.PRICING_STATUS_CODE IN (:B12 , :B11 , :B10 ) AND LINE1.LINE_INDEX = LDET.LINE_INDEX AND LDET.PRICING_STATUS_CODE = :B10 AND (LDET.UPDATED_FLAG = :B7 OR LINE.PRICE_FLAG = :B6 OR LDET.PRICING_PHASE_ID NOT I N (SELECT PH.PRICING_PHASE_ID FROM QP_EVENT_PHASES EV, QP_PRICING_PHASES PH WHERE PH.PRICING_PHASE_ID = EV.PRICING_PHASE_ID AND (EV.END_DATE_ACTIVE IS NULL OR (EV.END_DATE_ACTIVE IS NOT NULL AND EV.END_DATE_ACTIVE > LINE.PRICING_EFFECTIVE_DATE)) AND ((:B17 = :B7 AND PH.FREIGHT_EXISTS = :B7 ) OR (:B17 = :B16 )) AND INSTR(:B5 , EV.PRICING_EVENT_CODE||', ') > 0 AND (NVL(QP_PREQ_PUB.GET_BUY_LINE_PRICE_FLAG(LDET.CREATED_FROM_LIST_LINE_ID, LINE1.LINE_INDEX), LINE1.PRICE_FLAG) = :B7 OR (NVL(QP_PREQ_PUB.GET_BUY_LINE_PRICE_FLAG(LDET.CREATED_FROM_LIST_LINE_ID, LINE1.LINE_INDEX), LINE1.PRICE_FLAG) = :B9 AND NVL(PH.USER_FREEZE_OVERRIDE_FLAG, PH.FREEZE_OVERRIDE_FLAG) = :B7 )))) AND LDET.MODIFIER_LEVEL_CODE = :B19 AND QPLH.LIST_HEADER_ID = LDET.CREATED_FROM_LIST_HEADER_ID AND QPLH.LIST_TYPE_CODE NOT IN (:B2 , :B1 ) ORDER BY PRICING_GROUP_SEQUENCE, LINE_IND, IS_LDET_REC
9wdrypwkpf607 begin OE_FULFILL_WF.START_FULFILLMENT (:v1, :v2, :v3, :v4, :v5); end;
a29grr748ghc4 BEGIN jdr_custom_internal.getActiveLayers(:1, :2, :3, :4, :5); END;
avc1jqzz04wpr SELECT 'x' FROM DUAL
bf7uwg5pa3pj6 begin FND_FLEX_WORKFLOW_APIS.VALIDATE_COMBINATION (:v1, :v2, :v3, :v4, :v5); end;
bt0w082dfrm8v BEGIN WSH_SHIP_CONFIRM_ACTIONS.interface_ALL_wrp( :errbuf, :rc, :A0, :A1, :A2, :A3); END;
cd9mbmqyf4qhp UPDATE 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
csvvv0fmhr1yc BEGIN FFP1893_01010001.FORMULA( :N1, :N4, :T1, :I1, :D1, :T2, :I2, :T7, :I7, :T8, :I8, :T5, :I5, :N3, :T4, :I4, :N2, :N5, :T3, :I3, :T6, :I6, :FFERLN, :FFERCD, :FFERMT); END;
cwyx16zn1hpfb select parameter, value from nls_session_parameters
dcvv68fju01g4 begin FND_FLEX_WORKFLOW_APIS.END_GENERATION (:v1, :v2, :v3, :v4, :v5); end;
dk0sqcvc2xjvs BEGIN ASO_QUOTE_PUB_W.Create_Qte_Opportunity(:1, :2, :3, :4, :5, :6, p_c_auto_version_flag => :7, p_c_pricing_request_type => :8, p_c_header_pricing_event => :9, p_c_cal_tax_flag => :10, p_c_cal_freight_charge_flag => :11, p_c_copy_task_flag => :12, p_c_copy_notes_flag => :13, p_c_copy_att_flag => :14, p_c_deactivate_all => :15, p_c_price_mode => :16, p_source_code => :17, p_op_opportunity_id => :18, p_op_quote_name => :19, p_op_cust_account_id => :20, p_op_resource_id => :21, p_op_sold_to_contact_id => :22, p_op_sold_to_party_site_id => :23, p_op_price_list_id => :24, p_op_resource_grp_id => :25, p_op_channel_code => :26, p_op_order_type_id => :27, p_op_agreement_id => :28, p_op_currency_code => :29, p_op_marketing_source_code_id => :30, p_op_quote_expiration_date => :31, p_op_cust_party_id => :32, p_op_pricing_status_indicator => :33, p_op_tax_status_indicator => :34, x_return_status => :35, x_msg_count => :36, x_msg_data => :37 ); END;
fb13x9qx0ftks begin OE_STANDARD_WF.OEOL_SELECTOR (:v1, :v2, :v3, :v4, :v5); end;
fmfdkztk8vx23 SELECT CATEGORY, SEVERITY, FND_LOG_SEVERITY FROM FND_NEW_MESSAGES WHERE MESSAGE_NAME = :B1 AND APPLICATION_ID = :B2 AND LANGUAGE_CODE = :B3 AND ROWNUM = 1
g8102j8yynbwz begin WF_STANDARD.CONTINUEFLOW (:v1, :v2, :v3, :v4, :v5); end;
gf1u933c95jb5 DECLARE l_ret_stat varchar2(56); BEGIN CSI_INV_TXN_HOOK_PKG.postTransaction( p_header_id => :1 , p_transaction_id => :2 , x_return_status => l_ret_stat ); INV_TXNSTUB_PUB.g_ret_status := l_ret_stat; END;
gksvm8wmzk8w0 begin OE_INVOICE_WF.INVOICE_INTERFACE (:v1, :v2, :v3, :v4, :v5); end;

Back to SQL Statistics
Back to Top

 

Instance Activity Statistics

Back to Top

Instance Activity Stats

Statistic Total per Second per Trans
CPU used by this session 1,965,757 545.42 1.57
CPU used when call started 1,961,370 544.20 1.57
CR blocks created 16,728,253 4,641.41 13.37
Cached Commit SCN referenced 47,660 13.22 0.04
Commit SCN cached 8 0.00 0.00
DB time 4,933,746 1,368.91 3.94
DBWR checkpoint buffers written 3,039,276 843.28 2.43
DBWR checkpoints 34 0.01 0.00
DBWR object drop buffers written 57,852 16.05 0.05
DBWR revisited being-written buffer 193 0.05 0.00
DBWR thread checkpoint buffers written 546,983 151.77 0.44
DBWR transaction table writes 2,465 0.68 0.00
DBWR undo block writes 1,624,318 450.68 1.30
DFO trees parallelized 48 0.01 0.00
IMU CR rollbacks 43,897,258 12,179.71 35.09
IMU Flushes 358,822 99.56 0.29
IMU Redo allocation size 2,416,474,080 670,473.62 1,931.70
IMU commits 647,513 179.66 0.52
IMU contention 38,799 10.77 0.03
IMU ktichg flush 11,553 3.21 0.01
IMU pool not allocated 0 0.00 0.00
IMU recursive-transaction flush 1,788 0.50 0.00
IMU undo allocation size 5,804,228,536 1,610,438.17 4,639.84
IMU- failed to get a private strand 0 0.00 0.00
PX local messages recv'd 52,797 14.65 0.04
PX local messages sent 52,797 14.65 0.04
Parallel operations downgraded 25 to 50 pct 40 0.01 0.00
Parallel operations not downgraded 8 0.00 0.00
SQL*Net roundtrips to/from client 52,091,032 14,453.15 41.64
active txn count during cleanout 121,654,618 33,754.23 97.25
application wait time 11,154 3.09 0.01
background checkpoints completed 3 0.00 0.00
background checkpoints started 2 0.00 0.00
background timeouts 13,898 3.86 0.01
branch node splits 1,084 0.30 0.00
buffer is not pinned count 595,248,621 165,157.37 475.84
buffer is pinned count 1,551,143,441 430,379.44 1,239.97
bytes received via SQL*Net from client 11,414,410,765 3,167,036.36 9,124.56
bytes sent via SQL*Net to client 10,334,536,855 2,867,415.12 8,261.32
calls to get snapshot scn: kcmgss 117,898,306 32,712.00 94.25
calls to kcmgas 20,999,599 5,826.54 16.79
calls to kcmgcs 12,133,043 3,366.43 9.70
change write time 42,460 11.78 0.03
cleanout - number of ktugct calls 27,274,937 7,567.69 21.80
cleanouts and rollbacks - consistent read gets 14,673,989 4,071.44 11.73
cleanouts only - consistent read gets 156,507 43.42 0.13
cluster key scan block gets 873,648 242.40 0.70
cluster key scans 239,898 66.56 0.19
commit batch/immediate performed 4,397 1.22 0.00
commit batch/immediate requested 4,397 1.22 0.00
commit cleanout failures: block lost 260,132 72.18 0.21
commit cleanout failures: buffer being written 1,749 0.49 0.00
commit cleanout failures: callback failure 111,231 30.86 0.09
commit cleanout failures: cannot pin 31,547 8.75 0.03
commit cleanouts 9,735,625 2,701.24 7.78
commit cleanouts successfully completed 9,330,966 2,588.96 7.46
commit immediate performed 4,397 1.22 0.00
commit immediate requested 4,397 1.22 0.00
commit txn count during cleanout 1,436,269 398.51 1.15
concurrency wait time 17,018 4.72 0.01
consistent changes 788,945,923 218,900.52 630.67
consistent gets 1,858,645,143 515,698.70 1,485.78
consistent gets - examination 1,299,575,843 360,579.62 1,038.87
consistent gets from cache 1,858,645,389 515,698.76 1,485.78
cursor authentications 2,104 0.58 0.00
data blocks consistent reads - undo records applied 784,628,877 217,702.71 627.22
db block changes 201,816,212 55,995.82 161.33
db block gets 226,044,840 62,718.28 180.70
db block gets direct 4,284 1.19 0.00
db block gets from cache 226,040,588 62,717.10 180.69
deferred (CURRENT) block cleanout applications 1,679,933 466.11 1.34
dirty buffers inspected 10,175 2.82 0.01
enqueue conversions 10,440 2.90 0.01
enqueue releases 4,688,842 1,300.96 3.75
enqueue requests 4,694,242 1,302.46 3.75
enqueue timeouts 5,263 1.46 0.00
enqueue waits 34,832 9.66 0.03
exchange deadlocks 25,786 7.15 0.02
execute count 104,948,247 29,118.89 83.89
failed probes on index block reclamation 9,605 2.66 0.01
frame signature mismatch 322 0.09 0.00
free buffer inspected 2,983,409 827.78 2.38
free buffer requested 21,344,406 5,922.21 17.06
heap block compress 32,498,211 9,016.94 25.98
hot buffers moved to head of LRU 1,318,254 365.76 1.05
immediate (CR) block cleanout applications 14,830,524 4,114.87 11.86
immediate (CURRENT) block cleanout applications 1,164,817 323.19 0.93
index crx upgrade (found) 13,118 3.64 0.01
index crx upgrade (positioned) 10,530,148 2,921.69 8.42
index fast full scans (rowid ranges) 784 0.22 0.00
index fetch by key 189,511,462 52,581.75 151.49
index scans kdiixs1 141,870,547 39,363.33 113.41
java call heap collected bytes 1,507,954,616 418,396.29 1,205.44
java call heap collected count 18,428,090 5,113.05 14.73
java call heap gc count 4,871 1.35 0.00
java call heap live object count 1,550,438 430.18 1.24
java call heap live object count max 1,561,909 433.37 1.25
java call heap live size 391,774,248 108,701.48 313.18
java call heap live size max 394,279,568 109,396.60 315.18
java call heap object count 3,826,350 1,061.66 3.06
java call heap object count max 3,836,689 1,064.53 3.07
java call heap total size 508,164,096 140,994.94 406.22
java call heap total size max 511,068,160 141,800.70 408.54
java call heap used size 537,467,448 149,125.43 429.65
java call heap used size max 539,977,720 149,821.93 431.65
leaf node 90-10 splits 21,427 5.95 0.02
leaf node splits 248,217 68.87 0.20
lob reads 23,657 6.56 0.02
lob writes 41,321 11.46 0.03
lob writes unaligned 41,321 11.46 0.03
logons cumulative 10,192 2.83 0.01
messages received 2,100,831 582.90 1.68
messages sent 2,100,831 582.90 1.68
no buffer to keep pinned count 16 0.00 0.00
no work - consistent read gets 507,672,973 140,858.67 405.83
opened cursors cumulative 6,044,214 1,677.02 4.83
parse count (failures) 3,613 1.00 0.00
parse count (hard) 9,396 2.61 0.01
parse count (total) 9,271,216 2,572.39 7.41
parse time cpu 44,460 12.34 0.04
parse time elapsed 48,812 13.54 0.04
physical read IO requests 308,995 85.73 0.25
physical read bytes 3,769,450,496 1,045,869.74 3,013.26
physical read total IO requests 338,261 93.85 0.27
physical read total bytes 4,248,035,328 1,178,657.63 3,395.83
physical read total multi block requests 12,444 3.45 0.01
physical reads 460,138 127.67 0.37
physical reads cache 458,786 127.29 0.37
physical reads cache prefetch 150,543 41.77 0.12
physical reads direct 1,352 0.38 0.00
physical reads direct temporary tablespace 620 0.17 0.00
physical reads prefetch warmup 81,599 22.64 0.07
physical write IO requests 1,672,487 464.05 1.34
physical write bytes 25,635,725,312 7,112,874.76 20,492.92
physical write total IO requests 2,934,033 814.08 2.35
physical write total bytes 59,481,654,784 16,503,748.42 47,549.00
physical write total multi block requests 1,445,832 401.16 1.16
physical writes 3,129,361 868.27 2.50
physical writes direct 5,237 1.45 0.00
physical writes direct (lob) 226 0.06 0.00
physical writes direct temporary tablespace 4,619 1.28 0.00
physical writes from cache 3,124,124 866.82 2.50
physical writes non checkpoint 2,378,689 659.99 1.90
pinned buffers inspected 3,918 1.09 0.00
prefetch clients - default 1 0.00 0.00
prefetch warmup blocks aged out before use 251,992 69.92 0.20
prefetched blocks aged out before use 120 0.03 0.00
process last non-idle time 3,606 1.00 0.00
queries parallelized 48 0.01 0.00
recursive calls 169,694,471 47,083.34 135.65
recursive cpu usage 1,093,059 303.28 0.87
redo blocks written 65,938,561 18,295.28 52.71
redo buffer allocation retries 129 0.04 0.00
redo entries 103,825,670 28,807.42 83.00
redo log space requests 0 0.00 0.00
redo log space wait time 0 0.00 0.00
redo ordering marks 1,310,107 363.50 1.05
redo size 32,331,118,924 8,970,575.12 25,845.15
redo subscn max counts 2,385,923 662.00 1.91
redo synch time 97,807 27.14 0.08
redo synch writes 2,427,619 673.57 1.94
redo wastage 324,867,208 90,137.48 259.70
redo write time 58,140 16.13 0.05
redo writer latching time 271 0.08 0.00
redo writes 866,456 240.41 0.69
rollback changes - undo records applied 305,664 84.81 0.24
rollbacks only - consistent read gets 2,191,829 608.14 1.75
rows fetched via callback 100,080,793 27,768.36 80.00
session connect time 0 0.00 0.00
session cursor cache hits 5,783,211 1,604.61 4.62
session logical reads 2,084,681,865 578,414.73 1,666.47
session pga memory 10,759,551,672 2,985,339.51 8,601.07
session pga memory max 12,069,220,408 3,348,719.50 9,648.01
session uga memory ############### 75,250,177.69 216,803.50
session uga memory max 74,822,908,984 20,760,324.68 59,812.63
shared hash latch upgrades - no wait 32,911,272 9,131.54 26.31
shared hash latch upgrades - wait 28,167 7.82 0.02
sorts (memory) 11,041,133 3,063.47 8.83
sorts (rows) 136,434,643 37,855.08 109.06
sql area evicted 2,427 0.67 0.00
sql area purged 3,783 1.05 0.00
summed dirty queue length 578,307 160.46 0.46
switch current to new buffer 1,474,448 409.10 1.18
table fetch by rowid 919,141,453 255,024.50 734.75
table fetch continued row 29,252,219 8,116.31 23.38
table scan blocks gotten 105,481,150 29,266.74 84.32
table scan rows gotten 8,617,192,613 2,390,921.70 6,888.49
table scans (long tables) 2,041 0.57 0.00
table scans (rowid ranges) 2,039 0.57 0.00
table scans (short tables) 6,247,979 1,733.56 4.99
total number of times SMON posted 161,241 44.74 0.13
transaction rollbacks 4,397 1.22 0.00
transaction tables consistent read rollbacks 89 0.02 0.00
transaction tables consistent reads - undo records applied 5,143 1.43 0.00
undo change vector size 11,309,067,032 3,137,807.75 9,040.35
user I/O wait time 131,877 36.59 0.11
user calls 49,736,331 13,799.82 39.76
user commits 985,913 273.55 0.79
user rollbacks 265,042 73.54 0.21
workarea executions - onepass 4 0.00 0.00
workarea executions - optimal 6,632,795 1,840.33 5.30
write clones created in background 1,767 0.49 0.00
write clones created in foreground 9,859 2.74 0.01

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistic Begin Value End Value
session cursor cache count 542,823 1,262,942
opened cursors current 1,107,931 1,245,423
workarea memory allocated 254 160
logons current 5,268 5,294

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

Statistic Total per Hour
log switches (derived) 0 0.00

Back to Instance Activity Statistics
Back to Top

 

IO Stats

Back to Top

Tablespace IO Stats

Tablespace Reads Av Reads/s Av Rd(ms) Av Blks/Rd Writes Av Writes/s Buffer Waits Av Buf Wt(ms)
APPS_UNDOTS1 30 0 12.00 1.00 793,842 220 250,790 0.03
APPS_TS_TX_DATA 184,780 51 4.13 1.29 194,438 54 112,731 0.21
APPS_TS_TX_IDX 98,648 27 4.24 1.29 227,620 63 58,817 0.40
APPS_ASSM_DATA 8,811 2 2.11 6.51 233,788 65 41,268 0.44
APPS_ASSM_IDX 6,840 2 2.29 1.04 154,043 43 178,930 0.10
APPS_TS_TX_INTERFACE 1,254 0 4.50 2.05 32,571 9 16,030 0.04
TEMP 599 0 4.24 8.60 10,072 3 53 1.13
APPS_TS_SUMMARY 57 0 11.23 1.00 7,975 2 2,096 0.04
APPS_TS_SEED 2,185 1 5.62 1.33 5,694 2 765 2.22
SYSTEM 4,850 1 3.56 3.73 2,775 1 20,771 0.07
APPS_TS_QUEUES 385 0 5.84 2.66 5,570 2 418 0.33
APPS_TS_ARCHIVE 65 0 4.00 1.37 2,503 1 100 5.10
SYSAUX 285 0 2.25 1.09 1,579 0 0 0.00
APPS_TS_NOLOGGING 25 0 7.20 1.56 39 0 0 0.00
CTXSYS 24 0 5.00 1.00 6 0 0 0.00
APPS_TS_MEDIA 12 0 8.33 1.00 9 0 0 0.00
ODM 12 0 5.83 1.00 3 0 0 0.00
OLAP 12 0 10.00 1.00 3 0 0 0.00
OWAPUB 12 0 5.00 1.00 3 0 0 0.00
PORTAL 12 0 7.50 1.00 3 0 0 0.00
SYNCSERVER 12 0 7.50 1.00 3 0 0 0.00

Back to IO Stats
Back to Top

File IO Stats

Tablespace Filename Reads Av Reads/s Av Rd(ms) Av Blks/Rd Writes Av Writes/s Buffer Waits Av Buf Wt(ms)
APPS_ASSM_DATA /DB/visdata/apps_assm_data.dbf 8,811 2 2.11 6.51 233,788 65 41,268 0.44
APPS_ASSM_IDX /DB/visdata/apps_assm_idx.dbf 6,840 2 2.29 1.04 154,043 43 178,930 0.10
APPS_TS_ARCHIVE /DB/visdata/archive1.dbf 35 0 3.71 1.37 2,235 1 87 2.18
APPS_TS_ARCHIVE /DB/visdata/archive2.dbf 30 0 4.33 1.37 268 0 13 24.62
APPS_TS_MEDIA /DB/visdata/media1.dbf 4 0 10.00 1.00 3 0 0 0.00
APPS_TS_MEDIA /DB/visdata/media2.dbf 4 0 7.50 1.00 3 0 0 0.00
APPS_TS_MEDIA /DB/visdata/media3.dbf 4 0 7.50 1.00 3 0 0 0.00
APPS_TS_NOLOGGING /DB/visdata/nologging1.dbf 4 0 10.00 1.00 3 0 0 0.00
APPS_TS_NOLOGGING /DB/visdata/nologging2.dbf 15 0 5.33 1.00 22 0 0 0.00
APPS_TS_NOLOGGING /DB/visdata/nologging3.dbf 6 0 10.00 3.33 14 0 0 0.00
APPS_TS_QUEUES /DB/visdata/queues1.dbf 44 0 5.68 2.43 768 0 106 0.38
APPS_TS_QUEUES /DB/visdata/queues2.dbf 37 0 3.78 3.24 897 0 261 0.27
APPS_TS_QUEUES /DB/visdata/queues3.dbf 48 0 5.00 2.88 820 0 6 0.00
APPS_TS_QUEUES /DB/visdata/queues4.dbf 37 0 5.95 3.30 656 0 2 0.00
APPS_TS_QUEUES /DB/visdata/queues5.dbf 41 0 6.59 3.95 844 0 1 0.00
APPS_TS_QUEUES /DB/visdata/queues6.dbf 46 0 5.65 2.48 597 0 2 0.00
APPS_TS_QUEUES /DB/visdata/queues7.dbf 132 0 6.59 1.98 988 0 40 0.75
APPS_TS_SEED /DB/visdata/reference1.dbf 190 0 5.63 1.35 484 0 51 1.76
APPS_TS_SEED /DB/visdata/reference10.dbf 181 0 6.30 1.27 558 0 51 1.18
APPS_TS_SEED /DB/visdata/reference2.dbf 205 0 5.71 1.26 587 0 39 5.90
APPS_TS_SEED /DB/visdata/reference3.dbf 331 0 4.71 1.33 637 0 380 2.03
APPS_TS_SEED /DB/visdata/reference4.dbf 211 0 5.78 1.39 619 0 30 1.67
APPS_TS_SEED /DB/visdata/reference5.dbf 255 0 5.41 1.26 588 0 67 3.43
APPS_TS_SEED /DB/visdata/reference6.dbf 242 0 5.62 1.42 632 0 21 2.38
APPS_TS_SEED /DB/visdata/reference7.dbf 220 0 5.95 1.33 497 0 19 2.11
APPS_TS_SEED /DB/visdata/reference8.dbf 184 0 6.09 1.43 521 0 32 5.00
APPS_TS_SEED /DB/visdata/reference9.dbf 166 0 5.78 1.28 571 0 75 0.27
APPS_TS_SUMMARY /DB/visdata/summary1.dbf 5 0 6.00 1.00 934 0 354 0.00
APPS_TS_SUMMARY /DB/visdata/summary2.dbf 5 0 8.00 1.00 908 0 159 0.00
APPS_TS_SUMMARY /DB/visdata/summary3.dbf 9 0 11.11 1.00 962 0 200 0.05
APPS_TS_SUMMARY /DB/visdata/summary4.dbf 10 0 12.00 1.00 924 0 209 0.05
APPS_TS_SUMMARY /DB/visdata/summary5.dbf 7 0 11.43 1.00 1,003 0 262 0.08
APPS_TS_SUMMARY /DB/visdata/summary6.dbf 7 0 14.29 1.00 1,085 0 548 0.02
APPS_TS_SUMMARY /DB/visdata/summary7.dbf 7 0 10.00 1.00 986 0 197 0.10
APPS_TS_SUMMARY /DB/visdata/summary8.dbf 7 0 14.29 1.00 1,173 0 167 0.12
APPS_TS_TX_DATA /DB/visdata/tx_data1.dbf 3,466 1 4.98 1.24 361 0 7 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data10.dbf 3,427 1 4.60 1.22 242 0 0 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data11.dbf 3,388 1 4.45 1.26 259 0 0 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data12.dbf 13,544 4 3.08 1.20 4,404 1 3,493 1.06
APPS_TS_TX_DATA /DB/visdata/tx_data13.dbf 18,758 5 4.56 1.44 6,040 2 2,445 0.65
APPS_TS_TX_DATA /DB/visdata/tx_data14.dbf 13,427 4 4.00 1.33 27,927 8 14,900 0.12
APPS_TS_TX_DATA /DB/visdata/tx_data15.dbf 9,671 3 3.75 1.40 27,396 8 13,879 0.18
APPS_TS_TX_DATA /DB/visdata/tx_data16.dbf 9,679 3 3.82 1.41 26,093 7 15,045 0.19
APPS_TS_TX_DATA /DB/visdata/tx_data17.dbf 9,538 3 3.71 1.41 25,067 7 14,634 0.19
APPS_TS_TX_DATA /DB/visdata/tx_data18.dbf 9,619 3 3.69 1.39 23,940 7 14,320 0.13
APPS_TS_TX_DATA /DB/visdata/tx_data19.dbf 9,472 3 3.86 1.40 23,967 7 15,597 0.19
APPS_TS_TX_DATA /DB/visdata/tx_data2.dbf 6,981 2 3.29 1.16 1,180 0 2,074 0.64
APPS_TS_TX_DATA /DB/visdata/tx_data20.dbf 9,590 3 3.92 1.43 23,592 7 14,932 0.14
APPS_TS_TX_DATA /DB/visdata/tx_data21.dbf 24,122 7 4.60 1.17 1,113 0 1,344 0.10
APPS_TS_TX_DATA /DB/visdata/tx_data3.dbf 4,217 1 5.25 1.39 492 0 8 1.25
APPS_TS_TX_DATA /DB/visdata/tx_data4.dbf 18,559 5 4.31 1.07 324 0 4 7.50
APPS_TS_TX_DATA /DB/visdata/tx_data5.dbf 3,512 1 4.45 1.20 438 0 4 7.50
APPS_TS_TX_DATA /DB/visdata/tx_data6.dbf 3,505 1 4.64 1.22 248 0 16 8.75
APPS_TS_TX_DATA /DB/visdata/tx_data7.dbf 3,426 1 4.92 1.24 528 0 21 3.33
APPS_TS_TX_DATA /DB/visdata/tx_data8.dbf 3,348 1 4.43 1.23 523 0 7 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data9.dbf 3,531 1 4.55 1.26 304 0 1 10.00
APPS_TS_TX_IDX /DB/visdata/tx_idx1.dbf 2,646 1 3.25 1.12 2,560 1 1,186 0.74
APPS_TS_TX_IDX /DB/visdata/tx_idx10.dbf 2,585 1 3.54 1.15 1,804 1 1,073 0.67
APPS_TS_TX_IDX /DB/visdata/tx_idx11.dbf 2,618 1 3.41 1.15 2,012 1 1,173 0.55
APPS_TS_TX_IDX /DB/visdata/tx_idx12.dbf 12,005 3 4.95 1.51 24,319 7 1,163 0.17
APPS_TS_TX_IDX /DB/visdata/tx_idx13.dbf 9,872 3 4.34 1.22 31,472 9 3,579 0.20
APPS_TS_TX_IDX /DB/visdata/tx_idx14.dbf 5,953 2 4.83 1.33 23,094 6 3,356 0.22
APPS_TS_TX_IDX /DB/visdata/tx_idx15.dbf 6,018 2 4.49 1.32 19,521 5 3,801 0.21
APPS_TS_TX_IDX /DB/visdata/tx_idx16.dbf 5,877 2 4.66 1.32 18,015 5 3,771 0.14
APPS_TS_TX_IDX /DB/visdata/tx_idx17.dbf 5,881 2 4.66 1.33 16,958 5 3,651 0.19
APPS_TS_TX_IDX /DB/visdata/tx_idx18.dbf 5,975 2 4.63 1.32 16,777 5 5,068 0.21
APPS_TS_TX_IDX /DB/visdata/tx_idx19.dbf 5,885 2 4.47 1.32 15,789 4 3,446 0.17
APPS_TS_TX_IDX /DB/visdata/tx_idx2.dbf 3,237 1 3.86 1.27 2,319 1 1,380 0.36
APPS_TS_TX_IDX /DB/visdata/tx_idx20.dbf 5,776 2 4.57 1.31 15,335 4 3,845 0.07
APPS_TS_TX_IDX /DB/visdata/tx_idx21.dbf 3,780 1 5.06 1.47 16,253 5 2,938 1.77
APPS_TS_TX_IDX /DB/visdata/tx_idx3.dbf 4,131 1 2.75 1.10 2,124 1 3,250 0.59
APPS_TS_TX_IDX /DB/visdata/tx_idx4.dbf 2,822 1 3.26 1.13 3,923 1 3,432 0.40
APPS_TS_TX_IDX /DB/visdata/tx_idx5.dbf 2,825 1 3.59 1.18 5,235 1 8,004 0.23
APPS_TS_TX_IDX /DB/visdata/tx_idx6.dbf 2,760 1 3.56 1.17 2,996 1 1,494 1.06
APPS_TS_TX_IDX /DB/visdata/tx_idx7.dbf 2,686 1 3.36 1.14 2,938 1 1,095 0.91
APPS_TS_TX_IDX /DB/visdata/tx_idx8.dbf 2,690 1 3.28 1.17 2,171 1 1,033 1.18
APPS_TS_TX_IDX /DB/visdata/tx_idx9.dbf 2,626 1 3.26 1.18 2,005 1 1,079 0.77
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte.dbf 240 0 3.63 1.64 5,273 1 4,715 0.05
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte2.dbf 418 0 3.83 1.77 6,530 2 3,783 0.04
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte3.dbf 109 0 5.78 3.28 5,541 2 3,075 0.02
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte4.dbf 81 0 6.30 3.62 5,235 1 1,522 0.03
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte5.dbf 258 0 5.16 1.75 5,028 1 1,791 0.02
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte6.dbf 148 0 4.73 2.27 4,964 1 1,144 0.06
APPS_UNDOTS1 /DB/visdata/undo01.dbf 3 0 16.67 1.00 80,109 22 25,352 0.04
APPS_UNDOTS1 /DB/visdata/undo02.dbf 3 0 13.33 1.00 79,724 22 28,207 0.03
APPS_UNDOTS1 /DB/visdata/undo03.dbf 3 0 13.33 1.00 79,102 22 28,725 0.03
APPS_UNDOTS1 /DB/visdata/undo04.dbf 3 0 10.00 1.00 72,739 20 22,694 0.04
APPS_UNDOTS1 /DB/visdata/undo05.dbf 3 0 13.33 1.00 77,658 22 27,608 0.04
APPS_UNDOTS1 /DB/visdata/undo06.dbf 3 0 13.33 1.00 78,791 22 25,186 0.03
APPS_UNDOTS1 /DB/visdata/undo07.dbf 3 0 10.00 1.00 77,842 22 25,064 0.02
APPS_UNDOTS1 /DB/visdata/undo08.dbf 3 0 10.00 1.00 83,902 23 20,902 0.03
APPS_UNDOTS1 /DB/visdata/undo09.dbf 3 0 10.00 1.00 82,922 23 26,227 0.03
APPS_UNDOTS1 /DB/visdata/undo10.dbf 3 0 10.00 1.00 81,053 22 20,825 0.03
CTXSYS /DB/visdata/ctx1.dbf 12 0 5.00 1.00 3 0 0 0.00
CTXSYS /DB/visdata/ctx2.dbf 12 0 5.00 1.00 3 0 0 0.00
ODM /DB/visdata/odm.dbf 12 0 5.83 1.00 3 0 0 0.00
OLAP /DB/visdata/olap.dbf 12 0 10.00 1.00 3 0 0 0.00
OWAPUB /DB/visdata/owa1.dbf 12 0 5.00 1.00 3 0 0 0.00
PORTAL /DB/visdata/portal.dbf 12 0 7.50 1.00 3 0 0 0.00
SYNCSERVER /DB/visdata/mobile01.dbf 12 0 7.50 1.00 3 0 0 0.00
SYSAUX /DB/visdata/sysaux01.dbf 5 0 10.00 1.40 533 0 0 0.00
SYSAUX /DB/visdata/sysaux02.dbf 280 0 2.11 1.08 1,046 0 0 0.00
SYSTEM /DB/visdata/sys1.dbf 529 0 3.67 4.10 107 0 62 1.13
SYSTEM /DB/visdata/sys2.dbf 541 0 3.31 4.24 198 0 103 0.00
SYSTEM /DB/visdata/sys3.dbf 636 0 3.32 3.68 261 0 41 0.00
SYSTEM /DB/visdata/sys4.dbf 613 0 2.53 3.75 272 0 34 0.00
SYSTEM /DB/visdata/sys5.dbf 778 0 3.87 3.12 685 0 446 0.02
SYSTEM /DB/visdata/sys6.dbf 534 0 3.75 4.29 68 0 2 0.00
SYSTEM /DB/visdata/sys7.dbf 425 0 4.64 4.38 191 0 70 0.00
SYSTEM /DB/visdata/sys8.dbf 336 0 4.02 3.49 538 0 19,876 0.07
SYSTEM /DB/visdata/sys9.dbf 458 0 3.43 2.71 455 0 137 0.29
TEMP /DB/visdata/temp1.dbf 158 0 4.62 10.42 2,689 1 0  
TEMP /DB/visdata/temp2.dbf 112 0 3.57 1.00 2,294 1 6 1.67
TEMP /DB/visdata/temp3.dbf 208 0 4.47 15.72 2,467 1 0  
TEMP /DB/visdata/temp4.dbf 121 0 3.97 1.00 2,622 1 47 1.06

Back to IO Stats
Back to Top

 

Buffer Pool Statistics

P Number of Buffers Pool Hit% Buffer Gets Physical Reads Physical Writes Free Buff Wait Writ Comp Wait Buffer Busy Waits
D 2,182,837 100 2,084,427,219 458,751 3,124,124 0 0 682,769


Back to Top

 

Advisory Statistics

Back to Top

Instance Recovery Stats

  Targt MTTR (s) Estd MTTR (s) Recovery Estd IOs Actual Redo Blks Target Redo Blks Log File Size Redo Blks Log Ckpt Timeout Redo Blks Log Ckpt Interval Redo Blks
B 180 95 48495 1186277 4567642 188743680 4567642  
E 180 99 54325 1192525 10180644 188743680 10180644  

Back to Advisory Statistics
Back to Top

 

Buffer Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit % W/A MB Processed Extra W/A MB Read/Written
100.00 639,462 16

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

  PGA Aggr Target(M) Auto PGA Target(M) PGA Mem Alloc(M) W/A PGA Used(M) %PGA W/A Mem %Auto W/A Mem %Man W/A Mem Global Mem Bound(K)
B 20,480 1,280 47,619.27 1.41 0.00 100.00 0.00 1,048,576
E 20,480 1,280 55,652.51 0.16 0.00 100.00 0.00 1,048,576

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High Optimal Total Execs Optimal Execs 1-Pass Execs M-Pass Execs
2K 4K 5,991,324 5,991,324 0 0
64K 128K 11,734 11,734 0 0
128K 256K 1,158 1,158 0 0
256K 512K 1,145 1,145 0 0
512K 1024K 188,250 188,250 0 0
1M 2M 438,618 438,618 0 0
2M 4M 70 68 2 0
4M 8M 23 21 2 0
8M 16M 18 18 0 0
32M 64M 8 8 0 0
64M 128M 6 6 0 0
128M 256M 2 2 0 0

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

PGA Target Est (MB) Size Factr W/A MB Processed Estd Extra W/A MB Read/ Written to Disk Estd PGA Cache Hit % Estd PGA Overalloc Count
2,560 0.13 935,055.73 9,103.84 99.00 1,172
5,120 0.25 935,055.73 9,041.81 99.00 1,138
10,240 0.50 935,055.73 8,946.93 99.00 1,091
15,360 0.75 935,055.73 8,842.99 99.00 1,043
20,480 1.00 935,055.73 5.28 100.00 998
24,576 1.20 935,055.73 5.28 100.00 959
28,672 1.40 935,055.73 5.28 100.00 903
32,768 1.60 935,055.73 5.28 100.00 814
36,864 1.80 935,055.73 5.28 100.00 534
40,960 2.00 935,055.73 0.00 100.00 161
61,440 3.00 935,055.73 0.00 100.00 0
81,920 4.00 935,055.73 0.00 100.00 0
122,880 6.00 935,055.73 0.00 100.00 0
163,840 8.00 935,055.73 0.00 100.00 0

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

Shared Pool Size(M) SP Size Factr Est LC Size (M) Est LC Mem Obj Est LC Time Saved (s) Est LC Time Saved Factr Est LC Load Time (s) Est LC Load Time Factr Est LC Mem Obj Hits
1,008 0.37 311 13,697 2,763,409 1.00 3,440 3.13 216,600,230
1,296 0.47 583 17,024 2,764,879 1.00 1,970 1.79 216,719,209
1,584 0.58 872 20,921 2,765,588 1.00 1,261 1.15 216,776,989
1,872 0.68 1,159 25,571 2,765,733 1.00 1,116 1.01 216,789,343
2,160 0.79 1,424 32,116 2,765,749 1.00 1,100 1.00 216,790,880
2,448 0.89 1,569 36,819 2,765,749 1.00 1,100 1.00 216,791,005
2,736 1.00 1,576 37,449 2,765,749 1.00 1,100 1.00 216,791,013
3,024 1.11 1,576 37,449 2,765,749 1.00 1,100 1.00 216,791,013
3,312 1.21 1,576 37,449 2,765,749 1.00 1,100 1.00 216,791,013
3,600 1.32 1,576 37,449 2,765,749 1.00 1,100 1.00 216,791,013
3,888 1.42 1,576 37,449 2,765,749 1.00 1,100 1.00 216,791,013
4,176 1.53 1,576 37,449 2,765,749 1.00 1,100 1.00 216,791,013
4,464 1.63 1,576 37,449 2,765,749 1.00 1,100 1.00 216,791,013
4,752 1.74 1,576 37,449 2,765,749 1.00 1,100 1.00 216,791,013
5,040 1.84 1,576 37,449 2,765,749 1.00 1,100 1.00 216,791,013
5,328 1.95 1,576 37,449 2,765,749 1.00 1,100 1.00 216,791,013
5,616 2.05 1,576 37,449 2,765,749 1.00 1,100 1.00 216,791,013

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M) SGA Size Factor Est DB Time (s) Est Physical Reads
5,120 0.25 28,902  
10,240 0.50 28,902  
15,360 0.75 28,903  
20,480 1.00 28,902  
25,600 1.25 28,903  
30,720 1.50 28,903  
35,840 1.75 28,903  
40,960 2.00 28,907  

Back to Advisory Statistics
Back to Top

 

Streams Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Java Pool Advisory

Java Pool Size(M) JP Size Factr Est LC Size (M) Est LC Mem Obj Est LC Time Saved (s) Est LC Time Saved Factr Est LC Load Time (s) Est LC Load Time Factr Est LC Mem Obj Hits
16 0.25 13 352 123 1.00 1,101 1.00 12,467
32 0.50 13 352 123 1.00 1,101 1.00 12,467
48 0.75 13 352 123 1.00 1,101 1.00 12,467
64 1.00 13 352 123 1.00 1,101 1.00 12,467
80 1.25 13 352 123 1.00 1,101 1.00 12,467
96 1.50 13 352 123 1.00 1,101 1.00 12,467
112 1.75 13 352 123 1.00 1,101 1.00 12,467
128 2.00 13 352 123 1.00 1,101 1.00 12,467

Back to Advisory Statistics
Back to Top

 

Wait Statistics

Back to Top

Buffer Wait Statistics

Class Waits Total Wait Time (s) Avg Time (ms)
data block 423,586 87 0
undo block 201,858 6 0
undo header 48,932 2 0
segment header 2,579 0 0
1st level bmb 4,657 0 0
2nd level bmb 1,081 0 0
file header block 53 0 1
extent map 23 0 0

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason) Requests Succ Gets Failed Gets Waits Wt Time (s) Av Wt Time(ms)
UL-User-defined 69,265 68,267 998 2,065 51 24.58
TX-Transaction (row lock contention) 4,603 661 3,942 638 38 59.11
TX-Transaction (index contention) 26,798 26,798 0 24,087 22 0.93
RO-Multiple Object Reuse (fast object reuse) 288 288 0 31 6 197.42
TM-DML 2,172,938 2,172,878 1 5 6 1,102.00
HW-Segment High Water Mark 279,706 279,704 2 2,236 1 0.65
TX-Transaction 1,340,273 1,340,278 0 1,927 1 0.47
SQ-Sequence Cache 43,524 43,524 0 3,168 1 0.18
DV-Diana Versioning 32,512 32,512 0 87 0 3.56
TX-Transaction (allocate ITL entry) 166 166 0 80 0 1.25
FB-Format Block 36,729 36,729 0 466 0 0.17
CU-Cursor 9,250 9,250 0 1 0 40.00
PS-PX Process Reservation 1,864 1,544 320 41 0 0.00

Back to Wait Statistics
Back to Top

 

Undo Statistics

Back to Top

Undo Segment Summary

Undo TS# Num Undo Blocks (K) Number of Transactions Max Qry Len (s) Max Tx Concurcy Min/Max TR (mins) STO/ OOS uS/uR/uU/ eS/eR/eU
1 1,625.44 1,342,210 2,671 383 203.25/459.333333333333333333333333333333333333 0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

End Time Num Undo Blocks Number of Transactions Max Qry Len (s) Max Tx Concy Tun Ret (mins) STO/ OOS uS/uR/uU/ eS/eR/eU
17-Apr 12:57 228,191 193,673 687 378 208 0/0 0/0/0/0/0/0
17-Apr 12:47 58,893 130,867 517 371 217 0/0 0/0/0/0/0/0
17-Apr 12:37 334,791 183,636 787 376 203 0/0 0/0/0/0/0/0
17-Apr 12:27 431,446 261,090 2,474 376 233 0/0 0/0/0/0/0/0
17-Apr 12:17 283,219 301,605 2,671 380 326 0/0 0/0/0/0/0/0
17-Apr 12:07 288,902 271,339 1,910 383 459 0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

 

Latch Statistics

Back to Top

Latch Activity

Latch Name Get Requests Pct Get Miss Avg Slps /Miss Wait Time (s) NoWait Requests Pct NoWait Miss
ASM db client latch 2,467 0.00   0 0  
AWR Alerted Metric Element list 341,409 0.00   0 0  
Consistent RBA 867,331 0.06 0.00 0 0  
FOB s.o list latch 55,691 0.01 0.00 0 0  
In memory undo latch 765,217,869 2.13 0.00 11 1,277,785 0.00
JOX SGA heap latch 1,950,641 0.00   0 0  
JS queue state obj latch 21,600 0.00   0 0  
JS slv state obj latch 183 0.00   0 0  
KMG MMAN ready and startup request latch 2,933 0.00   0 0  
KMG resize request state object freelist 26 0.00   0 0  
KTF sga latch 12 0.00   0 1,214 0.00
KWQMN job cache list latch 14,305 0.26 0.97 0 0  
MQL Tracking Latch 0     0 72 0.00
Memory Management Latch 1,943 0.00   0 2,919 0.00
OS process 15,291 0.00   0 0  
OS process allocation 11,425 0.00   0 0  
OS process: request allocation 9,944 0.00   0 0  
PL/SQL warning settings 4,611,217 0.00   0 0  
SGA IO buffer pool latch 44,302 0.16 0.00 0 46,264 0.27
SQL memory manager latch 1 0.00   0 1,199 0.00
SQL memory manager workarea list latch 7,215,802 0.01 0.02 0 0  
Shared B-Tree 129 0.00   0 0  
active checkpoint queue latch 1,235,802 0.25 0.00 0 2 0.00
active service list 48,779 0.07 0.00 0 1,283 0.00
begin backup scn array 132 0.00   0 0  
buffer pool 24 0.00   0 0  
cache buffer handles 20,638,224 1.08 0.00 0 0  
cache buffers chains 4,913,922,471 0.94 0.03 48 18,842,899 2.44
cache buffers lru chain 10,280,773 0.34 0.06 2 37,671,358 0.49
cache table scan latch 2,140 0.00   0 2,140 0.00
channel handle pool latch 414,910 0.07 0.01 0 0  
channel operations parent latch 1,803,660 0.38 0.00 0 0  
checkpoint queue latch 18,114,050 0.01 0.01 0 3,136,297 0.02
client/application info 1,794,736 0.00 0.00 0 0  
commit callback allocation 88,527 0.00 0.00 0 0  
compile environment latch 3,148,866 0.00   0 0  
dictionary lookup 78 0.00   0 0  
dml lock allocation 4,329,281 0.17 0.02 0 0  
dummy allocation 20,362 0.17 0.00 0 0  
enqueue hash chains 9,434,455 0.06 0.00 0 332 0.00
enqueues 5,405,131 0.10 0.01 0 0  
error message lists 816 0.61 0.00 0 0  
event group latch 4,987 0.00   0 0  
file cache latch 21,833 0.00   0 0  
global KZLD latch for mem in SGA 9,677 0.00   0 0  
global ctx hash table latch 24,480 0.00   0 0  
hash table column usage latch 2,096 0.00   0 15,504,761 0.00
hash table modification latch 144 0.00   0 0  
internal temp table object number allocation latc 6 0.00   0 0  
job workq parent latch 0     0 122 0.00
job_queue_processes parameter latch 120 0.00   0 0  
kks stats 30,479 0.00 0.00 0 0  
ksuosstats global area 243 0.00   0 0  
ktm global data 161,229 0.00   0 0  
kwqbsn:qsga 129 0.00   0 0  
lgwr LWN SCN 869,788 0.10 0.00 0 0  
library cache 355,876,330 0.38 0.01 8 20,550 0.64
library cache load lock 9,934 0.33 0.21 0 9 0.00
library cache lock 59,967,040 0.05 0.01 0 0  
library cache lock allocation 1,552,304 0.01 0.06 0 0  
library cache pin 221,776,325 0.12 0.01 2 37 0.00
library cache pin allocation 537,372 0.00 0.00 0 0  
list of block allocation 464,670 0.01 0.00 0 0  
loader state object freelist 322,436 0.00 0.00 0 0  
longop free list parent 33 0.00   0 33 0.00
message pool operations parent latch 421,548 0.00 0.10 0 0  
messages 5,967,860 0.24 0.01 0 0  
mostly latch-free SCN 917,153 3.93 0.00 0 0  
multiblock read objects 27,594 0.00   0 0  
ncodef allocation latch 194 0.00   0 0  
object queue header heap 3,540,912 0.03 0.27 0 405,082 0.07
object queue header operation 36,146,485 0.13 0.44 3 23,441 0.22
object stats modification 412,495 0.02 0.04 0 0  
parallel query alloc buffer 8,160 0.86 0.00 0 0  
parallel query stats 528 13.26 0.00 0 0  
parameter table allocation management 24,265 0.94 0.52 0 0  
post/wait queue 1,373,032 0.03 0.02 0 556,536 0.01
process allocation 9,992 0.19 0.89 0 4,985 0.04
process group creation 9,944 0.00   0 0  
process queue 5,030 0.85 0.00 0 0  
process queue reference 779,761 0.05 0.00 0 82,933 0.42
qmn task queue latch 516 0.00   0 0  
query server freelists 4,256 4.72 0.00 0 0  
query server process 8 0.00   0 8 0.00
redo allocation 5,615,385 1.61 0.01 1 103,692,058 1.65
redo copy 0     0 103,829,230 0.05
redo writing 4,263,453 0.11 0.01 0 0  
resmgr group change latch 858,859 0.00   0 0  
resmgr:actses active list 30,010 0.52 0.97 0 0  
resmgr:actses change group 29,421 0.00   0 0  
resmgr:free threads list 20,360 0.19 0.00 0 0  
resmgr:schema config 1 0.00   0 0  
row cache objects 128,457,557 0.19 0.00 1 6,456 0.03
rules engine aggregate statistics 41,600 0.00   0 0  
rules engine rule set statistics 133,701 0.00 0.00 0 0  
rules engine rule statistics 50,501 0.00   0 0  
sequence cache 16,485,480 0.41 0.00 0 0  
session allocation 19,913,315 0.42 0.01 0 0  
session idle bit 102,587,067 0.01 0.02 0 0  
session state list latch 59,022 0.08 0.73 0 0  
session switching 15,241 0.00   0 0  
session timer 1,283 0.00   0 0  
shared pool 7,623,028 0.14 0.06 0 0  
shared pool sim alloc 394 0.00   0 0  
shared pool simulator 2,164,306 0.00 0.05 0 0  
sim partition latch 1 0.00   0 22,698 0.13
simulator hash latch 2,460 0.00   0 0  
simulator lru latch 1,656 0.00   0 0  
slave class 1 0.00   0 0  
slave class create 4 0.00   0 0  
sort extent pool 1,429,751 0.09 0.01 0 0  
state object free list 12 0.00   0 0  
statistics aggregation 84 0.00   0 0  
temp lob duration state obj allocation 263 0.00   0 0  
temporary table state object allocation 12,657 0.00   0 0  
threshold alerts latch 606 0.00   0 0  
trace latch 49 0.00   0 0  
transaction allocation 117,227 0.00 0.00 0 0  
transaction branch allocation 194 0.00   0 0  
undo global data 1,001,259,160 0.62 0.00 4 10,997 0.06
user lock 38,782 0.01 0.00 0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch Name Get Requests Misses Sleeps Spin Gets Sleep1 Sleep2 Sleep3
cache buffers chains 4,913,922,471 46,338,541 1,300,031 45,210,092 0 0 0
In memory undo latch 765,217,869 16,261,997 35,100 16,231,970 0 0 0
undo global data 1,001,259,160 6,252,025 9,378 6,243,970 0 0 0
library cache 355,876,330 1,350,981 11,559 1,340,572 0 0 0
library cache pin 221,776,325 268,758 3,051 266,020 0 0 0
row cache objects 128,457,557 247,368 1,064 246,363 0 0 0
cache buffer handles 20,638,224 223,399 243 223,179 0 0 0
redo allocation 5,615,385 90,642 1,071 89,676 0 0 0
session allocation 19,913,315 83,169 875 82,359 0 0 0
sequence cache 16,485,480 67,761 89 67,686 0 0 0
object queue header operation 36,146,485 48,249 21,468 28,607 0 0 0
mostly latch-free SCN 917,153 36,086 51 36,040 0 0 0
cache buffers lru chain 10,280,773 34,612 2,121 32,602 0 0 0
library cache lock 59,967,040 31,293 193 31,111 0 0 0
messages 5,967,860 14,168 143 14,026 0 0 0
session idle bit 102,587,067 14,106 233 13,878 0 0 0
shared pool 7,623,028 10,670 597 10,130 0 0 0
dml lock allocation 4,329,281 7,439 122 7,327 0 0 0
channel operations parent latch 1,803,660 6,898 19 6,881 0 0 0
enqueues 5,405,131 5,639 61 5,581 0 0 0
enqueue hash chains 9,434,455 5,433 20 5,413 0 0 0
redo writing 4,263,453 4,570 25 4,545 0 0 0
active checkpoint queue latch 1,235,802 3,150 12 3,138 0 0 0
checkpoint queue latch 18,114,050 2,341 34 2,311 0 0 0
sort extent pool 1,429,751 1,276 15 1,261 0 0 0
object queue header heap 3,540,912 1,080 291 817 0 0 0
post/wait queue 1,373,032 452 8 444 0 0 0
process queue reference 779,761 398 1 397 0 0 0
SQL memory manager workarea list latch 7,215,802 375 8 368 0 0 0
channel handle pool latch 414,910 297 3 294 0 0 0
parameter table allocation management 24,265 227 118 121 0 0 0
resmgr:actses active list 30,010 155 150 7 0 0 0
library cache lock allocation 1,552,304 104 6 100 0 0 0
object stats modification 412,495 81 3 79 0 0 0
session state list latch 59,022 49 36 13 0 0 0
shared pool simulator 2,164,306 41 2 39 0 0 0
KWQMN job cache list latch 14,305 37 36 2 0 0 0
library cache load lock 9,934 33 7 26 0 0 0
message pool operations parent latch 421,548 21 2 20 0 0 0
process allocation 9,992 19 17 2 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch Name Where NoWait Misses Sleeps Waiter Sleeps
In memory undo latch kturbk 0 25,871 28,457
In memory undo latch ktiFlush: child 0 4,863 2,916
In memory undo latch kticmt: child 0 3,624 918
In memory undo latch ktichg: child 0 467 2,726
In memory undo latch ktiTxnPoolFree 0 253 0
In memory undo latch ktiBRacquire 0 16 0
In memory undo latch ktbgfc 0 3 80
KWQMN job cache list latch kwqmnuji: update job item 0 37 8
SQL memory manager workarea list latch qesmmIUnRegisterWorkArea 0 5 3
SQL memory manager workarea list latch qesmmIRegisterWorkArea 0 3 5
active checkpoint queue latch kcbbacq: scan active checkpoints 0 12 12
cache buffer handles kcbzgs 0 151 154
cache buffer handles kcbzfs 0 92 90
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 1,443,988 1,681,350
cache buffers chains kcbgtcr: fast path 0 634,962 28,273
cache buffers chains kcbchg: kslbegin: call CR func 0 531,812 1,097,279
cache buffers chains kcbzgb: scan from tail. nowait 0 132,543 0
cache buffers chains kcbgtcr: kslbegin excl 0 121,009 38,575
cache buffers chains kcbgcur: kslbegin 0 26,230 13,571
cache buffers chains kcbrls: kslbegin 0 21,738 55,089
cache buffers chains kcbget: pin buffer 0 18,019 7,875
cache buffers chains kcbzwb 0 5,779 5,492
cache buffers chains kcbcge 0 3,579 6,096
cache buffers chains kcbget: exchange rls 0 657 669
cache buffers chains kcbnlc 0 358 1,467
cache buffers chains kcbget: exchange 0 345 1,381
cache buffers chains kcbbxsv 0 207 194
cache buffers chains kcb_is_private 0 196 2,144
cache buffers chains kcbgtcr: kslbegin shared 0 103 84
cache buffers chains kcb_pre_apply: kcbhq61 0 62 1,713
cache buffers chains kcbnew: new latch again 0 51 9
cache buffers chains kcbesc: escalate 0 49 23
cache buffers chains kcb_post_apply: kcbhq63 0 38 255
cache buffers chains kcbso1: set no access 0 23 37
cache buffers chains kcbgtcr 0 7 0
cache buffers chains kcbbic2 0 5 8
cache buffers chains kcb_post_apply: kcbhq62 0 3 344
cache buffers chains kcbo_ivd_process 0 2 36
cache buffers chains kcbzhngcbk1: get hash chain latch no wait 0 1 0
cache buffers chains kcbzib: multi-block read: nowait 0 1 0
cache buffers lru chain kcbzgws 0 1,237 0
cache buffers lru chain kcbbxsv: move to being written 0 274 711
cache buffers lru chain kcbgtcr:CR Scan:KCBRSKIP 0 226 0
cache buffers lru chain kcbo_link_q 0 167 32
cache buffers lru chain kcbzgb: posted for free bufs 0 92 563
cache buffers lru chain kcbo_ivd_proc 0 45 365
cache buffers lru chain kcbzswcu 0 40 76
cache buffers lru chain kcbbic2 0 24 315
cache buffers lru chain kcbzib 0 6 3
cache buffers lru chain kcbzgpwb: KSLBEGIN use prewarm buffers 0 4 72
cache buffers lru chain kcbo_write_process:free_unlink 0 2 0
cache buffers lru chain kcbzgm 0 2 0
cache buffers lru chain kcbbwlru 0 1 43
cache buffers lru chain kcbzfw 0 1 0
channel handle pool latch ksrchconnect() 0 9 4
channel operations parent latch ksrapublish() 0 10 3
channel operations parent latch ksrchdelete() 0 8 2
channel operations parent latch ksrmfree() 0 4 0
channel operations parent latch ksrsconsume() 0 4 2
channel operations parent latch ksrwait() 0 3 27
channel operations parent latch ksrchconnect() 0 1 9
checkpoint queue latch kcbbwthc: thread checkpoint buffers 0 22 7
checkpoint queue latch kcbkubc 0 6 15
checkpoint queue latch kcbklbc: Link buffer into ckpt queue 0 4 4
checkpoint queue latch kcbswcu: Switch buffers 0 2 8
dml lock allocation ktaiam 0 88 82
dml lock allocation ktaidm 0 34 40
enqueue hash chains ksqgtl3 0 12 12
enqueue hash chains ksqrcl 0 7 7
enqueue hash chains ksqcmi: get hash chain latch after wait 0 1 1
enqueues ksqgel: create enqueue 0 31 13
enqueues ksqdel 0 15 6
enqueues ksqies 0 15 42
lgwr LWN SCN kcs023 0 14 0
library cache kglpndl: child: after processing 0 4,595 155
library cache kglpnp: child 0 4,158 5,781
library cache kglobpn: child: 0 924 1,691
library cache kglpndl: child: before processing 0 680 3,038
library cache kglLockCursor 0 284 419
library cache kglScanDependency 0 216 0
library cache kglpin 0 120 55
library cache kgldte: child 0 0 105 177
library cache kglhdgn: child: 0 97 192
library cache kgldti: 2child 0 23 6
library cache kglic 0 16 0
library cache kglrtl 0 8 0
library cache kglivl: child 0 7 0
library cache kglhdiv: child 0 4 0
library cache kgldtld: 2child 0 3 0
library cache kglupd: child 0 3 0
library cache kglobld 0 2 1
library cache kglget: unpin heap 0 0 1 4
library cache kglukp: child 0 1 0
library cache load lock kglllal: llatch: in loop 0 6 7
library cache load lock kglllal: llatch 0 1 0
library cache lock kgllkdl: child: cleanup 0 126 113
library cache lock kgllkdl: child: no lock handle 0 80 29
library cache lock kgllkal: child: multiinstance 0 67 80
library cache lock allocation kgllkget 0 6 6
library cache pin kglpndl 0 1,423 935
library cache pin kglpnp: child 0 1,402 1,643
library cache pin kglpnal: child: alloc space 0 226 473
message pool operations parent latch ksrmalloc() 0 2 0
messages ksarcv 0 68 5
messages ksarcv: after wait 0 54 98
messages ksaamb: after wakeup 0 21 40
mostly latch-free SCN kcslcu3 0 37 51
object queue header heap kcbo_link_q:reget 0 283 6
object queue header heap kcbw_link_q:alloc 0 8 292
object queue header operation kcbo_ivbo 0 21,118 4,742
object queue header operation kcbw_link_q 0 4,074 2,424
object queue header operation kcbw_unlink_q 0 1,388 7,394
object queue header operation kcbo_switch_mq_bg 0 459 3,180
object queue header operation kcbo_switch_q_bg 0 319 1,704
object queue header operation kcbo_switch_cq 0 123 3,214
object queue header operation kcbo_link_q:reget 0 102 136
object queue header operation kcbo_write_q 0 25 15
object queue header operation kcbo_swap_buf_bg 0 18 4,490
object queue header operation kcbo_service_ockpt 0 13 2
object queue header operation kcbo_swap_buf 0 10 595
object stats modification ksoslinelm 0 3 1
parameter table allocation management ksp_param_table_free 0 118 118
post/wait queue ksliwat:remove 0 8 7
process allocation ksucrp 0 16 0
process allocation ksudlp 0 1 10
process queue reference kxfpqrsnd 0 1 0
redo allocation kcrfw_redo_gen: redo allocation 1 0 858 0
redo allocation kcrfw_redo_gen: redo allocation 3 0 139 662
redo allocation kcrfw_redo_gen: redo allocation 2 0 43 0
redo allocation kcrfw_redo_write: before write 0 20 196
redo allocation kcrfw_redo_write: more space 0 11 255
redo writing kcrfwcr 0 15 24
redo writing kcrfw_post: rba scn pair 0 7 0
redo writing kcrfw_post: after write 0 2 0
redo writing kcrfw_cal_target_rba 0 1 1
resmgr:actses active list kgskchclass 0 150 75
row cache objects kqreqd: reget 0 799 7
row cache objects kqrpre: find obj 0 197 874
row cache objects kqreqd 0 63 182
row cache objects kqrso 0 5 0
sequence cache kdnssd 0 64 5
sequence cache kdnnxt: cached seq 0 20 1
sequence cache kdnss 0 5 85
session allocation ksuxds: KSUSFCLC not set 0 270 31
session allocation ksuprc 0 217 169
session allocation ksudlc 0 118 201
session allocation ksucri 0 105 267
session allocation ksuxds: not user session 0 90 138
session allocation kspallmod 0 25 0
session allocation ksudlp 0 17 0
session allocation kxfpqidqr 0 15 26
session allocation ksursi 0 14 34
session allocation kxfprdp 0 4 8
session idle bit ksupuc: set busy 0 171 132
session idle bit ksupuc: clear busy 0 95 134
session idle bit ksuxds 0 9 9
session state list latch kpseqd 0 36 0
shared pool kghupr1 0 292 424
shared pool kghalo 0 231 105
shared pool kghfrunp: clatch: nowait 0 220 0
shared pool kghfre 0 32 62
shared pool kghfrunp: alloc: wait 0 27 0
shared pool kghfrunp: clatch: wait 0 12 11
shared pool kghalp 0 8 6
shared pool kghfrunp: alloc: session dur 0 6 0
shared pool kgh: sim resz update 0 1 0
shared pool simulator kglsim_unpin_simhp 0 2 2
sort extent pool ktstdt: dealloc sort extent 0 9 2
sort extent pool ktstallobj1 0 2 1
sort extent pool ktstdt: return extent 0 2 1
sort extent pool ktstaddextent1 0 1 0
sort extent pool ktstcrtobj 0 1 0
undo global data kturimugur: child 0 8,035 5,241
undo global data ktudba: KSLBEGIN 0 1,263 4,093
undo global data ktudnx:child 0 21 12
undo global data ktucof: at start 0 19 0
undo global data ktufrbs: child 0 17 27
undo global data ktusmasp: ktugd_tuux 0 13 4
undo global data ktubnd:child 0 10 2

Back to Latch Statistics
Back to Top

 

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

 

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

 

Segment Statistics

Back to Top

Segments by Logical Reads

Owner Tablespace Name Object Name Subobject Name Obj. Type Logical Reads %Total
AR APPS_TS_TX_INTERFACE RA_INTERFACE_LINES_ALL   TABLE 62,587,120 3.00
INV APPS_TS_TX_IDX MTL_ITEM_CATEGORIES_U1   INDEX 50,802,400 2.44
ICX APPS_TS_TX_DATA ICX_SESSION_ATTRIBUTES   TABLE 24,944,176 1.20
ONT APPS_TS_TX_DATA OE_ORDER_LINES_ALL   TABLE 23,139,648 1.11
WSH APPS_TS_TX_DATA WSH_DELIVERY_DETAILS   TABLE 20,371,936 0.98

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Owner Tablespace Name Object Name Subobject Name Obj. Type Physical Reads %Total
GL APPS_ASSM_DATA GL_JE_LINES   TABLE 35,022 7.61
AR APPS_ASSM_DATA RA_CUSTOMER_TRX_LINES_ALL   TABLE 13,097 2.85
WSH APPS_TS_TX_DATA WSH_DELIVERY_DETAILS   TABLE 9,554 2.08
HR APPS_TS_TX_IDX PAY_PERSON_LATEST_BALA_N50   INDEX 4,777 1.04
HR APPS_ASSM_DATA PAY_RUN_RESULTS   TABLE 4,047 0.88

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

Owner Tablespace Name Object Name Subobject Name Obj. Type Row Lock Waits % of Capture
APPLSYS APPS_TS_TX_IDX WF_ITEM_ACTIVITY_STATUSES_N1   INDEX 11,272 29.04
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_U1   INDEX 9,393 24.20
WSH APPS_TS_TX_DATA WSH_TRIP_STOPS   TABLE 7,308 18.83
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N6   INDEX 2,509 6.46
HR APPS_ASSM_IDX PAY_RUN_RESULT_VALUES_PK   INDEX 1,685 4.34

Back to Segment Statistics
Back to Top

Segments by ITL Waits

Owner Tablespace Name Object Name Subobject Name Obj. Type ITL Waits % of Capture
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N6   INDEX 21 38.89
APPLSYS APPS_TS_TX_IDX WF_ITEM_ATTRIBUTE_VALUES_PK   INDEX 11 20.37
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N1   INDEX 7 12.96
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N5   INDEX 4 7.41
GL APPS_ASSM_IDX GL_INTERFACE_N4   INDEX 2 3.70

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

Owner Tablespace Name Object Name Subobject Name Obj. Type Buffer Busy Waits % of Capture
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_U1   INDEX 129,642 36.61
APPLSYS APPS_TS_TX_DATA WF_ITEM_ATTRIBUTE_VALUES   TABLE 63,295 17.87
SYS SYSTEM DBMS_LOCK_ALLOCATED   TABLE 19,834 5.60
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N6   INDEX 15,925 4.50
APPLSYS APPS_TS_TX_DATA WF_ITEM_ACTIVITY_STATUSES WF_ITEM49 TABLE PARTITION 15,468 4.37

Back to Segment Statistics
Back to Top

 

Dictionary Cache Stats

Cache Get Requests Pct Miss Scan Reqs Pct Miss Mod Reqs Final Usage
dc_awr_control 5 20.00 0   2 1
dc_constraints 648 47.07 0   648 0
dc_files 6,660 0.00 0   0 111
dc_global_oids 7,847,339 0.00 0   0 45
dc_histogram_data 67,079 1.53 0   0 753
dc_histogram_defs 419,387 2.79 0   4,044 3,004
dc_object_grants 72,596 0.05 0   0 81
dc_object_ids 12,653,917 0.01 0   58 1,169
dc_objects 181,772 0.97 0   347 858
dc_profiles 9,738 0.00 0   0 1
dc_rollback_segments 20,441 0.00 0   0 387
dc_segments 368,333 0.64 0   16,029 1,343
dc_sequences 53,633 0.12 0   53,633 116
dc_table_scns 20,659 0.04 0   0 5
dc_tablespace_quotas 15,890 0.13 0   211 44
dc_tablespaces 6,047,449 0.00 0   0 21
dc_usernames 515,177 0.00 0   0 17
dc_users 15,131,258 0.00 0   0 63
outstanding_alerts 268 16.42 0   1 42


Back to Top

 

Library Cache Activity

Namespace Get Requests Pct Miss Pin Requests Pct Miss Reloads Invali- dations
BODY 640,165 0.02 42,588,321 0.00 22 0
CLUSTER 95 1.05 237 0.42 0 0
INDEX 15,831 0.40 16,643 0.56 0 0
JAVA DATA 626 0.00 0   0 0
PIPE 50,616 2.54 74,697 1.72 0 0
SQL AREA 6,591 87.33 114,731,568 0.41 3,925 439
TABLE/PROCEDURE 411,081 0.24 57,954,697 0.01 1,101 0
TRIGGER 29,100 0.09 1,408,392 0.00 23 0


Back to Top

 

Memory Statistics

Back to Top

Process Memory Summary

  Category Alloc (MB) Used (MB) Avg Alloc (MB) Std Dev Alloc (MB) Max Alloc (MB) Hist Max Alloc (MB) Num Proc Num Alloc
B Other 37,728.71   12.14 7.06 38 38 3,108 3,108
  Freeable 3,707.00 0.00 1.35 0.82 9   2,753 2,753
  SQL 3,501.06 1,795.71 1.13 0.70 4 21 3,100 3,099
  PL/SQL 2,413.27 192.63 0.78 0.96 3 3 3,108 3,108
  JAVA 270.09 268.79 2.25 0.32 5 8 120 120
E Other 44,269.67   14.10 8.60 41 41 3,139 3,139
  Freeable 4,330.25 0.00 1.53 0.94 9   2,825 2,825
  SQL 4,018.98 2,102.38 1.28 0.76 5 21 3,131 3,130
  PL/SQL 2,797.85 217.74 0.89 0.99 3 3 3,139 3,139
  JAVA 270.03 268.76 2.25 0.32 5 8 120 120

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions Begin Size (Bytes) End Size (Bytes) (if different)
Database Buffers 18,706,595,840 18,505,269,248
Fixed Size 2,111,120  
Redo Buffers 14,663,680  
Variable Size 2,751,465,840 2,952,792,432

Back to Memory Statistics
Back to Top

SGA breakdown difference

Pool Name Begin MB End MB % Diff
java free memory 51.29 51.29 0.00
java joxlod exec hp 12.09 12.09 0.00
large free memory 15.94 15.94 0.00
shared ASH buffers 29.00 29.00 0.00
shared CCursor 35.61 36.35 2.06
shared KTI-UNDO 53.19 53.19 0.00
shared PL/SQL MPCODE 66.56 69.75 4.78
shared db_block_hash_buckets 180.00 180.00 0.00
shared event statistics per sess 63.28 63.28 0.00
shared free memory 338.86 359.73 6.16
shared library cache 857.22 1,013.12 18.19
shared parameter table block 57.88 58.15 0.47
shared private strands 99.77 99.77 0.00
shared sessions 36.42 36.42 0.00
shared sql area 361.23 378.96 4.91
shared trace buffer 48.58 49.34 1.58
  buffer_cache 17,840.00 17,648.00 -1.08
  fixed_sga 2.01 2.01 0.00
  log_buffer 13.98 13.98 0.00

Back to Memory Statistics
Back to Top

 

Streams Statistics

Back to Top

 

Streams CPU/IO Usage

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

Rule Set

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

Resource Limit Stats

Resource Name Current Utilization Maximum Utilization Initial Allocation Limit
processes 3,140 3,159 3600 3600


Back to Top

 

init.ora Parameters

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


Back to Top

End of Report