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 12-Oct-08 06:54:16 5248 209.7
End Snap: 2 12-Oct-08 07:54:20 5279 233.7
Elapsed:   60.07 (mins)    
DB Time:   402.20 (mins)    

 

Report Summary

Cache Sizes

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

Load Profile

  Per Second Per Transaction
Redo size: 8,965,674.41 25,811.01
Logical reads: 603,590.49 1,737.66
Block changes: 55,951.78 161.08
Physical reads: 126.25 0.36
Physical writes: 876.75 2.52
User calls: 13,804.32 39.74
Parses: 2,559.98 7.37
Hard parses: 2.60 0.01
Sorts: 3,061.58 8.81
Logons: 2.83 0.01
Executes: 29,127.33 83.85
Transactions: 347.36  

% Blocks changed per Read: 9.27 Recursive Call %: 77.32
Rollback per transaction %: 21.17 Rows per Sort: 12.33

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.21 Latch Hit %: 99.07
Parse CPU to Parse Elapsd %: 89.50 % Non-Parse CPU: 97.75

Shared Pool Statistics

  Begin End
Memory Usage %: 86.77 86.99
% SQL with executions>1: 88.86 89.86
% Memory for SQL w/exec>1: 65.62 66.52

Top 5 Timed Events

Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class
CPU time   21,827   90.4  
db file sequential read 288,326 1,193 4 4.9 User I/O
log file sync 564,710 1,039 2 4.3 Commit
log file parallel write 845,228 518 1 2.1 System I/O
db file parallel write 263,319 237 1 1.0 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 21,826.70 90.45
sql execute elapsed time 20,354.04 84.34
PL/SQL execution elapsed time 4,871.72 20.19
inbound PL/SQL rpc elapsed time 4,655.40 19.29
parse time elapsed 620.36 2.57
Java execution elapsed time 516.68 2.14
hard parse elapsed time 333.01 1.38
repeated bind elapsed time 91.46 0.38
sequence load elapsed time 14.50 0.06
connection management call elapsed time 10.73 0.04
PL/SQL compilation elapsed time 7.34 0.03
hard parse (sharing criteria) elapsed time 4.37 0.02
failed parse elapsed time 1.59 0.01
hard parse (bind mismatch) elapsed time 1.10 0.00
DB time 24,132.24  
background elapsed time 1,228.46  
background cpu time 392.53  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait Class Waits %Time -outs Total Wait Time (s) Avg wait (ms) Waits /txn
User I/O 340,388 0.00 1,342 4 0.27
Commit 564,710 0.00 1,039 2 0.45
System I/O 1,139,449 0.00 767 1 0.91
Network 56,742,775 0.00 224 0 45.32
Concurrency 1,825,463 0.24 181 0 1.46
Application 70,759 0.06 166 2 0.06
Other 135,593 18.81 48 0 0.11
Configuration 6,576 0.00 3 0 0.01

Back to Wait Events Statistics
Back to Top

Wait Events

Event Waits %Time -outs Total Wait Time (s) Avg wait (ms) Waits /txn
db file sequential read 288,326 0.00 1,193 4 0.23
log file sync 564,710 0.00 1,039 2 0.45
log file parallel write 845,228 0.00 518 1 0.68
db file parallel write 263,319 0.00 237 1 0.21
SQL*Net more data from client 2,573,124 0.00 155 0 2.06
enq: TX - row lock contention 696 3.59 96 138 0.00
db file scattered read 12,612 0.00 82 7 0.01
read by other session 36,504 0.00 64 2 0.03
SQL*Net message to client 52,124,870 0.00 53 0 41.63
enq: UL - contention 2,425 0.58 52 21 0.00
latch: cache buffers chains 1,064,936 0.00 50 0 0.85
cursor: pin S wait on X 4,719 92.27 48 10 0.00
buffer busy waits 670,862 0.00 30 0 0.54
SQL*Net more data to client 2,044,781 0.00 17 0 1.63
SQL*Net break/reset to client 67,604 0.00 14 0 0.05
library cache load lock 573 0.00 12 22 0.00
latch: In memory undo latch 34,220 0.00 12 0 0.03
enq: TX - index contention 27,898 0.00 11 0 0.02
control file sequential read 29,164 0.00 11 0 0.02
PX Deq Credit: send blkd 24,269 0.00 11 0 0.02
latch: library cache 12,067 0.00 10 1 0.01
rdbms ipc reply 5 60.00 8 1589 0.00
latch: undo global data 13,765 0.00 8 1 0.01
enq: RO - fast object reuse 31 0.00 5 153 0.00
LGWR wait for redo copy 33,643 0.01 4 0 0.03
latch: object queue header operation 20,956 0.00 3 0 0.02
PX Deq: Signal ACK 267 35.21 3 11 0.00
kksfbc child completion 65 86.15 3 43 0.00
latch: library cache pin 3,293 0.00 2 1 0.00
os thread startup 70 0.00 2 33 0.00
local write wait 1,702 0.00 2 1 0.00
latch: cache buffers lru chain 1,816 0.00 2 1 0.00
enq: HW - contention 2,380 0.00 2 1 0.00
control file parallel write 1,738 0.00 1 1 0.00
enq: DV - contention 184 0.00 1 6 0.00
buffer deadlock 25,349 98.80 1 0 0.02
latch: row cache objects 1,026 0.00 1 1 0.00
enq: TX - contention 2,726 0.00 1 0 0.00
latch: redo allocation 1,262 0.00 1 1 0.00
latch free 1,130 0.00 1 1 0.00
enq: SQ - contention 3,985 0.00 1 0 0.00
library cache pin 2,020 0.00 1 0 0.00
latch: session allocation 891 0.00 0 1 0.00
wait list latch free 42 0.00 0 12 0.00
log buffer space 74 0.00 0 7 0.00
row cache lock 2,585 0.00 0 0 0.00
direct path read 732 0.00 0 0 0.00
SGA: allocation forcing component growth 31 51.61 0 10 0.00
latch: shared pool 784 0.00 0 0 0.00
cursor: pin S 7,252 0.00 0 0 0.01
latch: library cache lock 200 0.00 0 1 0.00
latch: object queue header heap 268 0.00 0 1 0.00
latch: cache buffer handles 281 0.00 0 1 0.00
enq: FB - contention 781 0.00 0 0 0.00
enq: TX - allocate ITL entry 84 0.00 0 1 0.00
enq: TM - contention 3 0.00 0 23 0.00
latch: messages 117 0.00 0 0 0.00
latch: enqueue hash chains 39 0.00 0 1 0.00
latch: redo writing 46 0.00 0 1 0.00
PX qref latch 349 84.53 0 0 0.00
write complete waits 7 0.00 0 4 0.00
reliable message 32 0.00 0 1 0.00
latch: checkpoint queue latch 39 0.00 0 1 0.00
enq: CU - contention 3 0.00 0 6 0.00
cursor: mutex S 119 0.00 0 0 0.00
enq: PS - contention 29 0.00 0 0 0.00
direct path write 440 0.00 0 0 0.00
direct path write temp 52 0.00 0 0 0.00
cursor: mutex X 91 0.00 0 0 0.00
direct path read temp 20 0.00 0 0 0.00
L1 validation 2 0.00 0 0 0.00
SQL*Net message from client 52,124,829 0.00 10,080,153 193 41.63
pipe get 29,425 14.84 21,059 716 0.02
Streams AQ: waiting for time management or cleanup tasks 2,947 40.11 3,508 1190 0.00
Streams AQ: qmn slave idle wait 129 0.00 3,505 27170 0.00
Streams AQ: qmn coordinator idle wait 258 50.00 3,505 13585 0.00
PX Idle Wait 1,620 76.05 2,544 1570 0.00
PL/SQL lock timer 214 100.00 2,422 11318 0.00
jobq slave wait 614 99.67 1,798 2928 0.00
PX Deq: Execution Msg 5,130 0.00 39 8 0.00
PX Deq: Execute Reply 2,634 0.04 3 1 0.00
PX Deq: Table Q Normal 6,559 0.00 1 0 0.01
PX Deq Credit: need buffer 4,120 0.00 1 0 0.00
PX Deq: Msg Fragment 4,370 0.00 1 0 0.00
PX Deq: Parse Reply 220 0.00 0 1 0.00
PX Deq: Join ACK 288 0.00 0 0 0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

Event Waits %Time -outs Total Wait Time (s) Avg wait (ms) Waits /txn
log file parallel write 845,239 0.00 518 1 0.68
db file parallel write 263,319 0.00 237 1 0.21
events in waitclass Other 41,573 0.01 6 0 0.03
control file sequential read 827 0.00 3 4 0.00
db file scattered read 524 0.00 2 4 0.00
os thread startup 62 0.00 2 34 0.00
control file parallel write 1,738 0.00 1 1 0.00
db file sequential read 189 0.00 0 3 0.00
direct path read 732 0.00 0 0 0.00
latch: cache buffers chains 101 0.00 0 1 0.00
latch: redo writing 46 0.00 0 1 0.00
direct path write 333 0.00 0 0 0.00
log file sync 1 0.00 0 1 0.00
buffer busy waits 6 0.00 0 0 0.00
latch: library cache 3 0.00 0 0 0.00
latch: shared pool 1 0.00 0 0 0.00
enq: TX - index contention 1 0.00 0 0 0.00
rdbms ipc message 1,471,029 0.83 37,517 26 1.17
pmon timer 1,355 89.67 3,510 2590 0.00
Streams AQ: waiting for time management or cleanup tasks 2,947 40.11 3,508 1190 0.00
Streams AQ: qmn slave idle wait 129 0.00 3,505 27170 0.00
Streams AQ: qmn coordinator idle wait 258 50.00 3,505 13585 0.00
smon timer 155,770 0.00 3,502 22 0.12

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic Total
BUSY_TIME 2,340,446
IDLE_TIME 3,427,142
IOWAIT_TIME 86,124
NICE_TIME 0
SYS_TIME 105,856
USER_TIME 2,167,330
LOAD 5
RSRC_MGR_CPU_WAIT_TIME 0
PHYSICAL_MEMORY_BYTES 47,441,896
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,132.80 21,827.50 440,237 2,171,880,803
SYS$BACKGROUND 0.00 0.00 14,836 3,810,354
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 338599 133866 1825283 17856 0 0 56726516 22442
SYS$BACKGROUND 1783 293 174 218 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
778 756 305 2.55 3.23 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
489 442 112,954 0.00 2.03 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
393 381 1,442 0.27 1.63 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
393 387 57,209 0.01 1.63 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
374 368 57,209 0.01 1.55 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...
363 357 64,014 0.01 1.50 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
351 349 376,368 0.00 1.46 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
336 330 57,208 0.01 1.39 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
266 264 50,491 0.01 1.10 6ubqcscr1gk1b asnDispContainer.jsp select name, value from icx_s...
260 168 21,632 0.01 1.08 1q78dwnrrkf6c asn.lead.server.LeadUwqAM BEGIN ASN_SALES_PVT.Lead_Proce...
245 236 81,143 0.00 1.02 3prk3vg9u0abb FNDOAMCOL BEGIN FND_GLOBAL.APPS_INITIA...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

CPU Time (s) Elapsed Time (s) Executions CPU per Exec (s) % Total DB Time SQL Id SQL Module SQL Text
756 778 305 2.48 3.23 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
442 489 112,954 0.00 2.03 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
387 393 57,209 0.01 1.63 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
381 393 1,442 0.26 1.63 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
368 374 57,209 0.01 1.55 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...
357 363 64,014 0.01 1.50 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
349 351 376,368 0.00 1.46 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
330 336 57,208 0.01 1.39 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
264 266 50,491 0.01 1.10 6ubqcscr1gk1b asnDispContainer.jsp select name, value from icx_s...
236 245 81,143 0.00 1.02 3prk3vg9u0abb FNDOAMCOL BEGIN FND_GLOBAL.APPS_INITIA...
168 260 21,632 0.01 1.08 1q78dwnrrkf6c asn.lead.server.LeadUwqAM BEGIN ASN_SALES_PVT.Lead_Proce...

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
67,521,820 157,212 429.50 3.10 189.39 195.53 5kqw5535fjvw6 ARXTWMAI SELECT NVL(RCTT.ATTRIBUTE10, ...
47,778,840 57,209 835.16 2.20 387.35 393.10 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
44,057,728 305 144,451.57 2.03 756.00 778.30 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
40,732,914 1,442 28,247.51 1.87 381.18 393.17 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
40,531,517 12,882 3,146.37 1.86 108.95 110.68 by2f4fw8tac6r ARXTWMAI UPDATE RA_CUST_TRX_LINE_GL_DIS...
38,378,724 64,014 599.54 1.76 356.52 362.53 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
36,334,911 57,208 635.14 1.67 330.36 335.53 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
32,907,280 1,583,361 20.78 1.51 131.75 134.87 66tmsr3446uqn ap.oie.server.WebExpensesAM SELECT WIAS.ACTIVITY_STATUS, ...
30,158,201 57,209 527.16 1.39 368.43 374.48 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...
29,494,405 174,074 169.44 1.36 159.24 161.53 3b3psftuyks81 INVTTMTX BEGIN INV_TXNSTUB_PUB.postTran...
29,490,902 174,072 169.42 1.36 147.48 149.74 gf1u933c95jb5 INVTTMTX DECLARE l_ret_stat varchar2...
26,397,986 10,000 2,639.80 1.21 81.94 179.45 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
25,939,062 202,546 128.07 1.19 208.05 240.27 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
24,842,131 50,491 492.01 1.14 263.93 265.58 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,241 10,000 4.52 9.94 81.94 179.45 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
36,956 2,403 15.38 8.12 13.87 173.86 3dssuqfjsynrk asn.lead.server.LeadUwqAM SELECT count(1) FROM (SELECT *...
31,252 2,403 13.01 6.87 107.79 234.70 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
24,629 21,632 1.14 5.41 167.77 260.25 1q78dwnrrkf6c asn.lead.server.LeadUwqAM BEGIN ASN_SALES_PVT.Lead_Proce...
10,762 722 14.91 2.36 88.29 129.98 dk0sqcvc2xjvs qotSCopHdrUpd.jsp BEGIN ASO_QUOTE_PUB_W.Create_Q...
9,982 7,214 1.38 2.19 117.59 165.10 8jb36w62w5hqf ibuSRDetailsActions.jsp BEGIN IBU_REQ_PKG.UpdateServic...
9,946 202,546 0.05 2.19 208.05 240.27 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
4,595 10,000 0.46 1.01 129.63 143.40 csvvv0fmhr1yc PYUSLV BEGIN FFP1893_01010001.FORMULA...
1,445 100,962 0.01 0.32 120.40 124.65 7dtkxnqpkqszw jtfavald.jsp SELECT DISTINCT a.PERMISSION_...
1,180 361 3.27 0.26 148.55 154.02 fumydqvpk1g21 qotSCopOverview.jsp BEGIN ASO_QUOTE_PUB_W.SUBMIT_Q...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows Processed Rows per Exec CPU per Exec (s) Elap per Exec (s) SQL Id SQL Module SQL Text
1,583,361 818,323 0.52 0.00 0.00 66tmsr3446uqn ap.oie.server.WebExpensesAM SELECT WIAS.ACTIVITY_STATUS, ...
895,297 895,297 1.00 0.00 0.00 cd9mbmqyf4qhp ap.oie.server.WebExpensesAM UPDATE WF_ITEM_ACTIVITY_STATUS...
597,434 597,430 1.00 0.00 0.00 avc1jqzz04wpr JDBC Thin Client SELECT 'x' FROM DUAL
376,368 376,366 1.00 0.00 0.00 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
343,833 262,488 0.76 0.00 0.00 fmfdkztk8vx23   SELECT CATEGORY, SEVERITY, F...
291,434 4,954,301 17.00 0.00 0.00 cwyx16zn1hpfb JDBC Thin Client select parameter, value from ...
202,546 202,545 1.00 0.00 0.00 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
174,074 174,074 1.00 0.00 0.00 3b3psftuyks81 INVTTMTX BEGIN INV_TXNSTUB_PUB.postTran...
174,072 174,072 1.00 0.00 0.00 gf1u933c95jb5 INVTTMTX DECLARE l_ret_stat varchar2...
174,071 174,071 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
597,439 597,434 6.47 avc1jqzz04wpr JDBC Thin Client SELECT 'x' FROM DUAL
376,365 376,368 4.08 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
343,822 343,833 3.73 fmfdkztk8vx23   SELECT CATEGORY, SEVERITY, F...
291,436 291,434 3.16 cwyx16zn1hpfb JDBC Thin Client select parameter, value from ...
202,546 202,546 2.20 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
174,075 174,071 1.89 6gnth2mfbs2nq INVTTMTX declare v_ret number := 0...
125,250 125,248 1.36 fb13x9qx0ftks OEXOETEL begin OE_STANDARD_WF.OEOL_SELE...
120,438 120,439 1.31 162ttnv4ubqun OEXOETEL begin OE_DS_PVT.Check_PO_Appr...
116,865 116,865 1.27 1c0b7sas42w2z INVTTMTX SELECT NVL(ITEM_COST, 0), ...
111,419 111,419 1.21 8camsgjsr9zya OEXOETEL begin OE_TRANSACTION_TYPES_PK...
101,282 101,281 1.10 76sw2a4vnc89j icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.S...
95,287 95,287 1.03 608c0n36kaw62 icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.C...
95,287 95,285 1.03 bf7uwg5pa3pj6 icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.V...
95,287 101,280 1.03 dcvv68fju01g4 icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.E...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b) Executions % Total SQL Id SQL Module SQL Text
1,752,544 1,203 0.06 2nfc4vng01c8t POXPOVPO SELECT END_DATE, START_DATE, R...

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;
2nfc4vng01c8t SELECT END_DATE, START_DATE, ROW_ID, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, LAST_UPDATED_BY, PO_NUM, RELEASE_NUM, RELEASE_TYPE, REVISED_DATE, APPROVED_DATE, BILL_TO_LOCATION_ID, BILL_TO_LOCATION, AGENT_ID, VENDOR_SITE_ID, VENDOR_SITE_CODE, VENDOR_ID, VENDOR_NAME, VENDOR_CONTACT, AUTHORIZATION_STATUS, NEED_BY_DATE, REVISION_NUM, DOC_TYPE_NAME, GLOBAL_AGREEMENT_FLAG, OWNING_ORG_ID, TYPE_LOOKUP_CODE, ORDER_DATE, CURRENCY_CODE, TERMS_NAME, SHIP_VIA_LOOKUP_CODE, HEADER_FOB_LOOKUP_CODE, HEADER_FREIGHT_TERMS_LC, RATE_TYPE, RATE_DATE, RATE, PLL_NOTE_TO_RECEIVER, CONFIRMING_ORDER_FLAG, LINE_NUM, LINE_TYPE_ID, LINE_TYPE, ORDER_TYPE_LOOKUP_CODE, PURCHASE_BASIS, ITEM_ID, ITEM_REVISION, JOB_ID, CATEGORY_ID, ITEM_DESCRIPTION, UNIT_MEAS_LOOKUP_CODE, ALLOW_PRICE_OVERRIDE_FLAG, NOT_TO_EXCEED_PRICE, UN_NUMBER, HAZARD_CLASS, FROM_HEADER_ID, FROM_LINE_ID, FROM_LINE_LOCATION_ID, NOTE_TO_VENDOR, UNORDERED_FLAG, VENDOR_PRODUCT_NUM, CONTRACT_ID, MIN_RELEASE_AMOUNT, PO_HEADER_ID, PO_RELEASE_ID, CLOSED_BY, CANCELLED_BY, PO_LINE_ID, LINE_LOCATION_ID, SHIPMENT_NUM, CREATION_DATE, QUANTITY, QUANTITY_RECEIVED, QUANTITY_ACCEPTED, QUANTITY_REJECTED, QUANTITY_BILLED, QUANTITY_CANCELLED, AMOUNT, AMOUNT_RECEIVED, AMOUNT_BILLED, AMOUNT_CANCELLED, SHIP_TO_LOCATION_ID, SHIP_TO_LOCATION, PROMISED_DATE, LAST_ACCEPT_DATE, PRICE_OVERRIDE, ENCUMBERED_FLAG, TAXABLE_FLAG, TAX_NAME, CANCEL_FLAG, CANCEL_DATE, CANCEL_REASON, FIRM_STATUS_LOOKUP_CODE, MATCHING_TYPE, MATCH_OPTION, COUNTRY_OF_ORIGIN, QTY_RCV_TOLERANC E, QTY_RCV_EXCEPTION_CODE, ENFORCE_SHIP_TO_LOCATION_CODE, ALLOW_SUBSTITUTE_RECEIPTS_FLAG, DAYS_EARLY_RECEIPT_ALLOWED, DAYS_LATE_RECEIPT_ALLOWED, RECEIPT_DAYS_EXCEPTION_CODE, INVOICE_CLOSE_TOLERANCE, RECEIVE_CLOSE_TOLERANCE, SHIP_TO_ORGANIZATION_ID, SHIP_TO_ORGANIZATION, SOURCE_SHIPMENT_ID, SHIPMENT_TYPE, CLOSED_CODE, RECEIVING_ROUTING_ID, ROUTING_NAME, ACCRUE_ON_RECEIPT_FLAG, CLOSED_REASON, CLOSED_DATE, SOURCE_SHIPMENT_NUM, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, ATTRIBUTE_CATEGORY, USSGL_TRANSACTION_CODE, ACCEPTANCE_DUE_DATE, SECONDARY_UNIT_OF_MEASURE, SECONDARY_QUANTITY, PREFERRED_GRADE, SECONDARY_QUANTITY_RECEIVED, SECONDARY_QUANTITY_ACCEPTED, SECONDARY_QUANTITY_REJECTED, SECONDARY_QUANTITY_CANCELLED, VMI_FLAG, CONSIGNED_FLAG, CONSIGNED_CONSUMPTION_FLAG, AUTO_PRICED_FLAG FROM PO_LINE_LOCATIONS_INQ_V WHERE (:1 = agent_id OR EXISTS ( SELECT 'This employee is in approval path of this doc' FROM PO_ACTION_HISTORY POAH2 WHERE POAH2.employee_id + 0 = :2 AND POAH2.object_type_code in ('PO', 'PA') AND POAH2.object_id = po_header_id) OR( ((type_lookup_code = 'STANDARD') AND (release_num is null)) AND ( ( :3 = 'PUBLIC') OR ( :4 = 'PURCHASING' AND EXISTS (SELECT 'this employee is an agent' FROM PO_AGENTS POA WHERE POA.agent_id =:5 AND sysdate between nvl(POA.start_date_active, sysdate) and nvl(POA.end_date_active, sysdate + 1) )) OR ( :6 = 'HIERARCHY' AND :7 IN (SELECT POEH.superior_id FROM PO_EMPLOYEE_HIERARCHIES POEH WHERE POEH.employee_id = agent_id AND POEH.position_structure_id = nvl( :8 , -1) )) ) ) OR( ((type_lookup_code = 'PLANNED') AND (release_num is null)) AND ( ( :9 = 'PUBLIC') OR ( :10 = 'PURCHASING' AND EXISTS (SELECT 'this employee is an agent' FROM PO_AGENTS POA WHERE POA.agent_id = :11 AND sysdate between nvl(POA.start_date_active, sysdate) and nvl(POA.end_date_active, sysdate + 1) )) OR ( :12 = 'HIERARCHY' AND :13 IN (SELECT POEH.superior_id FROM PO_EMPLOYEE_HIERARCHIES POEH WHERE POEH.employee_id = agent_id AND POEH.position_structure_id = nvl( :14 , -1) )) ) ) OR( ((type_lookup_code = 'BLANKET') AND (release_num is null)) AND ( ( :15 = 'PUBLIC') OR ( :16 = 'PURCHASING' AND EXISTS (SELECT 'this employee is an agent' FROM PO_AGENTS POA WHERE POA.agent_id = :17 AND sysdate between nvl(POA.start_date_active, sysdate) and nvl(POA.end_date_active, sysdate + 1) )) OR ( :18 = 'HIERARCHY' AND :19 IN (SELECT POEH.superior_id FROM PO_EMPLOYEE_HIERARCHIES POEH WHERE POEH.employee_id = agent_id AND POEH.position_structure_id = nvl( :20 , -1) )) ) )OR( release_type = 'BLANKET' AND ( ( :21 = 'PUBLIC') OR ( :22 = 'PURCHASING' AND EXISTS (SELECT 'this employee is an agent' FROM PO_AGENTS POA WHERE POA.agent_id = :23 AND sysdate between nvl(POA.start_date_active, sysdate) and nvl(POA.end_date_active, sysdate + 1) )) OR ( :24 = 'HIERARCHY' AND :25 IN (SELECT POEH.superior_id FROM PO_EMPLOYEE_HIERARCHIE S POEH WHERE POEH.employee_id = agent_id AND POEH.position_structure_id = nvl( :26 , -1) )) ) )OR( release_type = 'SCHEDULED' AND ( ( :27 = 'PUBLIC') OR ( :28 = 'PURCHASING' AND EXISTS (SELECT 'this employee is an agent' FROM PO_AGENTS POA WHERE POA.agent_id = :29 AND sysdate between nvl(POA.start_date_active, sysdate) and nvl(POA.end_date_active, sysdate + 1) )) OR ( :30 = 'HIERARCHY' AND :31 IN (SELECT POEH.superior_id FROM PO_EMPLOYEE_HIERARCHIES POEH WHERE POEH.employee_id = agent_id AND POEH.position_structure_id = nvl( :32 , -1) )) ) )OR (:33 = 'Y')) AND -1=-1 and (po_line_locations_inq_v.owning_org_id = decode(po_line_locations_inq_v.global_agreement_flag, 'Y', po_line_locations_inq_v.owning_org_id, 204) ) and (RELEASE_TYPE IS NULL) and (PO_HEADER_ID=:34) and (PO_LINE_ID=:35) order by po_header_id desc, release_num desc, line_num, shipment_num
3b3psftuyks81 BEGIN INV_TXNSTUB_PUB.postTransaction(:1, :2, :3); END;
3dssuqfjsynrk SELECT count(1) FROM (SELECT * FROM ( SELECT LeadEO.sales_lead_id as SalesLeadId , to_char(hz_timezone_pub.convert_datetime(:1, hcp.timezone_id, SYSDATE), 'HH:MI AM ') ||' '||ht.standard_time_short_code as PrimaryContactLocalTime , SUBSTRB(LeadEO.description, 1, 240) as Description , hp.party_name as ContactName , custParty.party_name as CustomerName , aslt.meaning as RankName , ast.meaning as LeadStatus , ROUND(SYSDATE - LeadEO.creation_date) as Age , DECODE(LeadEO.status_code, 'CONVERTED_TO_OPPORTUNITY', 'ASNCnvToOpptyDsbld', 'ASNCnvToOpptyEnbld') as ASNLeadLstCnvToOppty , LeadEO.customer_id , hp.party_id , LeadEO.primary_contact_party_id , hr.relationship_id FROM as_sales_leads LeadEO , ( SELECT /*+ no_merge */ distinct aaa.sales_lead_id, aaa.customer_id FROM as_accesses_all aaa WHERE aaa.sales_lead_id IS NOT NULL AND aaa.lead_id IS NULL AND aaa.salesforce_id = :2) secu , as_statuses_tl ast , as_sales_lead_ranks_tl aslt , hz_parties CustParty , hz_parties hp, hz_relationships hr , hz_contact_points hcp , hz_timezones ht , ams_source_codes amsc WHERE LeadEO.sales_lead_id = secu.sales_lead_id AND LeadEO.customer_id = secu.customer_id AND LeadEO.status_code = ast.status_code AND ast.language = USERENV('LANG') AND LeadEO.lead_rank_id = aslt.rank_id (+) AND aslt.language (+) = USERENV('LANG') AND LeadEO.customer_id = CustParty.party_id AND LeadEO.primary_contact_party_id = hr.party_id(+) AND hr.subject_ id = hp.party_id (+) AND hr.subject_table_name (+) = 'HZ_PARTIES' AND hr.object_id(+) = LeadEO.customer_id AND hr.object_table_name (+) = 'HZ_PARTIES' AND LeadEO.primary_contact_party_id = hcp.owner_table_id(+) AND hcp.owner_table_name (+) = 'HZ_PARTIES' AND hcp.primary_flag (+) = 'Y' AND hcp.contact_point_type (+) = 'PHONE' AND hcp.timezone_id = ht.timezone_id (+) AND LeadEO.source_promotion_id = amsc.source_code_id AND amsc.source_code_for_id = :3 AND LeadEO.status_code = :4 ORDER BY age ) )
3prk3vg9u0abb BEGIN FND_GLOBAL.APPS_INITIALIZE( user_id=>:1 , resp_id=>:2 , resp_appl_id=>:3 , security_group_id=>:4 , server_id=>:5);END;
4yak7x2zqz0dh BEGIN inv_transfer_order_pvt.finalize_pick_confirm(:1, :2, :3, :4, :5, :6, :7); END;
5kqw5535fjvw6 SELECT NVL(RCTT.ATTRIBUTE10, ' ') FROM RA_CUST_TRX_TYPES_ALL RCTT, RA_CUSTOMER_TRX_ALL RCT WHERE RCT.CUSTOMER_TRX_ID = :B1 AND RCT.CUST_TRX_TYPE_ID = RCTT.CUST_TRX_TYPE_ID
608c0n36kaw62 begin FND_FLEX_WORKFLOW_APIS.COPY_FROM_COMBINATION (:v1, :v2, :v3, :v4, :v5); end;
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
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;
bt0w082dfrm8v BEGIN WSH_SHIP_CONFIRM_ACTIONS.interface_ALL_wrp( :errbuf, :rc, :A0, :A1, :A2, :A3); END;
by2f4fw8tac6r UPDATE RA_CUST_TRX_LINE_GL_DIST LGD SET (AMOUNT, ACCTD_AMOUNT) = (SELECT NVL(LGD.AMOUNT, 0) - ( SUM(LGD2.AMOUNT) - ( DECODE(LGD.GL_DATE, REC1.GL_DATE, 1, 0) * DECODE(DECODE(LGD2.ACCOUNT_CLASS, 'UNEARN', 'REV', LGD2.ACCOUNT_CLASS), 'REV', CTL.REVENUE_AMOUNT, 'SUSPENSE', CTL.EXTENDED_AMOUNT - CTL.REVENUE_AMOUNT, CTL.EXTENDED_AMOUNT) ) ), NVL(LGD.ACCTD_AMOUNT, 0) - ( SUM(LGD2.ACCTD_AMOUNT) - ( DECODE(LGD.GL_DATE, REC1.GL_DATE, 1, 0) * DECODE(:B2 , NULL, ROUND(DECODE(DECODE(LGD2.ACCOUNT_CLASS, 'UNEARN', 'REV', LGD2.ACCOUNT_CLASS), 'REV', CTL.REVENUE_AMOUNT, 'SUSPENSE', CTL.EXTENDED_AMOUNT - CTL.REVENUE_AMOUNT, CTL.EXTENDED_AMOUNT) * NVL(CT.EXCHANGE_RATE, 1), :B3 ), ROUND( (DECODE(DECODE(LGD2.ACCOUNT_CLASS, 'UNEARN', 'REV', LGD2.ACCOUNT_CLASS), 'REV', CTL.REVENUE_AMOUNT, 'SUSPENSE', CTL.EXTENDED_AMOUNT - CTL.REVENUE_AMOUNT, CTL.EXTENDED_AMOUNT) * NVL(CT.EXCHANGE_RATE, 1) ) / :B2 ) * :B2 ) ) ) FROM RA_CUST_TRX_LINE_GL_DIST LGD2, RA_CUSTOMER_TRX_LINES CTL, RA_CUSTOMER_TRX CT, RA_CUST_TRX_LINE_GL_DIST REC1 WHERE REC1.CUSTOMER_TRX_ID = LGD.CUSTOMER_TRX_ID AND REC1.ACCOUNT_CLASS = 'REC' AND REC1.LATEST_REC_FLAG = 'Y' AND CT.CUSTOMER_TRX_ID = REC1.CUSTOMER_TRX_ID AND CTL.CUSTOMER_TRX_ID = CT.CUSTOMER_TRX_ID AND CTL.CUSTOMER_TRX_LINE_ID = LGD.CUSTOMER_TRX_LINE_ID AND LGD2.CUSTOMER_TRX_LINE_ID = LGD.CUSTOMER_TRX_LINE_ID AND LGD2.ACCOUNT_CLASS = LGD.ACCOUNT_CLASS AND LGD2.ACCOUNT_SET_FLAG = 'N' AND NVL(LGD2.GL_DATE, TO_DATE( 2415021, 'J') ) = NVL(LGD .GL_DATE, TO_DATE( 2415021, 'J') ) GROUP BY CTL.CUSTOMER_TRX_LINE_ID, DECODE(LGD2.ACCOUNT_CLASS, 'UNEARN', 'REV', LGD2.ACCOUNT_CLASS), REC1.GL_DATE, CTL.EXTENDED_AMOUNT, CTL.REVENUE_AMOUNT, CT.EXCHANGE_RATE ), PERCENT = (SELECT DECODE(LGD.ACCOUNT_CLASS || LGD.ACCOUNT_SET_FLAG, 'SUSPENSEN', LGD.PERCENT, 'UNBILLN', LGD.PERCENT, 'UNEARNN', LGD.PERCENT, NVL(LGD.PERCENT, 0) - ( SUM(NVL(LGD4.PERCENT, 0)) - DECODE(REC2.GL_DATE, NVL(LGD.GL_DATE, REC2.GL_DATE), 100, 0) ) ) FROM RA_CUST_TRX_LINE_GL_DIST LGD4, RA_CUST_TRX_LINE_GL_DIST REC2 WHERE REC2.CUSTOMER_TRX_ID = LGD.CUSTOMER_TRX_ID AND REC2.ACCOUNT_CLASS = 'REC' AND REC2.LATEST_REC_FLAG = 'Y' AND LGD4.CUSTOMER_TRX_LINE_ID = LGD.CUSTOMER_TRX_LINE_ID AND LGD4.ACCOUNT_SET_FLAG = LGD.ACCOUNT_SET_FLAG AND DECODE(LGD4.ACCOUNT_SET_FLAG, 'Y', LGD4.ACCOUNT_CLASS, LGD.ACCOUNT_CLASS) = LGD.ACCOUNT_CLASS AND NVL(LGD4.GL_DATE, TO_DATE( 2415021, 'J') ) = NVL(LGD.GL_DATE, TO_DATE( 2415021, 'J') ) GROUP BY REC2.GL_DATE, LGD.GL_DATE ), LAST_UPDATED_BY = :B1 , LAST_UPDATE_DATE = SYSDATE WHERE CUST_TRX_LINE_GL_DIST_ID IN (SELECT MIN(DECODE(LGD3.GL_POSTED_DATE, NULL, LGD3.CUST_TRX_LINE_GL_DIST_ID, NULL) ) FROM RA_CUSTOMER_TRX_LINES CTL, RA_CUST_TRX_LINE_GL_DIST LGD3, RA_CUST_TRX_LINE_GL_DIST REC3, RA_CUSTOMER_TRX T WHERE T.CUSTOMER_TRX_ID = :B5 AND REC3.CUSTOMER_TRX_ID = T.CUSTOMER_TRX_ID AND REC3.ACCOUNT_CLASS = 'REC' AND REC3.LATEST_REC_FLAG = 'Y' AND LGD3.CUSTOMER_TRX_ID = T.CUSTOMER_TRX_ID AND LGD3.ACCOUNT_S ET_FLAG = 'N' AND CTL.CUSTOMER_TRX_LINE_ID = LGD3.CUSTOMER_TRX_LINE_ID AND ( CTL.LINE_TYPE IN ('TAX', 'FREIGHT', 'CHARGES', 'SUSPENSE') OR (CTL.LINE_TYPE = 'LINE' AND CTL.ACCOUNTING_RULE_ID IS NULL) ) AND NVL(T.PREVIOUS_CUSTOMER_TRX_ID, -1) = DECODE(:B4 , 'INV', -1, 'REGULAR_CM', T.PREVIOUS_CUSTOMER_TRX_ID, NVL(T.PREVIOUS_CUSTOMER_TRX_ID, -1) ) GROUP BY CTL.CUSTOMER_TRX_LINE_ID, DECODE(LGD3.ACCOUNT_CLASS, 'UNEARN', 'REV', LGD3.ACCOUNT_CLASS), LGD3.GL_DATE, REC3.GL_DATE, CTL.EXTENDED_AMOUNT, CTL.REVENUE_AMOUNT, T.EXCHANGE_RATE HAVING ( SUM(NVL(LGD3.AMOUNT, 0)) <> DECODE(DECODE(LGD3.ACCOUNT_CLASS, 'UNEARN', 'REV', LGD3.ACCOUNT_CLASS), 'REV', CTL.REVENUE_AMOUNT, 'SUSPENSE', CTL.EXTENDED_AMOUNT - CTL.REVENUE_AMOUNT, CTL.EXTENDED_AMOUNT) * DECODE(LGD3.GL_DATE, REC3.GL_DATE, 1, 0) OR SUM(NVL(LGD3.ACCTD_AMOUNT, 0)) <> DECODE(LGD3.GL_DATE, REC3.GL_DATE, 1, 0) * DECODE(:B2 , NULL, ROUND(DECODE(DECODE(LGD3.ACCOUNT_CLASS, 'UNEARN', 'REV', LGD3.ACCOUNT_CLASS), 'REV', CTL.REVENUE_AMOUNT, 'SUSPENSE', CTL.EXTENDED_AMOUNT - CTL.REVENUE_AMOUNT, CTL.EXTENDED_AMOUNT) * NVL(T.EXCHANGE_RATE, 1), :B3 ), ROUND( (DECODE(DECODE(LGD3.ACCOUNT_CLASS, 'UNEARN', 'REV', LGD3.ACCOUNT_CLASS), 'REV', CTL.REVENUE_AMOUNT, 'SUSPENSE', CTL.EXTENDED_AMOUNT - CTL.REVENUE_AMOUNT, CTL.EXTENDED_AMOUNT) * NVL(T.EXCHANGE_RATE, 1) ) / :B2 ) * :B2 ) ) UNION SELECT TO_NUMBER( MIN(DECODE(LGD5.GL_POSTED_DATE||LGD5.ACCOUNT_CLASS|| LGD5.ACCOUNT_SET_FLAG, 'REVN', LGD 5.CUST_TRX_LINE_GL_DIST_ID, 'REVY', LGD5.CUST_TRX_LINE_GL_DIST_ID, 'TAXN', LGD5.CUST_TRX_LINE_GL_DIST_ID, 'TAXY', LGD5.CUST_TRX_LINE_GL_DIST_ID, 'FREIGHTN', LGD5.CUST_TRX_LINE_GL_DIST_ID, 'FREIGHTY', LGD5.CUST_TRX_LINE_GL_DIST_ID, 'CHARGESN', LGD5.CUST_TRX_LINE_GL_DIST_ID, 'CHARGESY', LGD5.CUST_TRX_LINE_GL_DIST_ID, 'UNEARNY', LGD5.CUST_TRX_LINE_GL_DIST_ID, 'UNBILLY', LGD5.CUST_TRX_LINE_GL_DIST_ID, NULL ) ) ) FROM RA_CUST_TRX_LINE_GL_DIST REC5, RA_CUST_TRX_LINE_GL_DIST LGD5, RA_CUSTOMER_TRX_LINES CTL2 WHERE CTL2.CUSTOMER_TRX_ID = :B5 AND REC5.CUSTOMER_TRX_ID = LGD5.CUSTOMER_TRX_ID AND REC5.ACCOUNT_CLASS = 'REC' AND REC5.LATEST_REC_FLAG = 'Y' AND LGD5.CUSTOMER_TRX_LINE_ID = CTL2.CUSTOMER_TRX_LINE_ID AND ( CTL2.LINE_TYPE IN ('TAX', 'FREIGHT', 'CHARGES', 'SUSPENSE') OR (CTL2.LINE_TYPE = 'LINE' AND (CTL2.ACCOUNTING_RULE_ID IS NULL OR LGD5.ACCOUNT_SET_FLAG = 'Y') ) ) GROUP BY LGD5.CUSTOMER_TRX_LINE_ID, LGD5.GL_DATE, REC5.GL_DATE, LGD5.ACCOUNT_SET_FLAG, DECODE(LGD5.ACCOUNT_SET_FLAG, 'N', NULL, LGD5.ACCOUNT_CLASS) HAVING SUM(NVL(LGD5.PERCENT, 0)) <> DECODE( NVL(LGD5.GL_DATE, REC5.GL_DATE), REC5.GL_DATE, 100, 0) )
cd9mbmqyf4qhp UPDATE WF_ITEM_ACTIVITY_STATUSES SET ACTIVITY_STATUS = :B8 , ACTIVITY_RESULT_CODE = NVL(:B13 , ACTIVITY_RESULT_CODE), BEGIN_DATE = NVL(:B11 , BEGIN_DATE), END_DATE = NVL(:B12 , END_DATE), DUE_DATE = DECODE(:B11 , TO_DATE(NULL), DUE_DATE, :B10 ), OUTBOUND_QUEUE_ID = :B9 , EXECUTION_TIME = DECODE(:B8 , :B7 , :B4 , :B6 , NVL(EXECUTION_TIME, :B4 ), :B5 , NVL(EXECUTION_TIME, :B4 ), EXECUTION_TIME) WHERE ITEM_TYPE = :B3 AND ITEM_KEY = :B2 AND PROCESS_ACTIVITY = :B1
csvvv0fmhr1yc BEGIN FFP1893_01010001.FORMULA( :N1, :N4, :T1, :I1, :D1, :T2, :I2, :T7, :I7, :T8, :I8, :T5, :I5, :N3, :T4, :I4, :N2, :N5, :T3, :I3, :T6, :I6, :FFERLN, :FFERCD, :FFERMT); END;
cwyx16zn1hpfb select parameter, value from nls_session_parameters
dcvv68fju01g4 begin FND_FLEX_WORKFLOW_APIS.END_GENERATION (:v1, :v2, :v3, :v4, :v5); end;
dk0sqcvc2xjvs BEGIN ASO_QUOTE_PUB_W.Create_Qte_Opportunity(:1, :2, :3, :4, :5, :6, p_c_auto_version_flag => :7, p_c_pricing_request_type => :8, p_c_header_pricing_event => :9, p_c_cal_tax_flag => :10, p_c_cal_freight_charge_flag => :11, p_c_copy_task_flag => :12, p_c_copy_notes_flag => :13, p_c_copy_att_flag => :14, p_c_deactivate_all => :15, p_c_price_mode => :16, p_source_code => :17, p_op_opportunity_id => :18, p_op_quote_name => :19, p_op_cust_account_id => :20, p_op_resource_id => :21, p_op_sold_to_contact_id => :22, p_op_sold_to_party_site_id => :23, p_op_price_list_id => :24, p_op_resource_grp_id => :25, p_op_channel_code => :26, p_op_order_type_id => :27, p_op_agreement_id => :28, p_op_currency_code => :29, p_op_marketing_source_code_id => :30, p_op_quote_expiration_date => :31, p_op_cust_party_id => :32, p_op_pricing_status_indicator => :33, p_op_tax_status_indicator => :34, x_return_status => :35, x_msg_count => :36, x_msg_data => :37 ); END;
fb13x9qx0ftks begin OE_STANDARD_WF.OEOL_SELECTOR (:v1, :v2, :v3, :v4, :v5); end;
fmfdkztk8vx23 SELECT CATEGORY, SEVERITY, FND_LOG_SEVERITY FROM FND_NEW_MESSAGES WHERE MESSAGE_NAME = :B1 AND APPLICATION_ID = :B2 AND LANGUAGE_CODE = :B3 AND ROWNUM = 1
fumydqvpk1g21 BEGIN ASO_QUOTE_PUB_W.SUBMIT_Quote(x_return_status => :1, x_msg_count => :2, x_msg_data => :3, p_q_quote_header_id => :4, p_q_last_update_date => :5, p_q_quote_expiration_date => :6, p_sc_book_flag => :7, p_sc_reserve_flag => :8, p_sc_calculate_price => :9, p_sc_server_id => :10, x_order_number => :11, x_order_header_id => :12, x_order_request_id => :13, x_contract_id => :14, x_status => :15 ); END;
g8102j8yynbwz begin WF_STANDARD.CONTINUEFLOW (:v1, :v2, :v3, :v4, :v5); end;
gf1u933c95jb5 DECLARE l_ret_stat varchar2(56); BEGIN CSI_INV_TXN_HOOK_PKG.postTransaction( p_header_id => :1 , p_transaction_id => :2 , x_return_status => l_ret_stat ); INV_TXNSTUB_PUB.g_ret_status := l_ret_stat; END;
gksvm8wmzk8w0 begin OE_INVOICE_WF.INVOICE_INTERFACE (:v1, :v2, :v3, :v4, :v5); end;

Back to SQL Statistics
Back to Top

 

Instance Activity Statistics

Back to Top

Instance Activity Stats

Statistic Total per Second per Trans
CPU used by this session 2,149,370 596.30 1.72
CPU used when call started 2,144,665 595.00 1.71
CR blocks created 16,969,997 4,708.03 13.55
Cached Commit SCN referenced 48,318 13.40 0.04
Commit SCN cached 8 0.00 0.00
DB time 5,155,069 1,430.18 4.12
DBWR checkpoint buffers written 3,069,971 851.71 2.45
DBWR checkpoints 34 0.01 0.00
DBWR object drop buffers written 57,150 15.86 0.05
DBWR revisited being-written buffer 154 0.04 0.00
DBWR thread checkpoint buffers written 676,455 187.67 0.54
DBWR transaction table writes 2,553 0.71 0.00
DBWR undo block writes 1,624,676 450.74 1.30
DFO trees parallelized 48 0.01 0.00
IMU CR rollbacks 45,125,573 12,519.29 36.04
IMU Flushes 359,900 99.85 0.29
IMU Redo allocation size 2,391,286,496 663,420.11 1,909.90
IMU commits 647,895 179.75 0.52
IMU contention 39,821 11.05 0.03
IMU ktichg flush 11,323 3.14 0.01
IMU pool not allocated 0 0.00 0.00
IMU recursive-transaction flush 1,777 0.49 0.00
IMU undo allocation size 5,745,000,064 1,593,848.57 4,588.48
IMU- failed to get a private strand 0 0.00 0.00
PX local messages recv'd 53,212 14.76 0.04
PX local messages sent 53,212 14.76 0.04
Parallel operations downgraded 25 to 50 pct 40 0.01 0.00
Parallel operations not downgraded 8 0.00 0.00
SQL*Net roundtrips to/from client 52,111,573 14,457.43 41.62
active txn count during cleanout 133,212,031 36,957.32 106.40
application wait time 16,632 4.61 0.01
background checkpoints completed 3 0.00 0.00
background checkpoints started 2 0.00 0.00
background timeouts 13,899 3.86 0.01
branch node splits 1,085 0.30 0.00
buffer is not pinned count 599,501,052 166,320.95 478.82
buffer is pinned count 1,548,896,796 429,714.00 1,237.09
bytes received via SQL*Net from client 11,411,101,651 3,165,808.15 9,113.95
bytes sent via SQL*Net to client 10,345,017,534 2,870,041.98 8,262.48
calls to get snapshot scn: kcmgss 117,848,380 32,694.95 94.12
calls to kcmgas 21,181,916 5,876.55 16.92
calls to kcmgcs 13,394,422 3,716.05 10.70
change write time 46,169 12.81 0.04
cleanout - number of ktugct calls 28,706,596 7,964.14 22.93
cleanouts and rollbacks - consistent read gets 14,838,241 4,116.61 11.85
cleanouts only - consistent read gets 157,091 43.58 0.13
cluster key scan block gets 874,059 242.49 0.70
cluster key scans 239,613 66.48 0.19
commit batch/immediate performed 4,379 1.21 0.00
commit batch/immediate requested 4,379 1.21 0.00
commit cleanout failures: block lost 260,501 72.27 0.21
commit cleanout failures: buffer being written 1,090 0.30 0.00
commit cleanout failures: callback failure 109,958 30.51 0.09
commit cleanout failures: cannot pin 33,336 9.25 0.03
commit cleanouts 9,699,965 2,691.08 7.75
commit cleanouts successfully completed 9,295,080 2,578.76 7.42
commit immediate performed 4,379 1.21 0.00
commit immediate requested 4,379 1.21 0.00
commit txn count during cleanout 1,393,024 386.47 1.11
concurrency wait time 18,074 5.01 0.01
consistent changes 871,572,434 241,802.34 696.12
consistent gets 1,948,547,771 540,590.08 1,556.29
consistent gets - examination 1,392,187,538 386,237.79 1,111.93
consistent gets from cache 1,948,547,735 540,590.07 1,556.29
cursor authentications 2,101 0.58 0.00
data blocks consistent reads - undo records applied 867,256,758 240,605.03 692.67
db block changes 201,677,243 55,951.78 161.08
db block gets 227,082,909 63,000.13 181.37
db block gets direct 4,340 1.20 0.00
db block gets from cache 227,078,569 62,998.93 181.37
deferred (CURRENT) block cleanout applications 1,679,123 465.84 1.34
dirty buffers inspected 10,214 2.83 0.01
doubling up with imu segment 0 0.00 0.00
enqueue conversions 10,426 2.89 0.01
enqueue releases 4,693,210 1,302.05 3.75
enqueue requests 4,699,430 1,303.77 3.75
enqueue timeouts 6,120 1.70 0.00
enqueue waits 34,568 9.59 0.03
exchange deadlocks 25,349 7.03 0.02
execute count 104,988,965 29,127.33 83.85
failed probes on index block reclamation 13,553 3.76 0.01
frame signature mismatch 308 0.09 0.00
free buffer inspected 3,180,710 882.43 2.54
free buffer requested 21,533,959 5,974.22 17.20
heap block compress 34,348,320 9,529.33 27.43
hot buffers moved to head of LRU 1,347,251 373.77 1.08
immediate (CR) block cleanout applications 14,995,338 4,160.19 11.98
immediate (CURRENT) block cleanout applications 1,164,091 322.96 0.93
index crx upgrade (found) 17,172 4.76 0.01
index crx upgrade (positioned) 10,507,595 2,915.15 8.39
index fast full scans (full) 0 0.00 0.00
index fast full scans (rowid ranges) 784 0.22 0.00
index fetch by key 189,752,382 52,643.44 151.55
index scans kdiixs1 141,918,759 39,372.85 113.35
java call heap collected bytes 1,509,438,192 418,766.91 1,205.58
java call heap collected count 18,447,733 5,118.00 14.73
java call heap gc count 4,895 1.36 0.00
java call heap live object count 1,555,617 431.58 1.24
java call heap live object count max 1,559,673 432.70 1.25
java call heap live size 394,887,216 109,554.47 315.39
java call heap live size max 395,530,624 109,732.97 315.91
java call heap object count 3,821,286 1,060.15 3.05
java call heap object count max 3,829,630 1,062.46 3.06
java call heap total size 513,146,880 142,363.52 409.85
java call heap total size max 513,675,264 142,510.11 410.27
java call heap used size 539,841,400 149,769.44 431.17
java call heap used size max 540,856,144 150,050.96 431.98
leaf node 90-10 splits 21,126 5.86 0.02
leaf node splits 248,796 69.02 0.20
lob reads 23,585 6.54 0.02
lob writes 41,328 11.47 0.03
lob writes unaligned 41,328 11.47 0.03
logons cumulative 10,190 2.83 0.01
messages received 1,816,303 503.90 1.45
messages sent 1,816,303 503.90 1.45
no buffer to keep pinned count 16 0.00 0.00
no work - consistent read gets 504,792,461 140,045.73 403.17
opened cursors cumulative 6,000,675 1,664.78 4.79
parse count (failures) 3,604 1.00 0.00
parse count (hard) 9,357 2.60 0.01
parse count (total) 9,227,403 2,559.98 7.37
parse time cpu 49,102 13.62 0.04
parse time elapsed 54,860 15.22 0.04
physical read IO requests 301,638 83.68 0.24
physical read bytes 3,727,917,056 1,034,244.59 2,977.46
physical read total IO requests 330,914 91.81 0.26
physical read total bytes 4,206,657,536 1,167,062.67 3,359.82
physical read total multi block requests 12,622 3.50 0.01
physical reads 455,068 126.25 0.36
physical reads cache 453,716 125.88 0.36
physical reads cache prefetch 152,830 42.40 0.12
physical reads direct 1,352 0.38 0.00
physical reads direct temporary tablespace 620 0.17 0.00
physical reads prefetch warmup 84,001 23.30 0.07
physical write IO requests 1,524,329 422.90 1.22
physical write bytes 25,888,628,736 7,182,341.75 20,677.03
physical write total IO requests 2,783,136 772.13 2.22
physical write total bytes 59,717,275,648 16,567,500.98 47,695.68
physical write total multi block requests 1,451,791 402.77 1.16
physical writes 3,160,233 876.75 2.52
physical writes direct 5,293 1.47 0.00
physical writes direct (lob) 223 0.06 0.00
physical writes direct temporary tablespace 4,674 1.30 0.00
physical writes from cache 3,154,940 875.28 2.52
physical writes non checkpoint 2,383,804 661.34 1.90
pinned buffers inspected 3,879 1.08 0.00
prefetch warmup blocks aged out before use 250,316 69.45 0.20
prefetched blocks aged out before use 120 0.03 0.00
process last non-idle time 3,603 1.00 0.00
queries parallelized 48 0.01 0.00
recursive calls 169,672,852 47,072.73 135.52
recursive cpu usage 1,195,064 331.55 0.95
redo blocks written 65,904,619 18,284.07 52.64
redo buffer allocation retries 75 0.02 0.00
redo entries 103,890,480 28,822.57 82.98
redo log space requests 0 0.00 0.00
redo log space wait time 0 0.00 0.00
redo ordering marks 1,300,957 360.93 1.04
redo size 32,316,620,996 8,965,674.41 25,811.01
redo subscn max counts 2,411,018 668.89 1.93
redo synch time 106,368 29.51 0.08
redo synch writes 2,431,769 674.65 1.94
redo wastage 322,824,600 89,561.97 257.84
redo write time 56,636 15.71 0.05
redo writer latching time 353 0.10 0.00
redo writes 845,278 234.51 0.68
rollback changes - undo records applied 219,821 60.99 0.18
rollbacks only - consistent read gets 2,281,421 632.94 1.82
rows fetched via callback 100,286,545 27,822.73 80.10
session connect time 0 0.00 0.00
session cursor cache hits 5,778,135 1,603.04 4.61
session logical reads 2,175,631,664 603,590.49 1,737.66
session pga memory 10,448,054,784 2,898,627.84 8,344.77
session pga memory max 11,652,062,432 3,232,658.45 9,306.40
session uga memory ############### 75,152,022.18 216,352.88
session uga memory max 74,490,488,024 20,666,067.23 59,494.91
shared hash latch upgrades - no wait 32,899,686 9,127.44 26.28
shared hash latch upgrades - wait 32,994 9.15 0.03
sorts (memory) 11,035,416 3,061.58 8.81
sorts (rows) 136,025,515 37,737.87 108.64
sql area evicted 2,671 0.74 0.00
sql area purged 3,774 1.05 0.00
summed dirty queue length 503,581 139.71 0.40
switch current to new buffer 1,426,178 395.67 1.14
table fetch by rowid 918,034,884 254,692.53 733.23
table fetch continued row 33,657,601 9,337.71 26.88
table scan blocks gotten 99,038,642 27,476.52 79.10
table scan rows gotten 8,250,799,368 2,289,038.22 6,589.84
table scans (long tables) 2,046 0.57 0.00
table scans (rowid ranges) 2,044 0.57 0.00
table scans (short tables) 6,225,139 1,727.05 4.97
total number of times SMON posted 155,750 43.21 0.12
transaction rollbacks 4,379 1.21 0.00
transaction tables consistent read rollbacks 81 0.02 0.00
transaction tables consistent reads - undo records applied 4,843 1.34 0.00
undo change vector size 11,304,214,864 3,136,154.30 9,028.58
user I/O wait time 134,178 37.23 0.11
user calls 49,757,427 13,804.32 39.74
user commits 987,013 273.83 0.79
user rollbacks 265,035 73.53 0.21
workarea executions - onepass 4 0.00 0.00
workarea executions - optimal 6,629,910 1,839.35 5.30
write clones created in background 1,698 0.47 0.00
write clones created in foreground 7,437 2.06 0.01

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistic Begin Value End Value
session cursor cache count 554,121 1,271,490
opened cursors current 1,100,695 1,233,499
workarea memory allocated 176 1,358
logons current 5,248 5,279

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 12.19 1.00 715,894 199 259,551 0.04
APPS_TS_TX_DATA 177,552 49 4.30 1.30 215,501 60 127,081 0.21
APPS_TS_TX_IDX 97,990 27 4.46 1.32 228,272 63 60,992 0.33
APPS_ASSM_DATA 8,833 2 2.27 6.49 155,050 43 42,386 0.39
APPS_ASSM_IDX 6,827 2 2.36 1.04 139,136 39 175,621 0.10
APPS_TS_TX_INTERFACE 1,193 0 2.90 2.10 33,840 9 16,519 0.03
TEMP 513 0 4.33 9.98 10,307 3 91 4.07
APPS_TS_SUMMARY 59 0 8.98 1.00 8,390 2 1,975 0.04
SYSTEM 5,395 1 3.93 3.45 2,755 1 21,755 0.07
APPS_TS_SEED 2,317 1 6.08 1.65 5,678 2 850 2.18
APPS_TS_QUEUES 386 0 5.39 2.12 5,699 2 428 0.28
APPS_TS_ARCHIVE 62 0 5.48 1.39 2,269 1 111 21.35
SYSAUX 292 0 2.16 1.08 1,496 0 0 0.00
APPS_TS_NOLOGGING 25 0 10.40 1.56 38 0 0 0.00
CTXSYS 24 0 7.50 1.00 6 0 0 0.00
APPS_TS_MEDIA 12 0 13.33 1.00 9 0 0 0.00
ODM 12 0 5.83 1.00 3 0 0 0.00
OLAP 12 0 6.67 1.00 3 0 0 0.00
OWAPUB 12 0 5.00 1.00 3 0 0 0.00
PORTAL 12 0 8.33 1.00 3 0 0 0.00
SYNCSERVER 12 0 5.83 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,833 2 2.27 6.49 155,050 43 42,386 0.39
APPS_ASSM_IDX /DB/visdata/apps_assm_idx.dbf 6,827 2 2.36 1.04 139,136 39 175,621 0.10
APPS_TS_ARCHIVE /DB/visdata/archive1.dbf 34 0 6.76 1.38 2,002 1 107 22.15
APPS_TS_ARCHIVE /DB/visdata/archive2.dbf 28 0 3.93 1.39 267 0 4 0.00
APPS_TS_MEDIA /DB/visdata/media1.dbf 4 0 10.00 1.00 3 0 0 0.00
APPS_TS_MEDIA /DB/visdata/media2.dbf 4 0 17.50 1.00 3 0 0 0.00
APPS_TS_MEDIA /DB/visdata/media3.dbf 4 0 12.50 1.00 3 0 0 0.00
APPS_TS_NOLOGGING /DB/visdata/nologging1.dbf 4 0 15.00 1.00 3 0 0 0.00
APPS_TS_NOLOGGING /DB/visdata/nologging2.dbf 15 0 7.33 1.00 23 0 0 0.00
APPS_TS_NOLOGGING /DB/visdata/nologging3.dbf 6 0 15.00 3.33 12 0 0 0.00
APPS_TS_QUEUES /DB/visdata/queues1.dbf 50 0 6.00 1.82 773 0 93 0.54
APPS_TS_QUEUES /DB/visdata/queues2.dbf 26 0 3.85 3.54 1,005 0 224 0.18
APPS_TS_QUEUES /DB/visdata/queues3.dbf 39 0 5.38 3.41 812 0 5 0.00
APPS_TS_QUEUES /DB/visdata/queues4.dbf 55 0 4.73 1.98 832 0 4 0.00
APPS_TS_QUEUES /DB/visdata/queues5.dbf 54 0 5.56 2.35 688 0 1 0.00
APPS_TS_QUEUES /DB/visdata/queues6.dbf 34 0 6.18 1.79 727 0 10 0.00
APPS_TS_QUEUES /DB/visdata/queues7.dbf 128 0 5.47 1.61 862 0 91 0.33
APPS_TS_SEED /DB/visdata/reference1.dbf 196 0 6.48 1.67 499 0 43 1.86
APPS_TS_SEED /DB/visdata/reference10.dbf 192 0 5.89 1.63 550 0 59 1.69
APPS_TS_SEED /DB/visdata/reference2.dbf 221 0 7.06 1.58 577 0 37 2.97
APPS_TS_SEED /DB/visdata/reference3.dbf 362 0 5.28 1.62 625 0 404 1.83
APPS_TS_SEED /DB/visdata/reference4.dbf 218 0 6.74 1.84 648 0 32 2.19
APPS_TS_SEED /DB/visdata/reference5.dbf 263 0 6.27 1.60 565 0 81 1.85
APPS_TS_SEED /DB/visdata/reference6.dbf 249 0 5.66 1.71 622 0 48 3.13
APPS_TS_SEED /DB/visdata/reference7.dbf 240 0 5.83 1.50 497 0 38 6.84
APPS_TS_SEED /DB/visdata/reference8.dbf 197 0 5.63 1.77 520 0 39 3.33
APPS_TS_SEED /DB/visdata/reference9.dbf 179 0 6.59 1.60 575 0 69 0.87
APPS_TS_SUMMARY /DB/visdata/summary1.dbf 7 0 12.86 1.00 1,033 0 262 0.00
APPS_TS_SUMMARY /DB/visdata/summary2.dbf 5 0 8.00 1.00 858 0 130 0.08
APPS_TS_SUMMARY /DB/visdata/summary3.dbf 7 0 8.57 1.00 915 0 171 0.12
APPS_TS_SUMMARY /DB/visdata/summary4.dbf 12 0 7.50 1.00 904 0 184 0.00
APPS_TS_SUMMARY /DB/visdata/summary5.dbf 7 0 7.14 1.00 1,031 0 285 0.00
APPS_TS_SUMMARY /DB/visdata/summary6.dbf 7 0 14.29 1.00 1,222 0 524 0.04
APPS_TS_SUMMARY /DB/visdata/summary7.dbf 7 0 7.14 1.00 1,083 0 216 0.05
APPS_TS_SUMMARY /DB/visdata/summary8.dbf 7 0 7.14 1.00 1,344 0 203 0.05
APPS_TS_TX_DATA /DB/visdata/tx_data1.dbf 3,201 1 5.15 1.20 411 0 3 6.67
APPS_TS_TX_DATA /DB/visdata/tx_data10.dbf 3,167 1 5.04 1.19 277 0 0 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data11.dbf 3,144 1 4.89 1.24 233 0 0 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data12.dbf 13,295 4 3.18 1.22 3,994 1 3,516 0.87
APPS_TS_TX_DATA /DB/visdata/tx_data13.dbf 18,069 5 4.73 1.46 5,626 2 2,314 0.94
APPS_TS_TX_DATA /DB/visdata/tx_data14.dbf 13,196 4 4.19 1.35 31,405 9 16,283 0.15
APPS_TS_TX_DATA /DB/visdata/tx_data15.dbf 9,425 3 3.94 1.41 30,380 8 15,908 0.18
APPS_TS_TX_DATA /DB/visdata/tx_data16.dbf 9,456 3 3.85 1.43 29,015 8 17,371 0.16
APPS_TS_TX_DATA /DB/visdata/tx_data17.dbf 9,378 3 3.85 1.41 28,091 8 17,264 0.17
APPS_TS_TX_DATA /DB/visdata/tx_data18.dbf 9,430 3 3.85 1.40 26,883 7 17,408 0.15
APPS_TS_TX_DATA /DB/visdata/tx_data19.dbf 9,386 3 4.00 1.42 27,034 8 16,805 0.21
APPS_TS_TX_DATA /DB/visdata/tx_data2.dbf 6,760 2 3.48 1.15 1,293 0 2,217 0.81
APPS_TS_TX_DATA /DB/visdata/tx_data20.dbf 9,350 3 4.07 1.45 26,930 7 16,577 0.15
APPS_TS_TX_DATA /DB/visdata/tx_data21.dbf 22,879 6 4.74 1.17 1,087 0 1,361 0.04
APPS_TS_TX_DATA /DB/visdata/tx_data3.dbf 3,964 1 5.38 1.36 489 0 11 6.36
APPS_TS_TX_DATA /DB/visdata/tx_data4.dbf 17,338 5 4.56 1.07 349 0 12 7.50
APPS_TS_TX_DATA /DB/visdata/tx_data5.dbf 3,277 1 5.03 1.18 408 0 6 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data6.dbf 3,241 1 4.96 1.21 256 0 4 10.00
APPS_TS_TX_DATA /DB/visdata/tx_data7.dbf 3,165 1 4.83 1.23 537 0 16 6.88
APPS_TS_TX_DATA /DB/visdata/tx_data8.dbf 3,131 1 4.63 1.19 484 0 5 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data9.dbf 3,300 1 4.95 1.23 319 0 0 0.00
APPS_TS_TX_IDX /DB/visdata/tx_idx1.dbf 2,587 1 3.41 1.12 2,678 1 1,113 0.61
APPS_TS_TX_IDX /DB/visdata/tx_idx10.dbf 2,531 1 3.56 1.14 1,945 1 1,127 0.51
APPS_TS_TX_IDX /DB/visdata/tx_idx11.dbf 2,558 1 3.37 1.16 1,996 1 1,100 0.53
APPS_TS_TX_IDX /DB/visdata/tx_idx12.dbf 11,691 3 5.17 1.57 23,408 6 1,241 0.27
APPS_TS_TX_IDX /DB/visdata/tx_idx13.dbf 9,959 3 4.69 1.28 30,887 9 3,420 0.28
APPS_TS_TX_IDX /DB/visdata/tx_idx14.dbf 6,170 2 4.98 1.32 23,236 6 3,726 0.44
APPS_TS_TX_IDX /DB/visdata/tx_idx15.dbf 5,988 2 4.74 1.36 19,627 5 4,299 0.16
APPS_TS_TX_IDX /DB/visdata/tx_idx16.dbf 5,915 2 5.06 1.36 18,474 5 3,923 0.20
APPS_TS_TX_IDX /DB/visdata/tx_idx17.dbf 5,923 2 4.72 1.35 17,286 5 3,856 0.19
APPS_TS_TX_IDX /DB/visdata/tx_idx18.dbf 6,039 2 4.89 1.35 17,035 5 5,421 0.18
APPS_TS_TX_IDX /DB/visdata/tx_idx19.dbf 6,010 2 4.95 1.40 16,690 5 3,537 0.23
APPS_TS_TX_IDX /DB/visdata/tx_idx2.dbf 3,138 1 4.22 1.28 2,287 1 1,378 0.60
APPS_TS_TX_IDX /DB/visdata/tx_idx20.dbf 5,790 2 4.78 1.36 15,830 4 3,525 0.17
APPS_TS_TX_IDX /DB/visdata/tx_idx21.dbf 3,544 1 4.99 1.48 15,675 4 3,036 0.45
APPS_TS_TX_IDX /DB/visdata/tx_idx3.dbf 4,060 1 2.82 1.09 2,094 1 2,970 0.67
APPS_TS_TX_IDX /DB/visdata/tx_idx4.dbf 2,742 1 3.48 1.12 3,599 1 3,187 0.56
APPS_TS_TX_IDX /DB/visdata/tx_idx5.dbf 2,776 1 3.53 1.17 5,186 1 8,378 0.19
APPS_TS_TX_IDX /DB/visdata/tx_idx6.dbf 2,730 1 3.47 1.18 3,025 1 2,006 0.52
APPS_TS_TX_IDX /DB/visdata/tx_idx7.dbf 2,622 1 3.51 1.14 2,943 1 1,442 0.51
APPS_TS_TX_IDX /DB/visdata/tx_idx8.dbf 2,614 1 3.46 1.17 2,217 1 1,217 0.53
APPS_TS_TX_IDX /DB/visdata/tx_idx9.dbf 2,603 1 3.71 1.21 2,154 1 1,090 0.87
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte.dbf 293 0 2.01 1.52 5,351 1 5,644 0.03
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte2.dbf 157 0 5.29 3.07 6,655 2 3,803 0.03
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte3.dbf 118 0 4.83 3.09 5,819 2 2,925 0.04
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte4.dbf 313 0 1.66 1.68 5,492 2 1,685 0.02
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte5.dbf 165 0 2.67 2.18 5,238 1 1,541 0.05
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte6.dbf 147 0 3.47 2.27 5,285 1 921 0.07
APPS_UNDOTS1 /DB/visdata/undo01.dbf 3 0 6.67 1.00 74,525 21 25,325 0.06
APPS_UNDOTS1 /DB/visdata/undo02.dbf 3 0 13.33 1.00 70,751 20 24,551 0.04
APPS_UNDOTS1 /DB/visdata/undo03.dbf 3 0 10.00 1.00 70,564 20 27,540 0.03
APPS_UNDOTS1 /DB/visdata/undo04.dbf 5 0 6.00 1.00 72,090 20 30,638 0.04
APPS_UNDOTS1 /DB/visdata/undo05.dbf 3 0 10.00 1.00 69,101 19 30,151 0.03
APPS_UNDOTS1 /DB/visdata/undo06.dbf 3 0 23.33 1.00 68,133 19 23,014 0.03
APPS_UNDOTS1 /DB/visdata/undo07.dbf 3 0 10.00 1.00 72,121 20 29,388 0.04
APPS_UNDOTS1 /DB/visdata/undo08.dbf 3 0 23.33 1.00 73,217 20 20,560 0.03
APPS_UNDOTS1 /DB/visdata/undo09.dbf 3 0 10.00 1.00 72,413 20 26,094 0.04
APPS_UNDOTS1 /DB/visdata/undo10.dbf 3 0 13.33 1.00 72,979 20 22,290 0.03
CTXSYS /DB/visdata/ctx1.dbf 12 0 9.17 1.00 3 0 0 0.00
CTXSYS /DB/visdata/ctx2.dbf 12 0 5.83 1.00 3 0 0 0.00
ODM /DB/visdata/odm.dbf 12 0 5.83 1.00 3 0 0 0.00
OLAP /DB/visdata/olap.dbf 12 0 6.67 1.00 3 0 0 0.00
OWAPUB /DB/visdata/owa1.dbf 12 0 5.00 1.00 3 0 0 0.00
PORTAL /DB/visdata/portal.dbf 12 0 8.33 1.00 3 0 0 0.00
SYNCSERVER /DB/visdata/mobile01.dbf 12 0 5.83 1.00 3 0 0 0.00
SYSAUX /DB/visdata/sysaux01.dbf 18 0 7.22 1.44 639 0 0 0.00
SYSAUX /DB/visdata/sysaux02.dbf 274 0 1.82 1.06 857 0 0 0.00
SYSTEM /DB/visdata/sys1.dbf 566 0 3.67 3.86 103 0 39 0.00
SYSTEM /DB/visdata/sys2.dbf 578 0 3.84 4.02 210 0 95 0.11
SYSTEM /DB/visdata/sys3.dbf 706 0 3.57 3.42 259 0 11 0.00
SYSTEM /DB/visdata/sys4.dbf 620 0 2.90 3.76 256 0 0 0.00
SYSTEM /DB/visdata/sys5.dbf 856 0 4.05 2.94 686 0 875 0.06
SYSTEM /DB/visdata/sys6.dbf 643 0 4.15 3.72 64 0 5 0.00
SYSTEM /DB/visdata/sys7.dbf 494 0 4.57 3.89 181 0 65 0.00
SYSTEM /DB/visdata/sys8.dbf 448 0 4.51 2.86 517 0 20,602 0.06
SYSTEM /DB/visdata/sys9.dbf 484 0 4.46 2.63 479 0 63 0.48
TEMP /DB/visdata/temp1.dbf 135 0 4.30 8.44 3,486 1 52 3.65
TEMP /DB/visdata/temp2.dbf 84 0 4.05 1.00 2,045 1 4 2.50
TEMP /DB/visdata/temp3.dbf 169 0 4.44 18.28 2,518 1 33 5.15
TEMP /DB/visdata/temp4.dbf 125 0 4.40 6.45 2,258 1 2 0.00

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,184,816 100 2,175,382,448 453,694 3,154,940 0 0 707,340


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 101 48592 1190370 4585294 188743680 4585294  
E 180 104 54068 1188160 10212264 188743680 10212264  

Back to Advisory Statistics
Back to Top

 

Buffer Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

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

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

  PGA Aggr Target(M) Auto PGA Target(M) PGA Mem Alloc(M) W/A PGA Used(M) %PGA W/A Mem %Auto W/A Mem %Man W/A Mem Global Mem Bound(K)
B 20,480 1,280 47,234.26 0.17 0.00 100.00 0.00 1,048,576
E 20,480 1,280 54,727.39 1.13 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,989,372 5,989,372 0 0
64K 128K 11,774 11,774 0 0
128K 256K 1,170 1,170 0 0
256K 512K 1,121 1,121 0 0
512K 1024K 188,288 188,288 0 0
1M 2M 438,967 438,967 0 0
2M 4M 72 70 2 0
4M 8M 21 19 2 0
8M 16M 2 2 0 0
32M 64M 8 8 0 0
64M 128M 6 6 0 0
128M 256M 2 2 0 0

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

PGA Target Est (MB) Size 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 941,140.16 9,092.35 99.00 1,211
5,120 0.25 941,140.16 9,047.53 99.00 1,182
10,240 0.50 941,140.16 8,926.17 99.00 1,131
15,360 0.75 941,140.16 8,780.90 99.00 1,078
20,480 1.00 941,140.16 5.28 100.00 1,033
24,576 1.20 941,140.16 5.28 100.00 1,000
28,672 1.40 941,140.16 5.28 100.00 939
32,768 1.60 941,140.16 5.28 100.00 830
36,864 1.80 941,140.16 5.28 100.00 562
40,960 2.00 941,140.16 0.00 100.00 119
61,440 3.00 941,140.16 0.00 100.00 0
81,920 4.00 941,140.16 0.00 100.00 0
122,880 6.00 941,140.16 0.00 100.00 0
163,840 8.00 941,140.16 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,360 0.50 305 13,711 2,327,915 1.00 4,464 3.63 208,722,605
1,632 0.60 552 17,034 2,329,474 1.00 2,905 2.36 208,844,802
1,904 0.70 823 20,869 2,330,787 1.00 1,592 1.29 208,948,391
2,176 0.80 1,093 25,258 2,331,104 1.00 1,275 1.04 208,975,716
2,448 0.90 1,350 32,084 2,331,145 1.00 1,234 1.00 208,979,713
2,720 1.00 1,537 37,621 2,331,148 1.00 1,231 1.00 208,980,191
2,992 1.10 1,604 39,955 2,331,148 1.00 1,231 1.00 208,980,246
3,264 1.20 1,604 39,955 2,331,148 1.00 1,231 1.00 208,980,256
3,536 1.30 1,604 39,955 2,331,148 1.00 1,231 1.00 208,980,256
3,808 1.40 1,604 39,955 2,331,148 1.00 1,231 1.00 208,980,256
4,080 1.50 1,604 39,955 2,331,148 1.00 1,231 1.00 208,980,256
4,352 1.60 1,604 39,955 2,331,148 1.00 1,231 1.00 208,980,256
4,624 1.70 1,604 39,955 2,331,148 1.00 1,231 1.00 208,980,256
4,896 1.80 1,604 39,955 2,331,148 1.00 1,231 1.00 208,980,256
5,168 1.90 1,604 39,955 2,331,148 1.00 1,231 1.00 208,980,256
5,440 2.00 1,604 39,955 2,331,148 1.00 1,231 1.00 208,980,256

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 31,531  
10,240 0.50 31,531  
15,360 0.75 31,531  
20,480 1.00 31,530  
25,600 1.25 31,531  
30,720 1.50 31,535  
35,840 1.75 31,535  
40,960 2.00 31,536  

Back to Advisory Statistics
Back to Top

 

Streams Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Java Pool Advisory

Java Pool Size(M) JP Size Factr Est LC Size (M) Est LC Mem Obj Est LC Time Saved (s) Est LC Time Saved Factr Est LC Load Time (s) Est LC Load Time Factr Est LC Mem Obj Hits
16 0.25 13 247 1,191 1.00 1,231 1.00 18,403
32 0.50 13 247 1,191 1.00 1,231 1.00 18,403
48 0.75 13 247 1,191 1.00 1,231 1.00 18,403
64 1.00 13 247 1,191 1.00 1,231 1.00 18,403
80 1.25 13 247 1,191 1.00 1,231 1.00 18,403
96 1.50 13 247 1,191 1.00 1,231 1.00 18,403
112 1.75 13 247 1,191 1.00 1,231 1.00 18,403
128 2.00 13 247 1,191 1.00 1,231 1.00 18,403

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 440,514 88 0
undo block 209,788 7 0
undo header 49,768 3 0
1st level bmb 4,180 0 0
file header block 95 0 4
segment header 2,240 0 0
2nd level bmb 771 0 0
extent map 9 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) 5,387 663 4,724 613 99 160.90
UL-User-defined 69,451 68,394 1,057 2,383 53 22.14
TX-Transaction (index contention) 27,278 27,278 0 23,965 11 0.48
RO-Multiple Object Reuse (fast object reuse) 288 288 0 29 5 166.55
HW-Segment High Water Mark 280,074 280,067 7 2,032 2 0.97
DV-Diana Versioning 32,387 32,387 0 183 1 6.23
TX-Transaction 1,342,575 1,342,576 0 1,802 1 0.58
SQ-Sequence Cache 43,263 43,263 0 2,909 1 0.26
FB-Format Block 36,971 36,971 0 549 0 0.26
TX-Transaction (allocate ITL entry) 169 169 0 73 0 0.82
TM-DML 2,175,044 2,174,964 13 3 0 20.00
CU-Cursor 9,234 9,234 0 2 0 10.00
PS-PX Process Reservation 1,864 1,544 320 26 0 0.38

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,613.00 1,334,540 2,680 383 184.9/553.75 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
12-Oct 07:45 215,882 183,248 523 380 192 0/0 0/0/0/0/0/0
12-Oct 07:35 77,949 132,023 370 375 197 0/0 0/0/0/0/0/0
12-Oct 07:25 458,074 209,492 677 371 185 0/0 0/0/0/0/0/0
12-Oct 07:15 356,062 272,816 2,445 383 236 0/0 0/0/0/0/0/0
12-Oct 07:05 337,749 376,047 2,680 380 315 0/0 0/0/0/0/0/0
12-Oct 06:55 167,286 160,914 1,729 379 554 0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

 

Latch Statistics

Back to Top

Latch Activity

Latch Name Get Requests Pct Get Miss Avg Slps /Miss Wait Time (s) NoWait Requests Pct NoWait Miss
ASM db client latch 2,467 0.00   0 0  
AWR Alerted Metric Element list 335,057 0.00   0 0  
Consistent RBA 846,592 0.07 0.03 0 0  
FOB s.o list latch 55,356 0.02 0.00 0 0  
In memory undo latch 849,821,584 1.65 0.00 12 1,279,750 0.00
JOX SGA heap latch 1,951,344 0.00   0 0  
JS mem alloc latch 8 0.00   0 0  
JS queue access latch 8 0.00   0 0  
JS queue state obj latch 21,600 0.00   0 0  
JS slv state obj latch 183 0.00   0 0  
KMG MMAN ready and startup request latch 2,928 0.00   0 0  
KMG resize request state object freelist 22 0.00   0 0  
KTF sga latch 12 0.00   0 1,213 0.00
KWQMN job cache list latch 14,387 0.19 0.93 0 0  
MQL Tracking Latch 0     0 72 0.00
Memory Management Latch 1,925 0.00   0 2,916 0.00
OS process 15,291 0.00   0 0  
OS process allocation 11,433 0.01 0.00 0 0  
OS process: request allocation 9,952 0.00   0 0  
PL/SQL warning settings 4,611,180 0.00   0 0  
SGA IO buffer pool latch 41,920 0.22 0.00 0 43,021 0.22
SQL memory manager latch 1 0.00   0 1,199 0.00
SQL memory manager workarea list latch 7,216,151 0.01 0.02 0 0  
Shared B-Tree 129 0.00   0 0  
active checkpoint queue latch 972,420 0.52 0.00 0 2 0.00
active service list 48,836 0.07 0.00 0 1,284 0.00
begin backup scn array 135 0.00   0 0  
buffer pool 22 0.00   0 0  
cache buffer handles 20,704,835 1.15 0.00 0 0  
cache buffers chains 5,167,822,821 0.93 0.02 50 19,078,965 2.42
cache buffers lru chain 10,240,249 0.36 0.05 2 38,110,686 0.48
cache table scan latch 2,145 0.00   0 2,145 0.00
channel handle pool latch 414,917 0.08 0.01 0 0  
channel operations parent latch 1,791,464 0.42 0.00 0 0  
checkpoint queue latch 15,253,878 0.02 0.02 0 3,167,730 0.02
client/application info 1,796,413 0.00 0.00 0 0  
commit callback allocation 88,556 0.00   0 0  
compile environment latch 3,154,587 0.00   0 0  
dictionary lookup 76 0.00   0 0  
dml lock allocation 4,333,041 0.19 0.02 0 0  
dummy allocation 20,373 0.16 0.00 0 0  
enqueue hash chains 9,445,574 0.06 0.01 0 307 0.00
enqueues 5,414,747 0.11 0.01 0 0  
error message lists 816 1.10 0.00 0 0  
event group latch 4,995 0.00   0 0  
file cache latch 22,043 0.00 0.00 0 0  
global KZLD latch for mem in SGA 9,687 0.00   0 0  
global ctx hash table latch 24,496 0.00   0 0  
hash table column usage latch 1,937 0.10 0.00 0 15,511,294 0.00
hash table modification latch 144 0.00   0 0  
internal temp table object number allocation latc 6 0.00   0 0  
job workq parent latch 0     0 122 0.00
job_queue_processes parameter latch 120 0.00   0 0  
kks stats 31,231 0.00   0 0  
ksuosstats global area 242 0.00   0 0  
ktm global data 155,770 0.00   0 0  
kwqbsn:qsga 129 0.00   0 0  
lgwr LWN SCN 849,000 0.11 0.00 0 0  
library cache 356,107,880 0.38 0.01 10 21,757 4.49
library cache load lock 10,158 0.32 0.00 0 11 0.00
library cache lock 59,801,841 0.05 0.01 0 0  
library cache lock allocation 1,551,221 0.01 0.02 0 0  
library cache pin 222,013,833 0.13 0.01 2 52 0.00
library cache pin allocation 540,601 0.00 0.08 0 0  
list of block allocation 459,767 0.01 0.00 0 0  
loader state object freelist 322,382 0.00 0.00 0 0  
longop free list parent 33 0.00   0 33 0.00
message pool operations parent latch 421,550 0.01 0.08 0 0  
messages 5,307,626 0.38 0.01 0 0  
mostly latch-free SCN 898,358 3.95 0.00 0 0  
multiblock read objects 27,836 0.00 0.00 0 0  
ncodef allocation latch 189 0.00   0 0  
object queue header heap 2,957,835 0.03 0.28 0 404,783 0.07
object queue header operation 35,327,666 0.14 0.42 3 21,275 0.03
object stats modification 412,359 0.03 0.02 0 0  
parallel query alloc buffer 8,160 1.04 0.00 0 0  
parallel query stats 528 10.42 0.00 0 0  
parameter table allocation management 24,267 0.97 0.44 0 0  
post/wait queue 1,380,574 0.03 0.01 0 565,121 0.01
process allocation 10,000 0.17 0.88 0 4,994 0.02
process group creation 9,952 0.00   0 0  
process queue 5,030 0.76 0.00 0 0  
process queue reference 789,511 0.05 0.01 0 85,071 0.41
qmn task queue latch 516 0.00   0 0  
query server freelists 4,256 5.26 0.00 0 0  
query server process 8 0.00   0 8 0.00
redo allocation 5,567,288 1.58 0.01 1 103,759,795 1.66
redo copy 0     0 103,894,916 0.05
redo writing 3,951,382 0.20 0.01 0 0  
resmgr group change latch 859,823 0.00   0 0  
resmgr:actses active list 30,023 0.48 0.99 0 0  
resmgr:actses change group 29,435 0.00   0 0  
resmgr:free threads list 20,371 0.16 0.00 0 0  
resmgr:schema config 1 0.00   0 0  
row cache objects 128,247,477 0.22 0.00 1 7,083 0.13
rules engine aggregate statistics 41,610 0.00   0 0  
rules engine rule set statistics 133,740 0.00 0.00 0 0  
rules engine rule statistics 50,520 0.00   0 0  
sequence cache 16,638,272 0.46 0.00 0 0  
session allocation 19,764,863 0.46 0.01 0 0  
session idle bit 102,651,842 0.01 0.02 0 0  
session state list latch 59,041 0.10 0.69 0 0  
session switching 15,267 0.00   0 0  
session timer 1,284 0.00   0 0  
shared pool 7,813,496 0.16 0.06 0 0  
shared pool sim alloc 373 0.00   0 0  
shared pool simulator 1,914,463 0.00 0.06 0 0  
sim partition latch 1 0.00   0 24,164 0.08
simulator hash latch 2,460 0.00   0 0  
simulator lru latch 1,518 0.00   0 0  
slave class 1 0.00   0 0  
slave class create 4 0.00   0 0  
sort extent pool 1,424,122 0.09 0.01 0 0  
state object free list 12 0.00   0 0  
statistics aggregation 84 0.00   0 0  
temp lob duration state obj allocation 262 0.00   0 0  
temporary table state object allocation 12,640 0.00   0 0  
threshold alerts latch 605 0.00   0 0  
trace latch 48 0.00   0 0  
transaction allocation 117,402 0.00   0 0  
transaction branch allocation 189 0.00   0 0  
undo global data 1,096,027,346 1.06 0.00 8 24,230 0.17
user lock 38,804 0.01 0.00 0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch Name Get Requests Misses Sleeps Spin Gets Sleep1 Sleep2 Sleep3
cache buffers chains 5,167,822,821 48,207,068 1,064,930 47,262,037 0 0 0
In memory undo latch 849,821,584 13,991,139 34,218 13,963,449 0 0 0
undo global data 1,096,027,346 11,584,549 13,767 11,572,763 0 0 0
library cache 356,107,880 1,363,201 12,069 1,352,363 0 0 0
row cache objects 128,247,477 281,547 1,026 280,576 0 0 0
library cache pin 222,013,833 279,515 3,294 276,538 0 0 0
cache buffer handles 20,704,835 238,807 281 238,563 0 0 0
session allocation 19,764,863 91,739 891 90,925 0 0 0
redo allocation 5,567,288 88,022 1,262 86,862 0 0 0
sequence cache 16,638,272 76,415 143 76,298 0 0 0
object queue header operation 35,327,666 50,051 20,956 31,025 0 0 0
cache buffers lru chain 10,240,249 36,929 1,816 35,229 0 0 0
mostly latch-free SCN 898,358 35,447 95 35,362 0 0 0
library cache lock 59,801,841 31,140 200 30,948 0 0 0
messages 5,307,626 20,015 117 19,900 0 0 0
session idle bit 102,651,842 15,162 252 14,916 0 0 0
shared pool 7,813,496 12,433 784 11,728 0 0 0
dml lock allocation 4,333,041 8,188 125 8,074 0 0 0
redo writing 3,951,382 7,897 46 7,851 0 0 0
channel operations parent latch 1,791,464 7,557 18 7,541 0 0 0
enqueues 5,414,747 5,926 88 5,839 0 0 0
enqueue hash chains 9,445,574 5,257 39 5,220 0 0 0
active checkpoint queue latch 972,420 5,086 17 5,071 0 0 0
checkpoint queue latch 15,253,878 2,422 39 2,386 0 0 0
sort extent pool 1,424,122 1,346 18 1,328 0 0 0
object queue header heap 2,957,835 959 268 724 0 0 0
lgwr LWN SCN 849,000 896 1 895 0 0 0
Consistent RBA 846,592 573 17 561 0 0 0
post/wait queue 1,380,574 440 4 436 0 0 0
SQL memory manager workarea list latch 7,216,151 375 8 367 0 0 0
process queue reference 789,511 364 2 363 0 0 0
channel handle pool latch 414,917 341 3 338 0 0 0
parameter table allocation management 24,267 235 103 137 0 0 0
resmgr:actses active list 30,023 145 143 4 0 0 0
library cache lock allocation 1,551,221 128 3 125 0 0 0
object stats modification 412,359 119 2 117 0 0 0
session state list latch 59,041 59 41 19 0 0 0
shared pool simulator 1,914,463 36 2 34 0 0 0
KWQMN job cache list latch 14,387 28 26 2 0 0 0
message pool operations parent latch 421,550 24 2 23 0 0 0
process allocation 10,000 17 15 2 0 0 0
library cache pin allocation 540,601 13 1 12 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch Name Where NoWait Misses Sleeps Waiter Sleeps
In memory undo latch kturbk 0 25,748 27,988
In memory undo latch ktiFlush: child 0 4,582 2,808
In memory undo latch kticmt: child 0 3,081 566
In memory undo latch ktichg: child 0 495 2,761
In memory undo latch ktiTxnPoolFree 0 282 1
In memory undo latch ktiBRacquire 0 19 0
In memory undo latch ktbgfc 0 10 111
In memory undo latch ktuswr 0 1 0
KWQMN job cache list latch kwqmnuji: update job item 0 27 3
SQL memory manager workarea list latch qesmmIRegisterWorkArea 0 6 5
SQL memory manager workarea list latch qesmmIUnRegisterWorkArea 0 2 7
active checkpoint queue latch kcbbacq: scan active checkpoints 0 17 17
cache buffer handles kcbzgs 0 178 170
cache buffer handles kcbzfs 0 103 111
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 1,283,854 1,506,019
cache buffers chains kcbgtcr: fast path 0 587,209 26,068
cache buffers chains kcbchg: kslbegin: call CR func 0 379,355 897,402
cache buffers chains kcbzgb: scan from tail. nowait 0 129,421 0
cache buffers chains kcbgtcr: kslbegin excl 0 118,293 45,933
cache buffers chains kcbrls: kslbegin 0 29,487 64,133
cache buffers chains kcbgcur: kslbegin 0 25,637 13,019
cache buffers chains kcbget: pin buffer 0 15,248 6,628
cache buffers chains kcbzwb 0 5,534 5,840
cache buffers chains kcbcge 0 2,301 5,478
cache buffers chains kcbget: exchange rls 0 621 509
cache buffers chains kcbget: exchange 0 298 1,173
cache buffers chains kcbbxsv 0 283 260
cache buffers chains kcbnlc 0 192 1,319
cache buffers chains kcb_is_private 0 189 2,200
cache buffers chains kcbgtcr: kslbegin shared 0 84 69
cache buffers chains kcbnew: new latch again 0 65 8
cache buffers chains kcb_pre_apply: kcbhq61 0 59 1,601
cache buffers chains kcbesc: escalate 0 53 21
cache buffers chains kcb_post_apply: kcbhq63 0 26 260
cache buffers chains kcbbic2 0 14 5
cache buffers chains kcbso1: set no access 0 12 35
cache buffers chains kcb_post_apply: kcbhq62 0 3 319
cache buffers chains kcbzib: finish free bufs 0 2 4
cache buffers chains kcbo_ivd_process 0 1 43
cache buffers chains kcbw_next_free 0 1 0
cache buffers lru chain kcbzgws 0 1,062 0
cache buffers lru chain kcbgtcr:CR Scan:KCBRSKIP 0 217 0
cache buffers lru chain kcbbxsv: move to being written 0 193 528
cache buffers lru chain kcbo_link_q 0 148 30
cache buffers lru chain kcbzgb: posted for free bufs 0 92 459
cache buffers lru chain kcbo_ivd_proc 0 44 416
cache buffers lru chain kcbzswcu 0 28 78
cache buffers lru chain kcbbic2 0 21 275
cache buffers lru chain kcbzfw 0 4 0
cache buffers lru chain kcbzib 0 4 1
cache buffers lru chain kcbbwlru 0 1 67
cache buffers lru chain kcbzgm 0 1 0
cache buffers lru chain kcbzgpwb: KSLBEGIN use prewarm buffers 0 1 52
channel handle pool latch ksrchconnect() 0 9 3
channel operations parent latch ksrapublish() 0 15 3
channel operations parent latch ksrwait() 0 6 21
channel operations parent latch ksrchdelete() 0 4 4
channel operations parent latch ksrchconnect() 0 3 9
channel operations parent latch ksrmfree() 0 2 1
channel operations parent latch ksrsconsume() 0 1 1
checkpoint queue latch kcbbwthc: thread checkpoint buffers 0 18 12
checkpoint queue latch kcbklbc: Link buffer into ckpt queue 0 9 0
checkpoint queue latch kcbkubc 0 8 15
checkpoint queue latch kcbswcu: Switch buffers 0 3 13
checkpoint queue latch kcbnlc: Link buffers into FQ 0 1 0
dml lock allocation ktaiam 0 83 91
dml lock allocation ktaidm 0 42 34
enqueue hash chains ksqgtl3 0 25 16
enqueue hash chains ksqrcl 0 10 20
enqueue hash chains ksqcmi: get hash chain latch after wait 0 3 2
enqueues ksqies 0 37 60
enqueues ksqgel: create enqueue 0 27 21
enqueues ksqdel 0 24 7
lgwr LWN SCN kcs023 0 28 0
library cache kglpndl: child: after processing 0 4,733 130
library cache kglpnp: child 0 4,462 6,204
library cache kglobpn: child: 0 1,021 1,756
library cache kglpndl: child: before processing 0 639 3,097
library cache kglLockCursor 0 292 397
library cache kglScanDependency 0 183 0
library cache kglpin 0 139 58
library cache kgldte: child 0 0 125 213
library cache kglhdgn: child: 0 110 162
library cache kgldti: 2child 0 31 13
library cache kglic 0 16 0
library cache kglhdiv: child 0 7 1
library cache kglivl: child 0 3 0
library cache kglupd: child 0 3 0
library cache kglget: unpin heap 0 0 2 0
library cache kglhdgc: child: 0 2 0
library cache kgldrp: child 0 1 0
library cache kglhdiv0: child 0 1 0
library cache kglukp: child 0 1 0
library cache lock kgllkdl: child: cleanup 0 122 112
library cache lock kgllkdl: child: no lock handle 0 86 23
library cache lock kgllkal: child: multiinstance 0 78 88
library cache lock allocation kgllkget 0 3 3
library cache pin kglpndl 0 1,570 986
library cache pin kglpnp: child 0 1,480 1,828
library cache pin kglpnal: child: alloc space 0 244 480
library cache pin allocation kglpnget 0 1 1
message pool operations parent latch ksrmalloc() 0 2 2
messages ksarcv 0 49 19
messages ksarcv: after wait 0 43 67
messages ksaamb: after wakeup 0 25 31
mostly latch-free SCN kcslcu3 0 67 96
mostly latch-free SCN kcs01 0 9 17
mostly latch-free SCN kcsnew_scn_rba 0 8 0
mostly latch-free SCN kcs024 0 1 0
object queue header heap kcbo_link_q:reget 0 257 7
object queue header heap kcbw_link_q:alloc 0 9 261
object queue header heap kcbw_unlink_q 0 2 0
object queue header operation kcbo_ivbo 0 21,489 4,973
object queue header operation kcbw_link_q 0 3,685 2,518
object queue header operation kcbw_unlink_q 0 1,112 7,580
object queue header operation kcbo_switch_mq_bg 0 449 2,818
object queue header operation kcbo_switch_q_bg 0 324 1,900
object queue header operation kcbo_switch_cq 0 124 3,186
object queue header operation kcbo_link_q:reget 0 98 155
object queue header operation kcbo_write_q 0 34 4
object queue header operation kcbo_service_ockpt 0 29 1
object queue header operation kcbo_swap_buf_bg 0 10 3,938
object queue header operation kcbo_swap_buf 0 9 561
object queue header operation kcbw_unlink_q_bg 0 1 21
object stats modification ksoslinelm 0 2 1
parameter table allocation management ksp_param_table_free 0 103 103
post/wait queue ksliwat:remove 0 4 3
process allocation ksucrp 0 14 0
process allocation ksudlp 0 1 7
process queue reference kxfpqrsnd 0 2 0
redo allocation kcrfw_redo_gen: redo allocation 1 0 984 0
redo allocation kcrfw_redo_gen: redo allocation 3 0 188 769
redo allocation kcrfw_redo_gen: redo allocation 2 0 49 0
redo allocation kcrfw_redo_write: more space 0 26 318
redo allocation kcrfw_redo_write: before write 0 15 191
redo writing kcrfwcr 0 33 42
redo writing kcrfw_post: rba scn pair 0 9 0
redo writing kcrfw_post: after write 0 4 4
resmgr:actses active list kgskchclass 0 143 69
row cache objects kqreqd: reget 0 792 5
row cache objects kqrpre: find obj 0 158 890
row cache objects kqreqd 0 71 131
row cache objects kqrso 0 4 0
sequence cache kdnssd 0 91 4
sequence cache kdnnxt: cached seq 0 41 2
sequence cache kdnss 0 11 142
session allocation ksuprc 0 271 163
session allocation ksuxds: KSUSFCLC not set 0 216 20
session allocation ksudlc 0 152 233
session allocation ksucri 0 110 307
session allocation ksuxds: not user session 0 92 116
session allocation kspallmod 0 22 0
session allocation ksudlp 0 10 1
session allocation kxfpqidqr 0 8 28
session allocation ksursi 0 6 20
session allocation kxfprdp 0 3 3
session allocation ksucrp 0 1 0
session idle bit ksupuc: set busy 0 164 163
session idle bit ksupuc: clear busy 0 128 135
session idle bit ksuxds 0 16 10
session state list latch kpseqd 0 38 0
session state list latch kpscad 0 1 1
session state list latch kpscdl 0 1 25
session state list latch kpseqa 0 1 71
shared pool kghupr1 0 392 567
shared pool kghalo 0 296 132
shared pool kghfrunp: clatch: nowait 0 202 0
shared pool kghfrunp: alloc: wait 0 47 0
shared pool kghfre 0 36 70
shared pool kghfrunp: clatch: wait 0 11 14
shared pool kghalp 0 9 15
shared pool kgh: sim resz update 0 2 0
shared pool kghasp 0 1 0
shared pool kghfrunp: alloc: session dur 0 1 0
shared pool simulator kglsim_unpin_simhp 0 2 2
sort extent pool ktstdt: dealloc sort extent 0 14 2
sort extent pool ktstsmonmsg 0 3 12
sort extent pool ktstallocext: new extent in-doubt 0 1 0
undo global data kturimugur: child 0 12,002 8,085
undo global data ktudba: KSLBEGIN 0 1,666 5,639
undo global data ktudnx:child 0 33 23
undo global data ktucof: at start 0 24 0
undo global data ktufrbs: child 0 23 17
undo global data ktusmasp: ktugd_tuux 0 11 4
undo global data ktubnd:child 0 8 0

Back to Latch Statistics
Back to Top

 

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

 

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

 

Segment Statistics

Back to Top

Segments by Logical Reads

Owner Tablespace Name Object Name Subobject Name Obj. Type Logical Reads %Total
AR APPS_TS_TX_INTERFACE RA_INTERFACE_LINES_ALL   TABLE 68,348,928 3.14
INV APPS_TS_TX_IDX MTL_ITEM_CATEGORIES_U1   INDEX 51,059,968 2.35
ICX APPS_TS_TX_DATA ICX_SESSION_ATTRIBUTES   TABLE 25,153,984 1.16
ONT APPS_TS_TX_DATA OE_ORDER_LINES_ALL   TABLE 22,897,968 1.05
WSH APPS_TS_TX_DATA WSH_DELIVERY_DETAILS   TABLE 20,822,656 0.96

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,010 7.69
AR APPS_ASSM_DATA RA_CUSTOMER_TRX_LINES_ALL   TABLE 13,066 2.87
WSH APPS_TS_TX_DATA WSH_DELIVERY_DETAILS   TABLE 9,554 2.10
HR APPS_ASSM_DATA PAY_RUN_RESULTS   TABLE 4,048 0.89
GL APPS_TS_TX_DATA GL_CODE_COMBINATIONS   TABLE 1,132 0.25

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 14,980 33.26
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_U1   INDEX 9,395 20.86
WSH APPS_TS_TX_DATA WSH_TRIP_STOPS   TABLE 8,966 19.91
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N6   INDEX 2,174 4.83
HR APPS_ASSM_IDX PAY_RUN_RESULT_VALUES_PK   INDEX 1,740 3.86

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 17 27.87
APPLSYS APPS_TS_TX_IDX WF_ITEM_ATTRIBUTE_VALUES_PK   INDEX 11 18.03
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N5   INDEX 10 16.39
GL APPS_ASSM_IDX GL_IMPORT_REFERENCES_N3   INDEX 4 6.56
GL APPS_ASSM_IDX GL_JE_LINES_N1   INDEX 4 6.56

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 127,744 34.71
APPLSYS APPS_TS_TX_DATA WF_ITEM_ATTRIBUTE_VALUES   TABLE 76,297 20.73
SYS SYSTEM DBMS_LOCK_ALLOCATED   TABLE 20,581 5.59
AR APPS_ASSM_DATA RA_CUST_TRX_LINE_GL_DIST_ALL   TABLE 17,489 4.75
APPLSYS APPS_TS_TX_DATA WF_ITEM_ACTIVITY_STATUSES WF_ITEM49 TABLE PARTITION 16,050 4.36

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.22 0   648 0
dc_files 6,660 0.00 0   0 111
dc_global_oids 7,853,638 0.00 0   0 43
dc_histogram_data 67,252 0.93 0   0 641
dc_histogram_defs 418,134 2.51 0   4,044 3,704
dc_object_grants 72,674 0.06 0   0 74
dc_object_ids 12,655,581 0.01 0   58 1,372
dc_objects 182,187 1.02 0   346 788
dc_profiles 9,746 0.00 0   0 1
dc_rollback_segments 20,547 0.00 0   0 389
dc_segments 367,678 0.71 0   16,157 1,351
dc_sequences 53,645 0.14 0   53,645 115
dc_table_scns 20,653 0.04 0   0 5
dc_tablespace_quotas 16,019 0.13 0   213 43
dc_tablespaces 5,963,923 0.00 0   0 22
dc_usernames 514,911 0.01 0   0 18
dc_users 15,140,589 0.00 0   0 63
outstanding_alerts 268 16.42 0   1 42


Back to Top

 

Library Cache Activity

Namespace Get Requests Pct Miss Pin Requests Pct Miss Reloads Invali- dations
BODY 636,094 0.02 42,611,552 0.00 15 0
CLUSTER 105 0.95 253 0.40 0 0
INDEX 15,818 0.40 16,630 0.56 0 0
JAVA DATA 626 0.00 0   0 0
PIPE 50,580 2.55 74,655 1.73 0 0
SQL AREA 6,441 89.83 114,750,932 0.44 3,942 447
TABLE/PROCEDURE 408,981 0.25 58,036,377 0.01 1,197 0
TRIGGER 28,740 0.09 1,408,996 0.00 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 37,381.17   12.11 7.03 40 40 3,088 3,088
  Freeable 3,692.94 0.00 1.35 0.82 9   2,743 2,743
  SQL 3,502.63 1,794.57 1.14 0.71 4 22 3,080 3,079
  PL/SQL 2,385.34 190.43 0.77 0.96 3 3 3,088 3,088
  JAVA 268.30 267.02 2.24 0.30 5 8 120 120
E Other 43,431.59   13.90 8.46 41 41 3,124 3,124
  Freeable 4,249.44 0.00 1.51 0.94 9   2,821 2,821
  SQL 4,004.55 2,092.97 1.29 0.76 5 22 3,116 3,115
  PL/SQL 2,765.02 215.40 0.89 0.99 3 3 3,124 3,124
  JAVA 268.27 266.97 2.24 0.30 5 8 120 120

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions Begin Size (Bytes) End Size (Bytes) (if different)
Database Buffers 18,706,595,840 18,522,046,464
Fixed Size 2,111,120  
Redo Buffers 14,663,680  
Variable Size 2,751,465,840 2,936,015,216

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 37.43 37.58 0.40
shared KTI-UNDO 53.19 53.19 0.00
shared PL/SQL MPCODE 66.57 69.50 4.41
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 336.63 353.86 5.12
shared library cache 852.81 1,002.35 17.53
shared parameter table block 57.65 58.01 0.63
shared private strands 99.77 99.77 0.00
shared sessions 36.42 36.42 0.00
shared sql area 366.81 377.41 2.89
shared trace buffer 48.27 49.00 1.52
  buffer_cache 17,840.00 17,664.00 -0.99
  fixed_sga 2.01 2.01 0.00
  log_buffer 13.98 13.98 0.00

Back to Memory Statistics
Back to Top

 

Streams Statistics

Back to Top

 

Streams CPU/IO Usage

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

Rule Set

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

Resource Limit Stats

Resource Name Current Utilization Maximum Utilization Initial Allocation Limit
processes 3,125 3,137 3600 3600


Back to Top

 

init.ora Parameters

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


Back to Top

End of Report