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 16-Aug-08 08:20:22 5268 209.0
End Snap: 2 16-Aug-08 09:20:27 5301 233.4
Elapsed:   60.09 (mins)    
DB Time:   471.50 (mins)    

 

Report Summary

Cache Sizes

  Begin End    
Buffer Cache: 17,728M 17,568M Std Block Size: 8K
Shared Pool Size: 2,624M 2,784M Log Buffer: 14,320K

Load Profile

  Per Second Per Transaction
Redo size: 8,972,969.68 25,877.02
Logical reads: 570,734.26 1,645.93
Block changes: 55,917.93 161.26
Physical reads: 126.75 0.37
Physical writes: 905.73 2.61
User calls: 13,795.52 39.78
Parses: 2,563.57 7.39
Hard parses: 2.61 0.01
Sorts: 3,060.08 8.82
Logons: 2.83 0.01
Executes: 29,119.77 83.98
Transactions: 346.75  

% Blocks changed per Read: 9.80 Recursive Call %: 77.33
Rollback per transaction %: 21.22 Rows per Sort: 12.30

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.97 Soft Parse %: 99.90
Execute to Parse %: 91.20 Latch Hit %: 98.45
Parse CPU to Parse Elapsd %: 90.96 % Non-Parse CPU: 97.53

Shared Pool Statistics

  Begin End
Memory Usage %: 85.64 86.19
% SQL with executions>1: 88.29 89.57
% Memory for SQL w/exec>1: 63.98 66.52

Top 5 Timed Events

Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class
CPU time   26,070   92.2  
db file sequential read 286,977 1,215 4 4.3 User I/O
log file sync 539,230 810 2 2.9 Commit
log file parallel write 895,680 461 1 1.6 System I/O
db file parallel write 207,377 162 1 .6 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 26,069.99 92.15
sql execute elapsed time 24,071.53 85.09
inbound PL/SQL rpc elapsed time 5,832.09 20.62
PL/SQL execution elapsed time 5,657.19 20.00
parse time elapsed 788.08 2.79
Java execution elapsed time 501.42 1.77
hard parse elapsed time 394.57 1.39
repeated bind elapsed time 102.16 0.36
sequence load elapsed time 18.90 0.07
connection management call elapsed time 15.06 0.05
PL/SQL compilation elapsed time 8.19 0.03
hard parse (sharing criteria) elapsed time 3.79 0.01
failed parse elapsed time 2.16 0.01
hard parse (bind mismatch) elapsed time 1.22 0.00
DB time 28,290.28  
background elapsed time 1,272.19  
background cpu time 530.76  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait Class Waits %Time -outs Total Wait Time (s) Avg wait (ms) Waits /txn
User I/O 340,355 0.00 1,371 4 0.27
Commit 539,230 0.00 810 2 0.43
System I/O 1,133,960 0.00 635 1 0.91
Application 70,314 0.08 215 3 0.06
Network 56,728,488 0.00 200 0 45.37
Concurrency 3,698,630 0.12 189 0 2.96
Other 169,938 35.13 38 0 0.14
Configuration 8,424 0.00 5 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
db file sequential read 286,977 0.00 1,215 4 0.23
log file sync 539,230 0.00 810 2 0.43
log file parallel write 895,680 0.00 461 1 0.72
db file parallel write 207,377 0.00 162 1 0.17
enq: TX - row lock contention 449 10.69 158 351 0.00
SQL*Net more data from client 2,570,939 0.00 109 0 2.06
db file scattered read 13,054 0.00 83 6 0.01
read by other session 37,258 0.00 70 2 0.03
SQL*Net message to client 52,112,545 0.00 61 0 41.68
cursor: pin S wait on X 4,792 93.20 49 10 0.00
latch: cache buffers chains 2,522,388 0.00 47 0 2.02
buffer busy waits 1,066,984 0.00 40 0 0.85
enq: UL - contention 2,324 0.30 35 15 0.00
SQL*Net more data to client 2,045,004 0.00 30 0 1.64
latch: In memory undo latch 48,188 0.00 17 0 0.04
library cache load lock 858 0.00 14 16 0.00
enq: TX - index contention 33,579 0.00 14 0 0.03
enq: RO - fast object reuse 34 0.00 12 344 0.00
SQL*Net break/reset to client 67,506 0.00 11 0 0.05
PX Deq Credit: send blkd 21,721 0.00 10 0 0.02
control file sequential read 29,164 0.00 9 0 0.02
rdbms ipc reply 5 60.00 7 1462 0.00
kksfbc child completion 154 77.27 6 39 0.00
latch: library cache 8,848 0.00 3 0 0.01
os thread startup 70 0.00 3 42 0.00
local write wait 1,854 0.00 3 1 0.00
log buffer space 475 0.00 3 6 0.00
wait list latch free 235 0.00 3 11 0.00
PX Deq: Signal ACK 197 38.07 2 11 0.00
latch: object queue header operation 32,885 0.00 2 0 0.03
enq: HW - contention 3,295 0.00 2 1 0.00
LGWR wait for redo copy 37,378 0.00 1 0 0.03
control file parallel write 1,739 0.00 1 1 0.00
row cache lock 4,156 0.00 1 0 0.00
enq: TX - contention 3,197 0.00 1 0 0.00
latch free 1,733 0.00 1 1 0.00
latch: library cache pin 2,554 0.00 1 0 0.00
buffer exterminate 1 100.00 1 977 0.00
enq: DV - contention 220 0.00 1 4 0.00
enq: SQ - contention 4,422 0.00 1 0 0.00
latch: undo global data 2,413 0.00 1 0 0.00
latch: row cache objects 2,045 0.00 0 0 0.00
library cache pin 2,600 0.00 0 0 0.00
buffer deadlock 60,017 98.71 0 0 0.05
latch: session allocation 1,694 0.00 0 0 0.00
direct path read 732 0.00 0 0 0.00
SGA: allocation forcing component growth 29 51.72 0 10 0.00
latch: redo allocation 1,198 0.00 0 0 0.00
latch: cache buffers lru chain 1,484 0.00 0 0 0.00
enq: FB - contention 906 0.00 0 0 0.00
enq: TM - contention 1 0.00 0 146 0.00
latch: shared pool 740 0.00 0 0 0.00
enq: TX - allocate ITL entry 198 0.00 0 1 0.00
latch: library cache lock 242 0.00 0 0 0.00
cursor: pin S 3,568 0.00 0 0 0.00
latch: object queue header heap 244 0.00 0 0 0.00
L1 validation 5 60.00 0 7 0.00
PX qref latch 300 79.67 0 0 0.00
library cache lock 4 0.00 0 7 0.00
latch: enqueue hash chains 21 0.00 0 1 0.00
latch: cache buffer handles 125 0.00 0 0 0.00
latch: messages 103 0.00 0 0 0.00
reliable message 38 0.00 0 0 0.00
latch: redo writing 28 0.00 0 0 0.00
cursor: pin X 2 50.00 0 6 0.00
enq: CU - contention 3 0.00 0 3 0.00
cursor: mutex S 188 0.00 0 0 0.00
direct path write 436 0.00 0 0 0.00
latch: checkpoint queue latch 30 0.00 0 0 0.00
write complete waits 6 0.00 0 0 0.00
cursor: mutex X 394 0.00 0 0 0.00
enq: PS - contention 32 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,112,500 0.00 10,158,985 195 41.68
pipe get 29,576 14.77 21,090 713 0.02
Streams AQ: qmn slave idle wait 129 0.00 3,525 27326 0.00
Streams AQ: qmn coordinator idle wait 258 50.00 3,525 13663 0.00
Streams AQ: waiting for time management or cleanup tasks 2,943 40.16 3,504 1191 0.00
PX Idle Wait 1,644 76.40 2,570 1563 0.00
PL/SQL lock timer 224 100.00 2,518 11243 0.00
jobq slave wait 612 99.84 1,792 2929 0.00
PX Deq: Execution Msg 5,282 0.00 35 7 0.00
PX Deq: Execute Reply 2,708 0.00 4 1 0.00
PX Deq Credit: need buffer 5,314 0.00 1 0 0.00
PX Deq: Msg Fragment 4,459 0.00 1 0 0.00
PX Deq: Table Q Normal 6,007 0.00 0 0 0.00
PX Deq: Parse Reply 279 0.00 0 1 0.00
PX Deq: Join ACK 229 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 895,670 0.00 461 1 0.72
db file parallel write 207,377 0.00 162 1 0.17
control file sequential read 827 0.00 3 4 0.00
os thread startup 62 0.00 3 41 0.00
events in waitclass Other 48,636 0.00 2 0 0.04
db file scattered read 471 0.00 2 4 0.00
control file parallel write 1,739 0.00 1 1 0.00
db file sequential read 271 0.00 1 3 0.00
direct path read 732 0.00 0 0 0.00
latch: cache buffers chains 133 0.00 0 0 0.00
latch: redo writing 28 0.00 0 0 0.00
direct path write 333 0.00 0 0 0.00
log file sync 1 0.00 0 1 0.00
latch: shared pool 4 0.00 0 0 0.00
latch: library cache 2 0.00 0 0 0.00
buffer busy waits 8 0.00 0 0 0.00
latch: In memory undo latch 1 0.00 0 0 0.00
rdbms ipc message 1,559,099 0.79 37,136 24 1.25
Streams AQ: qmn slave idle wait 129 0.00 3,525 27326 0.00
Streams AQ: qmn coordinator idle wait 258 50.00 3,525 13663 0.00
pmon timer 1,274 95.60 3,512 2756 0.00
Streams AQ: waiting for time management or cleanup tasks 2,943 40.16 3,504 1191 0.00
smon timer 176,702 0.00 3,495 20 0.14

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic Total
BUSY_TIME 2,870,339
IDLE_TIME 5,697,891
IOWAIT_TIME 97,646
NICE_TIME 0
SYS_TIME 177,265
USER_TIME 2,590,652
LOAD 7
RSRC_MGR_CPU_WAIT_TIME 0
PHYSICAL_MEMORY_BYTES 47,076,192
NUM_CPUS 24
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 28,292.40 26,072.50 441,850 2,054,233,943
SYS$BACKGROUND 0.00 0.00 15,292 3,728,005
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 338540 136771 3698443 18678 0 0 56713388 19993
SYS$BACKGROUND 1809 290 210 258 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
802 801 304 2.64 2.84 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
612 596 16 38.28 2.17 7g05xfvc5vp74 ARTERRPW BEGIN arp_run.revenue_recognit...
612 578 112,814 0.01 2.16 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
528 494 202,493 0.00 1.87 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
494 491 1,443 0.34 1.75 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
472 471 376,000 0.00 1.67 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
445 441 57,147 0.01 1.57 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
429 425 56,820 0.01 1.52 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...
424 422 64,006 0.01 1.50 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
388 386 57,101 0.01 1.37 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
373 344 266,225 0.00 1.32 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
326 319 81,013 0.00 1.15 3prk3vg9u0abb FNDOAMCOL BEGIN FND_GLOBAL.APPS_INITIA...
285 142 2,409 0.12 1.01 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
285 192 21,633 0.01 1.01 1q78dwnrrkf6c asn.lead.server.LeadUwqAM BEGIN ASN_SALES_PVT.Lead_Proce...

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
801 802 304 2.64 2.84 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
596 612 16 37.25 2.17 7g05xfvc5vp74 ARTERRPW BEGIN arp_run.revenue_recognit...
578 612 112,814 0.01 2.16 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
494 528 202,493 0.00 1.87 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
491 494 1,443 0.34 1.75 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
471 472 376,000 0.00 1.67 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
441 445 57,147 0.01 1.57 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
425 429 56,820 0.01 1.52 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...
422 424 64,006 0.01 1.50 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
386 388 57,101 0.01 1.37 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
344 373 266,225 0.00 1.32 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
319 326 81,013 0.00 1.15 3prk3vg9u0abb FNDOAMCOL BEGIN FND_GLOBAL.APPS_INITIA...
192 285 21,633 0.01 1.01 1q78dwnrrkf6c asn.lead.server.LeadUwqAM BEGIN ASN_SALES_PVT.Lead_Proce...
142 285 2,409 0.06 1.01 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....

Back to SQL Statistics
Back to Top

SQL ordered by Gets

Buffer Gets Executions Gets per Exec %Total CPU Time (s) Elapsed Time (s) SQL Id SQL Module SQL Text
99,906,049 16 6,244,128.06 4.85 596.01 612.50 7g05xfvc5vp74 ARTERRPW BEGIN arp_run.revenue_recognit...
76,155,269 202,493 376.09 3.70 493.68 528.04 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
73,966,832 266,225 277.84 3.59 344.38 372.94 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
46,831,486 57,147 819.49 2.28 440.58 445.49 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
44,353,490 304 145,899.64 2.16 801.16 802.30 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
42,841,193 157,186 272.55 2.08 156.12 156.56 5kqw5535fjvw6 ARXTWMAI SELECT NVL(RCTT.ATTRIBUTE10, ...
41,776,566 1,443 28,951.19 2.03 491.16 494.48 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
40,852,978 57,101 715.45 1.99 385.53 388.02 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
38,830,535 64,006 606.67 1.89 422.29 424.35 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
31,585,987 1,581,000 19.98 1.53 163.33 163.85 66tmsr3446uqn ap.oie.server.WebExpensesAM SELECT WIAS.ACTIVITY_STATUS, ...
30,226,386 56,820 531.97 1.47 425.36 428.89 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...
27,984,807 173,973 160.86 1.36 203.90 206.46 3b3psftuyks81 INVTTMTX BEGIN INV_TXNSTUB_PUB.postTran...
27,623,576 173,295 159.40 1.34 191.44 193.92 gf1u933c95jb5 INVTTMTX DECLARE l_ret_stat varchar2...
26,390,231 9,998 2,639.55 1.28 121.16 224.19 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,227 9,998 4.52 9.90 121.16 224.19 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
39,769 2,409 16.51 8.70 141.80 285.22 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
36,098 2,409 14.98 7.90 19.45 187.02 3dssuqfjsynrk asn.lead.server.LeadUwqAM SELECT count(1) FROM (SELECT *...
24,194 21,633 1.12 5.29 192.45 284.83 1q78dwnrrkf6c asn.lead.server.LeadUwqAM BEGIN ASN_SALES_PVT.Lead_Proce...
13,284 266,225 0.05 2.91 344.38 372.94 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
10,690 721 14.83 2.34 107.30 150.12 dk0sqcvc2xjvs qotSCopHdrUpd.jsp BEGIN ASO_QUOTE_PUB_W.Create_Q...
9,361 7,213 1.30 2.05 149.22 190.43 8jb36w62w5hqf ibuSRDetailsActions.jsp BEGIN IBU_REQ_PKG.UpdateServic...
9,329 202,493 0.05 2.04 493.68 528.04 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
4,598 9,974 0.46 1.01 168.31 181.26 csvvv0fmhr1yc PYUSLV BEGIN FFP1893_01010001.FORMULA...
4,514 9,994 0.45 0.99 138.84 149.44 63t8zpm02skgh PYUSLV SELECT DECODE(COUNT(PRR.RUN_RE...

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,581,000 817,875 0.52 0.00 0.00 66tmsr3446uqn ap.oie.server.WebExpensesAM SELECT WIAS.ACTIVITY_STATUS, ...
895,346 895,318 1.00 0.00 0.00 cd9mbmqyf4qhp ap.oie.server.WebExpensesAM UPDATE WF_ITEM_ACTIVITY_STATUS...
597,125 597,105 1.00 0.00 0.00 avc1jqzz04wpr JDBC Thin Client SELECT 'x' FROM DUAL
376,000 375,990 1.00 0.00 0.00 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
344,216 262,733 0.76 0.00 0.00 fmfdkztk8vx23   SELECT CATEGORY, SEVERITY, F...
291,153 4,949,139 17.00 0.00 0.00 cwyx16zn1hpfb JDBC Thin Client select parameter, value from ...
266,225 0 0.00 0.00 0.00 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
202,493 202,486 1.00 0.00 0.00 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
173,973 173,935 1.00 0.00 0.00 3b3psftuyks81 INVTTMTX BEGIN INV_TXNSTUB_PUB.postTran...
173,805 173,764 1.00 0.00 0.00 6gnth2mfbs2nq INVTTMTX declare v_ret number := 0...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse Calls Executions % Total Parses SQL Id SQL Module SQL Text
597,096 597,125 6.46 avc1jqzz04wpr JDBC Thin Client SELECT 'x' FROM DUAL
376,000 376,000 4.07 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
344,221 344,216 3.72 fmfdkztk8vx23   SELECT CATEGORY, SEVERITY, F...
291,126 291,153 3.15 cwyx16zn1hpfb JDBC Thin Client select parameter, value from ...
202,482 202,493 2.19 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
169,880 173,805 1.84 6gnth2mfbs2nq INVTTMTX declare v_ret number := 0...
124,256 125,202 1.34 fb13x9qx0ftks OEXOETEL begin OE_STANDARD_WF.OEOL_SELE...
120,403 120,423 1.30 162ttnv4ubqun OEXOETEL begin OE_DS_PVT.Check_PO_Appr...
115,409 116,422 1.25 1c0b7sas42w2z INVTTMTX SELECT NVL(ITEM_COST, 0), ...
111,327 111,405 1.20 8camsgjsr9zya OEXOETEL begin OE_TRANSACTION_TYPES_PK...
101,211 101,323 1.09 76sw2a4vnc89j icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.S...
95,279 101,325 1.03 dcvv68fju01g4 icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.E...
95,266 95,320 1.03 608c0n36kaw62 icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.C...
95,201 95,318 1.03 bf7uwg5pa3pj6 icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.V...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b) Executions % Total SQL Id SQL Module SQL Text
1,213,974 2,885 0.04 9hypmc3t618sc OEXOETEL SELECT ORDERED_ITEM, ORDERED_Q...

Back to SQL Statistics
Back to Top

 

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

 

Complete List of SQL Text

SQL Id SQL Text
0z318y6g3uagc declare l_retstat varchar2 ( 3 ) ; l_msg_data varchar2 ( 244 ) ; l_msg_cnt number ; l_trx_cnt number ; BEGIN :retval := INV_TXN_MANAGER_PUB . process_Transactions ( p_api_version => 1.0 , p_commit => fnd_api . g_true , x_return_status => l_retstat , x_msg_count => l_msg_cnt , x_msg_data => l_msg_data , x_trans_count => l_trx_cnt , p_table => 1 , p_header_id => :header_id ) ; END ;
162ttnv4ubqun begin OE_DS_PVT.Check_PO_Approved( :t_application_id, :t_entity_short_name, :t_validation_entity_short_name, :t_validation_tmplt_short_name, :t_record_set_short_name, :t_scope, :t_result ); end;
1c0b7sas42w2z SELECT NVL(ITEM_COST, 0), COST_UPDATE_ID FROM CST_ITEM_COSTS WHERE INVENTORY_ITEM_ID = :1 AND ORGANIZATION_ID = :2 AND COST_TYPE_ID = :3
1q78dwnrrkf6c BEGIN ASN_SALES_PVT.Lead_Process_After_Update( P_Api_Version_Number => 2.0, P_Init_Msg_List => FND_API.G_TRUE, p_Commit => FND_API.G_FALSE, p_Validation_Level => FND_API.G_VALID_LEVEL_NONE, P_Identity_Salesforce_Id => :1, P_Salesgroup_id => :2, P_Sales_Lead_Id => :3, X_Return_Status => :4, X_Msg_Count => :5, X_Msg_Data => :6); END;
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;
3dssuqfjsynrk SELECT count(1) FROM (SELECT * FROM ( SELECT LeadEO.sales_lead_id as SalesLeadId , to_char(hz_timezone_pub.convert_datetime(:1, hcp.timezone_id, SYSDATE), 'HH:MI AM ') ||' '||ht.standard_time_short_code as PrimaryContactLocalTime , SUBSTRB(LeadEO.description, 1, 240) as Description , hp.party_name as ContactName , custParty.party_name as CustomerName , aslt.meaning as RankName , ast.meaning as LeadStatus , ROUND(SYSDATE - LeadEO.creation_date) as Age , DECODE(LeadEO.status_code, 'CONVERTED_TO_OPPORTUNITY', 'ASNCnvToOpptyDsbld', 'ASNCnvToOpptyEnbld') as ASNLeadLstCnvToOppty , LeadEO.customer_id , hp.party_id , LeadEO.primary_contact_party_id , hr.relationship_id FROM as_sales_leads LeadEO , ( SELECT /*+ no_merge */ distinct aaa.sales_lead_id, aaa.customer_id FROM as_accesses_all aaa WHERE aaa.sales_lead_id IS NOT NULL AND aaa.lead_id IS NULL AND aaa.salesforce_id = :2) secu , as_statuses_tl ast , as_sales_lead_ranks_tl aslt , hz_parties CustParty , hz_parties hp, hz_relationships hr , hz_contact_points hcp , hz_timezones ht , ams_source_codes amsc WHERE LeadEO.sales_lead_id = secu.sales_lead_id AND LeadEO.customer_id = secu.customer_id AND LeadEO.status_code = ast.status_code AND ast.language = USERENV('LANG') AND LeadEO.lead_rank_id = aslt.rank_id (+) AND aslt.language (+) = USERENV('LANG') AND LeadEO.customer_id = CustParty.party_id AND LeadEO.primary_contact_party_id = hr.party_id(+) AND hr.subject_ id = hp.party_id (+) AND hr.subject_table_name (+) = 'HZ_PARTIES' AND hr.object_id(+) = LeadEO.customer_id AND hr.object_table_name (+) = 'HZ_PARTIES' AND LeadEO.primary_contact_party_id = hcp.owner_table_id(+) AND hcp.owner_table_name (+) = 'HZ_PARTIES' AND hcp.primary_flag (+) = 'Y' AND hcp.contact_point_type (+) = 'PHONE' AND hcp.timezone_id = ht.timezone_id (+) AND LeadEO.source_promotion_id = amsc.source_code_id AND amsc.source_code_for_id = :3 AND LeadEO.status_code = :4 ORDER BY age ) )
3prk3vg9u0abb BEGIN FND_GLOBAL.APPS_INITIALIZE( user_id=>:1 , resp_id=>:2 , resp_appl_id=>:3 , security_group_id=>:4 , server_id=>:5);END;
4yak7x2zqz0dh BEGIN inv_transfer_order_pvt.finalize_pick_confirm(:1, :2, :3, :4, :5, :6, :7); END;
5kqw5535fjvw6 SELECT NVL(RCTT.ATTRIBUTE10, ' ') FROM RA_CUST_TRX_TYPES_ALL RCTT, RA_CUSTOMER_TRX_ALL RCT WHERE RCT.CUSTOMER_TRX_ID = :B1 AND RCT.CUST_TRX_TYPE_ID = RCTT.CUST_TRX_TYPE_ID
608c0n36kaw62 begin FND_FLEX_WORKFLOW_APIS.COPY_FROM_COMBINATION (:v1, :v2, :v3, :v4, :v5); end;
63t8zpm02skgh SELECT DECODE(COUNT(PRR.RUN_RESULT_ID), 0, 'N', 'Y') FROM PAY_RUN_RESULTS PRR, PAY_ASSIGNMENT_ACTIONS ASA, PAY_PAYROLL_ACTIONS PPA WHERE PRR.SOURCE_ID = :B3 AND PRR.SOURCE_TYPE IN ('E', 'I') AND PRR.STATUS IN ('P', 'PA', 'R', 'O') AND ASA.ASSIGNMENT_ACTION_ID = PRR.ASSIGNMENT_ACTION_ID AND PPA.PAYROLL_ACTION_ID = ASA.PAYROLL_ACTION_ID AND NOT EXISTS (SELECT NULL FROM PAY_RUN_RESULTS PRR2 WHERE PRR2.SOURCE_ID = PRR.RUN_RESULT_ID AND PRR2.SOURCE_TYPE IN ('R', 'V')) AND PPA.DATE_EARNED BETWEEN :B2 AND :B1
64qc329wgjv39 select /*+ ORDERED INDEX(ASSBAL PAY_ASSIGNMENT_LATEST_BALA_N1) INDEX(DEFBAL PAY_DEFINED_BALANCES_PK) INDEX(ACT PAY_ASSIGNMENT_ACTIONS_PK) INDEX(PACT PAY_PAYROLL_ACTIONS_PK) INDEX(VALUE PAY_BALANCE_CONTEXT_VALUES_PK) USE_NL(ASSBAL DEFBAL ACT PACT VALUE) +*/ ASSBAL.defined_balance_id , DEFBAL.balance_dimension_id , to_char(ASSBAL.value) , ASSBAL.latest_balance_id , ASSBAL.rowid , to_char(ASSBAL.assignment_action_id) , ACT.payroll_action_id , to_char(PACT.effective_date, :b0) , to_number(to_char(PACT.effective_date, 'J')) , nvl(VALUE.context_id, 0) , nvl(VALUE.value, 'NULL') , to_char(ASSBAL.expired_assignment_action_id) , to_char(ASSBAL.expired_value) , to_char(ASSBAL.prev_assignment_action_id) , to_char(ASSBAL.prev_balance_value) from pay_assignment_latest_balances ASSBAL , pay_defined_balances DEFBAL , pay_assignment_actions ACT , pay_payroll_actions PACT , pay_balance_context_values VALUE where ((((ASSBAL.assignment_id=:b1 and ACT.assignment_action_id=ASSBAL.assignment_action_id) and PACT.payroll_action_id=ACT.payroll_action_id) and DEFBAL.defined_balance_id=ASSBAL.defined_balance_id) and VALUE.latest_balance_id(+)=ASSBAL.latest_balance_id) union all select /*+ ORDERED INDEX(PERBAL PAY_PERSON_LATEST_BALANCES_N2) INDEX(DEFBAL PAY_DEFINED_BALANCES_PK) INDEX(ACT PAY_ASSIGNMENT_ACTIONS_PK) INDEX(VALUE PAY_BALANCE_CONTEXT_VALUES_PK) INDEX(PACT PAY_PAYROLL_ACTIONS_PK) USE_NL(PERBAL DEFBAL ACT PACT VALUE) +*/ PERBAL.defined_balance_id , DEFBAL.balance_dimension_id , to_char (PERBAL.value) , PERBAL.latest_balance_id , PERBAL.rowid , to_char(PERBAL.assignment_action_id) , ACT.payroll_action_id , to_char(PACT.effective_date, :b0) , to_number(to_char(PACT.effective_date, 'J')) , nvl(VALUE.context_id, 0) , nvl(VALUE.value, 'NULL') , to_char(PERBAL.expired_assignment_action_id) , to_char(PERBAL.expired_value) , to_char(PERBAL.prev_assignment_action_id) , to_char(PERBAL.prev_balance_value) from pay_person_latest_balances PERBAL , pay_defined_balances DEFBAL , pay_assignment_actions ACT , pay_payroll_actions PACT , pay_balance_context_values VALUE where ((((PERBAL.person_id=:b3 and ACT.assignment_action_id=PERBAL.assignment_action_id) and PACT.payroll_action_id=ACT.payroll_action_id) and DEFBAL.defined_balance_id=PERBAL.defined_balance_id) and VALUE.latest_balance_id(+)=PERBAL.latest_balance_id) order by 6, 2, 1, 4, 10 desc
66tmsr3446uqn SELECT WIAS.ACTIVITY_STATUS, WIAS.ACTIVITY_RESULT_CODE, WIAS.ASSIGNED_USER, WIAS.NOTIFICATION_ID, WIAS.BEGIN_DATE, WIAS.END_DATE, WIAS.DUE_DATE, WIAS.ERROR_NAME, WIAS.ERROR_MESSAGE, WIAS.ERROR_STACK FROM WF_ITEM_ACTIVITY_STATUSES WIAS WHERE WIAS.ITEM_TYPE = :B3 AND WIAS.ITEM_KEY = :B2 AND WIAS.PROCESS_ACTIVITY = :B1
6gnth2mfbs2nq declare v_ret number := 0; begin if (INV_TABLE_LOCK_PVT.lock_onhand_records(:1, :2, :3, :4, :5, :6, :7) ) then v_ret := 1; end if; :8 := v_ret; end;
6h2tpcxpymqu7 BEGIN :1 := FND_AOLJ_UTIL.is_Valid_ICX(:2, NULL, 'Y', TRUE, TRUE, NULL, NULL, NULL, NULL, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, TRUE);:19 := fnd_session_management.g_enc_key;:20 := fnd_session_management.g_mac_key;END;
76sw2a4vnc89j begin FND_FLEX_WORKFLOW_APIS.START_GENERATION (:v1, :v2, :v3, :v4, :v5); end;
7g05xfvc5vp74 BEGIN arp_run.revenue_recognition( :errbuf, :rc, :A0, :A1, :A2); 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;
9hypmc3t618sc SELECT ORDERED_ITEM, ORDERED_QUANTITY, ORDER_QUANTITY_UOM, ORDERED_QUANTITY2, ORDERED_QUANTITY_UOM2, PREFERRED_GRADE, LINE_NUMBER, COMPONENT_NUMBER, REQUEST_DATE, SCHEDULE_SHIP_DATE, LINE_TYPE, CANCELLED_QUANTITY, SHIPPED_QUANTITY, PROMISE_DATE, PRICING_QUANTITY, PRICING_QUANTITY_UOM, SHIP_FROM, SOLD_TO, CUSTOMER_NUMBER, CUST_PO_NUMBER, CUSTOMER_LINE_NUMBER, CUSTOMER_SHIPMENT_NUMBER, DEMAND_BUCKET_TYPE_CODE, RLA_SCHEDULE_TYPE_CODE, CUSTOMER_DOCK_CODE, CUST_MODEL_SERIAL_NUMBER, CUSTOMER_PRODUCTION_LINE, CUST_PRODUCTION_SEQ_NUM, CUSTOMER_JOB, END_ITEM_UNIT_NUMBER, TAX_CODE, BLANKET_NUMBER, BLANKET_LINE_NUMBER, BLANKET_VERSION_NUMBER, PRICE_LIST, PRICING_DATE, SHIPMENT_NUMBER, TERMS, UNIT_LIST_PRICE, ORIGINAL_LIST_PRICE, ITEM_TYPE_CODE, OPTION_NUMBER, VISIBLE_DEMAND_FLAG, SCHEDULE_ARRIVAL_DATE, PLANNING_PRIORITY, ORIGINAL_ORDERED_ITEM, ORIGINAL_INVENTORY_ITEM_ID, ORIGINAL_ORDERED_ITEM_ID, item_relationship_type, LATE_DEMAND_PENALTY_FACTOR, ORIGINAL_ITEM_IDENTIFIER_TYPE, ITEM_SUBSTITUTION_TYPE_CODE, OVERRIDE_ATP_DATE_CODE, FIRM_DEMAND_FLAG, ITEM_IDENTIFIER_TYPE, UNIT_SELLING_PRICE, UNIT_COST, CUSTOMER_ITEM_NET_PRICE, CUSTOMER_PAYMENT_TERM_ID, CALCULATE_PRICE_FLAG, TAX_EXEMPT_NUMBER, TAX_DATE, TAX_VALUE, TAX_POINT_CODE, ACCOUNTING_RULE, ACCOUNTING_RULE_DURATION, INVOICING_RULE, SUBINVENTORY, FULFILLED_QUANTITY, INVOICED_QUANTITY, SHIPPING_INSTRUCTIONS, PACKING_INSTRUCTIONS, USER_ITEM_DESCRIPTION, SHIP_FROM_LOCATION, SHIP_TO, SHIP_TO_LOCATION, SHIP_TO_CONTACT, SHIP_TO_ADDRESS1, SHI P_TO_ADDRESS2, SHIP_TO_ADDRESS3, SHIP_TO_ADDRESS4, SHIP_TO_ADDRESS5, SHIPPING_QUANTITY_UOM, SHIPPING_QUANTITY, DELIVERY_LEAD_TIME, INVOICE_TO, INVOICE_TO_LOCATION, INVOICE_TO_CONTACT, INVOICE_TO_ADDRESS1, INVOICE_TO_ADDRESS2, INVOICE_TO_ADDRESS3, INVOICE_TO_ADDRESS4, INVOICE_TO_ADDRESS5, ITEM_REVISION, ROUNDING_FACTOR, SPLIT_BY, SHIP_TOLERANCE_ABOVE, SHIP_TOLERANCE_BELOW, ORDER_NUMBER, VERSION_NUMBER, ORDER_TYPE, ORDERED_DATE, OVER_SHIP_REASON, first_ack_code, FIRST_ACK_DATE, last_ack_code, LAST_ACK_DATE, SERVICE_TXN_REASON_CODE, SERVICE_TXN_COMMENTS, SERVICE_COTERMINATE_FLAG, SERVICE_DURATION, SERVICE_PERIOD, SERVICE_START_DATE, SERVICE_END_DATE, UNIT_SELLING_PERCENT, SERVICE_NUMBER, SERVICE_REFERENCE_TYPE_CODE, UNIT_LIST_PERCENT, UNIT_PERCENT_BASE_PRICE, END_CUSTOMER_SITE_USE_ID, END_CUSTOMER_CONTACT_ID, END_CUSTOMER_ID, IB_OWNER, IB_INSTALLED_AT_LOCATION, IB_CURRENT_LOCATION, EARLIEST_ACCEPTABLE_DATE, LATEST_ACCEPTABLE_DATE, ACTUAL_SHIPMENT_DATE, OVER_SHIP_RESOLVED_FLAG, ACTUAL_ARRIVAL_DATE, DEP_PLAN_REQUIRED_FLAG, AUTHORIZED_TO_SHIP_FLAG, COMMITMENT_ID, LOCK_CONTROL, ORDER_SOURCE_ID, TAX_EXEMPT_REASON_CODE, FULFILLED_FLAG, FULFILLMENT_METHOD_CODE, TAX_EXEMPT_FLAG, TAX_RATE, FREIGHT_TERMS_CODE, SHIPMENT_PRIORITY_CODE, SHIPPING_METHOD_CODE, FOB_POINT_CODE, INVOICE_INTERFACE_STATUS_CODE, SHIP_MODEL_COMPLETE_FLAG, SOURCE_DOCUMENT_TYPE_ID, SOURCE_DOCUMENT_ID, SOURCE_DOCUMENT_LINE_ID, ROW_ID, HEADER_ROW_ID, REFERENCE_HEADER_ID, REFERENCE_LINE_ID, REFERENCE_CUSTOMER_TRX_LINE_ID, CREDIT_INVOICE_LINE_ID, LINE_ID, ORG_ID, HEADER_ID, LINE_TYPE_ID, LINE_SET_ID, CONFIG_HEADER_ID, CONFIG_REV_NBR, SHIP_FROM_ORG_ID, SHIP_TO_ORG_ID, DELIVER_TO_ORG_ID, INTMED_SHIP_TO_ORG_ID, INVOICE_TO_ORG_ID, SOLD_FROM_ORG_ID, SHIP_TO_CONTACT_ID, DELIVER_TO_CONTACT_ID, INTMED_SHIP_TO_CONTACT_ID, INVOICE_TO_CONTACT_ID, INVENTORY_ITEM_ID, SERVICE_REFERENCE_LINE_ID, SERVICE_REFERENCE_SYSTEM_ID, PRICE_LIST_ID, AGREEMENT_ID, PAYMENT_TERM_ID, INVOICING_RULE_ID, ACCOUNTING_RULE_ID, SPLIT_FROM_LINE_ID, VEH_CUS_ITEM_CUM_KEY_ID, SALESREP_ID, RETURN_REASON_CODE, ARRIVAL_SET_ID, SHIP_SET_ID, ORDERED_ITEM_ID, OVER_SHIP_REASON_CODE, CONTEXT, SCHEDULE_STATUS_CODE, FLOW_STATUS_CODE, SOURCE_TYPE_CODE, DEMAND_CLASS_CODE, TRANSACTION_PHASE_CODE, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, ATTRIBUTE16, ATTRIBUTE17, ATTRIBUTE18, ATTRIBUTE19, ATTRIBUTE20, GLOBAL_ATTRIBUTE_CATEGORY, GLOBAL_ATTRIBUTE1, 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, INDUSTRY_CONTEXT, INDUSTRY_ATTRIBUTE1, INDUSTRY_ATTRIBUTE2, INDUSTRY_ATTRIBUTE3, INDUSTRY_ATTR IBUTE4, INDUSTRY_ATTRIBUTE5, INDUSTRY_ATTRIBUTE6, INDUSTRY_ATTRIBUTE7, INDUSTRY_ATTRIBUTE8, INDUSTRY_ATTRIBUTE9, INDUSTRY_ATTRIBUTE10, INDUSTRY_ATTRIBUTE11, INDUSTRY_ATTRIBUTE13, INDUSTRY_ATTRIBUTE12, 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, RETURN_CONTEXT, RETURN_ATTRIBUTE1, RETURN_ATTRIBUTE2, RETURN_ATTRIBUTE3, RETURN_ATTRIBUTE4, RETURN_ATTRIBUTE5, RETURN_ATTRIBUTE6, RETURN_ATTRIBUTE7, RETURN_ATTRIBUTE8, RETURN_ATTRIBUTE9, RETURN_ATTRIBUTE10, RETURN_ATTRIBUTE11, RETURN_ATTRIBUTE12, RETURN_ATTRIBUTE13, RETURN_ATTRIBUTE14, RETURN_ATTRIBUTE15, 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, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, REQUEST_ID, COMPONENT_SEQUENCE_ID, CONFIGURATION_ID, TOP_MODEL_LINE_ID, LINK_TO_LINE_ID, CONFIG_DISPLAY_SEQUENCE, COMPONENT_CODE, SORT_ORDER, SOLD_TO_ORG_ID, FREIGHT_CARRIER_CODE, PROJECT_ID, TASK_ID, LINE_CATEGORY_CODE, MODEL_REMNANT_FL AG, CUSTOMER_TRX_LINE_ID, OPTION_FLAG, BOOKED_FLAG, OPEN_FLAG, CANCELLED_FLAG, ORIG_SYS_DOCUMENT_REF, ORIG_SYS_LINE_REF, ORIG_SYS_SHIPMENT_REF, SHIPPING_INTERFACED_FLAG, ATO_LINE_ID, AUTO_SELECTED_QUANTITY, EXPLOSION_DATE, MODEL_GROUP_NUMBER FROM OE_ORDER_LINES_V WHERE (HEADER_ID=:1) order by line_number, shipment_number, nvl(option_number, -1), nvl(component_number, -1), nvl(service_number, -1)
9wdrypwkpf607 begin OE_FULFILL_WF.START_FULFILLMENT (:v1, :v2, :v3, :v4, :v5); end;
a29grr748ghc4 BEGIN jdr_custom_internal.getActiveLayers(:1, :2, :3, :4, :5); END;
avc1jqzz04wpr SELECT 'x' FROM DUAL
bf7uwg5pa3pj6 begin FND_FLEX_WORKFLOW_APIS.VALIDATE_COMBINATION (:v1, :v2, :v3, :v4, :v5); end;
bt0w082dfrm8v BEGIN WSH_SHIP_CONFIRM_ACTIONS.interface_ALL_wrp( :errbuf, :rc, :A0, :A1, :A2, :A3); END;
cd9mbmqyf4qhp UPDATE WF_ITEM_ACTIVITY_STATUSES SET ACTIVITY_STATUS = :B8 , ACTIVITY_RESULT_CODE = NVL(:B13 , ACTIVITY_RESULT_CODE), BEGIN_DATE = NVL(:B11 , BEGIN_DATE), END_DATE = NVL(:B12 , END_DATE), DUE_DATE = DECODE(:B11 , TO_DATE(NULL), DUE_DATE, :B10 ), OUTBOUND_QUEUE_ID = :B9 , EXECUTION_TIME = DECODE(:B8 , :B7 , :B4 , :B6 , NVL(EXECUTION_TIME, :B4 ), :B5 , NVL(EXECUTION_TIME, :B4 ), EXECUTION_TIME) WHERE ITEM_TYPE = :B3 AND ITEM_KEY = :B2 AND PROCESS_ACTIVITY = :B1
csvvv0fmhr1yc BEGIN FFP1893_01010001.FORMULA( :N1, :N4, :T1, :I1, :D1, :T2, :I2, :T7, :I7, :T8, :I8, :T5, :I5, :N3, :T4, :I4, :N2, :N5, :T3, :I3, :T6, :I6, :FFERLN, :FFERCD, :FFERMT); END;
cwyx16zn1hpfb select parameter, value from nls_session_parameters
dcvv68fju01g4 begin FND_FLEX_WORKFLOW_APIS.END_GENERATION (:v1, :v2, :v3, :v4, :v5); end;
dk0sqcvc2xjvs BEGIN ASO_QUOTE_PUB_W.Create_Qte_Opportunity(:1, :2, :3, :4, :5, :6, p_c_auto_version_flag => :7, p_c_pricing_request_type => :8, p_c_header_pricing_event => :9, p_c_cal_tax_flag => :10, p_c_cal_freight_charge_flag => :11, p_c_copy_task_flag => :12, p_c_copy_notes_flag => :13, p_c_copy_att_flag => :14, p_c_deactivate_all => :15, p_c_price_mode => :16, p_source_code => :17, p_op_opportunity_id => :18, p_op_quote_name => :19, p_op_cust_account_id => :20, p_op_resource_id => :21, p_op_sold_to_contact_id => :22, p_op_sold_to_party_site_id => :23, p_op_price_list_id => :24, p_op_resource_grp_id => :25, p_op_channel_code => :26, p_op_order_type_id => :27, p_op_agreement_id => :28, p_op_currency_code => :29, p_op_marketing_source_code_id => :30, p_op_quote_expiration_date => :31, p_op_cust_party_id => :32, p_op_pricing_status_indicator => :33, p_op_tax_status_indicator => :34, x_return_status => :35, x_msg_count => :36, x_msg_data => :37 ); END;
fb13x9qx0ftks begin OE_STANDARD_WF.OEOL_SELECTOR (:v1, :v2, :v3, :v4, :v5); end;
fmfdkztk8vx23 SELECT CATEGORY, SEVERITY, FND_LOG_SEVERITY FROM FND_NEW_MESSAGES WHERE MESSAGE_NAME = :B1 AND APPLICATION_ID = :B2 AND LANGUAGE_CODE = :B3 AND ROWNUM = 1
g8102j8yynbwz begin WF_STANDARD.CONTINUEFLOW (:v1, :v2, :v3, :v4, :v5); end;
gf1u933c95jb5 DECLARE l_ret_stat varchar2(56); BEGIN CSI_INV_TXN_HOOK_PKG.postTransaction( p_header_id => :1 , p_transaction_id => :2 , x_return_status => l_ret_stat ); INV_TXNSTUB_PUB.g_ret_status := l_ret_stat; END;
gksvm8wmzk8w0 begin OE_INVOICE_WF.INVOICE_INTERFACE (:v1, :v2, :v3, :v4, :v5); end;

Back to SQL Statistics
Back to Top

 

Instance Activity Statistics

Back to Top

Instance Activity Stats

Statistic Total per Second per Trans
CPU used by this session 2,596,908 720.25 2.08
CPU used when call started 2,590,774 718.55 2.07
CR blocks created 16,828,138 4,667.26 13.46
Cached Commit SCN referenced 48,138 13.35 0.04
Commit SCN cached 8 0.00 0.00
DB time 5,577,812 1,547.00 4.46
DBWR checkpoint buffers written 3,177,636 881.31 2.54
DBWR checkpoints 34 0.01 0.00
DBWR object drop buffers written 54,745 15.18 0.04
DBWR revisited being-written buffer 278 0.08 0.00
DBWR thread checkpoint buffers written 439,856 121.99 0.35
DBWR transaction table writes 2,741 0.76 0.00
DBWR undo block writes 1,628,683 451.71 1.30
DFO trees parallelized 48 0.01 0.00
IMU CR rollbacks 42,934,818 11,907.91 34.34
IMU Flushes 367,146 101.83 0.29
IMU Redo allocation size 2,413,995,392 669,518.01 1,930.81
IMU commits 639,451 177.35 0.51
IMU contention 47,048 13.05 0.04
IMU ktichg flush 11,455 3.18 0.01
IMU pool not allocated 0 0.00 0.00
IMU recursive-transaction flush 1,756 0.49 0.00
IMU undo allocation size 5,766,829,344 1,599,421.49 4,612.55
IMU- failed to get a private strand 0 0.00 0.00
PX local messages recv'd 53,258 14.77 0.04
PX local messages sent 53,258 14.77 0.04
Parallel operations downgraded 25 to 50 pct 40 0.01 0.00
Parallel operations not downgraded 8 0.00 0.00
SQL*Net roundtrips to/from client 52,094,933 14,448.45 41.67
active txn count during cleanout 129,763,784 35,989.79 103.79
application wait time 21,537 5.97 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,069 0.30 0.00
buffer is not pinned count 623,480,812 172,921.47 498.69
buffer is pinned count 1,611,223,966 446,870.56 1,288.72
bytes received via SQL*Net from client 11,407,648,542 3,163,894.26 9,124.31
bytes sent via SQL*Net to client 10,341,738,403 2,868,265.67 8,271.75
calls to get snapshot scn: kcmgss 117,577,198 32,609.86 94.04
calls to kcmgas 20,953,537 5,811.43 16.76
calls to kcmgcs 15,999,347 4,437.39 12.80
change write time 67,117 18.61 0.05
cleanout - number of ktugct calls 31,190,633 8,650.68 24.95
cleanouts and rollbacks - consistent read gets 14,667,284 4,067.95 11.73
cleanouts only - consistent read gets 165,004 45.76 0.13
cluster key scan block gets 873,491 242.26 0.70
cluster key scans 238,986 66.28 0.19
commit batch/immediate performed 4,862 1.35 0.00
commit batch/immediate requested 4,862 1.35 0.00
commit cleanout failures: block lost 260,459 72.24 0.21
commit cleanout failures: buffer being written 3,766 1.04 0.00
commit cleanout failures: callback failure 112,582 31.22 0.09
commit cleanout failures: cannot pin 36,673 10.17 0.03
commit cleanouts 9,683,651 2,685.75 7.75
commit cleanouts successfully completed 9,270,171 2,571.07 7.41
commit immediate performed 4,862 1.35 0.00
commit immediate requested 4,862 1.35 0.00
commit txn count during cleanout 1,424,695 395.14 1.14
concurrency wait time 18,934 5.25 0.02
consistent changes 729,501,579 202,326.17 583.49
consistent gets 1,827,270,805 506,790.82 1,461.53
consistent gets - examination 1,253,422,486 347,634.85 1,002.54
consistent gets from cache 1,827,270,332 506,790.69 1,461.53
cursor authentications 2,119 0.59 0.00
data blocks consistent reads - undo records applied 725,060,081 201,094.33 579.93
db block changes 201,616,106 55,917.93 161.26
db block gets 230,548,442 63,942.27 184.40
db block gets direct 4,341 1.20 0.00
db block gets from cache 230,544,104 63,941.06 184.40
deferred (CURRENT) block cleanout applications 1,662,681 461.14 1.33
dirty buffers inspected 10,515 2.92 0.01
doubling up with imu segment 0 0.00 0.00
enqueue conversions 10,429 2.89 0.01
enqueue releases 4,697,621 1,302.88 3.76
enqueue requests 4,704,879 1,304.89 3.76
enqueue timeouts 7,145 1.98 0.01
enqueue waits 41,901 11.62 0.03
exchange deadlocks 60,025 16.65 0.05
execute count 104,993,440 29,119.77 83.98
failed probes on index block reclamation 8,037 2.23 0.01
frame signature mismatch 2 0.00 0.00
free buffer inspected 3,294,412 913.70 2.64
free buffer requested 21,399,537 5,935.13 17.12
heap block compress 28,635,614 7,942.04 22.90
hot buffers moved to head of LRU 1,372,306 380.61 1.10
immediate (CR) block cleanout applications 14,832,306 4,113.72 11.86
immediate (CURRENT) block cleanout applications 1,155,120 320.37 0.92
index crx upgrade (found) 149,329 41.42 0.12
index crx upgrade (positioned) 10,540,373 2,923.36 8.43
index fast full scans (rowid ranges) 824 0.23 0.00
index fetch by key 191,268,110 53,047.92 152.98
index scans kdiixs1 163,078,949 45,229.70 130.44
java call heap collected bytes 1,548,662,120 429,519.12 1,238.68
java call heap collected count 19,044,297 5,281.91 15.23
java call heap gc count 4,838 1.34 0.00
java call heap live object count 1,590,320 441.07 1.27
java call heap live object count max 1,595,344 442.47 1.28
java call heap live size 462,248,992 128,204.07 369.73
java call heap live size max 463,290,936 128,493.05 370.56
java call heap object count 3,929,752 1,089.91 3.14
java call heap object count max 3,936,446 1,091.77 3.15
java call heap total size 619,053,056 171,693.44 495.14
java call heap total size max 620,104,704 171,985.11 495.99
java call heap used size 613,070,952 170,034.31 490.36
java call heap used size max 614,302,680 170,375.93 491.34
leaf node 90-10 splits 20,606 5.72 0.02
leaf node splits 249,207 69.12 0.20
lob reads 23,724 6.58 0.02
lob writes 41,270 11.45 0.03
lob writes unaligned 41,270 11.45 0.03
logons cumulative 10,192 2.83 0.01
messages received 1,863,237 516.77 1.49
messages sent 1,863,237 516.77 1.49
no buffer to keep pinned count 16 0.00 0.00
no work - consistent read gets 522,574,659 144,935.30 417.98
opened cursors cumulative 6,015,614 1,668.42 4.81
parse count (failures) 3,604 1.00 0.00
parse count (hard) 9,396 2.61 0.01
parse count (total) 9,243,122 2,563.57 7.39
parse time cpu 64,439 17.87 0.05
parse time elapsed 70,840 19.65 0.06
physical read IO requests 300,746 83.41 0.24
physical read bytes 3,743,948,800 1,038,378.60 2,994.56
physical read total IO requests 330,020 91.53 0.26
physical read total bytes 4,222,672,896 1,171,152.01 3,377.47
physical read total multi block requests 13,034 3.61 0.01
physical reads 457,024 126.75 0.37
physical reads cache 456,106 126.50 0.36
physical reads cache prefetch 156,099 43.29 0.12
physical reads direct 918 0.25 0.00
physical reads direct temporary tablespace 186 0.05 0.00
physical reads prefetch warmup 86,863 24.09 0.07
physical write IO requests 2,083,904 577.97 1.67
physical write bytes 26,752,385,024 7,419,733.96 21,397.66
physical write total IO requests 3,492,936 968.76 2.79
physical write total bytes 60,660,584,960 16,824,122.49 48,518.84
physical write total multi block requests 1,586,282 439.95 1.27
physical writes 3,265,672 905.73 2.61
physical writes direct 4,860 1.35 0.00
physical writes direct (lob) 226 0.06 0.00
physical writes direct temporary tablespace 4,225 1.17 0.00
physical writes from cache 3,260,812 904.38 2.61
physical writes non checkpoint 2,386,743 661.96 1.91
pinned buffers inspected 3,212 0.89 0.00
prefetch warmup blocks aged out before use 250,654 69.52 0.20
prefetched blocks aged out before use 121 0.03 0.00
process last non-idle time 3,607 1.00 0.00
queries parallelized 48 0.01 0.00
recursive aborts on index block reclamation 1 0.00 0.00
recursive calls 169,703,452 47,067.00 135.74
recursive cpu usage 1,462,282 405.56 1.17
redo blocks written 66,059,858 18,321.60 52.84
redo buffer allocation retries 482 0.13 0.00
redo entries 103,670,387 28,752.83 82.92
redo log space requests 0 0.00 0.00
redo log space wait time 0 0.00 0.00
redo ordering marks 1,220,560 338.52 0.98
redo size 32,352,688,232 8,972,969.68 25,877.02
redo subscn max counts 2,427,931 673.38 1.94
redo synch time 83,685 23.21 0.07
redo synch writes 2,430,027 673.96 1.94
redo wastage 364,176,136 101,003.71 291.28
redo write time 51,906 14.40 0.04
redo writer latching time 153 0.04 0.00
redo writes 895,471 248.36 0.72
rollback changes - undo records applied 252,092 69.92 0.20
rollbacks only - consistent read gets 2,406,721 667.50 1.92
rows fetched via callback 101,674,318 28,199.22 81.32
session connect time 0 0.00 0.00
session cursor cache hits 5,775,393 1,601.80 4.62
session logical reads 2,057,823,471 570,734.26 1,645.93
session pga memory 10,737,139,224 2,977,929.50 8,588.01
session pga memory max 12,053,395,672 3,342,991.26 9,640.80
session uga memory ############### 75,197,719.09 216,861.61
session uga memory max 74,834,750,408 20,755,306.07 59,855.92
shared hash latch upgrades - no wait 33,104,259 9,181.42 26.48
shared hash latch upgrades - wait 245,539 68.10 0.20
sorts (memory) 11,033,348 3,060.08 8.82
sorts (rows) 135,688,498 37,633.00 108.53
sql area evicted 2,896 0.80 0.00
sql area purged 3,774 1.05 0.00
summed dirty queue length 96,034 26.63 0.08
switch current to new buffer 1,415,351 392.55 1.13
table fetch by rowid 950,236,162 263,546.58 760.04
table fetch continued row 32,931,182 9,133.41 26.34
table scan blocks gotten 74,689,717 20,715.08 59.74
table scan rows gotten 2,310,542,629 640,825.54 1,848.07
table scans (long tables) 2,050 0.57 0.00
table scans (rowid ranges) 2,048 0.57 0.00
table scans (short tables) 6,176,183 1,712.96 4.94
total number of times SMON posted 176,663 49.00 0.14
transaction rollbacks 4,862 1.35 0.00
transaction tables consistent read rollbacks 90 0.02 0.00
transaction tables consistent reads - undo records applied 3,130 0.87 0.00
undo change vector size 11,319,410,292 3,139,421.51 9,053.73
user I/O wait time 137,082 38.02 0.11
user calls 49,740,735 13,795.52 39.78
user commits 984,965 273.18 0.79
user rollbacks 265,283 73.58 0.21
workarea executions - onepass 2 0.00 0.00
workarea executions - optimal 6,521,242 1,808.66 5.22
write clones created in background 1,846 0.51 0.00
write clones created in foreground 16,080 4.46 0.01

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistic Begin Value End Value
session cursor cache count 540,169 1,257,636
opened cursors current 1,100,832 1,237,063
workarea memory allocated 2,891 845
logons current 5,268 5,301

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 37 0 8.65 1.00 981,601 272 356,076 0.02
APPS_TS_TX_DATA 179,572 50 4.46 1.33 252,518 70 172,430 0.18
APPS_TS_TX_IDX 95,490 26 4.45 1.30 251,170 70 113,623 0.22
APPS_ASSM_DATA 8,867 2 2.27 6.47 308,408 86 50,059 0.29
APPS_ASSM_IDX 6,796 2 2.40 1.03 205,924 57 340,890 0.09
APPS_TS_TX_INTERFACE 1,172 0 2.61 2.12 44,084 12 22,635 0.03
TEMP 508 0 4.29 9.21 10,633 3 54 16.67
APPS_TS_SUMMARY 57 0 7.72 1.00 9,158 3 3,648 0.01
SYSTEM 5,245 1 3.67 3.58 3,114 1 42,288 0.08
APPS_TS_SEED 2,055 1 6.27 1.36 6,021 2 940 2.65
APPS_TS_QUEUES 344 0 5.96 2.51 5,929 2 1,022 0.15
APPS_TS_ARCHIVE 61 0 6.89 1.44 2,800 1 170 7.35
SYSAUX 291 0 2.20 1.14 1,695 0 9 0.00
APPS_TS_NOLOGGING 25 0 9.20 1.56 49 0 0 0.00
CTXSYS 24 0 7.08 1.00 6 0 0 0.00
APPS_TS_MEDIA 12 0 10.83 1.00 9 0 0 0.00
ODM 12 0 5.00 1.00 3 0 0 0.00
OLAP 12 0 6.67 1.00 3 0 0 0.00
OWAPUB 12 0 5.83 1.00 3 0 0 0.00
PORTAL 12 0 10.00 1.00 3 0 0 0.00
SYNCSERVER 12 0 12.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,867 2 2.27 6.47 308,408 86 50,059 0.29
APPS_ASSM_IDX /DB/visdata/apps_assm_idx.dbf 6,796 2 2.40 1.03 205,924 57 340,890 0.09
APPS_TS_ARCHIVE /DB/visdata/archive1.dbf 32 0 9.06 1.50 2,514 1 166 2.53
APPS_TS_ARCHIVE /DB/visdata/archive2.dbf 29 0 4.48 1.38 286 0 4 207.50
APPS_TS_MEDIA /DB/visdata/media1.dbf 4 0 7.50 1.00 3 0 0 0.00
APPS_TS_MEDIA /DB/visdata/media2.dbf 4 0 15.00 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 6.00 1.00 35 0 0 0.00
APPS_TS_NOLOGGING /DB/visdata/nologging3.dbf 6 0 15.00 3.33 11 0 0 0.00
APPS_TS_QUEUES /DB/visdata/queues1.dbf 34 0 5.29 2.71 824 0 433 0.14
APPS_TS_QUEUES /DB/visdata/queues2.dbf 27 0 4.81 3.56 1,009 0 355 0.14
APPS_TS_QUEUES /DB/visdata/queues3.dbf 33 0 9.70 4.06 872 0 8 0.00
APPS_TS_QUEUES /DB/visdata/queues4.dbf 40 0 5.00 2.58 863 0 8 0.00
APPS_TS_QUEUES /DB/visdata/queues5.dbf 40 0 7.25 3.03 647 0 7 0.00
APPS_TS_QUEUES /DB/visdata/queues6.dbf 33 0 7.58 2.52 701 0 9 0.00
APPS_TS_QUEUES /DB/visdata/queues7.dbf 137 0 4.96 1.70 1,013 0 202 0.20
APPS_TS_SEED /DB/visdata/reference1.dbf 176 0 6.53 1.36 535 0 44 1.59
APPS_TS_SEED /DB/visdata/reference10.dbf 169 0 7.46 1.26 584 0 61 5.57
APPS_TS_SEED /DB/visdata/reference2.dbf 189 0 7.04 1.33 619 0 43 5.81
APPS_TS_SEED /DB/visdata/reference3.dbf 317 0 5.33 1.38 674 0 459 1.96
APPS_TS_SEED /DB/visdata/reference4.dbf 205 0 6.73 1.37 658 0 35 1.43
APPS_TS_SEED /DB/visdata/reference5.dbf 238 0 5.97 1.28 604 0 81 3.58
APPS_TS_SEED /DB/visdata/reference6.dbf 226 0 6.37 1.48 668 0 43 3.26
APPS_TS_SEED /DB/visdata/reference7.dbf 206 0 7.18 1.30 525 0 31 2.26
APPS_TS_SEED /DB/visdata/reference8.dbf 171 0 5.15 1.46 546 0 50 5.00
APPS_TS_SEED /DB/visdata/reference9.dbf 158 0 5.44 1.32 608 0 93 1.40
APPS_TS_SUMMARY /DB/visdata/summary1.dbf 5 0 8.00 1.00 1,096 0 458 0.00
APPS_TS_SUMMARY /DB/visdata/summary2.dbf 5 0 8.00 1.00 953 0 299 0.00
APPS_TS_SUMMARY /DB/visdata/summary3.dbf 7 0 11.43 1.00 898 0 240 0.00
APPS_TS_SUMMARY /DB/visdata/summary4.dbf 12 0 5.83 1.00 1,052 0 308 0.00
APPS_TS_SUMMARY /DB/visdata/summary5.dbf 7 0 7.14 1.00 1,147 0 468 0.02
APPS_TS_SUMMARY /DB/visdata/summary6.dbf 7 0 8.57 1.00 1,418 0 750 0.00
APPS_TS_SUMMARY /DB/visdata/summary7.dbf 7 0 7.14 1.00 1,090 0 396 0.00
APPS_TS_SUMMARY /DB/visdata/summary8.dbf 7 0 7.14 1.00 1,504 0 729 0.04
APPS_TS_TX_DATA /DB/visdata/tx_data1.dbf 3,278 1 5.51 1.26 407 0 2 5.00
APPS_TS_TX_DATA /DB/visdata/tx_data10.dbf 3,257 1 5.07 1.26 284 0 1 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data11.dbf 3,263 1 4.68 1.30 257 0 0 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data12.dbf 13,326 4 3.26 1.23 4,659 1 3,900 1.75
APPS_TS_TX_DATA /DB/visdata/tx_data13.dbf 18,066 5 4.78 1.47 5,963 2 2,657 1.08
APPS_TS_TX_DATA /DB/visdata/tx_data14.dbf 13,347 4 4.11 1.35 36,180 10 22,885 0.14
APPS_TS_TX_DATA /DB/visdata/tx_data15.dbf 9,518 3 4.01 1.44 35,960 10 23,737 0.13
APPS_TS_TX_DATA /DB/visdata/tx_data16.dbf 9,548 3 4.06 1.42 34,440 10 21,913 0.13
APPS_TS_TX_DATA /DB/visdata/tx_data17.dbf 9,366 3 3.92 1.42 33,127 9 23,236 0.12
APPS_TS_TX_DATA /DB/visdata/tx_data18.dbf 9,497 3 4.12 1.39 31,728 9 24,409 0.13
APPS_TS_TX_DATA /DB/visdata/tx_data19.dbf 9,318 3 4.12 1.42 31,963 9 22,774 0.12
APPS_TS_TX_DATA /DB/visdata/tx_data2.dbf 6,822 2 3.69 1.17 1,383 0 2,306 0.63
APPS_TS_TX_DATA /DB/visdata/tx_data20.dbf 9,313 3 4.12 1.48 31,918 9 22,813 0.10
APPS_TS_TX_DATA /DB/visdata/tx_data21.dbf 24,026 7 5.00 1.28 1,182 0 1,765 0.03
APPS_TS_TX_DATA /DB/visdata/tx_data3.dbf 4,001 1 5.36 1.42 500 0 3 3.33
APPS_TS_TX_DATA /DB/visdata/tx_data4.dbf 17,099 5 5.01 1.09 354 0 2 5.00
APPS_TS_TX_DATA /DB/visdata/tx_data5.dbf 3,348 1 5.23 1.25 448 0 2 10.00
APPS_TS_TX_DATA /DB/visdata/tx_data6.dbf 3,324 1 5.17 1.26 265 0 2 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data7.dbf 3,280 1 5.15 1.29 593 0 7 1.43
APPS_TS_TX_DATA /DB/visdata/tx_data8.dbf 3,169 1 5.18 1.24 550 0 14 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data9.dbf 3,406 1 4.82 1.29 357 0 2 0.00
APPS_TS_TX_IDX /DB/visdata/tx_idx1.dbf 2,492 1 3.49 1.12 3,015 1 1,866 0.61
APPS_TS_TX_IDX /DB/visdata/tx_idx10.dbf 2,486 1 3.69 1.14 2,011 1 2,079 0.35
APPS_TS_TX_IDX /DB/visdata/tx_idx11.dbf 2,438 1 3.68 1.13 2,225 1 1,759 0.53
APPS_TS_TX_IDX /DB/visdata/tx_idx12.dbf 11,573 3 5.27 1.52 25,637 7 2,185 0.25
APPS_TS_TX_IDX /DB/visdata/tx_idx13.dbf 9,719 3 4.56 1.24 35,142 10 6,959 0.17
APPS_TS_TX_IDX /DB/visdata/tx_idx14.dbf 5,982 2 4.88 1.34 25,968 7 7,029 0.12
APPS_TS_TX_IDX /DB/visdata/tx_idx15.dbf 5,766 2 4.79 1.36 22,031 6 10,945 0.08
APPS_TS_TX_IDX /DB/visdata/tx_idx16.dbf 5,781 2 4.96 1.39 20,200 6 7,363 0.10
APPS_TS_TX_IDX /DB/visdata/tx_idx17.dbf 5,825 2 4.92 1.35 19,172 5 7,882 0.10
APPS_TS_TX_IDX /DB/visdata/tx_idx18.dbf 5,817 2 4.85 1.34 18,794 5 13,586 0.11
APPS_TS_TX_IDX /DB/visdata/tx_idx19.dbf 5,833 2 4.83 1.36 17,842 5 9,485 0.13
APPS_TS_TX_IDX /DB/visdata/tx_idx2.dbf 3,060 1 3.87 1.29 2,487 1 2,185 0.40
APPS_TS_TX_IDX /DB/visdata/tx_idx20.dbf 5,665 2 4.79 1.36 17,187 5 8,712 0.08
APPS_TS_TX_IDX /DB/visdata/tx_idx21.dbf 3,499 1 5.05 1.46 16,271 5 2,894 0.74
APPS_TS_TX_IDX /DB/visdata/tx_idx3.dbf 3,968 1 2.73 1.08 2,433 1 2,060 0.78
APPS_TS_TX_IDX /DB/visdata/tx_idx4.dbf 2,674 1 3.44 1.11 4,028 1 2,706 0.64
APPS_TS_TX_IDX /DB/visdata/tx_idx5.dbf 2,682 1 3.33 1.16 5,580 2 16,209 0.12
APPS_TS_TX_IDX /DB/visdata/tx_idx6.dbf 2,644 1 3.53 1.17 3,305 1 2,270 0.66
APPS_TS_TX_IDX /DB/visdata/tx_idx7.dbf 2,542 1 3.55 1.14 3,168 1 1,655 0.44
APPS_TS_TX_IDX /DB/visdata/tx_idx8.dbf 2,529 1 3.96 1.13 2,460 1 1,875 1.02
APPS_TS_TX_IDX /DB/visdata/tx_idx9.dbf 2,515 1 3.41 1.17 2,214 1 1,919 0.43
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte.dbf 66 0 6.21 3.32 6,859 2 3,560 0.03
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte2.dbf 310 0 2.61 2.04 8,813 2 3,840 0.04
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte3.dbf 266 0 2.18 1.94 7,561 2 4,588 0.02
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte4.dbf 148 0 1.96 2.43 7,275 2 3,865 0.02
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte5.dbf 161 0 3.23 2.20 6,848 2 3,779 0.03
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte6.dbf 221 0 2.04 1.85 6,728 2 3,003 0.02
APPS_UNDOTS1 /DB/visdata/undo01.dbf 6 0 10.00 1.00 97,496 27 37,257 0.02
APPS_UNDOTS1 /DB/visdata/undo02.dbf 3 0 10.00 1.00 97,353 27 38,896 0.03
APPS_UNDOTS1 /DB/visdata/undo03.dbf 4 0 10.00 1.00 101,729 28 42,712 0.03
APPS_UNDOTS1 /DB/visdata/undo04.dbf 4 0 10.00 1.00 101,290 28 32,321 0.02
APPS_UNDOTS1 /DB/visdata/undo05.dbf 3 0 3.33 1.00 102,604 28 35,114 0.02
APPS_UNDOTS1 /DB/visdata/undo06.dbf 3 0 6.67 1.00 100,693 28 41,574 0.03
APPS_UNDOTS1 /DB/visdata/undo07.dbf 3 0 13.33 1.00 94,026 26 33,928 0.02
APPS_UNDOTS1 /DB/visdata/undo08.dbf 3 0 6.67 1.00 94,348 26 31,793 0.02
APPS_UNDOTS1 /DB/visdata/undo09.dbf 3 0 13.33 1.00 93,632 26 31,816 0.02
APPS_UNDOTS1 /DB/visdata/undo10.dbf 5 0 4.00 1.00 98,430 27 30,665 0.02
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 5.00 1.00 3 0 0 0.00
OLAP /DB/visdata/olap.dbf 12 0 6.67 1.00 3 0 0 0.00
OWAPUB /DB/visdata/owa1.dbf 12 0 5.83 1.00 3 0 0 0.00
PORTAL /DB/visdata/portal.dbf 12 0 10.00 1.00 3 0 0 0.00
SYNCSERVER /DB/visdata/mobile01.dbf 12 0 12.50 1.00 3 0 0 0.00
SYSAUX /DB/visdata/sysaux01.dbf 16 0 5.63 2.31 770 0 7 0.00
SYSAUX /DB/visdata/sysaux02.dbf 275 0 2.00 1.07 925 0 2 0.00
SYSTEM /DB/visdata/sys1.dbf 567 0 3.53 3.94 110 0 138 1.38
SYSTEM /DB/visdata/sys2.dbf 579 0 3.42 4.07 211 0 200 0.20
SYSTEM /DB/visdata/sys3.dbf 689 0 2.89 3.52 295 0 57 0.00
SYSTEM /DB/visdata/sys4.dbf 646 0 2.86 3.62 290 0 38 2.11
SYSTEM /DB/visdata/sys5.dbf 860 0 4.13 2.99 751 0 3,831 0.13
SYSTEM /DB/visdata/sys6.dbf 565 0 4.62 4.19 94 0 14 0.00
SYSTEM /DB/visdata/sys7.dbf 451 0 4.63 4.31 225 0 193 0.16
SYSTEM /DB/visdata/sys8.dbf 391 0 3.68 3.19 620 0 37,603 0.07
SYSTEM /DB/visdata/sys9.dbf 497 0 3.54 2.58 518 0 214 0.14
TEMP /DB/visdata/temp1.dbf 103 0 4.08 1.00 2,407 1 15 3.33
TEMP /DB/visdata/temp2.dbf 88 0 5.57 1.00 2,692 1 7 7.14
TEMP /DB/visdata/temp3.dbf 152 0 3.82 5.38 2,516 1 8 26.25
TEMP /DB/visdata/temp4.dbf 165 0 4.18 22.23 3,018 1 24 24.58

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,172,942 100 2,049,259,240 456,117 3,260,812 0 0 1,104,060


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 103 48896 1186958 4592129 188743680 4592129  
E 180 107 53728 1200683 10234452 188743680 10234452  

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,025 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,282.39 0.86 0.00 100.00 0.00 1,048,576
E 20,480 1,280 55,048.71 0.20 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,868,709 5,868,709 0 0
64K 128K 11,754 11,754 0 0
128K 256K 1,160 1,160 0 0
256K 512K 1,110 1,110 0 0
512K 1024K 188,207 188,207 0 0
1M 2M 438,530 438,530 0 0
2M 4M 70 68 2 0
4M 8M 17 17 0 0
8M 16M 18 18 0 0
32M 64M 8 8 0 0
64M 128M 6 6 0 0
128M 256M 2 2 0 0

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

PGA Target Est (MB) Size Factr W/A MB Processed Estd Extra W/A MB Read/ Written to Disk Estd PGA Cache Hit % Estd PGA Overalloc Count
2,560 0.13 940,243.01 9,455.79 99.00 1,253
5,120 0.25 940,243.01 9,403.83 99.00 1,220
10,240 0.50 940,243.01 9,267.71 99.00 1,164
15,360 0.75 940,243.01 9,135.12 99.00 1,110
20,480 1.00 940,243.01 0.00 100.00 1,059
24,576 1.20 940,243.01 0.00 100.00 1,025
28,672 1.40 940,243.01 0.00 100.00 961
32,768 1.60 940,243.01 0.00 100.00 859
36,864 1.80 940,243.01 0.00 100.00 613
40,960 2.00 940,243.01 0.00 100.00 180
61,440 3.00 940,243.01 0.00 100.00 0
81,920 4.00 940,243.01 0.00 100.00 0
122,880 6.00 940,243.01 0.00 100.00 0
163,840 8.00 940,243.01 0.00 100.00 0

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

Shared Pool Size(M) SP Size Factr Est LC Size (M) Est LC Mem Obj Est LC Time Saved (s) Est LC Time Saved Factr Est LC Load Time (s) Est LC Load Time Factr Est LC Mem Obj Hits
1,920 0.69 331 13,835 2,566,922 1.00 3,273 2.13 200,159,558
2,208 0.79 594 17,405 2,568,109 1.00 2,086 1.36 200,244,338
2,496 0.90 879 21,004 2,568,564 1.00 1,631 1.06 200,277,876
2,784 1.00 1,163 25,260 2,568,659 1.00 1,536 1.00 200,285,251
3,072 1.10 1,389 33,016 2,568,670 1.00 1,525 0.99 200,286,211
3,360 1.21 1,439 34,194 2,568,670 1.00 1,525 0.99 200,286,316
3,648 1.31 1,486 34,850 2,568,670 1.00 1,525 0.99 200,286,351
3,936 1.41 1,502 35,709 2,568,670 1.00 1,525 0.99 200,286,353
4,224 1.52 1,502 35,709 2,568,670 1.00 1,525 0.99 200,286,353
4,512 1.62 1,502 35,709 2,568,670 1.00 1,525 0.99 200,286,353
4,800 1.72 1,502 35,709 2,568,670 1.00 1,525 0.99 200,286,353
5,088 1.83 1,502 35,709 2,568,670 1.00 1,525 0.99 200,286,353
5,376 1.93 1,502 35,709 2,568,670 1.00 1,525 0.99 200,286,353
5,664 2.03 1,502 35,709 2,568,670 1.00 1,525 0.99 200,286,353

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 37,559  
10,240 0.50 37,560  
15,360 0.75 37,560  
20,480 1.00 37,559  
25,600 1.25 37,565  
30,720 1.50 37,565  
35,840 1.75 37,565  
40,960 2.00 37,566  

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
32 0.33 14 325 576 1.00 1,537 1.00 25,116
48 0.50 15 331 576 1.00 1,537 1.00 25,116
64 0.67 15 331 576 1.00 1,537 1.00 25,116
80 0.83 15 331 576 1.00 1,537 1.00 25,116
96 1.00 15 331 576 1.00 1,537 1.00 25,116
112 1.17 15 331 576 1.00 1,537 1.00 25,116
128 1.33 15 331 576 1.00 1,537 1.00 25,116
144 1.50 15 331 576 1.00 1,537 1.00 25,116
160 1.67 15 331 576 1.00 1,537 1.00 25,116
176 1.83 15 331 576 1.00 1,537 1.00 25,116
192 2.00 15 331 576 1.00 1,537 1.00 25,116
208 2.17 15 331 576 1.00 1,537 1.00 25,116

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 735,405 107 0
undo block 289,066 6 0
undo header 67,020 3 0
file header block 88 1 10
segment header 3,516 0 0
1st level bmb 8,230 0 0
2nd level bmb 599 0 0
extent map 13 0 0
bitmap index block 2 0 0

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason) Requests Succ Gets Failed Gets Waits Wt Time (s) Av Wt Time(ms)
TX-Transaction (row lock contention) 6,137 386 5,751 361 162 447.37
UL-User-defined 69,496 68,445 1,051 2,307 36 15.50
TX-Transaction (index contention) 32,447 32,447 0 29,851 14 0.46
RO-Multiple Object Reuse (fast object reuse) 288 288 0 32 12 373.13
HW-Segment High Water Mark 280,534 280,526 9 2,809 2 0.72
TX-Transaction 1,340,496 1,341,054 0 2,200 1 0.66
SQ-Sequence Cache 43,669 43,669 0 3,292 1 0.29
DV-Diana Versioning 32,321 32,322 0 212 1 3.68
TX-Transaction (allocate ITL entry) 263 263 0 173 0 1.21
FB-Format Block 37,213 37,214 0 643 0 0.23
TM-DML 2,174,892 2,174,813 14 1 0 150.00
CU-Cursor 9,220 9,219 0 3 0 3.33
PS-PX Process Reservation 1,864 1,542 320 22 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,630.46 1,344,342 2,638 384   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
16-Aug 09:19 135,326 160,344 468 383 204 0/0 0/0/0/0/0/0
16-Aug 09:09 153,560 164,215 760 379 201 0/0 0/0/0/0/0/0
16-Aug 08:59 231,517 167,181 619 375 199 0/0 0/0/0/0/0/0
16-Aug 08:49 461,601 240,284 450 377 208 0/0 0/0/0/0/0/0
16-Aug 08:39 269,247 234,873 2,638 380 283 0/0 0/0/0/0/0/0
16-Aug 08:29 379,209 377,445 2,033 384 358 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,465 0.00   0 0  
AWR Alerted Metric Element list 336,053 0.00   0 0  
Consistent RBA 895,910 0.02 0.07 0 0  
FOB s.o list latch 54,400 0.03 0.00 0 0  
In memory undo latch 707,960,200 3.47 0.00 17 1,278,615 0.00
JOX SGA heap latch 1,947,738 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,517 0.00   0 0  
KMG resize request state object freelist 20 0.00   0 0  
KTF sga latch 11 0.00   0 1,213 0.00
KWQMN job cache list latch 14,382 0.45 0.66 0 0  
MQL Tracking Latch 0     0 72 0.00
Memory Management Latch 1,506 0.00   0 2,506 0.00
OS process 15,276 0.00   0 0  
OS process allocation 11,423 0.01 0.00 0 0  
OS process: request allocation 9,942 0.00   0 0  
PL/SQL warning settings 4,601,344 0.00   0 0  
SGA IO buffer pool latch 57,669 0.90 0.00 0 62,110 0.94
SQL memory manager latch 1 0.00   0 1,198 0.00
SQL memory manager workarea list latch 7,241,410 0.02 0.01 0 0  
Shared B-Tree 129 0.00   0 0  
active checkpoint queue latch 969,738 0.89 0.00 0 2 0.00
active service list 48,793 0.27 0.00 0 1,258 0.00
begin backup scn array 132 0.00   0 0  
buffer pool 20 0.00   0 0  
cache buffer handles 24,429,288 1.78 0.00 0 0  
cache buffers chains 4,788,779,215 1.55 0.03 47 19,474,224 2.58
cache buffers lru chain 10,482,980 0.40 0.04 0 37,876,116 0.77
cache table scan latch 2,090 0.00   0 2,090 0.05
channel handle pool latch 415,177 0.21 0.03 0 0  
channel operations parent latch 1,860,836 0.41 0.00 0 0  
checkpoint queue latch 20,668,169 0.02 0.01 0 3,290,204 0.03
client/application info 1,797,038 0.01 0.00 0 0  
commit callback allocation 88,581 0.01 0.00 0 0  
compile environment latch 3,154,453 0.00   0 0  
dictionary lookup 78 0.00   0 0  
dml lock allocation 4,332,238 0.79 0.00 0 0  
dummy allocation 20,367 1.12 0.00 0 0  
enqueue hash chains 9,465,143 0.31 0.00 0 366 0.27
enqueues 5,429,541 0.21 0.01 0 0  
error message lists 816 7.60 0.00 0 0  
event group latch 4,990 0.00   0 0  
file cache latch 21,943 0.00   0 0  
global KZLD latch for mem in SGA 9,684 0.00   0 0  
global ctx hash table latch 24,513 0.00   0 0  
hash table column usage latch 1,785 0.28 0.00 0 15,614,586 0.00
hash table modification latch 143 0.00   0 0  
internal temp table object number allocation latc 6 0.00   0 0  
job workq parent latch 0     0 122 0.00
job_queue_processes parameter latch 120 0.00   0 0  
kks stats 30,975 0.02 0.00 0 0  
ksuosstats global area 242 0.00   0 0  
ktm global data 176,681 0.00   0 0  
kwqbsn:qsga 129 0.00   0 0  
lgwr LWN SCN 901,490 0.45 0.00 0 0  
library cache 356,106,109 0.59 0.00 3 17,898 0.80
library cache load lock 10,245 0.99 0.03 0 40 0.00
library cache lock 59,842,238 0.13 0.00 0 0  
library cache lock allocation 1,553,362 0.01 0.02 0 0  
library cache pin 222,005,440 0.39 0.00 1 37 0.00
library cache pin allocation 541,231 0.00 0.00 0 0  
list of block allocation 459,001 0.02 0.00 0 0  
loader state object freelist 322,714 0.02 0.00 0 0  
longop free list parent 34 0.00   0 34 0.00
message pool operations parent latch 421,806 0.08 0.02 0 0  
messages 5,506,136 0.52 0.00 0 0  
mostly latch-free SCN 1,043,655 12.59 0.00 0 0  
multiblock read objects 28,796 0.01 0.00 0 0  
ncodef allocation latch 106 0.00   0 0  
object queue header heap 4,295,435 0.03 0.17 0 426,363 0.05
object queue header operation 43,954,385 0.18 0.42 2 19,552 0.33
object stats modification 412,901 0.05 0.01 0 0  
parallel query alloc buffer 8,160 3.05 0.00 0 0  
parallel query stats 528 35.61 0.02 0 0  
parameter table allocation management 24,258 1.03 0.88 0 0  
post/wait queue 1,331,672 0.06 0.02 0 539,918 0.04
process allocation 9,990 0.49 0.96 1 4,988 0.04
process group creation 9,942 0.00   0 0  
process queue 5,030 3.02 0.00 0 0  
process queue reference 771,215 0.07 0.00 0 83,747 0.36
qmn task queue latch 516 0.00   0 0  
query server freelists 4,256 16.28 0.00 0 0  
query server process 8 0.00   0 8 0.00
redo allocation 6,148,514 5.49 0.00 0 103,232,569 3.58
redo copy 0     0 103,678,359 0.05
redo writing 4,219,384 0.29 0.00 0 0  
resmgr group change latch 860,117 0.00   0 0  
resmgr:actses active list 30,020 0.85 1.04 0 0  
resmgr:actses change group 29,438 0.00   0 0  
resmgr:free threads list 20,365 1.15 0.00 0 0  
resmgr:schema config 1 0.00   0 0  
row cache objects 129,625,777 0.57 0.00 0 5,319 0.15
rules engine aggregate statistics 41,573 0.13 0.00 0 0  
rules engine rule set statistics 133,611 0.08 0.00 0 0  
rules engine rule statistics 50,482 0.00   0 0  
sequence cache 16,639,719 1.13 0.00 0 0  
session allocation 19,765,025 1.10 0.01 0 0  
session idle bit 102,624,959 0.02 0.02 0 0  
session state list latch 59,047 0.31 0.27 0 0  
session switching 15,186 0.01 0.00 0 0  
session timer 1,258 0.00   0 0  
shared pool 7,679,251 0.31 0.03 0 0  
shared pool sim alloc 387 0.00   0 0  
shared pool simulator 2,024,943 0.01 0.01 0 0  
sim partition latch 1 0.00   0 22,938 0.16
simulator hash latch 2,460 0.00   0 0  
simulator lru latch 2,060 0.00   0 0  
slave class 1 0.00   0 0  
slave class create 4 0.00   0 0  
sort extent pool 1,446,135 0.21 0.01 0 0  
state object free list 12 0.00   0 0  
statistics aggregation 84 0.00   0 0  
temp lob duration state obj allocation 262 0.00   0 0  
temporary table state object allocation 12,638 0.11 0.00 0 0  
threshold alerts latch 606 0.00   0 0  
trace latch 47 0.00   0 0  
transaction allocation 117,397 0.00 0.00 0 0  
transaction branch allocation 106 0.00   0 0  
undo global data 950,752,636 1.37 0.00 1 30,992 0.11
user lock 38,792 0.05 0.05 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,788,779,215 74,007,369 2,522,325 71,640,796 0 0 0
In memory undo latch 707,960,200 24,554,786 48,189 24,510,286 0 0 0
undo global data 950,752,636 13,054,831 2,419 13,052,669 0 0 0
library cache 356,106,109 2,111,094 8,847 2,102,940 0 0 0
library cache pin 222,005,440 862,907 2,555 860,526 0 0 0
row cache objects 129,625,777 732,983 2,045 730,982 0 0 0
cache buffer handles 24,429,288 434,535 125 434,423 0 0 0
redo allocation 6,148,514 337,251 1,199 336,196 0 0 0
session allocation 19,765,025 217,913 1,694 216,311 0 0 0
sequence cache 16,639,719 187,973 75 187,908 0 0 0
mostly latch-free SCN 1,043,655 131,375 333 131,056 0 0 0
object queue header operation 43,954,385 79,103 32,885 48,443 0 0 0
library cache lock 59,842,238 77,793 242 77,554 0 0 0
cache buffers lru chain 10,482,980 42,258 1,484 40,833 0 0 0
dml lock allocation 4,332,238 34,250 91 34,169 0 0 0
enqueue hash chains 9,465,143 29,072 21 29,053 0 0 0
messages 5,506,136 28,410 103 28,308 0 0 0
session idle bit 102,624,959 24,172 381 23,797 0 0 0
shared pool 7,679,251 23,668 737 22,997 0 0 0
redo writing 4,219,384 12,405 28 12,377 0 0 0
enqueues 5,429,541 11,138 78 11,063 0 0 0
active checkpoint queue latch 969,738 8,624 9 8,615 0 0 0
channel operations parent latch 1,860,836 7,576 37 7,540 0 0 0
lgwr LWN SCN 901,490 4,021 1 4,020 0 0 0
checkpoint queue latch 20,668,169 3,459 30 3,431 0 0 0
sort extent pool 1,446,135 3,095 28 3,068 0 0 0
object queue header heap 4,295,435 1,436 244 1,213 0 0 0
SQL memory manager workarea list latch 7,241,410 1,163 8 1,156 0 0 0
channel handle pool latch 415,177 889 26 866 0 0 0
post/wait queue 1,331,672 830 14 816 0 0 0
SGA IO buffer pool latch 57,669 517 2 515 0 0 0
message pool operations parent latch 421,806 318 5 314 0 0 0
resmgr:actses active list 30,020 254 263 7 0 0 0
parameter table allocation management 24,258 250 219 58 0 0 0
object stats modification 412,901 196 1 195 0 0 0
parallel query stats 528 188 4 184 0 0 0
session state list latch 59,047 182 49 135 0 0 0
Consistent RBA 895,910 150 11 143 0 0 0
library cache lock allocation 1,553,362 136 3 133 0 0 0
shared pool simulator 2,024,943 111 1 110 0 0 0
library cache load lock 10,245 101 3 98 0 0 0
KWQMN job cache list latch 14,382 65 43 22 0 0 0
process allocation 9,990 49 47 2 0 0 0
user lock 38,792 21 1 20 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 36,465 39,182
In memory undo latch ktiFlush: child 0 6,832 4,000
In memory undo latch kticmt: child 0 3,251 531
In memory undo latch ktichg: child 0 1,311 4,313
In memory undo latch ktiTxnPoolFree 0 249 2
In memory undo latch ktbgfc 0 8 79
In memory undo latch ktiBRacquire 0 7 0
KWQMN job cache list latch kwqmnuji: update job item 0 50 16
KWQMN job cache list latch kwqmndej: dequeue 0 1 49
SGA IO buffer pool latch ksfd_alloc_sgabuffer 0 1 0
SGA IO buffer pool latch ksfd_free_sgabuffer 0 1 3
SQL memory manager workarea list latch qesmmIRegisterWorkArea 0 7 6
SQL memory manager workarea list latch qesmmIUnRegisterWorkArea 0 1 2
active checkpoint queue latch kcbbacq: scan active checkpoints 0 9 9
active service list ksws_event: ksws event 0 1 1
cache buffer handles kcbzgs 0 78 58
cache buffer handles kcbzfs 0 47 67
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 2,595,338 2,788,272
cache buffers chains kcbchg: kslbegin: call CR func 0 1,106,452 1,925,287
cache buffers chains kcbgtcr: fast path 0 790,332 73,699
cache buffers chains kcbgtcr: kslbegin excl 0 567,841 446,941
cache buffers chains kcbrls: kslbegin 0 286,315 422,042
cache buffers chains kcbzgb: scan from tail. nowait 0 176,417 0
cache buffers chains kcbgcur: kslbegin 0 54,809 30,265
cache buffers chains kcbget: pin buffer 0 26,947 12,314
cache buffers chains kcbget: exchange rls 0 15,778 17,075
cache buffers chains kcbzwb 0 14,278 11,863
cache buffers chains kcbget: exchange 0 12,691 17,293
cache buffers chains kcbcge 0 7,065 15,999
cache buffers chains kcbnlc 0 1,907 2,697
cache buffers chains kcbbxsv 0 409 402
cache buffers chains kcbso1: set no access 0 395 143
cache buffers chains kcb_is_private 0 290 3,299
cache buffers chains kcbgtcr: kslbegin shared 0 206 163
cache buffers chains kcbesc: escalate 0 117 59
cache buffers chains kcbnew: new latch again 0 98 11
cache buffers chains kcbbic2 0 44 9
cache buffers chains kcb_pre_apply: kcbhq61 0 24 1,378
cache buffers chains kcb_post_apply: kcbhq62 0 12 200
cache buffers chains kcb_post_apply: kcbhq63 0 7 243
cache buffers chains kcbo_ivd_process 0 2 49
cache buffers chains kcbzib: finish free bufs 0 2 2
cache buffers chains kcbbic1 0 1 5
cache buffers chains kcbgtcr 0 1 1
cache buffers chains kcbrlb1 0 1 17
cache buffers chains kcbzhngcbk1: get hash chain latch no wait 0 1 0
cache buffers chains kcbzib: exchange rls 0 1 1
cache buffers chains kcbzib: multi-block read: nowait 0 1 0
cache buffers lru chain kcbzgws 0 790 0
cache buffers lru chain kcbo_link_q 0 316 26
cache buffers lru chain kcbbxsv: move to being written 0 203 564
cache buffers lru chain kcbgtcr:CR Scan:KCBRSKIP 0 70 0
cache buffers lru chain kcbzgb: posted for free bufs 0 58 343
cache buffers lru chain kcbzswcu 0 18 104
cache buffers lru chain kcbbic2 0 12 302
cache buffers lru chain kcbo_ivd_proc 0 11 100
cache buffers lru chain kcbz_decr_wspwbcnt 0 2 20
cache buffers lru chain kcbo_write_process:free_unlink 0 1 0
cache buffers lru chain kcbzfw 0 1 1
cache buffers lru chain kcbzgm 0 1 0
cache buffers lru chain kcbzib 0 1 0
channel handle pool latch ksrchconnect() 0 106 92
channel handle pool latch ksrchdelete() 0 6 20
channel operations parent latch ksrapublish() 0 51 25
channel operations parent latch ksrchdelete() 0 27 22
channel operations parent latch ksrwait() 0 8 25
channel operations parent latch ksrchconnect() 0 7 9
channel operations parent latch ksrsconsume() 0 6 13
channel operations parent latch ksrmfree() 0 4 9
checkpoint queue latch kcbbwthc: thread checkpoint buffers 0 16 10
checkpoint queue latch kcbklbc: Link buffer into ckpt queue 0 5 3
checkpoint queue latch kcbkubc 0 5 7
checkpoint queue latch kcbswcu: Switch buffers 0 3 10
checkpoint queue latch kcbnlc: Link buffers into FQ 0 1 0
client/application info kskirefrattrmap 0 1 0
cost function kzulrl 0 1 1
dml lock allocation ktaiam 0 70 63
dml lock allocation ktaidm 0 21 28
enqueue hash chains ksqgtl3 0 12 12
enqueue hash chains ksqrcl 0 5 6
enqueue hash chains ksqcmi: kslgpl 0 2 1
enqueue hash chains ksqcmi: get hash chain latch after wait 0 1 2
enqueue hash chains ksqcmi: if deadlock detected 0 1 0
enqueues ksqgel: create enqueue 0 33 14
enqueues ksqies 0 28 57
enqueues ksqdel 0 17 7
lgwr LWN SCN kcs023 0 70 0
library cache kglpndl: child: after processing 0 3,315 288
library cache kglpnp: child 0 3,006 3,892
library cache kglobpn: child: 0 1,054 1,490
library cache kglpndl: child: before processing 0 420 2,508
library cache kglLockCursor 0 163 274
library cache kgldti: 2child 0 142 16
library cache kglScanDependency 0 140 0
library cache kglhdgn: child: 0 86 151
library cache kglpin 0 85 56
library cache kgldte: child 0 0 84 126
library cache kglhdgc: child: 0 28 4
library cache kglukp: child 0 6 0
library cache kglic 0 5 0
library cache kglivl: child 0 5 0
library cache kglupd: child 0 3 0
library cache kgldtld: 2child 0 2 0
library cache kglhdiv: child 0 2 0
library cache kglobld 0 2 4
library cache kglget: unpin heap 0 0 1 0
library cache load lock kglllal: llatch: in loop 0 2 3
library cache load lock kglllal: llatch 0 1 0
library cache lock kgllkdl: child: cleanup 0 167 140
library cache lock kgllkal: child: multiinstance 0 75 102
library cache lock kgllkdl: child: no lock handle 0 48 19
library cache lock allocation kgllkget 0 3 2
library cache pin kglpnp: child 0 1,193 1,257
library cache pin kglpndl 0 1,137 876
library cache pin kglpnal: child: alloc space 0 226 423
message pool operations parent latch ksrmalloc() 0 10 8
messages ksarcv: after wait 0 53 77
messages ksarcv 0 39 7
messages ksaamb: after wakeup 0 11 19
mostly latch-free SCN kcslcu3 0 263 334
mostly latch-free SCN kcsnew_scn_rba 0 6 0
mostly latch-free SCN kcs01 0 5 11
mostly latch-free SCN kcs024 0 1 0
object queue header heap kcbo_link_q:reget 0 239 3
object queue header heap kcbw_link_q:alloc 0 5 252
object queue header operation kcbo_ivbo 0 33,614 13,866
object queue header operation kcbw_link_q 0 4,853 3,289
object queue header operation kcbw_unlink_q 0 1,693 6,786
object queue header operation kcbo_switch_mq_bg 0 559 4,034
object queue header operation kcbo_switch_q_bg 0 503 2,230
object queue header operation kcbo_switch_cq 0 139 4,059
object queue header operation kcbo_link_q:reget 0 64 207
object queue header operation kcbo_service_ockpt 0 32 13
object queue header operation kcbo_write_q 0 19 72
object queue header operation kcbo_swap_buf 0 12 627
object queue header operation kcbo_swap_buf_bg 0 12 6,317
object queue header operation kcbw_unlink_q_bg 0 4 20
object stats modification ksoslinelm 0 1 1
parallel query stats kxfprst: KSLBEGIN:1 0 4 4
parameter table allocation management ksp_param_table_free 0 218 219
parameter table allocation management kspptval 0 1 1
post/wait queue ksliwat:remove 0 13 12
post/wait queue ksliwat:add:nowait 0 1 0
process allocation ksucrp 0 39 0
process allocation ksudlp 0 7 8
process allocation ksufap: active procs 0 1 0
redo allocation kcrfw_redo_gen: redo allocation 1 0 763 0
redo allocation kcrfw_redo_gen: redo allocation 3 0 293 1,008
redo allocation kcrfw_redo_gen: redo allocation 2 0 90 0
redo allocation kcrfw_redo_write: before write 0 29 86
redo allocation kcrfw_redo_write: more space 0 22 125
redo writing kcrfwcr 0 17 26
redo writing kcrfw_post: rba scn pair 0 7 0
redo writing kcrfw_cal_target_rba 0 2 0
redo writing kcrfw_post: after write 0 2 2
resmgr:actses active list kgskchclass 0 263 131
row cache objects kqreqd: reget 0 1,530 19
row cache objects kqrpre: find obj 0 374 911
row cache objects kqreqd 0 127 1,109
row cache objects kqrso 0 6 6
row cache objects kqrpup 0 1 0
sequence cache kdnssd 0 57 4
sequence cache kdnnxt: cached seq 0 12 2
sequence cache kdnss 0 6 70
session allocation ksuxds: KSUSFCLC not set 0 894 110
session allocation ksucri 0 213 409
session allocation ksuprc 0 197 340
session allocation ksudlc 0 153 467
session allocation ksuxds: not user session 0 150 296
session allocation kspallmod 0 26 0
session allocation kxfpqidqr 0 24 37
session allocation ksudlp 0 17 2
session allocation ksursi 0 15 25
session allocation kxfprdp 0 5 7
session idle bit ksupuc: set busy 0 357 155
session idle bit ksupuc: clear busy 0 166 358
session idle bit ksuxds 0 27 37
session state list latch kpseqd 0 47 1
session state list latch kpscad 0 2 10
shared pool kghupr1 0 396 488
shared pool kghalo 0 222 127
shared pool kghfrunp: clatch: nowait 0 222 0
shared pool kghalp 0 50 35
shared pool kghfrunp: clatch: wait 0 32 14
shared pool kghfrunp: alloc: cursor dur 0 30 1
shared pool kghfrunp: alloc: wait 0 19 1
shared pool kghfre 0 18 83
shared pool kghasp 0 1 2
shared pool kghfrh 0 1 0
shared pool simulator kglsim_unpin_simhp 0 1 1
sort extent pool ktstdt: dealloc sort extent 0 20 3
sort extent pool ktstdt: return extent 0 5 5
sort extent pool ktstsmonmsg 0 2 26
sort extent pool ktstallobj1 0 1 1
undo global data kturimugur: child 0 1,897 1,452
undo global data ktudba: KSLBEGIN 0 453 949
undo global data ktucof: at start 0 27 0
undo global data ktudnx:child 0 14 6
undo global data ktusmasp: ktugd_tuux 0 13 4
undo global data ktufrbs: child 0 8 5
undo global data ktubnd:child 0 4 0
undo global data ktumof: KSLBEGIN 0 1 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 69,216,048 3.36
INV APPS_TS_TX_IDX MTL_ITEM_CATEGORIES_U1   INDEX 50,914,512 2.47
ONT APPS_TS_TX_DATA OE_ORDER_LINES_ALL   TABLE 23,755,280 1.15
APPLSYS APPS_TS_TX_DATA WF_LOCAL_USER_ROLES FND_RESP TABLE PARTITION 22,433,264 1.09
WSH APPS_TS_TX_DATA WSH_DELIVERY_DETAILS   TABLE 21,668,992 1.05

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,007 7.66
AR APPS_ASSM_DATA RA_CUSTOMER_TRX_LINES_ALL   TABLE 13,143 2.88
WSH APPS_TS_TX_DATA WSH_DELIVERY_DETAILS   TABLE 9,554 2.09
HR APPS_TS_TX_IDX PAY_PERSON_LATEST_BALA_N50   INDEX 4,777 1.05
HR APPS_ASSM_DATA PAY_RUN_RESULTS   TABLE 4,048 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
WSH APPS_TS_TX_DATA WSH_TRIP_STOPS   TABLE 11,110 24.28
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_U1   INDEX 10,393 22.71
APPLSYS APPS_TS_TX_IDX WF_ITEM_ACTIVITY_STATUSES_N1   INDEX 10,064 21.99
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N6   INDEX 3,406 7.44
HR APPS_ASSM_IDX PAY_RUN_RESULT_VALUES_PK   INDEX 1,953 4.27

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 37 25.34
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N5   INDEX 23 15.75
APPLSYS APPS_TS_TX_IDX WF_ITEM_ATTRIBUTE_VALUES_PK   INDEX 21 14.38
SYS SYSTEM SEG$   TABLE 19 13.01
GL APPS_ASSM_IDX GL_IMPORT_REFERENCES_N1   INDEX 14 9.59

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 202,605 33.72
APPLSYS APPS_TS_TX_DATA WF_ITEM_ATTRIBUTE_VALUES   TABLE 97,413 16.21
SYS SYSTEM DBMS_LOCK_ALLOCATED   TABLE 37,563 6.25
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N6   INDEX 28,878 4.81
ONT APPS_TS_TX_DATA OE_ORDER_LINES_ALL   TABLE 21,047 3.50

Back to Segment Statistics
Back to Top

 

Dictionary Cache Stats

Cache Get Requests Pct Miss Scan Reqs Pct Miss Mod Reqs Final Usage
dc_awr_control 5 20.00 0   2 1
dc_constraints 648 47.07 0   648 0
dc_files 6,660 0.00 0   0 111
dc_global_oids 7,854,808 0.00 0   0 48
dc_histogram_data 5,248 14.54 0   0 705
dc_histogram_defs 423,300 2.56 0   4,044 3,867
dc_object_grants 72,626 0.05 0   0 68
dc_object_ids 13,062,197 0.02 0   58 1,056
dc_objects 181,619 0.99 0   347 810
dc_profiles 9,745 0.00 0   0 1
dc_rollback_segments 21,212 0.00 0   0 387
dc_segments 369,501 0.51 0   16,159 1,401
dc_sequences 53,663 0.16 0   53,663 119
dc_table_scns 20,653 0.04 0   0 5
dc_tablespace_quotas 16,019 0.14 0   218 45
dc_tablespaces 6,008,849 0.00 0   0 22
dc_usernames 515,326 0.00 0   0 19
dc_users 15,154,424 0.00 0   0 65
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 643,216 0.02 42,590,301 -0.00 11 0
CLUSTER 105 0.00 234 0.85 2 0
INDEX 15,818 0.40 16,630 0.56 0 0
JAVA DATA 624 0.00 0   0 0
PIPE 50,600 2.53 74,832 1.72 1 0
SQL AREA 6,358 90.23 114,118,177 0.06 3,836 404
TABLE/PROCEDURE 410,104 0.25 57,980,293 -0.01 1,043 0
TRIGGER 28,849 0.09 1,408,747 0.00 27 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,500.51   12.07 7.10 38 38 3,107 3,107
  Freeable 3,653.63 0.00 1.33 0.80 9   2,753 2,753
  SQL 3,469.61 1,778.85 1.12 0.70 5 21 3,099 3,098
  PL/SQL 2,407.00 192.33 0.77 0.96 3 3 3,107 3,107
  JAVA 266.68 265.32 2.22 0.29 5 8 120 120
E Other 43,763.61   13.92 8.63 42 42 3,145 3,145
  Freeable 4,239.81 0.00 1.50 0.93 9   2,822 2,822
  SQL 3,981.55 2,082.43 1.27 0.75 5 21 3,137 3,136
  PL/SQL 2,802.85 217.44 0.89 0.99 3 3 3,145 3,145
  JAVA 266.70 265.35 2.22 0.29 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,589,155,328 18,421,383,168
Fixed Size 2,111,120  
Redo Buffers 14,663,680  
Variable Size 2,868,906,352 3,036,678,512

Back to Memory Statistics
Back to Top

SGA breakdown difference

Pool Name Begin MB End MB % Diff
java free memory 83.29 83.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 40.50 40.50 0.00
shared CCursor 34.09 34.52 1.26
shared KTI-UNDO 53.19 53.19 0.00
shared PL/SQL MPCODE 66.66 68.97 3.46
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 376.82 384.57 2.06
shared library cache 860.79 1,016.02 18.03
shared parameter table block 57.89 58.25 0.63
shared private strands 99.77 99.77 0.00
shared sessions 36.42 36.42 0.00
shared sql area 391.37 385.48 -1.50
shared trace buffer 48.61 49.34 1.51
  buffer_cache 17,728.00 17,568.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,146 3,159 3600 3600


Back to Top

 

init.ora Parameters

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


Back to Top

End of Report