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 29-Jul-08 11:25:25 5273 210.6
End Snap: 2 29-Jul-08 12:25:31 5305 234.2
Elapsed:   60.09 (mins)    
DB Time:   644.81 (mins)    

 

Report Summary

Cache Sizes

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

Load Profile

  Per Second Per Transaction
Redo size: 8,772,404.55 25,335.95
Logical reads: 580,773.84 1,677.36
Block changes: 54,956.10 158.72
Physical reads: 126.79 0.37
Physical writes: 899.39 2.60
User calls: 13,803.42 39.87
Parses: 2,561.48 7.40
Hard parses: 2.62 0.01
Sorts: 3,031.11 8.75
Logons: 2.82 0.01
Executes: 29,124.13 84.11
Transactions: 346.24  

% Blocks changed per Read: 9.46 Recursive Call %: 77.32
Rollback per transaction %: 21.23 Rows per Sort: 12.32

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.96 Redo NoWait %: 100.00
Buffer Hit %: 99.98 In-memory Sort %: 100.00
Library Hit %: 99.75 Soft Parse %: 99.90
Execute to Parse %: 91.20 Latch Hit %: 98.67
Parse CPU to Parse Elapsd %: 88.63 % Non-Parse CPU: 97.73

Shared Pool Statistics

  Begin End
Memory Usage %: 86.72 87.81
% SQL with executions>1: 88.68 89.62
% Memory for SQL w/exec>1: 64.99 67.23

Top 5 Timed Events

Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class
CPU time   33,785   87.3  
log file sync 570,422 2,098 4 5.4 Commit
db file sequential read 247,729 1,060 4 2.7 User I/O
latch: cache buffers chains 2,294,045 724 0 1.9 Concurrency
log file parallel write 759,770 661 1 1.7 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 33,784.86 87.33
sql execute elapsed time 32,207.10 83.25
inbound PL/SQL rpc elapsed time 7,986.22 20.64
PL/SQL execution elapsed time 7,666.95 19.82
parse time elapsed 957.36 2.47
Java execution elapsed time 843.25 2.18
hard parse elapsed time 422.53 1.09
repeated bind elapsed time 152.78 0.39
sequence load elapsed time 30.15 0.08
connection management call elapsed time 18.86 0.05
PL/SQL compilation elapsed time 9.31 0.02
hard parse (sharing criteria) elapsed time 4.23 0.01
failed parse elapsed time 2.37 0.01
hard parse (bind mismatch) elapsed time 1.34 0.00
DB time 38,688.50  
background elapsed time 1,748.00  
background cpu time 704.52  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait Class Waits %Time -outs Total Wait Time (s) Avg wait (ms) Waits /txn
Commit 570,422 0.00 2,098 4 0.46
User I/O 298,544 0.00 1,267 4 0.24
Concurrency 3,212,592 0.16 1,265 0 2.57
System I/O 1,025,464 0.00 923 1 0.82
Network 56,720,115 0.00 252 0 45.43
Application 70,051 0.09 236 3 0.06
Other 253,259 22.48 212 1 0.20
Configuration 7,097 0.00 6 1 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
log file sync 570,422 0.00 2,098 4 0.46
db file sequential read 247,729 0.00 1,060 4 0.20
latch: cache buffers chains 2,294,045 0.00 724 0 1.84
log file parallel write 759,770 0.00 661 1 0.61
db file parallel write 234,817 0.00 247 1 0.19
buffer busy waits 788,426 0.00 228 0 0.63
enq: TX - row lock contention 1,070 4.30 146 136 0.00
SQL*Net more data from client 2,565,674 0.00 137 0 2.06
db file scattered read 17,513 0.00 136 8 0.01
latch: library cache 40,122 0.00 119 3 0.03
SQL*Net message to client 52,131,554 0.00 73 0 41.76
enq: UL - contention 1,446 1.18 66 46 0.00
read by other session 30,350 0.00 65 2 0.02
cursor: pin S wait on X 5,539 92.44 57 10 0.00
latch: undo global data 25,593 0.00 53 2 0.02
SQL*Net more data to client 2,022,887 0.00 41 0 1.62
latch: In memory undo latch 28,783 0.00 38 1 0.02
latch: cache buffers lru chain 6,385 0.00 35 6 0.01
latch: library cache pin 11,826 0.00 34 3 0.01
latch: object queue header operation 37,425 0.00 27 1 0.03
enq: TX - index contention 31,847 0.00 26 1 0.03
SQL*Net break/reset to client 67,500 0.00 18 0 0.05
latch: row cache objects 6,130 0.00 17 3 0.00
PX Deq Credit: send blkd 22,391 0.00 14 1 0.02
control file sequential read 29,140 0.00 14 0 0.02
buffer deadlock 55,785 98.35 13 0 0.04
library cache load lock 641 0.00 13 20 0.00
LGWR wait for redo copy 32,580 0.32 13 0 0.03
rdbms ipc reply 11 36.36 10 943 0.00
latch free 3,968 0.00 9 2 0.00
latch: redo allocation 4,530 0.00 7 1 0.00
wait list latch free 458 0.00 5 12 0.00
enq: RO - fast object reuse 32 0.00 5 155 0.00
latch: session allocation 3,114 0.00 5 2 0.00
kksfbc child completion 107 77.57 4 39 0.00
os thread startup 71 0.00 4 52 0.00
local write wait 1,737 0.00 4 2 0.00
cursor: pin S 52,738 0.00 3 0 0.04
enq: SQ - contention 4,270 0.00 3 1 0.00
enq: HW - contention 2,563 0.00 3 1 0.00
PX Deq: Signal ACK 259 36.68 3 10 0.00
latch: cache buffer handles 1,157 0.00 3 2 0.00
row cache lock 1,376 0.00 2 2 0.00
control file parallel write 1,737 0.00 2 1 0.00
latch: object queue header heap 923 0.00 2 2 0.00
enq: TX - contention 2,467 0.00 2 1 0.00
latch: shared pool 1,370 0.00 1 1 0.00
direct path read 732 0.00 1 2 0.00
enq: DV - contention 216 0.00 1 6 0.00
latch: library cache lock 796 0.00 1 1 0.00
enq: FB - contention 822 0.00 1 1 0.00
latch: enqueue hash chains 123 0.00 1 6 0.00
latch: redo writing 143 0.00 1 4 0.00
enq: TM - contention 3 0.00 0 117 0.00
PX qref latch 1,840 95.92 0 0 0.00
SGA: allocation forcing component growth 22 45.45 0 14 0.00
library cache lock 10 0.00 0 23 0.00
library cache pin 1,416 0.00 0 0 0.00
enq: CU - contention 11 0.00 0 17 0.00
latch: messages 214 0.00 0 1 0.00
latch: checkpoint queue latch 55 0.00 0 2 0.00
enq: TX - allocate ITL entry 115 0.00 0 1 0.00
reliable message 24 0.00 0 1 0.00
cursor: pin X 2 100.00 0 12 0.00
enq: US - contention 3 0.00 0 8 0.00
L1 validation 3 66.67 0 7 0.00
enq: PS - contention 33 0.00 0 0 0.00
write complete waits 6 0.00 0 1 0.00
cursor: mutex S 155 0.00 0 0 0.00
direct path write 439 0.00 0 0 0.00
cursor: mutex X 39 0.00 0 0 0.00
direct path write temp 38 0.00 0 0 0.00
direct path read temp 6 0.00 0 0 0.00
SQL*Net message from client 52,131,545 0.00 10,120,964 194 41.76
pipe get 31,106 13.92 21,127 679 0.02
PL/SQL lock timer 293 99.66 3,573 12195 0.00
Streams AQ: qmn slave idle wait 129 0.00 3,520 27286 0.00
Streams AQ: qmn coordinator idle wait 258 50.00 3,520 13643 0.00
Streams AQ: waiting for time management or cleanup tasks 2,968 40.16 3,499 1179 0.00
PX Idle Wait 1,641 76.54 2,602 1586 0.00
jobq slave wait 612 99.84 1,793 2930 0.00
PX Deq: Execution Msg 5,255 0.00 44 8 0.00
PX Deq: Execute Reply 2,739 0.00 4 2 0.00
PX Deq Credit: need buffer 5,015 0.00 1 0 0.00
PX Deq: Table Q Normal 8,493 0.00 1 0 0.01
PX Deq: Msg Fragment 4,475 0.00 1 0 0.00
PX Deq: Parse Reply 222 0.00 0 1 0.00
PX Deq: Join ACK 131 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 759,774 0.00 661 1 0.61
db file parallel write 234,817 0.00 247 1 0.19
events in waitclass Other 48,851 0.21 33 1 0.04
control file sequential read 827 0.00 4 5 0.00
os thread startup 62 0.00 3 55 0.00
control file parallel write 1,737 0.00 2 1 0.00
db file scattered read 455 0.00 2 4 0.00
direct path read 732 0.00 1 2 0.00
db file sequential read 163 0.00 1 4 0.00
latch: redo writing 143 0.00 1 4 0.00
latch: cache buffers chains 148 0.00 0 3 0.00
latch: library cache pin 3 0.00 0 53 0.00
latch: row cache objects 2 0.00 0 31 0.00
latch: library cache 5 0.00 0 1 0.00
direct path write 333 0.00 0 0 0.00
latch: shared pool 1 0.00 0 2 0.00
log file sync 1 0.00 0 2 0.00
latch: In memory undo latch 8 0.00 0 0 0.00
buffer busy waits 9 0.00 0 0 0.00
rdbms ipc message 1,614,425 0.72 36,256 22 1.29
Streams AQ: qmn slave idle wait 129 0.00 3,520 27286 0.00
Streams AQ: qmn coordinator idle wait 258 50.00 3,520 13643 0.00
pmon timer 1,261 96.91 3,511 2784 0.00
Streams AQ: waiting for time management or cleanup tasks 2,967 40.14 3,498 1179 0.00
smon timer 162,263 0.00 3,485 21 0.13

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic Total
BUSY_TIME 3,695,519
IDLE_TIME 2,056,863
IOWAIT_TIME 69,927
NICE_TIME 0
SYS_TIME 228,950
USER_TIME 3,311,457
LOAD 8
RSRC_MGR_CPU_WAIT_TIME 0
PHYSICAL_MEMORY_BYTES 46,912,040
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 38,677.20 33,774.30 441,948 2,089,781,964
SYS$BACKGROUND 0.00 0.00 15,217 4,028,248
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 296832 126273 3212346 126106 0 0 56703700 25161
SYS$BACKGROUND 1688 391 238 412 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
1,172 1,120 300 3.91 3.03 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
870 707 113,023 0.01 2.25 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
748 654 1,444 0.52 1.93 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
682 605 56,895 0.01 1.76 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...
665 568 57,187 0.01 1.72 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
659 584 57,183 0.01 1.70 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
633 589 202,566 0.00 1.64 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
617 580 64,021 0.01 1.60 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
607 595 375,523 0.00 1.57 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
430 399 266,272 0.00 1.11 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
421 388 81,294 0.01 1.09 3prk3vg9u0abb FNDOAMCOL BEGIN FND_GLOBAL.APPS_INITIA...
405 314 173,643 0.00 1.05 3b3psftuyks81 INVTTMTX BEGIN INV_TXNSTUB_PUB.postTran...

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
1,120 1,172 300 3.73 3.03 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
707 870 113,023 0.01 2.25 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
654 748 1,444 0.45 1.93 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
605 682 56,895 0.01 1.76 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...
595 607 375,523 0.00 1.57 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
589 633 202,566 0.00 1.64 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
584 659 57,183 0.01 1.70 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
580 617 64,021 0.01 1.60 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
568 665 57,187 0.01 1.72 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
399 430 266,272 0.00 1.11 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
388 421 81,294 0.00 1.09 3prk3vg9u0abb FNDOAMCOL BEGIN FND_GLOBAL.APPS_INITIA...
314 405 173,643 0.00 1.05 3b3psftuyks81 INVTTMTX BEGIN INV_TXNSTUB_PUB.postTran...

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
76,212,071 202,566 376.23 3.64 589.08 633.26 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
73,993,583 266,272 277.89 3.53 399.41 430.37 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
45,259,259 300 150,864.20 2.16 1120.31 1172.43 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
44,405,959 57,183 776.56 2.12 583.81 659.03 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
43,184,213 1,444 29,905.96 2.06 653.57 748.28 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
40,300,801 64,021 629.49 1.92 579.95 617.40 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
38,356,158 57,187 670.71 1.83 568.41 664.96 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
38,135,581 157,181 242.62 1.82 176.59 188.89 5kqw5535fjvw6 ARXTWMAI SELECT NVL(RCTT.ATTRIBUTE10, ...
37,986,218 1,585,320 23.96 1.81 243.82 286.79 66tmsr3446uqn ap.oie.server.WebExpensesAM SELECT WIAS.ACTIVITY_STATUS, ...
32,324,701 173,739 186.05 1.54 293.35 382.31 gf1u933c95jb5 INVTTMTX DECLARE l_ret_stat varchar2...
32,219,937 173,643 185.55 1.54 314.44 405.00 3b3psftuyks81 INVTTMTX BEGIN INV_TXNSTUB_PUB.postTran...
30,293,645 56,895 532.45 1.45 604.66 681.52 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...
26,390,166 10,000 2,639.02 1.26 138.20 252.27 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
21,225,994 895,674 23.70 1.01 249.04 285.29 cd9mbmqyf4qhp ap.oie.server.WebExpensesAM UPDATE WF_ITEM_ACTIVITY_STATUS...

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,228 10,000 4.52 9.89 138.20 252.27 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
32,149 2,401 13.39 7.03 159.49 274.67 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
26,568 21,646 1.23 5.81 250.38 340.18 1q78dwnrrkf6c asn.lead.server.LeadUwqAM BEGIN ASN_SALES_PVT.Lead_Proce...
15,748 266,272 0.06 3.44 399.41 430.37 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
10,813 7,208 1.50 2.37 187.10 239.29 8jb36w62w5hqf ibuSRDetailsActions.jsp BEGIN IBU_REQ_PKG.UpdateServic...
10,779 202,566 0.05 2.36 589.08 633.26 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
4,585 9,997 0.46 1.00 189.45 206.52 csvvv0fmhr1yc PYUSLV BEGIN FFP1893_01010001.FORMULA...
1,499 15,017 0.10 0.33 144.38 203.31 00y09j4jtwps1 JDBC Thin Client declare sid number; l_enc_ke...
1,436 361 3.98 0.31 232.28 250.19 fumydqvpk1g21 qotSCopOverview.jsp BEGIN ASO_QUOTE_PUB_W.SUBMIT_Q...
1,159 100,925 0.01 0.25 173.60 178.43 7dtkxnqpkqszw jtfavald.jsp SELECT DISTINCT a.PERMISSION_...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows Processed Rows per Exec CPU per Exec (s) Elap per Exec (s) SQL Id SQL Module SQL Text
1,585,320 819,442 0.52 0.00 0.00 66tmsr3446uqn ap.oie.server.WebExpensesAM SELECT WIAS.ACTIVITY_STATUS, ...
895,674 894,165 1.00 0.00 0.00 cd9mbmqyf4qhp ap.oie.server.WebExpensesAM UPDATE WF_ITEM_ACTIVITY_STATUS...
840,511 839,920 1.00 0.00 0.00 gnhmcahkmrnzs ap.oie.server.WebExpensesAM INSERT INTO WF_ITEM_ACTIVITY_S...
597,346 597,320 1.00 0.00 0.00 avc1jqzz04wpr JDBC Thin Client SELECT 'x' FROM DUAL
462,959 463,389 1.00 0.00 0.00 821fx90awyvj7 OEXOETEL SELECT ACCOUNTING_RULE_ID , A...
375,523 375,512 1.00 0.00 0.00 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
342,942 261,315 0.76 0.00 0.00 fmfdkztk8vx23   SELECT CATEGORY, SEVERITY, F...
291,352 4,952,672 17.00 0.00 0.00 cwyx16zn1hpfb JDBC Thin Client select parameter, value from ...
266,272 0 0.00 0.00 0.00 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
202,566 202,565 1.00 0.00 0.00 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse Calls Executions % Total Parses SQL Id SQL Module SQL Text
597,320 597,346 6.47 avc1jqzz04wpr JDBC Thin Client SELECT 'x' FROM DUAL
375,555 375,523 4.07 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
342,946 342,942 3.71 fmfdkztk8vx23   SELECT CATEGORY, SEVERITY, F...
291,342 291,352 3.15 cwyx16zn1hpfb JDBC Thin Client select parameter, value from ...
202,562 202,566 2.19 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
172,178 173,903 1.86 6gnth2mfbs2nq INVTTMTX declare v_ret number := 0...
124,244 125,216 1.35 fb13x9qx0ftks OEXOETEL begin OE_STANDARD_WF.OEOL_SELE...
120,501 120,502 1.30 162ttnv4ubqun OEXOETEL begin OE_DS_PVT.Check_PO_Appr...
116,398 116,723 1.26 1c0b7sas42w2z INVTTMTX SELECT NVL(ITEM_COST, 0), ...
111,444 111,477 1.21 8camsgjsr9zya OEXOETEL begin OE_TRANSACTION_TYPES_PK...
101,086 101,340 1.09 76sw2a4vnc89j icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.S...
95,054 95,226 1.03 608c0n36kaw62 icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.C...
95,040 95,303 1.03 bf7uwg5pa3pj6 icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.V...
94,950 101,318 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
2,550,898 1,444 0.09 cjzdvgnq01bs1 OEXOETEL SELECT SOLD_TO, DEFAULT_FULFIL...

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
00y09j4jtwps1 declare sid number; l_enc_key icx_sessions.enc_key%type := null; l_mac_key icx_sessions.mac_key%type := null;begin sid := fnd_session_management.createSession( p_user_id => :1, c_mode_code => :2, p_server_id => :3); if sid > -1 then select enc_key, mac_key into l_enc_key, l_mac_key from icx_sessions where session_id = sid; end if; :4 := sid; :5 := l_enc_key; :6 := l_mac_key;end;
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;
25wzrzwd46a44 SELECT 1 FROM DUAL WHERE EXISTS ( SELECT 1 FROM FND_GRANTS G, WF_USER_ROLES R WHERE G.GRANTEE_KEY = R.ROLE_NAME AND R.USER_NAME IN (SELECT INCRNS.NAME FROM WF_LOCAL_ROLES SRC , WF_LOCAL_ROLES INCRNS WHERE SRC.NAME = :B4 AND SRC.PARENT_ORIG_SYSTEM = INCRNS.PARENT_ORIG_SYSTEM AND SRC.PARENT_ORIG_SYSTEM_ID = INCRNS.PARENT_ORIG_SYSTEM_ID) AND G.OBJECT_ID = :B3 AND ((:B2 = -1) OR (G.MENU_ID IN (SELECT CMF.MENU_ID FROM FND_COMPILED_MENU_FUNCTIONS CMF WHERE CMF.FUNCTION_ID = :B2 ))) AND ( G.CTX_SECGRP_ID = -1 OR G.CTX_SECGRP_ID = SYS_CONTEXT('FND', 'SECURITY_GROUP_ID')) AND ( G.CTX_RESP_ID = -1 OR G.CTX_RESP_ID = SYS_CONTEXT('FND', 'RESP_ID')) AND ( G.CTX_RESP_APPL_ID = -1 OR G.CTX_RESP_APPL_ID = SYS_CONTEXT('FND', 'RESP_APPL_ID')) AND ( G.CTX_ORG_ID = -1 OR G.CTX_ORG_ID = SYS_CONTEXT('FND', 'ORG_ID')) AND G.START_DATE <= SYSDATE AND ( G.END_DATE IS NULL OR G.END_DATE >= SYSDATE ) AND G.INSTANCE_TYPE = :B1 )
3b3psftuyks81 BEGIN INV_TXNSTUB_PUB.postTransaction(:1, :2, :3); END;
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;
76sw2a4vnc89j begin FND_FLEX_WORKFLOW_APIS.START_GENERATION (:v1, :v2, :v3, :v4, :v5); end;
7dtkxnqpkqszw SELECT DISTINCT a.PERMISSION_NAME, dom.DOMAIN_NAME, a.MAINTENANCE_MODE_FLAG FROM JTF_AUTH_PERMISSIONS_B A, JTF_AUTH_PRINCIPAL_MAPS B, JTF_AUTH_ROLE_PERMS C, JTF_AUTH_PRINCIPALS_B D, JTF_AUTH_PRINCIPALS_B E, JTF_AUTH_DOMAINS_B dom WHERE D.PRINCIPAL_NAME = :1 AND D.IS_USER_FLAG = 1 AND D.JTF_AUTH_PRINCIPAL_ID = B.JTF_AUTH_PRINCIPAL_ID AND B.JTF_AUTH_PARENT_PRINCIPAL_ID=E.JTF_AUTH_PRINCIPAL_ID AND E.IS_USER_FLAG = 0 AND E.JTF_AUTH_PRINCIPAL_ID = C.JTF_AUTH_PRINCIPAL_ID AND C.JTF_AUTH_PERMISSION_ID = A.JTF_AUTH_PERMISSION_ID AND C.POSITIVE_FLAG=1 AND B.JTF_AUTH_DOMAIN_ID = dom.JTF_AUTH_DOMAIN_ID ORDER BY A.PERMISSION_NAME
821fx90awyvj7 SELECT ACCOUNTING_RULE_ID , ACCOUNTING_RULE_DURATION , ACTUAL_ARRIVAL_DATE , ACTUAL_SHIPMENT_DATE , AGREEMENT_ID , ARRIVAL_SET_ID , ATO_LINE_ID , ATTRIBUTE1 , ATTRIBUTE10 , ATTRIBUTE11 , ATTRIBUTE12 , ATTRIBUTE13 , ATTRIBUTE14 , ATTRIBUTE15 , ATTRIBUTE16 , ATTRIBUTE17 , ATTRIBUTE18 , ATTRIBUTE19 , ATTRIBUTE2 , ATTRIBUTE20 , ATTRIBUTE3 , ATTRIBUTE4 , ATTRIBUTE5 , ATTRIBUTE6 , ATTRIBUTE7 , ATTRIBUTE8 , ATTRIBUTE9 , AUTO_SELECTED_QUANTITY , AUTHORIZED_TO_SHIP_FLAG , BOOKED_FLAG , CANCELLED_FLAG , CANCELLED_QUANTITY , COMPONENT_CODE , COMPONENT_NUMBER , COMPONENT_SEQUENCE_ID , CONFIG_HEADER_ID , CONFIG_REV_NBR , CONFIG_DISPLAY_SEQUENCE , CONFIGURATION_ID , CONTEXT , CREATED_BY , CREATION_DATE , CREDIT_INVOICE_LINE_ID , CUSTOMER_DOCK_CODE , CUSTOMER_JOB , CUSTOMER_PRODUCTION_LINE , CUST_PRODUCTION_SEQ_NUM , CUSTOMER_TRX_LINE_ID , CUST_MODEL_SERIAL_NUMBER , CUST_PO_NUMBER , CUSTOMER_LINE_NUMBER , CUSTOMER_SHIPMENT_NUMBER , CUSTOMER_ITEM_NET_PRICE , DELIVERY_LEAD_TIME , DELIVER_TO_CONTACT_ID , DELIVER_TO_ORG_ID , DEMAND_BUCKET_TYPE_CODE , DEMAND_CLASS_CODE , DEP_PLAN_REQUIRED_FLAG , EARLIEST_ACCEPTABLE_DATE , END_ITEM_UNIT_NUMBER , EXPLOSION_DATE , FIRST_ACK_CODE , FIRST_ACK_DATE , FOB_POINT_CODE , FREIGHT_CARRIER_CODE , FREIGHT_TERMS_CODE , FULFILLED_QUANTITY , FULFILLED_FLAG , FULFILLMENT_METHOD_CODE , FULFILLMENT_DATE , GLOBAL_ATTRIBUTE1 , GLOBAL_ATTRIBUTE10 , GLOBAL_ATTRIBUTE11 , GLOBAL_ATTRIBUTE12 , GLOB AL_ATTRIBUTE13 , GLOBAL_ATTRIBUTE14 , GLOBAL_ATTRIBUTE15 , GLOBAL_ATTRIBUTE16 , GLOBAL_ATTRIBUTE17 , GLOBAL_ATTRIBUTE18 , GLOBAL_ATTRIBUTE19 , GLOBAL_ATTRIBUTE2 , GLOBAL_ATTRIBUTE20 , GLOBAL_ATTRIBUTE3 , GLOBAL_ATTRIBUTE4 , GLOBAL_ATTRIBUTE5 , GLOBAL_ATTRIBUTE6 , GLOBAL_ATTRIBUTE7 , GLOBAL_ATTRIBUTE8 , GLOBAL_ATTRIBUTE9 , GLOBAL_ATTRIBUTE_CATEGORY , HEADER_ID , INDUSTRY_ATTRIBUTE1 , INDUSTRY_ATTRIBUTE10 , INDUSTRY_ATTRIBUTE11 , INDUSTRY_ATTRIBUTE12 , INDUSTRY_ATTRIBUTE13 , INDUSTRY_ATTRIBUTE14 , INDUSTRY_ATTRIBUTE15 , INDUSTRY_ATTRIBUTE16 , INDUSTRY_ATTRIBUTE17 , INDUSTRY_ATTRIBUTE18 , INDUSTRY_ATTRIBUTE19 , INDUSTRY_ATTRIBUTE20 , INDUSTRY_ATTRIBUTE21 , INDUSTRY_ATTRIBUTE22 , INDUSTRY_ATTRIBUTE23 , INDUSTRY_ATTRIBUTE24 , INDUSTRY_ATTRIBUTE25 , INDUSTRY_ATTRIBUTE26 , INDUSTRY_ATTRIBUTE27 , INDUSTRY_ATTRIBUTE28 , INDUSTRY_ATTRIBUTE29 , INDUSTRY_ATTRIBUTE30 , INDUSTRY_ATTRIBUTE2 , INDUSTRY_ATTRIBUTE3 , INDUSTRY_ATTRIBUTE4 , INDUSTRY_ATTRIBUTE5 , INDUSTRY_ATTRIBUTE6 , INDUSTRY_ATTRIBUTE7 , INDUSTRY_ATTRIBUTE8 , INDUSTRY_ATTRIBUTE9 , INDUSTRY_CONTEXT , INTMED_SHIP_TO_CONTACT_ID , INTMED_SHIP_TO_ORG_ID , INVENTORY_ITEM_ID , INVOICE_INTERFACE_STATUS_CODE , INVOICE_TO_CONTACT_ID , INVOICE_TO_ORG_ID , INVOICED_QUANTITY , INVOICING_RULE_ID , ORDERED_ITEM_ID , ITEM_IDENTIFIER_TYPE , ORDERED_ITEM , ITEM_REVISION , ITEM_TYPE_CODE , LAST_ACK_CODE , LAST_ACK_DATE , LAST_UPDATED_BY , LAST_UPDATE_DATE , LAST_UPDATE_LOGIN , LAT EST_ACCEPTABLE_DATE , LINE_CATEGORY_CODE , LINE_ID , LINE_NUMBER , LINE_TYPE_ID , LINK_TO_LINE_ID , MODEL_GROUP_NUMBER , MFG_LEAD_TIME , OPEN_FLAG , OPTION_FLAG , OPTION_NUMBER , ORDERED_QUANTITY , ORDERED_QUANTITY2 , ORDER_QUANTITY_UOM , ORDERED_QUANTITY_UOM2 , ORG_ID , ORIG_SYS_DOCUMENT_REF , ORIG_SYS_LINE_REF , ORIG_SYS_SHIPMENT_REF , OVER_SHIP_REASON_CODE , OVER_SHIP_RESOLVED_FLAG , PAYMENT_TERM_ID , PLANNING_PRIORITY , PREFERRED_GRADE , PRICE_LIST_ID , PRICE_REQUEST_CODE , PRICING_ATTRIBUTE1 , PRICING_ATTRIBUTE10 , PRICING_ATTRIBUTE2 , PRICING_ATTRIBUTE3 , PRICING_ATTRIBUTE4 , PRICING_ATTRIBUTE5 , PRICING_ATTRIBUTE6 , PRICING_ATTRIBUTE7 , PRICING_ATTRIBUTE8 , PRICING_ATTRIBUTE9 , PRICING_CONTEXT , PRICING_DATE , PRICING_QUANTITY , PRICING_QUANTITY_UOM , PROGRAM_APPLICATION_ID , PROGRAM_ID , PROGRAM_UPDATE_DATE , PROJECT_ID , PROMISE_DATE , RE_SOURCE_FLAG , REFERENCE_CUSTOMER_TRX_LINE_ID , REFERENCE_HEADER_ID , REFERENCE_LINE_ID , REFERENCE_TYPE , REQUEST_DATE , REQUEST_ID , RETURN_ATTRIBUTE1 , RETURN_ATTRIBUTE10 , RETURN_ATTRIBUTE11 , RETURN_ATTRIBUTE12 , RETURN_ATTRIBUTE13 , RETURN_ATTRIBUTE14 , RETURN_ATTRIBUTE15 , RETURN_ATTRIBUTE2 , RETURN_ATTRIBUTE3 , RETURN_ATTRIBUTE4 , RETURN_ATTRIBUTE5 , RETURN_ATTRIBUTE6 , RETURN_ATTRIBUTE7 , RETURN_ATTRIBUTE8 , RETURN_ATTRIBUTE9 , RETURN_CONTEXT , RETURN_REASON_CODE , RLA_SCHEDULE_TYPE_CODE , SALESREP_ID , SCHEDULE_ARRIVAL_DATE , SCHEDULE_SHIP_DATE , SCHED ULE_STATUS_CODE , SHIPMENT_NUMBER , SHIPMENT_PRIORITY_CODE , SHIPPED_QUANTITY , SHIPPED_QUANTITY2 , SHIPPING_METHOD_CODE , SHIPPING_QUANTITY , SHIPPING_QUANTITY2 , SHIPPING_QUANTITY_UOM , SHIP_FROM_ORG_ID , SUBINVENTORY , SHIP_SET_ID , SHIP_TOLERANCE_ABOVE , SHIP_TOLERANCE_BELOW , SHIPPABLE_FLAG , SHIPPING_INTERFACED_FLAG , SHIP_TO_CONTACT_ID , SHIP_TO_ORG_ID , SHIP_MODEL_COMPLETE_FLAG , SOLD_TO_ORG_ID , SOLD_FROM_ORG_ID , SORT_ORDER , SOURCE_DOCUMENT_ID , SOURCE_DOCUMENT_LINE_ID , SOURCE_DOCUMENT_TYPE_ID , SOURCE_TYPE_CODE , SPLIT_FROM_LINE_ID , LINE_SET_ID , SPLIT_BY , MODEL_REMNANT_FLAG , TASK_ID , TAX_CODE , TAX_DATE , TAX_EXEMPT_FLAG , TAX_EXEMPT_NUMBER , TAX_EXEMPT_REASON_CODE , TAX_POINT_CODE , TAX_RATE , TAX_VALUE , TOP_MODEL_LINE_ID , UNIT_LIST_PRICE , UNIT_LIST_PRICE_PER_PQTY , UNIT_SELLING_PRICE , UNIT_SELLING_PRICE_PER_PQTY , VISIBLE_DEMAND_FLAG , VEH_CUS_ITEM_CUM_KEY_ID , SHIPPING_INSTRUCTIONS , PACKING_INSTRUCTIONS , SERVICE_TXN_REASON_CODE , SERVICE_TXN_COMMENTS , SERVICE_DURATION , SERVICE_PERIOD , SERVICE_START_DATE , SERVICE_END_DATE , SERVICE_COTERMINATE_FLAG , UNIT_LIST_PERCENT , UNIT_SELLING_PERCENT , UNIT_PERCENT_BASE_PRICE , SERVICE_NUMBER , SERVICE_REFERENCE_TYPE_CODE , SERVICE_REFERENCE_LINE_ID , SERVICE_REFERENCE_SYSTEM_ID , TP_CONTEXT , TP_ATTRIBUTE1 , TP_ATTRIBUTE2 , TP_ATTRIBUTE3 , TP_ATTRIBUTE4 , TP_ATTRIBUTE5 , TP_ATTRIBUTE6 , TP_ATTRIBUTE7 , TP_ATTRIBUTE8 , TP_ATTRIBUTE9 , TP_ATTRIBUTE10 , TP_ATTRIBUTE11 , TP_ATTRIBUTE12 , TP_ATTRIBUTE13 , TP_ATTRIBUTE14 , TP_ATTRIBUTE15 , FLOW_STATUS_CODE , MARKETING_SOURCE_CODE_ID , CALCULATE_PRICE_FLAG , COMMITMENT_ID , ORDER_SOURCE_ID , UPGRADED_FLAG , ORIGINAL_INVENTORY_ITEM_ID , ORIGINAL_ITEM_IDENTIFIER_TYPE , ORIGINAL_ORDERED_ITEM_ID , ORIGINAL_ORDERED_ITEM , ITEM_RELATIONSHIP_TYPE , ITEM_SUBSTITUTION_TYPE_CODE , LATE_DEMAND_PENALTY_FACTOR , OVERRIDE_ATP_DATE_CODE , FIRM_DEMAND_FLAG , EARLIEST_SHIP_DATE , USER_ITEM_DESCRIPTION , BLANKET_NUMBER , BLANKET_LINE_NUMBER , BLANKET_VERSION_NUMBER , UNIT_COST , LOCK_CONTROL , CHANGE_SEQUENCE , TRANSACTION_PHASE_CODE , SOURCE_DOCUMENT_VERSION_NUMBER , MINISITE_ID , IB_OWNER , IB_INSTALLED_AT_LOCATION , IB_CURRENT_LOCATION , END_CUSTOMER_ID , END_CUSTOMER_CONTACT_ID , END_CUSTOMER_SITE_USE_ID , RETROBILL_REQUEST_ID , ORIGINAL_LIST_PRICE , ORDER_FIRMED_DATE , ACTUAL_FULFILLMENT_DATE FROM OE_ORDER_LINES_ALL WHERE LINE_ID = :B1
827gtfny5uagb begin :con := FND_GENERIC_POLICY.GET_PREDICATE(:sn, :on); end;
8c8cf4vtv4tx2 SELECT * FROM ( SELECT LeadEO.sales_lead_id as SalesLeadId , to_char(hz_timezone_pub.convert_datetime(:1, hcp.timezone_id, SYSDATE), 'HH:MI AM ') ||' '||ht.standard_time_short_code as PrimaryContactLocalTime , SUBSTRB(LeadEO.description, 1, 240) as Description , hp.party_name as ContactName , custParty.party_name as CustomerName , aslt.meaning as RankName , ast.meaning as LeadStatus , ROUND(SYSDATE - LeadEO.creation_date) as Age , DECODE(LeadEO.status_code, 'CONVERTED_TO_OPPORTUNITY', 'ASNCnvToOpptyDsbld', 'ASNCnvToOpptyEnbld') as ASNLeadLstCnvToOppty , LeadEO.customer_id , hp.party_id , LeadEO.primary_contact_party_id , hr.relationship_id FROM as_sales_leads LeadEO , ( SELECT /*+ no_merge */ distinct aaa.sales_lead_id, aaa.customer_id FROM as_accesses_all aaa WHERE aaa.sales_lead_id IS NOT NULL AND aaa.lead_id IS NULL AND aaa.salesforce_id = :2) secu , as_statuses_tl ast , as_sales_lead_ranks_tl aslt , hz_parties CustParty , hz_parties hp, hz_relationships hr , hz_contact_points hcp , hz_timezones ht , ams_source_codes amsc WHERE LeadEO.sales_lead_id = secu.sales_lead_id AND LeadEO.customer_id = secu.customer_id AND LeadEO.status_code = ast.status_code AND ast.language = USERENV('LANG') AND LeadEO.lead_rank_id = aslt.rank_id (+) AND aslt.language (+) = USERENV('LANG') AND LeadEO.customer_id = CustParty.party_id AND LeadEO.primary_contact_party_id = hr.party_id(+) AND hr.subject_id = hp.party_id (+) AND hr.subject_table_name (+) = 'HZ_PARTIES' AND hr.object_id(+) = LeadEO.customer_id AND hr.object_table_name (+) = 'HZ_PARTIES' AND LeadEO.primary_contact_party_id = hcp.owner_table_id(+) AND hcp.owner_table_name (+) = 'HZ_PARTIES' AND hcp.primary_flag (+) = 'Y' AND hcp.contact_point_type (+) = 'PHONE' AND hcp.timezone_id = ht.timezone_id (+) AND LeadEO.source_promotion_id = amsc.source_code_id AND amsc.source_code_for_id = :3 AND LeadEO.status_code = :4 ORDER BY age )
8camsgjsr9zya begin OE_TRANSACTION_TYPES_PKG.Val_Ord_Change( :t_application_id, :t_entity_short_name, :t_validation_entity_short_name, :t_validation_tmplt_short_name, :t_record_set_short_name, :t_scope, :t_result ); end;
8jb36w62w5hqf BEGIN IBU_REQ_PKG.UpdateServiceRequest(:1, :2, -1, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16); END;
9wdrypwkpf607 begin OE_FULFILL_WF.START_FULFILLMENT (:v1, :v2, :v3, :v4, :v5); end;
a29grr748ghc4 BEGIN jdr_custom_internal.getActiveLayers(:1, :2, :3, :4, :5); END;
avc1jqzz04wpr SELECT 'x' FROM DUAL
bf7uwg5pa3pj6 begin FND_FLEX_WORKFLOW_APIS.VALIDATE_COMBINATION (:v1, :v2, :v3, :v4, :v5); end;
bt0w082dfrm8v BEGIN WSH_SHIP_CONFIRM_ACTIONS.interface_ALL_wrp( :errbuf, :rc, :A0, :A1, :A2, :A3); END;
cd9mbmqyf4qhp UPDATE WF_ITEM_ACTIVITY_STATUSES SET ACTIVITY_STATUS = :B8 , ACTIVITY_RESULT_CODE = NVL(:B13 , ACTIVITY_RESULT_CODE), BEGIN_DATE = NVL(:B11 , BEGIN_DATE), END_DATE = NVL(:B12 , END_DATE), DUE_DATE = DECODE(:B11 , TO_DATE(NULL), DUE_DATE, :B10 ), OUTBOUND_QUEUE_ID = :B9 , EXECUTION_TIME = DECODE(:B8 , :B7 , :B4 , :B6 , NVL(EXECUTION_TIME, :B4 ), :B5 , NVL(EXECUTION_TIME, :B4 ), EXECUTION_TIME) WHERE ITEM_TYPE = :B3 AND ITEM_KEY = :B2 AND PROCESS_ACTIVITY = :B1
cjzdvgnq01bs1 SELECT SOLD_TO, DEFAULT_FULFILLMENT_SET, QUOTE_NUMBER, ORDER_NUMBER, VERSION_NUMBER, CUSTOMER_NUMBER, BLANKET_NUMBER, ORDERED_DATE, QUOTE_DATE, SOLD_TO_CONTACT, ORDER_TYPE, SOLD_TO_EMAIL_ADDRESS, SALES_DOCUMENT_NAME, CUST_PO_NUMBER, EXPIRATION_DATE, PRICE_LIST, SHIP_TO, SHIP_TO_ADDRESS1, SHIP_TO_ADDRESS2, SHIP_TO_ADDRESS3, SHIP_TO_ADDRESS4, SHIP_TO_ADDRESS5, PRICING_DATE, INVOICE_TO_LOCATION, ACCOUNTING_RULE, ACCOUNTING_RULE_DURATION, INVOICE_TO, INVOICING_RULE, INVOICE_TO_CONTACT, TERMS, INVOICE_TO_ADDRESS1, TRANSACTIONAL_CURR_CODE, INVOICE_TO_ADDRESS2, INVOICE_TO_ADDRESS3, INVOICE_TO_ADDRESS4, INVOICE_TO_ADDRESS5, SHIP_TO_LOCATION, SHIP_TO_CONTACT, SHIP_TOLERANCE_ABOVE, SHIP_TOLERANCE_BELOW, CURRENCY_PRECISION, SHIP_FROM_LOCATION, SHIP_FROM_ADDRESS1, SHIP_FROM_ADDRESS2, SHIP_FROM_ADDRESS3, SHIP_FROM_ADDRESS4, RETURN_REASON, REQUEST_DATE, TAX_EXEMPT_NUMBER, CONVERSION_RATE_DATE, SHIP_FROM, payment_amount, check_number, credit_card_holder_name, first_ack_code, last_ack_code, FIRST_ACK_DATE, LAST_ACK_DATE, credit_card_expiration_date, shipping_instructions, packing_instructions, EARLIEST_SCHEDULE_LIMIT, LATEST_SCHEDULE_LIMIT, CUSTOMER_PREFERENCE_SET_CODE, DRAFT_SUBMITTED_FLAG, CUSTOMER_SIGNATURE, CUSTOMER_SIGNATURE_DATE, SUPPLIER_SIGNATURE, SUPPLIER_SIGNATURE_DATE, END_CUSTOMER_SITE_USE_ID, END_CUSTOMER_CONTACT_ID, END_CUSTOMER_ID, IB_OWNER, IB_INSTALLED_AT_LOCATION, IB_CURRENT_LOCATION, credit_card_number, LOCK_CONTROL, credit_card_approval_code, credit_card_approval_date, FR EIGHT_CARRIER_CODE, CONVERSION_TYPE_CODE, CONVERSION_RATE, SHIPMENT_PRIORITY_CODE, TAX_EXEMPT_REASON_CODE, SALES_CHANNEL_CODE, TAX_EXEMPT_FLAG, ROW_ID, HEADER_ID, ORG_ID, ORDER_TYPE_ID, ORDER_SOURCE_ID, ORDER_DATE_TYPE_CODE, SOURCE_DOCUMENT_TYPE_ID, SOURCE_DOCUMENT_ID, PRICE_LIST_ID, AGREEMENT_ID, TAX_POINT_CODE, INVOICING_RULE_ID, ACCOUNTING_RULE_ID, PAYMENT_TERM_ID, FOB_POINT_CODE, FLOW_STATUS_CODE, FREIGHT_TERMS_CODE, SHIPPING_METHOD_CODE, SOLD_TO_ORG_ID, SOLD_TO_PHONE_ID, SHIP_FROM_ORG_ID, SOLD_FROM_ORG_ID, SHIP_TO_ORG_ID, INVOICE_TO_ORG_ID, DELIVER_TO_ORG_ID, SOLD_TO_CONTACT_ID, SHIP_TO_CONTACT_ID, INVOICE_TO_CONTACT_ID, DELIVER_TO_CONTACT_ID, SALESREP_ID, RETURN_REASON_CODE, ORDER_CATEGORY_CODE, payment_type_code, credit_card_code, USER_STATUS_CODE, TRANSACTION_PHASE_CODE, SOLD_TO_SITE_USE_ID, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, CONTEXT, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, ATTRIBUTE16, ATTRIBUTE17, ATTRIBUTE18, ATTRIBUTE19, ATTRIBUTE20, TP_CONTEXT, TP_ATTRIBUTE1, TP_ATTRIBUTE2, TP_ATTRIBUTE3, TP_ATTRIBUTE4, TP_ATTRIBUTE5, TP_ATTRIBUTE6, TP_ATTRIBUTE7, TP_ATTRIBUTE8, TP_ATTRIBUTE9, TP_ATTRIBUTE10, TP_ATTRIBUTE11, TP_ATTRIBUTE12, TP_ATTRIBUTE13, TP_ATTRIBUTE14, TP_ATTRIBUTE15, GLOBAL_ATTRIBUTE_CATEGORY, GLOBAL_AT TRIBUTE1, GLOBAL_ATTRIBUTE2, GLOBAL_ATTRIBUTE3, GLOBAL_ATTRIBUTE4, GLOBAL_ATTRIBUTE5, GLOBAL_ATTRIBUTE6, GLOBAL_ATTRIBUTE7, GLOBAL_ATTRIBUTE8, GLOBAL_ATTRIBUTE9, GLOBAL_ATTRIBUTE10, GLOBAL_ATTRIBUTE11, GLOBAL_ATTRIBUTE12, GLOBAL_ATTRIBUTE13, GLOBAL_ATTRIBUTE14, GLOBAL_ATTRIBUTE15, GLOBAL_ATTRIBUTE16, GLOBAL_ATTRIBUTE17, GLOBAL_ATTRIBUTE18, GLOBAL_ATTRIBUTE19, GLOBAL_ATTRIBUTE20, DEMAND_CLASS_CODE, BOOKED_FLAG, BOOKED_DATE, CANCELLED_FLAG, OPEN_FLAG, ORIG_SYS_DOCUMENT_REF FROM OE_ORDER_HEADERS_V WHERE HEADER_ID=:1 order by ordered_date desc, order_number desc
csvvv0fmhr1yc BEGIN FFP1893_01010001.FORMULA( :N1, :N4, :T1, :I1, :D1, :T2, :I2, :T7, :I7, :T8, :I8, :T5, :I5, :N3, :T4, :I4, :N2, :N5, :T3, :I3, :T6, :I6, :FFERLN, :FFERCD, :FFERMT); END;
cwyx16zn1hpfb select parameter, value from nls_session_parameters
dcvv68fju01g4 begin FND_FLEX_WORKFLOW_APIS.END_GENERATION (:v1, :v2, :v3, :v4, :v5); end;
fb13x9qx0ftks begin OE_STANDARD_WF.OEOL_SELECTOR (:v1, :v2, :v3, :v4, :v5); end;
fmfdkztk8vx23 SELECT CATEGORY, SEVERITY, FND_LOG_SEVERITY FROM FND_NEW_MESSAGES WHERE MESSAGE_NAME = :B1 AND APPLICATION_ID = :B2 AND LANGUAGE_CODE = :B3 AND ROWNUM = 1
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;
gnhmcahkmrnzs INSERT INTO WF_ITEM_ACTIVITY_STATUSES ( ITEM_TYPE, ITEM_KEY, PROCESS_ACTIVITY, ACTIVITY_STATUS, ACTIVITY_RESULT_CODE, ASSIGNED_USER, NOTIFICATION_ID, BEGIN_DATE, END_DATE, DUE_DATE, EXECUTION_TIME, OUTBOUND_QUEUE_ID ) VALUES ( :B13 , :B12 , :B11 , :B6 , :B10 , NULL, NULL, :B9 , :B8 , :B7 , DECODE(:B6 , :B5 , :B2 , :B4 , :B2 , :B3 , :B2 , NULL), :B1 )

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 3,343,972 927.42 2.68
CPU used when call started 3,336,064 925.23 2.67
CR blocks created 16,854,204 4,674.38 13.50
Cached Commit SCN referenced 49,585 13.75 0.04
Commit SCN cached 8 0.00 0.00
DB time 6,821,274 1,891.83 5.46
DBWR checkpoint buffers written 3,156,060 875.31 2.53
DBWR checkpoints 27 0.01 0.00
DBWR object drop buffers written 52,978 14.69 0.04
DBWR revisited being-written buffer 216 0.06 0.00
DBWR thread checkpoint buffers written 503,816 139.73 0.40
DBWR transaction table writes 2,780 0.77 0.00
DBWR undo block writes 1,582,627 438.93 1.27
DFO trees parallelized 48 0.01 0.00
IMU CR rollbacks 47,096,856 13,061.93 37.72
IMU Flushes 360,352 99.94 0.29
IMU Redo allocation size 2,359,146,548 654,290.34 1,889.68
IMU commits 644,511 178.75 0.52
IMU contention 41,065 11.39 0.03
IMU ktichg flush 11,324 3.14 0.01
IMU pool not allocated 0 0.00 0.00
IMU recursive-transaction flush 1,731 0.48 0.00
IMU undo allocation size 5,681,836,128 1,575,811.60 4,551.17
IMU- failed to get a private strand 0 0.00 0.00
PX local messages recv'd 54,151 15.02 0.04
PX local messages sent 54,151 15.02 0.04
Parallel operations downgraded 25 to 50 pct 40 0.01 0.00
Parallel operations not downgraded 8 0.00 0.00
SMON posted for undo segment shrink 1 0.00 0.00
SQL*Net roundtrips to/from client 52,124,065 14,456.19 41.75
active txn count during cleanout 148,897,707 41,295.58 119.27
application wait time 23,609 6.55 0.02
background checkpoints completed 3 0.00 0.00
background checkpoints started 2 0.00 0.00
background timeouts 13,878 3.85 0.01
branch node splits 1,060 0.29 0.00
buffer is not pinned count 624,347,576 173,157.78 500.10
buffer is pinned count 1,606,797,824 445,632.47 1,287.05
bytes received via SQL*Net from client 11,395,153,791 3,160,354.35 9,127.55
bytes sent via SQL*Net to client 10,301,587,802 2,857,062.61 8,251.60
calls to get snapshot scn: kcmgss 117,501,576 32,588.12 94.12
calls to kcmgas 20,891,474 5,794.08 16.73
calls to kcmgcs 18,013,853 4,996.00 14.43
change write time 78,604 21.80 0.06
cleanout - number of ktugct calls 33,572,963 9,311.19 26.89
cleanouts and rollbacks - consistent read gets 15,051,417 4,174.39 12.06
cleanouts only - consistent read gets 156,386 43.37 0.13
cluster key scan block gets 868,569 240.89 0.70
cluster key scans 237,928 65.99 0.19
commit batch performed 0 0.00 0.00
commit batch requested 0 0.00 0.00
commit batch/immediate performed 4,217 1.17 0.00
commit batch/immediate requested 4,217 1.17 0.00
commit cleanout failures: block lost 260,078 72.13 0.21
commit cleanout failures: buffer being written 687 0.19 0.00
commit cleanout failures: callback failure 115,254 31.96 0.09
commit cleanout failures: cannot pin 29,484 8.18 0.02
commit cleanouts 9,560,883 2,651.63 7.66
commit cleanouts successfully completed 9,155,376 2,539.17 7.33
commit immediate performed 4,217 1.17 0.00
commit immediate requested 4,217 1.17 0.00
commit txn count during cleanout 1,314,835 364.66 1.05
concurrency wait time 126,522 35.09 0.10
consistent changes 749,302,352 207,812.99 600.19
consistent gets 1,865,655,697 517,424.62 1,494.40
consistent gets - examination 1,282,252,723 355,622.49 1,027.09
consistent gets from cache 1,865,655,781 517,424.64 1,494.40
cursor authentications 2,224 0.62 0.00
data blocks consistent reads - undo records applied 744,906,108 206,593.72 596.67
db block changes 198,152,839 54,956.10 158.72
db block gets 228,416,606 63,349.51 182.96
db block gets direct 4,494 1.25 0.00
db block gets from cache 228,412,148 63,348.27 182.96
deferred (CURRENT) block cleanout applications 1,681,606 466.38 1.35
dirty buffers inspected 9,889 2.74 0.01
doubling up with imu segment 0 0.00 0.00
enqueue conversions 10,352 2.87 0.01
enqueue releases 4,679,950 1,297.95 3.75
enqueue requests 4,689,365 1,300.56 3.76
enqueue timeouts 9,223 2.56 0.01
enqueue waits 37,588 10.42 0.03
exchange deadlocks 55,797 15.47 0.04
execute count 105,011,623 29,124.13 84.11
failed probes on index block reclamation 15,200 4.22 0.01
frame signature mismatch 130 0.04 0.00
free buffer inspected 3,250,083 901.38 2.60
free buffer requested 21,376,473 5,928.59 17.12
heap block compress 27,971,467 7,757.66 22.41
hot buffers moved to head of LRU 1,529,798 424.28 1.23
immediate (CR) block cleanout applications 15,207,833 4,217.77 12.18
immediate (CURRENT) block cleanout applications 1,133,313 314.32 0.91
index crx upgrade (found) 68,127 18.89 0.05
index crx upgrade (positioned) 10,486,396 2,908.32 8.40
index fast full scans (rowid ranges) 784 0.22 0.00
index fetch by key 188,001,281 52,140.64 150.59
index scans kdiixs1 167,262,869 46,389.01 133.98
java call heap collected bytes 1,501,442,544 416,413.03 1,202.66
java call heap collected count 18,335,283 5,085.14 14.69
java call heap gc count 4,838 1.34 0.00
java call heap live object count 1,532,324 424.98 1.23
java call heap live object count max 1,533,937 425.43 1.23
java call heap live size 379,968,000 105,381.07 304.36
java call heap live size max 380,440,712 105,512.17 304.73
java call heap object count 3,787,998 1,050.57 3.03
java call heap object count max 3,795,778 1,052.73 3.04
java call heap total size 492,834,816 136,683.78 394.76
java call heap total size max 493,102,080 136,757.90 394.98
java call heap used size 524,209,944 145,385.42 419.89
java call heap used size max 525,301,664 145,688.20 420.77
leaf node 90-10 splits 19,778 5.49 0.02
leaf node splits 244,211 67.73 0.20
lob reads 23,688 6.57 0.02
lob writes 41,258 11.44 0.03
lob writes unaligned 41,258 11.44 0.03
logons cumulative 10,165 2.82 0.01
messages received 1,978,243 548.65 1.58
messages sent 1,978,242 548.65 1.58
no buffer to keep pinned count 12 0.00 0.00
no work - consistent read gets 532,088,015 147,570.34 426.20
opened cursors cumulative 6,009,945 1,666.81 4.81
parse count (failures) 3,602 1.00 0.00
parse count (hard) 9,438 2.62 0.01
parse count (total) 9,235,805 2,561.48 7.40
parse time cpu 76,740 21.28 0.06
parse time elapsed 86,586 24.01 0.07
physical read IO requests 265,980 73.77 0.21
physical read bytes 3,744,997,376 1,038,644.93 2,999.75
physical read total IO requests 295,231 81.88 0.24
physical read total bytes 4,223,336,448 1,171,308.43 3,382.90
physical read total multi block requests 17,501 4.85 0.01
physical reads 457,153 126.79 0.37
physical reads cache 456,235 126.53 0.37
physical reads cache prefetch 190,993 52.97 0.15
physical reads direct 918 0.25 0.00
physical reads direct temporary tablespace 186 0.05 0.00
physical reads prefetch warmup 121,682 33.75 0.10
physical write IO requests 1,605,837 445.37 1.29
physical write bytes 26,566,164,480 7,367,912.28 21,279.57
physical write total IO requests 2,880,350 798.84 2.31
physical write total bytes 59,684,277,248 16,552,954.77 47,807.28
physical write total multi block requests 1,470,685 407.88 1.18
physical writes 3,242,908 899.39 2.60
physical writes direct 5,013 1.39 0.00
physical writes direct (lob) 236 0.07 0.00
physical writes direct temporary tablespace 4,345 1.21 0.00
physical writes from cache 3,237,911 898.01 2.59
physical writes non checkpoint 2,313,127 641.53 1.85
pinned buffers inspected 5,108 1.42 0.00
prefetch warmup blocks aged out before use 265,307 73.58 0.21
prefetched blocks aged out before use 120 0.03 0.00
process last non-idle time 3,607 1.00 0.00
queries parallelized 48 0.01 0.00
recursive calls 169,720,713 47,070.68 135.95
recursive cpu usage 1,907,414 529.01 1.53
redo blocks written 64,519,229 17,893.89 51.68
redo buffer allocation retries 0 0.00 0.00
redo entries 102,190,165 28,341.62 81.85
redo log space requests 0 0.00 0.00
redo log space wait time 0 0.00 0.00
redo ordering marks 1,138,025 315.62 0.91
redo size 31,630,281,876 8,772,404.55 25,335.95
redo subscn max counts 2,412,761 669.16 1.93
redo synch time 215,926 59.89 0.17
redo synch writes 2,430,618 674.11 1.95
redo wastage 323,099,552 89,609.06 258.80
redo write time 74,260 20.60 0.06
redo writer latching time 1,306 0.36 0.00
redo writes 759,884 210.75 0.61
rollback changes - undo records applied 193,103 53.56 0.15
rollbacks only - consistent read gets 1,992,918 552.72 1.60
rows fetched via callback 98,852,419 27,415.92 79.18
session connect time 0 0.00 0.00
session cursor cache hits 5,772,768 1,601.03 4.62
session logical reads 2,094,071,269 580,773.84 1,677.36
session pga memory 10,637,841,864 2,950,319.97 8,520.94
session pga memory max 11,949,374,344 3,314,062.97 9,571.48
session uga memory ############### 75,151,238.17 217,047.41
session uga memory max 74,435,076,632 20,643,970.47 59,622.71
shared hash latch upgrades - no wait 32,908,341 9,126.86 26.36
shared hash latch upgrades - wait 115,024 31.90 0.09
sorts (memory) 10,929,156 3,031.11 8.75
sorts (rows) 134,631,771 37,339.04 107.84
sql area evicted 2,578 0.71 0.00
sql area purged 3,736 1.04 0.00
summed dirty queue length 266,600 73.94 0.21
switch current to new buffer 1,420,930 394.08 1.14
table fetch by rowid 947,487,549 262,778.06 758.94
table fetch continued row 33,070,281 9,171.78 26.49
table scan blocks gotten 76,667,055 21,262.99 61.41
table scan rows gotten 2,380,920,751 660,329.24 1,907.12
table scans (long tables) 2,038 0.57 0.00
table scans (rowid ranges) 2,036 0.56 0.00
table scans (short tables) 6,236,606 1,729.67 5.00
total number of times SMON posted 162,344 45.02 0.13
transaction rollbacks 4,217 1.17 0.00
transaction tables consistent read rollbacks 106 0.03 0.00
transaction tables consistent reads - undo records applied 3,734 1.04 0.00
undo change vector size 11,089,741,660 3,075,650.75 8,882.91
user I/O wait time 126,718 35.14 0.10
user calls 49,770,409 13,803.42 39.87
user commits 983,350 272.72 0.79
user rollbacks 265,085 73.52 0.21
workarea executions - onepass 2 0.00 0.00
workarea executions - optimal 6,522,633 1,809.00 5.22
write clones created in background 1,728 0.48 0.00
write clones created in foreground 10,064 2.79 0.01

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistic Begin Value End Value
session cursor cache count 539,318 1,252,300
opened cursors current 1,110,274 1,242,520
workarea memory allocated 176 2,200
logons current 5,273 5,305

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 58 0 7.76 1.00 695,082 193 246,096 0.25
APPS_TS_TX_DATA 156,667 43 4.66 1.52 189,787 53 114,436 0.67
APPS_TS_TX_IDX 84,876 24 4.59 1.48 233,639 65 85,766 0.48
APPS_ASSM_DATA 8,810 2 3.07 6.51 261,992 73 47,395 0.46
APPS_ASSM_IDX 6,733 2 2.74 1.04 149,439 41 286,323 0.28
APPS_TS_TX_INTERFACE 657 0 5.28 3.01 36,977 10 15,819 0.91
TEMP 446 0 4.24 10.61 10,622 3 83 9.40
APPS_TS_SUMMARY 59 0 9.83 1.00 8,002 2 2,958 0.14
SYSTEM 5,092 1 4.06 3.67 2,940 1 18,452 0.27
APPS_TS_SEED 1,627 0 7.07 1.52 5,775 2 759 2.81
APPS_TS_QUEUES 351 0 6.30 2.57 5,728 2 364 0.33
APPS_TS_ARCHIVE 62 0 5.00 1.52 2,492 1 112 4.73
SYSAUX 304 0 2.63 1.14 1,722 0 0 0.00
APPS_TS_NOLOGGING 25 0 9.60 1.56 40 0 0 0.00
CTXSYS 24 0 10.00 1.00 6 0 0 0.00
APPS_TS_MEDIA 12 0 12.50 1.00 9 0 0 0.00
ODM 12 0 8.33 1.00 3 0 0 0.00
OLAP 12 0 10.00 1.00 3 0 0 0.00
OWAPUB 12 0 7.50 1.00 3 0 0 0.00
PORTAL 12 0 8.33 1.00 3 0 0 0.00
SYNCSERVER 12 0 7.50 1.00 3 0 0 0.00

Back to IO Stats
Back to Top

File IO Stats

Tablespace Filename Reads Av Reads/s Av Rd(ms) Av Blks/Rd Writes Av Writes/s Buffer Waits Av Buf Wt(ms)
APPS_ASSM_DATA /DB/visdata/apps_assm_data.dbf 8,810 2 3.07 6.51 261,992 73 47,395 0.46
APPS_ASSM_IDX /DB/visdata/apps_assm_idx.dbf 6,733 2 2.74 1.04 149,439 41 286,323 0.28
APPS_TS_ARCHIVE /DB/visdata/archive1.dbf 32 0 5.31 1.66 2,215 1 109 4.86
APPS_TS_ARCHIVE /DB/visdata/archive2.dbf 30 0 4.67 1.37 277 0 3 0.00
APPS_TS_MEDIA /DB/visdata/media1.dbf 4 0 12.50 1.00 3 0 0 0.00
APPS_TS_MEDIA /DB/visdata/media2.dbf 4 0 12.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 17.50 1.00 3 0 0 0.00
APPS_TS_NOLOGGING /DB/visdata/nologging2.dbf 15 0 6.00 1.00 20 0 0 0.00
APPS_TS_NOLOGGING /DB/visdata/nologging3.dbf 6 0 13.33 3.33 17 0 0 0.00
APPS_TS_QUEUES /DB/visdata/queues1.dbf 41 0 8.54 2.37 720 0 126 0.32
APPS_TS_QUEUES /DB/visdata/queues2.dbf 29 0 5.17 3.24 840 0 121 0.33
APPS_TS_QUEUES /DB/visdata/queues3.dbf 42 0 8.33 3.64 937 0 8 0.00
APPS_TS_QUEUES /DB/visdata/queues4.dbf 45 0 4.44 2.89 785 0 4 0.00
APPS_TS_QUEUES /DB/visdata/queues5.dbf 28 0 5.71 3.71 707 0 0 0.00
APPS_TS_QUEUES /DB/visdata/queues6.dbf 36 0 4.44 2.33 698 0 3 0.00
APPS_TS_QUEUES /DB/visdata/queues7.dbf 130 0 6.46 1.84 1,041 0 102 0.39
APPS_TS_SEED /DB/visdata/reference1.dbf 144 0 6.94 1.48 486 0 37 4.86
APPS_TS_SEED /DB/visdata/reference10.dbf 125 0 5.92 1.41 586 0 50 4.00
APPS_TS_SEED /DB/visdata/reference2.dbf 159 0 8.30 1.38 621 0 41 5.12
APPS_TS_SEED /DB/visdata/reference3.dbf 282 0 5.53 1.43 650 0 419 2.43
APPS_TS_SEED /DB/visdata/reference4.dbf 158 0 6.90 1.66 622 0 27 3.70
APPS_TS_SEED /DB/visdata/reference5.dbf 182 0 5.93 1.54 595 0 32 2.50
APPS_TS_SEED /DB/visdata/reference6.dbf 179 0 5.98 1.74 641 0 27 4.81
APPS_TS_SEED /DB/visdata/reference7.dbf 159 0 13.40 1.50 502 0 23 2.17
APPS_TS_SEED /DB/visdata/reference8.dbf 126 0 5.95 1.63 511 0 33 3.33
APPS_TS_SEED /DB/visdata/reference9.dbf 113 0 6.73 1.44 561 0 70 0.71
APPS_TS_SUMMARY /DB/visdata/summary1.dbf 5 0 8.00 1.00 1,061 0 356 0.06
APPS_TS_SUMMARY /DB/visdata/summary2.dbf 5 0 8.00 1.00 924 0 280 0.18
APPS_TS_SUMMARY /DB/visdata/summary3.dbf 7 0 11.43 1.00 804 0 275 0.07
APPS_TS_SUMMARY /DB/visdata/summary4.dbf 11 0 8.18 1.00 838 0 286 0.10
APPS_TS_SUMMARY /DB/visdata/summary5.dbf 9 0 10.00 1.00 1,002 0 471 0.21
APPS_TS_SUMMARY /DB/visdata/summary6.dbf 7 0 14.29 1.00 1,141 0 685 0.13
APPS_TS_SUMMARY /DB/visdata/summary7.dbf 7 0 10.00 1.00 980 0 292 0.24
APPS_TS_SUMMARY /DB/visdata/summary8.dbf 8 0 8.75 1.00 1,252 0 313 0.13
APPS_TS_TX_DATA /DB/visdata/tx_data1.dbf 2,729 1 5.35 1.53 362 0 0 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data10.dbf 2,751 1 5.39 1.51 270 0 0 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data11.dbf 2,694 1 5.46 1.54 244 0 0 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data12.dbf 12,602 3 3.60 1.36 6,058 2 3,174 1.01
APPS_TS_TX_DATA /DB/visdata/tx_data13.dbf 16,296 5 5.14 1.85 6,165 2 1,978 0.93
APPS_TS_TX_DATA /DB/visdata/tx_data14.dbf 12,251 3 4.42 1.51 26,556 7 15,234 0.74
APPS_TS_TX_DATA /DB/visdata/tx_data15.dbf 8,629 2 4.37 1.60 26,452 7 15,829 0.64
APPS_TS_TX_DATA /DB/visdata/tx_data16.dbf 8,678 2 4.18 1.58 25,475 7 14,363 0.62
APPS_TS_TX_DATA /DB/visdata/tx_data17.dbf 8,480 2 4.06 1.59 24,276 7 14,699 0.60
APPS_TS_TX_DATA /DB/visdata/tx_data18.dbf 8,506 2 4.11 1.57 22,871 6 16,439 0.62
APPS_TS_TX_DATA /DB/visdata/tx_data19.dbf 8,451 2 4.29 1.60 22,516 6 14,658 0.70
APPS_TS_TX_DATA /DB/visdata/tx_data2.dbf 6,307 2 3.62 1.26 1,499 0 1,779 1.15
APPS_TS_TX_DATA /DB/visdata/tx_data20.dbf 8,450 2 4.44 1.66 23,132 6 15,132 0.59
APPS_TS_TX_DATA /DB/visdata/tx_data21.dbf 19,099 5 5.31 1.42 1,132 0 1,112 0.18
APPS_TS_TX_DATA /DB/visdata/tx_data3.dbf 3,694 1 5.92 1.81 476 0 7 14.29
APPS_TS_TX_DATA /DB/visdata/tx_data4.dbf 13,409 4 4.93 1.17 364 0 10 4.00
APPS_TS_TX_DATA /DB/visdata/tx_data5.dbf 2,744 1 5.28 1.45 339 0 7 4.29
APPS_TS_TX_DATA /DB/visdata/tx_data6.dbf 2,757 1 5.41 1.47 270 0 7 12.86
APPS_TS_TX_DATA /DB/visdata/tx_data7.dbf 2,682 1 5.61 1.51 566 0 2 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data8.dbf 2,650 1 5.20 1.42 465 0 6 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data9.dbf 2,808 1 5.24 1.50 299 0 0 0.00
APPS_TS_TX_IDX /DB/visdata/tx_idx1.dbf 2,360 1 3.39 1.20 2,763 1 1,366 0.51
APPS_TS_TX_IDX /DB/visdata/tx_idx10.dbf 2,325 1 3.37 1.21 1,966 1 1,689 0.58
APPS_TS_TX_IDX /DB/visdata/tx_idx11.dbf 2,295 1 3.63 1.24 2,148 1 1,812 0.62
APPS_TS_TX_IDX /DB/visdata/tx_idx12.dbf 10,052 3 5.51 1.89 25,046 7 1,577 0.34
APPS_TS_TX_IDX /DB/visdata/tx_idx13.dbf 8,670 2 4.63 1.38 32,135 9 5,086 0.57
APPS_TS_TX_IDX /DB/visdata/tx_idx14.dbf 5,041 1 4.99 1.54 23,435 6 5,215 0.45
APPS_TS_TX_IDX /DB/visdata/tx_idx15.dbf 5,022 1 4.94 1.57 20,447 6 5,748 0.52
APPS_TS_TX_IDX /DB/visdata/tx_idx16.dbf 4,883 1 5.06 1.54 18,931 5 5,860 0.42
APPS_TS_TX_IDX /DB/visdata/tx_idx17.dbf 4,906 1 5.16 1.58 17,374 5 5,383 0.45
APPS_TS_TX_IDX /DB/visdata/tx_idx18.dbf 4,994 1 4.93 1.56 17,460 5 8,809 0.59
APPS_TS_TX_IDX /DB/visdata/tx_idx19.dbf 4,975 1 5.24 1.53 16,804 5 6,189 0.43
APPS_TS_TX_IDX /DB/visdata/tx_idx2.dbf 2,821 1 4.35 1.43 2,411 1 1,795 0.56
APPS_TS_TX_IDX /DB/visdata/tx_idx20.dbf 4,786 1 4.92 1.56 16,061 4 6,287 0.44
APPS_TS_TX_IDX /DB/visdata/tx_idx21.dbf 3,173 1 5.21 1.75 14,802 4 2,657 0.44
APPS_TS_TX_IDX /DB/visdata/tx_idx3.dbf 3,841 1 3.40 1.18 2,155 1 2,666 0.52
APPS_TS_TX_IDX /DB/visdata/tx_idx4.dbf 2,522 1 3.51 1.20 3,841 1 2,969 0.81
APPS_TS_TX_IDX /DB/visdata/tx_idx5.dbf 2,538 1 3.56 1.27 5,372 1 13,772 0.23
APPS_TS_TX_IDX /DB/visdata/tx_idx6.dbf 2,505 1 3.64 1.28 2,993 1 1,808 0.74
APPS_TS_TX_IDX /DB/visdata/tx_idx7.dbf 2,371 1 3.60 1.18 3,017 1 1,920 0.78
APPS_TS_TX_IDX /DB/visdata/tx_idx8.dbf 2,371 1 4.18 1.28 2,249 1 1,562 0.54
APPS_TS_TX_IDX /DB/visdata/tx_idx9.dbf 2,425 1 3.56 1.23 2,229 1 1,596 0.48
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte.dbf 119 0 4.79 2.29 5,643 2 2,561 1.09
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte2.dbf 165 0 4.73 2.95 7,282 2 2,744 0.75
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte3.dbf 93 0 4.95 3.67 6,466 2 2,863 0.93
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte4.dbf 108 0 5.37 2.96 6,119 2 2,650 0.71
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte5.dbf 84 0 7.50 3.32 5,763 2 2,688 0.79
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte6.dbf 88 0 5.11 3.15 5,704 2 2,313 1.23
APPS_UNDOTS1 /DB/visdata/undo01.dbf 6 0 15.00 1.00 72,361 20 22,650 0.24
APPS_UNDOTS1 /DB/visdata/undo02.dbf 6 0 11.67 1.00 69,609 19 21,246 0.24
APPS_UNDOTS1 /DB/visdata/undo03.dbf 7 0 4.29 1.00 72,448 20 24,110 0.26
APPS_UNDOTS1 /DB/visdata/undo04.dbf 9 0 3.33 1.00 68,783 19 21,018 0.29
APPS_UNDOTS1 /DB/visdata/undo05.dbf 3 0 6.67 1.00 72,011 20 24,561 0.24
APPS_UNDOTS1 /DB/visdata/undo06.dbf 5 0 6.00 1.00 69,169 19 22,772 0.31
APPS_UNDOTS1 /DB/visdata/undo07.dbf 5 0 14.00 1.00 65,324 18 33,718 0.25
APPS_UNDOTS1 /DB/visdata/undo08.dbf 4 0 10.00 1.00 65,205 18 28,926 0.25
APPS_UNDOTS1 /DB/visdata/undo09.dbf 4 0 7.50 1.00 69,324 19 25,633 0.20
APPS_UNDOTS1 /DB/visdata/undo10.dbf 9 0 4.44 1.00 70,848 20 21,462 0.27
CTXSYS /DB/visdata/ctx1.dbf 12 0 10.83 1.00 3 0 0 0.00
CTXSYS /DB/visdata/ctx2.dbf 12 0 9.17 1.00 3 0 0 0.00
ODM /DB/visdata/odm.dbf 12 0 8.33 1.00 3 0 0 0.00
OLAP /DB/visdata/olap.dbf 12 0 10.00 1.00 3 0 0 0.00
OWAPUB /DB/visdata/owa1.dbf 12 0 7.50 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 7.50 1.00 3 0 0 0.00
SYSAUX /DB/visdata/sysaux01.dbf 29 0 5.17 1.83 597 0 0 0.00
SYSAUX /DB/visdata/sysaux02.dbf 275 0 2.36 1.07 1,125 0 0 0.00
SYSTEM /DB/visdata/sys1.dbf 555 0 4.54 4.06 123 0 6 0.00
SYSTEM /DB/visdata/sys2.dbf 560 0 3.80 4.20 215 0 42 0.71
SYSTEM /DB/visdata/sys3.dbf 685 0 3.09 3.55 279 0 3 0.00
SYSTEM /DB/visdata/sys4.dbf 620 0 3.45 3.82 265 0 10 5.00
SYSTEM /DB/visdata/sys5.dbf 793 0 4.26 3.19 723 0 683 0.09
SYSTEM /DB/visdata/sys6.dbf 554 0 3.90 4.21 79 0 3 0.00
SYSTEM /DB/visdata/sys7.dbf 446 0 4.91 4.26 226 0 20 1.50
SYSTEM /DB/visdata/sys8.dbf 383 0 4.62 3.23 555 0 17,676 0.28
SYSTEM /DB/visdata/sys9.dbf 496 0 4.58 2.59 475 0 9 3.33
TEMP /DB/visdata/temp1.dbf 78 0 3.08 1.00 2,517 1 35 8.86
TEMP /DB/visdata/temp2.dbf 140 0 4.71 13.27 2,668 1 1 0.00
TEMP /DB/visdata/temp3.dbf 126 0 5.79 21.37 2,734 1 43 9.77
TEMP /DB/visdata/temp4.dbf 102 0 2.55 1.00 2,703 1 4 12.50

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,186,795 100 2,067,567,886 456,195 3,238,114 0 0 818,692


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 106 48051 1191314 4604155 188743680 4604155  
E 180 131 64611 1449444 18412144 188743680 18412144  

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,288 5

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

  PGA Aggr Target(M) Auto PGA Target(M) PGA Mem Alloc(M) W/A PGA Used(M) %PGA W/A Mem %Auto W/A Mem %Man W/A Mem Global Mem Bound(K)
B 20,480 1,280 47,541.01 2.38 0.01 100.00 0.00 1,048,576
E 20,480 1,280 55,221.13 3.68 0.01 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,873,030 5,873,030 0 0
64K 128K 11,716 11,716 0 0
128K 256K 1,153 1,153 0 0
256K 512K 1,100 1,100 0 0
512K 1024K 188,127 188,127 0 0
1M 2M 439,310 439,310 0 0
2M 4M 72 70 2 0
4M 8M 11 11 0 0
8M 16M 6 6 0 0
32M 64M 6 6 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 940,974.22 10,032.38 99.00 1,332
5,120 0.25 940,974.22 9,945.81 99.00 1,295
10,240 0.50 940,974.22 9,781.01 99.00 1,231
15,360 0.75 940,974.22 9,690.86 99.00 1,191
20,480 1.00 940,974.22 2.73 100.00 1,145
24,576 1.20 940,974.22 2.73 100.00 1,104
28,672 1.40 940,974.22 2.73 100.00 1,048
32,768 1.60 940,974.22 2.73 100.00 933
36,864 1.80 940,974.22 2.73 100.00 667
40,960 2.00 940,974.22 0.00 100.00 177
61,440 3.00 940,974.22 0.00 100.00 0
81,920 4.00 940,974.22 0.00 100.00 0
122,880 6.00 940,974.22 0.00 100.00 0
163,840 8.00 940,974.22 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
2,160 0.80 298 13,429 2,980,134 1.00 4,196 2.29 183,208,607
2,432 0.90 549 17,525 2,982,017 1.00 2,313 1.26 183,315,801
2,704 1.00 819 20,388 2,982,501 1.00 1,829 1.00 183,344,917
2,976 1.10 1,088 23,963 2,982,591 1.00 1,739 0.95 183,350,906
3,248 1.20 1,330 30,154 2,982,599 1.00 1,731 0.95 183,351,613
3,520 1.30 1,458 34,366 2,982,599 1.00 1,731 0.95 183,351,679
3,792 1.40 1,505 35,942 2,982,599 1.00 1,731 0.95 183,351,694
4,064 1.50 1,505 35,942 2,982,599 1.00 1,731 0.95 183,351,694
4,336 1.60 1,505 35,942 2,982,599 1.00 1,731 0.95 183,351,694
4,608 1.70 1,505 35,942 2,982,599 1.00 1,731 0.95 183,351,694
4,880 1.80 1,505 35,942 2,982,599 1.00 1,731 0.95 183,351,694
5,152 1.91 1,505 35,942 2,982,599 1.00 1,731 0.95 183,351,694
5,424 2.01 1,505 35,942 2,982,599 1.00 1,731 0.95 183,351,694

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 50,103  
10,240 0.50 50,103  
15,360 0.75 50,103  
20,480 1.00 50,102  
25,600 1.25 50,104  
30,720 1.50 50,110  
35,840 1.75 50,110  
40,960 2.00 50,111  

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 14 338 1,059 1.00 1,831 1.00 14,842
32 0.50 14 338 1,059 1.00 1,831 1.00 14,842
48 0.75 14 338 1,059 1.00 1,831 1.00 14,842
64 1.00 14 338 1,059 1.00 1,831 1.00 14,842
80 1.25 14 338 1,059 1.00 1,831 1.00 14,842
96 1.50 14 338 1,059 1.00 1,831 1.00 14,842
112 1.75 14 338 1,059 1.00 1,831 1.00 14,842
128 2.00 14 338 1,059 1.00 1,831 1.00 14,842

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 565,283 240 0
undo block 187,267 42 0
undo header 58,814 20 0
1st level bmb 4,863 2 0
file header block 149 1 5
segment header 1,850 0 0
2nd level bmb 268 0 0
bitmap index block 5 0 6
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) 8,831 994 7,836 965 149 154.88
UL-User-defined 69,395 68,347 1,048 1,423 68 47.79
TX-Transaction (index contention) 29,420 29,420 0 27,057 28 1.02
RO-Multiple Object Reuse (fast object reuse) 225 225 0 25 5 203.60
SQ-Sequence Cache 43,413 43,414 0 3,219 3 0.97
HW-Segment High Water Mark 279,549 279,538 10 2,236 3 1.23
TX-Transaction 1,331,297 1,331,492 0 1,737 2 1.15
DV-Diana Versioning 32,260 32,258 0 214 1 5.98
FB-Format Block 35,901 35,899 0 570 1 1.26
TM-DML 2,170,671 2,170,578 8 3 0 123.33
CU-Cursor 9,412 9,415 0 9 0 22.22
TX-Transaction (allocate ITL entry) 186 186 0 95 0 0.84
US-Undo Segment 10,571 10,570 0 3 0 6.67
PS-PX Process Reservation 1,864 1,543 320 29 0 0.34

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,593.76 1,336,421 2,673 390 208.983333333333333333333333333333333333/413.2 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
29-Jul 12:23 201,110 174,537 555 384 209 0/0 0/0/0/0/0/0
29-Jul 12:13 246,422 183,107 399 386 214 0/0 0/0/0/0/0/0
29-Jul 12:03 371,888 219,419 681 382 229 0/0 0/0/0/0/0/0
29-Jul 11:53 274,351 225,514 2,601 390 283 0/0 0/0/0/0/0/0
29-Jul 11:43 190,742 235,795 2,417 390 347 0/0 0/0/0/0/0/0
29-Jul 11:33 309,250 298,049 2,673 390 413 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,479 0.00   0 0  
AWR Alerted Metric Element list 336,119 0.00   0 0  
Consistent RBA 760,254 0.02 0.10 0 0  
FOB s.o list latch 52,279 0.01 0.00 0 0  
In memory undo latch 722,168,220 1.58 0.00 38 1,275,829 0.00
JOX SGA heap latch 1,946,241 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,041 0.00   0 0  
KMG resize request state object freelist 22 0.00   0 0  
KTF sga latch 12 0.00   0 1,214 0.00
KWQMN job cache list latch 14,436 0.85 0.99 0 0  
MQL Tracking Latch 0     0 70 0.00
Memory Management Latch 1,036 0.00   0 2,030 0.00
OS process 15,180 0.00   0 0  
OS process allocation 11,350 0.04 0.00 0 0  
OS process: request allocation 9,869 0.01 0.00 0 0  
PL/SQL warning settings 4,600,890 0.00   0 0  
SGA IO buffer pool latch 44,513 0.11 0.02 0 45,105 0.50
SQL memory manager latch 1 0.00   0 1,198 0.00
SQL memory manager workarea list latch 7,309,081 0.01 0.02 0 0  
Shared B-Tree 129 0.00   0 0  
active checkpoint queue latch 1,220,582 0.45 0.01 0 2 0.00
active service list 48,638 0.11 0.00 0 1,249 0.00
begin backup scn array 147 0.00   0 0  
buffer pool 20 0.00   0 0  
cache buffer handles 24,327,749 1.89 0.00 3 0  
cache buffers chains 4,861,879,684 1.43 0.03 724 19,186,043 3.02
cache buffers lru chain 10,484,531 0.67 0.09 35 37,748,011 1.14
cache table scan latch 2,077 0.00   0 2,077 0.00
channel handle pool latch 414,915 0.07 0.10 0 0  
channel operations parent latch 1,837,730 0.36 0.01 0 0  
checkpoint queue latch 18,056,762 0.02 0.01 0 3,252,373 0.03
client/application info 1,799,024 0.01 0.04 0 0  
commit callback allocation 88,542 0.00   0 0  
compile environment latch 3,153,393 0.00   0 0  
dictionary lookup 65 0.00   0 0  
dml lock allocation 4,324,774 0.54 0.02 1 0  
dummy allocation 20,305 0.38 0.00 0 0  
enqueue hash chains 9,424,050 0.18 0.01 1 550 0.18
enqueues 5,420,579 0.24 0.03 3 0  
error message lists 816 3.55 0.00 0 0  
event group latch 4,949 0.00   0 0  
file cache latch 21,711 0.01 0.00 0 0  
global KZLD latch for mem in SGA 9,650 0.00   0 0  
global ctx hash table latch 24,532 0.00   0 0  
hash table column usage latch 1,908 0.05 1.00 0 15,659,847 0.00
hash table modification latch 149 0.00   0 0  
internal temp table object number allocation latc 6 0.00   0 0  
job workq parent latch 0     0 122 0.00
job_queue_processes parameter latch 120 0.00   0 0  
kks stats 29,167 0.00   0 0  
ksuosstats global area 242 0.00   0 0  
ktm global data 162,273 0.00   0 0  
kwqbsn:qsga 129 0.00   0 0  
lgwr LWN SCN 764,748 0.10 0.00 0 0  
library cache 356,011,336 0.82 0.01 119 19,027 0.94
library cache load lock 10,532 0.41 0.07 0 22 0.00
library cache lock 59,827,358 0.13 0.01 1 2 0.00
library cache lock allocation 1,545,359 0.01 0.07 0 0  
library cache pin 221,986,090 0.36 0.01 34 54 1.85
library cache pin allocation 540,605 0.00 0.19 0 0  
list of block allocation 448,408 0.01 0.02 0 0  
loader state object freelist 322,506 0.00 0.00 0 0  
longop free list parent 33 0.00   0 33 0.00
message pool operations parent latch 421,617 0.01 0.10 0 0  
messages 5,786,325 0.31 0.01 0 0  
mostly latch-free SCN 870,127 8.05 0.00 1 0  
multiblock read objects 38,645 0.00 0.00 0 0  
ncodef allocation latch 90 0.00   0 0  
object queue header heap 3,610,622 0.05 0.47 2 428,540 0.19
object queue header operation 36,084,128 0.22 0.48 27 19,622 0.03
object stats modification 412,471 0.04 0.04 0 0  
parallel query alloc buffer 8,160 1.70 0.00 0 0  
parallel query stats 528 16.29 0.02 0 0  
parameter table allocation management 24,214 0.61 0.59 0 0  
post/wait queue 1,354,302 0.06 0.01 0 570,793 0.03
process allocation 9,917 0.10 0.90 0 4,948 0.02
process group creation 9,869 0.00   0 0  
process queue 5,030 1.51 0.00 0 0  
process queue reference 817,836 0.07 0.01 0 85,121 2.16
qmn task queue latch 516 0.00   0 0  
query server freelists 4,256 7.78 0.02 0 0  
query server process 8 0.00   0 8 0.00
redo allocation 5,611,863 5.04 0.02 7 101,840,840 3.30
redo copy 0     0 102,184,626 0.06
redo writing 4,041,103 0.21 0.02 1 0  
resmgr group change latch 860,822 0.00   0 0  
resmgr:actses active list 29,923 0.52 0.98 0 0  
resmgr:actses change group 29,334 0.00   0 0  
resmgr:free threads list 20,303 0.43 0.02 0 0  
resmgr:schema config 1 0.00   0 0  
row cache objects 129,594,779 0.47 0.01 17 6,041 0.41
rules engine aggregate statistics 41,554 0.06 0.00 0 0  
rules engine rule set statistics 133,559 0.03 0.00 0 0  
rules engine rule statistics 50,458 0.00   0 0  
sequence cache 16,627,714 1.39 0.00 0 0  
session allocation 19,706,092 0.95 0.02 5 0  
session idle bit 102,660,283 0.05 0.04 3 0  
session state list latch 58,846 0.14 0.34 0 0  
session switching 15,149 0.01 0.00 0 0  
session timer 1,248 0.00   0 0  
shared pool 7,926,009 0.30 0.06 1 0  
shared pool sim alloc 385 0.00   0 0  
shared pool simulator 2,199,391 0.00 0.05 0 0  
sim partition latch 1 0.00   0 22,646 0.15
simulator hash latch 2,460 0.00   0 0  
simulator lru latch 1,380 0.00   0 0  
slave class 1 0.00   0 0  
slave class create 4 0.00   0 0  
sort extent pool 1,430,996 0.12 0.03 0 0  
state object free list 12 0.00   0 0  
statistics aggregation 84 0.00   0 0  
temp lob duration state obj allocation 268 0.00   0 0  
temporary table state object allocation 12,610 0.00   0 0  
threshold alerts latch 605 0.00   0 0  
trace latch 43 0.00   0 0  
transaction allocation 117,081 0.00 0.00 0 0  
transaction branch allocation 90 0.00   0 0  
undo global data 989,878,682 1.52 0.00 53 17,769 0.14
user lock 38,668 0.03 0.18 0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch Name Get Requests Misses Sleeps Spin Gets Sleep1 Sleep2 Sleep3
cache buffers chains 4,861,879,684 69,717,122 2,294,039 67,646,772 0 0 0
undo global data 989,878,682 15,001,099 25,596 14,978,461 0 0 0
In memory undo latch 722,168,220 11,443,685 28,784 11,418,417 0 0 0
library cache 356,011,336 2,908,503 40,131 2,871,323 0 0 0
library cache pin 221,986,090 789,298 11,826 778,321 0 0 0
row cache objects 129,594,779 605,840 6,130 599,897 0 0 0
cache buffer handles 24,327,749 459,587 1,157 458,621 0 0 0
redo allocation 5,611,863 283,026 4,531 279,029 0 0 0
sequence cache 16,627,714 231,565 293 231,306 0 0 0
session allocation 19,706,092 186,853 3,114 183,936 0 0 0
object queue header operation 36,084,128 78,193 37,425 43,582 0 0 0
library cache lock 59,827,358 75,428 796 74,657 0 0 0
mostly latch-free SCN 870,127 70,041 307 69,761 0 0 0
cache buffers lru chain 10,484,531 69,760 6,385 63,780 0 0 0
session idle bit 102,660,283 50,558 1,965 48,640 0 0 0
shared pool 7,926,009 23,493 1,370 22,230 0 0 0
dml lock allocation 4,324,774 23,153 362 22,808 0 0 0
messages 5,786,325 17,913 214 17,700 0 0 0
enqueue hash chains 9,424,050 17,219 123 17,109 0 0 0
enqueues 5,420,579 13,028 378 12,662 0 0 0
redo writing 4,041,103 8,644 143 8,502 0 0 0
channel operations parent latch 1,837,730 6,556 50 6,512 0 0 0
active checkpoint queue latch 1,220,582 5,455 38 5,417 0 0 0
checkpoint queue latch 18,056,762 4,252 55 4,198 0 0 0
object queue header heap 3,610,622 1,946 923 1,099 0 0 0
sort extent pool 1,430,996 1,684 47 1,639 0 0 0
SQL memory manager workarea list latch 7,309,081 862 19 845 0 0 0
post/wait queue 1,354,302 836 12 824 0 0 0
lgwr LWN SCN 764,748 758 1 757 0 0 0
process queue reference 817,836 542 3 540 0 0 0
query server freelists 4,256 331 6 325 0 0 0
channel handle pool latch 414,915 270 26 244 0 0 0
library cache lock allocation 1,545,359 222 16 208 0 0 0
resmgr:actses active list 29,923 155 152 6 0 0 0
Consistent RBA 760,254 153 15 141 0 0 0
object stats modification 412,471 149 6 143 0 0 0
parameter table allocation management 24,214 147 86 71 0 0 0
KWQMN job cache list latch 14,436 122 121 2 0 0 0
client/application info 1,799,024 101 4 97 0 0 0
resmgr:free threads list 20,303 87 2 85 0 0 0
parallel query stats 528 86 2 84 0 0 0
session state list latch 58,846 85 29 57 0 0 0
shared pool simulator 2,199,391 80 4 77 0 0 0
list of block allocation 448,408 63 1 62 0 0 0
message pool operations parent latch 421,617 52 5 47 0 0 0
SGA IO buffer pool latch 44,513 49 1 48 0 0 0
library cache load lock 10,532 43 3 40 0 0 0
library cache pin allocation 540,605 16 3 14 0 0 0
user lock 38,668 11 2 9 0 0 0
process allocation 9,917 10 9 2 0 0 0
hash table column usage latch 1,908 1 1 0 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 17,305 19,852
In memory undo latch ktiFlush: child 0 6,743 4,003
In memory undo latch kticmt: child 0 2,925 841
In memory undo latch ktichg: child 0 1,042 3,973
In memory undo latch ktiTxnPoolFree 0 683 3
In memory undo latch ktiBRacquire 0 44 0
In memory undo latch ktbgfc 0 32 107
In memory undo latch ktuswr 0 1 0
KWQMN job cache list latch kwqmnuji: update job item 0 121 11
SGA IO buffer pool latch ksfd_alloc_sgabuffer 0 1 0
SQL memory manager workarea list latch qesmmIUnRegisterWorkArea 0 10 5
SQL memory manager workarea list latch qesmmIRegisterWorkArea 0 8 13
SQL memory manager workarea list latch qesmmIRefreshBound 0 1 1
active checkpoint queue latch kcbbacq: scan active checkpoints 0 38 38
cache buffer handles kcbzgs 0 761 586
cache buffer handles kcbzfs 0 396 571
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 2,288,361 2,664,701
cache buffers chains kcbchg: kslbegin: call CR func 0 996,075 1,762,825
cache buffers chains kcbgtcr: fast path 0 738,382 53,567
cache buffers chains kcbgtcr: kslbegin excl 0 361,195 224,379
cache buffers chains kcbzgb: scan from tail. nowait 0 283,272 0
cache buffers chains kcbrls: kslbegin 0 115,944 220,883
cache buffers chains kcbgcur: kslbegin 0 65,562 35,490
cache buffers chains kcbget: pin buffer 0 45,185 17,501
cache buffers chains kcbget: exchange 0 15,980 24,429
cache buffers chains kcbzwb 0 14,853 9,337
cache buffers chains kcbget: exchange rls 0 13,573 17,293
cache buffers chains kcbcge 0 5,481 10,157
cache buffers chains kcbnlc 0 3,275 2,803
cache buffers chains kcbso1: set no access 0 933 252
cache buffers chains kcb_is_private 0 325 3,468
cache buffers chains kcbbxsv 0 226 203
cache buffers chains kcbgtcr: kslbegin shared 0 226 180
cache buffers chains kcbesc: escalate 0 198 66
cache buffers chains kcbnew: new latch again 0 121 39
cache buffers chains kcb_pre_apply: kcbhq61 0 61 1,555
cache buffers chains kcb_post_apply: kcbhq63 0 41 278
cache buffers chains kcbbic2 0 40 16
cache buffers chains kcbo_ivd_process 0 16 43
cache buffers chains kcbzhngcbk1: get hash chain latch no wait 0 13 0
cache buffers chains kcb_post_apply: kcbhq62 0 6 288
cache buffers chains kcbzib: multi-block read: nowait 0 4 0
cache buffers chains kcbzib: finish free bufs 0 3 6
cache buffers chains kcbw_next_free 0 1 0
cache buffers lru chain kcbzgws 0 2,906 0
cache buffers lru chain kcbgtcr:CR Scan:KCBRSKIP 0 1,104 0
cache buffers lru chain kcbo_link_q 0 962 116
cache buffers lru chain kcbbxsv: move to being written 0 552 1,556
cache buffers lru chain kcbzgb: posted for free bufs 0 309 1,528
cache buffers lru chain kcbo_ivd_proc 0 214 1,660
cache buffers lru chain kcbzswcu 0 167 220
cache buffers lru chain kcbbic2 0 120 1,041
cache buffers lru chain kcbzgpwb: KSLBEGIN use prewarm buffers 0 18 218
cache buffers lru chain kcbzib 0 12 3
cache buffers lru chain kcbzfw 0 10 0
cache buffers lru chain kcbzgm 0 5 0
cache buffers lru chain kcbz_decr_wspwbcnt 0 3 84
cache buffers lru chain kcbo_write_process:free_unlink 0 2 0
cache buffers lru chain kcbzar: KSLNBEGIN 0 2 0
cache buffers lru chain kcbw_make_free_nowait 0 1 0
channel handle pool latch ksrchconnect() 0 70 58
channel handle pool latch ksrchdelete() 0 7 19
channel operations parent latch ksrapublish() 0 62 33
channel operations parent latch ksrmfree() 0 50 2
channel operations parent latch ksrchdelete() 0 20 45
channel operations parent latch ksrwait() 0 16 40
channel operations parent latch ksrsconsume() 0 9 15
channel operations parent latch ksrchconnect() 0 7 29
checkpoint queue latch kcbbwthc: thread checkpoint buffers 0 22 15
checkpoint queue latch kcbkubc 0 17 23
checkpoint queue latch kcbklbc: Link buffer into ckpt queue 0 14 4
checkpoint queue latch kcbswcu: Switch buffers 0 2 14
client/application info kqp327i 0 4 4
cost function kzulgt: find user res 0 1 1
cost function kzulrl 0 1 2
dml lock allocation ktaiam 0 226 251
dml lock allocation ktaidm 0 136 111
enqueue hash chains ksqgtl3 0 61 66
enqueue hash chains ksqrcl 0 57 48
enqueue hash chains ksqcmi: get hash chain latch after wait 0 3 9
enqueue hash chains ksucallcbksafely: ksqhngcbk1 0 2 0
enqueues ksqies 0 173 262
enqueues ksqgel: create enqueue 0 113 74
enqueues ksqdel 0 88 40
enqueues ksqgel: failed to get enqueue 0 2 0
enqueues ksqgtl2 0 1 1
hash table column usage latch KSXMMON_GETCELEM 0 1 0
lgwr LWN SCN kcs023 0 68 0
library cache kglpndl: child: after processing 0 17,047 1,276
library cache kglpnp: child 0 14,299 19,185
library cache kglobpn: child: 0 3,495 5,417
library cache kglpndl: child: before processing 0 2,196 11,415
library cache kglLockCursor 0 1,087 1,376
library cache kgldte: child 0 0 457 601
library cache kglpin 0 435 183
library cache kglhdgn: child: 0 293 537
library cache kglScanDependency 0 212 0
library cache kgldti: 2child 0 68 18
library cache kglic 0 17 1
library cache kglivl: child 0 10 0
library cache kglrtl 0 6 1
library cache kglupd: child 0 6 0
library cache kglhdgc: child: 0 4 0
library cache kglget: unpin heap 0 0 3 7
library cache kglhdiv: child 0 3 0
library cache kglivr: child 0 2 0
library cache kgldrp: child 0 1 0
library cache kgldtld: 2child 0 1 0
library cache kglhdbrnl: child 0 1 0
library cache kglini: child 0 1 0
library cache kglukp: child 0 1 3
library cache load lock kglllal: llatch: in loop 0 3 3
library cache lock kgllkdl: child: cleanup 0 510 452
library cache lock kgllkal: child: multiinstance 0 286 344
library cache lock kgllkdl: child: no lock handle 0 255 88
library cache lock allocation kgllkget 0 14 13
library cache lock allocation kgllkrel 0 2 4
library cache pin kglpndl 0 6,012 4,174
library cache pin kglpnp: child 0 4,995 6,107
library cache pin kglpnal: child: alloc space 0 819 1,545
library cache pin allocation kglpnget 0 3 1
list of block allocation ktlbbl 0 1 1
message pool operations parent latch ksrmalloc() 0 4 3
message pool operations parent latch ksrmfree() 0 2 3
messages ksarcv 0 93 29
messages ksarcv: after wait 0 76 139
messages ksaamb: after wakeup 0 45 46
mostly latch-free SCN kcslcu3 0 239 308
mostly latch-free SCN kcs01 0 11 15
mostly latch-free SCN kcsnew_scn_rba 0 4 0
mostly latch-free SCN kcs024 0 1 0
object queue header heap kcbo_link_q:reget 0 861 23
object queue header heap kcbw_link_q:alloc 0 52 900
object queue header heap kcbw_unlink_q 0 10 0
object queue header operation kcbo_ivbo 0 34,146 7,508
object queue header operation kcbw_link_q 0 8,420 4,741
object queue header operation kcbw_unlink_q 0 2,987 11,893
object queue header operation kcbo_switch_mq_bg 0 931 5,406
object queue header operation kcbo_switch_q_bg 0 759 2,778
object queue header operation kcbo_switch_cq 0 294 6,760
object queue header operation kcbo_link_q:reget 0 197 216
object queue header operation kcbo_swap_buf_bg 0 57 7,433
object queue header operation kcbo_swap_buf 0 31 1,093
object queue header operation kcbo_service_ockpt 0 26 5
object queue header operation kcbo_write_q 0 25 39
object queue header operation kcbw_unlink_q_bg 0 2 22
object stats modification ksoslinelm 0 6 4
parallel query stats kxfprst: KSLBEGIN:1 0 2 2
parameter table allocation management ksp_param_table_free 0 86 86
post/wait queue ksliwat:remove 0 9 6
post/wait queue ksliwat:add:nowait 0 3 0
process allocation ksucrp 0 9 0
process queue reference kxfpqrsnd 0 3 0
query server freelists kxfpobrmf 0 6 6
redo allocation kcrfw_redo_gen: redo allocation 1 0 3,351 0
redo allocation kcrfw_redo_gen: redo allocation 3 0 711 3,528
redo allocation kcrfw_redo_gen: redo allocation 2 0 309 0
redo allocation kcrfw_redo_write: before write 0 90 441
redo allocation kcrfw_redo_write: more space 0 69 604
redo writing kcrfwcr 0 79 135
redo writing kcrfw_post: rba scn pair 0 47 0
redo writing kcrfw_cal_target_rba 0 11 1
redo writing kcrfw_post: after write 0 6 7
resmgr:actses active list kgskchclass 0 152 68
resmgr:free threads list kgskthrcreate 0 1 1
resmgr:free threads list kgskthrsod 0 1 1
row cache objects kqreqd: reget 0 4,819 74
row cache objects kqrpre: find obj 0 974 3,654
row cache objects kqreqd 0 311 2,395
row cache objects kqrso 0 19 5
row cache objects kqrpup 0 1 0
sequence cache kdnssd 0 212 13
sequence cache kdnnxt: cached seq 0 64 18
sequence cache kdnss 0 17 262
session allocation ksuxds: KSUSFCLC not set 0 746 119
session allocation ksuprc 0 639 593
session allocation ksuxds: not user session 0 564 434
session allocation ksucri 0 509 939
session allocation ksudlc 0 448 821
session allocation ksudlp 0 54 4
session allocation kxfpqidqr 0 52 70
session allocation ksursi 0 51 125
session allocation kspallmod 0 26 0
session allocation kxfprdp 0 23 7
session allocation ksucrp 0 3 2
session idle bit ksupuc: set busy 0 1,643 831
session idle bit ksupuc: clear busy 0 760 1,524
session idle bit ksuxds 0 88 137
session state list latch kpseqd 0 28 0
session state list latch kpscad 0 1 2
shared pool kghupr1 0 839 991
shared pool kghalo 0 378 230
shared pool kghfrunp: clatch: nowait 0 226 0
shared pool kghfre 0 97 140
shared pool kghfrunp: alloc: wait 0 33 0
shared pool kghalp 0 23 8
shared pool kghfrunp: clatch: wait 0 10 17
shared pool kghfrh 0 1 1
shared pool simulator kglsim_unpin_simhp 0 4 4
sort extent pool ktstdt: dealloc sort extent 0 31 7
sort extent pool ktstaddextent1 0 6 1
sort extent pool ktstdt: return extent 0 5 4
sort extent pool ktstcrtobj 0 3 0
sort extent pool ktstsmonmsg 0 2 30
undo global data kturimugur: child 0 18,292 12,199
undo global data ktudba: KSLBEGIN 0 6,998 13,268
undo global data ktudnx:child 0 116 43
undo global data ktufrbs: child 0 62 68
undo global data ktubnd:child 0 55 10
undo global data ktusmasp: ktugd_tuux 0 39 6
undo global data ktucof: at start 0 25 0
undo global data ktumof: KSLBEGIN 0 6 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 70,060,240 3.35
INV APPS_TS_TX_IDX MTL_ITEM_CATEGORIES_U1   INDEX 51,598,368 2.46
ONT APPS_TS_TX_DATA OE_ORDER_LINES_ALL   TABLE 23,334,272 1.11
APPLSYS APPS_TS_TX_DATA WF_LOCAL_USER_ROLES FND_RESP TABLE PARTITION 22,407,328 1.07
WSH APPS_TS_TX_DATA WSH_DELIVERY_DETAILS   TABLE 21,189,328 1.01

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,099 7.68
AR APPS_ASSM_DATA RA_CUSTOMER_TRX_LINES_ALL   TABLE 13,061 2.86
WSH APPS_TS_TX_DATA WSH_DELIVERY_DETAILS   TABLE 9,555 2.09
HR APPS_TS_TX_IDX PAY_PERSON_LATEST_BALA_N50   INDEX 4,777 1.04
HR APPS_ASSM_DATA PAY_RUN_RESULTS   TABLE 4,047 0.89

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 16,927 29.90
WSH APPS_TS_TX_DATA WSH_TRIP_STOPS   TABLE 15,252 26.94
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_U1   INDEX 11,221 19.82
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N6   INDEX 3,305 5.84
HR APPS_ASSM_IDX PAY_RUN_RESULT_VALUES_PK   INDEX 1,715 3.03

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 31 31.96
APPLSYS APPS_TS_TX_IDX WF_ITEM_ATTRIBUTE_VALUES_PK   INDEX 16 16.49
GL APPS_ASSM_IDX GL_IMPORT_REFERENCES_N1   INDEX 14 14.43
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N5   INDEX 11 11.34
GL APPS_ASSM_IDX GL_INTERFACE_N1   INDEX 6 6.19

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 197,156 42.05
APPLSYS APPS_TS_TX_DATA WF_ITEM_ATTRIBUTE_VALUES   TABLE 62,265 13.28
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N6   INDEX 28,108 6.00
GL APPS_ASSM_DATA GL_JE_LINES   TABLE 19,236 4.10
SYS SYSTEM DBMS_LOCK_ALLOCATED   TABLE 17,670 3.77

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 534 46.63 0   534 73
dc_files 6,660 0.00 0   0 111
dc_global_oids 7,845,963 0.00 0   0 48
dc_histogram_data 7,197 10.71 0   0 952
dc_histogram_defs 422,711 2.60 0   3,982 5,258
dc_object_grants 72,690 0.06 0   0 83
dc_object_ids 13,056,908 0.01 0   48 1,691
dc_objects 181,657 1.00 0   275 1,244
dc_profiles 9,712 0.00 0   0 1
dc_rollback_segments 26,275 0.01 0   9 394
dc_segments 369,020 0.83 0   15,558 1,055
dc_sequences 53,539 0.12 0   53,539 123
dc_table_scns 20,615 0.04 0   0 5
dc_tablespace_quotas 15,419 0.11 0   208 49
dc_tablespaces 5,988,476 0.00 0   0 22
dc_usernames 515,137 0.01 0   0 22
dc_users 15,181,898 0.00 0   0 67
outstanding_alerts 268 0.75 0   1 42


Back to Top

 

Library Cache Activity

Namespace Get Requests Pct Miss Pin Requests Pct Miss Reloads Invali- dations
BODY 637,452 0.02 42,551,338 -0.03 23 0
CLUSTER 118 0.85 277 0.72 1 0
INDEX 15,803 0.35 16,574 0.49 0 0
JAVA DATA 616 0.00 0   0 0
PIPE 50,571 2.52 76,236 1.65 0 0
SQL AREA 6,681 86.69 113,874,891 0.51 4,062 448
TABLE/PROCEDURE 409,951 0.25 57,881,259 -0.08 1,230 0
TRIGGER 28,829 0.12 1,407,753 0.00 19 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,711.94   12.11 7.06 39 39 3,113 3,113
  Freeable 3,664.25 0.00 1.33 0.80 9   2,763 2,763
  SQL 3,490.61 1,794.89 1.12 0.71 4 22 3,105 3,103
  PL/SQL 2,410.88 193.02 0.77 0.96 3 3 3,113 3,113
  JAVA 267.88 266.66 2.23 0.31 5 8 120 120
E Other 43,906.34   13.97 8.57 41 41 3,142 3,142
  Freeable 4,247.75 0.00 1.51 0.93 9   2,820 2,820
  SQL 3,993.52 2,095.09 1.27 0.76 5 22 3,134 3,132
  PL/SQL 2,785.41 218.48 0.89 0.99 3 3 3,142 3,142
  JAVA 267.89 266.67 2.23 0.31 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,538,823,680
Fixed Size 2,111,120  
Redo Buffers 14,663,680  
Variable Size 2,751,465,840 2,919,238,000

Back to Memory Statistics
Back to Top

SGA breakdown difference

Pool Name Begin MB End MB % Diff
java free memory 51.29 51.29 0.00
java joxlod exec hp 12.09 12.09 0.00
large free memory 15.94 15.94 0.00
shared ASH buffers 29.00 29.00 0.00
shared CCursor 34.80 36.82 5.79
shared KTI-UNDO 53.19 53.19 0.00
shared PL/SQL MPCODE 66.54 70.41 5.83
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 337.73 329.55 -2.42
shared library cache 855.50 1,006.85 17.69
shared parameter table block 57.95 58.25 0.53
shared private strands 99.77 99.77 0.00
shared sessions 36.42 36.42 0.00
shared sql area 374.94 376.58 0.44
shared trace buffer 48.69 49.36 1.38
  buffer_cache 17,840.00 17,680.00 -0.90
  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,142 3,160 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