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 28-Aug-08 07:24:03 3811 203.1
End Snap: 2 28-Aug-08 08:24:08 3821 237.0
Elapsed:   60.08 (mins)    
DB Time:   371.81 (mins)    

 

Report Summary

Cache Sizes

  Begin End    
Buffer Cache: 18,112M 17,968M Std Block Size: 8K
Shared Pool Size: 2,240M 2,384M Log Buffer: 14,320K

Load Profile

  Per Second Per Transaction
Redo size: 8,377,536.52 31,179.01
Logical reads: 523,560.66 1,948.56
Block changes: 51,665.98 192.29
Physical reads: 123.15 0.46
Physical writes: 829.33 3.09
User calls: 9,842.27 36.63
Parses: 1,955.99 7.28
Hard parses: 2.11 0.01
Sorts: 2,385.01 8.88
Logons: 2.10 0.01
Executes: 23,206.14 86.37
Transactions: 268.69  

% Blocks changed per Read: 9.87 Recursive Call %: 79.32
Rollback per transaction %: 19.24 Rows per Sort: 12.81

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.94 Redo NoWait %: 100.00
Buffer Hit %: 99.98 In-memory Sort %: 100.00
Library Hit %: 100.02 Soft Parse %: 99.89
Execute to Parse %: 91.57 Latch Hit %: 98.30
Parse CPU to Parse Elapsd %: 87.45 % Non-Parse CPU: 97.82

Shared Pool Statistics

  Begin End
Memory Usage %: 84.68 84.80
% SQL with executions>1: 90.16 91.26
% Memory for SQL w/exec>1: 68.11 70.39

Top 5 Timed Events

Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class
CPU time   20,511   91.9  
db file sequential read 260,642 1,021 4 4.6 User I/O
log file sync 386,649 523 1 2.3 Commit
log file parallel write 725,976 399 1 1.8 System I/O
db file parallel write 226,115 192 1 .9 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 20,511.46 91.94
sql execute elapsed time 19,515.16 87.48
PL/SQL execution elapsed time 4,190.92 18.79
inbound PL/SQL rpc elapsed time 3,828.08 17.16
parse time elapsed 574.69 2.58
Java execution elapsed time 433.68 1.94
hard parse elapsed time 284.67 1.28
repeated bind elapsed time 66.24 0.30
sequence load elapsed time 15.03 0.07
connection management call elapsed time 10.63 0.05
PL/SQL compilation elapsed time 7.53 0.03
hard parse (sharing criteria) elapsed time 3.77 0.02
failed parse elapsed time 1.39 0.01
hard parse (bind mismatch) elapsed time 1.21 0.01
DB time 22,308.42  
background elapsed time 1,091.79  
background cpu time 410.70  

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 314,201 0.00 1,186 4 0.32
System I/O 982,985 0.00 602 1 1.01
Commit 386,649 0.00 523 1 0.40
Application 50,277 0.12 228 5 0.05
Concurrency 3,806,565 0.12 148 0 3.93
Network 40,645,172 0.00 136 0 41.96
Other 134,146 38.19 35 0 0.14
Configuration 8,031 0.00 3 0 0.01

Back to Wait Events Statistics
Back to Top

Wait Events

Event Waits %Time -outs Total Wait Time (s) Avg wait (ms) Waits /txn
db file sequential read 260,642 0.00 1,021 4 0.27
log file sync 386,649 0.00 523 1 0.40
log file parallel write 725,976 0.00 399 1 0.75
db file parallel write 226,115 0.00 192 1 0.23
enq: TX - row lock contention 413 11.62 154 373 0.00
db file scattered read 14,371 0.00 95 7 0.01
SQL*Net more data from client 1,853,493 0.00 71 0 1.91
read by other session 36,361 0.00 68 2 0.04
enq: UL - contention 2,438 0.57 61 25 0.00
cursor: pin S wait on X 4,768 92.49 48 10 0.00
SQL*Net message to client 37,169,014 0.00 42 0 38.37
latch: cache buffers chains 2,725,438 0.00 41 0 2.81
buffer busy waits 1,019,101 0.00 25 0 1.05
SQL*Net more data to client 1,622,665 0.00 22 0 1.68
library cache load lock 877 0.00 15 17 0.00
enq: TX - index contention 30,704 0.00 13 0 0.03
PX Deq Credit: send blkd 23,694 0.00 11 0 0.02
control file sequential read 29,155 0.00 10 0 0.03
rdbms ipc reply 4 50.00 7 1775 0.00
SQL*Net break/reset to client 47,390 0.00 7 0 0.05
kksfbc child completion 157 82.80 6 41 0.00
enq: RO - fast object reuse 34 0.00 6 173 0.00
os thread startup 70 0.00 3 39 0.00
PX Deq: Signal ACK 218 32.57 2 11 0.00
wait list latch free 184 0.00 2 11 0.00
enq: HW - contention 3,012 0.00 2 1 0.00
control file parallel write 1,739 0.00 1 1 0.00
local write wait 1,604 0.00 1 1 0.00
row cache lock 4,242 0.00 1 0 0.00
enq: DV - contention 229 0.00 1 5 0.00
latch: library cache 3,945 0.00 1 0 0.00
enq: TX - contention 2,865 0.00 1 0 0.00
direct path read 732 0.00 1 1 0.00
LGWR wait for redo copy 31,447 0.00 1 0 0.03
enq: SQ - contention 4,859 0.00 1 0 0.01
latch: In memory undo latch 12,475 0.00 1 0 0.01
latch: object queue header operation 15,158 0.00 1 0 0.02
latch free 917 0.00 0 0 0.00
library cache pin 1,932 0.00 0 0 0.00
latch: library cache pin 1,118 0.00 0 0 0.00
SGA: allocation forcing component growth 29 65.52 0 10 0.00
enq: TX - allocate ITL entry 107 0.00 0 3 0.00
buffer deadlock 50,675 98.92 0 0 0.05
enq: TM - contention 2 0.00 0 108 0.00
latch: undo global data 1,753 0.00 0 0 0.00
latch: session allocation 867 0.00 0 0 0.00
latch: redo allocation 596 0.00 0 0 0.00
latch: cache buffers lru chain 833 0.00 0 0 0.00
enq: FB - contention 889 0.00 0 0 0.00
latch: row cache objects 578 0.00 0 0 0.00
latch: shared pool 556 0.00 0 0 0.00
latch: library cache lock 118 0.00 0 0 0.00
enq: CU - contention 7 0.00 0 4 0.00
cursor: pin S 2,221 0.00 0 0 0.00
PX qref latch 906 96.69 0 0 0.00
latch: object queue header heap 105 0.00 0 0 0.00
latch: messages 179 0.00 0 0 0.00
reliable message 32 0.00 0 1 0.00
latch: cache buffer handles 107 0.00 0 0 0.00
enq: US - contention 6 0.00 0 2 0.00
L1 validation 1 100.00 0 11 0.00
cursor: mutex S 207 0.00 0 0 0.00
latch: checkpoint queue latch 22 0.00 0 0 0.00
latch: redo writing 38 0.00 0 0 0.00
cursor: mutex X 431 0.00 0 0 0.00
direct path write 447 0.00 0 0 0.00
enq: PS - contention 34 0.00 0 0 0.00
latch: enqueue hash chains 10 0.00 0 0 0.00
write complete waits 7 0.00 0 0 0.00
library cache lock 5 0.00 0 1 0.00
latch: parallel query alloc buffer 1 0.00 0 2 0.00
log buffer space 8 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 37,169,000 0.00 7,377,876 198 38.37
pipe get 22,186 21.18 21,073 950 0.02
Streams AQ: qmn slave idle wait 129 0.00 3,518 27268 0.00
Streams AQ: qmn coordinator idle wait 258 50.00 3,518 13634 0.00
Streams AQ: waiting for time management or cleanup tasks 2,358 38.59 3,509 1488 0.00
PX Idle Wait 1,638 76.68 2,567 1567 0.00
PL/SQL lock timer 222 99.10 2,479 11165 0.00
jobq slave wait 613 99.84 1,795 2928 0.00
PX Deq: Execution Msg 5,100 0.00 35 7 0.01
PX Deq: Execute Reply 2,600 0.00 3 1 0.00
PX Deq Credit: need buffer 3,505 0.00 1 0 0.00
PX Deq: Msg Fragment 4,402 0.00 0 0 0.00
PX Deq: Table Q Normal 5,004 0.00 0 0 0.01
PX Deq: Parse Reply 285 0.00 0 0 0.00
PX Deq: Join ACK 227 0.00 0 0 0.00
class slave wait 1 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 725,975 0.00 399 1 0.75
db file parallel write 226,115 0.00 192 1 0.23
control file sequential read 827 0.00 3 4 0.00
os thread startup 62 0.00 2 40 0.00
db file scattered read 352 0.00 2 5 0.00
events in waitclass Other 37,797 0.00 1 0 0.04
control file parallel write 1,739 0.00 1 1 0.00
direct path read 732 0.00 1 1 0.00
db file sequential read 267 0.00 1 3 0.00
latch: cache buffers chains 128 0.00 0 0 0.00
latch: redo writing 38 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: library cache 1 0.00 0 1 0.00
latch: shared pool 4 0.00 0 0 0.00
buffer busy waits 7 0.00 0 0 0.00
rdbms ipc message 1,530,157 0.80 36,035 24 1.58
Streams AQ: qmn slave idle wait 129 0.00 3,518 27268 0.00
Streams AQ: qmn coordinator idle wait 258 50.00 3,518 13634 0.00
pmon timer 1,268 95.43 3,511 2769 0.00
Streams AQ: waiting for time management or cleanup tasks 2,358 38.59 3,509 1488 0.00
smon timer 120,404 0.00 3,503 29 0.12

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic Total
BUSY_TIME 2,235,977
IDLE_TIME 6,332,347
IOWAIT_TIME 88,503
NICE_TIME 0
SYS_TIME 123,801
USER_TIME 2,044,837
LOAD 3
RSRC_MGR_CPU_WAIT_TIME 0
PHYSICAL_MEMORY_BYTES 64,888,032
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 22,306.80 20,509.80 428,511 1,884,515,203
SYS$BACKGROUND 0.00 0.00 15,491 2,926,920
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 312510 118259 3806359 14541 0 0 40633199 13556
SYS$BACKGROUND 1686 348 202 246 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,457 1,456 10 145.71 6.53 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
728 728 302 2.41 3.26 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
578 567 16 36.11 2.59 7g05xfvc5vp74 ARTERRPW BEGIN arp_run.revenue_recognit...
403 382 78,565 0.01 1.81 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
391 388 54,746 0.01 1.75 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
359 334 141,865 0.00 1.61 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
349 348 54,661 0.01 1.57 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...
312 312 259,151 0.00 1.40 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
312 311 54,943 0.01 1.40 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
275 273 61,313 0.00 1.23 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
265 263 1,009 0.26 1.19 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
254 232 186,453 0.00 1.14 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
237 109 1,682 0.14 1.06 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
226 219 166,739 0.00 1.01 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,456 1,457 10 145.62 6.53 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
728 728 302 2.41 3.26 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
567 578 16 35.43 2.59 7g05xfvc5vp74 ARTERRPW BEGIN arp_run.revenue_recognit...
388 391 54,746 0.01 1.75 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
382 403 78,565 0.00 1.81 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
348 349 54,661 0.01 1.57 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...
334 359 141,865 0.00 1.61 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
312 312 259,151 0.00 1.40 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
311 312 54,943 0.01 1.40 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
273 275 61,313 0.00 1.23 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
263 265 1,009 0.26 1.19 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
232 254 186,453 0.00 1.14 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
219 226 166,739 0.00 1.01 3b3psftuyks81 INVTTMTX BEGIN INV_TXNSTUB_PUB.postTran...
109 237 1,682 0.06 1.06 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
148,047,431 10 14,804,743.10 7.84 1456.19 1457.11 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
98,295,501 16 6,143,468.81 5.21 566.86 577.84 7g05xfvc5vp74 ARTERRPW BEGIN arp_run.revenue_recognit...
53,381,491 141,865 376.28 2.83 333.98 358.59 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
51,822,180 186,453 277.94 2.75 232.45 254.46 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
51,026,152 155,048 329.10 2.70 170.64 170.93 5kqw5535fjvw6 ARXTWMAI SELECT NVL(RCTT.ATTRIBUTE10, ...
43,700,596 54,746 798.24 2.32 387.62 391.08 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
42,276,273 302 139,987.66 2.24 727.53 727.98 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
37,265,371 12,019 3,100.54 1.97 124.87 125.51 by2f4fw8tac6r ARXTWMAI UPDATE RA_CUST_TRX_LINE_GL_DIS...
32,645,973 54,943 594.18 1.73 311.42 312.23 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
30,131,644 166,739 180.71 1.60 219.29 226.15 3b3psftuyks81 INVTTMTX BEGIN INV_TXNSTUB_PUB.postTran...
29,802,479 166,318 179.19 1.58 208.49 215.34 gf1u933c95jb5 INVTTMTX DECLARE l_ret_stat varchar2...
29,121,189 1,382,592 21.06 1.54 138.87 139.11 66tmsr3446uqn ap.oie.server.WebExpensesAM SELECT WIAS.ACTIVITY_STATUS, ...
26,389,669 9,999 2,639.23 1.40 118.90 211.89 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
23,572,996 61,313 384.47 1.25 273.21 274.67 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
22,708,638 54,661 415.44 1.20 347.97 349.39 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...

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,231 9,999 4.52 10.19 118.90 211.89 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
38,675 1,682 22.99 8.71 14.83 174.59 3dssuqfjsynrk asn.lead.server.LeadUwqAM SELECT count(1) FROM (SELECT *...
31,608 1,682 18.79 7.12 108.88 236.58 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
21,880 15,132 1.45 4.93 129.14 202.07 1q78dwnrrkf6c asn.lead.server.LeadUwqAM BEGIN ASN_SALES_PVT.Lead_Proce...
11,389 186,453 0.06 2.57 232.45 254.46 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
8,414 5,047 1.67 1.90 99.29 129.62 8jb36w62w5hqf ibuSRDetailsActions.jsp BEGIN IBU_REQ_PKG.UpdateServic...
8,363 141,865 0.06 1.88 333.98 358.59 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
4,553 9,965 0.46 1.03 159.37 171.94 csvvv0fmhr1yc PYUSLV BEGIN FFP1893_01010001.FORMULA...
4,503 9,999 0.45 1.01 132.22 142.10 63t8zpm02skgh PYUSLV SELECT DECODE(COUNT(PRR.RUN_RE...
903 252 3.58 0.20 110.31 112.89 fumydqvpk1g21 qotSCopOverview.jsp BEGIN ASO_QUOTE_PUB_W.SUBMIT_Q...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows Processed Rows per Exec CPU per Exec (s) Elap per Exec (s) SQL Id SQL Module SQL Text
1,382,592 716,471 0.52 0.00 0.00 66tmsr3446uqn ap.oie.server.WebExpensesAM SELECT WIAS.ACTIVITY_STATUS, ...
788,490 788,424 1.00 0.00 0.00 cd9mbmqyf4qhp ap.oie.server.WebExpensesAM UPDATE WF_ITEM_ACTIVITY_STATUS...
419,250 419,246 1.00 0.00 0.00 avc1jqzz04wpr JDBC Thin Client SELECT 'x' FROM DUAL
259,187 202,258 0.78 0.00 0.00 fmfdkztk8vx23   SELECT CATEGORY, SEVERITY, F...
259,151 259,135 1.00 0.00 0.00 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
203,809 3,464,510 17.00 0.00 0.00 cwyx16zn1hpfb JDBC Thin Client select parameter, value from ...
186,453 0 0.00 0.00 0.00 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
166,739 166,739 1.00 0.00 0.00 3b3psftuyks81 INVTTMTX BEGIN INV_TXNSTUB_PUB.postTran...
166,704 166,651 1.00 0.00 0.00 6gnth2mfbs2nq INVTTMTX declare v_ret number := 0...
166,318 166,103 1.00 0.00 0.00 gf1u933c95jb5 INVTTMTX DECLARE l_ret_stat varchar2...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse Calls Executions % Total Parses SQL Id SQL Module SQL Text
419,228 419,250 5.95 avc1jqzz04wpr JDBC Thin Client SELECT 'x' FROM DUAL
259,186 259,187 3.68 fmfdkztk8vx23   SELECT CATEGORY, SEVERITY, F...
259,149 259,151 3.68 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
203,798 203,809 2.89 cwyx16zn1hpfb JDBC Thin Client select parameter, value from ...
163,043 166,704 2.31 6gnth2mfbs2nq INVTTMTX declare v_ret number := 0...
141,852 141,865 2.01 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
116,476 117,614 1.65 fb13x9qx0ftks OEXOETEL begin OE_STANDARD_WF.OEOL_SELE...
109,171 111,551 1.55 1c0b7sas42w2z INVTTMTX SELECT NVL(ITEM_COST, 0), ...
88,809 88,941 1.26 76sw2a4vnc89j icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.S...
84,674 88,940 1.20 dcvv68fju01g4 icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.E...
84,622 84,696 1.20 bf7uwg5pa3pj6 icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.V...
84,604 84,712 1.20 608c0n36kaw62 icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.C...
84,280 84,285 1.20 162ttnv4ubqun OEXOETEL begin OE_DS_PVT.Check_PO_Appr...
77,947 77,981 1.11 8camsgjsr9zya OEXOETEL begin OE_TRANSACTION_TYPES_PK...

Back to SQL Statistics
Back to Top

 

SQL ordered by Sharable Memory

No data exists for this section of the report.

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 ) )
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;
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;
bkxrrs52m7d8p BEGIN WSH_SHIP_CONFIRM_ACTIONS.interface_ALL_wrp( :errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8); END;
bt0w082dfrm8v BEGIN WSH_SHIP_CONFIRM_ACTIONS.interface_ALL_wrp( :errbuf, :rc, :A0, :A1, :A2, :A3); END;
by2f4fw8tac6r UPDATE RA_CUST_TRX_LINE_GL_DIST LGD SET (AMOUNT, ACCTD_AMOUNT) = (SELECT NVL(LGD.AMOUNT, 0) - ( SUM(LGD2.AMOUNT) - ( DECODE(LGD.GL_DATE, REC1.GL_DATE, 1, 0) * DECODE(DECODE(LGD2.ACCOUNT_CLASS, 'UNEARN', 'REV', LGD2.ACCOUNT_CLASS), 'REV', CTL.REVENUE_AMOUNT, 'SUSPENSE', CTL.EXTENDED_AMOUNT - CTL.REVENUE_AMOUNT, CTL.EXTENDED_AMOUNT) ) ), NVL(LGD.ACCTD_AMOUNT, 0) - ( SUM(LGD2.ACCTD_AMOUNT) - ( DECODE(LGD.GL_DATE, REC1.GL_DATE, 1, 0) * DECODE(:B2 , NULL, ROUND(DECODE(DECODE(LGD2.ACCOUNT_CLASS, 'UNEARN', 'REV', LGD2.ACCOUNT_CLASS), 'REV', CTL.REVENUE_AMOUNT, 'SUSPENSE', CTL.EXTENDED_AMOUNT - CTL.REVENUE_AMOUNT, CTL.EXTENDED_AMOUNT) * NVL(CT.EXCHANGE_RATE, 1), :B3 ), ROUND( (DECODE(DECODE(LGD2.ACCOUNT_CLASS, 'UNEARN', 'REV', LGD2.ACCOUNT_CLASS), 'REV', CTL.REVENUE_AMOUNT, 'SUSPENSE', CTL.EXTENDED_AMOUNT - CTL.REVENUE_AMOUNT, CTL.EXTENDED_AMOUNT) * NVL(CT.EXCHANGE_RATE, 1) ) / :B2 ) * :B2 ) ) ) FROM RA_CUST_TRX_LINE_GL_DIST LGD2, RA_CUSTOMER_TRX_LINES CTL, RA_CUSTOMER_TRX CT, RA_CUST_TRX_LINE_GL_DIST REC1 WHERE REC1.CUSTOMER_TRX_ID = LGD.CUSTOMER_TRX_ID AND REC1.ACCOUNT_CLASS = 'REC' AND REC1.LATEST_REC_FLAG = 'Y' AND CT.CUSTOMER_TRX_ID = REC1.CUSTOMER_TRX_ID AND CTL.CUSTOMER_TRX_ID = CT.CUSTOMER_TRX_ID AND CTL.CUSTOMER_TRX_LINE_ID = LGD.CUSTOMER_TRX_LINE_ID AND LGD2.CUSTOMER_TRX_LINE_ID = LGD.CUSTOMER_TRX_LINE_ID AND LGD2.ACCOUNT_CLASS = LGD.ACCOUNT_CLASS AND LGD2.ACCOUNT_SET_FLAG = 'N' AND NVL(LGD2.GL_DATE, TO_DATE( 2415021, 'J') ) = NVL(LGD .GL_DATE, TO_DATE( 2415021, 'J') ) GROUP BY CTL.CUSTOMER_TRX_LINE_ID, DECODE(LGD2.ACCOUNT_CLASS, 'UNEARN', 'REV', LGD2.ACCOUNT_CLASS), REC1.GL_DATE, CTL.EXTENDED_AMOUNT, CTL.REVENUE_AMOUNT, CT.EXCHANGE_RATE ), PERCENT = (SELECT DECODE(LGD.ACCOUNT_CLASS || LGD.ACCOUNT_SET_FLAG, 'SUSPENSEN', LGD.PERCENT, 'UNBILLN', LGD.PERCENT, 'UNEARNN', LGD.PERCENT, NVL(LGD.PERCENT, 0) - ( SUM(NVL(LGD4.PERCENT, 0)) - DECODE(REC2.GL_DATE, NVL(LGD.GL_DATE, REC2.GL_DATE), 100, 0) ) ) FROM RA_CUST_TRX_LINE_GL_DIST LGD4, RA_CUST_TRX_LINE_GL_DIST REC2 WHERE REC2.CUSTOMER_TRX_ID = LGD.CUSTOMER_TRX_ID AND REC2.ACCOUNT_CLASS = 'REC' AND REC2.LATEST_REC_FLAG = 'Y' AND LGD4.CUSTOMER_TRX_LINE_ID = LGD.CUSTOMER_TRX_LINE_ID AND LGD4.ACCOUNT_SET_FLAG = LGD.ACCOUNT_SET_FLAG AND DECODE(LGD4.ACCOUNT_SET_FLAG, 'Y', LGD4.ACCOUNT_CLASS, LGD.ACCOUNT_CLASS) = LGD.ACCOUNT_CLASS AND NVL(LGD4.GL_DATE, TO_DATE( 2415021, 'J') ) = NVL(LGD.GL_DATE, TO_DATE( 2415021, 'J') ) GROUP BY REC2.GL_DATE, LGD.GL_DATE ), LAST_UPDATED_BY = :B1 , LAST_UPDATE_DATE = SYSDATE WHERE CUST_TRX_LINE_GL_DIST_ID IN (SELECT MIN(DECODE(LGD3.GL_POSTED_DATE, NULL, LGD3.CUST_TRX_LINE_GL_DIST_ID, NULL) ) FROM RA_CUSTOMER_TRX_LINES CTL, RA_CUST_TRX_LINE_GL_DIST LGD3, RA_CUST_TRX_LINE_GL_DIST REC3, RA_CUSTOMER_TRX T WHERE T.CUSTOMER_TRX_ID = :B5 AND REC3.CUSTOMER_TRX_ID = T.CUSTOMER_TRX_ID AND REC3.ACCOUNT_CLASS = 'REC' AND REC3.LATEST_REC_FLAG = 'Y' AND LGD3.CUSTOMER_TRX_ID = T.CUSTOMER_TRX_ID AND LGD3.ACCOUNT_S ET_FLAG = 'N' AND CTL.CUSTOMER_TRX_LINE_ID = LGD3.CUSTOMER_TRX_LINE_ID AND ( CTL.LINE_TYPE IN ('TAX', 'FREIGHT', 'CHARGES', 'SUSPENSE') OR (CTL.LINE_TYPE = 'LINE' AND CTL.ACCOUNTING_RULE_ID IS NULL) ) AND NVL(T.PREVIOUS_CUSTOMER_TRX_ID, -1) = DECODE(:B4 , 'INV', -1, 'REGULAR_CM', T.PREVIOUS_CUSTOMER_TRX_ID, NVL(T.PREVIOUS_CUSTOMER_TRX_ID, -1) ) GROUP BY CTL.CUSTOMER_TRX_LINE_ID, DECODE(LGD3.ACCOUNT_CLASS, 'UNEARN', 'REV', LGD3.ACCOUNT_CLASS), LGD3.GL_DATE, REC3.GL_DATE, CTL.EXTENDED_AMOUNT, CTL.REVENUE_AMOUNT, T.EXCHANGE_RATE HAVING ( SUM(NVL(LGD3.AMOUNT, 0)) <> DECODE(DECODE(LGD3.ACCOUNT_CLASS, 'UNEARN', 'REV', LGD3.ACCOUNT_CLASS), 'REV', CTL.REVENUE_AMOUNT, 'SUSPENSE', CTL.EXTENDED_AMOUNT - CTL.REVENUE_AMOUNT, CTL.EXTENDED_AMOUNT) * DECODE(LGD3.GL_DATE, REC3.GL_DATE, 1, 0) OR SUM(NVL(LGD3.ACCTD_AMOUNT, 0)) <> DECODE(LGD3.GL_DATE, REC3.GL_DATE, 1, 0) * DECODE(:B2 , NULL, ROUND(DECODE(DECODE(LGD3.ACCOUNT_CLASS, 'UNEARN', 'REV', LGD3.ACCOUNT_CLASS), 'REV', CTL.REVENUE_AMOUNT, 'SUSPENSE', CTL.EXTENDED_AMOUNT - CTL.REVENUE_AMOUNT, CTL.EXTENDED_AMOUNT) * NVL(T.EXCHANGE_RATE, 1), :B3 ), ROUND( (DECODE(DECODE(LGD3.ACCOUNT_CLASS, 'UNEARN', 'REV', LGD3.ACCOUNT_CLASS), 'REV', CTL.REVENUE_AMOUNT, 'SUSPENSE', CTL.EXTENDED_AMOUNT - CTL.REVENUE_AMOUNT, CTL.EXTENDED_AMOUNT) * NVL(T.EXCHANGE_RATE, 1) ) / :B2 ) * :B2 ) ) UNION SELECT TO_NUMBER( MIN(DECODE(LGD5.GL_POSTED_DATE||LGD5.ACCOUNT_CLASS|| LGD5.ACCOUNT_SET_FLAG, 'REVN', LGD 5.CUST_TRX_LINE_GL_DIST_ID, 'REVY', LGD5.CUST_TRX_LINE_GL_DIST_ID, 'TAXN', LGD5.CUST_TRX_LINE_GL_DIST_ID, 'TAXY', LGD5.CUST_TRX_LINE_GL_DIST_ID, 'FREIGHTN', LGD5.CUST_TRX_LINE_GL_DIST_ID, 'FREIGHTY', LGD5.CUST_TRX_LINE_GL_DIST_ID, 'CHARGESN', LGD5.CUST_TRX_LINE_GL_DIST_ID, 'CHARGESY', LGD5.CUST_TRX_LINE_GL_DIST_ID, 'UNEARNY', LGD5.CUST_TRX_LINE_GL_DIST_ID, 'UNBILLY', LGD5.CUST_TRX_LINE_GL_DIST_ID, NULL ) ) ) FROM RA_CUST_TRX_LINE_GL_DIST REC5, RA_CUST_TRX_LINE_GL_DIST LGD5, RA_CUSTOMER_TRX_LINES CTL2 WHERE CTL2.CUSTOMER_TRX_ID = :B5 AND REC5.CUSTOMER_TRX_ID = LGD5.CUSTOMER_TRX_ID AND REC5.ACCOUNT_CLASS = 'REC' AND REC5.LATEST_REC_FLAG = 'Y' AND LGD5.CUSTOMER_TRX_LINE_ID = CTL2.CUSTOMER_TRX_LINE_ID AND ( CTL2.LINE_TYPE IN ('TAX', 'FREIGHT', 'CHARGES', 'SUSPENSE') OR (CTL2.LINE_TYPE = 'LINE' AND (CTL2.ACCOUNTING_RULE_ID IS NULL OR LGD5.ACCOUNT_SET_FLAG = 'Y') ) ) GROUP BY LGD5.CUSTOMER_TRX_LINE_ID, LGD5.GL_DATE, REC5.GL_DATE, LGD5.ACCOUNT_SET_FLAG, DECODE(LGD5.ACCOUNT_SET_FLAG, 'N', NULL, LGD5.ACCOUNT_CLASS) HAVING SUM(NVL(LGD5.PERCENT, 0)) <> DECODE( NVL(LGD5.GL_DATE, REC5.GL_DATE), REC5.GL_DATE, 100, 0) )
cd9mbmqyf4qhp UPDATE WF_ITEM_ACTIVITY_STATUSES SET ACTIVITY_STATUS = :B8 , ACTIVITY_RESULT_CODE = NVL(:B13 , ACTIVITY_RESULT_CODE), BEGIN_DATE = NVL(:B11 , BEGIN_DATE), END_DATE = NVL(:B12 , END_DATE), DUE_DATE = DECODE(:B11 , TO_DATE(NULL), DUE_DATE, :B10 ), OUTBOUND_QUEUE_ID = :B9 , EXECUTION_TIME = DECODE(:B8 , :B7 , :B4 , :B6 , NVL(EXECUTION_TIME, :B4 ), :B5 , NVL(EXECUTION_TIME, :B4 ), EXECUTION_TIME) WHERE ITEM_TYPE = :B3 AND ITEM_KEY = :B2 AND PROCESS_ACTIVITY = :B1
csvvv0fmhr1yc BEGIN FFP1893_01010001.FORMULA( :N1, :N4, :T1, :I1, :D1, :T2, :I2, :T7, :I7, :T8, :I8, :T5, :I5, :N3, :T4, :I4, :N2, :N5, :T3, :I3, :T6, :I6, :FFERLN, :FFERCD, :FFERMT); END;
cwyx16zn1hpfb select parameter, value from nls_session_parameters
dcvv68fju01g4 begin FND_FLEX_WORKFLOW_APIS.END_GENERATION (:v1, :v2, :v3, :v4, :v5); end;
fb13x9qx0ftks begin OE_STANDARD_WF.OEOL_SELECTOR (:v1, :v2, :v3, :v4, :v5); end;
fmfdkztk8vx23 SELECT CATEGORY, SEVERITY, FND_LOG_SEVERITY FROM FND_NEW_MESSAGES WHERE MESSAGE_NAME = :B1 AND APPLICATION_ID = :B2 AND LANGUAGE_CODE = :B3 AND ROWNUM = 1
fumydqvpk1g21 BEGIN ASO_QUOTE_PUB_W.SUBMIT_Quote(x_return_status => :1, x_msg_count => :2, x_msg_data => :3, p_q_quote_header_id => :4, p_q_last_update_date => :5, p_q_quote_expiration_date => :6, p_sc_book_flag => :7, p_sc_reserve_flag => :8, p_sc_calculate_price => :9, p_sc_server_id => :10, x_order_number => :11, x_order_header_id => :12, x_order_request_id => :13, x_contract_id => :14, x_status => :15 ); END;
g8102j8yynbwz begin WF_STANDARD.CONTINUEFLOW (:v1, :v2, :v3, :v4, :v5); end;
gf1u933c95jb5 DECLARE l_ret_stat varchar2(56); BEGIN CSI_INV_TXN_HOOK_PKG.postTransaction( p_header_id => :1 , p_transaction_id => :2 , x_return_status => l_ret_stat ); INV_TXNSTUB_PUB.g_ret_status := l_ret_stat; END;
gksvm8wmzk8w0 begin OE_INVOICE_WF.INVOICE_INTERFACE (:v1, :v2, :v3, :v4, :v5); end;

Back to SQL Statistics
Back to Top

 

Instance Activity Statistics

Back to Top

Instance Activity Stats

Statistic Total per Second per Trans
CPU used by this session 2,043,539 566.85 2.11
CPU used when call started 2,038,814 565.54 2.10
CR blocks created 14,661,723 4,066.96 15.14
Cached Commit SCN referenced 46,031 12.77 0.05
Commit SCN cached 8 0.00 0.00
DB time 4,930,393 1,367.62 5.09
DBWR checkpoint buffers written 2,908,268 806.71 3.00
DBWR checkpoints 34 0.01 0.00
DBWR object drop buffers written 57,086 15.83 0.06
DBWR revisited being-written buffer 276 0.08 0.00
DBWR thread checkpoint buffers written 646,949 179.45 0.67
DBWR transaction table writes 1,958 0.54 0.00
DBWR undo block writes 1,521,511 422.05 1.57
DFO trees parallelized 48 0.01 0.00
IMU CR rollbacks 29,935,578 8,303.71 30.90
IMU Flushes 300,745 83.42 0.31
IMU Redo allocation size 1,954,116,416 542,044.33 2,017.35
IMU commits 498,997 138.41 0.52
IMU contention 39,958 11.08 0.04
IMU ktichg flush 8,390 2.33 0.01
IMU pool not allocated 0 0.00 0.00
IMU recursive-transaction flush 1,345 0.37 0.00
IMU undo allocation size 4,481,088,256 1,242,990.67 4,626.09
IMU- failed to get a private strand 0 0.00 0.00
PX local messages recv'd 51,478 14.28 0.05
PX local messages sent 51,478 14.28 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 37,161,222 10,308.00 38.36
active txn count during cleanout 98,849,373 27,419.42 102.05
application wait time 22,777 6.32 0.02
background checkpoints completed 3 0.00 0.00
background checkpoints started 2 0.00 0.00
background timeouts 13,903 3.86 0.01
branch node splits 1,025 0.28 0.00
buffer is not pinned count 549,407,766 152,397.96 567.19
buffer is pinned count 1,396,674,590 387,417.83 1,441.87
bytes received via SQL*Net from client 8,237,423,013 2,284,944.94 8,503.97
bytes sent via SQL*Net to client 7,711,938,979 2,139,183.08 7,961.48
calls to get snapshot scn: kcmgss 93,617,515 25,968.18 96.65
calls to kcmgas 18,299,876 5,076.13 18.89
calls to kcmgcs 16,799,612 4,659.98 17.34
change write time 58,724 16.29 0.06
cleanout - number of ktugct calls 29,736,244 8,248.41 30.70
cleanouts and rollbacks - consistent read gets 12,505,377 3,468.82 12.91
cleanouts only - consistent read gets 136,975 37.99 0.14
cluster key scan block gets 813,656 225.70 0.84
cluster key scans 229,077 63.54 0.24
commit batch performed 0 0.00 0.00
commit batch requested 0 0.00 0.00
commit batch/immediate performed 4,318 1.20 0.00
commit batch/immediate requested 4,318 1.20 0.00
commit cleanout failures: block lost 212,575 58.97 0.22
commit cleanout failures: buffer being written 2,085 0.58 0.00
commit cleanout failures: callback failure 102,987 28.57 0.11
commit cleanout failures: cannot pin 29,746 8.25 0.03
commit cleanouts 8,133,118 2,256.01 8.40
commit cleanouts successfully completed 7,785,725 2,159.65 8.04
commit immediate performed 4,318 1.20 0.00
commit immediate requested 4,318 1.20 0.00
commit txn count during cleanout 1,245,831 345.58 1.29
concurrency wait time 14,788 4.10 0.02
consistent changes 735,111,803 203,909.64 758.90
consistent gets 1,670,538,956 463,383.94 1,724.59
consistent gets - examination 1,188,447,860 329,658.67 1,226.90
consistent gets from cache 1,670,538,840 463,383.91 1,724.59
current blocks converted for CR 1 0.00 0.00
cursor authentications 2,006 0.56 0.00
data blocks consistent reads - undo records applied 731,871,647 203,010.87 755.55
db block changes 186,260,300 51,665.98 192.29
db block gets 216,940,674 60,176.28 223.96
db block gets direct 4,162 1.15 0.00
db block gets from cache 216,936,494 60,175.12 223.96
deferred (CURRENT) block cleanout applications 1,384,274 383.98 1.43
dirty buffers inspected 8,290 2.30 0.01
doubling up with imu segment 0 0.00 0.00
enqueue conversions 8,293 2.30 0.01
enqueue releases 3,674,707 1,019.31 3.79
enqueue requests 3,681,990 1,021.33 3.80
enqueue timeouts 7,120 1.97 0.01
enqueue waits 39,096 10.84 0.04
exchange deadlocks 50,679 14.06 0.05
execute count 83,660,132 23,206.14 86.37
failed probes on index block reclamation 7,119 1.97 0.01
free buffer inspected 2,603,497 722.17 2.69
free buffer requested 18,767,640 5,205.88 19.37
heap block compress 33,328,577 9,244.88 34.41
hot buffers moved to head of LRU 1,086,509 301.38 1.12
immediate (CR) block cleanout applications 12,642,370 3,506.82 13.05
immediate (CURRENT) block cleanout applications 1,048,629 290.87 1.08
index crx upgrade (found) 134,454 37.30 0.14
index crx upgrade (positioned) 8,294,166 2,300.68 8.56
index fast full scans (rowid ranges) 800 0.22 0.00
index fetch by key 168,717,446 46,799.84 174.18
index scans kdiixs1 131,638,300 36,514.61 135.90
java call heap collected bytes 1,294,510,560 359,078.97 1,336.40
java call heap collected count 16,182,240 4,488.73 16.71
java call heap gc count 4,230 1.17 0.00
java call heap live object count 1,516,975 420.79 1.57
java call heap live object count max 1,569,021 435.22 1.62
java call heap live size 436,527,360 121,086.53 450.65
java call heap live size max 446,591,592 123,878.21 461.04
java call heap object count 3,662,270 1,015.86 3.78
java call heap object count max 3,676,596 1,019.84 3.80
java call heap total size 584,056,832 162,009.13 602.96
java call heap total size max 596,639,744 165,499.45 615.95
java call heap used size 575,894,432 159,744.99 594.53
java call heap used size max 582,851,264 161,674.72 601.71
leaf node 90-10 splits 18,536 5.14 0.02
leaf node splits 232,675 64.54 0.24
lob reads 16,660 4.62 0.02
lob writes 28,962 8.03 0.03
lob writes unaligned 28,962 8.03 0.03
logons cumulative 7,574 2.10 0.01
messages received 1,772,929 491.79 1.83
messages sent 1,772,929 491.79 1.83
no buffer to keep pinned count 16 0.00 0.00
no work - consistent read gets 439,111,709 121,803.39 453.32
opened cursors cumulative 4,496,261 1,247.20 4.64
parse count (failures) 2,520 0.70 0.00
parse count (hard) 7,617 2.11 0.01
parse count (total) 7,051,501 1,955.99 7.28
parse time cpu 44,755 12.41 0.05
parse time elapsed 51,175 14.20 0.05
physical read IO requests 275,668 76.47 0.28
physical read bytes 3,636,985,856 1,008,848.57 3,754.67
physical read total IO requests 304,934 84.58 0.31
physical read total bytes 4,115,570,688 1,141,601.25 4,248.74
physical read total multi block requests 14,365 3.98 0.01
physical reads 443,968 123.15 0.46
physical reads cache 443,050 122.90 0.46
physical reads cache prefetch 168,120 46.63 0.17
physical reads direct 918 0.25 0.00
physical reads direct temporary tablespace 186 0.05 0.00
physical reads prefetch warmup 98,709 27.38 0.10
physical write IO requests 1,619,144 449.13 1.67
physical write bytes 24,492,474,368 6,793,866.88 25,285.01
physical write total IO requests 2,762,070 766.16 2.85
physical write total bytes 56,104,406,016 15,562,570.77 57,919.85
physical write total multi block requests 1,306,883 362.51 1.35
physical writes 2,989,804 829.33 3.09
physical writes direct 4,681 1.30 0.00
physical writes direct (lob) 240 0.07 0.00
physical writes direct temporary tablespace 4,049 1.12 0.00
physical writes from cache 2,985,123 828.03 3.08
physical writes non checkpoint 2,233,312 619.49 2.31
pinned buffers inspected 2,115 0.59 0.00
prefetch warmup blocks aged out before use 217,937 60.45 0.22
prefetched blocks aged out before use 121 0.03 0.00
process last non-idle time 3,605 1.00 0.00
queries parallelized 48 0.01 0.00
recursive calls 136,086,610 37,748.51 140.49
recursive cpu usage 1,168,216 324.05 1.21
redo blocks written 61,575,038 17,080.05 63.57
redo buffer allocation retries 8 0.00 0.00
redo entries 96,101,149 26,657.10 99.21
redo log space requests 0 0.00 0.00
redo log space wait time 0 0.00 0.00
redo ordering marks 1,196,662 331.94 1.24
redo size 30,201,739,628 8,377,536.52 31,179.01
redo subscn max counts 2,270,458 629.79 2.34
redo synch time 54,094 15.00 0.06
redo synch writes 1,710,443 474.45 1.77
redo wastage 293,596,940 81,439.65 303.10
redo write time 44,145 12.25 0.05
redo writer latching time 101 0.03 0.00
redo writes 725,974 201.37 0.75
rollback changes - undo records applied 196,099 54.40 0.20
rollbacks only - consistent read gets 2,415,621 670.06 2.49
rows fetched via callback 89,370,756 24,790.19 92.26
session connect time 0 0.00 0.00
session cursor cache hits 4,528,654 1,256.18 4.68
session logical reads 1,887,481,211 523,560.66 1,948.56
session pga memory 8,908,553,016 2,471,106.94 9,196.82
session pga memory max 10,289,114,648 2,854,055.26 10,622.05
session uga memory ############### 74,747,141.44 278,189.44
session uga memory max 56,096,319,952 15,560,327.81 57,911.50
shared hash latch upgrades - no wait 28,801,910 7,989.24 29.73
shared hash latch upgrades - wait 215,484 59.77 0.22
sorts (memory) 8,598,180 2,385.01 8.88
sorts (rows) 110,107,568 30,542.29 113.67
sql area evicted 2,437 0.68 0.00
sql area purged 2,690 0.75 0.00
summed dirty queue length 142,836 39.62 0.15
switch current to new buffer 1,238,547 343.56 1.28
table fetch by rowid 824,313,686 228,652.99 850.99
table fetch continued row 33,453,805 9,279.61 34.54
table scan blocks gotten 54,911,082 15,231.56 56.69
table scan rows gotten 1,634,647,996 453,428.29 1,687.54
table scans (long tables) 2,053 0.57 0.00
table scans (rowid ranges) 2,051 0.57 0.00
table scans (short tables) 4,489,563 1,245.34 4.63
total number of times SMON posted 120,385 33.39 0.12
transaction rollbacks 4,318 1.20 0.00
transaction tables consistent read rollbacks 84 0.02 0.00
transaction tables consistent reads - undo records applied 2,651 0.74 0.00
undo change vector size 10,534,559,416 2,922,138.17 10,875.44
user I/O wait time 118,627 32.91 0.12
user calls 35,482,237 9,842.27 36.63
user commits 782,292 217.00 0.81
user rollbacks 186,364 51.69 0.19
workarea executions - onepass 2 0.00 0.00
workarea executions - optimal 4,905,854 1,360.81 5.06
write clones created in background 1,592 0.44 0.00
write clones created in foreground 8,353 2.32 0.01

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistic Begin Value End Value
session cursor cache count 298,757 829,390
opened cursors current 773,881 905,451
workarea memory allocated 0 238
logons current 3,811 3,821

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 79 0 7.72 1.00 756,879 210 362,465 0.02
APPS_TS_TX_DATA 167,161 46 4.13 1.31 193,440 54 187,136 0.15
APPS_ASSM_DATA 8,857 2 2.15 6.48 268,463 74 38,078 0.35
APPS_TS_TX_IDX 82,867 23 4.28 1.55 176,536 49 100,054 0.22
APPS_ASSM_IDX 6,353 2 2.04 1.05 162,562 45 299,128 0.07
APPS_TS_TX_INTERFACE 1,078 0 1.93 2.22 30,969 9 26,232 0.02
TEMP 353 0 4.73 12.32 7,844 2 51 2.75
SYSTEM 5,566 2 3.97 3.51 2,390 1 36,506 0.07
APPS_TS_SUMMARY 74 0 8.24 1.00 7,122 2 3,193 0.01
APPS_TS_SEED 2,324 1 6.42 1.93 3,955 1 1,039 2.48
APPS_TS_QUEUES 338 0 6.09 2.48 4,314 1 1,025 0.13
APPS_TS_ARCHIVE 56 0 6.79 1.45 2,200 1 188 4.41
SYSAUX 373 0 2.82 1.22 1,411 0 3 0.00
APPS_TS_NOLOGGING 31 0 5.81 1.45 49 0 0 0.00
CTXSYS 28 0 8.57 1.00 6 0 0 0.00
APPS_TS_MEDIA 18 0 9.44 1.00 9 0 0 0.00
ODM 14 0 2.86 1.00 3 0 0 0.00
OLAP 14 0 3.57 1.00 3 0 0 0.00
OWAPUB 14 0 2.86 1.00 3 0 0 0.00
PORTAL 14 0 2.86 1.00 3 0 0 0.00
SYNCSERVER 14 0 4.29 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,857 2 2.15 6.48 268,463 74 38,078 0.35
APPS_ASSM_IDX /DB/visdata/apps_assm_idx.dbf 6,353 2 2.04 1.05 162,562 45 299,128 0.07
APPS_TS_ARCHIVE /DB/visdata/archive1.dbf 28 0 8.93 1.50 1,952 1 176 2.95
APPS_TS_ARCHIVE /DB/visdata/archive2.dbf 28 0 4.64 1.39 248 0 12 25.83
APPS_TS_MEDIA /DB/visdata/media1.dbf 6 0 6.67 1.00 3 0 0 0.00
APPS_TS_MEDIA /DB/visdata/media2.dbf 6 0 13.33 1.00 3 0 0 0.00
APPS_TS_MEDIA /DB/visdata/media3.dbf 6 0 8.33 1.00 3 0 0 0.00
APPS_TS_NOLOGGING /DB/visdata/nologging1.dbf 6 0 5.00 1.00 3 0 0 0.00
APPS_TS_NOLOGGING /DB/visdata/nologging2.dbf 17 0 5.88 1.00 34 0 0 0.00
APPS_TS_NOLOGGING /DB/visdata/nologging3.dbf 8 0 6.25 2.75 12 0 0 0.00
APPS_TS_QUEUES /DB/visdata/queues1.dbf 46 0 6.09 1.85 569 0 323 0.06
APPS_TS_QUEUES /DB/visdata/queues2.dbf 26 0 5.77 4.00 680 0 454 0.09
APPS_TS_QUEUES /DB/visdata/queues3.dbf 31 0 6.13 2.39 608 0 3 0.00
APPS_TS_QUEUES /DB/visdata/queues4.dbf 34 0 5.59 3.53 578 0 6 0.00
APPS_TS_QUEUES /DB/visdata/queues5.dbf 34 0 5.88 2.97 548 0 11 0.00
APPS_TS_QUEUES /DB/visdata/queues6.dbf 26 0 6.54 4.04 512 0 0 0.00
APPS_TS_QUEUES /DB/visdata/queues7.dbf 141 0 6.24 1.76 819 0 228 0.31
APPS_TS_SEED /DB/visdata/reference1.dbf 197 0 6.65 2.13 371 0 52 2.88
APPS_TS_SEED /DB/visdata/reference10.dbf 214 0 6.59 1.94 405 0 73 3.29
APPS_TS_SEED /DB/visdata/reference2.dbf 207 0 5.46 2.11 401 0 47 4.04
APPS_TS_SEED /DB/visdata/reference3.dbf 384 0 5.39 2.02 492 0 483 2.32
APPS_TS_SEED /DB/visdata/reference4.dbf 224 0 7.19 1.91 403 0 45 2.44
APPS_TS_SEED /DB/visdata/reference5.dbf 243 0 6.13 1.76 391 0 75 2.93
APPS_TS_SEED /DB/visdata/reference6.dbf 230 0 6.13 1.98 380 0 56 3.21
APPS_TS_SEED /DB/visdata/reference7.dbf 220 0 9.32 1.86 336 0 42 1.19
APPS_TS_SEED /DB/visdata/reference8.dbf 205 0 5.66 1.95 369 0 60 4.67
APPS_TS_SEED /DB/visdata/reference9.dbf 200 0 6.45 1.65 407 0 106 0.38
APPS_TS_SUMMARY /DB/visdata/summary1.dbf 7 0 10.00 1.00 827 0 486 0.00
APPS_TS_SUMMARY /DB/visdata/summary2.dbf 7 0 14.29 1.00 801 0 316 0.03
APPS_TS_SUMMARY /DB/visdata/summary3.dbf 12 0 9.17 1.00 780 0 289 0.07
APPS_TS_SUMMARY /DB/visdata/summary4.dbf 12 0 5.00 1.00 801 0 310 0.00
APPS_TS_SUMMARY /DB/visdata/summary5.dbf 9 0 7.78 1.00 904 0 368 0.00
APPS_TS_SUMMARY /DB/visdata/summary6.dbf 9 0 7.78 1.00 967 0 793 0.00
APPS_TS_SUMMARY /DB/visdata/summary7.dbf 9 0 6.67 1.00 1,019 0 234 0.04
APPS_TS_SUMMARY /DB/visdata/summary8.dbf 9 0 7.78 1.00 1,023 0 397 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data1.dbf 3,014 1 4.70 1.27 289 0 2 5.00
APPS_TS_TX_DATA /DB/visdata/tx_data10.dbf 2,965 1 4.55 1.23 168 0 0 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data11.dbf 3,020 1 4.69 1.28 129 0 0 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data12.dbf 12,579 3 2.97 1.23 2,926 1 3,867 1.14
APPS_TS_TX_DATA /DB/visdata/tx_data13.dbf 16,705 5 4.61 1.48 4,053 1 2,583 0.81
APPS_TS_TX_DATA /DB/visdata/tx_data14.dbf 12,648 4 3.98 1.36 29,565 8 25,629 0.12
APPS_TS_TX_DATA /DB/visdata/tx_data15.dbf 9,028 3 3.86 1.44 26,952 7 23,087 0.13
APPS_TS_TX_DATA /DB/visdata/tx_data16.dbf 9,031 3 3.76 1.42 26,109 7 24,698 0.11
APPS_TS_TX_DATA /DB/visdata/tx_data17.dbf 8,972 2 3.75 1.43 25,231 7 26,384 0.10
APPS_TS_TX_DATA /DB/visdata/tx_data18.dbf 8,983 2 3.79 1.41 24,548 7 25,933 0.09
APPS_TS_TX_DATA /DB/visdata/tx_data19.dbf 8,886 2 3.89 1.43 24,443 7 25,578 0.12
APPS_TS_TX_DATA /DB/visdata/tx_data2.dbf 6,540 2 3.27 1.14 828 0 2,060 0.91
APPS_TS_TX_DATA /DB/visdata/tx_data20.dbf 8,761 2 3.84 1.44 24,749 7 25,655 0.09
APPS_TS_TX_DATA /DB/visdata/tx_data21.dbf 21,645 6 4.72 1.16 1,037 0 1,622 0.13
APPS_TS_TX_DATA /DB/visdata/tx_data3.dbf 3,157 1 5.06 1.40 397 0 6 6.67
APPS_TS_TX_DATA /DB/visdata/tx_data4.dbf 16,074 4 4.41 1.11 330 0 3 10.00
APPS_TS_TX_DATA /DB/visdata/tx_data5.dbf 3,003 1 4.77 1.26 296 0 6 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data6.dbf 3,010 1 4.83 1.23 175 0 8 3.75
APPS_TS_TX_DATA /DB/visdata/tx_data7.dbf 2,998 1 4.56 1.25 460 0 11 3.64
APPS_TS_TX_DATA /DB/visdata/tx_data8.dbf 3,039 1 4.41 1.19 487 0 4 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data9.dbf 3,103 1 4.33 1.26 268 0 0 0.00
APPS_TS_TX_IDX /DB/visdata/tx_idx1.dbf 2,343 1 3.35 1.21 2,127 1 1,666 0.52
APPS_TS_TX_IDX /DB/visdata/tx_idx10.dbf 2,298 1 3.20 1.24 1,467 0 1,717 0.38
APPS_TS_TX_IDX /DB/visdata/tx_idx11.dbf 2,309 1 3.19 1.24 1,737 0 2,192 0.45
APPS_TS_TX_IDX /DB/visdata/tx_idx12.dbf 9,481 3 5.31 1.98 18,149 5 2,027 0.19
APPS_TS_TX_IDX /DB/visdata/tx_idx13.dbf 8,484 2 4.41 1.42 25,679 7 5,662 0.22
APPS_TS_TX_IDX /DB/visdata/tx_idx14.dbf 4,809 1 4.80 1.68 16,852 5 5,866 0.16
APPS_TS_TX_IDX /DB/visdata/tx_idx15.dbf 4,841 1 4.84 1.65 14,075 4 9,060 0.12
APPS_TS_TX_IDX /DB/visdata/tx_idx16.dbf 4,785 1 4.69 1.68 12,937 4 6,622 0.11
APPS_TS_TX_IDX /DB/visdata/tx_idx17.dbf 4,650 1 4.80 1.61 12,489 3 6,095 0.11
APPS_TS_TX_IDX /DB/visdata/tx_idx18.dbf 4,885 1 4.84 1.67 12,318 3 11,838 0.07
APPS_TS_TX_IDX /DB/visdata/tx_idx19.dbf 4,883 1 4.55 1.68 11,785 3 8,947 0.09
APPS_TS_TX_IDX /DB/visdata/tx_idx2.dbf 2,655 1 3.84 1.48 1,783 0 2,455 0.29
APPS_TS_TX_IDX /DB/visdata/tx_idx20.dbf 4,798 1 4.80 1.61 11,139 3 4,769 0.25
APPS_TS_TX_IDX /DB/visdata/tx_idx21.dbf 3,087 1 5.12 1.89 15,350 4 3,187 0.49
APPS_TS_TX_IDX /DB/visdata/tx_idx3.dbf 3,842 1 2.58 1.19 1,789 0 2,572 0.69
APPS_TS_TX_IDX /DB/visdata/tx_idx4.dbf 2,514 1 3.23 1.29 3,357 1 3,020 0.75
APPS_TS_TX_IDX /DB/visdata/tx_idx5.dbf 2,491 1 3.45 1.31 4,747 1 14,167 0.14
APPS_TS_TX_IDX /DB/visdata/tx_idx6.dbf 2,534 1 3.28 1.25 2,687 1 2,529 0.52
APPS_TS_TX_IDX /DB/visdata/tx_idx7.dbf 2,448 1 3.33 1.31 2,627 1 1,814 0.36
APPS_TS_TX_IDX /DB/visdata/tx_idx8.dbf 2,368 1 3.04 1.26 1,754 0 1,873 0.60
APPS_TS_TX_IDX /DB/visdata/tx_idx9.dbf 2,362 1 3.30 1.32 1,688 0 1,976 0.39
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte.dbf 134 0 1.72 2.14 4,681 1 4,128 0.03
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte2.dbf 375 0 1.84 1.86 6,072 2 3,968 0.01
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte3.dbf 162 0 2.35 2.53 5,468 2 4,837 0.03
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte4.dbf 126 0 1.59 2.67 5,015 1 3,568 0.03
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte5.dbf 65 0 4.31 3.98 4,805 1 4,975 0.02
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte6.dbf 216 0 1.39 1.87 4,928 1 4,756 0.03
APPS_UNDOTS1 /DB/visdata/undo01.dbf 9 0 8.89 1.00 79,246 22 34,818 0.02
APPS_UNDOTS1 /DB/visdata/undo02.dbf 5 0 12.00 1.00 75,927 21 31,009 0.02
APPS_UNDOTS1 /DB/visdata/undo03.dbf 4 0 7.50 1.00 74,113 21 38,320 0.02
APPS_UNDOTS1 /DB/visdata/undo04.dbf 8 0 5.00 1.00 75,616 21 34,144 0.02
APPS_UNDOTS1 /DB/visdata/undo05.dbf 5 0 12.00 1.00 74,715 21 33,625 0.01
APPS_UNDOTS1 /DB/visdata/undo06.dbf 4 0 5.00 1.00 74,530 21 34,650 0.02
APPS_UNDOTS1 /DB/visdata/undo07.dbf 11 0 4.55 1.00 73,618 20 42,686 0.02
APPS_UNDOTS1 /DB/visdata/undo08.dbf 8 0 8.75 1.00 74,776 21 35,585 0.02
APPS_UNDOTS1 /DB/visdata/undo09.dbf 6 0 10.00 1.00 74,322 21 34,748 0.02
APPS_UNDOTS1 /DB/visdata/undo10.dbf 19 0 7.37 1.00 80,016 22 42,880 0.02
CTXSYS /DB/visdata/ctx1.dbf 14 0 8.57 1.00 3 0 0 0.00
CTXSYS /DB/visdata/ctx2.dbf 14 0 8.57 1.00 3 0 0 0.00
ODM /DB/visdata/odm.dbf 14 0 2.86 1.00 3 0 0 0.00
OLAP /DB/visdata/olap.dbf 14 0 3.57 1.00 3 0 0 0.00
OWAPUB /DB/visdata/owa1.dbf 14 0 2.86 1.00 3 0 0 0.00
PORTAL /DB/visdata/portal.dbf 14 0 2.86 1.00 3 0 0 0.00
SYNCSERVER /DB/visdata/mobile01.dbf 14 0 4.29 1.00 3 0 0 0.00
SYSAUX /DB/visdata/sysaux01.dbf 35 0 6.00 1.51 648 0 3 0.00
SYSAUX /DB/visdata/sysaux02.dbf 338 0 2.49 1.19 763 0 0 0.00
SYSTEM /DB/visdata/sys1.dbf 620 0 3.97 3.81 93 0 101 0.59
SYSTEM /DB/visdata/sys2.dbf 598 0 4.21 4.03 168 0 145 0.28
SYSTEM /DB/visdata/sys3.dbf 714 0 3.42 3.48 232 0 14 0.00
SYSTEM /DB/visdata/sys4.dbf 600 0 3.62 3.88 239 0 8 8.75
SYSTEM /DB/visdata/sys5.dbf 992 0 3.88 2.85 642 0 1,887 0.08
SYSTEM /DB/visdata/sys6.dbf 578 0 4.45 4.21 68 0 7 2.86
SYSTEM /DB/visdata/sys7.dbf 447 0 4.81 4.43 127 0 90 0.00
SYSTEM /DB/visdata/sys8.dbf 442 0 4.12 2.99 446 0 34,108 0.06
SYSTEM /DB/visdata/sys9.dbf 575 0 3.72 2.41 375 0 146 1.44
TEMP /DB/visdata/temp1.dbf 96 0 4.69 13.28 1,872 1 21 3.81
TEMP /DB/visdata/temp2.dbf 71 0 4.23 2.77 1,975 1 10 3.00
TEMP /DB/visdata/temp3.dbf 91 0 6.37 25.80 2,046 1 20 1.50
TEMP /DB/visdata/temp4.dbf 95 0 3.58 5.56 1,951 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,222,417 100 1,880,352,206 443,054 2,985,123 0 0 1,055,384


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 81 34719 811133 3117935 188743680 3117935  
E 180 84 38753 828496 8809227 188743680 8809227  

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 455,891 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 32,351.12 0.06 0.00 100.00 0.00 1,048,576
E 20,480 1,280 39,951.19 1.46 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 4,436,668 4,436,668 0 0
64K 128K 11,490 11,490 0 0
128K 256K 1,063 1,063 0 0
256K 512K 999 999 0 0
512K 1024K 138,708 138,708 0 0
1M 2M 308,564 308,564 0 0
2M 4M 68 66 2 0
4M 8M 17 17 0 0
8M 16M 2 2 0 0
32M 64M 8 8 0 0
64M 128M 6 6 0 0
128M 256M 2 2 0 0

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

PGA Target Est (MB) Size Factr W/A MB Processed Estd Extra W/A MB Read/ Written to Disk Estd PGA Cache Hit % Estd PGA Overalloc Count
2,560 0.13 617,220.84 7,864.39 99.00 979
5,120 0.25 617,220.84 7,783.64 99.00 941
10,240 0.50 617,220.84 7,668.48 99.00 888
15,360 0.75 617,220.84 7,546.00 99.00 840
20,480 1.00 617,220.84 2.73 100.00 780
24,576 1.20 617,220.84 2.73 100.00 615
28,672 1.40 617,220.84 0.00 100.00 144
32,768 1.60 617,220.84 0.00 100.00 0
36,864 1.80 617,220.84 0.00 100.00 0
40,960 2.00 617,220.84 0.00 100.00 0
61,440 3.00 617,220.84 0.00 100.00 0
81,920 4.00 617,220.84 0.00 100.00 0
122,880 6.00 617,220.84 0.00 100.00 0
163,840 8.00 617,220.84 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,440 0.60 283 12,440 2,016,951 1.00 4,637 4.45 140,578,596
1,680 0.70 486 15,472 2,020,102 1.00 1,486 1.42 140,759,972
1,920 0.80 724 19,279 2,020,505 1.00 1,083 1.04 140,785,759
2,160 0.90 946 23,536 2,020,545 1.00 1,043 1.00 140,788,737
2,400 1.00 1,094 29,936 2,020,545 1.00 1,043 1.00 140,788,830
2,640 1.10 1,105 30,897 2,020,545 1.00 1,043 1.00 140,788,832
2,880 1.20 1,105 30,897 2,020,545 1.00 1,043 1.00 140,788,832
3,120 1.30 1,105 30,897 2,020,545 1.00 1,043 1.00 140,788,832
3,360 1.40 1,105 30,897 2,020,545 1.00 1,043 1.00 140,788,832
3,600 1.50 1,105 30,897 2,020,545 1.00 1,043 1.00 140,788,832
3,840 1.60 1,105 30,897 2,020,545 1.00 1,043 1.00 140,788,832
4,080 1.70 1,105 30,897 2,020,545 1.00 1,043 1.00 140,788,832
4,320 1.80 1,105 30,897 2,020,545 1.00 1,043 1.00 140,788,832
4,560 1.90 1,105 30,897 2,020,545 1.00 1,043 1.00 140,788,832
4,800 2.00 1,105 30,897 2,020,545 1.00 1,043 1.00 140,788,832

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

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 12 263 125 1.00 1,043 1.00 7,825
48 0.50 13 268 125 1.00 1,043 1.00 7,825
64 0.67 13 268 125 1.00 1,043 1.00 7,825
80 0.83 13 268 125 1.00 1,043 1.00 7,825
96 1.00 13 268 125 1.00 1,043 1.00 7,825
112 1.17 13 268 125 1.00 1,043 1.00 7,825
128 1.33 13 268 125 1.00 1,043 1.00 7,825
144 1.50 13 268 125 1.00 1,043 1.00 7,825
160 1.67 13 268 125 1.00 1,043 1.00 7,825
176 1.83 13 268 125 1.00 1,043 1.00 7,825
192 2.00 13 268 125 1.00 1,043 1.00 7,825
208 2.17 13 268 125 1.00 1,043 1.00 7,825

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 682,554 90 0
undo block 293,347 5 0
undo header 69,181 2 0
1st level bmb 6,669 0 0
segment header 2,689 0 0
file header block 71 0 2
2nd level bmb 697 0 0
extent map 14 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,094 355 5,739 334 158 471.98
UL-User-defined 66,439 65,388 1,051 2,407 63 26.07
TX-Transaction (index contention) 29,421 29,421 0 27,199 14 0.52
RO-Multiple Object Reuse (fast object reuse) 288 288 0 32 6 188.13
HW-Segment High Water Mark 206,770 206,759 10 2,573 2 0.73
DV-Diana Versioning 22,848 22,848 0 216 1 6.06
TX-Transaction 1,106,630 1,107,033 0 1,982 1 0.52
SQ-Sequence Cache 37,672 37,672 0 3,576 1 0.20
TX-Transaction (allocate ITL entry) 178 178 0 100 0 2.80
TM-DML 1,663,946 1,663,893 0 2 0 110.00
FB-Format Block 35,379 35,379 0 639 0 0.06
CU-Cursor 7,422 7,422 0 6 0 5.00
US-Undo Segment 7,975 7,973 0 6 0 1.67
PS-PX Process Reservation 1,861 1,540 320 24 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,424.68 993,235 2,019 275   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
28-Aug 08:13 156,318 132,088 666 270 199 0/0 0/0/0/0/0/0
28-Aug 08:03 212,064 127,009 506 267 197 0/0 0/0/0/0/0/0
28-Aug 07:53 382,349 166,696 370 268 204 0/0 0/0/0/0/0/0
28-Aug 07:43 283,177 216,382 2,019 275 261 0/0 0/0/0/0/0/0
28-Aug 07:33 390,773 351,060 1,681 270 343 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,464 0.00   0 0  
AWR Alerted Metric Element list 248,143 0.00   0 0  
Consistent RBA 726,154 0.01 0.02 0 0  
FOB s.o list latch 46,582 0.02 0.00 0 0  
In memory undo latch 714,530,210 2.77 0.00 1 990,742 0.00
JOX SGA heap latch 1,864,533 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,931 0.00   0 0  
KMG resize request state object freelist 18 0.00   0 0  
KTF sga latch 12 0.00   0 1,214 0.00
KWQMN job cache list latch 12,079 0.28 0.65 0 0  
MQL Tracking Latch 0     0 71 0.00
Memory Management Latch 1,913 0.05 1.00 0 2,919 0.10
OS process 11,787 0.00   0 0  
OS process allocation 9,072 0.01 0.00 0 0  
OS process: request allocation 7,590 0.03 0.00 0 0  
PL/SQL warning settings 3,549,688 0.00   0 0  
SGA IO buffer pool latch 44,115 1.33 0.00 0 45,803 0.79
SQL memory manager latch 1 0.00   0 1,198 0.00
SQL memory manager workarea list latch 5,422,013 0.02 0.00 0 0  
Shared B-Tree 129 0.00   0 0  
active checkpoint queue latch 1,048,463 1.10 0.00 0 2 0.00
active service list 38,326 0.30 0.00 0 1,240 0.00
begin backup scn array 165 0.00   0 0  
buffer pool 18 0.00   0 0  
cache buffer handles 21,741,756 1.97 0.00 0 0  
cache buffers chains 4,488,859,397 1.70 0.04 41 17,146,562 2.58
cache buffers lru chain 9,312,508 0.39 0.02 0 33,122,620 0.64
cache table scan latch 1,980 0.00   0 1,980 0.00
channel handle pool latch 292,502 0.19 0.03 0 0  
channel operations parent latch 1,315,015 0.50 0.00 0 0  
checkpoint queue latch 21,285,805 0.02 0.01 0 3,012,860 0.02
client/application info 1,307,299 0.03 0.00 0 0  
commit callback allocation 62,868 0.00   0 0  
compile environment latch 2,229,364 0.00   0 0  
dictionary lookup 78 0.00   0 0  
dml lock allocation 3,315,055 0.80 0.00 0 0  
dummy allocation 15,150 1.79 0.00 0 0  
enqueue hash chains 7,411,885 0.30 0.00 0 351 0.28
enqueues 3,963,978 0.18 0.00 0 0  
error message lists 816 9.68 0.00 0 0  
event group latch 3,801 0.00   0 0  
file cache latch 19,986 0.01 0.00 0 0  
global KZLD latch for mem in SGA 7,063 0.00   0 0  
global ctx hash table latch 17,164 0.00   0 0  
hash table column usage latch 1,872 0.11 0.00 0 11,023,315 0.00
hash table modification latch 136 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 25,394 0.03 0.13 0 0  
ksuosstats global area 243 0.00   0 0  
ktm global data 120,404 0.00   0 0  
kwqbsn:qsga 129 0.00   0 0  
lgwr LWN SCN 730,482 0.44 0.00 0 0  
library cache 269,262,415 0.50 0.00 1 19,997 0.44
library cache load lock 10,198 0.98 0.00 0 19 0.00
library cache lock 42,943,992 0.09 0.00 0 0  
library cache lock allocation 1,133,458 0.00 0.00 0 0  
library cache pin 168,121,193 0.36 0.00 0 24 0.00
library cache pin allocation 398,688 0.01 0.05 0 0  
list of block allocation 412,536 0.03 0.00 0 0  
loader state object freelist 226,528 0.01 0.00 0 0  
longop free list parent 34 0.00   0 34 0.00
message pool operations parent latch 296,534 0.09 0.00 0 0  
messages 5,262,898 0.59 0.01 0 0  
mostly latch-free SCN 829,328 11.22 0.00 0 0  
multiblock read objects 31,521 0.00 0.00 0 0  
ncodef allocation latch 107 0.00   0 0  
object queue header heap 4,494,700 0.02 0.14 0 306,242 0.04
object queue header operation 35,858,642 0.13 0.32 1 17,359 0.05
object stats modification 290,488 0.03 0.00 0 0  
parallel query alloc buffer 8,156 3.32 0.00 0 0  
parallel query stats 528 39.20 0.01 0 0  
parameter table allocation management 17,433 1.61 0.89 0 0  
post/wait queue 963,438 0.05 0.01 0 386,841 0.03
process allocation 7,638 0.24 1.00 0 3,801 0.00
process group creation 7,590 0.01 0.00 0 0  
process queue 5,030 3.78 0.00 0 0  
process queue reference 740,764 0.06 0.00 0 82,024 1.10
qmn task queue latch 516 0.00   0 0  
query server freelists 4,256 17.95 0.00 0 0  
query server process 8 0.00   0 8 0.00
redo allocation 4,788,631 4.00 0.00 0 95,846,616 2.74
redo copy 0     0 96,103,499 0.04
redo writing 3,673,516 0.50 0.00 0 0  
resmgr group change latch 604,430 0.00   0 0  
resmgr:actses active list 22,183 0.43 0.98 0 0  
resmgr:actses change group 21,577 0.00   0 0  
resmgr:free threads list 15,148 1.76 0.00 0 0  
resmgr:schema config 1 0.00   0 0  
row cache objects 92,166,912 0.46 0.00 0 6,715 0.16
rules engine aggregate statistics 30,605 0.07 0.00 0 0  
rules engine rule set statistics 99,538 0.03 0.00 0 0  
rules engine rule statistics 38,339 0.00   0 0  
sequence cache 15,774,663 0.91 0.00 0 0  
session allocation 15,582,921 1.00 0.01 0 0  
session idle bit 73,176,894 0.02 0.01 0 0  
session state list latch 43,349 0.36 0.18 0 0  
session switching 10,649 0.00   0 0  
session timer 1,241 0.00   0 0  
shared pool 6,542,891 0.28 0.03 0 0  
shared pool sim alloc 337 1.19 0.00 0 0  
shared pool simulator 1,982,646 0.00 0.00 0 0  
sim partition latch 1 0.00   0 21,987 0.14
simulator hash latch 2,460 0.00   0 0  
simulator lru latch 1,854 0.00   0 0  
slave class 1 0.00   0 0  
slave class create 4 0.00   0 0  
sort extent pool 1,013,580 0.18 0.00 0 0  
state object free list 12 0.00   0 0  
statistics aggregation 84 0.00   0 0  
temp lob duration state obj allocation 246 0.00   0 0  
temporary table state object allocation 9,167 0.02 0.00 0 0  
threshold alerts latch 606 0.00   0 0  
trace latch 24 0.00   0 0  
transaction allocation 84,771 0.00 0.00 0 0  
transaction branch allocation 107 0.00   0 0  
undo global data 890,380,924 2.02 0.00 0 61,309 0.16
user lock 28,358 0.04 0.00 0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch Name Get Requests Misses Sleeps Spin Gets Sleep1 Sleep2 Sleep3
cache buffers chains 4,488,859,397 76,280,201 2,725,376 73,775,076 0 0 0
In memory undo latch 714,530,210 19,771,295 12,476 19,760,213 0 0 0
undo global data 890,380,924 17,960,696 1,759 17,959,108 0 0 0
library cache 269,262,415 1,345,553 3,946 1,341,957 0 0 0
library cache pin 168,121,193 609,581 1,119 608,537 0 0 0
cache buffer handles 21,741,756 429,369 107 429,274 0 0 0
row cache objects 92,166,912 420,781 578 420,222 0 0 0
redo allocation 4,788,631 191,335 596 190,801 0 0 0
session allocation 15,582,921 156,224 867 155,419 0 0 0
sequence cache 15,774,663 143,603 69 143,544 0 0 0
mostly latch-free SCN 829,328 93,041 169 92,889 0 0 0
object queue header operation 35,858,642 47,734 15,160 33,500 0 0 0
library cache lock 42,943,992 40,388 118 40,275 0 0 0
cache buffers lru chain 9,312,508 36,061 833 35,259 0 0 0
messages 5,262,898 31,067 179 30,889 0 0 0
dml lock allocation 3,315,055 26,595 26 26,570 0 0 0
enqueue hash chains 7,411,885 22,321 10 22,312 0 0 0
shared pool 6,542,891 18,446 556 17,945 0 0 0
redo writing 3,673,516 18,315 38 18,277 0 0 0
active checkpoint queue latch 1,048,463 11,547 7 11,540 0 0 0
session idle bit 73,176,894 11,085 129 10,958 0 0 0
enqueues 3,963,978 7,203 34 7,170 0 0 0
channel operations parent latch 1,315,015 6,621 31 6,592 0 0 0
checkpoint queue latch 21,285,805 3,242 22 3,221 0 0 0
lgwr LWN SCN 730,482 3,192 4 3,188 0 0 0
sort extent pool 1,013,580 1,836 6 1,830 0 0 0
SQL memory manager workarea list latch 5,422,013 862 1 861 0 0 0
object queue header heap 4,494,700 742 105 645 0 0 0
SGA IO buffer pool latch 44,115 588 1 587 0 0 0
channel handle pool latch 292,502 561 16 545 0 0 0
post/wait queue 963,438 475 4 471 0 0 0
parameter table allocation management 17,433 281 251 67 0 0 0
message pool operations parent latch 296,534 273 1 272 0 0 0
parallel query alloc buffer 8,156 271 1 270 0 0 0
parallel query stats 528 207 3 204 0 0 0
session state list latch 43,349 154 27 129 0 0 0
Consistent RBA 726,154 106 2 104 0 0 0
resmgr:actses active list 22,183 95 93 5 0 0 0
KWQMN job cache list latch 12,079 34 22 12 0 0 0
library cache pin allocation 398,688 22 1 21 0 0 0
process allocation 7,638 18 18 0 0 0 0
kks stats 25,394 8 1 7 0 0 0
Memory Management Latch 1,913 1 1 0 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch Name Where NoWait Misses Sleeps Waiter Sleeps
In memory undo latch ktiFlush: child 0 5,539 3,431
In memory undo latch kticmt: child 0 2,775 399
In memory undo latch kturbk 0 2,561 5,190
In memory undo latch ktichg: child 0 1,407 3,380
In memory undo latch ktiTxnPoolFree 0 177 0
In memory undo latch ktbgfc 0 7 76
In memory undo latch ktiBRacquire 0 4 0
KWQMN job cache list latch kwqmnuji: update job item 0 25 5
Memory Management Latch kmgs_perform_parameter_updates1 0 1 2
SGA IO buffer pool latch ksfd_alloc_sgabuffer 0 1 0
SQL memory manager workarea list latch qesmmIRegisterWorkArea 0 1 1
active checkpoint queue latch kcbbacq: scan active checkpoints 0 7 7
cache buffer handles kcbzgs 0 75 67
cache buffer handles kcbzfs 0 32 40
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 3,060,908 3,190,180
cache buffers chains kcbchg: kslbegin: call CR func 0 1,564,787 2,430,432
cache buffers chains kcbgtcr: fast path 0 749,616 65,287
cache buffers chains kcbgtcr: kslbegin excl 0 477,462 364,959
cache buffers chains kcbrls: kslbegin 0 275,343 389,398
cache buffers chains kcbzgb: scan from tail. nowait 0 128,583 0
cache buffers chains kcbgcur: kslbegin 0 43,594 21,144
cache buffers chains kcbget: pin buffer 0 23,010 9,627
cache buffers chains kcbzwb 0 12,339 10,371
cache buffers chains kcbcge 0 8,829 16,781
cache buffers chains kcbget: exchange rls 0 5,054 5,420
cache buffers chains kcbget: exchange 0 4,237 6,156
cache buffers chains kcbnlc 0 1,040 1,832
cache buffers chains kcbbxsv 0 529 516
cache buffers chains kcbso1: set no access 0 219 80
cache buffers chains kcbgtcr: kslbegin shared 0 218 180
cache buffers chains kcb_is_private 0 213 2,657
cache buffers chains kcbesc: escalate 0 75 35
cache buffers chains kcb_pre_apply: kcbhq61 0 67 1,406
cache buffers chains kcbnew: new latch again 0 53 3
cache buffers chains kcb_post_apply: kcbhq63 0 39 266
cache buffers chains kcbbic2 0 22 9
cache buffers chains kcb_post_apply: kcbhq62 0 13 189
cache buffers chains kcbw_next_free 0 5 0
cache buffers chains kcbzib: exchange rls 0 4 1
cache buffers chains kcbzib: finish free bufs 0 4 3
cache buffers chains kcbzhngcbk1: get hash chain latch no wait 0 2 0
cache buffers chains kcbzib: multi-block read: nowait 0 2 0
cache buffers chains kcbo_ivd_process 0 1 20
cache buffers lru chain kcbzgws 0 331 0
cache buffers lru chain kcbbxsv: move to being written 0 232 402
cache buffers lru chain kcbo_link_q 0 163 12
cache buffers lru chain kcbzgb: posted for free bufs 0 41 147
cache buffers lru chain kcbgtcr:CR Scan:KCBRSKIP 0 30 0
cache buffers lru chain kcbbic2 0 22 179
cache buffers lru chain kcbo_ivd_proc 0 5 38
cache buffers lru chain kcbzswcu 0 5 36
cache buffers lru chain kcbo_write_process:free_unlink 0 2 0
cache buffers lru chain kcbzfw 0 2 0
channel handle pool latch ksrchconnect() 0 35 34
channel handle pool latch ksrchdelete() 0 9 11
channel operations parent latch ksrapublish() 0 28 9
channel operations parent latch ksrchdelete() 0 24 16
channel operations parent latch ksrchconnect() 0 6 11
channel operations parent latch ksrsconsume() 0 6 11
channel operations parent latch ksrwait() 0 6 29
checkpoint queue latch kcbkubc 0 9 8
checkpoint queue latch kcbklbc: Link buffer into ckpt queue 0 7 1
checkpoint queue latch kcbbwthc: thread checkpoint buffers 0 4 8
checkpoint queue latch kcbkllrba: compute lowest lrba 0 2 0
client/application info kqp327i 0 1 1
dml lock allocation ktaiam 0 17 8
dml lock allocation ktaidm 0 9 18
enqueue hash chains ksqrcl 0 6 4
enqueue hash chains ksqgtl3 0 3 3
enqueue hash chains ksqcmi: if deadlock detected 0 1 0
enqueues ksqgel: create enqueue 0 14 6
enqueues ksqdel 0 12 5
enqueues ksqies 0 8 23
kks stats kks stats alloc/free 0 1 1
lgwr LWN SCN kcs023 0 47 0
library cache kglpndl: child: after processing 0 1,513 72
library cache kglpnp: child 0 1,331 1,876
library cache kglobpn: child: 0 387 688
library cache kglpndl: child: before processing 0 179 1,041
library cache kglScanDependency 0 165 0
library cache kglLockCursor 0 78 118
library cache kgldte: child 0 0 43 61
library cache kglhdgn: child: 0 41 55
library cache kglpin 0 31 15
library cache kgldti: 2child 0 27 5
library cache kglhdgc: child: 0 11 0
library cache kglic 0 7 0
library cache kgldrp: child 0 1 0
library cache kgldtld: 2child 0 1 2
library cache kglget: unpin heap 0 0 1 1
library cache kglrtl 0 1 1
library cache kglupd: child 0 1 0
library cache lock kgllkdl: child: cleanup 0 80 77
library cache lock kgllkal: child: multiinstance 0 38 41
library cache lock kgllkdl: child: no lock handle 0 26 6
library cache pin kglpndl 0 549 336
library cache pin kglpnp: child 0 481 564
library cache pin kglpnal: child: alloc space 0 89 219
library cache pin allocation kglpnget 0 1 1
message pool operations parent latch ksrmalloc() 0 2 2
messages ksarcv: after wait 0 83 143
messages ksarcv 0 77 14
messages ksaamb: after wakeup 0 19 25
mostly latch-free SCN kcslcu3 0 122 173
mostly latch-free SCN kcs024 0 4 0
mostly latch-free SCN kcs01 0 1 2
mostly latch-free SCN kcsnew_scn_rba 0 1 0
object queue header heap kcbo_link_q:reget 0 101 1
object queue header heap kcbw_link_q:alloc 0 4 109
object queue header operation kcbo_ivbo 0 16,510 6,167
object queue header operation kcbw_link_q 0 2,295 1,536
object queue header operation kcbw_unlink_q 0 687 3,143
object queue header operation kcbo_switch_mq_bg 0 485 2,269
object queue header operation kcbo_switch_q_bg 0 366 1,459
object queue header operation kcbo_switch_cq 0 74 1,911
object queue header operation kcbo_write_q 0 29 3
object queue header operation kcbo_link_q:reget 0 14 99
object queue header operation kcbo_swap_buf_bg 0 8 3,550
object queue header operation kcbo_service_ockpt 0 6 0
object queue header operation kcbw_unlink_q_bg 0 3 14
parallel query alloc buffer kxfpbalo 0 1 1
parallel query stats kxfprst: KSLBEGIN:1 0 3 3
parameter table allocation management ksp_param_table_free 0 250 250
parameter table allocation management kspallmod 0 1 0
post/wait queue ksliwat:remove 0 4 4
process allocation ksucrp 0 17 0
process allocation ksudlp 0 1 3
redo allocation kcrfw_redo_gen: redo allocation 1 0 442 0
redo allocation kcrfw_redo_gen: redo allocation 3 0 90 458
redo allocation kcrfw_redo_gen: redo allocation 2 0 43 0
redo allocation kcrfw_redo_write: more space 0 13 95
redo allocation kcrfw_redo_write: before write 0 8 51
redo writing kcrfwcr 0 31 35
redo writing kcrfw_post: rba scn pair 0 6 0
redo writing kcrfw_post: after write 0 1 3
resmgr:actses active list kgskchclass 0 93 49
row cache objects kqreqd: reget 0 439 12
row cache objects kqrpre: find obj 0 103 342
row cache objects kqreqd 0 27 220
row cache objects kqrso 0 5 2
sequence cache kdnssd 0 53 4
sequence cache kdnnxt: cached seq 0 10 1
sequence cache kdnss 0 6 64
session allocation ksuxds: KSUSFCLC not set 0 489 116
session allocation ksuprc 0 104 151
session allocation ksucri 0 93 193
session allocation ksudlc 0 69 217
session allocation ksuxds: not user session 0 61 111
session allocation kxfpqidqr 0 17 45
session allocation kspallmod 0 13 0
session allocation ksursi 0 12 27
session allocation ksudlp 0 6 3
session allocation kxfprdp 0 3 3
session idle bit ksupuc: set busy 0 131 54
session idle bit ksupuc: clear busy 0 59 136
session idle bit ksuxds 0 7 7
session state list latch kpseqd 0 24 0
session state list latch kpscad 0 2 4
session state list latch kpseqa 0 1 37
shared pool kghupr1 0 300 401
shared pool kghalo 0 202 102
shared pool kghfrunp: clatch: nowait 0 97 0
shared pool kghfrunp: alloc: wait 0 22 0
shared pool kghfre 0 13 43
shared pool kghalp 0 11 7
shared pool kghfrunp: clatch: wait 0 8 5
shared pool kghfrunp: alloc: cursor dur 0 7 0
shared pool kghasp 0 1 3
sort extent pool ktstdt: dealloc sort extent 0 6 1
undo global data kturimugur: child 0 1,430 1,209
undo global data ktudba: KSLBEGIN 0 275 547
undo global data ktusmasp: ktugd_tuux 0 18 0
undo global data ktucof: at start 0 14 0
undo global data ktudnx:child 0 8 0
undo global data ktufrbs: child 0 8 0
undo global data ktubnd:child 0 3 0

Back to Latch Statistics
Back to Top

 

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

 

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

 

Segment Statistics

Back to Top

Segments by Logical Reads

Owner Tablespace Name Object Name Subobject Name Obj. Type Logical Reads %Total
AR APPS_TS_TX_INTERFACE RA_INTERFACE_LINES_ALL   TABLE 70,905,664 3.76
INV APPS_TS_TX_IDX MTL_ITEM_CATEGORIES_U1   INDEX 50,351,856 2.67
ONT APPS_TS_TX_DATA OE_ORDER_LINES_ALL   TABLE 22,027,456 1.17
WSH APPS_TS_TX_DATA WSH_DELIVERY_DETAILS   TABLE 21,132,976 1.12
GL APPS_TS_TX_DATA GL_CODE_COMBINATIONS   TABLE 19,390,688 1.03

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,032 7.89
AR APPS_ASSM_DATA RA_CUSTOMER_TRX_LINES_ALL   TABLE 13,007 2.93
WSH APPS_TS_TX_DATA WSH_DELIVERY_DETAILS   TABLE 9,554 2.15
HR APPS_TS_TX_IDX PAY_PERSON_LATEST_BALA_N50   INDEX 4,777 1.08
HR APPS_ASSM_DATA PAY_RUN_RESULTS   TABLE 4,047 0.91

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,135 26.62
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_U1   INDEX 9,863 23.58
APPLSYS APPS_TS_TX_IDX WF_ITEM_ACTIVITY_STATUSES_N1   INDEX 8,657 20.70
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N6   INDEX 2,895 6.92
HR APPS_ASSM_IDX PAY_RUN_RESULT_VALUES_PK   INDEX 1,928 4.61

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 20 29.85
APPLSYS APPS_TS_TX_IDX WF_ITEM_ATTRIBUTE_VALUES_PK   INDEX 16 23.88
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N5   INDEX 4 5.97
APPLSYS APPS_TS_TX_IDX WF_ITEM_ACTIVITY_STATUSES_N1   INDEX 4 5.97
GL APPS_ASSM_IDX GL_IMPORT_REFERENCES_N1   INDEX 3 4.48

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 185,769 33.52
APPLSYS APPS_TS_TX_DATA WF_ITEM_ATTRIBUTE_VALUES   TABLE 116,742 21.07
SYS SYSTEM DBMS_LOCK_ALLOCATED   TABLE 34,069 6.15
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N6   INDEX 24,539 4.43
APPLSYS APPS_TS_TX_DATA WF_ITEM_ACTIVITY_STATUSES WF_ITEM49 TABLE PARTITION 20,697 3.73

Back to Segment Statistics
Back to Top

 

Dictionary Cache Stats

Cache Get Requests Pct Miss Scan Reqs Pct Miss Mod Reqs Final Usage
dc_awr_control 5 20.00 0   2 1
dc_constraints 648 47.22 0   648 0
dc_files 6,660 0.00 0   0 111
dc_global_oids 5,466,610 0.00 0   0 51
dc_histogram_data 5,476 6.79 0   0 673
dc_histogram_defs 318,308 3.03 0   4,044 5,022
dc_object_grants 51,120 0.10 0   0 68
dc_object_ids 9,177,384 0.02 0   58 1,063
dc_objects 134,950 1.30 0   347 861
dc_profiles 7,124 0.00 0   0 1
dc_rollback_segments 20,948 0.02 0   15 278
dc_segments 275,962 0.67 0   14,877 1,450
dc_sequences 46,411 0.16 0   46,411 106
dc_table_scns 16,833 0.05 0   0 5
dc_tablespace_quotas 14,727 0.19 0   211 40
dc_tablespaces 4,417,127 0.00 0   0 22
dc_usernames 369,330 0.01 0   0 18
dc_users 10,779,610 0.00 0   0 64
outstanding_alerts 268 16.42 0   1 43


Back to Top

 

Library Cache Activity

Namespace Get Requests Pct Miss Pin Requests Pct Miss Reloads Invali- dations
BODY 470,208 0.03 32,118,004 -0.00 9 0
CLUSTER 99 1.01 228 0.88 1 0
INDEX 11,138 0.57 11,950 0.78 0 0
JAVA DATA 620 0.00 0   0 0
PIPE 35,609 2.53 52,242 1.74 0 0
SQL AREA 5,531 91.05 90,751,428 -0.03 2,760 375
TABLE/PROCEDURE 297,540 0.33 44,378,917 -0.00 1,090 0
TRIGGER 21,317 0.12 1,256,930 0.00 29 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 25,712.76   11.18 6.74 37 37 2,299 2,299
  Freeable 2,412.44 0.00 1.23 0.77 9   1,967 1,967
  SQL 2,393.82 1,223.91 1.04 0.68 4 21 2,291 2,289
  PL/SQL 1,648.62 138.97 0.72 0.93 3 3 2,299 2,299
  JAVA 186.24 185.29 2.22 0.35 5 8 84 84
E Other 31,815.86   13.76 8.38 42 42 2,312 2,312
  Freeable 3,116.69 0.00 1.52 0.94 9   2,056 2,056
  SQL 2,878.40 1,506.75 1.25 0.76 5 21 2,304 2,302
  PL/SQL 1,962.95 159.71 0.85 0.97 3 3 2,312 2,312
  JAVA 186.19 185.25 2.22 0.35 5 8 84 84

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions Begin Size (Bytes) End Size (Bytes) (if different)
Database Buffers 18,991,808,512 18,840,813,568
Fixed Size 2,111,120  
Redo Buffers 14,663,680  
Variable Size 2,466,253,168 2,617,248,112

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 33.03 32.70 -0.99
shared KGLS heap 22.57   -100.00
shared KTI-UNDO 53.19 53.19 0.00
shared PL/SQL MPCODE 66.79 69.23 3.66
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 343.07 362.27 5.60
shared library cache 608.78 742.68 21.99
shared parameter table block 41.87 41.95 0.18
shared private strands 99.77 99.77 0.00
shared sessions 36.42 36.42 0.00
shared sql area 340.43 345.79 1.58
shared trace buffer 35.98 36.36 1.04
  buffer_cache 18,112.00 17,968.00 -0.80
  fixed_sga 2.01 2.01 0.00
  log_buffer 13.98 13.98 0.00

Back to Memory Statistics
Back to Top

 

Streams Statistics

Back to Top

 

Streams CPU/IO Usage

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

Rule Set

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

 

Resource Limit Stats

No data exists for this section of the report.


Back to Top

 

init.ora Parameters

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


Back to Top

End of Report