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 05-Aug-08 19:13:18 4795 209.3
End Snap: 2 05-Aug-08 20:13:23 4813 235.4
Elapsed:   60.09 (mins)    
DB Time:   578.55 (mins)    

 

Report Summary

Cache Sizes

  Begin End    
Buffer Cache: 17,872M 17,712M Std Block Size: 8K
Shared Pool Size: 2,512M 2,672M Log Buffer: 14,320K

Load Profile

  Per Second Per Transaction
Redo size: 8,785,209.44 27,402.94
Logical reads: 567,549.11 1,770.31
Block changes: 54,548.97 170.15
Physical reads: 115.26 0.36
Physical writes: 891.51 2.78
User calls: 12,481.42 38.93
Parses: 2,355.42 7.35
Hard parses: 2.45 0.01
Sorts: 2,841.55 8.86
Logons: 2.58 0.01
Executes: 27,150.11 84.69
Transactions: 320.59  

% Blocks changed per Read: 9.61 Recursive Call %: 77.89
Rollback per transaction %: 20.65 Rows per Sort: 12.45

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.95 Redo NoWait %: 100.00
Buffer Hit %: 99.98 In-memory Sort %: 100.00
Library Hit %: 99.71 Soft Parse %: 99.90
Execute to Parse %: 91.32 Latch Hit %: 98.49
Parse CPU to Parse Elapsd %: 89.84 % Non-Parse CPU: 97.75

Shared Pool Statistics

  Begin End
Memory Usage %: 85.87 86.98
% SQL with executions>1: 75.77 88.55
% Memory for SQL w/exec>1: 64.21 64.89

Top 5 Timed Events

Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class
CPU time   31,143   89.7  
log file sync 510,986 1,642 3 4.7 Commit
db file sequential read 252,093 1,036 4 3.0 User I/O
log file parallel write 737,215 589 1 1.7 System I/O
latch: cache buffers chains 2,102,960 392 0 1.1 Concurrency

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic Name Time (s) % of DB Time
DB CPU 31,143.11 89.72
sql execute elapsed time 29,286.93 84.37
PL/SQL execution elapsed time 6,777.89 19.53
inbound PL/SQL rpc elapsed time 6,751.49 19.45
parse time elapsed 860.50 2.48
Java execution elapsed time 790.64 2.28
hard parse elapsed time 389.57 1.12
repeated bind elapsed time 132.27 0.38
sequence load elapsed time 25.78 0.07
connection management call elapsed time 16.78 0.05
hard parse (sharing criteria) elapsed time 9.88 0.03
PL/SQL compilation elapsed time 8.51 0.02
failed parse elapsed time 2.03 0.01
hard parse (bind mismatch) elapsed time 1.08 0.00
DB time 34,713.17  
background elapsed time 1,608.70  
background cpu time 657.58  

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 510,986 0.00 1,642 3 0.44
User I/O 305,206 0.00 1,212 4 0.26
System I/O 1,029,866 0.00 862 1 0.89
Concurrency 3,102,146 0.15 710 0 2.68
Application 63,795 0.08 233 4 0.06
Network 51,383,198 0.00 195 0 44.46
Other 194,246 28.24 136 1 0.17
Configuration 8,353 0.00 10 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 510,986 0.00 1,642 3 0.44
db file sequential read 252,093 0.00 1,036 4 0.22
log file parallel write 737,215 0.00 589 1 0.64
latch: cache buffers chains 2,102,960 0.00 392 0 1.82
db file parallel write 261,749 0.00 260 1 0.23
enq: TX - row lock contention 985 4.77 159 162 0.00
buffer busy waits 892,575 0.00 128 0 0.77
db file scattered read 13,730 0.00 101 7 0.01
SQL*Net more data from client 2,334,882 0.00 95 0 2.02
read by other session 36,536 0.00 72 2 0.03
SQL*Net message to client 47,142,138 0.00 64 0 40.79
cursor: pin S wait on X 5,149 92.11 52 10 0.00
latch: undo global data 22,740 0.00 48 2 0.02
enq: UL - contention 2,071 0.34 47 23 0.00
latch: library cache 25,320 0.00 45 2 0.02
SQL*Net more data to client 1,906,178 0.00 36 0 1.65
latch: In memory undo latch 28,380 0.00 33 1 0.02
enq: TX - index contention 32,038 0.00 23 1 0.03
SQL*Net break/reset to client 60,696 0.00 15 0 0.05
library cache load lock 705 0.00 15 21 0.00
enq: RO - fast object reuse 43 0.00 12 283 0.00
latch: object queue header operation 27,039 0.00 12 0 0.02
latch: library cache pin 7,231 0.00 11 2 0.01
control file sequential read 29,164 0.00 11 0 0.03
rdbms ipc reply 7 57.14 10 1449 0.00
PX Deq Credit: send blkd 19,791 0.00 10 1 0.02
latch: cache buffers lru chain 3,902 0.00 10 2 0.00
LGWR wait for redo copy 31,278 0.13 8 0 0.03
buffer deadlock 54,850 98.44 7 0 0.05
kksfbc child completion 116 83.62 5 42 0.00
wait list latch free 388 0.00 5 12 0.00
latch: row cache objects 3,454 0.00 5 1 0.00
latch: redo allocation 4,194 0.00 4 1 0.00
latch free 2,647 0.00 4 1 0.00
log buffer space 536 0.00 4 7 0.00
enq: HW - contention 2,863 0.00 3 1 0.00
os thread startup 70 0.00 3 46 0.00
latch: session allocation 2,351 0.00 3 1 0.00
local write wait 1,646 0.00 3 2 0.00
PX Deq: Signal ACK 230 40.87 3 11 0.00
enq: SQ - contention 4,741 0.00 2 0 0.00
buffer exterminate 3 66.67 2 651 0.00
control file parallel write 1,738 0.00 2 1 0.00
enq: TX - contention 2,702 0.00 2 1 0.00
cursor: pin S 18,873 0.00 1 0 0.02
row cache lock 1,305 0.00 1 1 0.00
enq: DV - contention 175 0.00 1 6 0.00
latch: library cache lock 523 0.00 1 2 0.00
direct path read 732 0.00 1 1 0.00
latch: object queue header heap 469 0.00 1 1 0.00
latch: shared pool 670 0.00 1 1 0.00
enq: FB - contention 807 0.00 0 0 0.00
latch: cache buffer handles 599 0.00 0 1 0.00
SGA: allocation forcing component growth 32 50.00 0 10 0.00
latch: redo writing 103 0.00 0 3 0.00
library cache pin 1,413 0.00 0 0 0.00
PX qref latch 694 86.60 0 0 0.00
latch: enqueue hash chains 73 0.00 0 2 0.00
latch: messages 171 0.00 0 1 0.00
enq: TX - allocate ITL entry 103 0.00 0 1 0.00
latch: checkpoint queue latch 51 0.00 0 1 0.00
reliable message 27 0.00 0 1 0.00
cursor: mutex S 108 0.00 0 0 0.00
enq: PS - contention 34 0.00 0 0 0.00
write complete waits 7 0.00 0 1 0.00
direct path write 425 0.00 0 0 0.00
cursor: mutex X 245 0.00 0 0 0.00
enq: CU - contention 1 0.00 0 2 0.00
kkdlgon 1 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
latch: parallel query alloc buffer 1 0.00 0 0 0.00
SQL*Net message from client 47,142,113 0.00 9,257,888 196 40.79
pipe get 27,718 15.96 21,023 758 0.02
Streams AQ: waiting for time management or cleanup tasks 2,770 39.35 3,501 1264 0.00
Streams AQ: qmn slave idle wait 128 0.00 3,483 27210 0.00
Streams AQ: qmn coordinator idle wait 256 50.00 3,483 13605 0.00
PL/SQL lock timer 264 98.86 2,881 10911 0.00
PX Idle Wait 1,648 76.70 2,602 1579 0.00
jobq slave wait 612 99.84 1,791 2927 0.00
PX Deq: Execution Msg 5,346 0.00 43 8 0.00
PX Deq: Execute Reply 2,940 0.00 4 1 0.00
PX Deq Credit: need buffer 5,645 0.00 1 0 0.00
PX Deq: Msg Fragment 4,482 0.00 1 0 0.00
PX Deq: Table Q Normal 7,786 0.00 1 0 0.01
PX Deq: Parse Reply 225 0.00 0 1 0.00
PX Deq: Join ACK 197 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 737,223 0.00 589 1 0.64
db file parallel write 261,749 0.00 260 1 0.23
events in waitclass Other 42,941 0.10 16 0 0.04
control file sequential read 827 0.00 3 4 0.00
os thread startup 62 0.00 3 45 0.00
control file parallel write 1,738 0.00 2 1 0.00
direct path read 732 0.00 1 1 0.00
db file scattered read 148 0.00 1 4 0.00
db file sequential read 82 0.00 0 4 0.00
latch: redo writing 103 0.00 0 3 0.00
latch: cache buffers chains 147 0.00 0 2 0.00
latch: row cache objects 1 0.00 0 25 0.00
direct path write 333 0.00 0 0 0.00
latch: library cache 4 0.00 0 1 0.00
buffer busy waits 7 0.00 0 0 0.00
log file sync 1 0.00 0 0 0.00
latch: library cache pin 1 0.00 0 0 0.00
latch: shared pool 1 0.00 0 0 0.00
rdbms ipc message 1,520,130 0.78 36,190 24 1.32
pmon timer 1,269 95.90 3,511 2767 0.00
Streams AQ: waiting for time management or cleanup tasks 2,770 39.35 3,501 1264 0.00
smon timer 141,592 0.00 3,492 25 0.12
Streams AQ: qmn slave idle wait 128 0.00 3,483 27210 0.00
Streams AQ: qmn coordinator idle wait 256 50.00 3,483 13605 0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic Total
BUSY_TIME 3,403,003
IDLE_TIME 2,350,389
IOWAIT_TIME 73,051
NICE_TIME 0
SYS_TIME 204,223
USER_TIME 3,075,238
LOAD 9
RSRC_MGR_CPU_WAIT_TIME 0
PHYSICAL_MEMORY_BYTES 52,977,660
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 34,710.60 31,141.10 411,091 2,042,405,188
SYS$BACKGROUND 0.00 0.00 4,440 3,645,011
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 303908 121088 3101918 70671 0 0 51369453 19505
SYS$BACKGROUND 1297 157 224 307 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,100 1,074 300 3.67 3.17 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
746 628 101,280 0.01 2.15 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
609 571 56,432 0.01 1.76 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
595 560 56,380 0.01 1.71 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...
570 530 182,419 0.00 1.64 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
567 522 1,298 0.44 1.63 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
560 519 56,069 0.01 1.61 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
541 533 337,362 0.00 1.56 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
511 494 63,102 0.01 1.47 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
389 362 239,814 0.00 1.12 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
369 345 72,933 0.01 1.06 3prk3vg9u0abb FNDOAMCOL BEGIN FND_GLOBAL.APPS_INITIA...
358 313 171,388 0.00 1.03 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,074 1,100 300 3.58 3.17 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
628 746 101,280 0.01 2.15 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
571 609 56,432 0.01 1.76 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
560 595 56,380 0.01 1.71 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...
533 541 337,362 0.00 1.56 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
530 570 182,419 0.00 1.64 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
522 567 1,298 0.40 1.63 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
519 560 56,069 0.01 1.61 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
494 511 63,102 0.01 1.47 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
362 389 239,814 0.00 1.12 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
345 369 72,933 0.00 1.06 3prk3vg9u0abb FNDOAMCOL BEGIN FND_GLOBAL.APPS_INITIA...
313 358 171,388 0.00 1.03 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
68,622,380 182,419 376.18 3.35 529.85 569.70 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
66,640,881 239,814 277.89 3.26 361.98 389.35 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
46,092,268 156,450 294.61 2.25 235.99 251.70 5kqw5535fjvw6 ARXTWMAI SELECT NVL(RCTT.ATTRIBUTE10, ...
45,636,874 56,432 808.71 2.23 570.99 609.49 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
43,426,417 300 144,754.72 2.12 1074.33 1100.22 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
35,436,968 56,069 632.02 1.73 518.66 559.57 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
34,194,716 63,102 541.90 1.67 493.80 510.99 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
33,606,504 1,514,798 22.19 1.64 212.51 230.46 66tmsr3446uqn ap.oie.server.WebExpensesAM SELECT WIAS.ACTIVITY_STATUS, ...
32,520,265 171,477 189.65 1.59 292.20 336.74 gf1u933c95jb5 INVTTMTX DECLARE l_ret_stat varchar2...
32,511,397 171,388 189.69 1.59 312.62 357.67 3b3psftuyks81 INVTTMTX BEGIN INV_TXNSTUB_PUB.postTran...
29,857,309 9 3,317,478.78 1.46 165.27 165.27 bp8crdjba8zgt ARGLTP update ra_cust_trx_line_gl_dis...
28,515,665 1,298 21,968.93 1.39 521.82 566.69 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
26,822,975 56,380 475.75 1.31 560.28 594.88 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...
26,395,439 10,000 2,639.54 1.29 144.46 237.42 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...

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,235 10,000 4.52 10.89 144.46 237.42 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
33,968 2,171 15.65 8.17 152.38 279.16 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
20,572 19,467 1.06 4.95 219.74 294.12 1q78dwnrrkf6c asn.lead.server.LeadUwqAM BEGIN ASN_SALES_PVT.Lead_Proce...
13,641 239,814 0.06 3.28 361.98 389.35 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
9,591 6,488 1.48 2.31 164.85 209.96 8jb36w62w5hqf ibuSRDetailsActions.jsp BEGIN IBU_REQ_PKG.UpdateServic...
9,499 182,419 0.05 2.29 529.85 569.70 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
4,592 9,995 0.46 1.11 192.99 207.14 csvvv0fmhr1yc PYUSLV BEGIN FFP1893_01010001.FORMULA...
1,791 13,533 0.13 0.43 127.68 175.99 00y09j4jtwps1 JDBC Thin Client declare sid number; l_enc_ke...
1,296 324 4.00 0.31 199.01 209.05 fumydqvpk1g21 qotSCopOverview.jsp BEGIN ASO_QUOTE_PUB_W.SUBMIT_Q...
606 63,102 0.01 0.15 493.80 510.99 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...

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,514,798 784,005 0.52 0.00 0.00 66tmsr3446uqn ap.oie.server.WebExpensesAM SELECT WIAS.ACTIVITY_STATUS, ...
858,960 858,893 1.00 0.00 0.00 cd9mbmqyf4qhp ap.oie.server.WebExpensesAM UPDATE WF_ITEM_ACTIVITY_STATUS...
804,590 804,071 1.00 0.00 0.00 gnhmcahkmrnzs ap.oie.server.WebExpensesAM INSERT INTO WF_ITEM_ACTIVITY_S...
537,161 537,134 1.00 0.00 0.00 avc1jqzz04wpr JDBC Thin Client SELECT 'x' FROM DUAL
337,362 337,356 1.00 0.00 0.00 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
315,353 242,214 0.77 0.00 0.00 fmfdkztk8vx23   SELECT CATEGORY, SEVERITY, F...
262,009 4,453,847 17.00 0.00 0.00 cwyx16zn1hpfb JDBC Thin Client select parameter, value from ...
239,814 0 0.00 0.00 0.00 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
182,419 182,413 1.00 0.00 0.00 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
171,562 171,559 1.00 0.00 0.00 6gnth2mfbs2nq INVTTMTX declare v_ret number := 0...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse Calls Executions % Total Parses SQL Id SQL Module SQL Text
537,137 537,161 6.33 avc1jqzz04wpr JDBC Thin Client SELECT 'x' FROM DUAL
337,362 337,362 3.97 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
315,354 315,353 3.71 fmfdkztk8vx23   SELECT CATEGORY, SEVERITY, F...
262,004 262,009 3.09 cwyx16zn1hpfb JDBC Thin Client select parameter, value from ...
182,416 182,419 2.15 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
170,892 171,562 2.01 6gnth2mfbs2nq INVTTMTX declare v_ret number := 0...
121,981 122,686 1.44 fb13x9qx0ftks OEXOETEL begin OE_STANDARD_WF.OEOL_SELE...
114,381 115,082 1.35 1c0b7sas42w2z INVTTMTX SELECT NVL(ITEM_COST, 0), ...
108,455 108,454 1.28 162ttnv4ubqun OEXOETEL begin OE_DS_PVT.Check_PO_Appr...
100,306 100,336 1.18 8camsgjsr9zya OEXOETEL begin OE_TRANSACTION_TYPES_PK...
96,986 97,190 1.14 76sw2a4vnc89j icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.S...
91,692 91,664 1.08 bf7uwg5pa3pj6 icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.V...
91,601 91,740 1.08 608c0n36kaw62 icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.C...
91,506 97,221 1.08 dcvv68fju01g4 icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.E...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

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

Back to SQL Statistics
Back to Top

 

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

 

Complete List of SQL Text

SQL Id SQL Text
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 )
2nfc4vng01c8t SELECT END_DATE, START_DATE, ROW_ID, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, LAST_UPDATED_BY, PO_NUM, RELEASE_NUM, RELEASE_TYPE, REVISED_DATE, APPROVED_DATE, BILL_TO_LOCATION_ID, BILL_TO_LOCATION, AGENT_ID, VENDOR_SITE_ID, VENDOR_SITE_CODE, VENDOR_ID, VENDOR_NAME, VENDOR_CONTACT, AUTHORIZATION_STATUS, NEED_BY_DATE, REVISION_NUM, DOC_TYPE_NAME, GLOBAL_AGREEMENT_FLAG, OWNING_ORG_ID, TYPE_LOOKUP_CODE, ORDER_DATE, CURRENCY_CODE, TERMS_NAME, SHIP_VIA_LOOKUP_CODE, HEADER_FOB_LOOKUP_CODE, HEADER_FREIGHT_TERMS_LC, RATE_TYPE, RATE_DATE, RATE, PLL_NOTE_TO_RECEIVER, CONFIRMING_ORDER_FLAG, LINE_NUM, LINE_TYPE_ID, LINE_TYPE, ORDER_TYPE_LOOKUP_CODE, PURCHASE_BASIS, ITEM_ID, ITEM_REVISION, JOB_ID, CATEGORY_ID, ITEM_DESCRIPTION, UNIT_MEAS_LOOKUP_CODE, ALLOW_PRICE_OVERRIDE_FLAG, NOT_TO_EXCEED_PRICE, UN_NUMBER, HAZARD_CLASS, FROM_HEADER_ID, FROM_LINE_ID, FROM_LINE_LOCATION_ID, NOTE_TO_VENDOR, UNORDERED_FLAG, VENDOR_PRODUCT_NUM, CONTRACT_ID, MIN_RELEASE_AMOUNT, PO_HEADER_ID, PO_RELEASE_ID, CLOSED_BY, CANCELLED_BY, PO_LINE_ID, LINE_LOCATION_ID, SHIPMENT_NUM, CREATION_DATE, QUANTITY, QUANTITY_RECEIVED, QUANTITY_ACCEPTED, QUANTITY_REJECTED, QUANTITY_BILLED, QUANTITY_CANCELLED, AMOUNT, AMOUNT_RECEIVED, AMOUNT_BILLED, AMOUNT_CANCELLED, SHIP_TO_LOCATION_ID, SHIP_TO_LOCATION, PROMISED_DATE, LAST_ACCEPT_DATE, PRICE_OVERRIDE, ENCUMBERED_FLAG, TAXABLE_FLAG, TAX_NAME, CANCEL_FLAG, CANCEL_DATE, CANCEL_REASON, FIRM_STATUS_LOOKUP_CODE, MATCHING_TYPE, MATCH_OPTION, COUNTRY_OF_ORIGIN, QTY_RCV_TOLERANC E, QTY_RCV_EXCEPTION_CODE, ENFORCE_SHIP_TO_LOCATION_CODE, ALLOW_SUBSTITUTE_RECEIPTS_FLAG, DAYS_EARLY_RECEIPT_ALLOWED, DAYS_LATE_RECEIPT_ALLOWED, RECEIPT_DAYS_EXCEPTION_CODE, INVOICE_CLOSE_TOLERANCE, RECEIVE_CLOSE_TOLERANCE, SHIP_TO_ORGANIZATION_ID, SHIP_TO_ORGANIZATION, SOURCE_SHIPMENT_ID, SHIPMENT_TYPE, CLOSED_CODE, RECEIVING_ROUTING_ID, ROUTING_NAME, ACCRUE_ON_RECEIPT_FLAG, CLOSED_REASON, CLOSED_DATE, SOURCE_SHIPMENT_NUM, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, ATTRIBUTE_CATEGORY, USSGL_TRANSACTION_CODE, ACCEPTANCE_DUE_DATE, SECONDARY_UNIT_OF_MEASURE, SECONDARY_QUANTITY, PREFERRED_GRADE, SECONDARY_QUANTITY_RECEIVED, SECONDARY_QUANTITY_ACCEPTED, SECONDARY_QUANTITY_REJECTED, SECONDARY_QUANTITY_CANCELLED, VMI_FLAG, CONSIGNED_FLAG, CONSIGNED_CONSUMPTION_FLAG, AUTO_PRICED_FLAG FROM PO_LINE_LOCATIONS_INQ_V WHERE (:1 = agent_id OR EXISTS ( SELECT 'This employee is in approval path of this doc' FROM PO_ACTION_HISTORY POAH2 WHERE POAH2.employee_id + 0 = :2 AND POAH2.object_type_code in ('PO', 'PA') AND POAH2.object_id = po_header_id) OR( ((type_lookup_code = 'STANDARD') AND (release_num is null)) AND ( ( :3 = 'PUBLIC') OR ( :4 = 'PURCHASING' AND EXISTS (SELECT 'this employee is an agent' FROM PO_AGENTS POA WHERE POA.agent_id =:5 AND sysdate between nvl(POA.start_date_active, sysdate) and nvl(POA.end_date_active, sysdate + 1) )) OR ( :6 = 'HIERARCHY' AND :7 IN (SELECT POEH.superior_id FROM PO_EMPLOYEE_HIERARCHIES POEH WHERE POEH.employee_id = agent_id AND POEH.position_structure_id = nvl( :8 , -1) )) ) ) OR( ((type_lookup_code = 'PLANNED') AND (release_num is null)) AND ( ( :9 = 'PUBLIC') OR ( :10 = 'PURCHASING' AND EXISTS (SELECT 'this employee is an agent' FROM PO_AGENTS POA WHERE POA.agent_id = :11 AND sysdate between nvl(POA.start_date_active, sysdate) and nvl(POA.end_date_active, sysdate + 1) )) OR ( :12 = 'HIERARCHY' AND :13 IN (SELECT POEH.superior_id FROM PO_EMPLOYEE_HIERARCHIES POEH WHERE POEH.employee_id = agent_id AND POEH.position_structure_id = nvl( :14 , -1) )) ) ) OR( ((type_lookup_code = 'BLANKET') AND (release_num is null)) AND ( ( :15 = 'PUBLIC') OR ( :16 = 'PURCHASING' AND EXISTS (SELECT 'this employee is an agent' FROM PO_AGENTS POA WHERE POA.agent_id = :17 AND sysdate between nvl(POA.start_date_active, sysdate) and nvl(POA.end_date_active, sysdate + 1) )) OR ( :18 = 'HIERARCHY' AND :19 IN (SELECT POEH.superior_id FROM PO_EMPLOYEE_HIERARCHIES POEH WHERE POEH.employee_id = agent_id AND POEH.position_structure_id = nvl( :20 , -1) )) ) )OR( release_type = 'BLANKET' AND ( ( :21 = 'PUBLIC') OR ( :22 = 'PURCHASING' AND EXISTS (SELECT 'this employee is an agent' FROM PO_AGENTS POA WHERE POA.agent_id = :23 AND sysdate between nvl(POA.start_date_active, sysdate) and nvl(POA.end_date_active, sysdate + 1) )) OR ( :24 = 'HIERARCHY' AND :25 IN (SELECT POEH.superior_id FROM PO_EMPLOYEE_HIERARCHIE S POEH WHERE POEH.employee_id = agent_id AND POEH.position_structure_id = nvl( :26 , -1) )) ) )OR( release_type = 'SCHEDULED' AND ( ( :27 = 'PUBLIC') OR ( :28 = 'PURCHASING' AND EXISTS (SELECT 'this employee is an agent' FROM PO_AGENTS POA WHERE POA.agent_id = :29 AND sysdate between nvl(POA.start_date_active, sysdate) and nvl(POA.end_date_active, sysdate + 1) )) OR ( :30 = 'HIERARCHY' AND :31 IN (SELECT POEH.superior_id FROM PO_EMPLOYEE_HIERARCHIES POEH WHERE POEH.employee_id = agent_id AND POEH.position_structure_id = nvl( :32 , -1) )) ) )OR (:33 = 'Y')) AND -1=-1 and (po_line_locations_inq_v.owning_org_id = decode(po_line_locations_inq_v.global_agreement_flag, 'Y', po_line_locations_inq_v.owning_org_id, 204) ) and (RELEASE_TYPE IS NULL) and (PO_HEADER_ID=:34) and (PO_LINE_ID=:35) order by po_header_id desc, release_num desc, line_num, shipment_num
3b3psftuyks81 BEGIN INV_TXNSTUB_PUB.postTransaction(:1, :2, :3); END;
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;
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;
bp8crdjba8zgt update ra_cust_trx_line_gl_dist set gl_posted_date=:b0, posting_control_id=:b1, last_update_date=sysdate , last_updated_by=:b2 where (cust_trx_line_gl_dist_id in (select to_number(reference23) from gl_interface where ((((user_je_source_name=:b3 and set_of_books_id=:b4) and group_id=:b1) and (reference30||'')='RA_CUST_TRX_LINE_GL_DIST') and accounting_date between to_date((:b6||' 00:00:00'), 'DD-MON-RR HH24:MI:SS') and to_date((:b7||' 23:59:59'), 'DD-MON-RR HH24:MI:SS'))) and set_of_books_id=:b4)
bt0w082dfrm8v BEGIN WSH_SHIP_CONFIRM_ACTIONS.interface_ALL_wrp( :errbuf, :rc, :A0, :A1, :A2, :A3); END;
cd9mbmqyf4qhp UPDATE WF_ITEM_ACTIVITY_STATUSES SET ACTIVITY_STATUS = :B8 , ACTIVITY_RESULT_CODE = NVL(:B13 , ACTIVITY_RESULT_CODE), BEGIN_DATE = NVL(:B11 , BEGIN_DATE), END_DATE = NVL(:B12 , END_DATE), DUE_DATE = DECODE(:B11 , TO_DATE(NULL), DUE_DATE, :B10 ), OUTBOUND_QUEUE_ID = :B9 , EXECUTION_TIME = DECODE(:B8 , :B7 , :B4 , :B6 , NVL(EXECUTION_TIME, :B4 ), :B5 , NVL(EXECUTION_TIME, :B4 ), EXECUTION_TIME) WHERE ITEM_TYPE = :B3 AND ITEM_KEY = :B2 AND PROCESS_ACTIVITY = :B1
csvvv0fmhr1yc BEGIN FFP1893_01010001.FORMULA( :N1, :N4, :T1, :I1, :D1, :T2, :I2, :T7, :I7, :T8, :I8, :T5, :I5, :N3, :T4, :I4, :N2, :N5, :T3, :I3, :T6, :I6, :FFERLN, :FFERCD, :FFERMT); END;
cwyx16zn1hpfb select parameter, value from nls_session_parameters
dcvv68fju01g4 begin FND_FLEX_WORKFLOW_APIS.END_GENERATION (:v1, :v2, :v3, :v4, :v5); end;
fb13x9qx0ftks begin OE_STANDARD_WF.OEOL_SELECTOR (:v1, :v2, :v3, :v4, :v5); end;
fmfdkztk8vx23 SELECT CATEGORY, SEVERITY, FND_LOG_SEVERITY FROM FND_NEW_MESSAGES WHERE MESSAGE_NAME = :B1 AND APPLICATION_ID = :B2 AND LANGUAGE_CODE = :B3 AND ROWNUM = 1
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,088,981 856.84 2.67
CPU used when call started 3,082,267 854.97 2.67
CR blocks created 16,237,282 4,503.97 14.05
Cached Commit SCN referenced 47,800 13.26 0.04
Commit SCN cached 8 0.00 0.00
DB time 6,301,108 1,747.83 5.45
DBWR checkpoint buffers written 3,126,256 867.18 2.70
DBWR checkpoints 34 0.01 0.00
DBWR object drop buffers written 56,658 15.72 0.05
DBWR revisited being-written buffer 183 0.05 0.00
DBWR thread checkpoint buffers written 594,485 164.90 0.51
DBWR transaction table writes 2,369 0.66 0.00
DBWR undo block writes 1,592,290 441.68 1.38
DFO trees parallelized 48 0.01 0.00
IMU CR rollbacks 42,676,281 11,837.75 36.92
IMU Flushes 336,039 93.21 0.29
IMU Redo allocation size 2,217,220,360 615,022.92 1,918.39
IMU commits 599,971 166.42 0.52
IMU contention 39,422 10.94 0.03
IMU ktichg flush 10,334 2.87 0.01
IMU pool not allocated 0 0.00 0.00
IMU recursive-transaction flush 1,696 0.47 0.00
IMU undo allocation size 5,306,879,064 1,472,046.86 4,591.63
IMU- failed to get a private strand 0 0.00 0.00
PX local messages recv'd 52,807 14.65 0.05
PX local messages sent 52,807 14.65 0.05
Parallel operations downgraded 25 to 50 pct 40 0.01 0.00
Parallel operations not downgraded 8 0.00 0.00
SQL*Net roundtrips to/from client 47,127,871 13,072.55 40.78
active txn count during cleanout 122,450,861 33,965.99 105.95
application wait time 23,334 6.47 0.02
background checkpoints completed 3 0.00 0.00
background checkpoints started 2 0.00 0.00
background timeouts 13,886 3.85 0.01
branch node splits 1,053 0.29 0.00
buffer is not pinned count 591,259,898 164,006.43 511.57
buffer is pinned count 1,520,629,449 421,799.29 1,315.68
bytes received via SQL*Net from client 10,353,997,902 2,872,040.21 8,958.50
bytes sent via SQL*Net to client 9,472,386,803 2,627,494.81 8,195.72
calls to get snapshot scn: kcmgss 109,636,948 30,411.61 94.86
calls to kcmgas 20,144,905 5,587.89 17.43
calls to kcmgcs 17,583,565 4,877.41 15.21
change write time 76,170 21.13 0.07
cleanout - number of ktugct calls 32,097,391 8,903.32 27.77
cleanouts and rollbacks - consistent read gets 14,078,372 3,905.12 12.18
cleanouts only - consistent read gets 153,070 42.46 0.13
cluster key scan block gets 853,837 236.84 0.74
cluster key scans 236,858 65.70 0.20
commit batch/immediate performed 4,131 1.15 0.00
commit batch/immediate requested 4,131 1.15 0.00
commit cleanout failures: block lost 244,023 67.69 0.21
commit cleanout failures: buffer being written 1,121 0.31 0.00
commit cleanout failures: callback failure 113,236 31.41 0.10
commit cleanout failures: cannot pin 30,869 8.56 0.03
commit cleanouts 9,197,682 2,551.30 7.96
commit cleanouts successfully completed 8,808,433 2,443.32 7.62
commit immediate performed 4,131 1.15 0.00
commit immediate requested 4,131 1.15 0.00
commit txn count during cleanout 1,437,404 398.71 1.24
concurrency wait time 70,974 19.69 0.06
consistent changes 784,126,971 217,504.79 678.44
consistent gets 1,818,158,087 504,329.17 1,573.11
consistent gets - examination 1,282,252,744 355,677.24 1,109.43
consistent gets from cache 1,818,158,187 504,329.19 1,573.11
cursor authentications 2,275 0.63 0.00
data blocks consistent reads - undo records applied 780,150,198 216,401.70 675.00
db block changes 196,654,596 54,548.97 170.15
db block gets 227,913,995 63,219.85 197.20
db block gets direct 4,340 1.20 0.00
db block gets from cache 227,909,638 63,218.64 197.19
deferred (CURRENT) block cleanout applications 1,553,045 430.79 1.34
dirty buffers inspected 10,611 2.94 0.01
doubling up with imu segment 0 0.00 0.00
enqueue conversions 9,672 2.68 0.01
enqueue releases 4,354,517 1,207.88 3.77
enqueue requests 4,362,775 1,210.17 3.77
enqueue timeouts 8,193 2.27 0.01
enqueue waits 39,351 10.92 0.03
exchange deadlocks 54,864 15.22 0.05
execute count 97,878,907 27,150.11 84.69
failed probes on index block reclamation 13,880 3.85 0.01
frame signature mismatch 285 0.08 0.00
free buffer inspected 3,203,818 888.69 2.77
free buffer requested 20,610,248 5,716.97 17.83
heap block compress 30,792,319 8,541.32 26.64
hot buffers moved to head of LRU 1,410,855 391.35 1.22
immediate (CR) block cleanout applications 14,231,460 3,947.59 12.31
immediate (CURRENT) block cleanout applications 1,123,060 311.52 0.97
index crx upgrade (found) 75,678 20.99 0.07
index crx upgrade (positioned) 9,764,966 2,708.65 8.45
index fast full scans (full) 0 0.00 0.00
index fast full scans (rowid ranges) 784 0.22 0.00
index fetch by key 182,796,285 50,704.89 158.16
index scans kdiixs1 152,284,344 42,241.34 131.76
java call heap collected bytes 1,412,609,712 391,836.27 1,222.22
java call heap collected count 17,316,066 4,803.21 14.98
java call heap gc count 4,614 1.28 0.00
java call heap live object count 1,516,014 420.52 1.31
java call heap live object count max 1,518,901 421.32 1.31
java call heap live size 371,341,328 103,004.39 321.29
java call heap live size max 371,908,040 103,161.59 321.78
java call heap object count 3,691,550 1,023.98 3.19
java call heap object count max 3,698,854 1,026.01 3.20
java call heap total size 480,116,736 133,177.02 415.41
java call heap total size max 480,645,120 133,323.58 415.86
java call heap used size 510,537,072 141,615.15 441.73
java call heap used size max 511,510,048 141,885.04 442.57
leaf node 90-10 splits 20,044 5.56 0.02
leaf node splits 245,598 68.13 0.21
lob reads 21,479 5.96 0.02
lob writes 37,144 10.30 0.03
lob writes unaligned 37,144 10.30 0.03
logons cumulative 9,284 2.58 0.01
messages received 1,926,330 534.33 1.67
messages sent 1,926,330 534.33 1.67
no buffer to keep pinned count 16 0.00 0.00
no work - consistent read gets 487,236,520 135,151.94 421.57
opened cursors cumulative 5,490,748 1,523.05 4.75
parse count (failures) 3,237 0.90 0.00
parse count (hard) 8,837 2.45 0.01
parse count (total) 8,491,524 2,355.42 7.35
parse time cpu 70,049 19.43 0.06
parse time elapsed 77,973 21.63 0.07
physical read IO requests 266,544 73.94 0.23
physical read bytes 3,404,021,760 944,223.43 2,945.23
physical read total IO requests 295,821 82.06 0.26
physical read total bytes 3,882,770,432 1,077,020.96 3,359.46
physical read total multi block requests 13,724 3.81 0.01
physical reads 415,530 115.26 0.36
physical reads cache 414,612 115.01 0.36
physical reads cache prefetch 148,806 41.28 0.13
physical reads direct 918 0.25 0.00
physical reads direct temporary tablespace 186 0.05 0.00
physical reads prefetch warmup 100,283 27.82 0.09
physical write IO requests 1,370,851 380.25 1.19
physical write bytes 26,329,006,080 7,303,262.45 22,780.43
physical write total IO requests 2,601,481 721.61 2.25
physical write total bytes 59,476,555,264 16,497,884.18 51,460.41
physical write total multi block requests 1,423,682 394.91 1.23
physical writes 3,213,990 891.51 2.78
physical writes direct 4,859 1.35 0.00
physical writes direct (lob) 240 0.07 0.00
physical writes direct temporary tablespace 4,197 1.16 0.00
physical writes from cache 3,209,131 890.16 2.78
physical writes non checkpoint 2,334,246 647.48 2.02
pinned buffers inspected 4,258 1.18 0.00
prefetch clients - default 1 0.00 0.00
prefetch warmup blocks aged out before use 229,220 63.58 0.20
prefetched blocks aged out before use 2,170 0.60 0.00
process last non-idle time 3,604 1.00 0.00
queries parallelized 48 0.01 0.00
recursive calls 158,528,046 43,973.25 137.16
recursive cpu usage 1,767,539 490.29 1.53
redo blocks written 64,574,401 17,911.95 55.87
redo buffer allocation retries 605 0.17 0.00
redo entries 101,394,418 28,125.26 87.73
redo log space requests 0 0.00 0.00
redo log space wait time 0 0.00 0.00
redo ordering marks 1,162,720 322.52 1.01
redo size 31,671,576,116 8,785,209.44 27,402.94
redo subscn max counts 2,390,856 663.19 2.07
redo synch time 169,461 47.01 0.15
redo synch writes 2,188,021 606.92 1.89
redo wastage 309,884,988 85,957.34 268.12
redo write time 66,401 18.42 0.06
redo writer latching time 820 0.23 0.00
redo writes 737,226 204.50 0.64
rollback changes - undo records applied 244,380 67.79 0.21
rollbacks only - consistent read gets 2,376,450 659.19 2.06
rows fetched via callback 96,690,752 26,820.53 83.66
session connect time 0 0.00 0.00
session cursor cache hits 5,353,803 1,485.06 4.63
session logical reads 2,046,072,435 567,549.11 1,770.31
session pga memory 10,010,417,784 2,776,736.35 8,661.23
session pga memory max 11,211,818,360 3,109,986.45 9,700.71
session uga memory ############### 75,041,620.77 234,070.79
session uga memory max 67,180,688,800 18,634,892.66 58,126.20
shared hash latch upgrades - no wait 31,315,986 8,686.57 27.10
shared hash latch upgrades - wait 118,141 32.77 0.10
sorts (memory) 10,244,093 2,841.55 8.86
sorts (rows) 127,518,787 35,371.76 110.33
sql area evicted 1,810 0.50 0.00
sql area purged 3,406 0.94 0.00
summed dirty queue length 219,593 60.91 0.19
switch current to new buffer 1,351,877 374.99 1.17
table fetch by rowid 898,105,598 249,120.72 777.06
table fetch continued row 28,200,438 7,822.37 24.40
table scan blocks gotten 66,683,773 18,497.06 57.70
table scan rows gotten 2,026,293,410 562,062.71 1,753.19
table scans (long tables) 2,048 0.57 0.00
table scans (rowid ranges) 2,046 0.57 0.00
table scans (short tables) 5,638,691 1,564.09 4.88
total number of times SMON posted 141,630 39.29 0.12
transaction rollbacks 4,131 1.15 0.00
transaction tables consistent read rollbacks 108 0.03 0.00
transaction tables consistent reads - undo records applied 5,458 1.51 0.00
undo change vector size 11,067,968,724 3,070,084.76 9,576.25
user I/O wait time 121,294 33.65 0.10
user calls 44,996,803 12,481.42 38.93
user commits 917,123 254.40 0.79
user rollbacks 238,650 66.20 0.21
workarea executions - onepass 2 0.00 0.00
workarea executions - optimal 5,977,808 1,658.15 5.17
write clones created in background 1,631 0.45 0.00
write clones created in foreground 8,341 2.31 0.01

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistic Begin Value End Value
session cursor cache count 463,278 1,122,014
opened cursors current 1,003,825 1,132,966
workarea memory allocated 164 534
logons current 4,795 4,813

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 38 0 8.42 1.00 577,425 160 284,369 0.12
APPS_TS_TX_DATA 160,891 45 4.46 1.35 182,569 51 147,810 0.37
APPS_TS_TX_IDX 82,676 23 4.29 1.41 196,057 54 86,857 0.34
APPS_ASSM_DATA 8,704 2 2.25 6.58 210,617 58 62,823 0.33
APPS_ASSM_IDX 6,629 2 2.35 1.03 133,446 37 285,881 0.19
APPS_TS_TX_INTERFACE 993 0 4.62 2.27 36,613 10 35,392 0.23
TEMP 436 0 4.91 10.50 9,577 3 34 2.65
APPS_TS_SUMMARY 64 0 8.59 1.00 7,465 2 2,725 0.44
APPS_TS_SEED 1,861 1 6.45 1.56 4,887 1 912 2.41
SYSTEM 3,405 1 4.11 2.02 2,576 1 21,478 0.20
APPS_TS_QUEUES 286 0 5.98 1.52 4,953 1 397 0.18
APPS_TS_ARCHIVE 55 0 4.91 1.45 2,030 1 98 2.86
SYSAUX 278 0 2.19 1.10 1,382 0 1 0.00
APPS_TS_NOLOGGING 25 0 10.40 1.56 61 0 15 14.00
CTXSYS 24 0 7.08 1.00 6 0 0 0.00
APPS_TS_MEDIA 12 0 9.17 1.00 9 0 0 0.00
ODM 12 0 6.67 1.00 3 0 0 0.00
OLAP 12 0 7.50 1.00 3 0 0 0.00
OWAPUB 12 0 7.50 1.00 3 0 0 0.00
PORTAL 12 0 6.67 1.00 3 0 0 0.00
SYNCSERVER 12 0 5.83 1.00 3 0 0 0.00

Back to IO Stats
Back to Top

File IO Stats

Tablespace Filename Reads Av Reads/s Av Rd(ms) Av Blks/Rd Writes Av Writes/s Buffer Waits Av Buf Wt(ms)
APPS_ASSM_DATA /DB/visdata/apps_assm_data.dbf 8,704 2 2.25 6.58 210,617 58 62,823 0.33
APPS_ASSM_IDX /DB/visdata/apps_assm_idx.dbf 6,629 2 2.35 1.03 133,446 37 285,881 0.19
APPS_TS_ARCHIVE /DB/visdata/archive1.dbf 26 0 4.23 1.54 1,767 0 97 2.89
APPS_TS_ARCHIVE /DB/visdata/archive2.dbf 29 0 5.52 1.38 263 0 1 0.00
APPS_TS_MEDIA /DB/visdata/media1.dbf 4 0 10.00 1.00 3 0 0 0.00
APPS_TS_MEDIA /DB/visdata/media2.dbf 4 0 7.50 1.00 3 0 0 0.00
APPS_TS_MEDIA /DB/visdata/media3.dbf 4 0 10.00 1.00 3 0 0 0.00
APPS_TS_NOLOGGING /DB/visdata/nologging1.dbf 4 0 12.50 1.00 3 0 0 0.00
APPS_TS_NOLOGGING /DB/visdata/nologging2.dbf 15 0 8.00 1.00 46 0 15 14.00
APPS_TS_NOLOGGING /DB/visdata/nologging3.dbf 6 0 15.00 3.33 12 0 0 0.00
APPS_TS_QUEUES /DB/visdata/queues1.dbf 30 0 7.33 1.47 717 0 122 0.08
APPS_TS_QUEUES /DB/visdata/queues2.dbf 24 0 7.08 2.25 844 0 218 0.23
APPS_TS_QUEUES /DB/visdata/queues3.dbf 23 0 7.39 1.74 662 0 7 0.00
APPS_TS_QUEUES /DB/visdata/queues4.dbf 32 0 4.38 1.00 646 0 10 0.00
APPS_TS_QUEUES /DB/visdata/queues5.dbf 21 0 11.43 1.62 704 0 7 0.00
APPS_TS_QUEUES /DB/visdata/queues6.dbf 26 0 5.00 2.04 738 0 1 0.00
APPS_TS_QUEUES /DB/visdata/queues7.dbf 130 0 4.92 1.36 642 0 32 0.31
APPS_TS_SEED /DB/visdata/reference1.dbf 159 0 6.29 1.67 463 0 51 0.98
APPS_TS_SEED /DB/visdata/reference10.dbf 159 0 7.04 1.57 500 0 53 2.08
APPS_TS_SEED /DB/visdata/reference2.dbf 185 0 6.05 1.39 510 0 50 3.40
APPS_TS_SEED /DB/visdata/reference3.dbf 307 0 5.47 1.50 544 0 477 2.64
APPS_TS_SEED /DB/visdata/reference4.dbf 169 0 6.09 1.69 488 0 36 0.28
APPS_TS_SEED /DB/visdata/reference5.dbf 203 0 5.32 1.53 443 0 40 1.75
APPS_TS_SEED /DB/visdata/reference6.dbf 187 0 6.84 1.77 540 0 31 2.58
APPS_TS_SEED /DB/visdata/reference7.dbf 189 0 7.67 1.50 443 0 28 5.71
APPS_TS_SEED /DB/visdata/reference8.dbf 160 0 7.19 1.66 466 0 48 2.50
APPS_TS_SEED /DB/visdata/reference9.dbf 143 0 7.62 1.40 490 0 98 1.73
APPS_TS_SUMMARY /DB/visdata/summary1.dbf 5 0 8.00 1.00 901 0 375 0.16
APPS_TS_SUMMARY /DB/visdata/summary2.dbf 5 0 6.00 1.00 815 0 250 0.04
APPS_TS_SUMMARY /DB/visdata/summary3.dbf 7 0 8.57 1.00 838 0 364 2.83
APPS_TS_SUMMARY /DB/visdata/summary4.dbf 15 0 10.67 1.00 901 0 198 0.05
APPS_TS_SUMMARY /DB/visdata/summary5.dbf 8 0 8.75 1.00 882 0 371 0.05
APPS_TS_SUMMARY /DB/visdata/summary6.dbf 10 0 7.00 1.00 971 0 585 0.05
APPS_TS_SUMMARY /DB/visdata/summary7.dbf 7 0 8.57 1.00 1,027 0 287 0.00
APPS_TS_SUMMARY /DB/visdata/summary8.dbf 7 0 8.57 1.00 1,130 0 295 0.14
APPS_TS_TX_DATA /DB/visdata/tx_data1.dbf 2,894 1 5.32 1.31 324 0 2 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data10.dbf 2,819 1 5.02 1.32 206 0 0 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data11.dbf 2,905 1 5.08 1.38 192 0 0 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data12.dbf 12,718 4 3.15 1.29 2,459 1 3,626 1.00
APPS_TS_TX_DATA /DB/visdata/tx_data13.dbf 16,029 4 4.87 1.59 4,426 1 2,359 1.03
APPS_TS_TX_DATA /DB/visdata/tx_data14.dbf 12,347 3 4.32 1.33 26,939 7 20,217 0.28
APPS_TS_TX_DATA /DB/visdata/tx_data15.dbf 8,570 2 4.06 1.34 26,063 7 19,253 0.36
APPS_TS_TX_DATA /DB/visdata/tx_data16.dbf 8,608 2 4.07 1.33 24,585 7 20,896 0.30
APPS_TS_TX_DATA /DB/visdata/tx_data17.dbf 8,421 2 3.86 1.32 23,712 7 19,410 0.42
APPS_TS_TX_DATA /DB/visdata/tx_data18.dbf 8,528 2 4.02 1.34 22,958 6 19,135 0.42
APPS_TS_TX_DATA /DB/visdata/tx_data19.dbf 8,406 2 4.08 1.36 23,441 7 20,181 0.31
APPS_TS_TX_DATA /DB/visdata/tx_data2.dbf 6,445 2 3.41 1.19 586 0 1,979 1.15
APPS_TS_TX_DATA /DB/visdata/tx_data20.dbf 8,461 2 4.05 1.36 23,186 6 19,302 0.28
APPS_TS_TX_DATA /DB/visdata/tx_data21.dbf 20,417 6 5.20 1.39 951 0 1,414 0.11
APPS_TS_TX_DATA /DB/visdata/tx_data3.dbf 3,701 1 5.59 1.60 453 0 9 1.11
APPS_TS_TX_DATA /DB/visdata/tx_data4.dbf 14,893 4 4.85 1.13 301 0 7 4.29
APPS_TS_TX_DATA /DB/visdata/tx_data5.dbf 2,960 1 5.06 1.31 399 0 2 5.00
APPS_TS_TX_DATA /DB/visdata/tx_data6.dbf 3,010 1 5.29 1.38 217 0 3 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data7.dbf 2,918 1 5.22 1.35 443 0 15 4.00
APPS_TS_TX_DATA /DB/visdata/tx_data8.dbf 2,802 1 5.31 1.37 456 0 0 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data9.dbf 3,039 1 4.97 1.42 272 0 0 0.00
APPS_TS_TX_IDX /DB/visdata/tx_idx1.dbf 2,376 1 3.51 1.15 2,036 1 1,346 0.41
APPS_TS_TX_IDX /DB/visdata/tx_idx10.dbf 2,313 1 3.40 1.20 1,267 0 1,817 0.35
APPS_TS_TX_IDX /DB/visdata/tx_idx11.dbf 2,293 1 3.38 1.21 1,486 0 1,572 0.46
APPS_TS_TX_IDX /DB/visdata/tx_idx12.dbf 9,929 3 5.19 1.76 22,582 6 1,639 0.32
APPS_TS_TX_IDX /DB/visdata/tx_idx13.dbf 8,458 2 4.42 1.31 27,285 8 4,913 0.24
APPS_TS_TX_IDX /DB/visdata/tx_idx14.dbf 4,830 1 4.59 1.49 19,318 5 4,841 0.26
APPS_TS_TX_IDX /DB/visdata/tx_idx15.dbf 4,654 1 4.72 1.48 16,931 5 5,862 0.40
APPS_TS_TX_IDX /DB/visdata/tx_idx16.dbf 4,643 1 4.71 1.46 15,365 4 5,311 0.33
APPS_TS_TX_IDX /DB/visdata/tx_idx17.dbf 4,543 1 4.70 1.38 14,681 4 5,906 0.33
APPS_TS_TX_IDX /DB/visdata/tx_idx18.dbf 4,690 1 4.77 1.48 14,663 4 10,150 0.21
APPS_TS_TX_IDX /DB/visdata/tx_idx19.dbf 4,729 1 4.78 1.44 14,000 4 7,579 0.19
APPS_TS_TX_IDX /DB/visdata/tx_idx2.dbf 2,796 1 3.94 1.41 1,838 1 3,806 0.15
APPS_TS_TX_IDX /DB/visdata/tx_idx20.dbf 4,542 1 4.72 1.50 13,214 4 5,733 0.24
APPS_TS_TX_IDX /DB/visdata/tx_idx21.dbf 3,202 1 5.15 1.70 14,207 4 2,519 0.73
APPS_TS_TX_IDX /DB/visdata/tx_idx3.dbf 3,852 1 2.56 1.17 1,700 0 1,762 1.38
APPS_TS_TX_IDX /DB/visdata/tx_idx4.dbf 2,519 1 3.43 1.20 2,978 1 2,337 0.87
APPS_TS_TX_IDX /DB/visdata/tx_idx5.dbf 2,557 1 3.53 1.25 4,524 1 12,698 0.17
APPS_TS_TX_IDX /DB/visdata/tx_idx6.dbf 2,505 1 3.50 1.29 2,421 1 2,121 1.05
APPS_TS_TX_IDX /DB/visdata/tx_idx7.dbf 2,437 1 3.39 1.22 2,260 1 1,800 0.46
APPS_TS_TX_IDX /DB/visdata/tx_idx8.dbf 2,454 1 3.34 1.20 1,694 0 1,544 0.46
APPS_TS_TX_IDX /DB/visdata/tx_idx9.dbf 2,354 1 3.38 1.22 1,607 0 1,601 0.65
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte.dbf 180 0 4.44 1.84 5,848 2 15,415 0.26
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte2.dbf 191 0 4.76 2.39 7,154 2 7,763 0.25
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte3.dbf 104 0 4.33 3.38 6,277 2 5,009 0.21
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte4.dbf 126 0 5.24 2.68 5,979 2 3,297 0.16
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte5.dbf 265 0 4.26 1.73 5,718 2 2,547 0.18
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte6.dbf 127 0 5.04 2.48 5,637 2 1,361 0.16
APPS_UNDOTS1 /DB/visdata/undo01.dbf 3 0 10.00 1.00 60,735 17 34,779 0.14
APPS_UNDOTS1 /DB/visdata/undo02.dbf 3 0 6.67 1.00 60,915 17 24,670 0.12
APPS_UNDOTS1 /DB/visdata/undo03.dbf 3 0 6.67 1.00 58,595 16 35,202 0.08
APPS_UNDOTS1 /DB/visdata/undo04.dbf 3 0 20.00 1.00 56,995 16 35,278 0.11
APPS_UNDOTS1 /DB/visdata/undo05.dbf 4 0 10.00 1.00 56,837 16 28,666 0.14
APPS_UNDOTS1 /DB/visdata/undo06.dbf 3 0 6.67 1.00 57,903 16 28,429 0.11
APPS_UNDOTS1 /DB/visdata/undo07.dbf 6 0 5.00 1.00 53,882 15 23,737 0.11
APPS_UNDOTS1 /DB/visdata/undo08.dbf 5 0 6.00 1.00 54,548 15 21,843 0.10
APPS_UNDOTS1 /DB/visdata/undo09.dbf 4 0 7.50 1.00 58,049 16 28,080 0.13
APPS_UNDOTS1 /DB/visdata/undo10.dbf 4 0 10.00 1.00 58,966 16 23,685 0.14
CTXSYS /DB/visdata/ctx1.dbf 12 0 7.50 1.00 3 0 0 0.00
CTXSYS /DB/visdata/ctx2.dbf 12 0 6.67 1.00 3 0 0 0.00
ODM /DB/visdata/odm.dbf 12 0 6.67 1.00 3 0 0 0.00
OLAP /DB/visdata/olap.dbf 12 0 7.50 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 6.67 1.00 3 0 0 0.00
SYNCSERVER /DB/visdata/mobile01.dbf 12 0 5.83 1.00 3 0 0 0.00
SYSAUX /DB/visdata/sysaux01.dbf 19 0 4.74 1.84 654 0 1 0.00
SYSAUX /DB/visdata/sysaux02.dbf 259 0 2.01 1.05 728 0 0 0.00
SYSTEM /DB/visdata/sys1.dbf 366 0 3.99 1.93 107 0 80 1.50
SYSTEM /DB/visdata/sys2.dbf 418 0 3.54 1.86 191 0 121 0.91
SYSTEM /DB/visdata/sys3.dbf 421 0 4.23 1.84 247 0 20 0.50
SYSTEM /DB/visdata/sys4.dbf 398 0 3.19 1.87 230 0 7 8.57
SYSTEM /DB/visdata/sys5.dbf 495 0 4.32 1.58 644 0 2,287 0.13
SYSTEM /DB/visdata/sys6.dbf 429 0 4.97 1.93 63 0 6 0.00
SYSTEM /DB/visdata/sys7.dbf 286 0 4.48 2.65 170 0 48 0.63
SYSTEM /DB/visdata/sys8.dbf 250 0 4.32 2.83 491 0 18,801 0.20
SYSTEM /DB/visdata/sys9.dbf 342 0 4.06 2.28 433 0 108 0.83
TEMP /DB/visdata/temp1.dbf 130 0 6.15 17.62 2,621 1 18 2.22
TEMP /DB/visdata/temp2.dbf 160 0 4.81 13.39 2,667 1 7 7.14
TEMP /DB/visdata/temp3.dbf 76 0 3.29 1.00 2,332 1 9 0.00
TEMP /DB/visdata/temp4.dbf 70 0 4.57 1.00 1,957 1 0  

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,190,753 100 2,018,312,647 414,642 3,208,690 0 0 928,964


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 97 43464 1056941 4203815 188743680 4203815  
E 180 108 47420 1054540 10577442 188743680 10577442  

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 577,353 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 42,539.65 0.49 0.00 100.00 0.00 1,048,576
E 20,480 1,280 50,308.02 0.52 0.00 100.00 0.00 1,048,576

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High Optimal Total Execs Optimal Execs 1-Pass Execs M-Pass Execs
2K 4K 5,390,292 5,390,292 0 0
64K 128K 11,715 11,715 0 0
128K 256K 1,152 1,152 0 0
256K 512K 1,105 1,105 0 0
512K 1024K 171,853 171,853 0 0
1M 2M 395,012 395,012 0 0
2M 4M 72 70 2 0
4M 8M 13 13 0 0
8M 16M 6 6 0 0
32M 64M 8 8 0 0
64M 128M 6 6 0 0
128M 256M 2 2 0 0

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

PGA Target Est (MB) Size Factr W/A MB Processed Estd Extra W/A MB Read/ Written to Disk Estd PGA Cache Hit % Estd PGA Overalloc Count
2,560 0.13 825,699.55 10,365.96 99.00 1,281
5,120 0.25 825,699.55 10,278.44 99.00 1,235
10,240 0.50 825,699.55 10,154.52 99.00 1,180
15,360 0.75 825,699.55 10,000.70 99.00 1,123
20,480 1.00 825,699.55 2.73 100.00 1,070
24,576 1.20 825,699.55 2.73 100.00 1,026
28,672 1.40 825,699.55 2.73 100.00 939
32,768 1.60 825,699.55 2.73 100.00 683
36,864 1.80 825,699.55 0.00 100.00 177
40,960 2.00 825,699.55 0.00 100.00 0
61,440 3.00 825,699.55 0.00 100.00 0
81,920 4.00 825,699.55 0.00 100.00 0
122,880 6.00 825,699.55 0.00 100.00 0
163,840 8.00 825,699.55 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,128 0.80 320 14,169 2,426,298 1.00 4,003 2.39 181,424,005
2,400 0.90 547 18,240 2,428,154 1.00 2,147 1.28 181,532,207
2,672 1.00 818 22,290 2,428,626 1.00 1,675 1.00 181,561,406
2,944 1.10 1,088 28,513 2,428,690 1.00 1,611 0.96 181,566,061
3,216 1.20 1,318 35,121 2,428,694 1.00 1,607 0.96 181,566,532
3,488 1.31 1,410 38,572 2,428,694 1.00 1,607 0.96 181,566,589
3,760 1.41 1,458 40,011 2,428,694 1.00 1,607 0.96 181,566,602
4,032 1.51 1,458 40,011 2,428,694 1.00 1,607 0.96 181,566,602
4,304 1.61 1,458 40,011 2,428,694 1.00 1,607 0.96 181,566,602
4,576 1.71 1,458 40,011 2,428,694 1.00 1,607 0.96 181,566,602
4,848 1.81 1,458 40,011 2,428,694 1.00 1,607 0.96 181,566,602
5,120 1.92 1,458 40,011 2,428,694 1.00 1,607 0.96 181,566,602
5,392 2.02 1,458 40,011 2,428,694 1.00 1,607 0.96 181,566,602

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 44,500  
10,240 0.50 44,501  
15,360 0.75 44,506  
20,480 1.00 44,499  
25,600 1.25 44,507  
30,720 1.50 44,507  
35,840 1.75 44,508  
40,960 2.00 44,509  

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 8 171 973 1.00 1,676 1.00 15,996
32 0.50 8 171 973 1.00 1,676 1.00 15,996
48 0.75 8 171 973 1.00 1,676 1.00 15,996
64 1.00 8 171 973 1.00 1,676 1.00 15,996
80 1.25 8 171 973 1.00 1,676 1.00 15,996
96 1.50 8 171 973 1.00 1,676 1.00 15,996
112 1.75 8 171 973 1.00 1,676 1.00 15,996
128 2.00 8 171 973 1.00 1,676 1.00 15,996

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 633,952 174 0
undo block 214,245 22 0
undo header 70,124 11 0
1st level bmb 7,089 1 0
segment header 2,224 0 0
2nd level bmb 1,042 0 0
file header block 73 0 1
extent map 10 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) 7,769 922 6,847 876 163 186.51
UL-User-defined 68,314 67,295 1,019 2,041 48 23.49
TX-Transaction (index contention) 30,762 30,762 0 27,671 24 0.86
RO-Multiple Object Reuse (fast object reuse) 288 288 0 32 13 390.63
HW-Segment High Water Mark 255,861 255,858 5 2,432 3 1.41
SQ-Sequence Cache 41,896 41,896 0 3,579 2 0.60
TX-Transaction 1,263,594 1,263,749 0 1,882 2 0.88
DV-Diana Versioning 28,936 28,936 0 172 1 5.35
FB-Format Block 36,618 36,616 0 558 0 0.68
TX-Transaction (allocate ITL entry) 178 178 0 81 0 1.11
PS-PX Process Reservation 1,864 1,543 320 27 0 1.48
CU-Cursor 8,654 8,657 0 1 0 0.00

Back to Wait Statistics
Back to Top

 

Undo Statistics

Back to Top

Undo Segment Summary

Undo TS# Num Undo Blocks (K) Number of Transactions Max Qry Len (s) Max Tx Concurcy Min/Max TR (mins) STO/ OOS uS/uR/uU/ eS/eR/eU
1 1,580.73 1,258,064 2,670 350 198.283333333333333333333333333333333333/519.25 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
05-Aug 20:05 211,188 171,046 385 345 198 0/0 0/0/0/0/0/0
05-Aug 19:55 327,864 171,772 663 340 204 0/0 0/0/0/0/0/0
05-Aug 19:45 415,924 243,880 2,670 344 232 0/0 0/0/0/0/0/0
05-Aug 19:35 201,574 188,437 2,548 348 317 0/0 0/0/0/0/0/0
05-Aug 19:25 218,024 321,974 2,019 350 373 0/0 0/0/0/0/0/0
05-Aug 19:15 206,158 160,955 1,784 348 519 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,463 0.00   0 0  
AWR Alerted Metric Element list 307,327 0.00   0 0  
Consistent RBA 737,764 0.02 0.07 0 0  
FOB s.o list latch 50,852 0.02 0.00 0 0  
In memory undo latch 764,566,683 1.83 0.00 33 1,181,135 0.00
JOX SGA heap latch 1,918,949 0.00   0 0  
JS mem alloc latch 8 0.00   0 0  
JS queue access latch 8 0.00   0 0  
JS queue state obj latch 21,600 0.00   0 0  
JS slv state obj latch 183 0.00   0 0  
KMG MMAN ready and startup request latch 1,836 0.00   0 0  
KMG resize request state object freelist 24 0.00   0 0  
KTF sga latch 12 0.00   0 1,213 0.00
KWQMN job cache list latch 13,634 0.67 0.98 0 0  
MQL Tracking Latch 0     0 71 0.00
Memory Management Latch 779 0.00   0 1,823 0.00
OS process 14,013 0.00   0 0  
OS process allocation 10,567 0.00   0 0  
OS process: request allocation 9,087 0.00   0 0  
PL/SQL warning settings 4,251,993 0.00   0 0  
SGA IO buffer pool latch 34,093 0.10 0.00 0 34,724 0.30
SQL memory manager latch 1 0.00   0 1,197 0.00
SQL memory manager workarea list latch 6,410,709 0.01 0.01 0 0  
Shared B-Tree 129 0.00   0 0  
active checkpoint queue latch 1,191,673 0.45 0.01 0 2 0.00
active service list 45,182 0.10 0.00 0 1,252 0.00
begin backup scn array 132 0.00   0 0  
buffer pool 20 0.00   0 0  
cache buffer handles 23,245,486 1.94 0.00 0 0  
cache buffers chains 4,833,713,596 1.47 0.03 392 18,415,134 2.96
cache buffers lru chain 10,162,639 0.64 0.06 10 36,441,652 1.06
cache table scan latch 1,058 0.00   0 1,058 0.00
channel handle pool latch 373,929 0.07 0.05 0 0  
channel operations parent latch 1,631,177 0.44 0.00 0 0  
checkpoint queue latch 17,589,544 0.02 0.01 0 3,233,559 0.04
client/application info 1,631,599 0.00 0.02 0 0  
commit callback allocation 79,966 0.00   0 0  
compile environment latch 2,841,155 0.00   0 0  
dictionary lookup 78 0.00   0 0  
dml lock allocation 3,991,663 0.51 0.01 1 0  
dummy allocation 18,563 0.40 0.00 0 0  
enqueue hash chains 8,774,995 0.19 0.00 0 501 0.40
enqueues 4,932,515 0.23 0.02 0 0  
error message lists 816 3.92 0.00 0 0  
event group latch 4,556 0.00   0 0  
file cache latch 21,342 0.01 0.00 0 0  
global KZLD latch for mem in SGA 8,776 0.00   0 0  
global ctx hash table latch 22,047 0.00   0 0  
hash table column usage latch 2,210 0.09 0.00 0 14,016,321 0.00
hash table modification latch 139 0.00   0 0  
internal temp table object number allocation latc 3 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 32,219 0.02 0.00 0 0  
ksuosstats global area 242 0.00   0 0  
ktm global data 141,626 0.00   0 0  
kwqbsn:qsga 129 0.00   0 0  
lgwr LWN SCN 741,822 0.10 0.00 0 0  
library cache 326,959,634 0.77 0.01 45 25,971 1.00
library cache load lock 10,465 0.72 0.04 0 54 0.00
library cache lock 54,160,442 0.12 0.01 1 1 0.00
library cache lock allocation 1,407,963 0.01 0.03 0 0  
library cache pin 203,930,023 0.35 0.01 11 56 0.00
library cache pin allocation 490,454 0.00 0.04 0 0  
list of block allocation 446,072 0.01 0.08 0 0  
loader state object freelist 290,368 0.00 0.00 0 0  
longop free list parent 34 0.00   0 34 0.00
message pool operations parent latch 379,788 0.02 0.10 0 0  
messages 5,583,156 0.34 0.01 0 0  
mostly latch-free SCN 834,767 7.53 0.00 0 0  
multiblock read objects 30,376 0.00 0.00 0 0  
ncodef allocation latch 99 0.00   0 0  
object queue header heap 3,454,415 0.04 0.38 1 374,262 0.13
object queue header operation 34,311,443 0.20 0.40 12 19,632 0.52
object stats modification 371,707 0.03 0.03 0 0  
parallel query alloc buffer 8,160 1.83 0.01 0 0  
parallel query stats 528 16.67 0.05 0 0  
parameter table allocation management 21,949 0.65 0.63 0 0  
post/wait queue 1,230,203 0.06 0.03 0 511,875 0.03
process allocation 9,135 0.10 0.89 0 4,555 0.02
process group creation 9,087 0.00   0 0  
process queue 5,030 1.31 0.00 0 0  
process queue reference 794,205 0.08 0.00 0 81,805 0.85
qmn task queue latch 516 0.00   0 0  
query server freelists 4,256 7.80 0.01 0 0  
query server process 8 0.00   0 8 0.00
redo allocation 5,410,003 6.44 0.01 4 100,976,620 3.55
redo copy 0     0 101,396,689 0.05
redo writing 3,913,185 0.23 0.01 0 0  
resmgr group change latch 773,364 0.00   0 0  
resmgr:actses active list 27,310 0.37 0.99 0 0  
resmgr:actses change group 26,718 0.00   0 0  
resmgr:free threads list 18,561 0.36 0.03 0 0  
resmgr:schema config 1 0.00   0 0  
row cache objects 115,721,389 0.40 0.01 5 7,539 0.23
rules engine aggregate statistics 37,895 0.04 0.00 0 0  
rules engine rule set statistics 122,193 0.02 0.00 0 0  
rules engine rule statistics 46,407 0.00   0 0  
sequence cache 16,351,286 1.31 0.00 0 0  
session allocation 18,435,701 0.86 0.01 3 0  
session idle bit 92,821,291 0.04 0.03 1 0  
session state list latch 53,619 0.13 0.46 0 0  
session switching 13,675 0.00   0 0  
session timer 1,251 0.00   0 0  
shared pool 6,784,058 0.24 0.04 1 0  
shared pool sim alloc 353 0.00   0 0  
shared pool simulator 1,722,036 0.00 0.03 0 0  
sim partition latch 1 0.00   0 22,297 0.14
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,284,700 0.11 0.01 0 0  
state object free list 12 0.00   0 0  
statistics aggregation 84 0.00   0 0  
temp lob duration state obj allocation 263 0.00   0 0  
temporary table state object allocation 11,473 0.03 0.00 0 0  
threshold alerts latch 606 0.00   0 0  
trace latch 36 0.00   0 0  
transaction allocation 106,548 0.00 0.00 0 0  
transaction branch allocation 99 0.00   0 0  
undo global data 985,888,364 2.42 0.00 48 33,370 0.29
user lock 35,184 0.01 0.50 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,833,713,596 71,133,558 2,102,944 69,240,953 0 0 0
undo global data 985,888,364 23,840,232 22,749 23,820,175 0 0 0
In memory undo latch 764,566,683 13,958,079 28,377 13,933,274 0 0 0
library cache 326,959,634 2,530,817 25,312 2,507,560 0 0 0
library cache pin 203,930,023 703,907 7,229 697,306 0 0 0
row cache objects 115,721,389 459,630 3,454 456,287 0 0 0
cache buffer handles 23,245,486 450,161 599 449,642 0 0 0
redo allocation 5,410,003 348,460 4,196 344,888 0 0 0
sequence cache 16,351,286 214,265 237 214,052 0 0 0
session allocation 18,435,701 157,956 2,351 155,771 0 0 0
object queue header operation 34,311,443 68,012 27,040 42,918 0 0 0
cache buffers lru chain 10,162,639 65,338 3,902 61,646 0 0 0
library cache lock 54,160,442 63,596 523 63,100 0 0 0
mostly latch-free SCN 834,767 62,867 276 62,619 0 0 0
session idle bit 92,821,291 39,614 1,157 38,481 0 0 0
dml lock allocation 3,991,663 20,283 253 20,047 0 0 0
messages 5,583,156 18,744 171 18,576 0 0 0
enqueue hash chains 8,774,995 16,756 73 16,689 0 0 0
shared pool 6,784,058 16,075 670 15,472 0 0 0
enqueues 4,932,515 11,248 235 11,019 0 0 0
redo writing 3,913,185 9,067 103 8,964 0 0 0
channel operations parent latch 1,631,177 7,129 29 7,100 0 0 0
active checkpoint queue latch 1,191,673 5,336 35 5,301 0 0 0
checkpoint queue latch 17,589,544 4,376 51 4,328 0 0 0
sort extent pool 1,284,700 1,437 21 1,417 0 0 0
object queue header heap 3,454,415 1,227 469 797 0 0 0
lgwr LWN SCN 741,822 753 2 751 0 0 0
post/wait queue 1,230,203 695 18 677 0 0 0
SQL memory manager workarea list latch 6,410,709 624 8 617 0 0 0
query server freelists 4,256 332 2 330 0 0 0
channel handle pool latch 373,929 270 13 258 0 0 0
library cache lock allocation 1,407,963 191 5 186 0 0 0
Consistent RBA 737,764 153 10 144 0 0 0
parallel query alloc buffer 8,160 149 1 148 0 0 0
parameter table allocation management 21,949 142 90 64 0 0 0
resmgr:actses active list 27,310 101 100 3 0 0 0
object stats modification 371,707 93 3 90 0 0 0
KWQMN job cache list latch 13,634 91 89 2 0 0 0
parallel query stats 528 88 4 84 0 0 0
library cache load lock 10,465 75 3 72 0 0 0
session state list latch 53,619 68 31 39 0 0 0
message pool operations parent latch 379,788 67 7 61 0 0 0
resmgr:free threads list 18,561 67 2 65 0 0 0
client/application info 1,631,599 62 1 61 0 0 0
list of block allocation 446,072 62 5 58 0 0 0
shared pool simulator 1,722,036 32 1 31 0 0 0
library cache pin allocation 490,454 23 1 22 0 0 0
process allocation 9,135 9 8 1 0 0 0
user lock 35,184 2 1 1 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 16,230 19,017
In memory undo latch ktiFlush: child 0 7,006 4,229
In memory undo latch kticmt: child 0 3,358 820
In memory undo latch ktichg: child 0 1,160 4,207
In memory undo latch ktiTxnPoolFree 0 544 1
In memory undo latch ktiBRacquire 0 52 0
In memory undo latch ktbgfc 0 17 95
In memory undo latch ktuswr 0 1 0
KWQMN job cache list latch kwqmnuji: update job item 0 91 5
SQL memory manager workarea list latch qesmmIRegisterWorkArea 0 4 6
SQL memory manager workarea list latch qesmmIUnRegisterWorkArea 0 4 2
active checkpoint queue latch kcbbacq: scan active checkpoints 0 34 35
active checkpoint queue latch kcbo_add_ckpt: Add object ckpt 1 0 1 0
cache buffer handles kcbzgs 0 398 348
cache buffer handles kcbzfs 0 201 251
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 1,990,139 2,349,643
cache buffers chains kcbchg: kslbegin: call CR func 0 802,291 1,511,715
cache buffers chains kcbgtcr: fast path 0 728,975 51,780
cache buffers chains kcbgtcr: kslbegin excl 0 412,518 276,905
cache buffers chains kcbzgb: scan from tail. nowait 0 254,328 0
cache buffers chains kcbrls: kslbegin 0 160,126 289,244
cache buffers chains kcbgcur: kslbegin 0 89,988 50,534
cache buffers chains kcbget: pin buffer 0 40,480 15,675
cache buffers chains kcbget: exchange 0 34,118 42,552
cache buffers chains kcbget: exchange rls 0 30,220 34,989
cache buffers chains kcbzwb 0 14,314 9,916
cache buffers chains kcbcge 0 4,798 9,312
cache buffers chains kcbnlc 0 2,968 2,713
cache buffers chains kcbso1: set no access 0 782 242
cache buffers chains kcbbxsv 0 320 303
cache buffers chains kcb_is_private 0 228 2,851
cache buffers chains kcbgtcr: kslbegin shared 0 216 185
cache buffers chains kcbesc: escalate 0 163 64
cache buffers chains kcbnew: new latch again 0 94 21
cache buffers chains kcbbic2 0 48 8
cache buffers chains kcb_pre_apply: kcbhq61 0 45 1,582
cache buffers chains kcb_post_apply: kcbhq63 0 30 261
cache buffers chains kcbzhngcbk1: get hash chain latch no wait 0 7 0
cache buffers chains kcb_post_apply: kcbhq62 0 4 309
cache buffers chains kcbo_ivd_process 0 2 74
cache buffers chains kcbzib: multi-block read: nowait 0 2 0
cache buffers chains kcbzib: exchange rls 0 1 1
cache buffers chains kcbzib: finish free bufs 0 1 6
cache buffers lru chain kcbzgws 0 1,832 0
cache buffers lru chain kcbo_link_q 0 663 63
cache buffers lru chain kcbgtcr:CR Scan:KCBRSKIP 0 547 0
cache buffers lru chain kcbbxsv: move to being written 0 423 1,080
cache buffers lru chain kcbzgb: posted for free bufs 0 171 920
cache buffers lru chain kcbzswcu 0 87 158
cache buffers lru chain kcbo_ivd_proc 0 82 849
cache buffers lru chain kcbbic2 0 70 734
cache buffers lru chain kcbzfw 0 10 0
cache buffers lru chain kcbzgpwb: KSLBEGIN use prewarm buffers 0 6 113
cache buffers lru chain kcbzib 0 6 2
cache buffers lru chain kcbzgm 0 3 0
cache buffers lru chain kcbrlb 0 1 6
cache buffers lru chain kcbz_decr_wspwbcnt 0 1 47
channel handle pool latch ksrchconnect() 0 50 46
channel handle pool latch ksrchdelete() 0 4 8
channel operations parent latch ksrapublish() 0 49 26
channel operations parent latch ksrmfree() 0 38 3
channel operations parent latch ksrsconsume() 0 14 13
channel operations parent latch ksrchdelete() 0 7 34
channel operations parent latch ksrchconnect() 0 6 21
channel operations parent latch ksrwait() 0 5 22
checkpoint queue latch kcbbwthc: thread checkpoint buffers 0 22 16
checkpoint queue latch kcbklbc: Link buffer into ckpt queue 0 14 0
checkpoint queue latch kcbkubc 0 10 18
checkpoint queue latch kcbswcu: Switch buffers 0 5 18
client/application info kqp327i 0 2 2
cost function kzulrl 0 1 0
dml lock allocation ktaiam 0 148 184
dml lock allocation ktaidm 0 105 69
enqueue hash chains ksqgtl3 0 39 42
enqueue hash chains ksqrcl 0 29 28
enqueue hash chains ksqcmi: get hash chain latch after wait 0 3 2
enqueue hash chains ksqcmi: kslgpl 0 2 1
enqueues ksqies 0 105 152
enqueues ksqgel: create enqueue 0 73 57
enqueues ksqdel 0 57 26
lgwr LWN SCN kcs023 0 54 0
library cache kglpndl: child: after processing 0 10,308 700
library cache kglpnp: child 0 9,244 12,302
library cache kglobpn: child: 0 2,169 3,276
library cache kglpndl: child: before processing 0 1,413 7,201
library cache kglLockCursor 0 657 869
library cache kgldte: child 0 0 291 410
library cache kglpin 0 289 132
library cache kglScanDependency 0 205 0
library cache kglhdgn: child: 0 189 338
library cache kgldti: 2child 0 44 6
library cache kglic 0 30 0
library cache kglivl: child 0 9 0
library cache kglhdgc: child: 0 7 2
library cache kglhdiv: child 0 5 0
library cache kglrtl 0 4 0
library cache kglukp: child 0 3 1
library cache kglobld 0 2 2
library cache kglupd: child 0 2 0
library cache kglget: unpin heap 0 0 1 2
library cache load lock kglllal: llatch 0 3 0
library cache lock kgllkdl: child: cleanup 0 333 301
library cache lock kgllkal: child: multiinstance 0 189 222
library cache lock kgllkdl: child: no lock handle 0 156 44
library cache lock kglhdbrnl: child 0 1 0
library cache lock allocation kgllkget 0 3 3
library cache lock allocation kgllkrel 0 2 2
library cache pin kglpndl 0 3,566 2,410
library cache pin kglpnp: child 0 3,175 3,851
library cache pin kglpnal: child: alloc space 0 487 967
library cache pin allocation kglpnget 0 1 1
list of block allocation ktlbbl 0 3 0
list of block allocation ktlabl 0 2 4
message pool operations parent latch ksrmalloc() 0 6 2
message pool operations parent latch ksrmfree() 0 1 5
messages ksarcv 0 78 20
messages ksarcv: after wait 0 54 97
messages ksaamb: after wakeup 0 38 54
messages ksaclr 0 1 0
mostly latch-free SCN kcslcu3 0 221 277
mostly latch-free SCN kcs01 0 5 10
mostly latch-free SCN kcsnew_scn_rba 0 5 0
mostly latch-free SCN kcs024 0 2 0
object queue header heap kcbo_link_q:reget 0 455 8
object queue header heap kcbw_link_q:alloc 0 9 461
object queue header heap kcbw_unlink_q 0 5 0
object queue header operation kcbo_ivbo 0 25,824 5,495
object queue header operation kcbw_link_q 0 6,235 3,377
object queue header operation kcbw_unlink_q 0 2,687 8,954
object queue header operation kcbo_switch_mq_bg 0 725 4,741
object queue header operation kcbo_switch_q_bg 0 672 2,173
object queue header operation kcbo_switch_cq 0 246 5,483
object queue header operation kcbo_link_q:reget 0 100 157
object queue header operation kcbo_service_ockpt 0 33 5
object queue header operation kcbo_swap_buf_bg 0 29 5,341
object queue header operation kcbo_write_q 0 26 27
object queue header operation kcbo_swap_buf 0 19 907
object queue header operation kcbw_unlink_q_bg 0 1 22
object stats modification ksoslinelm 0 3 3
parallel query alloc buffer kxfpbalo 0 1 0
parallel query stats kxfprst: KSLBEGIN:1 0 4 4
parameter table allocation management ksp_param_table_free 0 90 89
post/wait queue ksliwat:remove 0 15 15
post/wait queue ksliwat:add:nowait 0 2 0
post/wait queue kslpstevent:get 0 1 4
process allocation ksucrp 0 8 0
query server freelists kxfpobadf 0 2 2
redo allocation kcrfw_redo_gen: redo allocation 1 0 2,967 0
redo allocation kcrfw_redo_gen: redo allocation 3 0 794 3,482
redo allocation kcrfw_redo_gen: redo allocation 2 0 304 0
redo allocation kcrfw_redo_write: before write 0 73 315
redo allocation kcrfw_redo_write: more space 0 56 412
redo writing kcrfwcr 0 68 97
redo writing kcrfw_post: rba scn pair 0 25 0
redo writing kcrfw_cal_target_rba 0 5 2
redo writing kcrfw_post: after write 0 5 5
resmgr:actses active list kgskchclass 0 99 39
resmgr:actses active list kgskactladd 0 1 52
resmgr:free threads list kgskthrsod 0 2 2
row cache objects kqreqd: reget 0 2,747 27
row cache objects kqrpre: find obj 0 520 2,054
row cache objects kqreqd 0 170 1,365
row cache objects kqrso 0 16 6
sequence cache kdnssd 0 171 10
sequence cache kdnnxt: cached seq 0 52 6
sequence cache kdnss 0 14 223
session allocation ksuxds: KSUSFCLC not set 0 649 130
session allocation ksuprc 0 453 407
session allocation ksuxds: not user session 0 382 339
session allocation ksucri 0 379 762
session allocation ksudlc 0 316 528
session allocation ksursi 0 48 99
session allocation kxfpqidqr 0 41 65
session allocation ksudlp 0 40 2
session allocation kxfprdp 0 25 17
session allocation kspallmod 0 18 0
session idle bit ksupuc: set busy 0 1,086 504
session idle bit ksupuc: clear busy 0 462 1,034
session idle bit ksuxds 0 57 68
session state list latch kpseqd 0 27 1
session state list latch kpscad 0 4 5
shared pool kghalo 0 337 171
shared pool kghfrunp: clatch: nowait 0 264 0
shared pool kghupr1 0 198 385
shared pool kghfre 0 73 106
shared pool kghfrunp: alloc: wait 0 47 1
shared pool kghfrunp: clatch: wait 0 19 24
shared pool kghalp 0 15 7
shared pool simulator kglsim_unpin_simhp 0 1 1
sort extent pool ktstdt: dealloc sort extent 0 10 3
sort extent pool ktstdt: return extent 0 5 2
sort extent pool ktstaddextent1 0 3 0
sort extent pool ktstallocext: new extent in-doubt 0 1 0
sort extent pool ktstcrtobj 0 1 1
sort extent pool ktstsmonmsg 0 1 15
undo global data kturimugur: child 0 18,789 14,033
undo global data ktudba: KSLBEGIN 0 3,780 8,642
undo global data ktudnx:child 0 56 18
undo global data ktusmasp: ktugd_tuux 0 41 8
undo global data ktufrbs: child 0 32 43
undo global data ktubnd:child 0 24 1
undo global data ktucof: at start 0 21 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 63,819,456 3.12
INV APPS_TS_TX_IDX MTL_ITEM_CATEGORIES_U1   INDEX 49,613,488 2.42
ONT APPS_TS_TX_DATA OE_ORDER_LINES_ALL   TABLE 22,802,176 1.11
APPLSYS APPS_TS_TX_DATA WF_LOCAL_USER_ROLES FND_RESP TABLE PARTITION 20,187,264 0.99
WSH APPS_TS_TX_DATA WSH_DELIVERY_DETAILS   TABLE 19,931,664 0.97

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Owner Tablespace Name Object Name Subobject Name Obj. Type Physical Reads %Total
GL APPS_ASSM_DATA GL_JE_LINES   TABLE 35,013 8.43
AR APPS_ASSM_DATA RA_CUSTOMER_TRX_LINES_ALL   TABLE 13,069 3.15
HR APPS_TS_TX_IDX PAY_PERSON_LATEST_BALA_N50   INDEX 4,777 1.15
HR APPS_ASSM_DATA PAY_RUN_RESULTS   TABLE 4,047 0.97
APPLSYS APPS_TS_TX_DATA WF_LOCAL_USER_ROLES FND_RESP TABLE PARTITION 1,278 0.31

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 15,489 28.71
WSH APPS_TS_TX_DATA WSH_TRIP_STOPS   TABLE 13,400 24.84
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_U1   INDEX 11,607 21.51
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N6   INDEX 3,066 5.68
HR APPS_ASSM_IDX PAY_RUN_RESULT_VALUES_PK   INDEX 1,726 3.20

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 25 30.86
GL APPS_ASSM_IDX GL_IMPORT_REFERENCES_N1   INDEX 19 23.46
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N5   INDEX 6 7.41
APPLSYS APPS_TS_TX_IDX WF_ITEM_ATTRIBUTE_VALUES_PK   INDEX 5 6.17
GL APPS_ASSM_IDX GL_IMPORT_REFERENCES_N3   INDEX 3 3.70

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

Owner Tablespace Name Object Name Subobject Name Obj. Type Buffer Busy Waits % of Capture
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_U1   INDEX 198,159 37.33
APPLSYS APPS_TS_TX_DATA WF_ITEM_ATTRIBUTE_VALUES   TABLE 85,728 16.15
AR APPS_TS_TX_INTERFACE RA_INTERFACE_LINES_ALL   TABLE 30,545 5.75
GL APPS_ASSM_DATA GL_JE_LINES   TABLE 25,680 4.84
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N6   INDEX 25,058 4.72

Back to Segment Statistics
Back to Top

 

Dictionary Cache Stats

Cache Get Requests Pct Miss Scan Reqs Pct Miss Mod Reqs Final Usage
dc_awr_control 5 20.00 0   2 1
dc_constraints 648 46.91 0   648 97
dc_files 6,660 0.00 0   0 111
dc_global_oids 7,056,394 0.00 0   0 47
dc_histogram_data 152,013 1.03 0   1 1,473
dc_histogram_defs 390,018 3.55 0   4,042 4,911
dc_object_grants 65,462 0.06 0   0 75
dc_object_ids 11,450,271 0.02 0   57 2,021
dc_objects 166,901 1.03 0   344 1,198
dc_profiles 8,837 0.00 0   0 1
dc_rollback_segments 19,232 0.00 0   0 351
dc_segments 343,491 0.76 0   15,788 2,231
dc_sequences 51,290 0.11 0   51,290 124
dc_table_scns 19,346 0.04 0   0 5
dc_tablespace_quotas 15,651 0.11 0   214 48
dc_tablespaces 5,380,629 0.00 0   0 21
dc_usernames 467,176 0.00 0   0 36
dc_users 13,587,165 0.00 0   0 68
outstanding_alerts 268 0.75 0   1 43


Back to Top

 

Library Cache Activity

Namespace Get Requests Pct Miss Pin Requests Pct Miss Reloads Invali- dations
BODY 584,025 0.02 39,056,916 -0.02 11 0
CLUSTER 62 0.00 143 0.70 1 0
INDEX 14,267 0.41 15,080 0.62 7 0
JAVA DATA 616 0.00 0   0 0
PIPE 45,600 2.52 67,806 1.67 0 0
SQL AREA 5,925 87.48 106,215,450 0.59 3,439 398
TABLE/PROCEDURE 372,757 0.24 53,358,239 -0.07 1,285 0
TRIGGER 26,052 0.05 1,357,206 0.00 46 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 33,641.42   11.80 6.84 38 38 2,850 2,850
  Freeable 3,332.19 0.00 1.33 0.83 9   2,511 2,511
  SQL 3,178.18 1,627.89 1.12 0.70 4 21 2,842 2,840
  PL/SQL 2,147.40 175.46 0.75 0.95 3 3 2,850 2,850
  JAVA 243.11 242.03 2.25 0.33 5 8 108 108
E Other 39,965.99   13.91 8.51 41 41 2,873 2,873
  Freeable 3,916.25 0.00 1.52 0.95 9   2,577 2,577
  SQL 3,668.52 1,914.34 1.28 0.77 5 21 2,865 2,863
  PL/SQL 2,514.38 198.72 0.88 0.98 3 3 2,873 2,873
  JAVA 243.17 242.12 2.25 0.33 5 8 108 108

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions Begin Size (Bytes) End Size (Bytes) (if different)
Database Buffers 18,740,150,272 18,572,378,112
Fixed Size 2,111,120  
Redo Buffers 14,663,680  
Variable Size 2,717,911,408 2,885,683,568

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 41.19 39.59 -3.89
shared KGLS heap 31.16   -100.00
shared KTI-UNDO 53.19 53.19 0.00
shared PCursor 26.29   -100.00
shared PL/SQL MPCODE 67.39 70.52 4.64
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 354.96 347.97 -1.97
shared library cache 777.90 924.69 18.87
shared parameter table block 52.68 52.89 0.40
shared private strands 99.77 99.77 0.00
shared sessions 36.42 36.42 0.00
shared sql area 383.06 414.85 8.30
shared trace buffer 44.63 45.19 1.26
  buffer_cache 17,872.00 17,712.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 2,874 2,893 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