AWR Report

WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
VIS187584551VIS110.2.0.3.0NOhpdb1

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:107-Apr-08 14:11:363230 198.3
End Snap:207-Apr-08 15:11:413263 234.3
Elapsed:  60.09 (mins)  
DB Time:  459.05 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 18,336M 18,208MStd Block Size: 8K
Shared Pool Size: 2,048M 2,176MLog Buffer: 14,320K

Load Profile

Per SecondPer Transaction
Redo size: 8,193,259.37 33,768.62
Logical reads: 514,787.38 2,121.70
Block changes: 50,417.93 207.80
Physical reads: 126.70 0.52
Physical writes: 794.42 3.27
User calls: 8,523.14 35.13
Parses: 1,751.80 7.22
Hard parses: 1.99 0.01
Sorts: 2,173.65 8.96
Logons: 1.97 0.01
Executes: 21,251.15 87.59
Transactions: 242.63 

% Blocks changed per Read: 9.79Recursive Call %: 80.27
Rollback per transaction %: 18.26Rows per Sort: 12.88

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.76Latch Hit %: 98.46
Parse CPU to Parse Elapsd %: 83.10% Non-Parse CPU: 97.88

Shared Pool Statistics

BeginEnd
Memory Usage %: 84.27 83.86
% SQL with executions>1: 86.61 90.61
% Memory for SQL w/exec>1: 71.89 69.86

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
CPU time  22,219  80.7 
db file sequential read 246,470 2,527 10 9.2User I/O
log file sync 341,515 609 2 2.2Commit
db file scattered read 18,295 470 26 1.7User I/O
read by other session 34,660 422 12 1.5User I/O

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
sql execute elapsed time 24,111.62 87.54
DB CPU 22,219.16 80.67
PL/SQL execution elapsed time 5,007.31 18.18
inbound PL/SQL rpc elapsed time 4,867.11 17.67
parse time elapsed 635.87 2.31
Java execution elapsed time 602.32 2.19
hard parse elapsed time 288.86 1.05
repeated bind elapsed time 74.84 0.27
sequence load elapsed time 16.93 0.06
connection management call elapsed time 10.70 0.04
PL/SQL compilation elapsed time 10.28 0.04
hard parse (sharing criteria) elapsed time 3.87 0.01
failed parse elapsed time 1.21 0.00
hard parse (bind mismatch) elapsed time 1.02 0.00
DB time 27,543.07  
background elapsed time 1,329.83  
background cpu time 473.98  

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 303,503 0.05 3,547 12 0.35
Commit 341,515 0.00 609 2 0.39
Application 48,673 0.35 569 12 0.06
Concurrency 3,328,812 0.19 521 0 3.81
Network 35,296,355 0.00 469 0 40.35
System I/O 661,244 0.00 311 0 0.76
Other 133,946 34.47 97 1 0.15
Configuration 8,001 2.79 18 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 246,470 0.00 2,527 10 0.28
log file sync 341,515 0.00 609 2 0.39
db file scattered read 18,295 0.00 470 26 0.02
read by other session 34,660 0.23 422 12 0.04
SQL*Net more data from client 1,615,921 0.00 399 0 1.85
enq: RO - fast object reuse 158 81.01 394 2491 0.00
log file parallel write 630,059 0.00 307 0 0.72
buffer busy waits 844,658 0.03 292 0 0.97
enq: UL - contention 1,607 2.49 136 85 0.00
local write wait 1,532 4.24 128 83 0.00
latch: cache buffers chains 2,413,979 0.00 93 0 2.76
cursor: pin S wait on X 6,547 93.00 66 10 0.01
rdbms ipc reply 174 14.37 51 291 0.00
SQL*Net message to client 32,199,127 0.00 41 0 36.81
library cache load lock 815 0.00 32 39 0.00
SQL*Net more data to client 1,481,307 0.00 29 0 1.69
enq: TX - row lock contention 398 1.01 27 68 0.00
enq: TX - index contention 29,876 0.00 27 1 0.03
PX Deq Credit: send blkd 21,350 0.00 19 1 0.02
enq: HW - contention 2,915 0.00 11 4 0.00
SQL*Net break/reset to client 46,504 0.00 10 0 0.05
wait list latch free 529 0.00 6 11 0.00
kksfbc child completion 114 85.09 5 43 0.00
latch: library cache 8,667 0.00 4 0 0.01
write complete waits 44 86.36 4 89 0.00
control file parallel write 1,850 0.00 4 2 0.00
os thread startup 77 0.00 3 38 0.00
enq: TM - contention 6 0.00 2 395 0.00
latch: In memory undo latch 17,491 0.00 2 0 0.02
latch: undo global data 8,874 0.00 2 0 0.01
latch free 4,029 0.00 2 0 0.00
PX Deq: Signal ACK 246 28.05 2 6 0.00
latch: library cache pin 2,645 0.00 1 1 0.00
latch: object queue header operation 12,393 0.00 1 0 0.01
enq: TX - allocate ITL entry 142 0.00 1 9 0.00
LGWR wait for redo copy 25,192 0.00 1 0 0.03
reliable message 32 0.00 1 35 0.00
latch: redo allocation 2,907 0.00 1 0 0.00
enq: TX - contention 2,584 0.00 1 0 0.00
log file switch completion 55 0.00 1 19 0.00
enq: DV - contention 176 0.00 1 6 0.00
buffer deadlock 45,655 98.40 1 0 0.05
buffer exterminate 1 100.00 1 980 0.00
row cache lock 1,009 0.00 1 1 0.00
enq: SQ - contention 4,160 0.00 1 0 0.00
latch: session allocation 1,524 0.00 1 1 0.00
SGA: allocation forcing component growth 44 81.82 0 11 0.00
latch: cache buffers lru chain 817 0.00 0 0 0.00
PX qref latch 1,069 94.86 0 0 0.00
latch: row cache objects 852 0.00 0 0 0.00
latch: shared pool 516 0.00 0 0 0.00
control file sequential read 29,323 0.00 0 0 0.03
enq: FB - contention 884 0.00 0 0 0.00
enq: US - contention 19 0.00 0 11 0.00
library cache pin 1,370 0.00 0 0 0.00
latch: object queue header heap 335 0.00 0 0 0.00
log file sequential read 6 0.00 0 14 0.00
cursor: pin S 4,605 0.00 0 0 0.01
latch: cache buffer handles 245 0.00 0 0 0.00
latch: library cache lock 136 0.00 0 0 0.00
enq: CU - contention 2 0.00 0 23 0.00
latch: redo writing 500 0.00 0 0 0.00
latch: messages 81 0.00 0 0 0.00
latch: enqueue hash chains 17 0.00 0 1 0.00
cursor: mutex S 131 0.00 0 0 0.00
cursor: pin X 1 100.00 0 11 0.00
enq: PS - contention 40 0.00 0 0 0.00
direct path read 1,709 0.00 0 0 0.00
cursor: mutex X 42 0.00 0 0 0.00
direct path write 767 0.00 0 0 0.00
latch: checkpoint queue latch 7 0.00 0 0 0.00
log file single write 6 0.00 0 0 0.00
direct path write temp 51 0.00 0 0 0.00
undo segment extension 185 100.00 0 0 0.00
direct path read temp 19 0.00 0 0 0.00
library cache lock 1 0.00 0 0 0.00
SQL*Net message from client 32,199,089 0.00 6,260,948 194 36.81
pipe get 20,252 23.30 21,084 1041 0.02
Streams AQ: waiting for messages in the queue 2,390 100.00 11,669 4882 0.00
PX Idle Wait 3,297 76.68 5,175 1570 0.00
Streams AQ: qmn slave idle wait 129 0.00 3,505 27167 0.00
Streams AQ: qmn coordinator idle wait 258 50.00 3,504 13583 0.00
Streams AQ: waiting for time management or cleanup tasks 1,640 49.82 3,500 2134 0.00
PL/SQL lock timer 253 99.21 2,775 10970 0.00
jobq slave wait 610 99.34 1,783 2923 0.00
PX Deq: Execution Msg 11,843 0.00 58 5 0.01
PX Deq: Msg Fragment 9,344 0.00 3 0 0.01
PX Deq: Execute Reply 4,629 0.00 2 0 0.01
PX Deq Credit: need buffer 3,487 0.00 2 1 0.00
PX Deq: Table Q Normal 8,018 0.00 1 0 0.01
PX Deq: Parse Reply 282 0.00 0 1 0.00
PX Deq: Join ACK 229 0.00 0 0 0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
log file parallel write 630,040 0.00 307 0 0.72
control file parallel write 1,850 0.00 4 2 0.00
events in waitclass Other 33,048 0.00 2 0 0.04
os thread startup 61 0.00 2 38 0.00
db file sequential read 576 0.00 2 4 0.00
db file scattered read 156 0.00 2 13 0.00
log file sequential read 6 0.00 0 14 0.00
latch: redo writing 500 0.00 0 0 0.00
control file sequential read 1,000 0.00 0 0 0.00
direct path read 1,709 0.00 0 0 0.00
latch: shared pool 3 0.00 0 1 0.00
buffer busy waits 30 0.00 0 0 0.00
latch: cache buffers chains 20 0.00 0 0 0.00
log file single write 6 0.00 0 0 0.00
log file sync 1 0.00 0 1 0.00
direct path write 655 0.00 0 0 0.00
latch: library cache 1 0.00 0 0 0.00
latch: In memory undo latch 1 0.00 0 0 0.00
rdbms ipc message 982,756 1.03 30,244 31 1.12
pmon timer 1,262 96.51 3,515 2785 0.00
smon timer 97,400 0.00 3,505 36 0.11
Streams AQ: qmn slave idle wait 129 0.00 3,505 27167 0.00
Streams AQ: qmn coordinator idle wait 258 50.00 3,504 13583 0.00
Streams AQ: waiting for time management or cleanup tasks 1,640 49.82 3,500 2134 0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
BUSY_TIME 2,439,963
IDLE_TIME 3,319,939
IOWAIT_TIME 160,850
NICE_TIME 22,721
SYS_TIME 151,908
USER_TIME 2,184,438
LOAD 5
RSRC_MGR_CPU_WAIT_TIME 0
PHYSICAL_MEMORY_BYTES 76,192
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 27,541.10 22,216.60 451,578 1,853,388,350
SYS$BACKGROUND 0.00 0.00 5,647 2,733,003
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 300402 354321 3328685 51893 0 0 35285726 46898
SYS$BACKGROUND 3100 426 116 236 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
887 876 299 2.97 3.22 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
572 350 56,991 0.01 2.08 auzgm2ap4faw2 JDBC Thin Client (SELECT SUB.GUID SUB_GUID, DE...
507 88 1,442 0.35 1.84 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
473 469 54,319 0.01 1.72 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
462 13 1,442 0.32 1.68 3dssuqfjsynrk asn.lead.server.LeadUwqAM SELECT count(1) FROM (SELECT *...
450 4 52 8.65 1.63 9k7t8q4kfcb7y SQL*Plus begin GL.apps_ddl.apps_ddl(:dd...
432 341 121,891 0.00 1.57 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
430 152 10,000 0.04 1.56 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
423 421 54,288 0.01 1.53 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...
417 389 67,692 0.01 1.51 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
400 398 54,287 0.01 1.45 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
362 345 223,322 0.00 1.31 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
336 233 160,145 0.00 1.22 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
305 135 12,984 0.02 1.11 1q78dwnrrkf6c asn.lead.server.LeadUwqAM BEGIN ASN_SALES_PVT.Lead_Proce...
293 266 864 0.34 1.06 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
289 286 60,400 0.00 1.05 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...

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
876 887 299 2.93 3.22 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
469 473 54,319 0.01 1.72 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
421 423 54,288 0.01 1.53 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...
398 400 54,287 0.01 1.45 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
389 417 67,692 0.01 1.51 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
350 572 56,991 0.01 2.08 auzgm2ap4faw2 JDBC Thin Client (SELECT SUB.GUID SUB_GUID, DE...
345 362 223,322 0.00 1.31 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
341 432 121,891 0.00 1.57 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
286 289 60,400 0.00 1.05 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
266 293 864 0.31 1.06 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
233 336 160,145 0.00 1.22 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
152 430 10,000 0.02 1.56 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
135 305 12,984 0.01 1.11 1q78dwnrrkf6c asn.lead.server.LeadUwqAM BEGIN ASN_SALES_PVT.Lead_Proce...
88 507 1,442 0.06 1.84 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
13 462 1,442 0.01 1.68 3dssuqfjsynrk asn.lead.server.LeadUwqAM SELECT count(1) FROM (SELECT *...
4 450 52 0.07 1.63 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
138,420,660 56,991 2,428.82 7.46 350.13 572.48 auzgm2ap4faw2 JDBC Thin Client (SELECT SUB.GUID SUB_GUID, DE...
46,384,758 54,319 853.93 2.50 468.78 472.70 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
45,864,610 121,891 376.28 2.47 341.42 431.88 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
44,663,462 154,315 289.43 2.41 158.57 158.71 5kqw5535fjvw6 ARXTWMAI SELECT NVL(RCTT.ATTRIBUTE10, ...
44,526,198 160,145 278.04 2.40 233.11 336.02 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
41,549,106 299 138,960.22 2.24 875.58 887.04 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
33,474,566 54,287 616.62 1.80 397.88 399.98 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
30,216,711 164,357 183.85 1.63 214.52 219.23 gf1u933c95jb5 INVTTMTX DECLARE l_ret_stat varchar2...
30,176,991 164,348 183.62 1.63 229.67 234.42 3b3psftuyks81 INVTTMTX BEGIN INV_TXNSTUB_PUB.postTran...
28,293,271 1,323,510 21.38 1.52 150.10 150.90 66tmsr3446uqn ap.oie.server.WebExpensesAM SELECT WIAS.ACTIVITY_STATUS, ...
26,511,911 11 2,410,173.73 1.43 136.46 136.46 bp8crdjba8zgt ARGLTP update ra_cust_trx_line_gl_dis...
26,396,737 10,000 2,639.67 1.42 151.62 429.65 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
26,124,108 4,321 6,045.85 1.41 158.57 243.65 8jb36w62w5hqf ibuSRDetailsActions.jsp BEGIN IBU_REQ_PKG.UpdateServic...
22,750,271 54,288 419.07 1.23 420.54 422.68 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...
20,390,488 60,400 337.59 1.10 285.75 288.91 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...

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,238 10,000 4.52 9.90 151.62 429.65 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
44,142 1,442 30.61 9.66 12.78 461.71 3dssuqfjsynrk asn.lead.server.LeadUwqAM SELECT count(1) FROM (SELECT *...
31,209 1,442 21.64 6.83 88.06 506.74 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
26,604 4,280 6.22 5.82 4.87 170.03 auudu2jzbt9s0 CSCCCCRC SELECT HD.ID CONTRACT_ID , HD....
21,392 12,984 1.65 4.68 135.31 305.05 1q78dwnrrkf6c asn.lead.server.LeadUwqAM BEGIN ASN_SALES_PVT.Lead_Proce...
13,728 160,145 0.09 3.00 233.11 336.02 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
13,055 2,448 5.33 2.86 12.38 170.07 72cqcsuq5wgh0 asn.dashboard.server.DashboardAM SELECT aslrt.meaning as rank_n...
11,465 432 26.54 2.51 105.62 182.42 dk0sqcvc2xjvs qotSCopHdrUpd.jsp BEGIN ASO_QUOTE_PUB_W.Create_Q...
10,873 121,891 0.09 2.38 341.42 431.88 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
10,814 4,321 2.50 2.37 158.57 243.65 8jb36w62w5hqf ibuSRDetailsActions.jsp BEGIN IBU_REQ_PKG.UpdateServic...
4,589 9,997 0.46 1.00 193.28 231.15 csvvv0fmhr1yc PYUSLV BEGIN FFP1893_01010001.FORMULA...

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,323,510 685,704 0.52 0.00 0.00 66tmsr3446uqn ap.oie.server.WebExpensesAM SELECT WIAS.ACTIVITY_STATUS, ...
756,162 756,145 1.00 0.00 0.00 cd9mbmqyf4qhp ap.oie.server.WebExpensesAM UPDATE WF_ITEM_ACTIVITY_STATUS...
704,925 704,886 1.00 0.00 0.00 gnhmcahkmrnzs ap.oie.server.WebExpensesAM INSERT INTO WF_ITEM_ACTIVITY_S...
361,733 361,724 1.00 0.00 0.00 avc1jqzz04wpr JDBC Thin Client SELECT 'x' FROM DUAL
232,481 182,734 0.79 0.00 0.00 fmfdkztk8vx23   SELECT CATEGORY, SEVERITY, F...
223,322 223,318 1.00 0.00 0.00 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
177,218 3,012,556 17.00 0.00 0.00 cwyx16zn1hpfb JDBC Thin Client select parameter, value from ...
164,357 164,352 1.00 0.00 0.00 gf1u933c95jb5 INVTTMTX DECLARE l_ret_stat varchar2...
164,348 164,344 1.00 0.00 0.00 3b3psftuyks81 INVTTMTX BEGIN INV_TXNSTUB_PUB.postTran...
164,347 164,331 1.00 0.00 0.00 6gnth2mfbs2nq INVTTMTX declare v_ret number := 0...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
361,727 361,733 5.73 avc1jqzz04wpr JDBC Thin Client SELECT 'x' FROM DUAL
232,478 232,481 3.68 fmfdkztk8vx23   SELECT CATEGORY, SEVERITY, F...
223,324 223,322 3.54 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
177,214 177,218 2.81 cwyx16zn1hpfb JDBC Thin Client select parameter, value from ...
163,866 164,347 2.59 6gnth2mfbs2nq INVTTMTX declare v_ret number := 0...
121,890 121,891 1.93 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
114,933 115,130 1.82 fb13x9qx0ftks OEXOETEL begin OE_STANDARD_WF.OEOL_SELE...
109,792 110,059 1.74 1c0b7sas42w2z INVTTMTX SELECT NVL(ITEM_COST, 0), ...
84,716 84,768 1.34 76sw2a4vnc89j icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.S...
81,156 81,157 1.28 608c0n36kaw62 icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.C...
81,153 81,166 1.28 bf7uwg5pa3pj6 icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.V...
81,146 84,768 1.28 dcvv68fju01g4 icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.E...
72,246 72,246 1.14 162ttnv4ubqun OEXOETEL begin OE_DS_PVT.Check_PO_Appr...
70,000 69,999 1.11 97mt0g20bcfc3 PYUSLV begin ...
66,831 66,836 1.06 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 IdSQL Text
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;
5kqw5535fjvw6SELECT 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
608c0n36kaw62begin FND_FLEX_WORKFLOW_APIS.COPY_FROM_COMBINATION (:v1, :v2, :v3, :v4, :v5); end;
64qc329wgjv39 select /*+ ORDERED INDEX(ASSBAL PAY_ASSIGNMENT_LATEST_BALA_N1) INDEX(DEFBAL PAY_DEFINED_BALANCES_PK) INDEX(ACT PAY_ASSIGNMENT_ACTIONS_PK) INDEX(PACT PAY_PAYROLL_ACTIONS_PK) INDEX(VALUE PAY_BALANCE_CONTEXT_VALUES_PK) USE_NL(ASSBAL DEFBAL ACT PACT VALUE) +*/ ASSBAL.defined_balance_id , DEFBAL.balance_dimension_id , to_char(ASSBAL.value) , ASSBAL.latest_balance_id , ASSBAL.rowid , to_char(ASSBAL.assignment_action_id) , ACT.payroll_action_id , to_char(PACT.effective_date, :b0) , to_number(to_char(PACT.effective_date, 'J')) , nvl(VALUE.context_id, 0) , nvl(VALUE.value, 'NULL') , to_char(ASSBAL.expired_assignment_action_id) , to_char(ASSBAL.expired_value) , to_char(ASSBAL.prev_assignment_action_id) , to_char(ASSBAL.prev_balance_value) from pay_assignment_latest_balances ASSBAL , pay_defined_balances DEFBAL , pay_assignment_actions ACT , pay_payroll_actions PACT , pay_balance_context_values VALUE where ((((ASSBAL.assignment_id=:b1 and ACT.assignment_action_id=ASSBAL.assignment_action_id) and PACT.payroll_action_id=ACT.payroll_action_id) and DEFBAL.defined_balance_id=ASSBAL.defined_balance_id) and VALUE.latest_balance_id(+)=ASSBAL.latest_balance_id) union all select /*+ ORDERED INDEX(PERBAL PAY_PERSON_LATEST_BALANCES_N2) INDEX(DEFBAL PAY_DEFINED_BALANCES_PK) INDEX(ACT PAY_ASSIGNMENT_ACTIONS_PK) INDEX(VALUE PAY_BALANCE_CONTEXT_VALUES_PK) INDEX(PACT PAY_PAYROLL_ACTIONS_PK) USE_NL(PERBAL DEFBAL ACT PACT VALUE) +*/ PERBAL.defined_balance_id , DEFBAL.balance_dimension_id , to_char (PERBAL.value) , PERBAL.latest_balance_id , PERBAL.rowid , to_char(PERBAL.assignment_action_id) , ACT.payroll_action_id , to_char(PACT.effective_date, :b0) , to_number(to_char(PACT.effective_date, 'J')) , nvl(VALUE.context_id, 0) , nvl(VALUE.value, 'NULL') , to_char(PERBAL.expired_assignment_action_id) , to_char(PERBAL.expired_value) , to_char(PERBAL.prev_assignment_action_id) , to_char(PERBAL.prev_balance_value) from pay_person_latest_balances PERBAL , pay_defined_balances DEFBAL , pay_assignment_actions ACT , pay_payroll_actions PACT , pay_balance_context_values VALUE where ((((PERBAL.person_id=:b3 and ACT.assignment_action_id=PERBAL.assignment_action_id) and PACT.payroll_action_id=ACT.payroll_action_id) and DEFBAL.defined_balance_id=PERBAL.defined_balance_id) and VALUE.latest_balance_id(+)=PERBAL.latest_balance_id) order by 6, 2, 1, 4, 10 desc
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,222,680 616.44 2.54
CPU used when call started 2,219,244 615.48 2.54
CR blocks created 14,350,927 3,980.07 16.40
Cached Commit SCN referenced 45,227 12.54 0.05
Commit SCN cached 8 0.00 0.00
DB time 6,708,120 1,860.42 7.67
DBWR checkpoint buffers written 2,816,639 781.16 3.22
DBWR checkpoints 34 0.01 0.00
DBWR object drop buffers written 26,565 7.37 0.03
DBWR revisited being-written buffer 10 0.00 0.00
DBWR thread checkpoint buffers written 1,095,478 303.82 1.25
DBWR transaction table writes 2,129 0.59 0.00
DBWR undo block writes 1,472,343 408.34 1.68
DFO trees parallelized 48 0.01 0.00
IMU CR rollbacks 25,245,187 7,001.47 28.86
IMU Flushes 273,675 75.90 0.31
IMU Redo allocation size 1,797,262,988 498,450.92 2,054.37
IMU commits 459,332 127.39 0.53
IMU contention 30,932 8.58 0.04
IMU ktichg flush 7,403 2.05 0.01
IMU pool not allocated 740 0.21 0.00
IMU recursive-transaction flush 1,163 0.32 0.00
IMU undo allocation size 4,073,190,760 1,129,654.20 4,655.88
IMU- failed to get a private strand 740 0.21 0.00
PX local messages recv'd 67,284 18.66 0.08
PX local messages sent 67,284 18.66 0.08
Parallel operations downgraded 25 to 50 pct 40 0.01 0.00
Parallel operations not downgraded 8 0.00 0.00
SMON posted for undo segment shrink 3 0.00 0.00
SQL*Net roundtrips to/from client 32,189,962 8,927.53 36.79
active txn count during cleanout 158,698,787 44,013.35 181.40
application wait time 56,909 15.78 0.07
background checkpoints completed 6 0.00 0.00
background checkpoints started 5 0.00 0.00
background timeouts 11,456 3.18 0.01
branch node splits 1,009 0.28 0.00
buffer is not pinned count 656,119,048 181,967.33 749.98
buffer is pinned count 1,388,642,671 385,124.62 1,587.30
bytes received via SQL*Net from client 7,185,705,721 1,992,875.64 8,213.66
bytes sent via SQL*Net to client 6,828,487,525 1,893,805.14 7,805.34
calls to get snapshot scn: kcmgss 85,786,029 23,791.80 98.06
calls to kcmgas 17,815,751 4,941.00 20.36
calls to kcmgcs 28,160,406 7,809.98 32.19
change write time 59,330 16.45 0.07
cleanout - number of ktugct calls 40,858,619 11,331.68 46.70
cleanouts and rollbacks - consistent read gets 12,233,729 3,392.89 13.98
cleanouts only - consistent read gets 128,218 35.56 0.15
cluster key scan block gets 793,861 220.17 0.91
cluster key scans 225,784 62.62 0.26
commit batch/immediate performed 4,147 1.15 0.00
commit batch/immediate requested 4,147 1.15 0.00
commit cleanout failures: block lost 196,775 54.57 0.22
commit cleanout failures: buffer being written 3,328 0.92 0.00
commit cleanout failures: callback failure 103,559 28.72 0.12
commit cleanout failures: cannot pin 29,132 8.08 0.03
commit cleanouts 7,707,820 2,137.68 8.81
commit cleanouts successfully completed 7,375,026 2,045.38 8.43
commit immediate performed 4,147 1.15 0.00
commit immediate requested 4,147 1.15 0.00
commit txn count during cleanout 1,142,710 316.92 1.31
concurrency wait time 52,129 14.46 0.06
consistent changes 597,629,333 165,745.86 683.12
consistent gets 1,630,294,298 452,144.01 1,863.52
consistent gets - examination 1,111,662,645 308,307.28 1,270.69
consistent gets from cache 1,630,294,322 452,144.02 1,863.52
cursor authentications 2,129 0.59 0.00
data blocks consistent reads - undo records applied 594,842,694 164,973.01 679.94
db block changes 181,791,781 50,417.93 207.80
db block gets 225,874,031 62,643.65 258.19
db block gets direct 4,100 1.14 0.00
db block gets from cache 225,869,953 62,642.52 258.18
deferred (CURRENT) block cleanout applications 1,306,716 362.40 1.49
dirty buffers inspected 8,607 2.39 0.01
doubling up with imu segment 0 0.00 0.00
enqueue conversions 8,326 2.31 0.01
enqueue releases 3,357,552 931.18 3.84
enqueue requests 3,364,778 933.18 3.85
enqueue timeouts 7,125 1.98 0.01
enqueue waits 36,185 10.04 0.04
exchange deadlocks 45,666 12.66 0.05
execute count 76,625,195 21,251.15 87.59
failed probes on index block reclamation 12,602 3.50 0.01
frame signature mismatch 62 0.02 0.00
free buffer inspected 2,410,729 668.59 2.76
free buffer requested 18,342,797 5,087.17 20.97
heap block compress 26,581,283 7,372.02 30.38
hot buffers moved to head of LRU 952,314 264.11 1.09
immediate (CR) block cleanout applications 12,361,968 3,428.45 14.13
immediate (CURRENT) block cleanout applications 1,030,036 285.67 1.18
index crx upgrade (found) 52,603 14.59 0.06
index crx upgrade (positioned) 7,515,799 2,084.42 8.59
index fast full scans (rowid ranges) 1,864 0.52 0.00
index fetch by key 181,797,829 50,419.61 207.81
index scans kdiixs1 121,004,799 33,559.34 138.32
java call heap collected bytes 1,164,632,896 322,997.99 1,331.24
java call heap collected count 14,564,381 4,039.27 16.65
java call heap gc count 4,010 1.11 0.00
java call heap live object count 1,398,913 387.97 1.60
java call heap live object count max 1,500,855 416.25 1.72
java call heap live size 340,782,696 94,512.29 389.53
java call heap live size max 360,770,896 100,055.80 412.38
java call heap object count 3,545,465 983.30 4.05
java call heap object count max 3,568,533 989.69 4.08
java call heap total size 440,008,704 122,031.53 502.95
java call heap total size max 465,174,528 129,010.99 531.72
java call heap used size 480,062,384 133,139.97 548.74
java call heap used size max 493,546,640 136,879.68 564.15
leaf node 90-10 splits 17,275 4.79 0.02
leaf node splits 226,485 62.81 0.26
lob reads 14,310 3.97 0.02
lob writes 24,920 6.91 0.03
lob writes unaligned 24,920 6.91 0.03
logons cumulative 7,111 1.97 0.01
messages received 1,112,268 308.48 1.27
messages sent 1,112,268 308.48 1.27
no buffer to keep pinned count 14 0.00 0.00
no work - consistent read gets 478,058,774 132,584.29 546.45
opened cursors cumulative 3,976,347 1,102.80 4.55
parse count (failures) 2,158 0.60 0.00
parse count (hard) 7,160 1.99 0.01
parse count (total) 6,316,451 1,751.80 7.22
parse time cpu 47,136 13.07 0.05
parse time elapsed 56,719 15.73 0.06
physical read IO requests 266,355 73.87 0.30
physical read bytes 3,742,433,280 1,037,922.29 4,277.81
physical read total IO requests 295,793 82.03 0.34
physical read total bytes 4,223,642,624 1,171,380.35 4,827.86
physical read total multi block requests 18,265 5.07 0.02
physical reads 456,840 126.70 0.52
physical reads cache 454,542 126.06 0.52
physical reads cache prefetch 189,894 52.66 0.22
physical reads direct 2,298 0.64 0.00
physical reads direct temporary tablespace 589 0.16 0.00
physical reads prefetch warmup 126,753 35.15 0.14
physical write IO requests 1,234,571 342.39 1.41
physical write bytes 23,465,533,440 6,507,904.97 26,822.41
physical write total IO requests 2,015,539 558.99 2.30
physical write total bytes 54,364,354,560 15,077,349.69 62,141.49
physical write total multi block requests 1,245,473 345.42 1.42
physical writes 2,864,445 794.42 3.27
physical writes direct 5,344 1.48 0.01
physical writes direct (lob) 233 0.06 0.00
physical writes direct temporary tablespace 4,383 1.22 0.01
physical writes from cache 2,859,101 792.94 3.27
physical writes non checkpoint 2,134,366 591.94 2.44
pinned buffers inspected 1,944 0.54 0.00
prefetch warmup blocks aged out before use 233,219 64.68 0.27
prefetched blocks aged out before use 120 0.03 0.00
process last non-idle time 3,606 1.00 0.00
queries parallelized 48 0.01 0.00
recursive aborts on index block reclamation 2 0.00 0.00
recursive calls 125,012,264 34,670.76 142.90
recursive cpu usage 1,268,047 351.68 1.45
redo blocks written 60,171,957 16,688.02 68.78
redo buffer allocation retries 34 0.01 0.00
redo entries 94,050,760 26,083.93 107.51
redo log space requests 58 0.02 0.00
redo log space wait time 112 0.03 0.00
redo ordering marks 1,158,283 321.24 1.32
redo size 29,542,410,736 8,193,259.37 33,768.62
redo subscn max counts 2,235,200 619.91 2.55
redo synch time 62,773 17.41 0.07
redo synch writes 1,479,528 410.33 1.69
redo wastage 257,832,060 71,506.86 294.72
redo write time 37,898 10.51 0.04
redo writer latching time 119 0.03 0.00
redo writes 630,010 174.73 0.72
rollback changes - undo records applied 207,927 57.67 0.24
rollbacks only - consistent read gets 2,284,346 633.54 2.61
rows fetched via callback 104,434,359 28,963.71 119.37
session connect time 0 0.00 0.00
session cursor cache hits 4,123,499 1,143.61 4.71
session logical reads 1,856,167,324 514,787.38 2,121.70
session pga memory 9,363,123,792 2,596,758.35 10,702.57
session pga memory max 11,673,626,896 3,237,550.71 13,343.61
session uga memory ############### 74,568,021.92 307,333.04
session uga memory max 50,568,892,904 14,024,720.58 57,803.06
shared hash latch upgrades - no wait 27,624,163 7,661.25 31.58
shared hash latch upgrades - wait 80,038 22.20 0.09
sorts (memory) 7,837,537 2,173.65 8.96
sorts (rows) 100,972,227 28,003.53 115.42
sql area evicted 2,483 0.69 0.00
sql area purged 2,311 0.64 0.00
summed dirty queue length 33,005 9.15 0.04
switch current to new buffer 1,180,226 327.32 1.35
table fetch by rowid 870,998,216 241,561.68 995.60
table fetch continued row 32,419,095 8,991.08 37.06
table scan blocks gotten 48,533,202 13,460.14 55.48
table scan rows gotten 1,430,594,153 396,759.39 1,635.25
table scans (long tables) 4,172 1.16 0.00
table scans (rowid ranges) 4,170 1.16 0.00
table scans (short tables) 3,929,374 1,089.77 4.49
total number of times SMON posted 97,493 27.04 0.11
transaction rollbacks 4,147 1.15 0.00
transaction tables consistent read rollbacks 69 0.02 0.00
transaction tables consistent reads - undo records applied 3,261 0.90 0.00
undo change vector size 10,283,145,380 2,851,916.11 11,754.21
user I/O wait time 354,694 98.37 0.41
user calls 30,731,843 8,523.14 35.13
user commits 715,105 198.33 0.82
user rollbacks 159,743 44.30 0.18
workarea executions - onepass 4 0.00 0.00
workarea executions - optimal 4,370,555 1,212.12 5.00
write clones created in background 1,462 0.41 0.00
write clones created in foreground 18,768 5.21 0.02

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session cursor cache count 220,738 686,204
opened cursors current 640,492 764,603
workarea memory allocated 2,111 891
logons current 3,230 3,263

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 111 0 15.23 1.00 501,649 139 309,908 0.03
APPS_TS_TX_DATA 167,056 46 11.73 1.43 178,424 49 140,176 0.65
APPS_ASSM_DATA 8,530 2 10.48 6.70 252,143 70 50,403 0.90
APPS_TS_TX_IDX 74,295 21 10.03 1.72 128,775 36 87,793 0.45
APPS_ASSM_IDX 6,235 2 7.58 1.05 121,447 34 244,338 0.14
APPS_TS_TX_INTERFACE 977 0 2.70 2.34 25,926 7 21,552 0.08
TEMP 293 0 2.73 15.73 9,077 3 379 691.79
SYSTEM 4,976 1 7.20 2.51 2,158 1 19,256 0.11
APPS_TS_SEED 2,704 1 38.69 2.34 4,209 1 2,241 109.11
APPS_TS_SUMMARY 139 0 15.32 1.00 4,185 1 2,599 0.51
APPS_TS_QUEUES 479 0 9.52 2.73 3,630 1 365 5.81
SYSAUX 300 0 3.47 1.10 1,297 0 0 0.00
APPS_TS_ARCHIVE 76 0 8.68 1.24 1,433 0 41 3.90
APPS_TS_NOLOGGING 43 0 2.79 1.33 74 0 0 0.00
APPS_TS_MEDIA 30 0 0.00 1.00 18 0 0 0.00
CTXSYS 38 0 0.00 1.00 10 0 0 0.00
ODM 19 0 0.00 1.00 5 0 0 0.00
OLAP 19 0 0.00 1.00 5 0 0 0.00
OWAPUB 19 0 0.00 1.00 5 0 0 0.00
PORTAL 19 0 0.00 1.00 5 0 0 0.00
SYNCSERVER 19 0 0.00 1.00 5 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,530 2 10.48 6.70 252,143 70 50,403 0.90
APPS_ASSM_IDX /DB/visdata/apps_assm_idx.dbf 6,235 2 7.58 1.05 121,447 34 244,338 0.14
APPS_TS_ARCHIVE /DB/visdata/archive1.dbf 34 0 14.71 1.21 1,186 0 40 4.00
APPS_TS_ARCHIVE /DB/visdata/archive2.dbf 42 0 3.81 1.26 247 0 1 0.00
APPS_TS_MEDIA /DB/visdata/media1.dbf 10 0 0.00 1.00 6 0 0 0.00
APPS_TS_MEDIA /DB/visdata/media2.dbf 10 0 0.00 1.00 6 0 0 0.00
APPS_TS_MEDIA /DB/visdata/media3.dbf 10 0 0.00 1.00 6 0 0 0.00
APPS_TS_NOLOGGING /DB/visdata/nologging1.dbf 10 0 0.00 1.00 6 0 0 0.00
APPS_TS_NOLOGGING /DB/visdata/nologging2.dbf 21 0 5.24 1.00 48 0 0 0.00
APPS_TS_NOLOGGING /DB/visdata/nologging3.dbf 12 0 0.83 2.17 20 0 0 0.00
APPS_TS_QUEUES /DB/visdata/queues1.dbf 100 0 4.90 1.42 506 0 139 0.50
APPS_TS_QUEUES /DB/visdata/queues2.dbf 52 0 4.81 3.50 809 0 168 0.54
APPS_TS_QUEUES /DB/visdata/queues3.dbf 52 0 18.08 3.27 505 0 7 0.00
APPS_TS_QUEUES /DB/visdata/queues4.dbf 51 0 4.12 3.14 455 0 7 0.00
APPS_TS_QUEUES /DB/visdata/queues5.dbf 47 0 7.23 3.70 471 0 3 0.00
APPS_TS_QUEUES /DB/visdata/queues6.dbf 35 0 5.43 4.60 399 0 1 0.00
APPS_TS_QUEUES /DB/visdata/queues7.dbf 142 0 15.07 2.25 485 0 40 49.00
APPS_TS_SEED /DB/visdata/reference1.dbf 236 0 12.97 3.02 433 0 72 11.39
APPS_TS_SEED /DB/visdata/reference10.dbf 201 0 14.98 2.93 471 0 61 59.84
APPS_TS_SEED /DB/visdata/reference2.dbf 229 0 11.27 2.25 428 0 38 6.32
APPS_TS_SEED /DB/visdata/reference3.dbf 493 0 43.14 1.87 514 0 1,250 124.05
APPS_TS_SEED /DB/visdata/reference4.dbf 322 0 72.08 2.16 385 0 502 140.62
APPS_TS_SEED /DB/visdata/reference5.dbf 243 0 26.67 2.17 392 0 106 24.43
APPS_TS_SEED /DB/visdata/reference6.dbf 299 0 47.32 2.31 421 0 70 59.29
APPS_TS_SEED /DB/visdata/reference7.dbf 243 0 40.12 2.62 342 0 29 17.24
APPS_TS_SEED /DB/visdata/reference8.dbf 216 0 43.98 2.43 410 0 53 14.15
APPS_TS_SEED /DB/visdata/reference9.dbf 222 0 52.30 2.28 413 0 60 102.83
APPS_TS_SUMMARY /DB/visdata/summary1.dbf 14 0 0.00 1.00 493 0 401 0.02
APPS_TS_SUMMARY /DB/visdata/summary2.dbf 14 0 0.00 1.00 398 0 266 0.00
APPS_TS_SUMMARY /DB/visdata/summary3.dbf 22 0 57.73 1.00 429 0 225 0.04
APPS_TS_SUMMARY /DB/visdata/summary4.dbf 20 0 0.50 1.00 464 0 200 0.10
APPS_TS_SUMMARY /DB/visdata/summary5.dbf 16 0 0.00 1.00 492 0 335 0.00
APPS_TS_SUMMARY /DB/visdata/summary6.dbf 17 0 38.24 1.00 727 0 709 1.79
APPS_TS_SUMMARY /DB/visdata/summary7.dbf 20 0 10.00 1.00 669 0 239 0.04
APPS_TS_SUMMARY /DB/visdata/summary8.dbf 16 0 0.00 1.00 513 0 224 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data1.dbf 3,064 1 12.79 1.51 214 0 18 13.33
APPS_TS_TX_DATA /DB/visdata/tx_data10.dbf 2,914 1 15.63 1.39 104 0 10 18.00
APPS_TS_TX_DATA /DB/visdata/tx_data11.dbf 2,876 1 16.54 1.41 105 0 25 50.80
APPS_TS_TX_DATA /DB/visdata/tx_data12.dbf 12,355 3 9.61 1.30 1,841 1 4,203 3.00
APPS_TS_TX_DATA /DB/visdata/tx_data13.dbf 17,458 5 13.83 1.60 3,272 1 2,606 2.47
APPS_TS_TX_DATA /DB/visdata/tx_data14.dbf 12,609 3 9.03 1.42 27,714 8 19,121 0.30
APPS_TS_TX_DATA /DB/visdata/tx_data15.dbf 9,018 3 10.93 1.54 24,795 7 18,887 0.40
APPS_TS_TX_DATA /DB/visdata/tx_data16.dbf 9,106 3 10.29 1.53 24,025 7 17,215 0.44
APPS_TS_TX_DATA /DB/visdata/tx_data17.dbf 9,039 3 11.52 1.55 23,416 6 17,808 0.44
APPS_TS_TX_DATA /DB/visdata/tx_data18.dbf 9,119 3 11.80 1.52 22,845 6 18,754 0.81
APPS_TS_TX_DATA /DB/visdata/tx_data19.dbf 8,938 2 10.13 1.51 23,274 6 18,425 0.29
APPS_TS_TX_DATA /DB/visdata/tx_data2.dbf 6,593 2 8.67 1.20 473 0 2,462 1.21
APPS_TS_TX_DATA /DB/visdata/tx_data20.dbf 8,852 2 10.30 1.53 23,068 6 18,679 0.22
APPS_TS_TX_DATA /DB/visdata/tx_data21.dbf 23,091 6 13.14 1.24 1,349 0 1,411 1.15
APPS_TS_TX_DATA /DB/visdata/tx_data3.dbf 3,117 1 14.91 1.56 302 0 99 46.46
APPS_TS_TX_DATA /DB/visdata/tx_data4.dbf 14,189 4 12.34 1.33 247 0 69 15.22
APPS_TS_TX_DATA /DB/visdata/tx_data5.dbf 3,003 1 14.96 1.32 246 0 47 36.81
APPS_TS_TX_DATA /DB/visdata/tx_data6.dbf 2,884 1 13.27 1.40 138 0 70 30.43
APPS_TS_TX_DATA /DB/visdata/tx_data7.dbf 2,845 1 10.71 1.42 359 0 110 5.55
APPS_TS_TX_DATA /DB/visdata/tx_data8.dbf 2,907 1 12.36 1.31 397 0 83 9.28
APPS_TS_TX_DATA /DB/visdata/tx_data9.dbf 3,079 1 11.76 1.50 240 0 74 22.84
APPS_TS_TX_IDX /DB/visdata/tx_idx1.dbf 2,276 1 8.89 1.30 1,641 0 2,291 1.43
APPS_TS_TX_IDX /DB/visdata/tx_idx10.dbf 2,214 1 8.92 1.38 1,112 0 1,942 0.72
APPS_TS_TX_IDX /DB/visdata/tx_idx11.dbf 2,216 1 7.92 1.43 1,349 0 1,877 0.62
APPS_TS_TX_IDX /DB/visdata/tx_idx12.dbf 8,225 2 14.36 2.18 16,926 5 2,020 0.45
APPS_TS_TX_IDX /DB/visdata/tx_idx13.dbf 7,325 2 7.40 1.51 18,006 5 3,918 0.65
APPS_TS_TX_IDX /DB/visdata/tx_idx14.dbf 4,156 1 11.68 1.96 11,566 3 4,672 0.26
APPS_TS_TX_IDX /DB/visdata/tx_idx15.dbf 4,220 1 10.93 1.95 9,965 3 5,527 0.32
APPS_TS_TX_IDX /DB/visdata/tx_idx16.dbf 4,079 1 11.39 1.90 8,486 2 5,115 0.22
APPS_TS_TX_IDX /DB/visdata/tx_idx17.dbf 4,032 1 11.71 1.94 8,713 2 5,120 0.27
APPS_TS_TX_IDX /DB/visdata/tx_idx18.dbf 4,040 1 11.91 1.83 8,649 2 7,427 0.20
APPS_TS_TX_IDX /DB/visdata/tx_idx19.dbf 4,022 1 11.72 1.90 8,287 2 6,123 0.28
APPS_TS_TX_IDX /DB/visdata/tx_idx2.dbf 2,599 1 10.14 1.70 1,327 0 3,362 0.31
APPS_TS_TX_IDX /DB/visdata/tx_idx20.dbf 4,060 1 10.78 1.84 7,500 2 4,599 0.23
APPS_TS_TX_IDX /DB/visdata/tx_idx21.dbf 2,682 1 9.84 2.10 10,640 3 3,438 0.62
APPS_TS_TX_IDX /DB/visdata/tx_idx3.dbf 3,778 1 7.11 1.26 1,412 0 4,036 0.92
APPS_TS_TX_IDX /DB/visdata/tx_idx4.dbf 2,501 1 8.04 1.31 2,519 1 3,416 0.99
APPS_TS_TX_IDX /DB/visdata/tx_idx5.dbf 2,474 1 7.35 1.40 3,973 1 11,124 0.22
APPS_TS_TX_IDX /DB/visdata/tx_idx6.dbf 2,408 1 7.35 1.40 2,142 1 3,807 0.57
APPS_TS_TX_IDX /DB/visdata/tx_idx7.dbf 2,361 1 6.98 1.38 2,084 1 3,724 0.42
APPS_TS_TX_IDX /DB/visdata/tx_idx8.dbf 2,362 1 7.31 1.45 1,256 0 2,164 0.82
APPS_TS_TX_IDX /DB/visdata/tx_idx9.dbf 2,265 1 8.15 1.43 1,222 0 2,091 0.88
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte.dbf 74 0 4.86 3.01 4,108 1 9,707 0.08
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte2.dbf 158 0 4.94 3.04 5,029 1 4,566 0.06
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte3.dbf 86 0 6.51 3.88 4,502 1 3,094 0.10
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte4.dbf 129 0 2.09 2.62 4,094 1 2,251 0.12
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte5.dbf 270 0 1.70 1.71 3,913 1 1,257 0.03
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte6.dbf 260 0 0.81 1.72 4,280 1 677 0.03
APPS_UNDOTS1 /DB/visdata/undo01.dbf 7 0 0.00 1.00 45,788 13 32,814 0.02
APPS_UNDOTS1 /DB/visdata/undo02.dbf 8 0 5.00 1.00 47,472 13 32,224 0.03
APPS_UNDOTS1 /DB/visdata/undo03.dbf 12 0 45.00 1.00 50,415 14 30,106 0.04
APPS_UNDOTS1 /DB/visdata/undo04.dbf 20 0 0.00 1.00 52,945 15 33,226 0.03
APPS_UNDOTS1 /DB/visdata/undo05.dbf 11 0 37.27 1.00 53,721 15 38,897 0.03
APPS_UNDOTS1 /DB/visdata/undo06.dbf 8 0 5.00 1.00 52,905 15 32,260 0.03
APPS_UNDOTS1 /DB/visdata/undo07.dbf 10 0 12.00 1.00 51,502 14 34,633 0.03
APPS_UNDOTS1 /DB/visdata/undo08.dbf 13 0 23.85 1.00 51,534 14 23,380 0.03
APPS_UNDOTS1 /DB/visdata/undo09.dbf 9 0 1.11 1.00 45,172 13 25,604 0.03
APPS_UNDOTS1 /DB/visdata/undo10.dbf 13 0 16.92 1.00 50,195 14 26,764 0.03
CTXSYS /DB/visdata/ctx1.dbf 19 0 0.00 1.00 5 0 0 0.00
CTXSYS /DB/visdata/ctx2.dbf 19 0 0.00 1.00 5 0 0 0.00
ODM /DB/visdata/odm.dbf 19 0 0.00 1.00 5 0 0 0.00
OLAP /DB/visdata/olap.dbf 19 0 0.00 1.00 5 0 0 0.00
OWAPUB /DB/visdata/owa1.dbf 19 0 0.00 1.00 5 0 0 0.00
PORTAL /DB/visdata/portal.dbf 19 0 0.00 1.00 5 0 0 0.00
SYNCSERVER /DB/visdata/mobile01.dbf 19 0 0.00 1.00 5 0 0 0.00
SYSAUX /DB/visdata/sysaux01.dbf 24 0 5.42 1.42 576 0 0 0.00
SYSAUX /DB/visdata/sysaux02.dbf 276 0 3.30 1.07 721 0 0 0.00
SYSTEM /DB/visdata/sys1.dbf 509 0 7.11 2.92 104 0 120 0.67
SYSTEM /DB/visdata/sys2.dbf 459 0 7.54 3.05 164 0 120 0.17
SYSTEM /DB/visdata/sys3.dbf 582 0 5.67 2.41 192 0 30 1.00
SYSTEM /DB/visdata/sys4.dbf 531 0 5.69 2.52 198 0 19 1.05
SYSTEM /DB/visdata/sys5.dbf 835 0 8.01 2.00 613 0 1,464 0.15
SYSTEM /DB/visdata/sys6.dbf 506 0 9.47 2.21 71 0 19 1.05
SYSTEM /DB/visdata/sys7.dbf 420 0 6.26 2.62 134 0 77 0.00
SYSTEM /DB/visdata/sys8.dbf 441 0 9.52 3.19 354 0 17,272 0.08
SYSTEM /DB/visdata/sys9.dbf 693 0 5.95 2.22 328 0 135 2.81
TEMP /DB/visdata/temp1.dbf 86 0 2.91 33.80 2,536 1 157 676.50
TEMP /DB/visdata/temp2.dbf 66 0 0.61 11.65 2,027 1 37 584.05
TEMP /DB/visdata/temp3.dbf 64 0 6.09 4.47 2,072 1 79 667.59
TEMP /DB/visdata/temp4.dbf 77 0 1.56 8.40 2,442 1 106 770.09

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,252,102 100 1,836,696,998 454,717 2,859,101 0 0 879,193


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 84 30995 715402 2404344 35156250 2404344  
E 180 109 48418 1079573 8364628 35156250 8364628  

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 390,809 16

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 26,300.48 0.75 0.00 100.00 0.00 1,048,576
E 20,480 1,280 34,091.89 0.87 0.00 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 3,969,565 3,969,565 0 0
64K 128K 11,399 11,399 0 0
128K 256K 1,307 1,307 0 0
256K 512K 784 784 0 0
512K 1024K 122,240 122,240 0 0
1M 2M 261,581 261,581 0 0
2M 4M 70 68 2 0
4M 8M 23 21 2 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 FactrW/A MB ProcessedEstd Extra W/A MB Read/ Written to Disk Estd PGA Cache Hit %Estd PGA Overalloc Count
2,560 0.13 498,084.49 7,870.63 98.00 936
5,120 0.25 498,084.49 7,747.74 98.00 893
10,240 0.50 498,084.49 7,595.41 98.00 837
15,360 0.75 498,084.49 7,433.67 99.00 779
20,480 1.00 498,084.49 5.06 100.00 624
24,576 1.20 498,084.49 0.00 100.00 112
28,672 1.40 498,084.49 0.00 100.00 0
32,768 1.60 498,084.49 0.00 100.00 0
36,864 1.80 498,084.49 0.00 100.00 0
40,960 2.00 498,084.49 0.00 100.00 0
61,440 3.00 498,084.49 0.00 100.00 0
81,920 4.00 498,084.49 0.00 100.00 0
122,880 6.00 498,084.49 0.00 100.00 0
163,840 8.00 498,084.49 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,504 0.69 253 12,102 2,340,275 1.00 7,188 6.66 127,324,079
1,728 0.79 455 15,643 2,345,553 1.00 1,910 1.77 127,587,652
1,952 0.90 677 19,254 2,346,382 1.00 1,081 1.00 127,630,273
2,176 1.00 899 25,172 2,346,384 1.00 1,079 1.00 127,630,808
2,400 1.10 992 30,366 2,346,384 1.00 1,079 1.00 127,630,850
2,624 1.21 992 30,366 2,346,384 1.00 1,079 1.00 127,630,850
2,848 1.31 992 30,366 2,346,384 1.00 1,079 1.00 127,630,850
3,072 1.41 992 30,366 2,346,384 1.00 1,079 1.00 127,630,850
3,296 1.51 992 30,366 2,346,384 1.00 1,079 1.00 127,630,850
3,520 1.62 992 30,366 2,346,384 1.00 1,079 1.00 127,630,850
3,744 1.72 992 30,366 2,346,384 1.00 1,079 1.00 127,630,850
3,968 1.82 992 30,366 2,346,384 1.00 1,079 1.00 127,630,850
4,192 1.93 992 30,366 2,346,384 1.00 1,079 1.00 127,630,850
4,416 2.03 992 30,366 2,346,384 1.00 1,079 1.00 127,630,850

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 32,530  
10,240 0.50 32,531  
15,360 0.75 32,531  
20,480 1.00 32,530  
25,600 1.25 32,531  
30,720 1.50 32,535  
35,840 1.75 32,535  
40,960 2.00 32,536  

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 11 302 983 1.00 1,080 1.00 12,205
32 0.50 11 302 983 1.00 1,080 1.00 12,205
48 0.75 11 302 983 1.00 1,080 1.00 12,205
64 1.00 11 302 983 1.00 1,080 1.00 12,205
80 1.25 11 302 983 1.00 1,080 1.00 12,205
96 1.50 11 302 983 1.00 1,080 1.00 12,205
112 1.75 11 302 983 1.00 1,080 1.00 12,205
128 2.00 11 302 983 1.00 1,080 1.00 12,205

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
data block 561,018 456 1
file header block 449 262 584
undo block 235,008 7 0
undo header 74,891 3 0
1st level bmb 5,019 2 0
segment header 2,184 2 1
2nd level bmb 416 0 1
bitmap index block 27 0 0
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) 261 261 0 29 403 13,892.41
UL-User-defined 65,463 64,442 1,021 1,532 140 91.07
TX-Transaction (index contention) 27,752 27,752 0 26,089 28 1.06
TX-Transaction (row lock contention) 5,826 388 5,438 360 28 76.39
HW-Segment High Water Mark 185,772 185,766 5 2,450 11 4.68
TM-DML 1,501,014 1,500,934 21 6 2 401.67
TX-Transaction 1,030,429 1,030,373 0 1,761 1 0.74
TX-Transaction (allocate ITL entry) 169 169 0 123 1 10.41
DV-Diana Versioning 19,690 19,690 0 172 1 6.92
SQ-Sequence Cache 35,104 35,104 0 3,009 1 0.34
FB-Format Block 34,959 34,957 0 607 0 0.49
US-Undo Segment 14,520 14,520 0 19 0 11.58
CU-Cursor 6,997 6,995 0 2 0 20.00
PS-PX Process Reservation 3,728 3,087 640 26 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,477.02 1,031,858 2,364 271   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
07-Apr 15:07 199,478 139,899 623 238 198 0/0 0/0/0/0/0/0
07-Apr 14:57 54,269 79,667 446 229 202 0/0 0/0/0/0/0/0
07-Apr 14:47 435,503 159,444 2,364 271 185 0/0 0/0/0/0/0/0
07-Apr 14:37 309,950 203,242 2,027 248 240 0/0 0/0/0/0/0/0
07-Apr 14:27 205,758 220,321 2,209 237 318 0/0 0/0/0/0/0/0
07-Apr 14:17 272,063 229,285 1,739 240 416 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,581 0.00   0 0  
AWR Alerted Metric Element list 214,469 0.00   0 0  
Consistent RBA 630,317 0.02 0.30 0 0  
FOB s.o list latch 43,472 0.02 0.00 0 0  
In memory undo latch 565,711,447 2.32 0.00 2 898,881 0.00
JOX SGA heap latch 1,836,931 0.00   0 0  
JS mem alloc latch 0     0 2 0.00
JS queue state obj latch 21,600 0.00   0 0  
JS slv state obj latch 180 0.00   0 0  
KMG MMAN ready and startup request latch 2,620 0.00   0 0  
KMG resize request state object freelist 16 0.00   0 0  
KTF sga latch 12 0.00   0 1,214 0.00
KWQMN job cache list latch 10,792 0.44 0.94 0 0  
MQL Tracking Latch 0     0 72 0.00
Memory Management Latch 1,574 0.00   0 2,612 0.00
OS process 10,620 0.00   0 0  
OS process allocation 8,309 0.00   0 0  
OS process: request allocation 6,800 0.01 0.00 0 0  
PL/SQL warning settings 3,218,732 0.00   0 0  
SGA IO buffer pool latch 60,909 0.00   0 106,662 0.00
SQL memory manager latch 1 0.00   0 1,199 0.00
SQL memory manager workarea list latch 4,722,812 0.01 0.02 0 0  
Shared B-Tree 129 0.00   0 0  
active checkpoint queue latch 481,490 0.00   0 2 0.00
active service list 38,044 0.31 0.00 0 1,244 0.00
alert log latch 0     0 2 0.00
begin backup scn array 154 0.00   0 0  
buffer pool 16 0.00   0 0  
cache buffer handles 20,869,809 1.83 0.00 0 0  
cache buffers chains 4,217,365,651 1.63 0.04 93 16,437,281 2.95
cache buffers lru chain 8,894,297 0.43 0.02 0 32,362,309 0.71
cache table scan latch 1,905 0.00   0 1,905 0.05
channel handle pool latch 255,256 0.06 0.03 0 0  
channel operations parent latch 1,135,759 0.54 0.01 0 0  
checkpoint queue latch 19,852,943 0.01 0.00 0 2,892,818 0.05
client/application info 1,149,824 0.00 0.11 0 0  
commit callback allocation 54,578 0.00   0 0  
compile environment latch 1,936,142 0.00   0 0  
dictionary lookup 72 0.00   0 0  
dml lock allocation 2,990,634 0.32 0.01 0 0  
dummy allocation 14,221 1.12 0.00 0 0  
enqueue hash chains 6,774,839 0.18 0.00 0 914 0.00
enqueues 3,522,359 0.21 0.01 0 0  
error message lists 1,584 4.55 0.00 0 0  
event group latch 3,414 0.00   0 0  
file cache latch 20,905 0.00   0 0  
global KZLD latch for mem in SGA 6,220 0.00   0 0  
global ctx hash table latch 14,751 0.00   0 0  
hash table column usage latch 2,041 0.05 0.00 0 9,924,837 0.00
hash table modification latch 142 0.00   0 2 0.00
internal temp table object number allocation latc 6 0.00   0 0  
job workq parent latch 0     0 122 0.00
job_queue_processes free list latch 0     0 2 0.00
job_queue_processes parameter latch 121 0.00   0 0  
kks stats 24,581 0.00   0 0  
ksuosstats global area 242 0.00   0 0  
ktm global data 97,462 0.00   0 0  
kwqbsn:qsga 129 0.00   0 0  
lgwr LWN SCN 633,514 0.11 0.03 0 0  
library cache 241,008,737 0.50 0.01 4 22,452 14.21
library cache load lock 10,324 0.60 0.00 0 52 0.00
library cache lock 37,498,337 0.07 0.00 0 0  
library cache lock allocation 996,741 0.01 0.00 0 0  
library cache pin 150,605,215 0.20 0.01 1 24 4.17
library cache pin allocation 353,564 0.00 0.00 0 0  
list of block allocation 405,002 0.03 0.00 0 0  
loader state object freelist 197,730 0.00 0.00 0 0  
longop free list parent 33 0.00   0 33 0.00
message pool operations parent latch 258,619 0.04 0.02 0 0  
messages 3,374,339 0.06 0.04 0 0  
mostly latch-free SCN 712,518 8.46 0.05 1 0  
multiblock read objects 39,774 0.01 0.67 0 2 0.00
ncodef allocation latch 94 0.00   0 0  
object queue header heap 4,110,487 0.02 0.39 0 261,514 0.07
object queue header operation 28,743,061 0.13 0.33 1 15,610 0.02
object stats modification 253,140 0.02 0.00 0 4 0.00
parallel query alloc buffer 23,516 4.81 0.00 0 0  
parallel query stats 912 24.78 0.03 0 0  
parameter table allocation management 15,669 2.17 0.56 0 0  
post/wait queue 838,172 0.06 0.00 0 341,741 0.02
process allocation 6,848 0.06 1.00 0 3,414 0.00
process group creation 6,800 0.00   0 0  
process queue 15,146 1.33 0.00 0 0  
process queue reference 1,339,023 0.06 0.00 0 99,412 1.08
qmn task queue latch 516 0.00   0 0  
query server freelists 13,488 21.55 0.00 0 0  
query server process 16 0.00   0 16 0.00
redo allocation 4,347,795 5.88 0.01 1 93,738,294 2.94
redo copy 0     0 94,049,570 0.04
redo writing 2,777,567 0.03 0.65 0 0  
resmgr group change latch 521,083 0.00   0 0  
resmgr:actses active list 20,411 0.21 0.95 0 0  
resmgr:actses change group 19,432 0.00   0 0  
resmgr:free threads list 14,219 1.18 0.00 0 0  
resmgr:schema config 1 0.00   0 0  
row cache objects 80,575,318 0.25 0.00 0 9,750 0.13
rules engine aggregate statistics 27,001 0.04 0.00 0 0  
rules engine evaluation context statistics 0     0 2 0.00
rules engine rule set statistics 88,336 0.02 0.05 0 0  
rules engine rule statistics 34,339 0.00   0 0  
sequence cache 15,492,518 0.94 0.00 0 0  
session allocation 14,256,048 0.72 0.01 1 0  
session idle bit 63,388,141 0.03 0.02 0 0  
session state list latch 39,050 0.25 0.15 0 0  
session switching 9,216 0.00   0 0  
session timer 1,243 0.00   0 0  
shared pool 5,851,875 0.21 0.04 0 0  
shared pool sim alloc 323 0.00   0 0  
shared pool simulator 1,879,677 0.00 0.05 0 0  
sim partition latch 1 0.00   0 21,763 0.11
simulator hash latch 2,460 0.00   0 0  
simulator lru latch 1,104 0.00   0 0  
slave class 1 0.00   0 0  
slave class create 4 0.00   0 0  
sort extent pool 877,001 0.11 0.02 0 0  
state object free list 12 0.00   0 0  
statistics aggregation 84 0.00   0 0  
temp lob duration state obj allocation 199 0.00   0 0  
temporary table state object allocation 8,010 0.00   0 0  
threshold alerts latch 607 0.00   0 0  
trace latch 44 0.00   0 0  
transaction allocation 73,991 0.00 0.00 0 0  
transaction branch allocation 94 0.00   0 0  
undo global data 805,725,521 1.63 0.00 2 12,243 0.42
user lock 24,936 0.00   0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
cache buffers chains 4,217,365,651 68,687,201 2,413,959 66,477,493 0 0 0
undo global data 805,725,521 13,111,128 8,880 13,103,236 0 0 0
In memory undo latch 565,711,447 13,099,687 17,491 13,084,598 0 0 0
library cache 241,008,737 1,198,475 8,669 1,190,590 0 0 0
cache buffer handles 20,869,809 382,194 245 381,976 0 0 0
library cache pin 150,605,215 295,909 2,645 293,510 0 0 0
redo allocation 4,347,795 255,502 2,911 253,085 0 0 0
row cache objects 80,575,318 201,040 853 200,231 0 0 0
sequence cache 15,492,518 145,288 159 145,145 0 0 0
session allocation 14,256,048 102,469 1,525 101,150 0 0 0
mostly latch-free SCN 712,518 60,296 2,879 57,773 0 0 0
cache buffers lru chain 8,894,297 38,231 817 37,437 0 0 0
object queue header operation 28,743,061 37,554 12,394 25,651 0 0 0
library cache lock 37,498,337 27,820 136 27,691 0 0 0
session idle bit 63,388,141 15,874 394 15,492 0 0 0
shared pool 5,851,875 12,254 516 11,788 0 0 0
enqueue hash chains 6,774,839 12,216 17 12,199 0 0 0
dml lock allocation 2,990,634 9,538 88 9,455 0 0 0
enqueues 3,522,359 7,459 69 7,390 0 0 0
channel operations parent latch 1,135,759 6,145 31 6,117 0 0 0
query server freelists 13,488 2,907 8 2,902 0 0 0
checkpoint queue latch 19,852,943 2,248 7 2,241 0 0 0
messages 3,374,339 2,153 81 2,077 0 0 0
sort extent pool 877,001 956 18 939 0 0 0
object queue header heap 4,110,487 862 335 548 0 0 0
redo writing 2,777,567 765 500 267 0 0 0
lgwr LWN SCN 633,514 689 23 668 0 0 0
post/wait queue 838,172 481 1 480 0 0 0
parameter table allocation management 15,669 340 189 175 0 0 0
SQL memory manager workarea list latch 4,722,812 326 5 321 0 0 0
parallel query stats 912 226 7 219 0 0 0
channel handle pool latch 255,256 147 4 143 0 0 0
Consistent RBA 630,317 141 43 103 0 0 0
session state list latch 39,050 96 14 83 0 0 0
message pool operations parent latch 258,619 94 2 92 0 0 0
KWQMN job cache list latch 10,792 47 44 3 0 0 0
resmgr:actses active list 20,411 43 41 3 0 0 0
shared pool simulator 1,879,677 42 2 41 0 0 0
rules engine rule set statistics 88,336 21 1 20 0 0 0
client/application info 1,149,824 18 2 17 0 0 0
process allocation 6,848 4 4 0 0 0 0
multiblock read objects 39,774 3 2 2 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 6,519 4,231
In memory undo latch kturbk 0 6,173 8,551
In memory undo latch kticmt: child 0 3,397 587
In memory undo latch ktichg: child 0 1,202 4,044
In memory undo latch ktiTxnPoolFree 0 177 2
In memory undo latch ktiBRacquire 0 16 0
In memory undo latch ktbgfc 0 5 74
KWQMN job cache list latch kwqmnuji: update job item 0 47 5
SQL memory manager workarea list latch qesmmIRegisterWorkArea 0 4 5
SQL memory manager workarea list latch qesmmIUnRegisterWorkArea 0 1 0
cache buffer handles kcbzgs 0 143 162
cache buffer handles kcbzfs 0 102 83
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 2,666,287 2,867,734
cache buffers chains kcbchg: kslbegin: call CR func 0 1,402,272 2,154,070
cache buffers chains kcbgtcr: fast path 0 650,701 50,479
cache buffers chains kcbgtcr: kslbegin excl 0 359,013 249,599
cache buffers chains kcbrls: kslbegin 0 212,600 301,115
cache buffers chains kcbzgb: scan from tail. nowait 0 160,325 0
cache buffers chains kcbgcur: kslbegin 0 51,804 27,009
cache buffers chains kcbget: pin buffer 0 26,532 10,069
cache buffers chains kcbget: exchange 0 15,268 18,401
cache buffers chains kcbget: exchange rls 0 13,860 15,338
cache buffers chains kcbzwb 0 13,716 12,632
cache buffers chains kcbcge 0 4,904 8,802
cache buffers chains kcbnlc 0 1,348 1,715
cache buffers chains kcbso1: set no access 0 300 116
cache buffers chains kcb_is_private 0 123 1,988
cache buffers chains kcbgtcr: kslbegin shared 0 116 106
cache buffers chains kcbesc: escalate 0 112 50
cache buffers chains kcbnew: new latch again 0 51 3
cache buffers chains kcbzib: finish free bufs 0 38 3
cache buffers chains kcbbxsv 0 24 4
cache buffers chains kcb_pre_apply: kcbhq61 0 21 1,235
cache buffers chains kcbbic2 0 13 7
cache buffers chains kcb_post_apply: kcbhq63 0 8 241
cache buffers chains kcb_post_apply: kcbhq62 0 6 224
cache buffers chains kcbzhngcbk1: get hash chain latch no wait 0 4 0
cache buffers chains kcbzib: multi-block read: nowait 0 4 0
cache buffers chains kcbgtcr 0 2 2
cache buffers chains kcbo_ivd_process 0 1 13
cache buffers lru chain kcbzgws 0 423 0
cache buffers lru chain kcbo_link_q 0 240 12
cache buffers lru chain kcbgtcr:CR Scan:KCBRSKIP 0 60 0
cache buffers lru chain kcbzgb: posted for free bufs 0 34 226
cache buffers lru chain kcbbxsv: move to being written 0 30 237
cache buffers lru chain kcbzswcu 0 19 51
cache buffers lru chain kcbo_ivd_proc 0 4 89
cache buffers lru chain kcbzib 0 3 1
cache buffers lru chain kcbbic2 0 1 171
cache buffers lru chain kcbz_decr_wspwbcnt 0 1 13
cache buffers lru chain kcbzgm 0 1 0
cache buffers lru chain kcbzgpwb: KSLBEGIN use prewarm buffers 0 1 25
channel handle pool latch ksrchconnect() 0 20 14
channel operations parent latch ksrapublish() 0 28 11
channel operations parent latch ksrchdelete() 0 9 6
channel operations parent latch ksrsconsume() 0 6 4
channel operations parent latch ksrchconnect() 0 5 5
channel operations parent latch ksrmfree() 0 5 4
channel operations parent latch ksrwait() 0 4 30
checkpoint queue latch kcbbwthc: thread checkpoint buffers 0 3 2
checkpoint queue latch kcbklbc: Link buffer into ckpt queue 0 3 0
checkpoint queue latch kcbnlc: Link buffers into FQ 0 1 1
client/application info kqp327i 0 3 3
dml lock allocation ktaiam 0 60 58
dml lock allocation ktaidm 0 28 30
enqueue hash chains ksqgtl3 0 9 9
enqueue hash chains ksqrcl 0 6 7
enqueue hash chains ksqcmi: get hash chain latch after wait 0 1 2
enqueue hash chains ksucallcbksafely: ksqhngcbk1 0 1 0
enqueues ksqgel: create enqueue 0 36 17
enqueues ksqies 0 18 46
enqueues ksqdel 0 15 6
lgwr LWN SCN kcs023 0 701 0
library cache kglpndl: child: after processing 0 3,477 218
library cache kglpnp: child 0 3,087 4,194
library cache kglobpn: child: 0 864 1,338
library cache kglpndl: child: before processing 0 466 2,351
library cache kglLockCursor 0 146 245
library cache kglScanDependency 0 144 0
library cache kglpin 0 83 32
library cache kgldte: child 0 0 72 122
library cache kglhdgn: child: 0 64 101
library cache kgldti: 2child 0 26 4
library cache kglic 0 13 0
library cache kglhdiv0: child 0 6 0
library cache kglivl: child 0 6 0
library cache kglhdgc: child: 0 5 0
library cache kglrtl 0 3 0
library cache kglhdiv: child 0 2 6
library cache kglupd: child 0 2 0
library cache kglati 0 1 0
library cache kglget: unpin heap 0 0 1 1
library cache kglhdiv0: parent: invalidate 0 1 0
library cache lock kgllkdl: child: cleanup 0 100 89
library cache lock kgllkdl: child: no lock handle 0 54 11
library cache lock kgllkal: child: multiinstance 0 36 47
library cache pin kglpnp: child 0 1,240 1,405
library cache pin kglpndl 0 1,207 867
library cache pin kglpnal: child: alloc space 0 198 373
message pool operations parent latch ksrmfree() 0 3 1
messages ksaamb: after wakeup 0 48 66
messages ksarcv 0 20 12
messages ksarcv: after wait 0 13 1
mostly latch-free SCN kcslcu3 0 2,174 2,898
mostly latch-free SCN kcs01 0 24 43
mostly latch-free SCN kcs024 0 23 0
mostly latch-free SCN kcsnew_scn_rba 0 19 0
multiblock read objects kcbzib: mbr get 0 2 2
object queue header heap kcbo_link_q:reget 0 329 3
object queue header heap kcbw_link_q:alloc 0 6 332
object queue header operation kcbo_ivbo 0 13,545 1,844
object queue header operation kcbw_link_q 0 2,933 1,142
object queue header operation kcbw_unlink_q 0 544 2,860
object queue header operation kcbo_switch_mq_bg 0 126 1,897
object queue header operation kcbo_switch_q_bg 0 118 1,303
object queue header operation kcbo_switch_cq 0 112 1,922
object queue header operation kcbo_link_q:reget 0 53 77
object queue header operation kcbo_swap_buf_bg 0 10 6,249
object queue header operation kcbo_service_ockpt 0 7 2
object queue header operation kcbo_swap_buf 0 4 391
object queue header operation kcbo_write_q 0 1 0
parallel query stats kxfprst: KSLBEGIN:1 0 7 7
parameter table allocation management ksp_param_table_free 0 189 189
post/wait queue ksliwat:remove 0 1 1
process allocation ksucrp 0 4 0
query server freelists kxfpobadf 0 7 7
query server freelists kxfpobrmf 0 1 1
redo allocation kcrfw_redo_gen: redo allocation 1 0 1,600 0
redo allocation kcrfw_redo_gen: redo allocation 3 0 740 2,764
redo allocation kcrfw_redo_gen: redo allocation 2 0 216 0
redo allocation kcrfw_redo_write: more space 0 184 78
redo allocation kcrfw_redo_write: before write 0 170 76
redo writing kcrfw_post: after write 0 397 1
redo writing kcrfw_post: rba scn pair 0 90 0
redo writing kcrfw_cal_target_rba 0 12 0
redo writing kcrfwcr 0 1 498
resmgr:actses active list kgskchclass 0 41 20
row cache objects kqreqd: reget 0 657 8
row cache objects kqrpre: find obj 0 137 627
row cache objects kqreqd 0 52 217
row cache objects kqrso 0 5 1
rules engine rule set statistics kwrsoef: find ectx stats 0 1 0
sequence cache kdnssd 0 115 7
sequence cache kdnnxt: cached seq 0 32 1
sequence cache kdnss 0 12 149
session allocation ksuxds: KSUSFCLC not set 0 665 297
session allocation ksursi 0 193 371
session allocation ksuprc 0 154 177
session allocation ksucri 0 124 172
session allocation kxfpqidqr 0 96 129
session allocation ksudlc 0 95 233
session allocation ksuxds: not user session 0 90 99
session allocation kxfprdp 0 90 46
session allocation ksudlp 0 10 1
session allocation kspallmod 0 7 0
session allocation ksusin 0 1 0
session idle bit ksupuc: set busy 0 383 141
session idle bit ksupuc: clear busy 0 141 374
session idle bit ksuxds 0 18 27
session state list latch kpseqd 0 12 2
session state list latch kpscad 0 2 1
shared pool kghalo 0 212 146
shared pool kghupr1 0 207 291
shared pool kghfrunp: clatch: nowait 0 103 0
shared pool kghfrunp: alloc: session dur 0 46 22
shared pool kghfrunp: clatch: wait 0 44 44
shared pool kghfre 0 29 49
shared pool kghfrunp: alloc: wait 0 11 0
shared pool kghalp 0 10 8
shared pool kghfrh 0 1 0
shared pool simulator kglsim_unpin_simhp 0 2 2
sort extent pool ktstdt: dealloc sort extent 0 9 3
sort extent pool ktstdt: return extent 0 6 1
sort extent pool ktstaddextent1 0 1 1
sort extent pool ktstfd 0 1 0
sort extent pool ktstsmonmsg 0 1 10
undo global data kturimugur: child 0 5,574 4,122
undo global data ktudba: KSLBEGIN 0 3,251 4,739
undo global data ktudnx:child 0 15 3
undo global data ktucof: at start 0 12 0
undo global data ktubnd:child 0 9 4
undo global data ktufrbs: child 0 7 8
undo global data ktusmasp: ktugd_tuux 0 6 1

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 80,756,800 4.35
APPLSYS APPS_TS_SEED WF_EVENTS_U1   INDEX 48,419,504 2.61
APPLSYS APPS_TS_SEED WF_EVENTS   TABLE 48,292,576 2.60
APPLSYS APPS_TS_SEED WF_EVENT_SUBSCRIPTIONS   TABLE 40,998,800 2.21
WSH APPS_TS_TX_DATA WSH_DELIVERY_DETAILS   TABLE 23,874,944 1.29

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,084 7.68
AR APPS_ASSM_DATA RA_CUSTOMER_TRX_LINES_ALL   TABLE 12,994 2.84
WSH APPS_TS_TX_DATA WSH_DELIVERY_DETAILS   TABLE 9,554 2.09
HR APPS_TS_TX_IDX PAY_PERSON_LATEST_BALA_N50   INDEX 4,777 1.05
HR APPS_ASSM_DATA PAY_RUN_RESULTS   TABLE 4,048 0.89

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
APPLSYS APPS_TS_TX_IDX WF_ITEM_ACTIVITY_STATUSES_N1   INDEX 14,419 30.72
WSH APPS_TS_TX_DATA WSH_TRIP_STOPS   TABLE 9,506 20.25
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_U1   INDEX 9,134 19.46
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N6   INDEX 3,444 7.34
HR APPS_ASSM_IDX PAY_RUN_RESULT_VALUES_PK   INDEX 1,709 3.64

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 20 29.85
GL APPS_ASSM_IDX GL_IMPORT_REFERENCES_N1   INDEX 13 19.40
APPLSYS APPS_TS_TX_IDX WF_ITEM_ATTRIBUTE_VALUES_PK   INDEX 11 16.42
GL APPS_ASSM_IDX GL_IMPORT_REFERENCES_N3   INDEX 6 8.96
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N1   INDEX 4 5.97

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 174,047 36.46
APPLSYS APPS_TS_TX_DATA WF_ITEM_ATTRIBUTE_VALUES   TABLE 81,320 17.04
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N6   INDEX 26,120 5.47
GL APPS_ASSM_DATA GL_JE_LINES   TABLE 19,338 4.05
AR APPS_ASSM_DATA RA_CUST_TRX_LINE_GL_DIST_ALL   TABLE 19,228 4.03

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control 6 16.67 0   2 1
dc_constraints 600 46.83 0   600 157
dc_files 6,660 1.67 0   0 111
dc_global_oids 4,717,650 0.00 0   0 48
dc_histogram_data 5,253 11.54 0   0 705
dc_histogram_defs 294,189 3.47 0   4,013 4,185
dc_object_grants 44,316 0.07 0   0 122
dc_object_ids 8,008,334 0.02 0   54 1,607
dc_objects 120,559 1.27 0   313 1,231
dc_profiles 6,280 0.00 0   0 1
dc_rollback_segments 48,456 0.07 0   99 271
dc_segments 253,858 0.81 0   14,580 1,867
dc_sequences 44,083 0.11 0   44,083 120
dc_table_scns 15,578 0.05 0   0 5
dc_tablespace_quotas 14,348 0.16 0   210 51
dc_tablespaces 3,919,201 0.00 0   0 22
dc_usernames 322,002 0.01 0   0 19
dc_users 9,366,242 0.00 0   0 71
outstanding_alerts 270 47.78 0   3 43


Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY 418,681 0.03 28,674,648 -0.02 32 0
CLUSTER 92 0.00 214 1.40 3 0
INDEX 9,580 0.64 10,373 0.90 4 0
JAVA DATA 614 0.00 0   0 0
PIPE 31,176 2.63 45,794 1.75 0 0
SQL AREA 5,736 81.97 83,065,428 0.41 2,596 387
TABLE/PROCEDURE 268,394 0.36 39,923,010 -0.03 1,268 0
TRIGGER 18,557 0.15 1,206,899 0.00 27 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 20,992.72   10.85 6.34 36 36 1,934 1,934
  SQL 1,986.55 1,014.69 1.03 0.67 4 21 1,928 1,926
  Freeable 1,824.88 0.00 1.14 0.71 9   1,607 1,607
  PL/SQL 1,334.66 113.79 0.69 0.91 3 3 1,934 1,934
  JAVA 160.58 159.94 2.23 0.35 5 7 72 72
E Other 27,204.04   13.87 8.57 56 56 1,962 1,962
  Freeable 2,615.88 0.00 1.51 0.93 9   1,731 1,731
  SQL 2,441.05 1,277.19 1.25 0.76 5 21 1,956 1,954
  PL/SQL 1,675.39 134.38 0.85 0.98 3 3 1,962 1,962
  JAVA 160.20 159.57 2.23 0.35 5 7 72 72

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers 19,226,689,536 19,092,471,808
Fixed Size 2,111,120  
Redo Buffers 14,663,680  
Variable Size 2,231,372,144 2,365,589,872

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 36.16 34.71 -4.00
shared KGLS heap 48.56   -100.00
shared KTI-UNDO 44.33 44.33 0.00
shared PCursor 22.37 22.59 0.98
shared PL/SQL MPCODE 67.84 70.31 3.65
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 322.20 351.30 9.03
shared library cache 502.52 627.62 24.90
shared parameter table block 35.49 35.84 0.99
shared private strands 83.14 83.14 0.00
shared sessions 30.35 30.35 0.00
shared sql area 322.68 347.21 7.60
shared trace buffer 30.23 30.92 2.27
  buffer_cache 18,336.00 18,208.00 -0.70
  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