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 06-May-09 05:37:49 4768 211.4
End Snap: 2 06-May-09 06:37:54 4783 234.1
Elapsed:   60.08 (mins)    
DB Time:   415.31 (mins)    

 

Report Summary

Cache Sizes

  Begin End    
Buffer Cache: 17,984M 17,824M Std Block Size: 8K
Shared Pool Size: 2,400M 2,560M Log Buffer: 14,320K

Load Profile

  Per Second Per Transaction
Redo size: 8,752,977.49 27,282.24
Logical reads: 561,879.43 1,751.33
Block changes: 54,468.54 169.77
Physical reads: 121.84 0.38
Physical writes: 852.12 2.66
User calls: 12,467.11 38.86
Parses: 2,360.62 7.36
Hard parses: 2.46 0.01
Sorts: 2,867.43 8.94
Logons: 2.58 0.01
Executes: 27,142.69 84.60
Transactions: 320.83  

% Blocks changed per Read: 9.69 Recursive Call %: 77.91
Rollback per transaction %: 20.62 Rows per Sort: 12.39

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.77 Soft Parse %: 99.90
Execute to Parse %: 91.30 Latch Hit %: 99.05
Parse CPU to Parse Elapsd %: 92.53 % Non-Parse CPU: 97.79

Shared Pool Statistics

  Begin End
Memory Usage %: 86.49 86.54
% SQL with executions>1: 90.40 90.92
% Memory for SQL w/exec>1: 70.62 70.89

Top 5 Timed Events

Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class
CPU time   19,651   78.9  
SQL*Net more data from client 2,333,168 5,578 2 22.4 Network
db file sequential read 278,108 932 3 3.7 User I/O
log file sync 494,534 698 1 2.8 Commit
log file parallel write 813,691 337 0 1.4 System I/O

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic Name Time (s) % of DB Time
DB CPU 19,650.53 78.86
sql execute elapsed time 19,005.47 76.27
PL/SQL execution elapsed time 7,062.42 28.34
inbound PL/SQL rpc elapsed time 6,847.17 27.48
parse time elapsed 533.56 2.14
Java execution elapsed time 498.39 2.00
hard parse elapsed time 282.76 1.13
repeated bind elapsed time 74.55 0.30
sequence load elapsed time 13.42 0.05
connection management call elapsed time 9.63 0.04
PL/SQL compilation elapsed time 6.27 0.03
hard parse (sharing criteria) elapsed time 3.62 0.01
failed parse elapsed time 1.43 0.01
hard parse (bind mismatch) elapsed time 1.18 0.00
DB time 24,918.49  
background elapsed time 1,002.45  
background cpu time 352.99  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait Class Waits %Time -outs Total Wait Time (s) Avg wait (ms) Waits /txn
Network 51,318,007 0.00 5,618 0 44.37
User I/O 329,343 0.00 1,050 3 0.28
Commit 494,534 0.00 698 1 0.43
System I/O 1,130,959 0.00 497 0 0.98
Application 63,077 0.06 177 3 0.05
Concurrency 1,926,552 0.19 126 0 1.67
Other 136,814 21.98 37 0 0.12
Configuration 6,932 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
SQL*Net more data from client 2,333,168 0.00 5,578 2 2.02
db file sequential read 278,108 0.00 932 3 0.24
log file sync 494,534 0.00 698 1 0.43
log file parallel write 813,691 0.00 337 0 0.70
db file parallel write 286,365 0.00 154 1 0.25
enq: TX - row lock contention 659 5.92 137 207 0.00
db file scattered read 11,990 0.00 58 5 0.01
read by other session 36,446 0.00 58 2 0.03
cursor: pin S wait on X 4,110 90.61 41 10 0.00
latch: cache buffers chains 1,201,589 0.00 29 0 1.04
SQL*Net message to client 47,083,483 0.00 23 0 40.71
enq: UL - contention 1,450 0.00 19 13 0.00
SQL*Net more data to client 1,901,356 0.00 18 0 1.64
buffer busy waits 651,468 0.00 18 0 0.56
library cache load lock 650 0.00 11 18 0.00
SQL*Net break/reset to client 60,930 0.00 11 0 0.05
enq: TX - index contention 26,204 0.00 11 0 0.02
PX Deq Credit: send blkd 23,600 0.00 9 0 0.02
rdbms ipc reply 6 50.00 7 1148 0.00
latch: In memory undo latch 24,440 0.00 6 0 0.02
enq: RO - fast object reuse 32 0.00 6 184 0.00
control file sequential read 29,164 0.00 5 0 0.03
latch: library cache 9,054 0.00 5 1 0.01
latch: undo global data 8,164 0.00 5 1 0.01
enq: TM - contention 6 0.00 4 634 0.00
PX Deq: Signal ACK 255 36.08 3 12 0.00
kksfbc child completion 60 83.33 2 42 0.00
os thread startup 70 0.00 2 31 0.00
latch: object queue header operation 20,566 0.00 2 0 0.02
latch free 2,786 0.00 2 1 0.00
latch: library cache pin 2,530 0.00 1 1 0.00
LGWR wait for redo copy 32,863 0.01 1 0 0.03
enq: HW - contention 2,528 0.00 1 0 0.00
latch: cache buffers lru chain 1,623 0.00 1 1 0.00
local write wait 1,570 0.00 1 1 0.00
log buffer space 136 0.00 1 8 0.00
buffer exterminate 2 50.00 1 489 0.00
control file parallel write 1,739 0.00 1 1 0.00
enq: TX - contention 2,748 0.00 1 0 0.00
enq: DV - contention 185 0.00 1 4 0.00
row cache lock 2,703 0.00 1 0 0.00
latch: redo allocation 1,047 0.00 1 0 0.00
enq: SQ - contention 3,999 0.00 0 0 0.00
library cache pin 2,064 0.00 0 0 0.00
buffer deadlock 27,301 98.78 0 0 0.02
latch: row cache objects 742 0.00 0 1 0.00
wait list latch free 29 0.00 0 11 0.00
latch: session allocation 563 0.00 0 0 0.00
SGA: allocation forcing component growth 24 41.67 0 10 0.00
latch: shared pool 660 0.00 0 0 0.00
direct path read 732 0.00 0 0 0.00
latch: library cache lock 156 0.00 0 1 0.00
latch: messages 231 0.00 0 0 0.00
latch: cache buffer handles 194 0.00 0 0 0.00
cursor: pin S 10,542 0.00 0 0 0.01
enq: FB - contention 678 0.00 0 0 0.00
enq: TX - allocate ITL entry 154 0.00 0 0 0.00
latch: object queue header heap 192 0.00 0 0 0.00
latch: redo writing 108 0.00 0 0 0.00
latch: checkpoint queue latch 39 0.00 0 1 0.00
library cache lock 3 0.00 0 9 0.00
reliable message 35 0.00 0 1 0.00
latch: enqueue hash chains 26 0.00 0 1 0.00
PX qref latch 3,004 97.90 0 0 0.00
cursor: mutex S 97 0.00 0 0 0.00
L1 validation 1 100.00 0 10 0.00
write complete waits 7 0.00 0 1 0.00
enq: PS - contention 49 0.00 0 0 0.00
direct path write 439 0.00 0 0 0.00
direct path write temp 45 0.00 0 0 0.00
cursor: mutex X 12 0.00 0 0 0.00
kkdlgon 1 0.00 0 0 0.00
direct path read temp 13 0.00 0 0 0.00
SQL*Net message from client 47,083,459 0.00 9,289,464 197 40.71
pipe get 26,893 16.74 21,083 784 0.02
Streams AQ: waiting for time management or cleanup tasks 2,790 39.53 3,492 1252 0.00
Streams AQ: qmn slave idle wait 128 0.00 3,473 27135 0.00
Streams AQ: qmn coordinator idle wait 256 50.00 3,473 13568 0.00
PX Idle Wait 1,618 76.14 2,534 1566 0.00
PL/SQL lock timer 217 99.54 2,442 11253 0.00
jobq slave wait 618 99.35 1,808 2925 0.00
PX Deq: Execution Msg 5,148 0.00 39 8 0.00
PX Deq: Execute Reply 2,651 0.00 3 1 0.00
PX Deq Credit: need buffer 4,383 0.00 1 0 0.00
PX Deq: Msg Fragment 4,359 0.00 0 0 0.00
PX Deq: Table Q Normal 5,877 0.00 0 0 0.01
PX Deq: Parse Reply 242 0.00 0 1 0.00
PX Deq: Join ACK 280 0.00 0 0 0.00
class slave wait 1 0.00 0 1 0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

Event Waits %Time -outs Total Wait Time (s) Avg wait (ms) Waits /txn
log file parallel write 813,685 0.00 337 0 0.70
db file parallel write 286,365 0.00 154 1 0.25
events in waitclass Other 41,699 0.00 3 0 0.04
control file sequential read 827 0.00 2 2 0.00
db file scattered read 492 0.00 2 4 0.00
os thread startup 62 0.00 2 31 0.00
control file parallel write 1,739 0.00 1 1 0.00
db file sequential read 227 0.00 1 3 0.00
direct path read 732 0.00 0 0 0.00
latch: cache buffers chains 57 0.00 0 1 0.00
latch: redo writing 108 0.00 0 0 0.00
direct path write 333 0.00 0 0 0.00
log file sync 1 0.00 0 2 0.00
latch: library cache 1 0.00 0 0 0.00
buffer busy waits 9 0.00 0 0 0.00
rdbms ipc message 1,686,824 0.72 37,581 22 1.46
pmon timer 1,361 89.42 3,511 2579 0.00
smon timer 133,293 0.00 3,503 26 0.12
Streams AQ: waiting for time management or cleanup tasks 2,790 39.53 3,492 1252 0.00
Streams AQ: qmn slave idle wait 128 0.00 3,473 27135 0.00
Streams AQ: qmn coordinator idle wait 256 50.00 3,473 13568 0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic Total
BUSY_TIME 2,104,482
IDLE_TIME 3,662,196
IOWAIT_TIME 107,016
NICE_TIME 17,999
SYS_TIME 99,103
USER_TIME 1,916,799
LOAD 3
RSRC_MGR_CPU_WAIT_TIME 0
PHYSICAL_MEMORY_BYTES 53,184,240
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 24,918.50 19,649.90 424,014 2,021,912,369
SYS$BACKGROUND 0.00 0.00 15,097 3,633,137
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 327540 104679 1926418 12416 0 0 51304426 561846
SYS$BACKGROUND 1786 282 129 197 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
725 721 305 2.38 2.91 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
411 11 20,008 0.02 1.65 fw8fr3nddyd26 PYUSLV insert into pay_run_balances(r...
400 373 101,491 0.00 1.60 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
398 8 10,000 0.04 1.60 38kpqs2vdwfh9 PYUSLV update pay_person_latest_balan...
361 360 56,487 0.01 1.45 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
360 358 63,127 0.01 1.44 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
339 337 56,504 0.01 1.36 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...
314 309 1,300 0.24 1.26 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
311 309 56,500 0.01 1.25 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
285 283 337,939 0.00 1.14 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...

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
721 725 305 2.36 2.91 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
373 400 101,491 0.00 1.60 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
360 361 56,487 0.01 1.45 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
358 360 63,127 0.01 1.44 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
337 339 56,504 0.01 1.36 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...
309 311 56,500 0.01 1.25 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
309 314 1,300 0.24 1.26 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
283 285 337,939 0.00 1.14 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
228 229 45,424 0.01 0.92 6ubqcscr1gk1b asnDispContainer.jsp select name, value from icx_s...
209 211 58,106 0.00 0.85 bfbyqwbr4vwms OEXOETEL begin OE_OEOL_SCH.SCHEDULE_LIN...
11 411 20,008 0.00 1.65 fw8fr3nddyd26 PYUSLV insert into pay_run_balances(r...
8 398 10,000 0.00 1.60 38kpqs2vdwfh9 PYUSLV update pay_person_latest_balan...

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
55,996,328 156,472 357.87 2.76 154.56 155.16 5kqw5535fjvw6 ARXTWMAI SELECT NVL(RCTT.ATTRIBUTE10, ...
44,238,706 56,487 783.17 2.18 359.55 361.41 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
43,268,870 305 141,865.15 2.14 721.13 724.68 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
38,913,527 63,127 616.43 1.92 357.51 360.03 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
37,252,817 56,500 659.34 1.84 309.36 311.30 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
31,000,965 171,664 180.59 1.53 173.28 174.96 3b3psftuyks81 INVTTMTX BEGIN INV_TXNSTUB_PUB.postTran...
30,993,222 171,646 180.56 1.53 162.56 164.19 gf1u933c95jb5 INVTTMTX DECLARE l_ret_stat varchar2...
30,235,981 1,515,467 19.95 1.49 110.82 111.61 66tmsr3446uqn ap.oie.server.WebExpensesAM SELECT WIAS.ACTIVITY_STATUS, ...
28,782,722 56,504 509.39 1.42 337.22 339.46 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...
28,583,053 1,300 21,986.96 1.41 309.18 314.33 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
26,402,611 10,000 2,640.26 1.30 81.27 177.95 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
23,415,782 182,637 128.21 1.16 183.68 201.92 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
20,526,741 45,424 451.89 1.01 227.60 228.81 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 10.30 81.27 177.95 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
36,755 2,160 17.02 8.37 13.11 144.27 3dssuqfjsynrk asn.lead.server.LeadUwqAM SELECT count(1) FROM (SELECT *...
31,688 2,160 14.67 7.21 93.02 200.95 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
23,156 19,462 1.19 5.27 146.87 212.12 1q78dwnrrkf6c asn.lead.server.LeadUwqAM BEGIN ASN_SALES_PVT.Lead_Proce...
9,084 6,484 1.40 2.07 104.11 134.61 8jb36w62w5hqf ibuSRDetailsActions.jsp BEGIN IBU_REQ_PKG.UpdateServic...
9,037 182,637 0.05 2.06 183.68 201.92 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
4,779 10,000 0.48 1.09 8.29 398.20 38kpqs2vdwfh9 PYUSLV update pay_person_latest_balan...
4,590 10,000 0.46 1.05 129.84 137.92 csvvv0fmhr1yc PYUSLV BEGIN FFP1893_01010001.FORMULA...
4,508 10,000 0.45 1.03 107.73 113.52 63t8zpm02skgh PYUSLV SELECT DECODE(COUNT(PRR.RUN_RE...
1,488 90,807 0.02 0.34 104.45 106.63 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,515,467 783,564 0.52 0.00 0.00 66tmsr3446uqn ap.oie.server.WebExpensesAM SELECT WIAS.ACTIVITY_STATUS, ...
859,336 859,335 1.00 0.00 0.00 cd9mbmqyf4qhp ap.oie.server.WebExpensesAM UPDATE WF_ITEM_ACTIVITY_STATUS...
537,442 537,430 1.00 0.00 0.00 avc1jqzz04wpr JDBC Thin Client SELECT 'x' FROM DUAL
452,476 452,385 1.00 0.00 0.00 821fx90awyvj7 OEXOETEL SELECT ACCOUNTING_RULE_ID , A...
337,939 337,938 1.00 0.00 0.00 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
315,471 242,454 0.77 0.00 0.00 fmfdkztk8vx23   SELECT CATEGORY, SEVERITY, F...
261,810 4,450,680 17.00 0.00 0.00 cwyx16zn1hpfb JDBC Thin Client select parameter, value from ...
182,637 182,634 1.00 0.00 0.00 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
171,664 171,664 1.00 0.00 0.00 3b3psftuyks81 INVTTMTX BEGIN INV_TXNSTUB_PUB.postTran...
171,663 171,661 1.00 0.00 0.00 6gnth2mfbs2nq INVTTMTX declare v_ret number := 0...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse Calls Executions % Total Parses SQL Id SQL Module SQL Text
537,447 537,442 6.32 avc1jqzz04wpr JDBC Thin Client SELECT 'x' FROM DUAL
337,938 337,939 3.97 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
315,475 315,471 3.71 fmfdkztk8vx23   SELECT CATEGORY, SEVERITY, F...
261,812 261,810 3.08 cwyx16zn1hpfb JDBC Thin Client select parameter, value from ...
182,636 182,637 2.15 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
171,670 171,663 2.02 6gnth2mfbs2nq INVTTMTX declare v_ret number := 0...
122,725 122,722 1.44 fb13x9qx0ftks OEXOETEL begin OE_STANDARD_WF.OEOL_SELE...
115,180 115,176 1.35 1c0b7sas42w2z INVTTMTX SELECT NVL(ITEM_COST, 0), ...
108,307 108,306 1.27 162ttnv4ubqun OEXOETEL begin OE_DS_PVT.Check_PO_Appr...
100,197 100,194 1.18 8camsgjsr9zya OEXOETEL begin OE_TRANSACTION_TYPES_PK...
97,137 97,131 1.14 76sw2a4vnc89j icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.S...
91,747 91,744 1.08 608c0n36kaw62 icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.C...
91,747 91,741 1.08 bf7uwg5pa3pj6 icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.V...
91,747 97,134 1.08 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,361,340 3,901 0.05 gz467g1c3hf9v qotSCopHdrUpd.jsp SELECT /*+ ORDERED USE_NL(QPQ ...

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;
38kpqs2vdwfh9 update pay_person_latest_balances set assignment_action_id=:b1, value=:b2, expired_assignment_action_id=:b3, expired_value=:b4, prev_assignment_action_id=:b5, prev_balance_value=:b6 where rowid=:b7
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 ) )
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;
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;
bfbyqwbr4vwms begin OE_OEOL_SCH.SCHEDULE_LINE (: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;
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
fw8fr3nddyd26 insert into pay_run_balances(run_balance_id, assignment_action_id, assignment_id, action_sequence, defined_balance_id, balance_value, payroll_action_id, effective_date, tax_unit_id, jurisdiction_code, jurisdiction_comp1, jurisdiction_comp2, jurisdiction_comp3, source_id, source_text, tax_group, source_number, source_text2) values (:b1, :b2:b3, :b4:b5, :b6:b7, :b8, :b9, :b10:b11, to_date(:b12, :b13), :b14:b15, :b16:b17, :b18:b19, :b20:b21, :b22:b23, :b24:b25, :b26:b27, :b28:b29, :b30:b31, :b32:b33)
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;
gz467g1c3hf9v SELECT /*+ ORDERED USE_NL(QPQ QPLAT_Q QPLAT_PROD QPA QPL QPH) INDEX(QPQ QP_QUALIFIERS_N1) INDEX(QPLAT_Q qp_preq_line_attrs_tmp_N2) INDEX(QPA QP_PRICING_ATTRIBUTES_N5) l_list_qual_cur */ QPLAT_PROD.LINE_INDEX, QPL.LIST_LINE_ID, QPL.ARITHMETIC_OPERATOR, QPL.OPERAND, QPL.PRICING_GROUP_SEQUENCE, QPL.LIST_LINE_TYPE_CODE, QPL.PRICING_PHASE_ID, QPL.AUTOMATIC_FLAG, QPL.INCOMPATIBILITY_GRP_CODE, QPL.PRICE_BY_FORMULA_ID, QPL.PRODUCT_PRECEDENCE, QPL.PRIMARY_UOM_FLAG, QPL.MODIFIER_LEVEL_CODE, QPL.LIST_LINE_NO, QPA.PRODUCT_UOM_CODE, QPA.EXCLUDER_FLAG, QPH.LIST_TYPE_CODE, QPH.ROUNDING_FACTOR, QPH.LIST_HEADER_ID LIST_HEADER_ID, QPLAT_PROD.CONTEXT PRODUCT_ATTRIBUTE_CONTEXT, QPLAT_PROD.ATTRIBUTE PRODUCT_ATTRIBUTE, QPLAT_PROD.VALUE_FROM PRODUCT_ATTR_VALUE_FROM, QPLAT_PROD.ATTRIBUTE_LEVEL PRODUCT_ATTRIBUTE_LEVEL, QPLAT_PROD.ATTRIBUTE_TYPE PRODUCT_ATTRIBUTE_TYPE, QPLAT_PROD.APPLIED_FLAG, NULL PRICING_ATTRIBUTE_CONTEXT, NULL PRICING_ATTRIBUTE, NULL PRICING_ATTR_VALUE_FROM, NULL PRICING_SETUP_VALUE_FROM, NULL PRICING_SETUP_VALUE_TO, NULL PRICING_ATTRIBUTE_LEVEL, NULL PRICING_ATTRIBUTE_TYPE, NULL PRICING_OPERATOR_TYPE, QPLAT_Q.CONTEXT QUALIFIER_ATTRIBUTE_CONTEXT, QPLAT_Q.ATTRIBUTE QUALIFIER_ATTRIBUTE, QPLAT_Q.VALUE_FROM QUALIFIER_ATTR_VALUE_FROM, QPLAT_Q.PRICING_ATTR_FLAG QUALIFIER_PRICING_ATTR_FLAG, QPQ.QUALIFIER_GROUPING_NO QUALIFIER_GROUPING_NO, QPQ.QUALIFIER_PRECEDENCE QUALIFIER_PRECEDENCE, QPQ.QUALIFIER_DATATYPE QUALIFIER_DATATYPE, QPQ.QUALIFIER_ATTR_VAL UE SETUP_VALUE_FROM, QPQ.QUALIFIER_ATTR_VALUE_TO SETUP_VALUE_TO, QPQ.COMPARISON_OPERATOR_CODE QUALIFIER_OPERATOR_TYPE, NULL PRICING_ATTRIBUTE_DATATYPE, DECODE(QPQ.LIST_LINE_ID, -1, 'HQ', 'LQ') QUALIFIER_TYPE , QPL.BREAK_UOM_CODE , QPL.BREAK_UOM_CONTEXT , QPL.BREAK_UOM_ATTRIBUTE FROM QP_NPREQ_LINES_TMP QPLINES, QP_QUALIFIERS QPQ, QP_NPREQ_LINE_ATTRS_TMP QPLAT_Q, QP_NPREQ_LINE_ATTRS_TMP QPLAT_PROD, QP_PRICING_ATTRIBUTES QPA, QP_LIST_LINES QPL, QP_LIST_HEADERS_B QPH, QP_PRICE_REQ_SOURCES_V QPRS WHERE QPA.PRICING_PHASE_ID = :B15 AND QPA.QUALIFICATION_IND = :B14 AND QPLAT_PROD.CONTEXT = QPA.PRODUCT_ATTRIBUTE_CONTEXT AND (QPLINES.PRICE_FLAG = :B3 OR (QPLINES.PRICE_FLAG = :B13 AND :B12 = :B3 )) AND QPLINES.LIST_PRICE_OVERRIDE_FLAG IN ('N', 'O') AND QPLINES.LINE_TYPE_CODE <> :B11 AND QPLINES.VALIDATED_FLAG = :B10 AND QPLINES.QUALIFIERS_EXIST_FLAG = :B3 AND QPLAT_PROD.ATTRIBUTE = QPA.PRODUCT_ATTRIBUTE AND QPLAT_PROD.VALUE_FROM = QPA.PRODUCT_ATTR_VALUE AND QPA.EXCLUDER_FLAG = :B10 AND QPL.LIST_HEADER_ID = QPH.LIST_HEADER_ID AND ((NVL(:B8 , 'OFF') = 'ON' AND :B9 = QPH.ORIG_ORG_ID) OR (NVL(:B8 , 'OFF') = 'ON' AND NVL(QPH.GLOBAL_FLAG, 'Y') = 'Y') OR NVL(:B8 , 'OFF') = 'OFF' ) AND QPA.LIST_LINE_ID = QPL.LIST_LINE_ID AND QPA.LIST_HEADER_ID = QPLINES.PRICE_LIST_HEADER_ID AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN NVL(TRUNC(QPH.START_DATE_ACTIVE), QPLINES.PRICING_EFFECTIVE_DATE) AND NVL(TRUNC(QPH.END_DATE_ACTIVE), QPLINES.PRICING_EFFECTIVE_DATE) AND QPLINES.PRICING_EFF ECTIVE_DATE BETWEEN NVL(TRUNC(QPL.START_DATE_ACTIVE), QPLINES.PRICING_EFFECTIVE_DATE) AND NVL(TRUNC(QPL.END_DATE_ACTIVE), QPLINES.PRICING_EFFECTIVE_DATE) AND QPH.CURRENCY_CODE = QPLINES.CURRENCY_CODE AND QPH.SOURCE_SYSTEM_CODE = QPRS.SOURCE_SYSTEM_CODE AND QPLINES.REQUEST_TYPE_CODE = QPRS.REQUEST_TYPE_CODE AND QPH.ACTIVE_FLAG = :B3 AND QPLAT_PROD.ATTRIBUTE_TYPE = :B7 AND QPLAT_Q.ATTRIBUTE_TYPE = :B6 AND (QPQ.QUALIFIER_CONTEXT <> :B5 OR QPQ.QUALIFIER_ATTRIBUTE <> :B4 ) AND QPLAT_Q.CONTEXT = QPQ.QUALIFIER_CONTEXT AND QPLAT_Q.ATTRIBUTE = QPQ.QUALIFIER_ATTRIBUTE AND QPQ.LIST_HEADER_ID = QPLINES.PRICE_LIST_HEADER_ID AND QPQ.ACTIVE_FLAG = :B3 AND ((QPLAT_Q.VALUE_FROM = QPQ.QUALIFIER_ATTR_VALUE AND QPQ.COMPARISON_OPERATOR_CODE = '=') OR (QPLAT_Q.VALUE_FROM <> QPQ.QUALIFIER_ATTR_VALUE AND QPQ.COMPARISON_OPERATOR_CODE = 'NOT =') OR QPQ.COMPARISON_OPERATOR_CODE = :B2 ) AND QPLAT_Q.LINE_INDEX = QPLINES.LINE_INDEX AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN NVL(QPQ.START_DATE_ACTIVE, QPLINES.PRICING_EFFECTIVE_DATE) AND NVL(QPQ.END_DATE_ACTIVE, QPLINES.PRICING_EFFECTIVE_DATE) AND QPLAT_PROD.LINE_INDEX = QPLAT_Q.LINE_INDEX AND QPLAT_PROD.PRICING_STATUS_CODE = :B1 AND QPLAT_Q. PRICING_STATUS_CODE = :B1 AND (INSTR(QPLINES.PROCESS_STATUS, 'FREEGOOD')=0) UNION ALL SELECT /*+ ORDERED USE_NL(QPLINES QPQ QPLAT_Q QPLAT_PROD QPA QPLAT_PRIC QPL QPH) INDEX(QPQ QP_QUALIFIERS_N1) INDEX(QPLAT_Q qp_preq_line_attrs_tmp_N2) INDEX(QPA QP_PRICING_ATTRIBUTES_N5) INDEX(QPLAT_PRIC qp_preq_line _attrs_tmp_N2) l_list_qual_cur */ QPLAT_PROD.LINE_INDEX, QPL.LIST_LINE_ID, QPL.ARITHMETIC_OPERATOR, QPL.OPERAND, QPL.PRICING_GROUP_SEQUENCE, QPL.LIST_LINE_TYPE_CODE, QPL.PRICING_PHASE_ID, QPL.AUTOMATIC_FLAG, QPL.INCOMPATIBILITY_GRP_CODE, QPL.PRICE_BY_FORMULA_ID, QPL.PRODUCT_PRECEDENCE, QPL.PRIMARY_UOM_FLAG, QPL.MODIFIER_LEVEL_CODE, QPL.LIST_LINE_NO, QPA.PRODUCT_UOM_CODE, QPA.EXCLUDER_FLAG, QPH.LIST_TYPE_CODE, QPH.ROUNDING_FACTOR, QPH.LIST_HEADER_ID LIST_HEADER_ID, QPLAT_PROD.CONTEXT PRODUCT_ATTRIBUTE_CONTEXT, QPLAT_PROD.ATTRIBUTE PRODUCT_ATTRIBUTE, QPLAT_PROD.VALUE_FROM PRODUCT_ATTR_VALUE_FROM, QPLAT_PROD.ATTRIBUTE_LEVEL PRODUCT_ATTRIBUTE_LEVEL, QPLAT_PROD.ATTRIBUTE_TYPE PRODUCT_ATTRIBUTE_TYPE, QPLAT_PROD.APPLIED_FLAG, QPLAT_PRIC.CONTEXT PRICING_ATTRIBUTE_CONTEXT, QPLAT_PRIC.ATTRIBUTE PRICING_ATTRIBUTE, QPLAT_PRIC.VALUE_FROM PRICING_ATTR_VALUE_FROM, QPA.PRICING_ATTR_VALUE_FROM PRICING_SETUP_VALUE_FROM, QPA.PRICING_ATTR_VALUE_TO PRICING_SETUP_VALUE_TO, QPLAT_PRIC.ATTRIBUTE_LEVEL PRICING_ATTRIBUTE_LEVEL, QPLAT_PRIC.ATTRIBUTE_TYPE PRICING_ATTRIBUTE_TYPE, QPA.COMPARISON_OPERATOR_CODE PRICING_OPERATOR_TYPE, QPLAT_Q.CONTEXT QUALIFIER_ATTRIBUTE_CONTEXT, QPLAT_Q.ATTRIBUTE QUALIFIER_ATTRIBUTE, QPLAT_Q.VALUE_FROM QUALIFIER_ATTR_VALUE_FROM, QPLAT_Q.PRICING_ATTR_FLAG QUALIFIER_PRICING_ATTR_FLAG, QPQ.QUALIFIER_GROUPING_NO QUALIFIER_GROUPING_NO, QPQ.QUALIFIER_PRECEDENCE QUALIFIER_PRECEDENCE, QPQ.QUALIFIER_DATATYPE QUALIFIER_DATATYPE, QPQ.QUALIFIER_AT TR_VALUE SETUP_VALUE_FROM, QPQ.QUALIFIER_ATTR_VALUE_TO SETUP_VALUE_TO, QPQ.COMPARISON_OPERATOR_CODE QUALIFIER_OPERATOR_TYPE, QPA.PRICING_ATTRIBUTE_DATATYPE PRICING_ATTRIBUTE_DATATYPE, DECODE(QPQ.LIST_LINE_ID, -1, 'HQ', 'LQ') QUALIFIER_TYPE , QPL.BREAK_UOM_CODE , QPL.BREAK_UOM_CONTEXT , QPL.BREAK_UOM_ATTRIBUTE FROM QP_NPREQ_LINES_TMP QPLINES, QP_QUALIFIERS QPQ, QP_NPREQ_LINE_ATTRS_TMP QPLAT_Q, QP_NPREQ_LINE_ATTRS_TMP QPLAT_PROD, QP_PRICING_ATTRIBUTES QPA, QP_NPREQ_LINE_ATTRS_TMP QPLAT_PRIC, QP_LIST_LINES QPL, QP_LIST_HEADERS_B QPH, QP_PRICE_REQ_SOURCES_V QPRS WHERE QPA.PRICING_PHASE_ID = :B15 AND QPA.QUALIFICATION_IND = :B17 AND QPLAT_PROD.CONTEXT = QPA.PRODUCT_ATTRIBUTE_CONTEXT AND (QPLINES.PRICE_FLAG = :B3 OR (QPLINES.PRICE_FLAG = :B13 AND :B12 = :B3 )) AND QPLINES.LIST_PRICE_OVERRIDE_FLAG IN ('N', 'O') AND QPLINES.LINE_TYPE_CODE <> :B11 AND QPLINES.VALIDATED_FLAG = :B10 AND QPLINES.QUALIFIERS_EXIST_FLAG = :B3 AND QPLINES.PRICING_ATTRS_EXIST_FLAG = :B3 AND QPLAT_PROD.ATTRIBUTE = QPA.PRODUCT_ATTRIBUTE AND QPLAT_PROD.VALUE_FROM = QPA.PRODUCT_ATTR_VALUE AND QPA.EXCLUDER_FLAG = :B10 AND QPLAT_PRIC.CONTEXT = QPA.PRICING_ATTRIBUTE_CONTEXT AND QPLAT_PRIC.ATTRIBUTE = QPA.PRICING_ATTRIBUTE AND (QPLAT_PRIC.VALUE_FROM = QPA.PRICING_ATTR_VALUE_FROM OR QPA.COMPARISON_OPERATOR_CODE IN ('NOT =', :B2 )) AND QPLAT_PRIC.ATTRIBUTE_TYPE = :B16 AND QPLAT_PRIC. PRICING_STATUS_CODE = :B1 AND QPLAT_PRIC.LINE_INDEX = QPLAT_PROD.LINE_INDEX AND QPH.LIST_HEADER_ID = QPL.LIST_HEAD ER_ID AND ((NVL(:B8 , 'OFF') = 'ON' AND :B9 = QPH.ORIG_ORG_ID) OR (NVL(:B8 , 'OFF') = 'ON' AND NVL(QPH.GLOBAL_FLAG, 'Y') = 'Y') OR NVL(:B8 , 'OFF') = 'OFF' ) AND QPA.LIST_LINE_ID = QPL.LIST_LINE_ID AND QPA.LIST_HEADER_ID = QPLINES.PRICE_LIST_HEADER_ID AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN NVL(TRUNC(QPH.START_DATE_ACTIVE), QPLINES.PRICING_EFFECTIVE_DATE) AND NVL(TRUNC(QPH.END_DATE_ACTIVE), QPLINES.PRICING_EFFECTIVE_DATE) AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN NVL(TRUNC(QPL.START_DATE_ACTIVE), QPLINES.PRICING_EFFECTIVE_DATE) AND NVL(TRUNC(QPL.END_DATE_ACTIVE), QPLINES.PRICING_EFFECTIVE_DATE) AND QPH.CURRENCY_CODE = QPLINES.CURRENCY_CODE AND QPH.SOURCE_SYSTEM_CODE = QPRS.SOURCE_SYSTEM_CODE AND QPLINES.REQUEST_TYPE_CODE = QPRS.REQUEST_TYPE_CODE AND QPH.ACTIVE_FLAG = :B3 AND QPLAT_PROD.ATTRIBUTE_TYPE = :B7 AND QPLAT_Q.ATTRIBUTE_TYPE = :B6 AND (QPQ.QUALIFIER_CONTEXT <> :B5 OR QPQ.QUALIFIER_ATTRIBUTE <> :B4 ) AND QPLAT_Q.CONTEXT = QPQ.QUALIFIER_CONTEXT AND QPLAT_Q.ATTRIBUTE = QPQ.QUALIFIER_ATTRIBUTE AND QPQ.LIST_HEADER_ID = QPLINES.PRICE_LIST_HEADER_ID AND QPQ.ACTIVE_FLAG = :B3 AND ((QPLAT_Q.VALUE_FROM = QPQ.QUALIFIER_ATTR_VALUE AND QPQ.COMPARISON_OPERATOR_CODE = '=') OR (QPLAT_Q.VALUE_FROM <> QPQ.QUALIFIER_ATTR_VALUE AND QPQ.COMPARISON_OPERATOR_CODE = 'NOT =') OR QPQ.COMPARISON_OPERATOR_CODE = :B2 ) AND QPLAT_Q.LINE_INDEX = QPLINES.LINE_INDEX AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN NVL(QPQ.START_DATE_ACTIVE, QPLINES.PRICING_EFFECTIVE_DATE) AND NVL( QPQ.END_DATE_ACTIVE, QPLINES.PRICING_EFFECTIVE_DATE) AND QPLAT_PROD.LINE_INDEX = QPLINES.LINE_INDEX AND QPLAT_PROD.PRICING_STATUS_CODE = :B1 AND QPLAT_Q.PRICING_STATUS_CODE = :B1 AND (INSTR(QPLINES.PROCESS_STATUS, 'FREEGOOD')=0) UNION ALL SELECT /*+ ORDERED USE_NL(QPLINES QPLAT_PROD QPA QPL QPH) index(QPA QP_PRICING_ATTRIBUTES_N5) l_list_cur */ QPLAT_PROD.LINE_INDEX, QPL.LIST_LINE_ID, QPL.ARITHMETIC_OPERATOR, QPL.OPERAND, QPL.PRICING_GROUP_SEQUENCE, QPL.LIST_LINE_TYPE_CODE, QPL.PRICING_PHASE_ID, QPL.AUTOMATIC_FLAG, QPL.INCOMPATIBILITY_GRP_CODE, QPL.PRICE_BY_FORMULA_ID, QPL.PRODUCT_PRECEDENCE, QPL.PRIMARY_UOM_FLAG, QPL.MODIFIER_LEVEL_CODE, QPL.LIST_LINE_NO, QPA.PRODUCT_UOM_CODE, QPA.EXCLUDER_FLAG, QPH.LIST_TYPE_CODE, QPH.ROUNDING_FACTOR, QPH.LIST_HEADER_ID LIST_HEADER_ID, QPLAT_PROD.CONTEXT PRODUCT_ATTRIBUTE_CONTEXT, QPLAT_PROD.ATTRIBUTE PRODUCT_ATTRIBUTE, QPLAT_PROD.VALUE_FROM PRODUCT_ATTR_VALUE_FROM, QPLAT_PROD.ATTRIBUTE_LEVEL PRODUCT_ATTRIBUTE_LEVEL, QPLAT_PROD.ATTRIBUTE_TYPE PRODUCT_ATTRIBUTE_TYPE, QPLAT_PROD.APPLIED_FLAG, NULL PRICING_ATTRIBUTE_CONTEXT, NULL PRICING_ATTRIBUTE, NULL PRICING_ATTR_VALUE_FROM, NULL PRICING_SETUP_VALUE_FROM, NULL PRICING_SETUP_VALUE_TO, NULL PRICING_ATTRIBUTE_LEVEL, NULL PRICING_ATTRIBUTE_TYPE, NULL PRICING_OPERATOR_TYPE, NULL QUALIFIER_ATTRIBUTE_CONTEXT, NULL QUALIFIER_ATTRIBUTE, NULL QUALIFIER_ATTR_VALUE_FROM, NULL QUALIFIER_PRICING_ATTR_FLAG, -9999 QUALIFIER_GROUPING_NO, 5000 QUALIFIER_PRECEDENCE, NULL QUALIFIER_DATATYPE, NULL SETUP_VALUE_FROM, NULL SETUP_VALUE_TO, NULL QUALIFIER_OPERATOR_TYPE, NULL PRICING_ATTRIBUTE_DATATYPE, NULL QUALIFIER_TYPE , QPL.BREAK_UOM_CODE , QPL.BREAK_UOM_CONTEXT , QPL.BREAK_UOM_ATTRIBUTE FROM QP_NPREQ_LINES_TMP QPLINES, QP_NPREQ_LINE_ATTRS_TMP QPLAT_PROD, QP_PRICING_ATTRIBUTES QPA, QP_LIST_LINES QPL, QP_LIST_HEADERS_B QPH, QP_PRICE_REQ_SOURCES_V QPRS WHERE QPA.PRICING_PHASE_ID = :B15 AND QPA.QUALIFICATION_IND = :B18 AND QPLAT_PROD.CONTEXT = QPA.PRODUCT_ATTRIBUTE_CONTEXT AND (QPLINES.PRICE_FLAG = :B3 OR (QPLINES.PRICE_FLAG = :B13 AND :B12 = :B3 )) AND QPLINES.LIST_PRICE_OVERRIDE_FLAG IN ('N', 'O') AND QPLINES.LINE_TYPE_CODE <> :B11 AND QPLINES.VALIDATED_FLAG = :B10 AND QPLINES.QUALIFIERS_EXIST_FLAG = :B10 AND QPLAT_PROD.ATTRIBUTE = QPA.PRODUCT_ATTRIBUTE AND QPLAT_PROD.VALUE_FROM = QPA.PRODUCT_ATTR_VALUE AND QPA.EXCLUDER_FLAG = :B10 AND QPLAT_PROD.PRICING_STATUS_CODE = :B1 AND QPH.LIST_HEADER_ID = QPL.LIST_HEADER_ID AND ((NVL(:B8 , 'OFF') = 'ON' AND :B9 = QPH.ORIG_ORG_ID) OR (NVL(:B8 , 'OFF') = 'ON' AND NVL(QPH.GLOBAL_FLAG, 'Y') = 'Y') OR NVL(:B8 , 'OFF') = 'OFF' ) AND QPA.LIST_LINE_ID = QPL.LIST_LINE_ID AND QPA.LIST_HEADER_ID = QPLINES.PRICE_LIST_HEADER_ID AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN NVL(TRUNC(QPH.START_DATE_ACTIVE), QPLINES.PRICING_EFFECTIVE_DATE) AND NVL(TRUNC(QPH.END_DATE_ACTIVE), QPLINES.PRICING_EFFECTIVE_DATE) AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN NVL(TRUNC(QPL.START_DATE_ACTIVE), QPLINES.PRICING_EFFE CTIVE_DATE) AND NVL(TRUNC(QPL.END_DATE_ACTIVE), QPLINES.PRICING_EFFECTIVE_DATE) AND QPH.CURRENCY_CODE = QPLINES.CURRENCY_CODE AND QPH.SOURCE_SYSTEM_CODE = QPRS.SOURCE_SYSTEM_CODE AND QPLINES.REQUEST_TYPE_CODE = QPRS.REQUEST_TYPE_CODE AND QPH.ACTIVE_FLAG = :B3 AND QPLAT_PROD.ATTRIBUTE_TYPE = :B7 AND QPLAT_PROD.LINE_INDEX = QPLINES.LINE_INDEX AND (INSTR(QPLINES.PROCESS_STATUS, 'FREEGOOD')=0) UNION ALL SELECT /*+ ORDERED USE_NL(QPLINES QPLAT_PROD QPA QPLAT_PRIC QPL QPH) index(QPA QP_PRICING_ATTRIBUTES_N5) INDEX(QPLAT_PRIC qp_preq_line_attrs_tmp_N2) l_list_cur */ QPLAT_PROD.LINE_INDEX, QPL.LIST_LINE_ID, QPL.ARITHMETIC_OPERATOR, QPL.OPERAND, QPL.PRICING_GROUP_SEQUENCE, QPL.LIST_LINE_TYPE_CODE, QPL.PRICING_PHASE_ID, QPL.AUTOMATIC_FLAG, QPL.INCOMPATIBILITY_GRP_CODE, QPL.PRICE_BY_FORMULA_ID, QPL.PRODUCT_PRECEDENCE, QPL.PRIMARY_UOM_FLAG, QPL.MODIFIER_LEVEL_CODE, QPL.LIST_LINE_NO, QPA.PRODUCT_UOM_CODE, QPA.EXCLUDER_FLAG, QPH.LIST_TYPE_CODE, QPH.ROUNDING_FACTOR, QPH.LIST_HEADER_ID LIST_HEADER_ID, QPLAT_PROD.CONTEXT PRODUCT_ATTRIBUTE_CONTEXT, QPLAT_PROD.ATTRIBUTE PRODUCT_ATTRIBUTE, QPLAT_PROD.VALUE_FROM PRODUCT_ATTR_VALUE_FROM, QPLAT_PROD.ATTRIBUTE_LEVEL PRODUCT_ATTRIBUTE_LEVEL, QPLAT_PROD.ATTRIBUTE_TYPE PRODUCT_ATTRIBUTE_TYPE, QPLAT_PROD.APPLIED_FLAG, QPLAT_PRIC.CONTEXT PRICING_ATTRIBUTE_CONTEXT, QPLAT_PRIC.ATTRIBUTE PRICING_ATTRIBUTE, QPLAT_PRIC.VALUE_FROM PRICING_ATTR_VALUE_FROM, QPA.PRICING_ATTR_VALUE_FROM PRICING_SETUP_VALUE_FROM, QPA.PRICING_ATTR_VALUE_ TO PRICING_SETUP_VALUE_TO, QPLAT_PRIC.ATTRIBUTE_LEVEL PRICING_ATTRIBUTE_LEVEL, QPLAT_PRIC.ATTRIBUTE_TYPE PRICING_ATTRIBUTE_TYPE, QPA.COMPARISON_OPERATOR_CODE PRICING_OPERATOR_TYPE, NULL QUALIFIER_ATTRIBUTE_CONTEXT, NULL QUALIFIER_ATTRIBUTE, NULL QUALIFIER_ATTR_VALUE_FROM, NULL QUALIFIER_PRICING_ATTR_FLAG, -9999 QUALIFIER_GROUPING_NO, 5000 QUALIFIER_PRECEDENCE, NULL QUALIFIER_DATATYPE, NULL SETUP_VALUE_FROM, NULL SETUP_VALUE_TO, NULL QUALIFIER_OPERATOR_TYPE, QPA.PRICING_ATTRIBUTE_DATATYPE PRICING_ATTRIBUTE_DATATYPE, NULL QUALIFIER_TYPE , QPL.BREAK_UOM_CODE , QPL.BREAK_UOM_CONTEXT , QPL.BREAK_UOM_ATTRIBUTE FROM QP_NPREQ_LINES_TMP QPLINES, QP_NPREQ_LINE_ATTRS_TMP QPLAT_PROD, QP_PRICING_ATTRIBUTES QPA, QP_NPREQ_LINE_ATTRS_TMP QPLAT_PRIC, QP_LIST_LINES QPL, QP_LIST_HEADERS_B QPH, QP_PRICE_REQ_SOURCES_V QPRS WHERE QPA.PRICING_PHASE_ID = :B15 AND QPA.QUALIFICATION_IND = :B19 AND QPLAT_PROD.CONTEXT = QPA.PRODUCT_ATTRIBUTE_CONTEXT AND (QPLINES.PRICE_FLAG = :B3 OR (QPLINES.PRICE_FLAG = :B13 AND :B12 = :B3 )) AND QPLINES.LIST_PRICE_OVERRIDE_FLAG IN ('N', 'O') AND QPLINES.LINE_TYPE_CODE <> :B11 AND QPLINES.VALIDATED_FLAG = :B10 AND QPLINES.QUALIFIERS_EXIST_FLAG = :B10 AND QPLINES.PRICING_ATTRS_EXIST_FLAG = :B3 AND QPLAT_PROD.ATTRIBUTE = QPA.PRODUCT_ATTRIBUTE AND QPLAT_PROD.VALUE_FROM = QPA.PRODUCT_ATTR_VALUE AND QPA.EXCLUDER_FLAG = :B10 AND QPLAT_PROD.PRICING_STATUS_CODE = :B1 AND QPLAT_PRIC.CONTEXT = QPA.PRICING_ATTRIBUTE_CONTEXT AND QPLAT_PRIC.ATTRIBUTE = QP A.PRICING_ATTRIBUTE AND (QPLAT_PRIC.VALUE_FROM = QPA.PRICING_ATTR_VALUE_FROM OR QPA.COMPARISON_OPERATOR_CODE IN ('NOT =', :B2 )) AND QPLAT_PRIC.ATTRIBUTE_TYPE = :B16 AND QPLAT_PRIC. PRICING_STATUS_CODE = :B1 AND QPLAT_PRIC.LINE_INDEX = QPLAT_PROD.LINE_INDEX AND QPH.LIST_HEADER_ID = QPLINES.PRICE_LIST_HEADER_ID AND ((NVL(:B8 , 'OFF') = 'ON' AND :B9 = QPH.ORIG_ORG_ID) OR (NVL(:B8 , 'OFF') = 'ON' AND NVL(QPH.GLOBAL_FLAG, 'Y') = 'Y') OR NVL(:B8 , 'OFF') = 'OFF' ) AND QPA.LIST_LINE_ID = QPL.LIST_LINE_ID AND QPA.LIST_HEADER_ID = QPLINES.PRICE_LIST_HEADER_ID AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN NVL(TRUNC(QPH.START_DATE_ACTIVE), QPLINES.PRICING_EFFECTIVE_DATE) AND NVL(TRUNC(QPH.END_DATE_ACTIVE), QPLINES.PRICING_EFFECTIVE_DATE) AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN NVL(TRUNC(QPL.START_DATE_ACTIVE), QPLINES.PRICING_EFFECTIVE_DATE) AND NVL(TRUNC(QPL.END_DATE_ACTIVE), QPLINES.PRICING_EFFECTIVE_DATE) AND QPH.CURRENCY_CODE = QPLINES.CURRENCY_CODE AND QPH.SOURCE_SYSTEM_CODE = QPRS.SOURCE_SYSTEM_CODE AND QPLINES.REQUEST_TYPE_CODE = QPRS.REQUEST_TYPE_CODE AND QPH.ACTIVE_FLAG = :B3 AND QPLAT_PROD.ATTRIBUTE_TYPE = :B7 AND QPLAT_PROD.LINE_INDEX = QPLINES.LINE_INDEX AND (INSTR(QPLINES.PROCESS_STATUS, 'FREEGOOD')=0) ORDER BY 1, 2

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,937,287 537.39 1.67
CPU used when call started 1,932,842 536.15 1.67
CR blocks created 16,011,813 4,441.53 13.84
Cached Commit SCN referenced 47,654 13.22 0.04
Commit SCN cached 8 0.00 0.00
DB time 5,209,210 1,444.99 4.50
DBWR checkpoint buffers written 2,983,521 827.60 2.58
DBWR checkpoints 34 0.01 0.00
DBWR object drop buffers written 57,953 16.08 0.05
DBWR revisited being-written buffer 197 0.05 0.00
DBWR thread checkpoint buffers written 639,346 177.35 0.55
DBWR transaction table writes 2,288 0.63 0.00
DBWR undo block writes 1,585,108 439.69 1.37
DFO trees parallelized 48 0.01 0.00
IMU CR rollbacks 37,304,078 10,347.80 32.25
IMU Flushes 334,958 92.91 0.29
IMU Redo allocation size 2,288,521,852 634,814.60 1,978.66
IMU commits 601,811 166.94 0.52
IMU contention 36,074 10.01 0.03
IMU ktichg flush 10,508 2.91 0.01
IMU pool not allocated 0 0.00 0.00
IMU recursive-transaction flush 1,657 0.46 0.00
IMU undo allocation size 5,420,477,984 1,503,589.99 4,686.55
IMU- failed to get a private strand 0 0.00 0.00
PX local messages recv'd 52,836 14.66 0.05
PX local messages sent 52,836 14.66 0.05
Parallel operations downgraded 25 to 50 pct 40 0.01 0.00
Parallel operations not downgraded 8 0.00 0.00
SQL*Net roundtrips to/from client 47,073,853 13,057.85 40.70
active txn count during cleanout 104,830,494 29,079.00 90.64
application wait time 17,679 4.90 0.02
background checkpoints completed 3 0.00 0.00
background checkpoints started 2 0.00 0.00
background timeouts 13,901 3.86 0.01
branch node splits 1,052 0.29 0.00
buffer is not pinned count 568,695,930 157,750.94 491.70
buffer is pinned count 1,473,230,256 408,660.32 1,273.76
bytes received via SQL*Net from client 10,346,478,470 2,870,016.53 8,945.58
bytes sent via SQL*Net to client 9,458,274,336 2,623,637.00 8,177.64
calls to get snapshot scn: kcmgss 109,891,561 30,482.89 95.01
calls to kcmgas 20,036,121 5,557.83 17.32
calls to kcmgcs 11,013,488 3,055.04 9.52
change write time 44,960 12.47 0.04
cleanout - number of ktugct calls 25,265,595 7,008.44 21.84
cleanouts and rollbacks - consistent read gets 13,833,102 3,837.17 11.96
cleanouts only - consistent read gets 148,422 41.17 0.13
cluster key scan block gets 856,168 237.49 0.74
cluster key scans 237,412 65.86 0.21
commit batch/immediate performed 4,134 1.15 0.00
commit batch/immediate requested 4,134 1.15 0.00
commit cleanout failures: block lost 244,930 67.94 0.21
commit cleanout failures: buffer being written 558 0.15 0.00
commit cleanout failures: callback failure 107,015 29.68 0.09
commit cleanout failures: cannot pin 32,967 9.14 0.03
commit cleanouts 9,177,693 2,545.81 7.94
commit cleanouts successfully completed 8,792,223 2,438.88 7.60
commit immediate performed 4,134 1.15 0.00
commit immediate requested 4,134 1.15 0.00
commit txn count during cleanout 1,325,727 367.74 1.15
concurrency wait time 12,614 3.50 0.01
consistent changes 799,285,700 221,714.39 691.06
consistent gets 1,806,365,572 501,068.94 1,561.79
consistent gets - examination 1,278,942,261 354,766.64 1,105.78
consistent gets from cache 1,806,365,558 501,068.94 1,561.79
cursor authentications 2,120 0.59 0.00
data blocks consistent reads - undo records applied 795,360,272 220,625.51 687.67
db block changes 196,360,398 54,468.54 169.77
db block gets 219,222,733 60,810.34 189.54
db block gets direct 4,284 1.19 0.00
db block gets from cache 219,218,448 60,809.15 189.54
deferred (CURRENT) block cleanout applications 1,603,750 444.87 1.39
dirty buffers inspected 8,593 2.38 0.01
enqueue conversions 9,730 2.70 0.01
enqueue releases 4,344,191 1,205.04 3.76
enqueue requests 4,351,487 1,207.06 3.76
enqueue timeouts 7,210 2.00 0.01
enqueue waits 32,382 8.98 0.03
exchange deadlocks 27,303 7.57 0.02
execute count 97,850,049 27,142.69 84.60
failed probes on index block reclamation 12,621 3.50 0.01
frame signature mismatch 304 0.08 0.00
free buffer inspected 3,059,756 848.75 2.65
free buffer requested 20,391,855 5,656.51 17.63
heap block compress 32,980,869 9,148.59 28.52
hot buffers moved to head of LRU 1,309,365 363.21 1.13
immediate (CR) block cleanout applications 13,981,543 3,878.35 12.09
immediate (CURRENT) block cleanout applications 1,134,141 314.60 0.98
index crx upgrade (found) 22,160 6.15 0.02
index crx upgrade (positioned) 9,760,129 2,707.37 8.44
index fast full scans (rowid ranges) 824 0.23 0.00
index fetch by key 180,513,677 50,072.81 156.07
index scans kdiixs1 133,939,271 37,153.50 115.80
java call heap collected bytes 1,414,009,736 392,233.10 1,222.56
java call heap collected count 17,326,790 4,806.29 14.98
java call heap gc count 4,645 1.29 0.00
java call heap live object count 1,544,144 428.33 1.34
java call heap live object count max 1,552,691 430.70 1.34
java call heap live size 375,651,440 104,202.20 324.79
java call heap live size max 377,623,320 104,749.18 326.49
java call heap object count 3,709,293 1,028.92 3.21
java call heap object count max 3,719,594 1,031.78 3.22
java call heap total size 485,097,472 134,561.51 419.42
java call heap total size max 487,201,792 135,145.23 421.24
java call heap used size 514,354,416 142,677.11 444.71
java call heap used size max 516,590,616 143,297.41 446.65
leaf node 90-10 splits 20,737 5.75 0.02
leaf node splits 241,665 67.04 0.21
lob reads 21,413 5.94 0.02
lob writes 37,206 10.32 0.03
lob writes unaligned 37,206 10.32 0.03
logons cumulative 9,312 2.58 0.01
messages received 2,303,677 639.02 1.99
messages sent 2,303,676 639.02 1.99
no buffer to keep pinned count 16 0.00 0.00
no work - consistent read gets 478,808,494 132,817.01 413.98
opened cursors cumulative 5,511,597 1,528.87 4.77
parse count (failures) 3,250 0.90 0.00
parse count (hard) 8,876 2.46 0.01
parse count (total) 8,510,087 2,360.62 7.36
parse time cpu 43,337 12.02 0.04
parse time elapsed 46,836 12.99 0.04
physical read IO requests 290,826 80.67 0.25
physical read bytes 3,598,172,160 998,099.36 3,110.99
physical read total IO requests 320,101 88.79 0.28
physical read total bytes 4,076,904,448 1,130,895.23 3,524.90
physical read total multi block requests 12,003 3.33 0.01
physical reads 439,230 121.84 0.38
physical reads cache 438,095 121.52 0.38
physical reads cache prefetch 148,006 41.06 0.13
physical reads direct 1,135 0.31 0.00
physical reads direct temporary tablespace 403 0.11 0.00
physical reads prefetch warmup 79,001 21.91 0.07
physical write IO requests 1,200,045 332.88 1.04
physical write bytes 25,165,127,680 6,980,571.47 21,757.81
physical write total IO requests 2,417,538 670.60 2.09
physical write total bytes 58,192,146,944 16,141,958.26 50,313.03
physical write total multi block requests 1,406,043 390.02 1.22
physical writes 3,071,915 852.12 2.66
physical writes direct 5,020 1.39 0.00
physical writes direct (lob) 219 0.06 0.00
physical writes direct temporary tablespace 4,400 1.22 0.00
physical writes from cache 3,066,895 850.73 2.65
physical writes non checkpoint 2,321,319 643.91 2.01
pinned buffers inspected 4,042 1.12 0.00
prefetch warmup blocks aged out before use 243,215 67.47 0.21
prefetched blocks aged out before use 116 0.03 0.00
process last non-idle time 3,605 1.00 0.00
queries parallelized 48 0.01 0.00
recursive aborts on index block reclamation 2 0.00 0.00
recursive calls 158,520,480 43,972.10 137.06
recursive cpu usage 1,089,715 302.28 0.94
redo blocks written 64,339,000 17,847.04 55.63
redo buffer allocation retries 211 0.06 0.00
redo entries 101,050,912 28,030.58 87.37
redo log space requests 0 0.00 0.00
redo log space wait time 0 0.00 0.00
redo ordering marks 1,277,047 354.24 1.10
redo size 31,554,693,908 8,752,977.49 27,282.24
redo subscn max counts 2,334,595 647.59 2.02
redo synch time 71,719 19.89 0.06
redo synch writes 2,186,220 606.44 1.89
redo wastage 309,193,776 85,767.47 267.33
redo write time 38,355 10.64 0.03
redo writer latching time 156 0.04 0.00
redo writes 813,759 225.73 0.70
rollback changes - undo records applied 220,158 61.07 0.19
rollbacks only - consistent read gets 2,330,479 646.45 2.01
rows fetched via callback 94,350,709 26,172.01 81.58
session connect time 0 0.00 0.00
session cursor cache hits 5,370,078 1,489.61 4.64
session logical reads 2,025,588,843 561,879.43 1,751.33
session pga memory 9,388,017,248 2,604,148.34 8,116.90
session pga memory max 10,344,395,776 2,869,438.81 8,943.78
session uga memory ############### 74,879,256.30 233,391.88
session uga memory max 67,781,103,296 18,801,845.23 58,603.65
shared hash latch upgrades - no wait 31,618,527 8,770.68 27.34
shared hash latch upgrades - wait 36,941 10.25 0.03
sorts (memory) 10,337,154 2,867.43 8.94
sorts (rows) 128,116,585 35,538.34 110.77
sql area evicted 2,782 0.77 0.00
sql area purged 3,420 0.95 0.00
summed dirty queue length 458,784 127.26 0.40
switch current to new buffer 1,358,632 376.87 1.17
table fetch by rowid 872,213,891 241,943.99 754.12
table fetch continued row 30,276,008 8,398.28 26.18
table scan blocks gotten 94,007,611 26,076.83 81.28
table scan rows gotten 7,349,181,714 2,038,594.39 6,354.11
table scans (long tables) 2,058 0.57 0.00
table scans (rowid ranges) 2,056 0.57 0.00
table scans (short tables) 5,686,081 1,577.27 4.92
total number of times SMON posted 133,293 36.97 0.12
transaction rollbacks 4,134 1.15 0.00
transaction tables consistent read rollbacks 60 0.02 0.00
transaction tables consistent reads - undo records applied 5,426 1.51 0.00
undo change vector size 11,032,576,764 3,060,333.79 9,538.78
user I/O wait time 104,993 29.12 0.09
user calls 44,944,237 12,467.11 38.86
user commits 918,140 254.68 0.79
user rollbacks 238,462 66.15 0.21
workarea executions - onepass 2 0.00 0.00
workarea executions - optimal 6,070,521 1,683.91 5.25
write clones created in background 1,563 0.43 0.00
write clones created in foreground 4,609 1.28 0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistic Begin Value End Value
session cursor cache count 508,690 1,160,615
opened cursors current 1,008,193 1,119,537
workarea memory allocated 2,562 160
logons current 4,768 4,783

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 32 0 9.06 1.00 529,391 147 250,812 0.02
APPS_TS_TX_DATA 171,477 48 3.50 1.28 170,904 47 119,598 0.19
APPS_TS_TX_IDX 94,094 26 3.51 1.32 194,488 54 50,935 0.32
APPS_ASSM_DATA 8,728 2 1.96 6.56 133,674 37 44,727 0.33
APPS_ASSM_IDX 6,589 2 1.95 1.04 112,190 31 184,854 0.09
APPS_TS_TX_INTERFACE 1,186 0 1.69 2.11 27,086 8 10,328 0.03
TEMP 478 0 3.49 10.07 9,496 3 33 1.82
SYSTEM 5,010 1 3.42 3.68 2,457 1 22,696 0.05
APPS_TS_SEED 2,179 1 4.47 1.61 4,914 1 726 1.98
APPS_TS_SUMMARY 56 0 7.50 1.00 6,954 2 2,667 0.01
APPS_TS_QUEUES 372 0 4.25 2.35 5,053 1 447 0.22
APPS_TS_ARCHIVE 66 0 4.70 1.17 1,991 1 88 4.20
SYSAUX 307 0 2.25 1.07 1,427 0 0 0.00
APPS_TS_NOLOGGING 25 0 4.40 1.56 35 0 3 0.00
CTXSYS 24 0 4.17 1.00 6 0 0 0.00
APPS_TS_MEDIA 12 0 5.83 1.00 9 0 0 0.00
ODM 12 0 5.00 1.00 3 0 0 0.00
OLAP 12 0 3.33 1.00 3 0 0 0.00
OWAPUB 12 0 4.17 1.00 3 0 0 0.00
PORTAL 12 0 4.17 1.00 3 0 0 0.00
SYNCSERVER 12 0 4.17 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,728 2 1.96 6.56 133,674 37 44,727 0.33
APPS_ASSM_IDX /DB/visdata/apps_assm_idx.dbf 6,589 2 1.95 1.04 112,190 31 184,854 0.09
APPS_TS_ARCHIVE /DB/visdata/archive1.dbf 35 0 5.14 1.00 1,741 0 86 4.30
APPS_TS_ARCHIVE /DB/visdata/archive2.dbf 31 0 4.19 1.35 250 0 2 0.00
APPS_TS_MEDIA /DB/visdata/media1.dbf 4 0 5.00 1.00 3 0 0 0.00
APPS_TS_MEDIA /DB/visdata/media2.dbf 4 0 5.00 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 5.00 1.00 3 0 0 0.00
APPS_TS_NOLOGGING /DB/visdata/nologging2.dbf 15 0 4.00 1.00 18 0 3 0.00
APPS_TS_NOLOGGING /DB/visdata/nologging3.dbf 6 0 5.00 3.33 14 0 0 0.00
APPS_TS_QUEUES /DB/visdata/queues1.dbf 49 0 4.08 2.18 643 0 216 0.23
APPS_TS_QUEUES /DB/visdata/queues2.dbf 30 0 3.00 3.10 840 0 183 0.22
APPS_TS_QUEUES /DB/visdata/queues3.dbf 36 0 4.44 2.58 756 0 1 0.00
APPS_TS_QUEUES /DB/visdata/queues4.dbf 41 0 3.41 2.83 741 0 2 0.00
APPS_TS_QUEUES /DB/visdata/queues5.dbf 40 0 3.50 2.05 630 0 4 0.00
APPS_TS_QUEUES /DB/visdata/queues6.dbf 38 0 4.47 2.76 602 0 0 0.00
APPS_TS_QUEUES /DB/visdata/queues7.dbf 138 0 4.93 2.02 841 0 41 0.24
APPS_TS_SEED /DB/visdata/reference1.dbf 185 0 4.76 1.81 455 0 39 3.59
APPS_TS_SEED /DB/visdata/reference10.dbf 184 0 4.78 1.67 531 0 43 0.93
APPS_TS_SEED /DB/visdata/reference2.dbf 219 0 4.57 1.52 521 0 44 4.32
APPS_TS_SEED /DB/visdata/reference3.dbf 337 0 4.36 1.54 547 0 418 1.89
APPS_TS_SEED /DB/visdata/reference4.dbf 193 0 3.99 1.67 477 0 36 2.50
APPS_TS_SEED /DB/visdata/reference5.dbf 243 0 4.20 1.50 466 0 10 1.00
APPS_TS_SEED /DB/visdata/reference6.dbf 223 0 4.53 1.73 514 0 14 0.71
APPS_TS_SEED /DB/visdata/reference7.dbf 223 0 4.84 1.52 439 0 20 1.00
APPS_TS_SEED /DB/visdata/reference8.dbf 197 0 3.91 1.69 448 0 30 3.33
APPS_TS_SEED /DB/visdata/reference9.dbf 175 0 4.86 1.54 516 0 72 0.69
APPS_TS_SUMMARY /DB/visdata/summary1.dbf 5 0 8.00 1.00 849 0 296 0.03
APPS_TS_SUMMARY /DB/visdata/summary2.dbf 5 0 6.00 1.00 765 0 292 0.00
APPS_TS_SUMMARY /DB/visdata/summary3.dbf 7 0 4.29 1.00 786 0 251 0.12
APPS_TS_SUMMARY /DB/visdata/summary4.dbf 11 0 5.45 1.00 694 0 252 0.00
APPS_TS_SUMMARY /DB/visdata/summary5.dbf 7 0 8.57 1.00 889 0 370 0.00
APPS_TS_SUMMARY /DB/visdata/summary6.dbf 7 0 10.00 1.00 935 0 713 0.00
APPS_TS_SUMMARY /DB/visdata/summary7.dbf 7 0 10.00 1.00 988 0 254 0.00
APPS_TS_SUMMARY /DB/visdata/summary8.dbf 7 0 8.57 1.00 1,048 0 239 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data1.dbf 3,090 1 3.97 1.18 333 0 0 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data10.dbf 3,050 1 3.94 1.17 228 0 0 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data11.dbf 3,055 1 3.93 1.22 190 0 0 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data12.dbf 12,961 4 2.59 1.21 2,860 1 2,786 0.92
APPS_TS_TX_DATA /DB/visdata/tx_data13.dbf 17,292 5 3.75 1.43 4,608 1 1,806 0.91
APPS_TS_TX_DATA /DB/visdata/tx_data14.dbf 12,923 4 3.46 1.33 25,084 7 14,929 0.16
APPS_TS_TX_DATA /DB/visdata/tx_data15.dbf 9,170 3 3.21 1.39 23,947 7 16,046 0.21
APPS_TS_TX_DATA /DB/visdata/tx_data16.dbf 9,204 3 3.25 1.41 23,152 6 16,960 0.15
APPS_TS_TX_DATA /DB/visdata/tx_data17.dbf 9,108 3 3.22 1.40 22,215 6 16,464 0.13
APPS_TS_TX_DATA /DB/visdata/tx_data18.dbf 9,148 3 3.21 1.38 21,311 6 15,487 0.16
APPS_TS_TX_DATA /DB/visdata/tx_data19.dbf 9,041 3 3.27 1.40 21,364 6 16,369 0.14
APPS_TS_TX_DATA /DB/visdata/tx_data2.dbf 6,525 2 2.90 1.13 757 0 1,422 0.95
APPS_TS_TX_DATA /DB/visdata/tx_data20.dbf 9,134 3 3.37 1.42 21,325 6 15,733 0.13
APPS_TS_TX_DATA /DB/visdata/tx_data21.dbf 22,042 6 3.84 1.21 988 0 1,532 0.03
APPS_TS_TX_DATA /DB/visdata/tx_data3.dbf 3,564 1 4.27 1.30 420 0 9 5.56
APPS_TS_TX_DATA /DB/visdata/tx_data4.dbf 16,718 5 3.76 1.06 288 0 9 6.67
APPS_TS_TX_DATA /DB/visdata/tx_data5.dbf 3,072 1 3.99 1.17 390 0 8 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data6.dbf 3,082 1 3.69 1.19 224 0 9 7.78
APPS_TS_TX_DATA /DB/visdata/tx_data7.dbf 3,035 1 3.78 1.20 482 0 14 0.71
APPS_TS_TX_DATA /DB/visdata/tx_data8.dbf 3,060 1 3.90 1.21 470 0 14 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data9.dbf 3,203 1 4.03 1.23 268 0 1 0.00
APPS_TS_TX_IDX /DB/visdata/tx_idx1.dbf 2,479 1 3.10 1.12 2,141 1 1,066 0.69
APPS_TS_TX_IDX /DB/visdata/tx_idx10.dbf 2,450 1 3.03 1.13 1,394 0 1,173 0.60
APPS_TS_TX_IDX /DB/visdata/tx_idx11.dbf 2,456 1 3.14 1.15 1,542 0 1,110 0.54
APPS_TS_TX_IDX /DB/visdata/tx_idx12.dbf 11,000 3 3.89 1.55 20,558 6 1,293 0.39
APPS_TS_TX_IDX /DB/visdata/tx_idx13.dbf 9,664 3 3.61 1.28 27,015 7 3,225 0.37
APPS_TS_TX_IDX /DB/visdata/tx_idx14.dbf 5,812 2 3.75 1.35 19,561 5 3,095 0.12
APPS_TS_TX_IDX /DB/visdata/tx_idx15.dbf 5,719 2 3.63 1.39 16,862 5 3,393 0.18
APPS_TS_TX_IDX /DB/visdata/tx_idx16.dbf 5,686 2 3.74 1.40 15,729 4 3,598 0.12
APPS_TS_TX_IDX /DB/visdata/tx_idx17.dbf 5,583 2 3.50 1.34 14,284 4 3,599 0.23
APPS_TS_TX_IDX /DB/visdata/tx_idx18.dbf 5,813 2 3.68 1.36 14,873 4 5,036 0.14
APPS_TS_TX_IDX /DB/visdata/tx_idx19.dbf 5,775 2 3.79 1.38 13,746 4 3,878 0.31
APPS_TS_TX_IDX /DB/visdata/tx_idx2.dbf 3,065 1 3.43 1.23 1,893 1 1,150 0.41
APPS_TS_TX_IDX /DB/visdata/tx_idx20.dbf 5,570 2 3.65 1.38 13,495 4 2,411 0.08
APPS_TS_TX_IDX /DB/visdata/tx_idx21.dbf 3,364 1 3.92 1.51 13,987 4 2,078 0.50
APPS_TS_TX_IDX /DB/visdata/tx_idx3.dbf 4,020 1 2.45 1.09 1,844 1 1,572 1.26
APPS_TS_TX_IDX /DB/visdata/tx_idx4.dbf 2,667 1 3.27 1.09 3,108 1 1,365 0.87
APPS_TS_TX_IDX /DB/visdata/tx_idx5.dbf 2,656 1 3.23 1.18 4,362 1 7,396 0.10
APPS_TS_TX_IDX /DB/visdata/tx_idx6.dbf 2,674 1 3.26 1.17 2,411 1 1,175 0.66
APPS_TS_TX_IDX /DB/visdata/tx_idx7.dbf 2,586 1 3.03 1.18 2,253 1 952 0.68
APPS_TS_TX_IDX /DB/visdata/tx_idx8.dbf 2,520 1 3.21 1.12 1,752 0 1,225 0.59
APPS_TS_TX_IDX /DB/visdata/tx_idx9.dbf 2,535 1 2.91 1.17 1,678 0 1,145 0.52
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte.dbf 144 0 1.53 2.06 4,168 1 2,029 0.02
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte2.dbf 399 0 1.38 1.81 5,533 2 2,227 0.04
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte3.dbf 184 0 2.23 2.35 4,651 1 1,954 0.02
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte4.dbf 155 0 1.81 2.36 4,370 1 1,483 0.04
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte5.dbf 246 0 1.30 1.79 4,246 1 1,757 0.03
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte6.dbf 58 0 3.97 4.24 4,118 1 878 0.02
APPS_UNDOTS1 /DB/visdata/undo01.dbf 3 0 6.67 1.00 59,015 16 24,062 0.02
APPS_UNDOTS1 /DB/visdata/undo02.dbf 4 0 5.00 1.00 54,787 15 23,159 0.03
APPS_UNDOTS1 /DB/visdata/undo03.dbf 3 0 10.00 1.00 50,216 14 27,953 0.03
APPS_UNDOTS1 /DB/visdata/undo04.dbf 4 0 10.00 1.00 48,907 14 25,905 0.02
APPS_UNDOTS1 /DB/visdata/undo05.dbf 3 0 13.33 1.00 51,633 14 24,276 0.02
APPS_UNDOTS1 /DB/visdata/undo06.dbf 3 0 6.67 1.00 50,170 14 22,161 0.03
APPS_UNDOTS1 /DB/visdata/undo07.dbf 3 0 16.67 1.00 47,936 13 23,620 0.02
APPS_UNDOTS1 /DB/visdata/undo08.dbf 3 0 3.33 1.00 51,459 14 23,462 0.02
APPS_UNDOTS1 /DB/visdata/undo09.dbf 3 0 10.00 1.00 56,248 16 29,180 0.03
APPS_UNDOTS1 /DB/visdata/undo10.dbf 3 0 10.00 1.00 59,020 16 27,034 0.02
CTXSYS /DB/visdata/ctx1.dbf 12 0 5.00 1.00 3 0 0 0.00
CTXSYS /DB/visdata/ctx2.dbf 12 0 3.33 1.00 3 0 0 0.00
ODM /DB/visdata/odm.dbf 12 0 5.00 1.00 3 0 0 0.00
OLAP /DB/visdata/olap.dbf 12 0 3.33 1.00 3 0 0 0.00
OWAPUB /DB/visdata/owa1.dbf 12 0 4.17 1.00 3 0 0 0.00
PORTAL /DB/visdata/portal.dbf 12 0 4.17 1.00 3 0 0 0.00
SYNCSERVER /DB/visdata/mobile01.dbf 12 0 4.17 1.00 3 0 0 0.00
SYSAUX /DB/visdata/sysaux01.dbf 6 0 6.67 1.33 552 0 0 0.00
SYSAUX /DB/visdata/sysaux02.dbf 301 0 2.16 1.06 875 0 0 0.00
SYSTEM /DB/visdata/sys1.dbf 534 0 3.15 4.14 105 0 53 0.00
SYSTEM /DB/visdata/sys2.dbf 516 0 3.91 4.43 178 0 67 0.30
SYSTEM /DB/visdata/sys3.dbf 692 0 2.93 3.46 241 0 0 0.00
SYSTEM /DB/visdata/sys4.dbf 624 0 2.85 3.73 231 0 0 0.00
SYSTEM /DB/visdata/sys5.dbf 808 0 3.61 3.10 627 0 1,784 0.06
SYSTEM /DB/visdata/sys6.dbf 552 0 3.35 4.20 63 0 8 0.00
SYSTEM /DB/visdata/sys7.dbf 443 0 3.81 4.31 156 0 110 0.82
SYSTEM /DB/visdata/sys8.dbf 377 0 3.77 3.21 441 0 20,628 0.04
SYSTEM /DB/visdata/sys9.dbf 464 0 3.71 2.69 415 0 46 1.09
TEMP /DB/visdata/temp1.dbf 124 0 3.87 16.81 2,568 1 24 1.67
TEMP /DB/visdata/temp2.dbf 150 0 3.47 16.84 2,508 1 0  
TEMP /DB/visdata/temp3.dbf 116 0 3.02 1.00 1,950 1 0  
TEMP /DB/visdata/temp4.dbf 88 0 3.64 1.00 2,470 1 9 2.22

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,204,606 100 2,025,349,202 438,073 3,066,895 0 0 687,916


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 90 43824 1061578 4138619 188743680 4138619  
E 180 91 47928 1068193 9681343 188743680 9681343  

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 578,911 10

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 43,446.69 1.31 0.00 100.00 0.00 1,048,576
E 20,480 1,280 49,931.53 0.60 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,488,787 5,488,787 0 0
64K 128K 11,705 11,705 0 0
128K 256K 1,144 1,144 0 0
256K 512K 1,121 1,121 0 0
512K 1024K 171,831 171,831 0 0
1M 2M 395,699 395,699 0 0
2M 4M 70 70 0 0
4M 8M 19 17 2 0
8M 16M 20 20 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 858,717.79 8,256.51 99.00 1,092
5,120 0.25 858,717.79 8,180.31 99.00 1,058
10,240 0.50 858,717.79 8,032.82 99.00 1,008
15,360 0.75 858,717.79 7,880.45 99.00 958
20,480 1.00 858,717.79 5.06 100.00 922
24,576 1.20 858,717.79 5.06 100.00 879
28,672 1.40 858,717.79 5.06 100.00 813
32,768 1.60 858,717.79 5.06 100.00 614
36,864 1.80 858,717.79 0.00 100.00 162
40,960 2.00 858,717.79 0.00 100.00 0
61,440 3.00 858,717.79 0.00 100.00 0
81,920 4.00 858,717.79 0.00 100.00 0
122,880 6.00 858,717.79 0.00 100.00 0
163,840 8.00 858,717.79 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,024 0.40 299 13,520 2,353,193 1.00 6,441 5.88 183,211,262
1,280 0.50 523 16,756 2,355,686 1.00 3,948 3.60 183,395,087
1,536 0.60 778 20,398 2,358,012 1.00 1,622 1.48 183,566,756
1,792 0.70 1,032 24,349 2,358,464 1.00 1,170 1.07 183,602,492
2,048 0.80 1,275 30,769 2,358,533 1.00 1,101 1.00 183,608,390
2,304 0.90 1,442 35,634 2,358,538 1.00 1,096 1.00 183,608,976
2,560 1.00 1,505 36,928 2,358,538 1.00 1,096 1.00 183,609,059
2,816 1.10 1,536 37,930 2,358,538 1.00 1,096 1.00 183,609,083
3,072 1.20 1,536 37,930 2,358,538 1.00 1,096 1.00 183,609,083
3,328 1.30 1,536 37,930 2,358,538 1.00 1,096 1.00 183,609,083
3,584 1.40 1,536 37,930 2,358,538 1.00 1,096 1.00 183,609,083
3,840 1.50 1,536 37,930 2,358,538 1.00 1,096 1.00 183,609,083
4,096 1.60 1,536 37,930 2,358,538 1.00 1,096 1.00 183,609,083
4,352 1.70 1,536 37,930 2,358,538 1.00 1,096 1.00 183,609,083
4,608 1.80 1,536 37,930 2,358,538 1.00 1,096 1.00 183,609,083
4,864 1.90 1,536 37,930 2,358,538 1.00 1,096 1.00 183,609,083
5,120 2.00 1,536 37,930 2,358,538 1.00 1,096 1.00 183,609,083

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 33,070  
10,240 0.50 33,070  
15,360 0.75 33,071  
20,480 1.00 33,070  
25,600 1.25 33,071  
30,720 1.50 33,071  
35,840 1.75 33,071  
40,960 2.00 33,075  

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 11 285 1,057 1.00 1,096 1.00 17,771
32 0.50 11 285 1,057 1.00 1,096 1.00 17,771
48 0.75 11 285 1,057 1.00 1,096 1.00 17,771
64 1.00 11 285 1,057 1.00 1,096 1.00 17,771
80 1.25 11 285 1,057 1.00 1,096 1.00 17,771
96 1.50 11 285 1,057 1.00 1,096 1.00 17,771
112 1.75 11 285 1,057 1.00 1,096 1.00 17,771
128 2.00 11 285 1,057 1.00 1,096 1.00 17,771

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 428,278 73 0
undo block 208,799 5 0
undo header 42,013 1 0
1st level bmb 5,278 0 0
segment header 2,550 0 0
2nd level bmb 900 0 0
file header block 85 0 1
extent map 10 0 0
bitmap index block 1 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)
TX-Transaction (row lock contention) 6,455 590 5,865 570 140 245.40
UL-User-defined 68,198 67,177 1,021 1,438 20 13.82
TX-Transaction (index contention) 24,951 24,951 0 22,592 12 0.52
RO-Multiple Object Reuse (fast object reuse) 288 288 0 31 6 193.87
TM-DML 2,003,309 2,003,276 0 6 4 646.67
HW-Segment High Water Mark 255,180 255,177 3 2,170 1 0.62
TX-Transaction 1,262,042 1,262,046 0 1,852 1 0.43
DV-Diana Versioning 29,103 29,103 0 184 1 3.26
SQ-Sequence Cache 41,198 41,198 0 2,899 1 0.18
FB-Format Block 36,116 36,116 0 462 0 0.28
TX-Transaction (allocate ITL entry) 209 209 0 137 0 0.36
PS-PX Process Reservation 1,864 1,544 320 39 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,520.49 1,237,220 2,504 346   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
06-May 06:27 154,255 152,778 440 342 205 0/0 0/0/0/0/0/0
06-May 06:17 72,516 119,584 741 336 204 0/0 0/0/0/0/0/0
06-May 06:07 452,894 197,729 2,504 336 190 0/0 0/0/0/0/0/0
06-May 05:57 362,976 263,729 2,480 343 245 0/0 0/0/0/0/0/0
06-May 05:47 411,938 379,744 2,459 346 337 0/0 0/0/0/0/0/0
06-May 05:37 65,913 123,656 1,856 341 896 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,468 0.00   0 0  
AWR Alerted Metric Element list 305,814 0.00   0 0  
Consistent RBA 814,635 0.06 0.23 0 0  
FOB s.o list latch 50,291 0.01 0.00 0 0  
In memory undo latch 778,699,019 1.60 0.00 6 1,181,112 0.00
JOX SGA heap latch 1,923,593 0.00   0 0  
JS queue state obj latch 21,630 0.00   0 0  
JS slv state obj latch 183 0.00   0 0  
KMG MMAN ready and startup request latch 3,391 0.00   0 0  
KMG resize request state object freelist 24 0.00   0 0  
KTF sga latch 12 0.00   0 1,214 0.00
KWQMN job cache list latch 13,693 0.21 0.90 0 0  
MQL Tracking Latch 0     0 72 0.00
Memory Management Latch 2,385 0.00   0 3,378 0.00
OS process 14,145 0.00   0 0  
OS process allocation 10,649 0.00   0 0  
OS process: request allocation 9,168 0.00   0 0  
PL/SQL warning settings 4,259,615 0.00   0 0  
SGA IO buffer pool latch 31,438 0.06 0.00 0 31,926 0.24
SQL memory manager latch 1 0.00   0 1,199 0.00
SQL memory manager workarea list latch 6,597,867 0.01 0.02 0 0  
Shared B-Tree 128 0.00   0 0  
active checkpoint queue latch 1,490,741 0.78 0.00 0 2 0.00
active service list 45,304 0.06 0.00 0 1,282 0.00
begin backup scn array 133 0.00   0 0  
buffer pool 20 0.00   0 0  
cache buffer handles 20,124,012 1.26 0.00 0 0  
cache buffers chains 4,826,676,779 1.01 0.02 29 18,030,381 2.42
cache buffers lru chain 9,826,395 0.36 0.05 1 36,022,880 0.48
cache table scan latch 2,113 0.00   0 2,113 0.00
channel handle pool latch 374,006 0.12 0.02 0 0  
channel operations parent latch 1,593,242 0.50 0.00 0 0  
checkpoint queue latch 21,092,556 0.01 0.01 0 3,074,770 0.03
client/application info 1,632,863 0.00 0.00 0 0  
commit callback allocation 80,063 0.00 0.00 0 0  
compile environment latch 2,841,382 0.00   0 0  
dictionary lookup 80 0.00   0 0  
dml lock allocation 3,991,099 0.17 0.01 0 0  
dummy allocation 18,628 0.18 0.00 0 0  
enqueue hash chains 8,744,442 0.06 0.01 0 537 0.19
enqueues 4,915,185 0.11 0.01 0 0  
error message lists 816 0.98 0.00 0 0  
event group latch 4,593 0.00   0 0  
file cache latch 21,180 0.00   0 0  
global KZLD latch for mem in SGA 8,805 0.00   0 0  
global ctx hash table latch 22,057 0.00   0 0  
hash table column usage latch 1,921 0.00   0 13,928,926 0.00
hash table modification latch 145 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 29,164 0.01 0.00 0 0  
ksuosstats global area 242 0.00   0 0  
ktm global data 133,298 0.00   0 0  
kwqbsn:qsga 128 0.00   0 0  
lgwr LWN SCN 817,273 0.12 0.02 0 0  
library cache 326,878,826 0.34 0.01 5 20,320 0.74
library cache load lock 10,849 0.41 0.00 0 29 0.00
library cache lock 54,257,475 0.05 0.01 0 0  
library cache lock allocation 1,407,077 0.01 0.04 0 0  
library cache pin 203,849,511 0.11 0.01 1 67 0.00
library cache pin allocation 490,675 0.00 0.00 0 0  
list of block allocation 444,346 0.01 0.00 0 0  
loader state object freelist 290,376 0.00 0.00 0 0  
longop free list parent 33 0.00   0 33 0.00
message pool operations parent latch 379,770 0.01 0.07 0 0  
messages 6,477,944 0.44 0.01 0 0  
mostly latch-free SCN 864,109 4.14 0.05 1 0  
multiblock read objects 26,538 0.00 0.00 0 0  
ncodef allocation latch 192 0.00   0 0  
object queue header heap 4,190,454 0.03 0.17 0 361,914 0.07
object queue header operation 34,751,079 0.15 0.40 2 19,550 1.22
object stats modification 371,802 0.02 0.00 0 0  
parallel query alloc buffer 8,156 0.83 0.00 0 0  
parallel query stats 528 13.26 0.00 0 0  
parameter table allocation management 21,960 1.14 0.45 0 0  
post/wait queue 1,216,663 0.05 0.02 0 495,020 0.01
process allocation 9,216 0.15 0.64 0 4,592 0.02
process group creation 9,168 0.00   0 0  
process queue 5,030 0.85 0.00 0 0  
process queue reference 774,153 0.05 0.00 0 84,313 3.56
qmn task queue latch 512 0.00   0 0  
query server freelists 4,256 5.38 0.00 0 0  
query server process 8 0.00   0 8 0.00
redo allocation 5,325,622 2.62 0.01 1 100,857,373 2.03
redo copy 0     0 101,053,376 0.05
redo writing 4,353,191 0.36 0.01 0 0  
resmgr group change latch 774,555 0.00   0 0  
resmgr:actses active list 27,404 0.51 0.98 0 0  
resmgr:actses change group 26,805 0.00   0 0  
resmgr:free threads list 18,626 0.20 0.00 0 0  
resmgr:schema config 1 0.00   0 0  
row cache objects 115,899,453 0.20 0.00 0 5,878 0.15
rules engine aggregate statistics 37,940 0.00   0 0  
rules engine rule set statistics 122,317 0.00 0.00 0 0  
rules engine rule statistics 46,437 0.00   0 0  
sequence cache 16,199,414 0.42 0.00 0 0  
session allocation 18,630,131 0.45 0.01 0 0  
session idle bit 92,709,755 0.01 0.02 0 0  
session state list latch 53,798 0.12 0.62 0 0  
session switching 13,717 0.00   0 0  
session timer 1,282 0.00   0 0  
shared pool 7,417,384 0.15 0.06 0 0  
shared pool sim alloc 375 0.00   0 0  
shared pool simulator 1,687,145 0.00 0.00 0 0  
sim partition latch 1 0.00   0 22,940 0.10
simulator hash latch 2,460 0.00   0 0  
simulator lru latch 1,380 0.00   0 0  
slave class 1 0.00   0 0  
slave class create 4 0.00   0 0  
sort extent pool 1,276,012 0.13 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 237 0.00   0 0  
temporary table state object allocation 11,459 0.00   0 0  
threshold alerts latch 615 0.00   0 0  
trace latch 33 0.00   0 0  
transaction allocation 106,251 0.00   0 0  
transaction branch allocation 192 0.00   0 0  
undo global data 981,988,827 0.85 0.00 5 16,110 0.02
user lock 35,314 0.02 0.17 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,826,676,779 48,613,119 1,201,585 47,569,342 0 0 0
In memory undo latch 778,699,019 12,462,079 24,439 12,441,047 0 0 0
undo global data 981,988,827 8,391,718 8,166 8,384,794 0 0 0
library cache 326,878,826 1,112,813 9,055 1,104,693 0 0 0
cache buffer handles 20,124,012 254,526 194 254,370 0 0 0
row cache objects 115,899,453 236,608 742 235,912 0 0 0
library cache pin 203,849,511 221,764 2,530 219,493 0 0 0
redo allocation 5,325,622 139,420 1,047 138,555 0 0 0
session allocation 18,630,131 83,026 563 82,517 0 0 0
sequence cache 16,199,414 68,691 65 68,640 0 0 0
object queue header operation 34,751,079 51,366 20,565 32,490 0 0 0
mostly latch-free SCN 864,109 35,744 1,836 34,086 0 0 0
cache buffers lru chain 9,826,395 34,978 1,623 33,440 0 0 0
library cache lock 54,257,475 28,649 156 28,501 0 0 0
messages 6,477,944 28,557 231 28,335 0 0 0
redo writing 4,353,191 15,532 108 15,426 0 0 0
active checkpoint queue latch 1,490,741 11,654 14 11,640 0 0 0
session idle bit 92,709,755 11,212 242 10,974 0 0 0
shared pool 7,417,384 10,967 660 10,371 0 0 0
channel operations parent latch 1,593,242 7,902 13 7,890 0 0 0
dml lock allocation 3,991,099 6,727 60 6,672 0 0 0
enqueues 4,915,185 5,285 56 5,236 0 0 0
enqueue hash chains 8,744,442 5,117 26 5,093 0 0 0
checkpoint queue latch 21,092,556 3,051 39 3,015 0 0 0
sort extent pool 1,276,012 1,633 12 1,621 0 0 0
object queue header heap 4,190,454 1,121 192 945 0 0 0
lgwr LWN SCN 817,273 996 21 976 0 0 0
post/wait queue 1,216,663 614 11 603 0 0 0
Consistent RBA 814,635 495 112 403 0 0 0
channel handle pool latch 374,006 460 7 453 0 0 0
SQL memory manager workarea list latch 6,597,867 361 6 356 0 0 0
parameter table allocation management 21,960 251 114 141 0 0 0
resmgr:actses active list 27,404 140 137 5 0 0 0
library cache lock allocation 1,407,077 104 4 101 0 0 0
session state list latch 53,798 63 39 24 0 0 0
KWQMN job cache list latch 13,693 29 26 3 0 0 0
message pool operations parent latch 379,770 28 2 27 0 0 0
process allocation 9,216 14 9 5 0 0 0
user lock 35,314 6 1 5 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 15,071 17,391
In memory undo latch ktiFlush: child 0 5,201 3,035
In memory undo latch kticmt: child 0 3,582 696
In memory undo latch ktichg: child 0 425 3,241
In memory undo latch ktiTxnPoolFree 0 147 0
In memory undo latch ktiBRacquire 0 9 0
In memory undo latch ktbgfc 0 4 86
KWQMN job cache list latch kwqmnuji: update job item 0 27 1
SQL memory manager workarea list latch qesmmIRegisterWorkArea 0 6 5
active checkpoint queue latch kcbbacq: scan active checkpoints 0 14 14
active service list ksws_event: ksws event 0 1 1
cache buffer handles kcbzgs 0 131 112
cache buffer handles kcbzfs 0 63 83
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 1,452,918 1,664,729
cache buffers chains kcbgtcr: fast path 0 629,642 25,543
cache buffers chains kcbchg: kslbegin: call CR func 0 532,654 1,101,650
cache buffers chains kcbgtcr: kslbegin excl 0 131,116 55,709
cache buffers chains kcbzgb: scan from tail. nowait 0 123,465 0
cache buffers chains kcbrls: kslbegin 0 41,855 80,812
cache buffers chains kcbgcur: kslbegin 0 27,366 13,702
cache buffers chains kcbget: pin buffer 0 19,826 8,177
cache buffers chains kcbzwb 0 6,155 4,466
cache buffers chains kcbcge 0 3,355 6,179
cache buffers chains kcbget: exchange rls 0 2,429 2,676
cache buffers chains kcbget: exchange 0 1,676 4,247
cache buffers chains kcbnlc 0 307 1,468
cache buffers chains kcbbxsv 0 194 190
cache buffers chains kcb_is_private 0 145 1,840
cache buffers chains kcbgtcr: kslbegin shared 0 102 87
cache buffers chains kcbesc: escalate 0 68 37
cache buffers chains kcbnew: new latch again 0 67 9
cache buffers chains kcbso1: set no access 0 51 48
cache buffers chains kcb_pre_apply: kcbhq61 0 36 1,649
cache buffers chains kcb_post_apply: kcbhq63 0 16 251
cache buffers chains kcbbic2 0 10 5
cache buffers chains kcbzib: finish free bufs 0 8 3
cache buffers chains kcb_post_apply: kcbhq62 0 6 344
cache buffers chains kcbzib: multi-block read: nowait 0 2 0
cache buffers chains kcbgtcr 0 1 0
cache buffers chains kcbo_ivd_process 0 1 38
cache buffers chains kcbw_next_free 0 1 0
cache buffers chains kcbzhngcbk1: get hash chain latch no wait 0 1 0
cache buffers chains kcbzib: exchange rls 0 1 0
cache buffers lru chain kcbzgws 0 887 0
cache buffers lru chain kcbbxsv: move to being written 0 272 564
cache buffers lru chain kcbo_link_q 0 188 13
cache buffers lru chain kcbgtcr:CR Scan:KCBRSKIP 0 129 0
cache buffers lru chain kcbzgb: posted for free bufs 0 50 369
cache buffers lru chain kcbo_ivd_proc 0 38 278
cache buffers lru chain kcbbic2 0 29 291
cache buffers lru chain kcbzswcu 0 26 64
cache buffers lru chain kcbzgpwb: KSLBEGIN use prewarm buffers 0 3 27
cache buffers lru chain kcbzfw 0 1 1
channel handle pool latch ksrchconnect() 0 9 9
channel handle pool latch ksrchdelete() 0 6 6
channel operations parent latch ksrapublish() 0 28 6
channel operations parent latch ksrchdelete() 0 19 14
channel operations parent latch ksrsconsume() 0 8 9
channel operations parent latch ksrmfree() 0 7 1
channel operations parent latch ksrchconnect() 0 3 12
channel operations parent latch ksrwait() 0 3 26
checkpoint queue latch kcbkubc 0 21 17
checkpoint queue latch kcbbwthc: thread checkpoint buffers 0 11 18
checkpoint queue latch kcbklbc: Link buffer into ckpt queue 0 5 2
checkpoint queue latch kcbswcu: Switch buffers 0 2 2
client/application info kqp327i 0 1 1
cost function kzulrl 0 1 1
dml lock allocation ktaiam 0 44 44
dml lock allocation ktaidm 0 16 16
enqueue hash chains ksqgtl3 0 15 16
enqueue hash chains ksqrcl 0 10 9
enqueue hash chains ksqcmi: get hash chain latch after wait 0 1 1
enqueues ksqies 0 22 26
enqueues ksqgel: create enqueue 0 21 23
enqueues ksqdel 0 13 7
lgwr LWN SCN kcs023 0 495 0
library cache kglpndl: child: after processing 0 3,557 73
library cache kglpnp: child 0 3,174 4,813
library cache kglobpn: child: 0 806 1,352
library cache kglpndl: child: before processing 0 537 2,164
library cache kglLockCursor 0 229 293
library cache kglScanDependency 0 189 0
library cache kglhdgn: child: 0 92 135
library cache kglpin 0 81 33
library cache kgldte: child 0 0 75 157
library cache kglic 0 31 0
library cache kgldti: 2child 0 16 5
library cache kglhdiv: child 0 7 0
library cache kglivl: child 0 6 0
library cache kglupd: child 0 3 0
library cache kglget: unpin heap 0 0 1 1
library cache kglhdgh: child: 0 1 1
library cache kglukp: child 0 1 0
library cache lock kgllkdl: child: cleanup 0 85 97
library cache lock kgllkdl: child: no lock handle 0 79 17
library cache lock kgllkal: child: multiinstance 0 71 57
library cache lock allocation kgllkget 0 4 4
library cache pin kglpndl 0 1,183 679
library cache pin kglpnp: child 0 1,143 1,474
library cache pin kglpnal: child: alloc space 0 203 376
library cache pin kglpnck 0 1 1
message pool operations parent latch ksrmalloc() 0 3 2
messages ksaamb: after wakeup 0 80 109
messages ksarcv: after wait 0 78 104
messages ksarcv 0 73 15
mostly latch-free SCN kcslcu3 0 1,342 1,857
mostly latch-free SCN kcs01 0 62 114
mostly latch-free SCN kcsnew_scn_rba 0 50 0
mostly latch-free SCN kcs024 0 20 0
object queue header heap kcbo_link_q:reget 0 184 3
object queue header heap kcbw_link_q:alloc 0 7 189
object queue header heap kcbw_unlink_q 0 1 0
object queue header operation kcbo_ivbo 0 21,422 5,519
object queue header operation kcbw_link_q 0 3,601 1,939
object queue header operation kcbw_unlink_q 0 1,056 6,200
object queue header operation kcbo_switch_mq_bg 0 302 3,079
object queue header operation kcbo_switch_q_bg 0 284 2,292
object queue header operation kcbo_switch_cq 0 121 2,913
object queue header operation kcbo_link_q:reget 0 88 134
object queue header operation kcbo_write_q 0 24 16
object queue header operation kcbo_swap_buf_bg 0 20 4,624
object queue header operation kcbo_service_ockpt 0 19 0
object queue header operation kcbo_swap_buf 0 7 505
object queue header operation kcbw_unlink_q_bg 0 2 12
parameter table allocation management ksp_param_table_free 0 114 114
post/wait queue ksliwat:remove 0 10 10
post/wait queue kslpstevent:get 0 1 1
process allocation ksucrp 0 7 0
process allocation ksudlp 0 2 6
redo allocation kcrfw_redo_gen: redo allocation 1 0 655 0
redo allocation kcrfw_redo_gen: redo allocation 3 0 223 881
redo allocation kcrfw_redo_write: before write 0 79 104
redo allocation kcrfw_redo_write: more space 0 47 72
redo allocation kcrfw_redo_gen: redo allocation 2 0 43 0
redo writing kcrfw_post: after write 0 39 0
redo writing kcrfw_post: rba scn pair 0 36 0
redo writing kcrfwcr 0 25 108
redo writing kcrfw_cal_target_rba 0 8 0
resmgr:actses active list kgskchclass 0 137 83
row cache objects kqreqd: reget 0 568 5
row cache objects kqrpre: find obj 0 128 602
row cache objects kqreqd 0 42 135
row cache objects kqrso 0 2 0
sequence cache kdnssd 0 46 1
sequence cache kdnnxt: cached seq 0 14 0
sequence cache kdnss 0 5 66
session allocation ksuxds: KSUSFCLC not set 0 210 31
session allocation ksuprc 0 105 118
session allocation ksuxds: not user session 0 75 71
session allocation ksucri 0 68 193
session allocation ksudlc 0 57 104
session allocation kspallmod 0 17 0
session allocation kxfpqidqr 0 10 26
session allocation ksudlp 0 8 0
session allocation ksursi 0 8 17
session allocation kxfprdp 0 4 3
session allocation ksucrp 0 1 0
session idle bit ksupuc: set busy 0 284 111
session idle bit ksupuc: clear busy 0 106 272
session idle bit ksuxds 0 9 16
session state list latch kpseqd 0 37 0
session state list latch kpscad 0 1 0
session state list latch kpscdl 0 1 17
shared pool kghupr1 0 357 461
shared pool kghalo 0 242 95
shared pool kghfrunp: clatch: nowait 0 162 0
shared pool kghfrunp: alloc: wait 0 29 0
shared pool kghfre 0 26 86
shared pool kghfrunp: clatch: wait 0 10 11
shared pool kghalp 0 6 16
sort extent pool ktstdt: dealloc sort extent 0 9 0
sort extent pool ktstaddextent1 0 2 0
sort extent pool ktstcrtobj 0 1 0
undo global data kturimugur: child 0 7,263 4,874
undo global data ktudba: KSLBEGIN 0 862 3,268
undo global data ktucof: at start 0 14 0
undo global data ktudnx:child 0 12 11
undo global data ktufrbs: child 0 9 12
undo global data ktubnd:child 0 6 1

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,399,696 3.08
INV APPS_TS_TX_IDX MTL_ITEM_CATEGORIES_U1   INDEX 50,591,856 2.50
ONT APPS_TS_TX_DATA OE_ORDER_LINES_ALL   TABLE 23,164,368 1.14
ICX APPS_TS_TX_DATA ICX_SESSION_ATTRIBUTES   TABLE 20,817,824 1.03
WSH APPS_TS_TX_DATA WSH_DELIVERY_DETAILS   TABLE 19,690,672 0.97

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,017 7.97
AR APPS_ASSM_DATA RA_CUSTOMER_TRX_LINES_ALL   TABLE 13,110 2.98
WSH APPS_TS_TX_DATA WSH_DELIVERY_DETAILS   TABLE 9,554 2.18
HR APPS_TS_TX_IDX PAY_PERSON_LATEST_BALA_N50   INDEX 4,777 1.09
HR APPS_ASSM_DATA PAY_RUN_RESULTS   TABLE 4,048 0.92

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 13,955 31.54
WSH APPS_TS_TX_DATA WSH_TRIP_STOPS   TABLE 11,202 25.32
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_U1   INDEX 8,934 20.19
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N6   INDEX 2,763 6.24
HR APPS_ASSM_IDX PAY_RUN_RESULT_VALUES_PK   INDEX 1,677 3.79

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 26 21.85
GL APPS_ASSM_IDX GL_IMPORT_REFERENCES_N1   INDEX 25 21.01
APPLSYS APPS_TS_TX_IDX WF_ITEM_ATTRIBUTE_VALUES_PK   INDEX 16 13.45
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N5   INDEX 14 11.76
SYS SYSTEM SEG$   TABLE 13 10.92

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 132,600 36.61
APPLSYS APPS_TS_TX_DATA WF_ITEM_ATTRIBUTE_VALUES   TABLE 72,775 20.09
SYS SYSTEM DBMS_LOCK_ALLOCATED   TABLE 20,591 5.69
GL APPS_ASSM_DATA GL_JE_LINES   TABLE 17,881 4.94
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N6   INDEX 17,363 4.79

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,062,970 0.00 0   0 48
dc_histogram_data 61,984 2.16 0   0 612
dc_histogram_defs 382,682 3.11 0   4,044 2,073
dc_object_grants 65,567 0.09 0   0 76
dc_object_ids 11,402,996 0.02 0   58 1,093
dc_objects 165,924 1.22 0   347 802
dc_profiles 8,866 0.00 0   0 1
dc_rollback_segments 19,342 0.00 0   0 353
dc_segments 335,341 0.76 0   15,598 1,357
dc_sequences 51,259 0.16 0   51,259 110
dc_table_scns 19,384 0.04 0   0 5
dc_tablespace_quotas 15,463 0.14 0   211 40
dc_tablespaces 5,439,479 0.00 0   0 21
dc_usernames 466,245 0.00 0   0 19
dc_users 13,676,873 0.00 0   0 63
outstanding_alerts 279 2.87 0   11 43


Back to Top

 

Library Cache Activity

Namespace Get Requests Pct Miss Pin Requests Pct Miss Reloads Invali- dations
BODY 574,403 0.02 39,097,210 0.00 16 0
CLUSTER 124 0.81 290 1.72 4 0
INDEX 14,285 0.45 15,096 0.62 0 0
JAVA DATA 626 0.00 0   0 0
PIPE 45,444 2.54 66,869 1.73 0 0
SQL AREA 6,285 88.23 106,916,002 0.42 3,721 512
TABLE/PROCEDURE 370,176 0.28 53,412,075 0.01 1,285 0
TRIGGER 26,261 0.10 1,357,901 0.01 25 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 34,351.85   12.16 7.17 38 38 2,824 2,824
  Freeable 3,421.63 0.00 1.37 0.83 9   2,497 2,497
  SQL 3,224.30 1,652.93 1.14 0.72 4 21 2,816 2,815
  PL/SQL 2,196.59 175.41 0.78 0.96 3 3 2,824 2,824
  JAVA 243.73 242.60 2.26 0.33 5 8 108 108
E Other 39,695.14   13.97 8.63 41 41 2,842 2,842
  Freeable 3,834.00 0.00 1.50 0.93 9   2,551 2,551
  SQL 3,643.29 1,902.13 1.29 0.77 5 21 2,834 2,833
  PL/SQL 2,515.84 196.46 0.89 0.99 3 3 2,842 2,842
  JAVA 244.23 243.09 2.26 0.33 5 8 108 108

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions Begin Size (Bytes) End Size (Bytes) (if different)
Database Buffers 18,857,590,784 18,689,818,624
Fixed Size 2,111,120  
Redo Buffers 14,663,680  
Variable Size 2,600,470,896 2,768,243,056

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 34.66 35.23 1.66
shared KTI-UNDO 53.19 53.19 0.00
shared PL/SQL MPCODE 66.50 68.84 3.53
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 324.24 344.65 6.30
shared library cache 786.12 916.79 16.62
shared parameter table block 52.40 52.55 0.29
shared private strands 99.77 99.77 0.00
shared sessions 36.42 36.42 0.00
shared sql area 333.00 337.32 1.30
shared trace buffer 44.17 44.69 1.17
  buffer_cache 17,984.00 17,824.00 -0.89
  fixed_sga 2.01 2.01 0.00
  log_buffer 13.98 13.98 0.00

Back to Memory Statistics
Back to Top

 

Streams Statistics

Back to Top

 

Streams CPU/IO Usage

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

Rule Set

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

 

Resource Limit Stats

No data exists for this section of the report.


Back to Top

 

init.ora Parameters

Parameter 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