AWR Report

WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
VIS187584551VIS110.2.0.3.0NOhpdb1

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:115-Feb-08 09:45:203582 205.0
End Snap:215-Feb-08 10:45:263596 238.0
Elapsed:  60.09 (mins)  
DB Time:  496.19 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 18,240M 18,096MStd Block Size: 8K
Shared Pool Size: 2,144M 2,288MLog Buffer: 14,320K

Load Profile

Per SecondPer Transaction
Redo size: 8,346,812.95 32,071.41
Logical reads: 509,917.13 1,959.28
Block changes: 51,490.32 197.84
Physical reads: 124.93 0.48
Physical writes: 814.49 3.13
User calls: 9,386.44 36.07
Parses: 1,887.54 7.25
Hard parses: 1.99 0.01
Sorts: 2,317.99 8.91
Logons: 2.13 0.01
Executes: 22,593.53 86.81
Transactions: 260.26 

% Blocks changed per Read: 10.10Recursive Call %: 79.66
Rollback per transaction %: 18.94Rows per Sort: 12.76

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.95Redo NoWait %: 100.00
Buffer Hit %: 99.98In-memory Sort %: 100.00
Library Hit %: 99.79Soft Parse %: 99.89
Execute to Parse %: 91.65Latch Hit %: 98.72
Parse CPU to Parse Elapsd %: 84.59% Non-Parse CPU: 97.83

Shared Pool Statistics

BeginEnd
Memory Usage %: 84.40 84.72
% SQL with executions>1: 89.45 89.34
% Memory for SQL w/exec>1: 67.07 65.96

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
CPU time  23,675  79.5 
db file sequential read 257,143 2,995 12 10.1User I/O
log file sync 379,744 890 2 3.0Commit
db file scattered read 15,998 489 31 1.6User I/O
SQL*Net more data from client 1,779,829 465 0 1.6Network

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
sql execute elapsed time 25,736.23 86.45
DB CPU 23,675.37 79.52
PL/SQL execution elapsed time 5,535.00 18.59
inbound PL/SQL rpc elapsed time 5,516.98 18.53
parse time elapsed 676.97 2.27
Java execution elapsed time 645.20 2.17
hard parse elapsed time 308.74 1.04
repeated bind elapsed time 87.61 0.29
sequence load elapsed time 17.87 0.06
connection management call elapsed time 11.92 0.04
PL/SQL compilation elapsed time 10.04 0.03
hard parse (sharing criteria) elapsed time 4.55 0.02
failed parse elapsed time 1.41 0.00
hard parse (bind mismatch) elapsed time 1.18 0.00
DB time 29,771.49  
background elapsed time 1,481.70  
background cpu time 501.45  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
User I/O 314,399 0.05 3,878 12 0.34
Commit 379,744 0.00 890 2 0.40
Concurrency 2,389,562 0.24 641 0 2.55
Application 52,413 0.33 581 11 0.06
Network 38,819,629 0.00 544 0 41.37
System I/O 677,613 0.00 329 0 0.72
Other 139,050 34.34 107 1 0.15
Configuration 7,713 0.01 13 2 0.01

Back to Wait Events Statistics
Back to Top

Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
db file sequential read 257,143 0.00 2,995 12 0.27
log file sync 379,744 0.00 890 2 0.40
db file scattered read 15,998 0.00 489 31 0.02
SQL*Net more data from client 1,779,829 0.00 465 0 1.90
buffer busy waits 838,419 0.04 437 1 0.89
enq: RO - fast object reuse 160 78.75 386 2410 0.00
log file parallel write 646,395 0.00 324 1 0.69
local write wait 1,557 9.63 232 149 0.00
read by other session 37,056 0.01 163 4 0.04
enq: UL - contention 1,982 1.87 125 63 0.00
latch: cache buffers chains 1,477,872 0.00 66 0 1.57
cursor: pin S wait on X 5,752 93.53 59 10 0.01
rdbms ipc reply 28 92.86 54 1931 0.00
enq: TX - row lock contention 405 1.73 50 123 0.00
SQL*Net message to client 35,463,929 0.00 47 0 37.79
SQL*Net more data to client 1,575,871 0.00 33 0 1.68
library cache load lock 782 0.00 29 37 0.00
enq: TX - index contention 31,232 0.00 29 1 0.03
PX Deq Credit: send blkd 21,673 0.00 23 1 0.02
SQL*Net break/reset to client 49,858 0.00 12 0 0.05
enq: HW - contention 2,936 0.00 11 4 0.00
latch: library cache 11,432 0.00 10 1 0.01
enq: TM - contention 8 25.00 8 1060 0.00
kksfbc child completion 113 85.84 5 43 0.00
control file parallel write 1,859 0.00 4 2 0.00
latch: undo global data 7,390 0.00 4 0 0.01
latch: In memory undo latch 16,038 0.00 3 0 0.02
os thread startup 76 0.00 3 40 0.00
latch free 4,680 0.00 3 1 0.00
latch: library cache pin 3,464 0.00 2 1 0.00
latch: object queue header operation 16,059 0.00 2 0 0.02
wait list latch free 181 0.00 2 11 0.00
PX Deq: Signal ACK 275 23.27 2 6 0.00
latch: cache buffers lru chain 1,405 0.00 2 1 0.00
buffer deadlock 47,542 98.59 2 0 0.05
enq: DV - contention 171 0.00 1 9 0.00
LGWR wait for redo copy 25,466 0.00 1 0 0.03
enq: TX - contention 2,694 0.00 1 1 0.00
latch: redo allocation 2,497 0.00 1 0 0.00
latch: row cache objects 1,191 0.00 1 1 0.00
latch: session allocation 1,716 0.00 1 1 0.00
enq: SQ - contention 4,113 0.00 1 0 0.00
log file switch completion 47 0.00 1 18 0.00
row cache lock 905 0.00 1 1 0.00
enq: TX - allocate ITL entry 158 0.00 1 3 0.00
SGA: allocation forcing component growth 46 71.74 0 11 0.00
PX qref latch 720 91.25 0 1 0.00
library cache pin 1,428 0.00 0 0 0.00
write complete waits 8 12.50 0 32 0.00
enq: FB - contention 932 0.00 0 0 0.00
control file sequential read 29,347 0.00 0 0 0.03
cursor: pin S 4,654 0.00 0 0 0.00
reliable message 33 0.00 0 7 0.00
latch: object queue header heap 383 0.00 0 1 0.00
latch: shared pool 428 0.00 0 0 0.00
latch: cache buffer handles 223 0.00 0 1 0.00
latch: library cache lock 188 0.00 0 1 0.00
latch: messages 86 0.00 0 1 0.00
log file sequential read 6 0.00 0 7 0.00
latch: redo writing 451 0.00 0 0 0.00
cursor: mutex S 119 0.00 0 0 0.00
latch: enqueue hash chains 23 0.00 0 0 0.00
cursor: mutex X 236 0.00 0 0 0.00
latch: checkpoint queue latch 8 0.00 0 0 0.00
direct path read 1,830 0.00 0 0 0.00
enq: CU - contention 1 0.00 0 3 0.00
enq: PS - contention 49 0.00 0 0 0.00
enq: US - contention 1 0.00 0 2 0.00
direct path write 771 0.00 0 0 0.00
log file single write 6 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
L1 validation 1 0.00 0 0 0.00
SQL*Net message from client 35,463,916 0.00 6,983,862 197 37.79
pipe get 21,908 21.07 21,063 961 0.02
Streams AQ: waiting for messages in the queue 2,389 100.00 11,658 4880 0.00
PX Idle Wait 3,284 76.49 5,180 1577 0.00
Streams AQ: qmn slave idle wait 129 0.00 3,517 27263 0.00
Streams AQ: qmn coordinator idle wait 258 50.00 3,517 13631 0.00
Streams AQ: waiting for time management or cleanup tasks 2,221 38.63 3,513 1582 0.00
PL/SQL lock timer 260 99.62 2,859 10995 0.00
jobq slave wait 612 99.51 1,792 2927 0.00
PX Deq: Execution Msg 11,497 0.00 64 6 0.01
PX Deq: Msg Fragment 9,341 0.00 3 0 0.01
PX Deq Credit: need buffer 3,718 0.00 3 1 0.00
PX Deq: Execute Reply 4,272 0.00 2 1 0.00
PX Deq: Table Q Normal 8,191 0.00 1 0 0.01
PX Deq: Parse Reply 318 0.00 0 1 0.00
PX Deq: Join ACK 205 0.00 0 0 0.00
class slave wait 1 0.00 0 1 0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
log file parallel write 646,399 0.00 324 1 0.69
db file scattered read 189 0.00 6 31 0.00
control file parallel write 1,859 0.00 4 2 0.00
events in waitclass Other 35,017 0.00 3 0 0.04
os thread startup 60 0.00 2 41 0.00
db file sequential read 127 0.00 2 14 0.00
latch: cache buffers chains 37 0.00 0 1 0.00
log file sequential read 6 0.00 0 7 0.00
latch: redo writing 451 0.00 0 0 0.00
control file sequential read 1,019 0.00 0 0 0.00
direct path read 1,830 0.00 0 0 0.00
log file sync 1 0.00 0 1 0.00
latch: shared pool 2 0.00 0 0 0.00
log file single write 6 0.00 0 0 0.00
direct path write 666 0.00 0 0 0.00
buffer busy waits 6 0.00 0 0 0.00
latch: library cache pin 1 0.00 0 0 0.00
latch: library cache 1 0.00 0 0 0.00
rdbms ipc message 957,368 1.05 30,235 32 1.02
pmon timer 1,245 98.15 3,518 2826 0.00
Streams AQ: qmn slave idle wait 129 0.00 3,517 27263 0.00
Streams AQ: qmn coordinator idle wait 258 50.00 3,517 13631 0.00
Streams AQ: waiting for time management or cleanup tasks 2,221 38.63 3,513 1582 0.00
smon timer 110,961 0.00 3,500 32 0.12

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
BUSY_TIME 2,602,998
IDLE_TIME 3,159,677
IOWAIT_TIME 176,689
NICE_TIME 24,344
SYS_TIME 167,761
USER_TIME 2,320,535
LOAD 5
RSRC_MGR_CPU_WAIT_TIME 0
PHYSICAL_MEMORY_BYTES 33,680
NUM_CPUS 16
NUM_CPU_SOCKETS 4

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical ReadsLogical Reads
SYS$USERS 29,764.10 23,670.60 439,838 1,835,664,722
SYS$BACKGROUND 0.00 0.00 10,477 2,750,458
VIS 0.00 0.00 0 0

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

Service NameUser I/O Total WtsUser I/O Wt TimeConcurcy Total WtsConcurcy Wt TimeAdmin Total WtsAdmin Wt TimeNetwork Total WtsNetwork Wt Time
SYS$USERS 311579 387071 2389439 63818 0 0 38808378 54444
SYS$BACKGROUND 2814 769 107 252 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 IdSQL ModuleSQL Text
913 905 300 3.04 3.07 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
606 16 1,608 0.38 2.04 3dssuqfjsynrk asn.lead.server.LeadUwqAM SELECT count(1) FROM (SELECT *...
576 106 1,608 0.36 1.93 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
516 509 54,779 0.01 1.73 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
492 441 75,489 0.01 1.65 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
477 153 10,000 0.05 1.60 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
469 382 135,421 0.00 1.58 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
462 456 54,753 0.01 1.55 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...
451 445 54,777 0.01 1.52 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
426 3 56 7.60 1.43 9k7t8q4kfcb7y SQL*Plus begin GL.apps_ddl.apps_ddl(:dd...
395 393 250,190 0.00 1.33 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
395 392 63,632 0.01 1.33 auzgm2ap4faw2 JDBC Thin Client (SELECT SUB.GUID SUB_GUID, DE...
361 260 178,061 0.00 1.21 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
340 153 14,428 0.02 1.14 1q78dwnrrkf6c asn.lead.server.LeadUwqAM BEGIN ASN_SALES_PVT.Lead_Proce...
332 327 61,003 0.01 1.11 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
325 304 960 0.34 1.09 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...

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 IdSQL ModuleSQL Text
905 913 300 3.02 3.07 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
509 516 54,779 0.01 1.73 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
456 462 54,753 0.01 1.55 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...
445 451 54,777 0.01 1.52 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
441 492 75,489 0.01 1.65 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
393 395 250,190 0.00 1.33 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
392 395 63,632 0.01 1.33 auzgm2ap4faw2 JDBC Thin Client (SELECT SUB.GUID SUB_GUID, DE...
382 469 135,421 0.00 1.58 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
327 332 61,003 0.01 1.11 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
304 325 960 0.32 1.09 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
260 361 178,061 0.00 1.21 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
153 340 14,428 0.01 1.14 1q78dwnrrkf6c asn.lead.server.LeadUwqAM BEGIN ASN_SALES_PVT.Lead_Proce...
153 477 10,000 0.02 1.60 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
106 576 1,608 0.07 1.93 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
16 606 1,608 0.01 2.04 3dssuqfjsynrk asn.lead.server.LeadUwqAM SELECT count(1) FROM (SELECT *...
3 426 56 0.06 1.43 9k7t8q4kfcb7y SQL*Plus begin GL.apps_ddl.apps_ddl(:dd...

Back to SQL Statistics
Back to Top

SQL ordered by Gets

Buffer Gets Executions Gets per Exec %TotalCPU Time (s)Elapsed Time (s) SQL IdSQL ModuleSQL Text
154,609,170 63,632 2,429.74 8.41 392.26 394.54 auzgm2ap4faw2 JDBC Thin Client (SELECT SUB.GUID SUB_GUID, DE...
50,983,873 135,421 376.48 2.77 381.69 469.18 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
49,501,029 178,061 278.00 2.69 259.95 361.11 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
48,884,721 54,779 892.40 2.66 508.71 515.98 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
42,139,016 300 140,463.39 2.29 905.24 913.37 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
34,792,380 54,777 635.16 1.89 444.59 451.10 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
30,757,598 166,006 185.28 1.67 226.40 232.70 gf1u933c95jb5 INVTTMTX DECLARE l_ret_stat varchar2...
30,734,080 165,952 185.20 1.67 242.56 248.94 3b3psftuyks81 INVTTMTX BEGIN INV_TXNSTUB_PUB.postTran...
29,083,420 4,810 6,046.45 1.58 177.65 266.54 8jb36w62w5hqf ibuSRDetailsActions.jsp BEGIN IBU_REQ_PKG.UpdateServic...
28,496,267 1,367,169 20.84 1.55 157.03 158.39 66tmsr3446uqn ap.oie.server.WebExpensesAM SELECT WIAS.ACTIVITY_STATUS, ...
26,396,111 10,000 2,639.61 1.44 152.71 476.63 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
25,274,754 11 2,297,704.91 1.37 137.45 137.45 bp8crdjba8zgt ARGLTP update ra_cust_trx_line_gl_dis...
23,569,103 61,003 386.36 1.28 327.00 331.62 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
22,723,860 54,753 415.02 1.24 456.16 461.98 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical ReadsExecutionsReads per Exec %TotalCPU Time (s)Elapsed Time (s) SQL IdSQL ModuleSQL Text
45,235 10,000 4.52 10.04 152.71 476.63 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
43,071 1,608 26.79 9.56 15.51 606.16 3dssuqfjsynrk asn.lead.server.LeadUwqAM SELECT count(1) FROM (SELECT *...
31,440 1,608 19.55 6.98 106.27 576.00 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
26,190 4,744 5.52 5.81 5.22 200.72 auudu2jzbt9s0 CSCCCCRC SELECT HD.ID CONTRACT_ID , HD....
21,900 14,428 1.52 4.86 153.03 340.37 1q78dwnrrkf6c asn.lead.server.LeadUwqAM BEGIN ASN_SALES_PVT.Lead_Proce...
13,330 178,061 0.07 2.96 259.95 361.11 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
11,601 2,728 4.25 2.58 14.54 177.88 72cqcsuq5wgh0 asn.dashboard.server.DashboardAM SELECT aslrt.meaning as rank_n...
11,213 481 23.31 2.49 121.19 201.73 dk0sqcvc2xjvs qotSCopHdrUpd.jsp BEGIN ASO_QUOTE_PUB_W.Create_Q...
10,332 4,810 2.15 2.29 177.65 266.54 8jb36w62w5hqf ibuSRDetailsActions.jsp BEGIN IBU_REQ_PKG.UpdateServic...
10,277 135,421 0.08 2.28 381.69 469.18 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
4,600 9,999 0.46 1.02 193.93 231.76 csvvv0fmhr1yc PYUSLV BEGIN FFP1893_01010001.FORMULA...
4,511 10,000 0.45 1.00 161.22 195.25 63t8zpm02skgh PYUSLV SELECT DECODE(COUNT(PRR.RUN_RE...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows ProcessedRows per ExecCPU per Exec (s)Elap per Exec (s) SQL IdSQL ModuleSQL Text
1,367,169 708,194 0.52 0.00 0.00 66tmsr3446uqn ap.oie.server.WebExpensesAM SELECT WIAS.ACTIVITY_STATUS, ...
779,854 779,828 1.00 0.00 0.00 cd9mbmqyf4qhp ap.oie.server.WebExpensesAM UPDATE WF_ITEM_ACTIVITY_STATUS...
727,444 727,393 1.00 0.00 0.00 gnhmcahkmrnzs ap.oie.server.WebExpensesAM INSERT INTO WF_ITEM_ACTIVITY_S...
425,176 182,983 0.43 0.00 0.00 0wrz2kbatczjk CSCCCCRC SELECT EXECUTE_FLAG FROM JTF_U...
402,534 402,535 1.00 0.00 0.00 avc1jqzz04wpr JDBC Thin Client SELECT 'x' FROM DUAL
251,282 196,270 0.78 0.00 0.00 fmfdkztk8vx23   SELECT CATEGORY, SEVERITY, F...
250,190 250,182 1.00 0.00 0.00 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
197,021 3,349,185 17.00 0.00 0.00 cwyx16zn1hpfb JDBC Thin Client select parameter, value from ...
178,061 0 0.00 0.00 0.00 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
166,006 165,994 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 CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
402,538 402,534 5.91 avc1jqzz04wpr JDBC Thin Client SELECT 'x' FROM DUAL
251,283 251,282 3.69 fmfdkztk8vx23   SELECT CATEGORY, SEVERITY, F...
250,194 250,190 3.68 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
197,022 197,021 2.89 cwyx16zn1hpfb JDBC Thin Client select parameter, value from ...
165,288 165,994 2.43 6gnth2mfbs2nq INVTTMTX declare v_ret number := 0...
135,422 135,421 1.99 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
116,403 116,817 1.71 fb13x9qx0ftks OEXOETEL begin OE_STANDARD_WF.OEOL_SELE...
111,002 111,241 1.63 1c0b7sas42w2z INVTTMTX SELECT NVL(ITEM_COST, 0), ...
87,408 87,546 1.28 76sw2a4vnc89j icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.S...
83,466 83,492 1.23 bf7uwg5pa3pj6 icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.V...
83,461 87,538 1.23 dcvv68fju01g4 icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.E...
83,439 83,524 1.23 608c0n36kaw62 icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.C...
80,329 80,328 1.18 162ttnv4ubqun OEXOETEL begin OE_DS_PVT.Check_PO_Appr...
74,300 74,309 1.09 8camsgjsr9zya OEXOETEL begin OE_TRANSACTION_TYPES_PK...
69,996 69,995 1.03 97mt0g20bcfc3 PYUSLV begin ...

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 IdSQL Text
0wrz2kbatczjkSELECT EXECUTE_FLAG FROM JTF_USER_HOOKS WHERE PKG_NAME = :B4 AND API_NAME = :B3 AND PROCESSING_TYPE = :B2 AND USER_HOOK_TYPE = :B1
0z318y6g3uagcdeclare 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
1q78dwnrrkf6cBEGIN 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;
25wzrzwd46a44SELECT 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 )
3b3psftuyks81BEGIN 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 ) )
4yak7x2zqz0dhBEGIN inv_transfer_order_pvt.finalize_pick_confirm(:1, :2, :3, :4, :5, :6, :7); END;
608c0n36kaw62begin FND_FLEX_WORKFLOW_APIS.COPY_FROM_COMBINATION (:v1, :v2, :v3, :v4, :v5); end;
63t8zpm02skghSELECT 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
66tmsr3446uqnSELECT 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;
6h2tpcxpymqu7BEGIN :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;
72cqcsuq5wgh0 SELECT aslrt.meaning as rank_name , aslrt.rank_id, sum(case when asl.status_open_flag = 'Y' AND round(sysdate-asl.creation_date)<= 2 THEN 1 else 0 END) as day0_2, sum(case when asl.status_open_flag = 'Y' AND round((sysdate - asl.creation_date)) between 3 and 7 THEN 1 else 0 END) as day3_7, sum(case when asl.status_open_flag = 'Y' AND round((sysdate - asl.creation_date)) between 8 and 30 THEN 1 else 0 END) as day8_30, sum(case when asl.status_open_flag = 'Y' AND round((sysdate - asl.creation_date)) >= 31 THEN 1 else 0 END) as day_31, sum(case when nvl(asl.status_open_flag, 'N') = 'N' AND asl.status_code <> 'CONVERTED_TO_OPPORTUNITY' THEN 1 ELSE 0 END) as closed, sum(case when asl.status_code = 'CONVERTED_TO_OPPORTUNITY' THEN 1 ELSE 0 END) as converted, round((sum(case when asl.status_code = 'CONVERTED_TO_OPPORTUNITY' THEN 1 ELSE 0 END)/count(asl.sales_lead_id)) * 100, 2) as conversion, count(aslrt.rank_id) total_leads FROM as_sales_leads asl, as_sales_lead_ranks_tl aslrt, as_sales_lead_ranks_b aslrb, ( SELECT /*+ no_merge */ distinct aaa.sales_lead_id , aaa.customer_id FROM as_accesses_all aaa WHERE aaa.lead_id is null AND aaa.sales_lead_id IS NOT NULL AND aaa.salesforce_id = :1)secu WHERE asl.lead_rank_id = aslrt.rank_id AND aslrb.rank_id = aslrt.rank_id AND aslrt.language = USERENV('LANG') AND secu.sa les_lead_id = asl.sales_lead_id AND secu.customer_id = asl.customer_id GROUP BY aslrt.rank_id, aslrt.meaning, aslrb.min_score ORDER BY aslrb.min_score DESC
76sw2a4vnc89jbegin FND_FLEX_WORKFLOW_APIS.START_GENERATION (:v1, :v2, :v3, :v4, :v5); end;
827gtfny5uagbbegin :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;
8jb36w62w5hqfBEGIN IBU_REQ_PKG.UpdateServiceRequest(:1, :2, -1, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16); END;
97mt0g20bcfc3 begin pay_US_rules.get_default_jurisdiction (:asgact, :eeid, :defval:defvalind); end;
9k7t8q4kfcb7ybegin GL.apps_ddl.apps_ddl(:ddl_text); end;
9wdrypwkpf607begin OE_FULFILL_WF.START_FULFILLMENT (:v1, :v2, :v3, :v4, :v5); end;
a29grr748ghc4BEGIN jdr_custom_internal.getActiveLayers(:1, :2, :3, :4, :5); END;
auudu2jzbt9s0 SELECT HD.ID CONTRACT_ID , HD.CONTRACT_NUMBER , HD.CONTRACT_NUMBER_MODIFIER , HD.STS_CODE , HD.AUTHORING_ORG_ID , HD.INV_ORGANIZATION_ID , HD.END_DATE HDR_END_DATE , SV.ID SERVICE_LINE_ID , SV.START_DATE SV_START_DATE , OKS_ENTITLEMENTS_PVT.GET_END_DATE_TIME(SV.END_DATE) SV_END_DATE , OKS_ENTITLEMENTS_PVT.GET_END_DATE_TIME(SV.DATE_TERMINATED) SV_DATE_TERMINATED , CL.STS_CODE CL_STS_CODE , CL.ID COVLVL_LINE_ID , CL.START_DATE CL_START_DATE , OKS_ENTITLEMENTS_PVT.GET_END_DATE_TIME(CL.END_DATE) CL_END_DATE , OKS_ENTITLEMENTS_PVT.GET_END_DATE_TIME(CL.DATE_TERMINATED) CL_DATE_TERMINATED , DECODE(SV.LSE_ID, 14, 'Y', 15, 'Y', 16, 'Y', 17, 'Y', 18, 'Y', 'N') WARRANTY_FLAG FROM OKC_K_HEADERS_B HD , OKC_K_LINES_B SV , OKC_K_LINES_B CL WHERE HD.ID = :B3 AND HD.SCS_CODE IN ('SERVICE', 'WARRANTY') AND HD.ID > -1 AND HD.TEMPLATE_YN <> 'Y' AND SV.DNZ_CHR_ID = HD.ID AND SV.CLE_ID IS NULL AND SV.CHR_ID = HD.ID AND SV.LSE_ID IN (1, 14, 19) AND CL.CLE_ID = SV.ID AND CL.LSE_ID IN (7, 8, 9, 10, 11, 35, 18, 25) AND CL.ID = :B2 AND (:B1 IS NULL OR EXISTS (SELECT '*' FROM OKC_K_ITEMS ITM , OKC_K_LINES_B BPL , OKC_K_LINES_B CV WHERE CV.CLE_ID = SV.ID AND CV.LSE_ID IN (2, 15, 20) AND BPL.CLE_ID = CV.ID AND ITM.CLE_ID = BPL.ID AND ITM.OBJECT1_ID1||'' = TO_CHAR(:B1 ) AND ITM.OBJECT1_ID2 = '#' AND ITM.JTOT_OBJECT1_CODE||'' = 'OKX_BUSIPROC' ))
auzgm2ap4faw2 (SELECT SUB.GUID SUB_GUID, DECODE(SUB.RULE_FUNCTION, NULL, DECODE(SUB.JAVA_RULE_FUNC, NULL, NULL, :B5 || SUB.JAVA_RULE_FUNC), SUB.RULE_FUNCTION) RULE_FUNC, SUB.SOURCE_TYPE SOURCE_TYPE, NVL(SUB.PHASE, 0) PHASE, SUB.RULE_DATA RULE_DATA, SUB.PRIORITY PRIORITY FROM WF_EVENT_SUBSCRIPTIONS SUB, WF_EVENTS EVT WHERE SUB.SYSTEM_GUID = :B4 AND SUB.STATUS = 'ENABLED' AND SUB.LICENSED_FLAG = 'Y' AND SUB.SOURCE_TYPE = :B3 AND ((SUB.SOURCE_AGENT_GUID IS NOT NULL AND SUB.SOURCE_AGENT_GUID = NVL(:B2 , SUB.SOURCE_AGENT_GUID)) OR SUB.SOURCE_AGENT_GUID IS NULL) AND SUB.EVENT_FILTER_GUID = EVT.GUID AND EVT.NAME IN (:B1 , 'oracle.apps.wf.event.any') AND EVT.TYPE = 'EVENT' AND EVT.STATUS = 'ENABLED' AND EVT.LICENSED_FLAG = 'Y') UNION ALL (SELECT SUB.GUID SUB_GUID, DECODE(SUB.RULE_FUNCTION, NULL, DECODE(SUB.JAVA_RULE_FUNC, NULL, NULL, :B5 || SUB.JAVA_RULE_FUNC), SUB.RULE_FUNCTION) RULE_FUNC, SUB.SOURCE_TYPE SOURCE_TYPE, NVL(SUB.PHASE, 0) PHASE, SUB.RULE_DATA RULE_DATA, SUB.PRIORITY PRIORITY FROM WF_EVENT_SUBSCRIPTIONS SUB, WF_EVENT_GROUPS EGRP, WF_EVENTS GRP, WF_EVENTS EVT WHERE SUB.SYSTEM_GUID = :B4 AND SUB.STATUS = 'ENABLED' AND SUB.LICENSED_FLAG = 'Y' AND SUB.SOURCE_TYPE = :B3 AND ((SUB.SOURCE_AGENT_GUID IS NOT NULL AND SUB.SOURCE_AGENT_GUID = NVL(:B2 , SUB.SOURCE_AGENT_GUID)) OR SUB.SOURCE_AGENT_GUID IS NULL) AND GRP.GUID = SUB.EVENT_FILTER_GUID AND GRP.TYPE = 'GROUP' AND GRP.STATUS = 'ENABLED' AND EGRP.GROUP_GUID = GRP.GUID AND EGRP.MEMBER_GUID = EVT.GUID AND EVT.NA ME = :B1 AND EVT.TYPE = 'EVENT' AND EVT.STATUS = 'ENABLED' AND EVT.LICENSED_FLAG = 'Y') ORDER BY 4
avc1jqzz04wprSELECT 'x' FROM DUAL
bf7uwg5pa3pj6begin FND_FLEX_WORKFLOW_APIS.VALIDATE_COMBINATION (:v1, :v2, :v3, :v4, :v5); end;
bp8crdjba8zgtupdate ra_cust_trx_line_gl_dist set gl_posted_date=:b0, posting_control_id=:b1, last_update_date=sysdate , last_updated_by=:b2 where (cust_trx_line_gl_dist_id in (select to_number(reference23) from gl_interface where ((((user_je_source_name=:b3 and set_of_books_id=:b4) and group_id=:b1) and (reference30||'')='RA_CUST_TRX_LINE_GL_DIST') and accounting_date between to_date((:b6||' 00:00:00'), 'DD-MON-RR HH24:MI:SS') and to_date((:b7||' 23:59:59'), 'DD-MON-RR HH24:MI:SS'))) and set_of_books_id=:b4)
bt0w082dfrm8vBEGIN WSH_SHIP_CONFIRM_ACTIONS.interface_ALL_wrp( :errbuf, :rc, :A0, :A1, :A2, :A3); END;
cd9mbmqyf4qhpUPDATE 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
csvvv0fmhr1ycBEGIN 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;
cwyx16zn1hpfbselect parameter, value from nls_session_parameters
dcvv68fju01g4begin FND_FLEX_WORKFLOW_APIS.END_GENERATION (:v1, :v2, :v3, :v4, :v5); end;
dk0sqcvc2xjvsBEGIN 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;
fb13x9qx0ftksbegin OE_STANDARD_WF.OEOL_SELECTOR (:v1, :v2, :v3, :v4, :v5); end;
fmfdkztk8vx23SELECT CATEGORY, SEVERITY, FND_LOG_SEVERITY FROM FND_NEW_MESSAGES WHERE MESSAGE_NAME = :B1 AND APPLICATION_ID = :B2 AND LANGUAGE_CODE = :B3 AND ROWNUM = 1
g8102j8yynbwzbegin WF_STANDARD.CONTINUEFLOW (:v1, :v2, :v3, :v4, :v5); end;
gf1u933c95jb5DECLARE 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;
gksvm8wmzk8w0begin OE_INVOICE_WF.INVOICE_INTERFACE (:v1, :v2, :v3, :v4, :v5); end;
gnhmcahkmrnzsINSERT INTO WF_ITEM_ACTIVITY_STATUSES ( ITEM_TYPE, ITEM_KEY, PROCESS_ACTIVITY, ACTIVITY_STATUS, ACTIVITY_RESULT_CODE, ASSIGNED_USER, NOTIFICATION_ID, BEGIN_DATE, END_DATE, DUE_DATE, EXECUTION_TIME, OUTBOUND_QUEUE_ID ) VALUES ( :B13 , :B12 , :B11 , :B6 , :B10 , NULL, NULL, :B9 , :B8 , :B7 , DECODE(:B6 , :B5 , :B2 , :B4 , :B2 , :B3 , :B2 , NULL), :B1 )

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
CPU used by this session 2,362,922 655.33 2.52
CPU used when call started 2,359,151 654.28 2.51
CR blocks created 14,290,600 3,963.34 15.23
Cached Commit SCN referenced 46,162 12.80 0.05
Commit SCN cached 8 0.00 0.00
DB time 6,960,777 1,930.49 7.42
DBWR checkpoint buffers written 2,886,350 800.50 3.08
DBWR checkpoints 37 0.01 0.00
DBWR object drop buffers written 27,304 7.57 0.03
DBWR revisited being-written buffer 13 0.00 0.00
DBWR thread checkpoint buffers written 1,012,168 280.71 1.08
DBWR transaction table writes 1,898 0.53 0.00
DBWR undo block writes 1,497,394 415.29 1.60
DFO trees parallelized 48 0.01 0.00
IMU CR rollbacks 25,562,927 7,089.60 27.24
IMU Flushes 288,219 79.93 0.31
IMU Redo allocation size 1,917,917,372 531,913.22 2,043.80
IMU commits 490,711 136.09 0.52
IMU contention 32,604 9.04 0.03
IMU ktichg flush 7,992 2.22 0.01
IMU pool not allocated 1,107 0.31 0.00
IMU recursive-transaction flush 1,360 0.38 0.00
IMU undo allocation size 4,387,703,696 1,216,881.21 4,675.69
IMU- failed to get a private strand 1,107 0.31 0.00
PX local messages recv'd 67,293 18.66 0.07
PX local messages sent 67,293 18.66 0.07
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 35,457,546 9,833.76 37.78
active txn count during cleanout 88,041,280 24,417.28 93.82
application wait time 58,091 16.11 0.06
background checkpoints completed 6 0.00 0.00
background checkpoints started 5 0.00 0.00
background timeouts 11,453 3.18 0.01
branch node splits 1,029 0.29 0.00
buffer is not pinned count 692,410,482 192,032.41 737.86
buffer is pinned count 1,452,328,188 402,787.20 1,547.65
bytes received via SQL*Net from client 7,897,837,228 2,190,378.01 8,416.21
bytes sent via SQL*Net to client 7,410,474,664 2,055,213.38 7,896.86
calls to get snapshot scn: kcmgss 91,281,269 25,315.85 97.27
calls to kcmgas 17,894,255 4,962.77 19.07
calls to kcmgcs 14,443,185 4,005.66 15.39
change write time 63,046 17.49 0.07
cleanout - number of ktugct calls 27,376,261 7,592.50 29.17
cleanouts and rollbacks - consistent read gets 12,487,938 3,463.39 13.31
cleanouts only - consistent read gets 133,663 37.07 0.14
cluster key scan block gets 803,825 222.93 0.86
cluster key scans 227,258 63.03 0.24
commit batch/immediate performed 3,764 1.04 0.00
commit batch/immediate requested 3,764 1.04 0.00
commit cleanout failures: block lost 207,727 57.61 0.22
commit cleanout failures: buffer being written 3,808 1.06 0.00
commit cleanout failures: callback failure 103,937 28.83 0.11
commit cleanout failures: cannot pin 30,046 8.33 0.03
commit cleanouts 8,084,965 2,242.28 8.62
commit cleanouts successfully completed 7,739,447 2,146.45 8.25
commit immediate performed 3,764 1.04 0.00
commit immediate requested 3,764 1.04 0.00
commit txn count during cleanout 1,170,694 324.68 1.25
concurrency wait time 64,069 17.77 0.07
consistent changes 609,944,592 169,161.40 649.98
consistent gets 1,625,242,090 450,742.96 1,731.91
consistent gets - examination 1,075,179,586 298,189.19 1,145.75
consistent gets from cache 1,625,242,083 450,742.96 1,731.91
cursor authentications 1,822 0.51 0.00
data blocks consistent reads - undo records applied 606,892,059 168,314.82 646.73
db block changes 185,658,445 51,490.32 197.84
db block gets 213,363,938 59,174.13 227.37
db block gets direct 4,184 1.16 0.00
db block gets from cache 213,359,754 59,172.97 227.36
deferred (CURRENT) block cleanout applications 1,378,361 382.27 1.47
dirty buffers inspected 9,213 2.56 0.01
enqueue conversions 8,806 2.44 0.01
enqueue releases 3,571,263 990.45 3.81
enqueue requests 3,578,281 992.40 3.81
enqueue timeouts 6,897 1.91 0.01
enqueue waits 37,916 10.52 0.04
exchange deadlocks 47,547 13.19 0.05
execute count 81,465,418 22,593.53 86.81
failed probes on index block reclamation 11,814 3.28 0.01
free buffer inspected 2,448,303 679.01 2.61
free buffer requested 18,397,266 5,102.28 19.60
heap block compress 27,466,777 7,617.61 29.27
hot buffers moved to head of LRU 965,498 267.77 1.03
immediate (CR) block cleanout applications 12,621,619 3,500.47 13.45
immediate (CURRENT) block cleanout applications 1,048,894 290.90 1.12
index crx upgrade (found) 47,964 13.30 0.05
index crx upgrade (positioned) 8,016,352 2,223.25 8.54
index fast full scans (rowid ranges) 1,580 0.44 0.00
index fetch by key 193,407,514 53,639.44 206.10
index scans kdiixs1 128,076,714 35,520.66 136.48
java call heap collected bytes 1,224,462,832 339,591.26 1,304.83
java call heap collected count 15,238,947 4,226.35 16.24
java call heap gc count 4,158 1.15 0.00
java call heap live object count 1,452,991 402.97 1.55
java call heap live object count max 1,513,153 419.66 1.61
java call heap live size 357,201,568 99,065.91 380.65
java call heap live size max 368,954,072 102,325.34 393.17
java call heap object count 3,573,133 990.97 3.81
java call heap object count max 3,589,607 995.54 3.83
java call heap total size 462,422,016 128,247.64 492.77
java call heap total size max 477,102,080 132,319.00 508.42
java call heap used size 494,204,216 137,062.09 526.64
java call heap used size max 502,340,600 139,318.62 535.31
leaf node 90-10 splits 18,324 5.08 0.02
leaf node splits 230,141 63.83 0.25
lob reads 15,572 4.32 0.02
lob writes 27,701 7.68 0.03
lob writes unaligned 27,701 7.68 0.03
logons cumulative 7,677 2.13 0.01
messages received 1,089,818 302.25 1.16
messages sent 1,089,818 302.25 1.16
no buffer to keep pinned count 16 0.00 0.00
no work - consistent read gets 508,140,611 140,927.19 541.49
opened cursors cumulative 4,316,648 1,197.17 4.60
parse count (failures) 2,404 0.67 0.00
parse count (hard) 7,190 1.99 0.01
parse count (total) 6,805,891 1,887.54 7.25
parse time cpu 51,366 14.25 0.05
parse time elapsed 60,724 16.84 0.06
physical read IO requests 275,132 76.30 0.29
physical read bytes 3,690,135,552 1,023,418.38 3,932.34
physical read total IO requests 304,595 84.48 0.32
physical read total bytes 4,171,860,992 1,157,019.61 4,445.68
physical read total multi block requests 15,987 4.43 0.02
physical reads 450,456 124.93 0.48
physical reads cache 448,440 124.37 0.48
physical reads cache prefetch 175,144 48.57 0.19
physical reads direct 2,016 0.56 0.00
physical reads direct temporary tablespace 186 0.05 0.00
physical reads prefetch warmup 109,533 30.38 0.12
physical write IO requests 1,353,439 375.36 1.44
physical write bytes 24,058,437,632 6,672,342.21 25,637.50
physical write total IO requests 2,021,758 560.71 2.15
physical write total bytes 55,535,312,896 15,402,106.25 59,180.35
physical write total multi block requests 1,279,972 354.99 1.36
physical writes 2,936,821 814.49 3.13
physical writes direct 5,036 1.40 0.01
physical writes direct (lob) 230 0.06 0.00
physical writes direct temporary tablespace 4,061 1.13 0.00
physical writes from cache 2,931,785 813.10 3.12
physical writes non checkpoint 2,172,855 602.62 2.32
pinned buffers inspected 3,456 0.96 0.00
prefetch clients - default 1 0.00 0.00
prefetch warmup blocks aged out before use 242,568 67.27 0.26
prefetched blocks aged out before use 118 0.03 0.00
process last non-idle time 3,605 1.00 0.00
queries parallelized 48 0.01 0.00
recursive calls 132,542,329 36,759.15 141.24
recursive cpu usage 1,365,254 378.64 1.45
redo blocks written 61,299,810 17,000.83 65.32
redo buffer allocation retries 33 0.01 0.00
redo entries 95,816,482 26,573.64 102.11
redo log space requests 49 0.01 0.00
redo log space wait time 84 0.02 0.00
redo ordering marks 1,171,877 325.01 1.25
redo size 30,096,070,076 8,346,812.95 32,071.41
redo subscn max counts 2,272,535 630.26 2.42
redo synch time 91,689 25.43 0.10
redo synch writes 1,640,240 454.90 1.75
redo wastage 262,793,048 72,882.75 280.04
redo write time 40,418 11.21 0.04
redo writer latching time 156 0.04 0.00
redo writes 646,465 179.29 0.69
rollback changes - undo records applied 339,074 94.04 0.36
rollbacks only - consistent read gets 1,953,207 541.70 2.08
rows fetched via callback 110,504,049 30,647.08 117.76
session connect time 0 0.00 0.00
session cursor cache hits 4,408,025 1,222.52 4.70
session logical reads 1,838,606,145 509,917.13 1,959.28
session pga memory 9,080,503,256 2,518,377.38 9,676.50
session pga memory max 11,293,634,232 3,132,164.84 12,034.89
session uga memory ############### 74,592,486.10 286,610.76
session uga memory max 54,313,471,184 15,063,241.93 57,878.31
shared hash latch upgrades - no wait 28,519,926 7,909.69 30.39
shared hash latch upgrades - wait 73,191 20.30 0.08
sorts (memory) 8,357,965 2,317.99 8.91
sorts (rows) 106,688,255 29,588.81 113.69
sql area evicted 1,999 0.55 0.00
sql area purged 2,573 0.71 0.00
summed dirty queue length 59,000 16.36 0.06
switch current to new buffer 1,226,022 340.02 1.31
table fetch by rowid 912,955,512 253,198.14 972.88
table fetch continued row 32,356,217 8,973.64 34.48
table scan blocks gotten 54,112,606 15,007.53 57.66
table scan rows gotten 1,569,769,824 435,358.34 1,672.80
table scans (long tables) 4,134 1.15 0.00
table scans (rowid ranges) 4,132 1.15 0.00
table scans (short tables) 4,302,180 1,193.16 4.58
total number of times SMON posted 110,967 30.78 0.12
transaction rollbacks 3,764 1.04 0.00
transaction tables consistent read rollbacks 84 0.02 0.00
transaction tables consistent reads - undo records applied 6,055 1.68 0.01
undo change vector size 10,480,410,984 2,906,626.34 11,168.29
user I/O wait time 388,036 107.62 0.41
user calls 33,844,642 9,386.44 36.07
user commits 760,720 210.98 0.81
user rollbacks 177,688 49.28 0.19
workarea executions - onepass 2 0.00 0.00
workarea executions - optimal 4,728,104 1,311.29 5.04
write clones created in background 1,410 0.39 0.00
write clones created in foreground 35,240 9.77 0.04

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session cursor cache count 282,317 789,630
opened cursors current 734,273 855,745
workarea memory allocated 430 86
logons current 3,582 3,596

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived) 3 3.00

Back to Instance Activity Statistics
Back to Top

IO Stats

Back to Top

Tablespace IO Stats

TablespaceReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
APPS_UNDOTS1 95 0 4.53 1.00 561,544 156 288,961 0.04
APPS_TS_TX_DATA 172,101 48 13.10 1.36 191,616 53 151,629 0.35
APPS_ASSM_DATA 8,503 2 7.72 6.71 259,458 72 49,336 1.08
APPS_TS_TX_IDX 78,171 22 13.12 1.60 148,054 41 80,111 0.56
APPS_ASSM_IDX 6,218 2 8.08 1.05 135,957 38 265,794 0.16
APPS_TS_TX_INTERFACE 1,082 0 2.82 2.21 28,730 8 17,633 0.06
TEMP 279 0 6.74 15.36 8,872 2 491 821.04
SYSTEM 4,977 1 8.02 3.02 2,358 1 17,700 0.12
APPS_TS_SEED 2,154 1 15.10 2.08 4,808 1 733 6.23
APPS_TS_SUMMARY 144 0 1.11 1.00 4,537 1 2,546 0.03
APPS_TS_QUEUES 374 0 10.53 2.11 4,282 1 346 3.55
SYSAUX 364 0 7.64 1.19 1,397 0 0 0.00
APPS_TS_ARCHIVE 70 0 7.00 1.41 1,579 0 48 5.00
APPS_TS_NOLOGGING 51 0 6.47 1.24 72 0 2 0.00
CTXSYS 64 0 1.72 1.00 12 0 0 0.00
APPS_TS_MEDIA 36 0 2.78 1.00 18 0 0 0.00
ODM 32 0 1.25 1.00 6 0 0 0.00
OLAP 32 0 1.56 1.00 6 0 0 0.00
OWAPUB 32 0 0.94 1.00 6 0 0 0.00
PORTAL 32 0 0.94 1.00 6 0 0 0.00
SYNCSERVER 32 0 1.25 1.00 6 0 0 0.00

Back to IO Stats
Back to Top

File IO Stats

TablespaceFilenameReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
APPS_ASSM_DATA /DB/visdata/apps_assm_data.dbf 8,503 2 7.72 6.71 259,458 72 49,336 1.08
APPS_ASSM_IDX /DB/visdata/apps_assm_idx.dbf 6,218 2 8.08 1.05 135,957 38 265,794 0.16
APPS_TS_ARCHIVE /DB/visdata/archive1.dbf 30 0 8.33 1.23 1,328 0 44 5.45
APPS_TS_ARCHIVE /DB/visdata/archive2.dbf 40 0 6.00 1.55 251 0 4 0.00
APPS_TS_MEDIA /DB/visdata/media1.dbf 12 0 4.17 1.00 6 0 0 0.00
APPS_TS_MEDIA /DB/visdata/media2.dbf 12 0 2.50 1.00 6 0 0 0.00
APPS_TS_MEDIA /DB/visdata/media3.dbf 12 0 1.67 1.00 6 0 0 0.00
APPS_TS_NOLOGGING /DB/visdata/nologging1.dbf 12 0 2.50 1.00 6 0 0 0.00
APPS_TS_NOLOGGING /DB/visdata/nologging2.dbf 23 0 10.43 1.00 49 0 0 0.00
APPS_TS_NOLOGGING /DB/visdata/nologging3.dbf 16 0 3.75 1.75 17 0 2 0.00
APPS_TS_QUEUES /DB/visdata/queues1.dbf 57 0 6.32 1.63 525 0 144 0.63
APPS_TS_QUEUES /DB/visdata/queues2.dbf 29 0 7.24 2.38 747 0 159 0.44
APPS_TS_QUEUES /DB/visdata/queues3.dbf 31 0 10.32 2.48 624 0 6 0.00
APPS_TS_QUEUES /DB/visdata/queues4.dbf 42 0 7.14 2.29 555 0 0 0.00
APPS_TS_QUEUES /DB/visdata/queues5.dbf 31 0 9.35 3.52 566 0 3 0.00
APPS_TS_QUEUES /DB/visdata/queues6.dbf 38 0 11.32 2.53 506 0 0 0.00
APPS_TS_QUEUES /DB/visdata/queues7.dbf 146 0 13.90 1.70 759 0 34 31.47
APPS_TS_SEED /DB/visdata/reference1.dbf 205 0 15.02 2.58 489 0 45 8.89
APPS_TS_SEED /DB/visdata/reference10.dbf 195 0 15.44 2.22 529 0 52 6.73
APPS_TS_SEED /DB/visdata/reference2.dbf 202 0 15.89 1.84 497 0 29 5.52
APPS_TS_SEED /DB/visdata/reference3.dbf 319 0 12.23 1.89 576 0 425 5.86
APPS_TS_SEED /DB/visdata/reference4.dbf 213 0 14.74 2.25 442 0 39 5.13
APPS_TS_SEED /DB/visdata/reference5.dbf 222 0 20.81 1.94 445 0 13 10.77
APPS_TS_SEED /DB/visdata/reference6.dbf 223 0 12.06 2.40 480 0 31 11.61
APPS_TS_SEED /DB/visdata/reference7.dbf 194 0 13.20 2.00 433 0 24 8.75
APPS_TS_SEED /DB/visdata/reference8.dbf 195 0 20.10 2.03 476 0 43 3.95
APPS_TS_SEED /DB/visdata/reference9.dbf 186 0 12.85 1.75 441 0 32 2.81
APPS_TS_SUMMARY /DB/visdata/summary1.dbf 16 0 1.25 1.00 529 0 381 0.03
APPS_TS_SUMMARY /DB/visdata/summary2.dbf 15 0 0.67 1.00 464 0 221 0.00
APPS_TS_SUMMARY /DB/visdata/summary3.dbf 22 0 1.36 1.00 519 0 209 0.00
APPS_TS_SUMMARY /DB/visdata/summary4.dbf 19 0 2.11 1.00 438 0 335 0.06
APPS_TS_SUMMARY /DB/visdata/summary5.dbf 18 0 0.00 1.00 648 0 346 0.03
APPS_TS_SUMMARY /DB/visdata/summary6.dbf 18 0 1.11 1.00 610 0 572 0.03
APPS_TS_SUMMARY /DB/visdata/summary7.dbf 18 0 0.56 1.00 708 0 236 0.04
APPS_TS_SUMMARY /DB/visdata/summary8.dbf 18 0 1.67 1.00 621 0 246 0.04
APPS_TS_TX_DATA /DB/visdata/tx_data1.dbf 3,234 1 16.07 1.41 260 0 2 10.00
APPS_TS_TX_DATA /DB/visdata/tx_data10.dbf 3,007 1 16.53 1.33 116 0 0 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data11.dbf 2,968 1 16.99 1.36 93 0 1 70.00
APPS_TS_TX_DATA /DB/visdata/tx_data12.dbf 12,704 4 9.28 1.25 2,196 1 3,534 1.67
APPS_TS_TX_DATA /DB/visdata/tx_data13.dbf 17,254 5 14.73 1.53 3,624 1 2,093 2.08
APPS_TS_TX_DATA /DB/visdata/tx_data14.dbf 12,819 4 9.35 1.40 29,724 8 20,414 0.30
APPS_TS_TX_DATA /DB/visdata/tx_data15.dbf 9,166 3 11.83 1.45 27,170 8 19,975 0.27
APPS_TS_TX_DATA /DB/visdata/tx_data16.dbf 9,283 3 11.11 1.48 26,037 7 21,064 0.26
APPS_TS_TX_DATA /DB/visdata/tx_data17.dbf 9,249 3 11.22 1.49 25,145 7 19,839 0.30
APPS_TS_TX_DATA /DB/visdata/tx_data18.dbf 9,224 3 11.29 1.46 24,427 7 21,188 0.27
APPS_TS_TX_DATA /DB/visdata/tx_data19.dbf 9,001 2 11.23 1.47 24,312 7 20,201 0.26
APPS_TS_TX_DATA /DB/visdata/tx_data2.dbf 6,738 2 10.50 1.18 556 0 1,647 1.73
APPS_TS_TX_DATA /DB/visdata/tx_data20.dbf 9,006 2 12.68 1.51 24,458 7 20,289 0.26
APPS_TS_TX_DATA /DB/visdata/tx_data21.dbf 23,063 6 16.22 1.22 1,513 0 1,342 0.08
APPS_TS_TX_DATA /DB/visdata/tx_data3.dbf 3,257 1 15.28 1.45 304 0 5 18.00
APPS_TS_TX_DATA /DB/visdata/tx_data4.dbf 15,208 4 14.66 1.20 244 0 5 8.00
APPS_TS_TX_DATA /DB/visdata/tx_data5.dbf 3,059 1 14.30 1.26 263 0 9 8.89
APPS_TS_TX_DATA /DB/visdata/tx_data6.dbf 2,989 1 16.60 1.29 148 0 11 7.27
APPS_TS_TX_DATA /DB/visdata/tx_data7.dbf 2,967 1 14.82 1.31 354 0 10 2.00
APPS_TS_TX_DATA /DB/visdata/tx_data8.dbf 3,081 1 16.34 1.25 417 0 0 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data9.dbf 4,824 1 14.71 1.00 255 0 0 0.00
APPS_TS_TX_IDX /DB/visdata/tx_idx1.dbf 2,283 1 9.38 1.24 1,752 0 1,703 1.05
APPS_TS_TX_IDX /DB/visdata/tx_idx10.dbf 2,222 1 9.49 1.28 1,147 0 1,539 0.78
APPS_TS_TX_IDX /DB/visdata/tx_idx11.dbf 2,204 1 8.72 1.30 1,365 0 1,730 1.00
APPS_TS_TX_IDX /DB/visdata/tx_idx12.dbf 8,630 2 16.31 2.04 18,859 5 1,717 0.52
APPS_TS_TX_IDX /DB/visdata/tx_idx13.dbf 7,871 2 10.38 1.44 21,477 6 5,093 0.56
APPS_TS_TX_IDX /DB/visdata/tx_idx14.dbf 4,631 1 21.04 1.80 14,069 4 4,462 0.29
APPS_TS_TX_IDX /DB/visdata/tx_idx15.dbf 4,463 1 13.83 1.72 11,927 3 5,594 0.80
APPS_TS_TX_IDX /DB/visdata/tx_idx16.dbf 4,508 1 15.14 1.77 10,765 3 5,430 0.28
APPS_TS_TX_IDX /DB/visdata/tx_idx17.dbf 4,463 1 12.71 1.71 10,390 3 6,187 0.31
APPS_TS_TX_IDX /DB/visdata/tx_idx18.dbf 4,441 1 14.54 1.76 10,156 3 8,575 0.25
APPS_TS_TX_IDX /DB/visdata/tx_idx19.dbf 4,507 1 18.08 1.80 9,613 3 6,423 0.32
APPS_TS_TX_IDX /DB/visdata/tx_idx2.dbf 2,707 1 12.34 1.58 1,341 0 2,936 0.55
APPS_TS_TX_IDX /DB/visdata/tx_idx20.dbf 4,344 1 13.94 1.75 8,557 2 4,307 0.26
APPS_TS_TX_IDX /DB/visdata/tx_idx21.dbf 2,730 1 17.61 1.95 11,498 3 2,080 1.04
APPS_TS_TX_IDX /DB/visdata/tx_idx3.dbf 3,804 1 8.21 1.21 1,464 0 2,257 1.84
APPS_TS_TX_IDX /DB/visdata/tx_idx4.dbf 2,454 1 9.95 1.26 2,586 1 2,301 1.40
APPS_TS_TX_IDX /DB/visdata/tx_idx5.dbf 2,472 1 8.85 1.28 4,118 1 10,412 0.29
APPS_TS_TX_IDX /DB/visdata/tx_idx6.dbf 2,445 1 8.85 1.27 2,194 1 2,017 1.12
APPS_TS_TX_IDX /DB/visdata/tx_idx7.dbf 2,369 1 9.60 1.27 2,075 1 1,615 1.07
APPS_TS_TX_IDX /DB/visdata/tx_idx8.dbf 2,345 1 9.82 1.32 1,391 0 1,910 0.91
APPS_TS_TX_IDX /DB/visdata/tx_idx9.dbf 2,278 1 10.77 1.35 1,310 0 1,823 0.99
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte.dbf 95 0 5.05 2.58 4,430 1 6,280 0.04
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte2.dbf 229 0 3.32 2.40 5,664 2 3,901 0.04
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte3.dbf 231 0 2.81 2.07 4,912 1 2,945 0.10
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte4.dbf 131 0 2.98 2.60 4,632 1 1,653 0.07
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte5.dbf 152 0 3.42 2.28 4,495 1 1,568 0.09
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte6.dbf 244 0 1.02 1.77 4,597 1 1,286 0.08
APPS_UNDOTS1 /DB/visdata/undo01.dbf 7 0 1.43 1.00 54,215 15 30,650 0.05
APPS_UNDOTS1 /DB/visdata/undo02.dbf 7 0 1.43 1.00 61,722 17 29,919 0.04
APPS_UNDOTS1 /DB/visdata/undo03.dbf 7 0 2.86 1.00 55,603 15 35,448 0.03
APPS_UNDOTS1 /DB/visdata/undo04.dbf 11 0 4.55 1.00 54,247 15 28,108 0.04
APPS_UNDOTS1 /DB/visdata/undo05.dbf 9 0 13.33 1.00 55,796 15 25,865 0.04
APPS_UNDOTS1 /DB/visdata/undo06.dbf 7 0 1.43 1.00 56,816 16 24,710 0.05
APPS_UNDOTS1 /DB/visdata/undo07.dbf 14 0 2.86 1.00 54,187 15 28,030 0.04
APPS_UNDOTS1 /DB/visdata/undo08.dbf 10 0 10.00 1.00 59,084 16 35,551 0.04
APPS_UNDOTS1 /DB/visdata/undo09.dbf 9 0 3.33 1.00 56,573 16 25,608 0.04
APPS_UNDOTS1 /DB/visdata/undo10.dbf 14 0 2.86 1.00 53,301 15 25,072 0.04
CTXSYS /DB/visdata/ctx1.dbf 32 0 2.50 1.00 6 0 0 0.00
CTXSYS /DB/visdata/ctx2.dbf 32 0 0.94 1.00 6 0 0 0.00
ODM /DB/visdata/odm.dbf 32 0 1.25 1.00 6 0 0 0.00
OLAP /DB/visdata/olap.dbf 32 0 1.56 1.00 6 0 0 0.00
OWAPUB /DB/visdata/owa1.dbf 32 0 0.94 1.00 6 0 0 0.00
PORTAL /DB/visdata/portal.dbf 32 0 0.94 1.00 6 0 0 0.00
SYNCSERVER /DB/visdata/mobile01.dbf 32 0 1.25 1.00 6 0 0 0.00
SYSAUX /DB/visdata/sysaux01.dbf 41 0 9.51 1.46 641 0 0 0.00
SYSAUX /DB/visdata/sysaux02.dbf 323 0 7.40 1.16 756 0 0 0.00
SYSTEM /DB/visdata/sys1.dbf 503 0 7.44 2.44 107 0 69 0.14
SYSTEM /DB/visdata/sys2.dbf 569 0 6.89 2.21 176 0 106 0.09
SYSTEM /DB/visdata/sys3.dbf 658 0 6.31 3.27 217 0 23 2.61
SYSTEM /DB/visdata/sys4.dbf 563 0 7.16 3.98 225 0 8 8.75
SYSTEM /DB/visdata/sys5.dbf 814 0 8.46 2.90 657 0 117 0.85
SYSTEM /DB/visdata/sys6.dbf 501 0 10.40 3.99 74 0 7 2.86
SYSTEM /DB/visdata/sys7.dbf 388 0 9.56 4.08 144 0 27 0.37
SYSTEM /DB/visdata/sys8.dbf 373 0 11.82 2.82 397 0 17,307 0.11
SYSTEM /DB/visdata/sys9.dbf 608 0 6.32 1.94 361 0 36 2.22
TEMP /DB/visdata/temp1.dbf 55 0 6.91 4.27 2,484 1 179 792.68
TEMP /DB/visdata/temp2.dbf 74 0 5.14 39.68 2,242 1 128 871.41
TEMP /DB/visdata/temp3.dbf 62 0 6.94 16.56 1,822 1 89 905.39
TEMP /DB/visdata/temp4.dbf 88 0 7.84 1.00 2,324 1 95 727.58

Back to IO Stats
Back to Top

Buffer Pool Statistics

PNumber of BuffersPool Hit%Buffer GetsPhysical ReadsPhysical WritesFree Buff WaitWrit Comp WaitBuffer Busy Waits
D 2,238,249 100 1,819,816,769 448,367 2,931,785 0 0 875,411


Back to Top

Advisory Statistics

Back to Top

Instance Recovery Stats

Targt MTTR (s) Estd MTTR (s)Recovery Estd IOsActual Redo BlksTarget Redo BlksLog File Size Redo BlksLog Ckpt Timeout Redo BlksLog Ckpt Interval Redo Blks
B 180 89 33776 784403 2962467 35156250 2962467  
E 180 116 51725 1167566 8685947 35156250 8685947  

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 ProcessedExtra W/A MB Read/Written
100.00 431,644 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 MemGlobal Mem Bound(K)
B 20,480 1,280 30,518.91 0.55 0.00 100.00 0.00 1,048,576
E 20,480 1,280 37,741.86 2.44 0.01 100.00 0.00 1,048,576

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K 4K 4,287,412 4,287,412 0 0
64K 128K 11,502 11,502 0 0
128K 256K 1,335 1,335 0 0
256K 512K 822 822 0 0
512K 1024K 133,421 133,421 0 0
1M 2M 290,294 290,294 0 0
2M 4M 72 70 2 0
4M 8M 21 21 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 FactrW/A MB ProcessedEstd Extra W/A MB Read/ Written to Disk Estd PGA Cache Hit %Estd PGA Overalloc Count
2,560 0.13 581,013.85 8,453.28 99.00 1,046
5,120 0.25 581,013.85 8,334.94 99.00 1,004
10,240 0.50 581,013.85 8,147.51 99.00 949
15,360 0.75 581,013.85 7,977.86 99.00 899
20,480 1.00 581,013.85 0.00 100.00 829
24,576 1.20 581,013.85 0.00 100.00 553
28,672 1.40 581,013.85 0.00 100.00 0
32,768 1.60 581,013.85 0.00 100.00 0
36,864 1.80 581,013.85 0.00 100.00 0
40,960 2.00 581,013.85 0.00 100.00 0
61,440 3.00 581,013.85 0.00 100.00 0
81,920 4.00 581,013.85 0.00 100.00 0
122,880 6.00 581,013.85 0.00 100.00 0
163,840 8.00 581,013.85 0.00 100.00 0

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

Shared Pool Size(M)SP Size FactrEst LC Size (M)Est LC Mem ObjEst LC Time Saved (s)Est LC Time Saved FactrEst LC Load Time (s)Est LC Load Time FactrEst LC Mem Obj Hits
1,568 0.69 288 12,969 3,321,100 1.00 9,103 7.48 140,435,296
1,808 0.79 496 16,055 3,327,203 1.00 3,000 2.47 140,712,100
2,048 0.90 734 19,540 3,328,861 1.00 1,342 1.10 140,789,037
2,288 1.00 971 25,126 3,328,986 1.00 1,217 1.00 140,795,311
2,528 1.10 1,064 29,839 3,328,986 1.00 1,217 1.00 140,795,371
2,768 1.21 1,071 30,623 3,328,986 1.00 1,217 1.00 140,795,376
3,008 1.31 1,071 30,623 3,328,986 1.00 1,217 1.00 140,795,376
3,248 1.42 1,071 30,623 3,328,986 1.00 1,217 1.00 140,795,376
3,488 1.52 1,071 30,623 3,328,986 1.00 1,217 1.00 140,795,376
3,728 1.63 1,071 30,623 3,328,986 1.00 1,217 1.00 140,795,376
3,968 1.73 1,071 30,623 3,328,986 1.00 1,217 1.00 140,795,376
4,208 1.84 1,071 30,623 3,328,986 1.00 1,217 1.00 140,795,376
4,448 1.94 1,071 30,623 3,328,986 1.00 1,217 1.00 140,795,376
4,688 2.05 1,071 30,623 3,328,986 1.00 1,217 1.00 140,795,376

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
5,120 0.25 36,376  
10,240 0.50 36,376  
15,360 0.75 36,381  
20,480 1.00 36,375  
25,600 1.25 36,390  
30,720 1.50 36,390  
35,840 1.75 36,390  
40,960 2.00 36,391  

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 FactrEst LC Size (M)Est LC Mem ObjEst LC Time Saved (s)Est LC Time Saved FactrEst LC Load Time (s)Est LC Load Time FactrEst LC Mem Obj Hits
16 0.25 7 185 1,430 1.00 1,217 1.00 17,651
32 0.50 7 185 1,430 1.00 1,217 1.00 17,651
48 0.75 7 185 1,430 1.00 1,217 1.00 17,651
64 1.00 7 185 1,430 1.00 1,217 1.00 17,651
80 1.25 7 185 1,430 1.00 1,217 1.00 17,651
96 1.50 7 185 1,430 1.00 1,217 1.00 17,651
112 1.75 7 185 1,430 1.00 1,217 1.00 17,651
128 2.00 7 185 1,430 1.00 1,217 1.00 17,651

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
file header block 479 403 842
data block 577,277 200 0
undo block 231,509 9 0
undo header 57,445 3 0
1st level bmb 5,507 1 0
segment header 2,135 1 0
2nd level bmb 933 0 0
bitmap index block 12 0 1
extent map 7 0 0

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
RO-Multiple Object Reuse (fast object reuse) 288 288 0 32 395 12,334.38
UL-User-defined 65,945 64,946 999 1,930 128 66.29
TX-Transaction (row lock contention) 5,624 382 5,242 369 51 138.05
TX-Transaction (index contention) 28,625 28,624 0 27,154 30 1.09
HW-Segment High Water Mark 200,825 200,818 7 2,483 11 4.51
TM-DML 1,613,218 1,613,121 9 6 9 1,450.00
DV-Diana Versioning 21,678 21,678 0 170 2 9.53
TX-Transaction 1,081,302 1,081,262 0 1,867 2 0.83
SQ-Sequence Cache 36,235 36,235 0 3,087 1 0.33
TX-Transaction (allocate ITL entry) 186 186 0 137 1 3.72
FB-Format Block 35,427 35,427 0 646 0 0.36
PS-PX Process Reservation 3,727 3,087 640 33 0 0.00
CU-Cursor 6,945 6,946 0 1 0 0.00
US-Undo Segment 7,457 7,457 0 1 0 0.00

Back to Wait Statistics
Back to Top

Undo Statistics

Back to Top

Undo Segment Summary

Undo TS#Num Undo Blocks (K)Number of TransactionsMax Qry Len (s)Max Tx ConcurcyMin/Max TR (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
1 1,509.05 1,081,800 2,685 267   0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

End TimeNum Undo BlocksNumber of TransactionsMax Qry Len (s)Max Tx ConcyTun Ret (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
15-Feb 10:43 197,031 140,485 645 258 211 0/0 0/0/0/0/0/0
15-Feb 10:33 56,375 97,710 483 255 217 0/0 0/0/0/0/0/0
15-Feb 10:23 385,604 151,452 2,667 267 201 0/0 0/0/0/0/0/0
15-Feb 10:13 347,854 210,496 2,685 264 246 0/0 0/0/0/0/0/0
15-Feb 10:03 197,312 182,898 2,564 265 332 0/0 0/0/0/0/0/0
15-Feb 09:53 324,869 298,759 2,181 265 410 0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

Back to Top

Latch Activity

Latch NameGet RequestsPct Get MissAvg Slps /MissWait Time (s)NoWait RequestsPct NoWait Miss
ASM db client latch 2,465 0.00   0 0  
AWR Alerted Metric Element list 234,961 0.00   0 0  
Consistent RBA 646,684 0.02 0.40 0 0  
FOB s.o list latch 43,904 0.02 0.00 0 0  
In memory undo latch 564,442,966 2.09 0.00 3 962,109 0.00
JOX SGA heap latch 1,855,976 0.00   0 0  
JS queue state obj latch 21,630 0.00   0 0  
JS slv state obj latch 177 0.00   0 0  
KMG MMAN ready and startup request latch 2,760 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 11,713 0.52 0.95 0 0  
MQL Tracking Latch 0     0 72 0.00
Memory Management Latch 1,716 0.00   0 2,751 0.00
OS process 11,400 0.00   0 0  
OS process allocation 8,815 0.00   0 0  
OS process: request allocation 7,310 0.00   0 0  
PL/SQL warning settings 3,454,033 0.00   0 0  
SGA IO buffer pool latch 63,569 0.00   0 122,480 0.00
SQL memory manager latch 1 0.00   0 1,199 0.00
SQL memory manager workarea list latch 5,127,160 0.01 0.01 0 0  
Shared B-Tree 129 0.00   0 0  
active checkpoint queue latch 442,594 0.00 0.00 0 2 0.00
active service list 40,320 0.26 0.00 0 1,236 0.00
begin backup scn array 152 0.00   0 0  
buffer pool 18 0.00   0 0  
cache buffer handles 21,410,394 1.59 0.00 0 0  
cache buffers chains 4,246,659,281 1.25 0.03 66 16,443,534 2.86
cache buffers lru chain 9,195,757 0.46 0.03 2 32,317,618 0.77
cache table scan latch 1,911 0.00   0 1,911 0.05
channel handle pool latch 282,650 0.07 0.03 0 0  
channel operations parent latch 1,257,231 0.50 0.00 0 0  
checkpoint queue latch 18,780,576 0.01 0.00 0 2,964,470 0.03
client/application info 1,261,661 0.00 0.00 0 0  
commit callback allocation 60,214 0.00   0 0  
compile environment latch 2,143,609 0.00   0 0  
dictionary lookup 78 0.00   0 0  
dml lock allocation 3,213,999 0.32 0.01 0 0  
dummy allocation 15,372 1.10 0.02 0 0  
enqueue hash chains 7,204,279 0.17 0.00 0 960 0.10
enqueues 3,826,794 0.22 0.01 0 0  
error message lists 1,584 3.79 0.00 0 0  
event group latch 3,662 0.00   0 0  
file cache latch 19,915 0.00   0 0  
global KZLD latch for mem in SGA 6,787 0.00   0 0  
global ctx hash table latch 16,338 0.00   0 0  
hash table column usage latch 1,743 0.11 0.00 0 10,848,702 0.00
hash table modification latch 148 0.00   0 0  
internal temp table object number allocation latc 3 0.00   0 0  
job workq parent latch 0     0 122 0.00
job_queue_processes parameter latch 121 0.00   0 0  
kks stats 23,550 0.00 0.00 0 0  
ksuosstats global area 242 0.00   0 0  
ktm global data 110,967 0.00   0 0  
kwqbsn:qsga 129 0.00   0 0  
lgwr LWN SCN 650,028 0.10 0.06 0 0  
library cache 260,451,754 0.55 0.01 10 18,287 162.07
library cache load lock 8,772 0.62 0.00 0 15 0.00
library cache lock 41,234,024 0.08 0.01 0 0  
library cache lock allocation 1,089,515 0.01 0.01 0 0  
library cache pin 162,704,105 0.22 0.01 2 32 0.00
library cache pin allocation 388,236 0.00 0.09 0 0  
list of block allocation 418,386 0.03 0.00 0 0  
loader state object freelist 219,158 0.00 0.00 0 0  
longop free list parent 35 0.00   0 35 0.00
message pool operations parent latch 286,670 0.03 0.03 0 0  
messages 3,307,282 0.06 0.04 0 0  
mostly latch-free SCN 715,098 6.64 0.07 2 0  
multiblock read objects 35,093 0.01 0.00 0 0  
ncodef allocation latch 76 0.00   0 0  
object queue header heap 3,829,290 0.03 0.39 0 293,080 0.07
object queue header operation 29,915,512 0.14 0.38 2 17,642 0.27
object stats modification 280,886 0.03 0.04 0 0  
parallel query alloc buffer 23,520 3.73 0.00 0 0  
parallel query stats 912 23.46 0.05 0 0  
parameter table allocation management 17,198 1.91 0.55 0 0  
post/wait queue 917,829 0.08 0.00 0 379,972 0.02
process allocation 7,358 0.07 1.00 0 3,662 0.00
process group creation 7,310 0.00   0 0  
process queue 15,146 1.26 0.00 0 0  
process queue reference 1,326,491 0.03 0.00 0 100,226 0.72
qmn task queue latch 516 0.00   0 0  
query server freelists 13,488 18.43 0.00 0 0  
query server process 16 0.00   0 16 0.00
redo allocation 4,473,387 4.82 0.01 1 95,553,815 2.72
redo copy 0     0 95,816,027 0.04
redo writing 2,792,860 0.03 0.61 0 0  
resmgr group change latch 579,590 0.00   0 0  
resmgr:actses active list 22,131 0.14 1.00 0 0  
resmgr:actses change group 21,137 0.00   0 0  
resmgr:free threads list 15,370 1.14 0.01 0 0  
resmgr:schema config 1 0.00   0 0  
row cache objects 88,978,719 0.27 0.00 1 7,169 0.13
rules engine aggregate statistics 29,487 0.03 0.00 0 0  
rules engine rule set statistics 96,069 0.02 0.00 0 0  
rules engine rule statistics 37,097 0.00   0 0  
sequence cache 15,665,857 0.99 0.00 0 0  
session allocation 15,106,859 0.68 0.02 1 0  
session idle bit 69,816,840 0.03 0.03 0 0  
session state list latch 42,473 0.21 0.04 0 0  
session switching 10,200 0.00   0 0  
session timer 1,236 0.00   0 0  
shared pool 6,067,736 0.20 0.03 0 0  
shared pool sim alloc 329 0.00   0 0  
shared pool simulator 1,825,744 0.00 0.06 0 0  
sim partition latch 1 0.00   0 24,328 0.07
simulator hash latch 2,460 0.00   0 0  
simulator lru latch 1,242 0.00   0 0  
slave class 1 0.00   0 0  
slave class create 4 0.00   0 0  
sort extent pool 974,249 0.11 0.01 0 0  
state object free list 12 0.00   0 0  
statistics aggregation 84 0.00   0 0  
temp lob duration state obj allocation 216 0.00   0 0  
temporary table state object allocation 8,795 0.00   0 0  
threshold alerts latch 606 0.00   0 0  
trace latch 31 0.00   0 0  
transaction allocation 80,899 0.00 0.00 0 0  
transaction branch allocation 76 0.00   0 0  
undo global data 751,740,391 1.77 0.00 4 12,848 0.10
user lock 27,242 0.00 0.00 0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
cache buffers chains 4,246,659,281 52,913,333 1,477,865 51,536,876 0 0 0
undo global data 751,740,391 13,324,442 7,391 13,317,946 0 0 0
In memory undo latch 564,442,966 11,783,338 16,038 11,769,577 0 0 0
library cache 260,451,754 1,419,920 11,435 1,409,494 0 0 0
library cache pin 162,704,105 364,816 3,464 361,610 0 0 0
cache buffer handles 21,410,394 339,454 223 339,252 0 0 0
row cache objects 88,978,719 243,504 1,191 242,350 0 0 0
redo allocation 4,473,387 215,830 2,497 213,717 0 0 0
sequence cache 15,665,857 155,792 157 155,652 0 0 0
session allocation 15,106,859 102,740 1,716 101,241 0 0 0
mostly latch-free SCN 715,098 47,482 3,394 44,419 0 0 0
object queue header operation 29,915,512 42,485 16,060 27,168 0 0 0
cache buffers lru chain 9,195,757 42,058 1,405 40,704 0 0 0
library cache lock 41,234,024 33,487 188 33,304 0 0 0
session idle bit 69,816,840 20,277 538 19,755 0 0 0
enqueue hash chains 7,204,279 12,466 23 12,443 0 0 0
shared pool 6,067,736 12,268 428 11,868 0 0 0
dml lock allocation 3,213,999 10,360 77 10,290 0 0 0
enqueues 3,826,794 8,455 71 8,386 0 0 0
channel operations parent latch 1,257,231 6,263 29 6,237 0 0 0
query server freelists 13,488 2,486 2 2,484 0 0 0
checkpoint queue latch 18,780,576 2,199 8 2,191 0 0 0
messages 3,307,282 2,142 86 2,060 0 0 0
sort extent pool 974,249 1,070 8 1,064 0 0 0
object queue header heap 3,829,290 993 383 623 0 0 0
redo writing 2,792,860 741 451 291 0 0 0
post/wait queue 917,829 716 2 714 0 0 0
lgwr LWN SCN 650,028 654 42 614 0 0 0
process queue reference 1,326,491 436 1 435 0 0 0
SQL memory manager workarea list latch 5,127,160 401 3 398 0 0 0
parameter table allocation management 17,198 328 180 173 0 0 0
parallel query stats 912 214 10 204 0 0 0
channel handle pool latch 282,650 185 5 180 0 0 0
resmgr:free threads list 15,370 175 2 174 0 0 0
dummy allocation 15,372 169 3 166 0 0 0
Consistent RBA 646,684 121 48 82 0 0 0
message pool operations parent latch 286,670 91 3 88 0 0 0
session state list latch 42,473 89 4 85 0 0 0
library cache lock allocation 1,089,515 77 1 76 0 0 0
object stats modification 280,886 74 3 71 0 0 0
KWQMN job cache list latch 11,713 61 58 3 0 0 0
resmgr:actses active list 22,131 32 32 0 0 0 0
shared pool simulator 1,825,744 31 2 29 0 0 0
library cache pin allocation 388,236 11 1 10 0 0 0
process allocation 7,358 5 5 0 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
In memory undo latch ktiFlush: child 0 5,961 3,790
In memory undo latch kturbk 0 5,527 7,735
In memory undo latch kticmt: child 0 3,293 733
In memory undo latch ktichg: child 0 990 3,713
In memory undo latch ktiTxnPoolFree 0 236 0
In memory undo latch ktiBRacquire 0 21 0
In memory undo latch ktbgfc 0 6 69
KWQMN job cache list latch kwqmnuji: update job item 0 60 5
SQL memory manager workarea list latch qesmmIRegisterWorkArea 0 2 0
SQL memory manager workarea list latch qesmmIUnRegisterWorkArea 0 1 3
cache buffer handles kcbzgs 0 145 137
cache buffer handles kcbzfs 0 78 86
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 1,401,575 1,697,258
cache buffers chains kcbgtcr: fast path 0 625,477 44,322
cache buffers chains kcbchg: kslbegin: call CR func 0 474,197 999,374
cache buffers chains kcbgtcr: kslbegin excl 0 304,833 226,062
cache buffers chains kcbrls: kslbegin 0 182,840 273,155
cache buffers chains kcbzgb: scan from tail. nowait 0 165,443 0
cache buffers chains kcbgcur: kslbegin 0 47,775 23,698
cache buffers chains kcbget: pin buffer 0 28,607 10,848
cache buffers chains kcbget: exchange 0 10,088 14,109
cache buffers chains kcbget: exchange rls 0 9,888 10,703
cache buffers chains kcbzwb 0 9,574 7,651
cache buffers chains kcbcge 0 2,879 6,808
cache buffers chains kcbnlc 0 1,579 1,741
cache buffers chains kcbso1: set no access 0 343 114
cache buffers chains kcbgtcr: kslbegin shared 0 123 101
cache buffers chains kcbesc: escalate 0 111 52
cache buffers chains kcb_is_private 0 108 1,553
cache buffers chains kcbnew: new latch again 0 43 4
cache buffers chains kcbbxsv 0 30 14
cache buffers chains kcbbic2 0 12 6
cache buffers chains kcb_pre_apply: kcbhq61 0 10 1,154
cache buffers chains kcbzhngcbk1: get hash chain latch no wait 0 7 0
cache buffers chains kcb_post_apply: kcbhq62 0 5 256
cache buffers chains kcbgtcr 0 2 0
cache buffers chains kcbw_next_free 0 2 0
cache buffers chains kcb_post_apply: kcbhq63 0 1 184
cache buffers chains kcbo_ivd_process 0 1 7
cache buffers lru chain kcbzgws 0 738 0
cache buffers lru chain kcbo_link_q 0 346 22
cache buffers lru chain kcbgtcr:CR Scan:KCBRSKIP 0 130 0
cache buffers lru chain kcbzgb: posted for free bufs 0 91 340
cache buffers lru chain kcbbxsv: move to being written 0 41 447
cache buffers lru chain kcbzswcu 0 24 57
cache buffers lru chain kcbo_ivd_proc 0 12 182
cache buffers lru chain kcbbic2 0 6 349
cache buffers lru chain kcbzgm 0 5 0
cache buffers lru chain kcbzar: KSLNBEGIN 0 4 0
cache buffers lru chain kcbw_activate_granule 0 2 0
cache buffers lru chain kcbzib 0 2 3
cache buffers lru chain kcbrlb 0 1 2
cache buffers lru chain kcbw_make_free_nowait 0 1 0
cache buffers lru chain kcbzfw 0 1 0
cache buffers lru chain kcbzgpwb: KSLBEGIN use prewarm buffers 0 1 30
channel handle pool latch ksrchconnect() 0 25 23
channel handle pool latch ksrchdelete() 0 1 4
channel operations parent latch ksrapublish() 0 20 5
channel operations parent latch ksrchconnect() 0 7 8
channel operations parent latch ksrchdelete() 0 7 11
channel operations parent latch ksrmfree() 0 6 6
channel operations parent latch ksrsconsume() 0 5 2
channel operations parent latch ksrwait() 0 3 21
checkpoint queue latch kcbswcu: Switch buffers 0 4 3
checkpoint queue latch kcbbwthc: thread checkpoint buffers 0 3 4
checkpoint queue latch kcbklbc: Link buffer into ckpt queue 0 1 0
dml lock allocation ktaiam 0 51 51
dml lock allocation ktaidm 0 26 26
dummy allocation ktcscnfy 0 3 3
enqueue hash chains ksqgtl3 0 12 13
enqueue hash chains ksqrcl 0 11 10
enqueues ksqgel: create enqueue 0 30 13
enqueues ksqies 0 23 47
enqueues ksqdel 0 18 11
lgwr LWN SCN kcs023 0 804 0
library cache kglpndl: child: after processing 0 4,488 303
library cache kglpnp: child 0 4,143 5,547
library cache kglobpn: child: 0 1,136 1,641
library cache kglpndl: child: before processing 0 673 3,168
library cache kglLockCursor 0 257 364
library cache kglScanDependency 0 146 0
library cache kgldte: child 0 0 108 154
library cache kglpin 0 105 44
library cache kglhdgn: child: 0 82 151
library cache kgldti: 2child 0 27 6
library cache kglhdiv0: child 0 24 0
library cache kglic 0 17 0
library cache kglhdiv0: parent: invalidate 0 12 9
library cache kglupd: child 0 5 0
library cache kglhdgc: child: 0 4 0
library cache kglrtl 0 3 0
library cache kgldtld: 2child 0 2 1
library cache kglget: unpin heap 0 0 2 4
library cache kglivl: child 0 2 0
library cache kglobld 0 2 0
library cache kglhdiv: child 0 1 19
library cache kglukp: child 0 1 1
library cache lock kgllkdl: child: cleanup 0 113 124
library cache lock kgllkal: child: multiinstance 0 74 64
library cache lock kgllkdl: child: no lock handle 0 71 14
library cache lock kglhdbrnl: child 0 1 0
library cache lock allocation kgllkget 0 1 1
library cache pin kglpndl 0 1,604 1,149
library cache pin kglpnp: child 0 1,577 1,784
library cache pin kglpnal: child: alloc space 0 283 531
library cache pin allocation kglpnget 0 1 1
message pool operations parent latch ksrmfree() 0 2 0
message pool operations parent latch ksrmalloc() 0 1 3
messages ksaamb: after wakeup 0 46 73
messages ksarcv 0 23 11
messages ksarcv: after wait 0 17 2
mostly latch-free SCN kcslcu3 0 2,591 3,435
mostly latch-free SCN kcs024 0 40 0
mostly latch-free SCN kcs01 0 29 48
mostly latch-free SCN kcsnew_scn_rba 0 19 0
object queue header heap kcbo_link_q:reget 0 377 3
object queue header heap kcbw_link_q:alloc 0 5 380
object queue header heap kcbw_unlink_q 0 1 0
object queue header operation kcbo_ivbo 0 16,727 2,271
object queue header operation kcbw_link_q 0 3,420 1,427
object queue header operation kcbw_unlink_q 0 725 4,040
object queue header operation kcbo_switch_mq_bg 0 207 2,157
object queue header operation kcbo_switch_q_bg 0 151 1,488
object queue header operation kcbo_switch_cq 0 130 2,509
object queue header operation kcbo_link_q:reget 0 67 86
object queue header operation kcbo_swap_buf 0 12 507
object queue header operation kcbo_service_ockpt 0 11 0
object queue header operation kcbo_swap_buf_bg 0 9 7,573
object queue header operation kcbo_write_q 0 8 0
object queue header operation kcbw_unlink_q_bg 0 1 15
object stats modification ksoslinelm 0 3 2
parallel query stats kxfprst: KSLBEGIN:1 0 10 10
parameter table allocation management ksp_param_table_free 0 180 180
post/wait queue ksliwat:remove 0 2 1
process allocation ksucrp 0 4 0
process allocation ksudlp 0 1 4
process queue reference kxfpqrsnd 0 1 0
query server freelists kxfpobrmf 0 2 2
redo allocation kcrfw_redo_gen: redo allocation 1 0 1,340 0
redo allocation kcrfw_redo_gen: redo allocation 3 0 533 2,318
redo allocation kcrfw_redo_write: before write 0 253 99
redo allocation kcrfw_redo_write: more space 0 230 95
redo allocation kcrfw_redo_gen: redo allocation 2 0 141 0
redo writing kcrfw_post: after write 0 346 0
redo writing kcrfw_post: rba scn pair 0 91 0
redo writing kcrfw_cal_target_rba 0 14 0
resmgr:actses active list kgskchclass 0 32 11
resmgr:free threads list kgskthrsod 0 2 2
row cache objects kqreqd: reget 0 966 3
row cache objects kqrpre: find obj 0 162 817
row cache objects kqreqd 0 59 369
row cache objects kqrso 0 4 3
sequence cache kdnssd 0 114 12
sequence cache kdnnxt: cached seq 0 29 2
sequence cache kdnss 0 14 143
session allocation ksuxds: KSUSFCLC not set 0 714 324
session allocation ksursi 0 186 395
session allocation ksuprc 0 184 210
session allocation ksucri 0 143 217
session allocation ksuxds: not user session 0 130 100
session allocation ksudlc 0 124 282
session allocation kxfprdp 0 115 49
session allocation kxfpqidqr 0 96 135
session allocation ksudlp 0 14 1
session allocation kspallmod 0 9 0
session allocation ksusin 0 1 2
session idle bit ksupuc: set busy 0 501 200
session idle bit ksupuc: clear busy 0 211 502
session idle bit ksuxds 0 27 37
session state list latch kpseqd 0 4 0
shared pool kghalo 0 205 111
shared pool kghupr1 0 166 272
shared pool kghfrunp: clatch: nowait 0 119 0
shared pool kghfre 0 26 35
shared pool kghfrunp: alloc: wait 0 25 1
shared pool kghalp 0 5 8
shared pool kghfrunp: clatch: wait 0 5 9
shared pool kghasp 0 1 1
shared pool simulator kglsim_unpin_simhp 0 2 2
sort extent pool ktstdt: dealloc sort extent 0 4 3
sort extent pool ktstdt: return extent 0 3 0
sort extent pool ktstsmonmsg 0 1 8
undo global data kturimugur: child 0 5,920 4,604
undo global data ktudba: KSLBEGIN 0 1,383 2,763
undo global data ktucof: at start 0 23 0
undo global data ktudnx:child 0 21 10
undo global data ktufrbs: child 0 14 11
undo global data ktusmasp: ktugd_tuux 0 11 0
undo global data ktumof: KSLBEGIN 0 10 0
undo global data ktubnd:child 0 8 3

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

OwnerTablespace NameObject NameSubobject NameObj. TypeLogical Reads%Total
AR APPS_TS_TX_INTERFACE RA_INTERFACE_LINES_ALL   TABLE 64,618,528 3.51
APPLSYS APPS_TS_SEED WF_EVENTS_U1   INDEX 54,094,112 2.94
APPLSYS APPS_TS_SEED WF_EVENTS   TABLE 53,912,160 2.93
APPLSYS APPS_TS_SEED WF_EVENT_SUBSCRIPTIONS   TABLE 45,809,296 2.49
WSH APPS_TS_TX_DATA WSH_DELIVERY_DETAILS   TABLE 24,209,744 1.32

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
GL APPS_ASSM_DATA GL_JE_LINES   TABLE 35,079 7.79
AR APPS_ASSM_DATA RA_CUSTOMER_TRX_LINES_ALL   TABLE 12,976 2.88
WSH APPS_TS_TX_DATA WSH_DELIVERY_DETAILS   TABLE 9,554 2.12
HR APPS_TS_TX_IDX PAY_PERSON_LATEST_BALA_N50   INDEX 4,777 1.06
HR APPS_ASSM_DATA PAY_RUN_RESULTS   TABLE 4,052 0.90

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
APPLSYS APPS_TS_TX_IDX WF_ITEM_ACTIVITY_STATUSES_N1   INDEX 13,646 29.36
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_U1   INDEX 10,598 22.81
WSH APPS_TS_TX_DATA WSH_TRIP_STOPS   TABLE 10,244 22.04
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N6   INDEX 4,001 8.61
HR APPS_ASSM_IDX PAY_RUN_RESULT_VALUES_PK   INDEX 1,729 3.72

Back to Segment Statistics
Back to Top

Segments by ITL Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeITL Waits% of Capture
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N6   INDEX 36 33.96
APPLSYS APPS_TS_TX_IDX WF_ITEM_ATTRIBUTE_VALUES_PK   INDEX 19 17.92
GL APPS_ASSM_IDX GL_IMPORT_REFERENCES_N3   INDEX 13 12.26
GL APPS_ASSM_IDX GL_IMPORT_REFERENCES_N1   INDEX 10 9.43
GL APPS_ASSM_IDX GL_JE_LINES_U1   INDEX 6 5.66

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_U1   INDEX 185,229 37.63
APPLSYS APPS_TS_TX_DATA WF_ITEM_ATTRIBUTE_VALUES   TABLE 96,837 19.67
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N6   INDEX 31,650 6.43
SYS SYSTEM DBMS_LOCK_ALLOCATED   TABLE 17,302 3.51
AR APPS_ASSM_DATA RA_CUST_TRX_LINE_GL_DIST_ALL   TABLE 16,757 3.40

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control 5 20.00 0   2 1
dc_constraints 648 47.07 0   648 97
dc_files 6,660 0.00 0   0 111
dc_global_oids 5,257,226 0.00 0   0 49
dc_histogram_data 3,849 14.84 0   0 510
dc_histogram_defs 310,855 3.21 0   4,042 3,266
dc_object_grants 48,952 0.07 0   0 119
dc_object_ids 8,835,348 0.02 0   57 1,176
dc_objects 129,262 1.11 0   345 1,054
dc_profiles 6,848 0.00 0   0 1
dc_rollback_segments 18,958 0.02 0   12 269
dc_segments 267,855 0.67 0   14,760 1,494
dc_sequences 45,355 0.12 0   45,355 121
dc_table_scns 16,430 0.05 0   0 5
dc_tablespace_quotas 14,607 0.16 0   216 49
dc_tablespaces 4,377,884 0.00 0   0 21
dc_usernames 353,200 0.00 0   0 23
dc_users 10,333,038 0.00 0   0 68
outstanding_alerts 268 0.75 0   1 43


Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY 448,700 0.03 31,019,790 -0.03 4 0
CLUSTER 76 0.00 182 1.10 2 0
INDEX 10,617 0.60 11,430 0.81 0 0
JAVA DATA 616 0.00 0   0 0
PIPE 34,548 2.51 50,924 1.65 0 0
SQL AREA 5,370 92.64 88,285,128 0.42 2,479 335
TABLE/PROCEDURE 290,102 0.33 42,952,692 -0.04 829 0
TRIGGER 20,539 0.12 1,241,214 0.00 25 0


Back to Top

Memory Statistics

Back to Top

Process Memory Summary

CategoryAlloc (MB)Used (MB)Avg Alloc (MB)Std Dev Alloc (MB)Max Alloc (MB)Hist Max Alloc (MB)Num ProcNum Alloc
B Other 24,283.30   11.34 6.54 37 37 2,142 2,142
  SQL 2,279.06 1,166.36 1.07 0.67 4 21 2,136 2,135
  Freeable 2,222.31 0.00 1.20 0.75 9   1,856 1,856
  PL/SQL 1,559.87 132.04 0.73 0.93 3 3 2,142 2,142
  JAVA 178.10 177.39 2.23 0.36 5 8 80 80
E Other 30,070.31   13.95 8.40 57 57 2,156 2,156
  Freeable 2,920.81 0.00 1.52 0.94 9   1,918 1,918
  SQL 2,725.77 1,427.20 1.27 0.75 5 21 2,150 2,149
  PL/SQL 1,848.06 149.28 0.86 0.97 3 3 2,156 2,156
  JAVA 178.01 177.28 2.23 0.36 5 8 80 80

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers 19,126,026,240 18,975,031,296
Fixed Size 2,111,120  
Redo Buffers 14,663,680  
Variable Size 2,332,035,440 2,483,030,384

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
java free memory 51.29 51.29 0.00
java joxlod exec hp 12.09 12.09 0.00
large PX msg pool 0.49 0.49 0.00
large free memory 15.51 15.51 0.00
shared ASH buffers 29.00 29.00 0.00
shared CCursor 35.42 36.10 1.92
shared KGLS heap 33.50   -100.00
shared KTI-UNDO 44.33 44.33 0.00
shared PCursor 22.17   -100.00
shared PL/SQL MPCODE 66.83 70.42 5.36
shared db_block_hash_buckets 180.00 180.00 0.00
shared event statistics per sess 52.73 52.73 0.00
shared free memory 334.51 349.50 4.48
shared library cache 571.58 697.39 22.01
shared parameter table block 39.35 39.51 0.39
shared private strands 83.14 83.14 0.00
shared sessions 30.35 30.35 0.00
shared sql area 356.91 377.46 5.76
shared trace buffer 33.50 33.98 1.45
  buffer_cache 18,240.00 18,096.00 -0.79
  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 NameBegin valueEnd 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 /DB/visdata/cntrl01.dbf, /DB/visdata/cntrl02.dbf, /DB/visdata/cntrl03.dbf   
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 1   
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 16   
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 3000   
remote_login_passwordfile EXCLUSIVE   
replication_dependency_tracking FALSE   
session_cached_cursors 500   
sessions 6000   
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