WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host
VIS 187584551 VIS 1 10.2.0.3.0 NO hpdb1.zko.hp

  Snap Id Snap Time Sessions Cursors/Session
Begin Snap: 1 16-Apr-09 11:56:54 3803 205.8
End Snap: 2 16-Apr-09 12:56:59 3828 236.2
Elapsed:   60.07 (mins)    
DB Time:   288.69 (mins)    

 

Report Summary

Cache Sizes

  Begin End    
Buffer Cache: 18,176M 18,032M Std Block Size: 8K
Shared Pool Size: 2,208M 2,352M Log Buffer: 14,320K

Load Profile

  Per Second Per Transaction
Redo size: 8,369,420.66 31,135.36
Logical reads: 501,933.11 1,867.26
Block changes: 51,617.23 192.02
Physical reads: 121.70 0.45
Physical writes: 798.41 2.97
User calls: 9,851.26 36.65
Parses: 1,963.26 7.30
Hard parses: 2.08 0.01
Sorts: 2,411.21 8.97
Logons: 2.11 0.01
Executes: 23,209.50 86.34
Transactions: 268.81  

% Blocks changed per Read: 10.28 Recursive Call %: 79.31
Rollback per transaction %: 19.21 Rows per Sort: 12.74

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.96 Redo NoWait %: 100.00
Buffer Hit %: 99.98 In-memory Sort %: 100.00
Library Hit %: 99.86 Soft Parse %: 99.89
Execute to Parse %: 91.54 Latch Hit %: 98.93
Parse CPU to Parse Elapsd %: 88.34 % Non-Parse CPU: 97.98

Shared Pool Statistics

  Begin End
Memory Usage %: 83.28 84.90
% SQL with executions>1: 92.03 90.74
% Memory for SQL w/exec>1: 72.66 68.94

Top 5 Timed Events

Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class
CPU time   15,720   90.8  
db file sequential read 265,615 989 4 5.7 User I/O
log file sync 406,666 670 2 3.9 Commit
log file parallel write 697,258 467 1 2.7 System I/O
db file parallel write 264,960 226 1 1.3 System I/O

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic Name Time (s) % of DB Time
DB CPU 15,720.47 90.76
sql execute elapsed time 14,911.63 86.09
PL/SQL execution elapsed time 3,371.27 19.46
inbound PL/SQL rpc elapsed time 2,957.45 17.07
Java execution elapsed time 431.92 2.49
parse time elapsed 409.44 2.36
hard parse elapsed time 209.25 1.21
repeated bind elapsed time 57.94 0.33
sequence load elapsed time 11.01 0.06
connection management call elapsed time 7.24 0.04
PL/SQL compilation elapsed time 6.00 0.03
hard parse (sharing criteria) elapsed time 3.47 0.02
hard parse (bind mismatch) elapsed time 0.98 0.01
failed parse elapsed time 0.96 0.01
DB time 17,321.28  
background elapsed time 1,065.97  
background cpu time 308.02  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait Class Waits %Time -outs Total Wait Time (s) Avg wait (ms) Waits /txn
User I/O 322,357 0.00 1,140 4 0.33
System I/O 993,112 0.00 702 1 1.03
Commit 406,666 0.00 670 2 0.42
Network 40,665,794 0.00 181 0 41.97
Concurrency 1,725,630 0.19 92 0 1.78
Application 50,530 0.01 52 1 0.05
Other 125,242 18.05 29 0 0.13
Configuration 6,827 0.00 3 0 0.01

Back to Wait Events Statistics
Back to Top

Wait Events

Event Waits %Time -outs Total Wait Time (s) Avg wait (ms) Waits /txn
db file sequential read 265,615 0.00 989 4 0.27
log file sync 406,666 0.00 670 2 0.42
log file parallel write 697,258 0.00 467 1 0.72
db file parallel write 264,960 0.00 226 1 0.27
SQL*Net more data from client 1,853,206 0.00 135 0 1.91
db file scattered read 13,126 0.00 81 6 0.01
read by other session 40,815 0.00 69 2 0.04
cursor: pin S wait on X 3,622 89.01 35 10 0.00
SQL*Net message to client 37,193,426 0.00 34 0 38.39
enq: UL - contention 2,517 0.16 21 8 0.00
latch: cache buffers chains 1,046,107 0.00 13 0 1.08
buffer busy waits 619,271 0.00 13 0 0.64
library cache load lock 550 0.00 12 22 0.00
SQL*Net more data to client 1,619,162 0.00 12 0 1.67
SQL*Net break/reset to client 47,444 0.00 11 0 0.05
enq: TX - row lock contention 530 0.38 10 19 0.00
enq: TX - index contention 26,488 0.00 9 0 0.03
PX Deq Credit: send blkd 23,038 0.00 9 0 0.02
control file sequential read 29,155 0.00 8 0 0.03
rdbms ipc reply 4 50.00 7 1653 0.00
enq: TM - contention 6 0.00 5 883 0.00
enq: RO - fast object reuse 33 0.00 5 149 0.00
latch: library cache 6,349 0.00 3 0 0.01
PX Deq: Signal ACK 278 30.22 3 11 0.00
latch: undo global data 32,164 0.00 3 0 0.03
kksfbc child completion 57 75.44 2 38 0.00
os thread startup 70 0.00 2 28 0.00
enq: HW - contention 2,464 0.00 2 1 0.00
latch: In memory undo latch 16,193 0.00 2 0 0.02
control file parallel write 1,739 0.00 1 1 0.00
local write wait 1,556 0.00 1 1 0.00
LGWR wait for redo copy 24,945 0.00 1 0 0.03
latch: object queue header operation 12,134 0.00 1 0 0.01
log buffer space 106 0.00 1 7 0.00
enq: TX - contention 2,752 0.00 1 0 0.00
latch: library cache pin 1,611 0.00 1 0 0.00
enq: DV - contention 173 0.00 1 3 0.00
enq: SQ - contention 4,160 0.00 1 0 0.00
latch: cache buffers lru chain 982 0.00 0 0 0.00
wait list latch free 33 0.00 0 11 0.00
latch free 594 0.00 0 0 0.00
direct path read 732 0.00 0 0 0.00
row cache lock 2,521 0.00 0 0 0.00
library cache pin 1,416 0.00 0 0 0.00
latch: row cache objects 488 0.00 0 0 0.00
buffer deadlock 22,409 99.24 0 0 0.02
SGA: allocation forcing component growth 19 47.37 0 11 0.00
latch: session allocation 522 0.00 0 0 0.00
latch: redo allocation 499 0.00 0 0 0.00
latch: shared pool 494 0.00 0 0 0.00
latch: library cache lock 95 0.00 0 1 0.00
enq: FB - contention 768 0.00 0 0 0.00
enq: CU - contention 1 0.00 0 61 0.00
latch: cache buffer handles 191 0.00 0 0 0.00
latch: messages 172 0.00 0 0 0.00
latch: object queue header heap 103 0.00 0 0 0.00
PX qref latch 281 79.36 0 0 0.00
reliable message 31 0.00 0 1 0.00
cursor: pin S 3,003 0.00 0 0 0.00
L1 validation 5 40.00 0 4 0.00
db file parallel read 1 0.00 0 21 0.00
enq: US - contention 7 0.00 0 2 0.00
latch: redo writing 30 0.00 0 0 0.00
library cache lock 3 0.00 0 4 0.00
enq: TX - allocate ITL entry 58 0.00 0 0 0.00
latch: checkpoint queue latch 16 0.00 0 1 0.00
cursor: mutex S 137 0.00 0 0 0.00
latch: enqueue hash chains 14 0.00 0 1 0.00
buffer exterminate 1 0.00 0 7 0.00
direct path write 442 0.00 0 0 0.00
enq: PS - contention 44 0.00 0 0 0.00
write complete waits 9 0.00 0 0 0.00
cursor: mutex X 215 0.00 0 0 0.00
direct path write temp 51 0.00 0 0 0.00
direct path read temp 19 0.00 0 0 0.00
latch: parallel query alloc buffer 1 0.00 0 0 0.00
cursor: pin X 1 0.00 0 0 0.00
SQL*Net message from client 37,193,403 0.00 7,370,955 198 38.39
pipe get 22,175 21.01 21,078 951 0.02
Streams AQ: waiting for time management or cleanup tasks 2,359 38.45 3,513 1489 0.00
Streams AQ: qmn coordinator idle wait 256 50.00 3,487 13622 0.00
Streams AQ: qmn slave idle wait 128 0.00 3,487 27243 0.00
PX Idle Wait 1,603 75.86 2,518 1571 0.00
PL/SQL lock timer 193 99.48 2,207 11436 0.00
jobq slave wait 613 99.84 1,795 2929 0.00
PX Deq: Execution Msg 5,125 0.00 38 7 0.01
PX Deq: Execute Reply 2,627 0.00 3 1 0.00
PX Deq Credit: need buffer 4,322 0.00 1 0 0.00
PX Deq: Msg Fragment 4,286 0.00 1 0 0.00
PX Deq: Table Q Normal 5,393 0.00 0 0 0.01
PX Deq: Parse Reply 242 0.00 0 0 0.00
PX Deq: Join ACK 293 0.00 0 0 0.00
class slave wait 1 0.00 0 0 0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

Event Waits %Time -outs Total Wait Time (s) Avg wait (ms) Waits /txn
log file parallel write 697,262 0.00 467 1 0.72
db file parallel write 264,905 0.00 226 1 0.27
control file sequential read 827 0.00 3 3 0.00
events in waitclass Other 30,407 0.00 2 0 0.03
db file scattered read 318 0.00 2 6 0.00
os thread startup 62 0.00 2 29 0.00
control file parallel write 1,739 0.00 1 1 0.00
db file sequential read 251 0.00 1 3 0.00
direct path read 732 0.00 0 0 0.00
latch: cache buffers chains 71 0.00 0 0 0.00
latch: redo writing 30 0.00 0 0 0.00
direct path write 333 0.00 0 0 0.00
log file sync 1 0.00 0 0 0.00
buffer busy waits 9 0.00 0 0 0.00
latch: library cache 2 0.00 0 0 0.00
latch: shared pool 1 0.00 0 0 0.00
rdbms ipc message 1,506,719 0.81 36,502 24 1.56
pmon timer 1,322 91.23 3,513 2658 0.00
Streams AQ: waiting for time management or cleanup tasks 2,359 38.45 3,513 1489 0.00
smon timer 117,689 0.00 3,508 30 0.12
Streams AQ: qmn coordinator idle wait 256 50.00 3,487 13622 0.00
Streams AQ: qmn slave idle wait 128 0.00 3,487 27243 0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic Total
BUSY_TIME 1,680,905
IDLE_TIME 4,085,707
IOWAIT_TIME 77,012
NICE_TIME 0
SYS_TIME 71,095
USER_TIME 1,565,427
LOAD 3
RSRC_MGR_CPU_WAIT_TIME 0
PHYSICAL_MEMORY_BYTES 64,659,708
NUM_CPUS 16
NUM_CPU_SOCKETS 4

Back to Wait Events Statistics
Back to Top

Service Statistics

Service Name DB Time (s) DB CPU (s) Physical Reads Logical Reads
SYS$USERS 17,319.40 15,719.10 423,005 1,806,142,571
SYS$BACKGROUND 0.00 0.00 15,652 2,870,338
VIS 0.00 0.00 0 0

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

Service Name User I/O Total Wts User I/O Wt Time Concurcy Total Wts Concurcy Wt Time Admin Total Wts Admin Wt Time Network Total Wts Network Wt Time
SYS$USERS 320722 113717 1725477 8996 0 0 40653827 18139
SYS$BACKGROUND 1636 290 145 180 0 0 0 0

Back to Wait Events Statistics
Back to Top

 

SQL Statistics

Back to Top

SQL ordered by Elapsed Time

Elapsed Time (s) CPU Time (s) Executions Elap per Exec (s) % Total DB Time SQL Id SQL Module SQL Text
640 638 304 2.11 3.70 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
329 328 55,054 0.01 1.90 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
305 278 78,437 0.00 1.76 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
296 295 55,034 0.01 1.71 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...
268 268 55,038 0.00 1.55 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
259 256 61,301 0.00 1.49 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
211 210 259,669 0.00 1.22 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
201 198 1,008 0.20 1.16 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
188 77 1,684 0.11 1.09 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
180 11 1,684 0.11 1.04 3dssuqfjsynrk asn.lead.server.LeadUwqAM SELECT count(1) FROM (SELECT *...
175 107 15,135 0.01 1.01 1q78dwnrrkf6c asn.lead.server.LeadUwqAM BEGIN ASN_SALES_PVT.Lead_Proce...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

CPU Time (s) Elapsed Time (s) Executions CPU per Exec (s) % Total DB Time SQL Id SQL Module SQL Text
638 640 304 2.10 3.70 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
328 329 55,054 0.01 1.90 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
295 296 55,034 0.01 1.71 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...
278 305 78,437 0.00 1.76 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
268 268 55,038 0.00 1.55 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
256 259 61,301 0.00 1.49 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
210 211 259,669 0.00 1.22 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
198 201 1,008 0.20 1.16 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
150 150 155,037 0.00 0.87 5kqw5535fjvw6 ARXTWMAI SELECT NVL(RCTT.ATTRIBUTE10, ...
148 150 56,304 0.00 0.87 bfbyqwbr4vwms OEXOETEL begin OE_OEOL_SCH.SCHEDULE_LIN...
107 175 15,135 0.01 1.01 1q78dwnrrkf6c asn.lead.server.LeadUwqAM BEGIN ASN_SALES_PVT.Lead_Proce...
77 188 1,684 0.05 1.09 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
11 180 1,684 0.01 1.04 3dssuqfjsynrk asn.lead.server.LeadUwqAM SELECT count(1) FROM (SELECT *...

Back to SQL Statistics
Back to Top

SQL ordered by Gets

Buffer Gets Executions Gets per Exec %Total CPU Time (s) Elapsed Time (s) SQL Id SQL Module SQL Text
59,441,251 155,037 383.40 3.29 150.28 150.33 5kqw5535fjvw6 ARXTWMAI SELECT NVL(RCTT.ATTRIBUTE10, ...
44,281,966 55,054 804.34 2.45 327.95 328.74 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
42,220,280 304 138,882.50 2.33 637.95 640.16 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
32,777,935 55,038 595.55 1.81 267.67 268.00 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
29,205,600 166,848 175.04 1.61 144.94 145.42 3b3psftuyks81 INVTTMTX BEGIN INV_TXNSTUB_PUB.postTran...
29,201,285 166,835 175.03 1.61 135.05 135.53 gf1u933c95jb5 INVTTMTX DECLARE l_ret_stat varchar2...
27,466,354 61,301 448.06 1.52 256.45 258.94 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
26,485,417 1,384,115 19.14 1.46 91.20 91.31 66tmsr3446uqn ap.oie.server.WebExpensesAM SELECT WIAS.ACTIVITY_STATUS, ...
26,399,248 10,000 2,639.92 1.46 74.86 154.00 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
24,056,843 55,034 437.13 1.33 295.00 295.71 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...
18,165,504 141,817 128.09 1.00 133.56 157.94 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical Reads Executions Reads per Exec %Total CPU Time (s) Elapsed Time (s) SQL Id SQL Module SQL Text
45,238 10,000 4.52 10.31 74.86 154.00 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
42,742 1,684 25.38 9.74 10.99 179.98 3dssuqfjsynrk asn.lead.server.LeadUwqAM SELECT count(1) FROM (SELECT *...
29,101 1,684 17.28 6.63 76.86 188.26 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
20,355 15,135 1.34 4.64 106.73 175.03 1q78dwnrrkf6c asn.lead.server.LeadUwqAM BEGIN ASN_SALES_PVT.Lead_Proce...
9,100 502 18.13 2.07 55.90 86.52 dk0sqcvc2xjvs qotSCopHdrUpd.jsp BEGIN ASO_QUOTE_PUB_W.Create_Q...
9,075 5,046 1.80 2.07 76.57 111.20 8jb36w62w5hqf ibuSRDetailsActions.jsp BEGIN IBU_REQ_PKG.UpdateServic...
9,037 141,817 0.06 2.06 133.56 157.94 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
4,588 10,000 0.46 1.05 114.33 125.21 csvvv0fmhr1yc PYUSLV BEGIN FFP1893_01010001.FORMULA...
4,504 10,000 0.45 1.03 94.19 101.77 63t8zpm02skgh PYUSLV SELECT DECODE(COUNT(PRR.RUN_RE...
2,689 70,644 0.04 0.61 76.80 82.06 7dtkxnqpkqszw jtfavald.jsp SELECT DISTINCT a.PERMISSION_...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows Processed Rows per Exec CPU per Exec (s) Elap per Exec (s) SQL Id SQL Module SQL Text
1,384,115 716,616 0.52 0.00 0.00 66tmsr3446uqn ap.oie.server.WebExpensesAM SELECT WIAS.ACTIVITY_STATUS, ...
788,595 788,595 1.00 0.00 0.00 cd9mbmqyf4qhp ap.oie.server.WebExpensesAM UPDATE WF_ITEM_ACTIVITY_STATUS...
419,366 419,367 1.00 0.00 0.00 avc1jqzz04wpr JDBC Thin Client SELECT 'x' FROM DUAL
259,669 259,667 1.00 0.00 0.00 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
259,011 202,107 0.78 0.00 0.00 fmfdkztk8vx23   SELECT CATEGORY, SEVERITY, F...
203,982 3,467,551 17.00 0.00 0.00 cwyx16zn1hpfb JDBC Thin Client select parameter, value from ...
166,849 166,848 1.00 0.00 0.00 6gnth2mfbs2nq INVTTMTX declare v_ret number := 0...
166,848 166,848 1.00 0.00 0.00 3b3psftuyks81 INVTTMTX BEGIN INV_TXNSTUB_PUB.postTran...
166,835 166,835 1.00 0.00 0.00 gf1u933c95jb5 INVTTMTX DECLARE l_ret_stat varchar2...
155,037 155,031 1.00 0.00 0.00 5kqw5535fjvw6 ARXTWMAI SELECT NVL(RCTT.ATTRIBUTE10, ...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse Calls Executions % Total Parses SQL Id SQL Module SQL Text
419,370 419,366 5.93 avc1jqzz04wpr JDBC Thin Client SELECT 'x' FROM DUAL
259,664 259,669 3.67 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
259,012 259,011 3.66 fmfdkztk8vx23   SELECT CATEGORY, SEVERITY, F...
203,982 203,982 2.88 cwyx16zn1hpfb JDBC Thin Client select parameter, value from ...
166,850 166,849 2.36 6gnth2mfbs2nq INVTTMTX declare v_ret number := 0...
141,817 141,817 2.00 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
117,655 117,653 1.66 fb13x9qx0ftks OEXOETEL begin OE_STANDARD_WF.OEOL_SELE...
111,795 111,793 1.58 1c0b7sas42w2z INVTTMTX SELECT NVL(ITEM_COST, 0), ...
88,921 88,918 1.26 76sw2a4vnc89j icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.S...
84,716 84,715 1.20 608c0n36kaw62 icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.C...
84,716 84,706 1.20 bf7uwg5pa3pj6 icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.V...
84,716 88,916 1.20 dcvv68fju01g4 icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.E...
84,294 84,293 1.19 162ttnv4ubqun OEXOETEL begin OE_DS_PVT.Check_PO_Appr...
77,989 77,989 1.10 8camsgjsr9zya OEXOETEL begin OE_TRANSACTION_TYPES_PK...

Back to SQL Statistics
Back to Top

 

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

 

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

 

Complete List of SQL Text

SQL Id SQL Text
0z318y6g3uagc declare l_retstat varchar2 ( 3 ) ; l_msg_data varchar2 ( 244 ) ; l_msg_cnt number ; l_trx_cnt number ; BEGIN :retval := INV_TXN_MANAGER_PUB . process_Transactions ( p_api_version => 1.0 , p_commit => fnd_api . g_true , x_return_status => l_retstat , x_msg_count => l_msg_cnt , x_msg_data => l_msg_data , x_trans_count => l_trx_cnt , p_table => 1 , p_header_id => :header_id ) ; END ;
162ttnv4ubqun begin OE_DS_PVT.Check_PO_Approved( :t_application_id, :t_entity_short_name, :t_validation_entity_short_name, :t_validation_tmplt_short_name, :t_record_set_short_name, :t_scope, :t_result ); end;
1c0b7sas42w2z SELECT NVL(ITEM_COST, 0), COST_UPDATE_ID FROM CST_ITEM_COSTS WHERE INVENTORY_ITEM_ID = :1 AND ORGANIZATION_ID = :2 AND COST_TYPE_ID = :3
1q78dwnrrkf6c BEGIN ASN_SALES_PVT.Lead_Process_After_Update( P_Api_Version_Number => 2.0, P_Init_Msg_List => FND_API.G_TRUE, p_Commit => FND_API.G_FALSE, p_Validation_Level => FND_API.G_VALID_LEVEL_NONE, P_Identity_Salesforce_Id => :1, P_Salesgroup_id => :2, P_Sales_Lead_Id => :3, X_Return_Status => :4, X_Msg_Count => :5, X_Msg_Data => :6); END;
3b3psftuyks81 BEGIN INV_TXNSTUB_PUB.postTransaction(:1, :2, :3); END;
3dssuqfjsynrk SELECT count(1) FROM (SELECT * FROM ( SELECT LeadEO.sales_lead_id as SalesLeadId , to_char(hz_timezone_pub.convert_datetime(:1, hcp.timezone_id, SYSDATE), 'HH:MI AM ') ||' '||ht.standard_time_short_code as PrimaryContactLocalTime , SUBSTRB(LeadEO.description, 1, 240) as Description , hp.party_name as ContactName , custParty.party_name as CustomerName , aslt.meaning as RankName , ast.meaning as LeadStatus , ROUND(SYSDATE - LeadEO.creation_date) as Age , DECODE(LeadEO.status_code, 'CONVERTED_TO_OPPORTUNITY', 'ASNCnvToOpptyDsbld', 'ASNCnvToOpptyEnbld') as ASNLeadLstCnvToOppty , LeadEO.customer_id , hp.party_id , LeadEO.primary_contact_party_id , hr.relationship_id FROM as_sales_leads LeadEO , ( SELECT /*+ no_merge */ distinct aaa.sales_lead_id, aaa.customer_id FROM as_accesses_all aaa WHERE aaa.sales_lead_id IS NOT NULL AND aaa.lead_id IS NULL AND aaa.salesforce_id = :2) secu , as_statuses_tl ast , as_sales_lead_ranks_tl aslt , hz_parties CustParty , hz_parties hp, hz_relationships hr , hz_contact_points hcp , hz_timezones ht , ams_source_codes amsc WHERE LeadEO.sales_lead_id = secu.sales_lead_id AND LeadEO.customer_id = secu.customer_id AND LeadEO.status_code = ast.status_code AND ast.language = USERENV('LANG') AND LeadEO.lead_rank_id = aslt.rank_id (+) AND aslt.language (+) = USERENV('LANG') AND LeadEO.customer_id = CustParty.party_id AND LeadEO.primary_contact_party_id = hr.party_id(+) AND hr.subject_ id = hp.party_id (+) AND hr.subject_table_name (+) = 'HZ_PARTIES' AND hr.object_id(+) = LeadEO.customer_id AND hr.object_table_name (+) = 'HZ_PARTIES' AND LeadEO.primary_contact_party_id = hcp.owner_table_id(+) AND hcp.owner_table_name (+) = 'HZ_PARTIES' AND hcp.primary_flag (+) = 'Y' AND hcp.contact_point_type (+) = 'PHONE' AND hcp.timezone_id = ht.timezone_id (+) AND LeadEO.source_promotion_id = amsc.source_code_id AND amsc.source_code_for_id = :3 AND LeadEO.status_code = :4 ORDER BY age ) )
4yak7x2zqz0dh BEGIN inv_transfer_order_pvt.finalize_pick_confirm(:1, :2, :3, :4, :5, :6, :7); END;
5kqw5535fjvw6 SELECT NVL(RCTT.ATTRIBUTE10, ' ') FROM RA_CUST_TRX_TYPES_ALL RCTT, RA_CUSTOMER_TRX_ALL RCT WHERE RCT.CUSTOMER_TRX_ID = :B1 AND RCT.CUST_TRX_TYPE_ID = RCTT.CUST_TRX_TYPE_ID
608c0n36kaw62 begin FND_FLEX_WORKFLOW_APIS.COPY_FROM_COMBINATION (:v1, :v2, :v3, :v4, :v5); end;
63t8zpm02skgh SELECT DECODE(COUNT(PRR.RUN_RESULT_ID), 0, 'N', 'Y') FROM PAY_RUN_RESULTS PRR, PAY_ASSIGNMENT_ACTIONS ASA, PAY_PAYROLL_ACTIONS PPA WHERE PRR.SOURCE_ID = :B3 AND PRR.SOURCE_TYPE IN ('E', 'I') AND PRR.STATUS IN ('P', 'PA', 'R', 'O') AND ASA.ASSIGNMENT_ACTION_ID = PRR.ASSIGNMENT_ACTION_ID AND PPA.PAYROLL_ACTION_ID = ASA.PAYROLL_ACTION_ID AND NOT EXISTS (SELECT NULL FROM PAY_RUN_RESULTS PRR2 WHERE PRR2.SOURCE_ID = PRR.RUN_RESULT_ID AND PRR2.SOURCE_TYPE IN ('R', 'V')) AND PPA.DATE_EARNED BETWEEN :B2 AND :B1
64qc329wgjv39 select /*+ ORDERED INDEX(ASSBAL PAY_ASSIGNMENT_LATEST_BALA_N1) INDEX(DEFBAL PAY_DEFINED_BALANCES_PK) INDEX(ACT PAY_ASSIGNMENT_ACTIONS_PK) INDEX(PACT PAY_PAYROLL_ACTIONS_PK) INDEX(VALUE PAY_BALANCE_CONTEXT_VALUES_PK) USE_NL(ASSBAL DEFBAL ACT PACT VALUE) +*/ ASSBAL.defined_balance_id , DEFBAL.balance_dimension_id , to_char(ASSBAL.value) , ASSBAL.latest_balance_id , ASSBAL.rowid , to_char(ASSBAL.assignment_action_id) , ACT.payroll_action_id , to_char(PACT.effective_date, :b0) , to_number(to_char(PACT.effective_date, 'J')) , nvl(VALUE.context_id, 0) , nvl(VALUE.value, 'NULL') , to_char(ASSBAL.expired_assignment_action_id) , to_char(ASSBAL.expired_value) , to_char(ASSBAL.prev_assignment_action_id) , to_char(ASSBAL.prev_balance_value) from pay_assignment_latest_balances ASSBAL , pay_defined_balances DEFBAL , pay_assignment_actions ACT , pay_payroll_actions PACT , pay_balance_context_values VALUE where ((((ASSBAL.assignment_id=:b1 and ACT.assignment_action_id=ASSBAL.assignment_action_id) and PACT.payroll_action_id=ACT.payroll_action_id) and DEFBAL.defined_balance_id=ASSBAL.defined_balance_id) and VALUE.latest_balance_id(+)=ASSBAL.latest_balance_id) union all select /*+ ORDERED INDEX(PERBAL PAY_PERSON_LATEST_BALANCES_N2) INDEX(DEFBAL PAY_DEFINED_BALANCES_PK) INDEX(ACT PAY_ASSIGNMENT_ACTIONS_PK) INDEX(VALUE PAY_BALANCE_CONTEXT_VALUES_PK) INDEX(PACT PAY_PAYROLL_ACTIONS_PK) USE_NL(PERBAL DEFBAL ACT PACT VALUE) +*/ PERBAL.defined_balance_id , DEFBAL.balance_dimension_id , to_char (PERBAL.value) , PERBAL.latest_balance_id , PERBAL.rowid , to_char(PERBAL.assignment_action_id) , ACT.payroll_action_id , to_char(PACT.effective_date, :b0) , to_number(to_char(PACT.effective_date, 'J')) , nvl(VALUE.context_id, 0) , nvl(VALUE.value, 'NULL') , to_char(PERBAL.expired_assignment_action_id) , to_char(PERBAL.expired_value) , to_char(PERBAL.prev_assignment_action_id) , to_char(PERBAL.prev_balance_value) from pay_person_latest_balances PERBAL , pay_defined_balances DEFBAL , pay_assignment_actions ACT , pay_payroll_actions PACT , pay_balance_context_values VALUE where ((((PERBAL.person_id=:b3 and ACT.assignment_action_id=PERBAL.assignment_action_id) and PACT.payroll_action_id=ACT.payroll_action_id) and DEFBAL.defined_balance_id=PERBAL.defined_balance_id) and VALUE.latest_balance_id(+)=PERBAL.latest_balance_id) order by 6, 2, 1, 4, 10 desc
66tmsr3446uqn SELECT WIAS.ACTIVITY_STATUS, WIAS.ACTIVITY_RESULT_CODE, WIAS.ASSIGNED_USER, WIAS.NOTIFICATION_ID, WIAS.BEGIN_DATE, WIAS.END_DATE, WIAS.DUE_DATE, WIAS.ERROR_NAME, WIAS.ERROR_MESSAGE, WIAS.ERROR_STACK FROM WF_ITEM_ACTIVITY_STATUSES WIAS WHERE WIAS.ITEM_TYPE = :B3 AND WIAS.ITEM_KEY = :B2 AND WIAS.PROCESS_ACTIVITY = :B1
6gnth2mfbs2nq declare v_ret number := 0; begin if (INV_TABLE_LOCK_PVT.lock_onhand_records(:1, :2, :3, :4, :5, :6, :7) ) then v_ret := 1; end if; :8 := v_ret; end;
6h2tpcxpymqu7 BEGIN :1 := FND_AOLJ_UTIL.is_Valid_ICX(:2, NULL, 'Y', TRUE, TRUE, NULL, NULL, NULL, NULL, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, TRUE);:19 := fnd_session_management.g_enc_key;:20 := fnd_session_management.g_mac_key;END;
76sw2a4vnc89j begin FND_FLEX_WORKFLOW_APIS.START_GENERATION (:v1, :v2, :v3, :v4, :v5); end;
7dtkxnqpkqszw SELECT DISTINCT a.PERMISSION_NAME, dom.DOMAIN_NAME, a.MAINTENANCE_MODE_FLAG FROM JTF_AUTH_PERMISSIONS_B A, JTF_AUTH_PRINCIPAL_MAPS B, JTF_AUTH_ROLE_PERMS C, JTF_AUTH_PRINCIPALS_B D, JTF_AUTH_PRINCIPALS_B E, JTF_AUTH_DOMAINS_B dom WHERE D.PRINCIPAL_NAME = :1 AND D.IS_USER_FLAG = 1 AND D.JTF_AUTH_PRINCIPAL_ID = B.JTF_AUTH_PRINCIPAL_ID AND B.JTF_AUTH_PARENT_PRINCIPAL_ID=E.JTF_AUTH_PRINCIPAL_ID AND E.IS_USER_FLAG = 0 AND E.JTF_AUTH_PRINCIPAL_ID = C.JTF_AUTH_PRINCIPAL_ID AND C.JTF_AUTH_PERMISSION_ID = A.JTF_AUTH_PERMISSION_ID AND C.POSITIVE_FLAG=1 AND B.JTF_AUTH_DOMAIN_ID = dom.JTF_AUTH_DOMAIN_ID ORDER BY A.PERMISSION_NAME
827gtfny5uagb begin :con := FND_GENERIC_POLICY.GET_PREDICATE(:sn, :on); end;
8c8cf4vtv4tx2 SELECT * FROM ( SELECT LeadEO.sales_lead_id as SalesLeadId , to_char(hz_timezone_pub.convert_datetime(:1, hcp.timezone_id, SYSDATE), 'HH:MI AM ') ||' '||ht.standard_time_short_code as PrimaryContactLocalTime , SUBSTRB(LeadEO.description, 1, 240) as Description , hp.party_name as ContactName , custParty.party_name as CustomerName , aslt.meaning as RankName , ast.meaning as LeadStatus , ROUND(SYSDATE - LeadEO.creation_date) as Age , DECODE(LeadEO.status_code, 'CONVERTED_TO_OPPORTUNITY', 'ASNCnvToOpptyDsbld', 'ASNCnvToOpptyEnbld') as ASNLeadLstCnvToOppty , LeadEO.customer_id , hp.party_id , LeadEO.primary_contact_party_id , hr.relationship_id FROM as_sales_leads LeadEO , ( SELECT /*+ no_merge */ distinct aaa.sales_lead_id, aaa.customer_id FROM as_accesses_all aaa WHERE aaa.sales_lead_id IS NOT NULL AND aaa.lead_id IS NULL AND aaa.salesforce_id = :2) secu , as_statuses_tl ast , as_sales_lead_ranks_tl aslt , hz_parties CustParty , hz_parties hp, hz_relationships hr , hz_contact_points hcp , hz_timezones ht , ams_source_codes amsc WHERE LeadEO.sales_lead_id = secu.sales_lead_id AND LeadEO.customer_id = secu.customer_id AND LeadEO.status_code = ast.status_code AND ast.language = USERENV('LANG') AND LeadEO.lead_rank_id = aslt.rank_id (+) AND aslt.language (+) = USERENV('LANG') AND LeadEO.customer_id = CustParty.party_id AND LeadEO.primary_contact_party_id = hr.party_id(+) AND hr.subject_id = hp.party_id (+) AND hr.subject_table_name (+) = 'HZ_PARTIES' AND hr.object_id(+) = LeadEO.customer_id AND hr.object_table_name (+) = 'HZ_PARTIES' AND LeadEO.primary_contact_party_id = hcp.owner_table_id(+) AND hcp.owner_table_name (+) = 'HZ_PARTIES' AND hcp.primary_flag (+) = 'Y' AND hcp.contact_point_type (+) = 'PHONE' AND hcp.timezone_id = ht.timezone_id (+) AND LeadEO.source_promotion_id = amsc.source_code_id AND amsc.source_code_for_id = :3 AND LeadEO.status_code = :4 ORDER BY age )
8camsgjsr9zya begin OE_TRANSACTION_TYPES_PKG.Val_Ord_Change( :t_application_id, :t_entity_short_name, :t_validation_entity_short_name, :t_validation_tmplt_short_name, :t_record_set_short_name, :t_scope, :t_result ); end;
8jb36w62w5hqf BEGIN IBU_REQ_PKG.UpdateServiceRequest(:1, :2, -1, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16); END;
9wdrypwkpf607 begin OE_FULFILL_WF.START_FULFILLMENT (:v1, :v2, :v3, :v4, :v5); end;
a29grr748ghc4 BEGIN jdr_custom_internal.getActiveLayers(:1, :2, :3, :4, :5); END;
avc1jqzz04wpr SELECT 'x' FROM DUAL
bf7uwg5pa3pj6 begin FND_FLEX_WORKFLOW_APIS.VALIDATE_COMBINATION (:v1, :v2, :v3, :v4, :v5); end;
bfbyqwbr4vwms begin OE_OEOL_SCH.SCHEDULE_LINE (:v1, :v2, :v3, :v4, :v5); end;
bt0w082dfrm8v BEGIN WSH_SHIP_CONFIRM_ACTIONS.interface_ALL_wrp( :errbuf, :rc, :A0, :A1, :A2, :A3); END;
cd9mbmqyf4qhp UPDATE WF_ITEM_ACTIVITY_STATUSES SET ACTIVITY_STATUS = :B8 , ACTIVITY_RESULT_CODE = NVL(:B13 , ACTIVITY_RESULT_CODE), BEGIN_DATE = NVL(:B11 , BEGIN_DATE), END_DATE = NVL(:B12 , END_DATE), DUE_DATE = DECODE(:B11 , TO_DATE(NULL), DUE_DATE, :B10 ), OUTBOUND_QUEUE_ID = :B9 , EXECUTION_TIME = DECODE(:B8 , :B7 , :B4 , :B6 , NVL(EXECUTION_TIME, :B4 ), :B5 , NVL(EXECUTION_TIME, :B4 ), EXECUTION_TIME) WHERE ITEM_TYPE = :B3 AND ITEM_KEY = :B2 AND PROCESS_ACTIVITY = :B1
csvvv0fmhr1yc BEGIN FFP1893_01010001.FORMULA( :N1, :N4, :T1, :I1, :D1, :T2, :I2, :T7, :I7, :T8, :I8, :T5, :I5, :N3, :T4, :I4, :N2, :N5, :T3, :I3, :T6, :I6, :FFERLN, :FFERCD, :FFERMT); END;
cwyx16zn1hpfb select parameter, value from nls_session_parameters
dcvv68fju01g4 begin FND_FLEX_WORKFLOW_APIS.END_GENERATION (:v1, :v2, :v3, :v4, :v5); end;
dk0sqcvc2xjvs BEGIN ASO_QUOTE_PUB_W.Create_Qte_Opportunity(:1, :2, :3, :4, :5, :6, p_c_auto_version_flag => :7, p_c_pricing_request_type => :8, p_c_header_pricing_event => :9, p_c_cal_tax_flag => :10, p_c_cal_freight_charge_flag => :11, p_c_copy_task_flag => :12, p_c_copy_notes_flag => :13, p_c_copy_att_flag => :14, p_c_deactivate_all => :15, p_c_price_mode => :16, p_source_code => :17, p_op_opportunity_id => :18, p_op_quote_name => :19, p_op_cust_account_id => :20, p_op_resource_id => :21, p_op_sold_to_contact_id => :22, p_op_sold_to_party_site_id => :23, p_op_price_list_id => :24, p_op_resource_grp_id => :25, p_op_channel_code => :26, p_op_order_type_id => :27, p_op_agreement_id => :28, p_op_currency_code => :29, p_op_marketing_source_code_id => :30, p_op_quote_expiration_date => :31, p_op_cust_party_id => :32, p_op_pricing_status_indicator => :33, p_op_tax_status_indicator => :34, x_return_status => :35, x_msg_count => :36, x_msg_data => :37 ); END;
fb13x9qx0ftks begin OE_STANDARD_WF.OEOL_SELECTOR (:v1, :v2, :v3, :v4, :v5); end;
fmfdkztk8vx23 SELECT CATEGORY, SEVERITY, FND_LOG_SEVERITY FROM FND_NEW_MESSAGES WHERE MESSAGE_NAME = :B1 AND APPLICATION_ID = :B2 AND LANGUAGE_CODE = :B3 AND ROWNUM = 1
g8102j8yynbwz begin WF_STANDARD.CONTINUEFLOW (:v1, :v2, :v3, :v4, :v5); end;
gf1u933c95jb5 DECLARE l_ret_stat varchar2(56); BEGIN CSI_INV_TXN_HOOK_PKG.postTransaction( p_header_id => :1 , p_transaction_id => :2 , x_return_status => l_ret_stat ); INV_TXNSTUB_PUB.g_ret_status := l_ret_stat; END;
gksvm8wmzk8w0 begin OE_INVOICE_WF.INVOICE_INTERFACE (:v1, :v2, :v3, :v4, :v5); end;

Back to SQL Statistics
Back to Top

 

Instance Activity Statistics

Back to Top

Instance Activity Stats

Statistic Total per Second per Trans
CPU used by this session 1,550,514 430.19 1.60
CPU used when call started 1,547,360 429.31 1.60
CR blocks created 14,074,639 3,904.97 14.53
Cached Commit SCN referenced 46,140 12.80 0.05
Commit SCN cached 8 0.00 0.00
DB time 4,396,556 1,219.81 4.54
DBWR checkpoint buffers written 2,796,275 775.82 2.89
DBWR checkpoints 34 0.01 0.00
DBWR object drop buffers written 57,613 15.98 0.06
DBWR revisited being-written buffer 169 0.05 0.00
DBWR thread checkpoint buffers written 688,259 190.96 0.71
DBWR transaction table writes 1,800 0.50 0.00
DBWR undo block writes 1,518,951 421.43 1.57
DFO trees parallelized 48 0.01 0.00
IMU CR rollbacks 30,859,721 8,561.95 31.85
IMU Flushes 295,124 81.88 0.30
IMU Redo allocation size 1,952,760,784 541,788.67 2,015.53
IMU commits 505,150 140.15 0.52
IMU contention 34,504 9.57 0.04
IMU ktichg flush 8,327 2.31 0.01
IMU pool not allocated 0 0.00 0.00
IMU recursive-transaction flush 1,336 0.37 0.00
IMU undo allocation size 4,506,867,144 1,250,419.19 4,651.73
IMU- failed to get a private strand 0 0.00 0.00
PX local messages recv'd 51,447 14.27 0.05
PX local messages sent 51,447 14.27 0.05
Parallel operations downgraded 25 to 50 pct 40 0.01 0.00
Parallel operations not downgraded 8 0.00 0.00
SQL*Net roundtrips to/from client 37,186,382 10,317.27 38.38
active txn count during cleanout 82,893,609 22,998.63 85.56
application wait time 5,205 1.44 0.01
background checkpoints completed 3 0.00 0.00
background checkpoints started 2 0.00 0.00
background timeouts 13,907 3.86 0.01
branch node splits 1,019 0.28 0.00
buffer is not pinned count 533,023,588 147,886.08 550.16
buffer is pinned count 1,365,314,180 378,803.06 1,409.20
bytes received via SQL*Net from client 8,239,910,366 2,286,142.85 8,504.76
bytes sent via SQL*Net to client 7,707,218,446 2,138,348.78 7,954.94
calls to get snapshot scn: kcmgss 93,991,743 26,077.78 97.01
calls to kcmgas 17,890,050 4,963.55 18.47
calls to kcmgcs 10,720,183 2,974.29 11.06
change write time 37,775 10.48 0.04
cleanout - number of ktugct calls 23,267,304 6,455.46 24.02
cleanouts and rollbacks - consistent read gets 12,138,027 3,367.67 12.53
cleanouts only - consistent read gets 134,514 37.32 0.14
cluster key scan block gets 810,484 224.87 0.84
cluster key scans 229,115 63.57 0.24
commit batch performed 0 0.00 0.00
commit batch requested 0 0.00 0.00
commit batch/immediate performed 4,120 1.14 0.00
commit batch/immediate requested 4,120 1.14 0.00
commit cleanout failures: block lost 212,105 58.85 0.22
commit cleanout failures: buffer being written 1,153 0.32 0.00
commit cleanout failures: callback failure 102,773 28.51 0.11
commit cleanout failures: cannot pin 31,265 8.67 0.03
commit cleanouts 8,176,086 2,268.43 8.44
commit cleanouts successfully completed 7,828,790 2,172.08 8.08
commit immediate performed 4,120 1.14 0.00
commit immediate requested 4,120 1.14 0.00
commit txn count during cleanout 1,227,677 340.62 1.27
concurrency wait time 9,177 2.55 0.01
consistent changes 695,414,320 192,940.99 717.77
consistent gets 1,599,754,927 443,848.07 1,651.17
consistent gets - examination 1,130,766,249 313,728.31 1,167.11
consistent gets from cache 1,599,754,908 443,848.06 1,651.17
cursor authentications 1,913 0.53 0.00
data blocks consistent reads - undo records applied 692,259,307 192,065.64 714.51
db block changes 186,043,213 51,617.23 192.02
db block gets 209,355,183 58,085.08 216.08
db block gets direct 4,152 1.15 0.00
db block gets from cache 209,351,046 58,083.93 216.08
deferred (CURRENT) block cleanout applications 1,408,685 390.84 1.45
dirty buffers inspected 8,403 2.33 0.01
doubling up with imu segment 0 0.00 0.00
enqueue conversions 8,296 2.30 0.01
enqueue releases 3,670,346 1,018.33 3.79
enqueue requests 3,678,663 1,020.64 3.80
enqueue timeouts 8,204 2.28 0.01
enqueue waits 33,647 9.34 0.03
exchange deadlocks 22,409 6.22 0.02
execute count 83,653,638 23,209.50 86.34
failed probes on index block reclamation 9,342 2.59 0.01
frame signature mismatch 3 0.00 0.00
free buffer inspected 2,553,518 708.47 2.64
free buffer requested 18,273,567 5,069.96 18.86
heap block compress 29,278,361 8,123.21 30.22
hot buffers moved to head of LRU 1,101,008 305.47 1.14
immediate (CR) block cleanout applications 12,272,543 3,404.99 12.67
immediate (CURRENT) block cleanout applications 1,048,559 290.92 1.08
index crx upgrade (found) 25,535 7.08 0.03
index crx upgrade (positioned) 8,294,293 2,301.23 8.56
index fast full scans (rowid ranges) 792 0.22 0.00
index fetch by key 168,592,600 46,775.60 174.01
index scans kdiixs1 118,846,758 32,973.74 122.67
java call heap collected bytes 1,247,866,728 346,217.55 1,287.98
java call heap collected count 15,462,262 4,289.97 15.96
java call heap gc count 4,236 1.18 0.00
java call heap live object count 1,481,441 411.02 1.53
java call heap live object count max 1,528,927 424.20 1.58
java call heap live size 357,544,496 99,199.84 369.04
java call heap live size max 366,783,072 101,763.06 378.57
java call heap object count 3,590,725 996.24 3.71
java call heap object count max 3,603,486 999.78 3.72
java call heap total size 459,931,648 127,606.90 474.71
java call heap total size max 471,465,984 130,807.08 486.62
java call heap used size 493,776,408 136,997.05 509.65
java call heap used size max 500,124,760 138,758.38 516.20
leaf node 90-10 splits 19,451 5.40 0.02
leaf node splits 231,805 64.31 0.24
lob reads 16,624 4.61 0.02
lob writes 28,991 8.04 0.03
lob writes unaligned 28,991 8.04 0.03
logons cumulative 7,597 2.11 0.01
messages received 1,891,535 524.80 1.95
messages sent 1,891,535 524.80 1.95
no buffer to keep pinned count 16 0.00 0.00
no work - consistent read gets 426,313,037 118,279.50 440.02
opened cursors cumulative 4,521,664 1,254.52 4.67
parse count (failures) 2,523 0.70 0.00
parse count (hard) 7,497 2.08 0.01
parse count (total) 7,076,151 1,963.26 7.30
parse time cpu 31,738 8.81 0.03
parse time elapsed 35,929 9.97 0.04
physical read IO requests 279,567 77.57 0.29
physical read bytes 3,593,469,952 996,999.39 3,708.97
physical read total IO requests 308,834 85.69 0.32
physical read total bytes 4,072,062,976 1,129,783.85 4,202.95
physical read total multi block requests 13,123 3.64 0.01
physical reads 438,656 121.70 0.45
physical reads cache 437,335 121.34 0.45
physical reads cache prefetch 158,524 43.98 0.16
physical reads direct 1,321 0.37 0.00
physical reads direct temporary tablespace 589 0.16 0.00
physical reads prefetch warmup 88,822 24.64 0.09
physical write IO requests 1,179,439 327.23 1.22
physical write bytes 23,574,192,128 6,540,601.57 24,331.91
physical write total IO requests 2,211,783 613.65 2.28
physical write total bytes 55,117,518,848 15,292,219.91 56,889.10
physical write total multi block requests 1,202,613 333.66 1.24
physical writes 2,877,709 798.41 2.97
physical writes direct 5,074 1.41 0.01
physical writes direct (lob) 236 0.07 0.00
physical writes direct temporary tablespace 4,461 1.24 0.00
physical writes from cache 2,872,635 797.01 2.96
physical writes non checkpoint 2,224,486 617.18 2.30
pinned buffers inspected 2,982 0.83 0.00
prefetch warmup blocks aged out before use 218,302 60.57 0.23
prefetched blocks aged out before use 120 0.03 0.00
process last non-idle time 3,604 1.00 0.00
queries parallelized 48 0.01 0.00
recursive aborts on index block reclamation 2 0.00 0.00
recursive calls 136,086,288 37,756.81 140.46
recursive cpu usage 878,056 243.61 0.91
redo blocks written 61,441,109 17,046.68 63.42
redo buffer allocation retries 127 0.04 0.00
redo entries 95,863,255 26,597.02 98.94
redo log space requests 0 0.00 0.00
redo log space wait time 0 0.00 0.00
redo ordering marks 1,263,939 350.68 1.30
redo size 30,165,777,328 8,369,420.66 31,135.36
redo subscn max counts 2,222,212 616.55 2.29
redo synch time 68,916 19.12 0.07
redo synch writes 1,712,030 475.00 1.77
redo wastage 262,748,104 72,898.81 271.19
redo write time 50,270 13.95 0.05
redo writer latching time 155 0.04 0.00
redo writes 697,367 193.48 0.72
rollback changes - undo records applied 213,193 59.15 0.22
rollbacks only - consistent read gets 2,099,765 582.57 2.17
rows fetched via callback 89,408,568 24,806.19 92.28
session connect time 0 0.00 0.00
session cursor cache hits 4,536,633 1,258.68 4.68
session logical reads 1,809,109,983 501,933.11 1,867.26
session pga memory 8,811,288,272 2,444,670.24 9,094.50
session pga memory max 10,098,198,960 2,801,720.44 10,422.77
session uga memory ############### 74,737,607.52 278,033.89
session uga memory max 55,974,847,944 15,530,083.76 57,773.99
shared hash latch upgrades - no wait 28,904,021 8,019.35 29.83
shared hash latch upgrades - wait 40,352 11.20 0.04
sorts (memory) 8,690,699 2,411.21 8.97
sorts (rows) 110,743,680 30,725.56 114.30
sql area evicted 2,268 0.63 0.00
sql area purged 2,693 0.75 0.00
summed dirty queue length 231,652 64.27 0.24
switch current to new buffer 1,348,775 374.21 1.39
table fetch by rowid 808,697,655 224,371.17 834.69
table fetch continued row 30,889,009 8,570.08 31.88
table scan blocks gotten 71,652,408 19,879.78 73.96
table scan rows gotten 4,464,601,569 1,238,692.71 4,608.10
table scans (long tables) 2,051 0.57 0.00
table scans (rowid ranges) 2,049 0.57 0.00
table scans (short tables) 4,545,335 1,261.09 4.69
total number of times SMON posted 117,685 32.65 0.12
transaction rollbacks 4,120 1.14 0.00
transaction tables consistent read rollbacks 55 0.02 0.00
transaction tables consistent reads - undo records applied 3,897 1.08 0.00
undo change vector size 10,532,527,872 2,922,223.93 10,871.06
user I/O wait time 114,067 31.65 0.12
user calls 35,506,746 9,851.26 36.65
user commits 782,712 217.16 0.81
user rollbacks 186,147 51.65 0.19
workarea executions - onepass 4 0.00 0.00
workarea executions - optimal 4,994,767 1,385.79 5.16
write clones created in background 1,551 0.43 0.00
write clones created in foreground 5,069 1.41 0.01

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistic Begin Value End Value
session cursor cache count 306,321 838,244
opened cursors current 782,502 904,175
workarea memory allocated 1,279 4,522
logons current 3,803 3,828

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

Statistic Total per Hour
log switches (derived) 0 0.00

Back to Instance Activity Statistics
Back to Top

 

IO Stats

Back to Top

Tablespace IO Stats

Tablespace Reads Av Reads/s Av Rd(ms) Av Blks/Rd Writes Av Writes/s Buffer Waits Av Buf Wt(ms)
APPS_UNDOTS1 31 0 5.48 1.00 540,045 150 244,129 0.02
APPS_TS_TX_DATA 169,011 47 3.91 1.28 155,139 43 110,342 0.22
APPS_TS_TX_IDX 85,547 24 4.00 1.47 157,000 44 56,724 0.33
APPS_ASSM_DATA 8,608 2 1.96 6.64 163,923 45 39,223 0.50
APPS_ASSM_IDX 6,364 2 2.02 1.05 108,031 30 171,464 0.09
APPS_TS_TX_INTERFACE 1,165 0 2.21 2.13 27,078 8 14,889 0.02
TEMP 338 0 3.67 14.00 8,249 2 32 0.94
SYSTEM 4,794 1 3.71 3.94 2,226 1 19,327 0.03
APPS_TS_SUMMARY 59 0 8.81 1.00 6,493 2 2,546 0.03
APPS_TS_SEED 2,628 1 5.78 1.69 3,722 1 894 2.82
APPS_TS_QUEUES 377 0 5.52 2.41 4,269 1 444 0.27
APPS_TS_ARCHIVE 57 0 3.68 1.35 1,968 1 72 1.11
SYSAUX 295 0 2.44 1.07 1,310 0 0 0.00
APPS_TS_NOLOGGING 25 0 6.00 1.56 33 0 0 0.00
CTXSYS 24 0 5.00 1.00 6 0 0 0.00
APPS_TS_MEDIA 12 0 8.33 1.00 9 0 0 0.00
ODM 12 0 7.50 1.00 3 0 0 0.00
OLAP 12 0 10.00 1.00 3 0 0 0.00
OWAPUB 12 0 6.67 1.00 3 0 0 0.00
PORTAL 12 0 8.33 1.00 3 0 0 0.00
SYNCSERVER 12 0 7.50 1.00 3 0 0 0.00

Back to IO Stats
Back to Top

File IO Stats

Tablespace Filename Reads Av Reads/s Av Rd(ms) Av Blks/Rd Writes Av Writes/s Buffer Waits Av Buf Wt(ms)
APPS_ASSM_DATA /DB/visdata/apps_assm_data.dbf 8,608 2 1.96 6.64 163,923 45 39,223 0.50
APPS_ASSM_IDX /DB/visdata/apps_assm_idx.dbf 6,364 2 2.02 1.05 108,031 30 171,464 0.09
APPS_TS_ARCHIVE /DB/visdata/archive1.dbf 23 0 5.22 1.39 1,742 0 62 1.29
APPS_TS_ARCHIVE /DB/visdata/archive2.dbf 34 0 2.65 1.32 226 0 10 0.00
APPS_TS_MEDIA /DB/visdata/media1.dbf 4 0 7.50 1.00 3 0 0 0.00
APPS_TS_MEDIA /DB/visdata/media2.dbf 4 0 7.50 1.00 3 0 0 0.00
APPS_TS_MEDIA /DB/visdata/media3.dbf 4 0 10.00 1.00 3 0 0 0.00
APPS_TS_NOLOGGING /DB/visdata/nologging1.dbf 4 0 7.50 1.00 3 0 0 0.00
APPS_TS_NOLOGGING /DB/visdata/nologging2.dbf 15 0 4.00 1.00 18 0 0 0.00
APPS_TS_NOLOGGING /DB/visdata/nologging3.dbf 6 0 10.00 3.33 12 0 0 0.00
APPS_TS_QUEUES /DB/visdata/queues1.dbf 87 0 4.02 1.30 581 0 132 0.30
APPS_TS_QUEUES /DB/visdata/queues2.dbf 34 0 4.12 4.50 749 0 246 0.20
APPS_TS_QUEUES /DB/visdata/queues3.dbf 31 0 7.10 3.03 618 0 1 0.00
APPS_TS_QUEUES /DB/visdata/queues4.dbf 32 0 6.88 3.19 465 0 3 0.00
APPS_TS_QUEUES /DB/visdata/queues5.dbf 31 0 4.19 3.10 567 0 0 0.00
APPS_TS_QUEUES /DB/visdata/queues6.dbf 26 0 7.31 3.69 551 0 0 0.00
APPS_TS_QUEUES /DB/visdata/queues7.dbf 136 0 6.10 1.87 738 0 62 0.48
APPS_TS_SEED /DB/visdata/reference1.dbf 219 0 5.89 1.94 354 0 45 5.11
APPS_TS_SEED /DB/visdata/reference10.dbf 254 0 6.89 1.74 385 0 54 2.96
APPS_TS_SEED /DB/visdata/reference2.dbf 234 0 5.51 1.94 371 0 42 1.43
APPS_TS_SEED /DB/visdata/reference3.dbf 385 0 5.22 1.65 441 0 477 2.83
APPS_TS_SEED /DB/visdata/reference4.dbf 240 0 6.00 1.63 390 0 36 2.22
APPS_TS_SEED /DB/visdata/reference5.dbf 275 0 5.35 1.51 346 0 67 1.79
APPS_TS_SEED /DB/visdata/reference6.dbf 308 0 5.52 1.64 377 0 40 3.00
APPS_TS_SEED /DB/visdata/reference7.dbf 257 0 6.07 1.63 324 0 26 8.46
APPS_TS_SEED /DB/visdata/reference8.dbf 228 0 5.66 1.76 348 0 46 1.30
APPS_TS_SEED /DB/visdata/reference9.dbf 228 0 6.14 1.48 386 0 61 1.97
APPS_TS_SUMMARY /DB/visdata/summary1.dbf 5 0 6.00 1.00 755 0 376 0.05
APPS_TS_SUMMARY /DB/visdata/summary2.dbf 5 0 10.00 1.00 731 0 269 0.00
APPS_TS_SUMMARY /DB/visdata/summary3.dbf 14 0 11.43 1.00 768 0 243 0.00
APPS_TS_SUMMARY /DB/visdata/summary4.dbf 7 0 7.14 1.00 693 0 243 0.00
APPS_TS_SUMMARY /DB/visdata/summary5.dbf 7 0 7.14 1.00 870 0 315 0.03
APPS_TS_SUMMARY /DB/visdata/summary6.dbf 7 0 7.14 1.00 890 0 576 0.03
APPS_TS_SUMMARY /DB/visdata/summary7.dbf 7 0 8.57 1.00 894 0 247 0.12
APPS_TS_SUMMARY /DB/visdata/summary8.dbf 7 0 10.00 1.00 892 0 277 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data1.dbf 2,989 1 4.56 1.26 269 0 6 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data10.dbf 2,949 1 4.25 1.19 167 0 0 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data11.dbf 2,949 1 4.20 1.25 132 0 0 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data12.dbf 12,535 3 2.71 1.20 2,285 1 3,470 1.43
APPS_TS_TX_DATA /DB/visdata/tx_data13.dbf 17,495 5 4.35 1.48 3,796 1 2,251 0.74
APPS_TS_TX_DATA /DB/visdata/tx_data14.dbf 12,644 4 3.77 1.35 24,270 7 14,988 0.15
APPS_TS_TX_DATA /DB/visdata/tx_data15.dbf 9,045 3 3.59 1.40 21,650 6 13,168 0.22
APPS_TS_TX_DATA /DB/visdata/tx_data16.dbf 9,143 3 3.66 1.39 20,624 6 14,350 0.11
APPS_TS_TX_DATA /DB/visdata/tx_data17.dbf 8,891 2 3.57 1.39 19,773 5 13,756 0.24
APPS_TS_TX_DATA /DB/visdata/tx_data18.dbf 9,005 2 3.49 1.37 19,356 5 14,571 0.15
APPS_TS_TX_DATA /DB/visdata/tx_data19.dbf 8,863 2 3.60 1.39 19,340 5 15,177 0.15
APPS_TS_TX_DATA /DB/visdata/tx_data2.dbf 6,471 2 3.06 1.12 536 0 1,835 0.76
APPS_TS_TX_DATA /DB/visdata/tx_data20.dbf 8,878 2 3.56 1.40 19,726 5 15,425 0.10
APPS_TS_TX_DATA /DB/visdata/tx_data21.dbf 21,516 6 4.44 1.14 972 0 1,298 0.07
APPS_TS_TX_DATA /DB/visdata/tx_data3.dbf 3,199 1 4.90 1.40 378 0 7 2.86
APPS_TS_TX_DATA /DB/visdata/tx_data4.dbf 17,404 5 4.31 1.09 302 0 8 5.00
APPS_TS_TX_DATA /DB/visdata/tx_data5.dbf 2,977 1 4.66 1.23 326 0 6 15.00
APPS_TS_TX_DATA /DB/visdata/tx_data6.dbf 3,009 1 4.34 1.20 179 0 9 5.56
APPS_TS_TX_DATA /DB/visdata/tx_data7.dbf 2,947 1 4.40 1.20 395 0 15 6.00
APPS_TS_TX_DATA /DB/visdata/tx_data8.dbf 2,996 1 4.18 1.15 421 0 2 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data9.dbf 3,106 1 4.45 1.23 242 0 0 0.00
APPS_TS_TX_IDX /DB/visdata/tx_idx1.dbf 2,484 1 3.11 1.18 1,976 1 1,149 0.84
APPS_TS_TX_IDX /DB/visdata/tx_idx10.dbf 2,403 1 3.15 1.20 1,400 0 1,214 0.37
APPS_TS_TX_IDX /DB/visdata/tx_idx11.dbf 2,439 1 3.23 1.24 1,580 0 1,114 0.60
APPS_TS_TX_IDX /DB/visdata/tx_idx12.dbf 9,862 3 4.99 1.87 16,810 5 1,232 0.26
APPS_TS_TX_IDX /DB/visdata/tx_idx13.dbf 8,651 2 4.12 1.35 21,974 6 2,869 0.32
APPS_TS_TX_IDX /DB/visdata/tx_idx14.dbf 4,836 1 4.27 1.60 14,608 4 2,783 0.14
APPS_TS_TX_IDX /DB/visdata/tx_idx15.dbf 4,926 1 4.36 1.52 12,798 4 3,837 0.22
APPS_TS_TX_IDX /DB/visdata/tx_idx16.dbf 4,857 1 4.35 1.55 11,314 3 3,585 0.07
APPS_TS_TX_IDX /DB/visdata/tx_idx17.dbf 4,771 1 4.52 1.55 11,196 3 3,911 0.21
APPS_TS_TX_IDX /DB/visdata/tx_idx18.dbf 5,033 1 4.41 1.52 11,352 3 5,492 0.11
APPS_TS_TX_IDX /DB/visdata/tx_idx19.dbf 4,877 1 4.38 1.51 10,656 3 4,291 0.21
APPS_TS_TX_IDX /DB/visdata/tx_idx2.dbf 2,790 1 3.70 1.45 1,590 0 1,985 0.12
APPS_TS_TX_IDX /DB/visdata/tx_idx20.dbf 4,820 1 4.55 1.50 10,069 3 2,580 0.14
APPS_TS_TX_IDX /DB/visdata/tx_idx21.dbf 3,329 1 4.74 1.72 13,645 4 1,939 1.38
APPS_TS_TX_IDX /DB/visdata/tx_idx3.dbf 3,954 1 2.25 1.21 1,647 0 1,755 1.00
APPS_TS_TX_IDX /DB/visdata/tx_idx4.dbf 2,655 1 3.12 1.28 2,857 1 2,235 0.75
APPS_TS_TX_IDX /DB/visdata/tx_idx5.dbf 2,592 1 3.36 1.26 4,178 1 8,621 0.10
APPS_TS_TX_IDX /DB/visdata/tx_idx6.dbf 2,675 1 3.16 1.24 2,325 1 2,076 0.66
APPS_TS_TX_IDX /DB/visdata/tx_idx7.dbf 2,587 1 3.00 1.31 2,153 1 1,427 0.46
APPS_TS_TX_IDX /DB/visdata/tx_idx8.dbf 2,500 1 3.20 1.30 1,468 0 1,376 0.92
APPS_TS_TX_IDX /DB/visdata/tx_idx9.dbf 2,506 1 3.10 1.30 1,404 0 1,253 0.44
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte.dbf 144 0 2.08 2.06 4,145 1 3,818 0.01
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte2.dbf 245 0 2.45 2.31 5,159 1 3,253 0.02
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte3.dbf 260 0 2.00 1.95 4,585 1 2,580 0.04
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte4.dbf 140 0 2.43 2.51 4,297 1 1,730 0.02
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte5.dbf 238 0 1.72 1.82 4,407 1 2,133 0.02
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte6.dbf 138 0 2.90 2.37 4,485 1 1,375 0.04
APPS_UNDOTS1 /DB/visdata/undo01.dbf 3 0 6.67 1.00 57,945 16 25,749 0.02
APPS_UNDOTS1 /DB/visdata/undo02.dbf 3 0 6.67 1.00 52,037 14 23,713 0.02
APPS_UNDOTS1 /DB/visdata/undo03.dbf 3 0 3.33 1.00 46,781 13 21,829 0.01
APPS_UNDOTS1 /DB/visdata/undo04.dbf 3 0 6.67 1.00 50,926 14 23,570 0.02
APPS_UNDOTS1 /DB/visdata/undo05.dbf 4 0 2.50 1.00 51,999 14 28,917 0.02
APPS_UNDOTS1 /DB/visdata/undo06.dbf 3 0 3.33 1.00 55,795 15 20,955 0.02
APPS_UNDOTS1 /DB/visdata/undo07.dbf 3 0 10.00 1.00 54,912 15 29,809 0.02
APPS_UNDOTS1 /DB/visdata/undo08.dbf 3 0 3.33 1.00 56,336 16 20,771 0.01
APPS_UNDOTS1 /DB/visdata/undo09.dbf 3 0 3.33 1.00 54,904 15 22,968 0.01
APPS_UNDOTS1 /DB/visdata/undo10.dbf 3 0 10.00 1.00 58,410 16 25,848 0.02
CTXSYS /DB/visdata/ctx1.dbf 12 0 5.00 1.00 3 0 0 0.00
CTXSYS /DB/visdata/ctx2.dbf 12 0 5.00 1.00 3 0 0 0.00
ODM /DB/visdata/odm.dbf 12 0 7.50 1.00 3 0 0 0.00
OLAP /DB/visdata/olap.dbf 12 0 10.00 1.00 3 0 0 0.00
OWAPUB /DB/visdata/owa1.dbf 12 0 6.67 1.00 3 0 0 0.00
PORTAL /DB/visdata/portal.dbf 12 0 8.33 1.00 3 0 0 0.00
SYNCSERVER /DB/visdata/mobile01.dbf 12 0 7.50 1.00 3 0 0 0.00
SYSAUX /DB/visdata/sysaux01.dbf 5 0 24.00 1.00 552 0 0 0.00
SYSAUX /DB/visdata/sysaux02.dbf 290 0 2.07 1.07 758 0 0 0.00
SYSTEM /DB/visdata/sys1.dbf 483 0 4.10 4.73 93 0 0 0.00
SYSTEM /DB/visdata/sys2.dbf 546 0 3.17 4.31 162 0 0 0.00
SYSTEM /DB/visdata/sys3.dbf 640 0 3.27 3.80 209 0 0 0.00
SYSTEM /DB/visdata/sys4.dbf 542 0 3.25 4.35 225 0 1 0.00
SYSTEM /DB/visdata/sys5.dbf 802 0 3.85 3.28 618 0 242 0.04
SYSTEM /DB/visdata/sys6.dbf 514 0 4.03 4.59 48 0 0 0.00
SYSTEM /DB/visdata/sys7.dbf 423 0 4.26 4.61 124 0 0 0.00
SYSTEM /DB/visdata/sys8.dbf 354 0 4.46 3.52 401 0 19,069 0.03
SYSTEM /DB/visdata/sys9.dbf 490 0 3.45 2.65 346 0 15 0.67
TEMP /DB/visdata/temp1.dbf 85 0 3.29 3.12 2,124 1 24 0.83
TEMP /DB/visdata/temp2.dbf 83 0 3.73 12.45 2,059 1 8 1.25
TEMP /DB/visdata/temp3.dbf 45 0 2.44 1.00 1,644 0 0  
TEMP /DB/visdata/temp4.dbf 125 0 4.32 27.11 2,422 1 0  

Back to IO Stats
Back to Top

 

Buffer Pool Statistics

P Number of Buffers Pool Hit% Buffer Gets Physical Reads Physical Writes Free Buff Wait Writ Comp Wait Buffer Busy Waits
D 2,230,333 100 1,808,918,870 437,328 2,872,635 0 0 660,086


Back to Top

 

Advisory Statistics

Back to Top

Instance Recovery Stats

  Targt MTTR (s) Estd MTTR (s) Recovery Estd IOs Actual Redo Blks Target Redo Blks Log File Size Redo Blks Log Ckpt Timeout Redo Blks Log Ckpt Interval Redo Blks
B 180 73 35063 814306 3105278 188743680 3105278  
E 180 76 39311 831726 8783288 188743680 8783288  

Back to Advisory Statistics
Back to Top

 

Buffer Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit % W/A MB Processed Extra W/A MB Read/Written
100.00 456,125 15

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

  PGA Aggr Target(M) Auto PGA Target(M) PGA Mem Alloc(M) W/A PGA Used(M) %PGA W/A Mem %Auto W/A Mem %Man W/A Mem Global Mem Bound(K)
B 20,480 1,280 32,665.35 1.21 0.00 100.00 0.00 1,048,576
E 20,480 1,280 40,239.09 3.07 0.01 100.00 0.00 1,048,576

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High Optimal Total Execs Optimal Execs 1-Pass Execs M-Pass Execs
2K 4K 4,533,681 4,533,681 0 0
64K 128K 11,472 11,472 0 0
128K 256K 1,067 1,067 0 0
256K 512K 1,029 1,029 0 0
512K 1024K 138,672 138,672 0 0
1M 2M 308,584 308,584 0 0
2M 4M 72 70 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 Factr W/A MB Processed Estd Extra W/A MB Read/ Written to Disk Estd PGA Cache Hit % Estd PGA Overalloc Count
2,560 0.13 616,988.60 7,285.68 99.00 924
5,120 0.25 616,988.60 7,184.51 99.00 884
10,240 0.50 616,988.60 7,040.54 99.00 825
15,360 0.75 616,988.60 6,913.31 99.00 774
20,480 1.00 616,988.60 4.94 100.00 721
24,576 1.20 616,988.60 4.94 100.00 558
28,672 1.40 616,988.60 0.00 100.00 163
32,768 1.60 616,988.60 0.00 100.00 0
36,864 1.80 616,988.60 0.00 100.00 0
40,960 2.00 616,988.60 0.00 100.00 0
61,440 3.00 616,988.60 0.00 100.00 0
81,920 4.00 616,988.60 0.00 100.00 0
122,880 6.00 616,988.60 0.00 100.00 0
163,840 8.00 616,988.60 0.00 100.00 0

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

Shared Pool Size(M) SP Size Factr Est LC Size (M) Est LC Mem Obj Est LC Time Saved (s) Est LC Time Saved Factr Est LC Load Time (s) Est LC Load Time Factr Est LC Mem Obj Hits
1,152 0.49 279 12,823 1,948,798 1.00 3,155 4.22 151,381,532
1,392 0.59 490 15,907 1,950,818 1.00 1,135 1.52 151,532,144
1,632 0.69 730 19,721 1,951,173 1.00 780 1.04 151,560,892
1,872 0.80 968 26,032 1,951,205 1.00 748 1.00 151,563,975
2,112 0.90 1,116 31,360 1,951,205 1.00 748 1.00 151,564,029
2,352 1.00 1,125 32,293 1,951,205 1.00 748 1.00 151,564,030
2,592 1.10 1,125 32,293 1,951,205 1.00 748 1.00 151,564,030
2,832 1.20 1,125 32,293 1,951,205 1.00 748 1.00 151,564,030
3,072 1.31 1,125 32,293 1,951,205 1.00 748 1.00 151,564,030
3,312 1.41 1,125 32,293 1,951,205 1.00 748 1.00 151,564,030
3,552 1.51 1,125 32,293 1,951,205 1.00 748 1.00 151,564,030
3,792 1.61 1,125 32,293 1,951,205 1.00 748 1.00 151,564,030
4,032 1.71 1,125 32,293 1,951,205 1.00 748 1.00 151,564,030
4,272 1.82 1,125 32,293 1,951,205 1.00 748 1.00 151,564,030
4,512 1.92 1,125 32,293 1,951,205 1.00 748 1.00 151,564,030
4,752 2.02 1,125 32,293 1,951,205 1.00 748 1.00 151,564,030

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M) SGA Size Factor Est DB Time (s) Est Physical Reads
5,120 0.25 21,254  
10,240 0.50 21,254  
15,360 0.75 21,254  
20,480 1.00 21,253  
25,600 1.25 21,254  
30,720 1.50 21,254  
35,840 1.75 21,254  
40,960 2.00 21,254  

Back to Advisory Statistics
Back to Top

 

Streams Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Java Pool Advisory

Java Pool Size(M) JP Size Factr Est LC Size (M) Est LC Mem Obj Est LC Time Saved (s) Est LC Time Saved Factr Est LC Load Time (s) Est LC Load Time Factr Est LC Mem Obj Hits
16 0.25 13 296 164 1.00 748 1.00 13,730
32 0.50 13 296 164 1.00 748 1.00 13,730
48 0.75 13 296 164 1.00 748 1.00 13,730
64 1.00 13 296 164 1.00 748 1.00 13,730
80 1.25 13 296 164 1.00 748 1.00 13,730
96 1.50 13 296 164 1.00 748 1.00 13,730
112 1.75 13 296 164 1.00 748 1.00 13,730
128 2.00 13 296 164 1.00 748 1.00 13,730

Back to Advisory Statistics
Back to Top

 

Wait Statistics

Back to Top

Buffer Wait Statistics

Class Waits Total Wait Time (s) Avg Time (ms)
data block 409,126 82 0
undo block 202,032 3 0
undo header 42,097 1 0
1st level bmb 3,847 0 0
segment header 2,134 0 0
2nd level bmb 790 0 0
file header block 47 0 1
extent map 13 0 0

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason) Requests Succ Gets Failed Gets Waits Wt Time (s) Av Wt Time(ms)
UL-User-defined 66,388 65,366 1,022 2,458 22 8.84
TX-Transaction (row lock contention) 7,367 513 6,854 498 10 21.02
TX-Transaction (index contention) 24,679 24,679 0 22,943 10 0.42
TM-DML 1,664,668 1,664,642 0 6 5 905.00
RO-Multiple Object Reuse (fast object reuse) 288 288 0 32 5 156.88
HW-Segment High Water Mark 206,070 206,062 8 2,055 1 0.70
TX-Transaction 1,107,982 1,107,985 0 1,834 1 0.47
DV-Diana Versioning 22,913 22,913 0 171 1 3.86
SQ-Sequence Cache 37,074 37,074 0 3,006 1 0.19
FB-Format Block 35,072 35,072 0 549 0 0.15
CU-Cursor 7,308 7,308 0 1 0 70.00
PS-PX Process Reservation 1,864 1,544 320 37 0 0.54
TX-Transaction (allocate ITL entry) 114 114 0 49 0 0.20
US-Undo Segment 8,816 8,816 0 7 0 1.43

Back to Wait Statistics
Back to Top

 

Undo Statistics

Back to Top

Undo Segment Summary

Undo TS# Num Undo Blocks (K) Number of Transactions Max Qry Len (s) Max Tx Concurcy Min/Max TR (mins) STO/ OOS uS/uR/uU/ eS/eR/eU
1 1,519.65 1,108,007 2,662 274   0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

End Time Num Undo Blocks Number of Transactions Max Qry Len (s) Max Tx Concy Tun Ret (mins) STO/ OOS uS/uR/uU/ eS/eR/eU
16-Apr 12:53 212,204 154,126 639 270 209 0/0 0/0/0/0/0/0
16-Apr 12:43 41,238 92,091 490 262 217 0/0 0/0/0/0/0/0
16-Apr 12:33 210,680 126,495 2,662 263 199 0/0 0/0/0/0/0/0
16-Apr 12:23 396,785 183,778 2,528 264 206 0/0 0/0/0/0/0/0
16-Apr 12:13 312,754 216,143 1,860 273 270 0/0 0/0/0/0/0/0
16-Apr 12:03 345,985 335,374 2,184 274 388 0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

 

Latch Statistics

Back to Top

Latch Activity

Latch Name Get Requests Pct Get Miss Avg Slps /Miss Wait Time (s) NoWait Requests Pct NoWait Miss
ASM db client latch 2,467 0.00   0 0  
AWR Alerted Metric Element list 248,256 0.00   0 0  
Consistent RBA 698,116 0.06 0.00 0 0  
FOB s.o list latch 46,451 0.00 0.00 0 0  
In memory undo latch 675,579,403 1.73 0.00 2 991,434 0.00
JOX SGA heap latch 1,867,817 0.00   0 0  
JS queue state obj latch 21,600 0.00   0 0  
JS slv state obj latch 183 0.00   0 0  
KMG MMAN ready and startup request latch 2,571 0.00   0 0  
KMG resize request state object freelist 18 0.00   0 0  
KTF sga latch 12 0.00   0 1,213 0.00
KWQMN job cache list latch 12,074 0.12 0.87 0 0  
MQL Tracking Latch 0     0 71 0.00
Memory Management Latch 1,591 0.19 1.00 0 2,561 0.00
OS process 11,808 0.00   0 0  
OS process allocation 9,102 0.01 0.00 0 0  
OS process: request allocation 7,621 0.03 0.00 0 0  
PL/SQL warning settings 3,558,857 0.00   0 0  
SGA IO buffer pool latch 29,020 0.45 0.02 0 29,861 0.37
SQL memory manager latch 1 0.00   0 1,199 0.00
SQL memory manager workarea list latch 5,422,022 0.00 0.01 0 0  
Shared B-Tree 128 0.00   0 0  
active checkpoint queue latch 1,195,866 0.46 0.00 0 2 0.00
active service list 38,424 0.09 0.00 0 1,258 0.00
begin backup scn array 153 0.00   0 0  
buffer pool 18 0.00   0 0  
cache buffer handles 19,196,770 1.50 0.00 0 0  
cache buffers chains 4,304,689,687 1.05 0.02 13 16,145,546 2.44
cache buffers lru chain 9,270,896 0.31 0.03 0 31,981,982 0.41
cache table scan latch 1,941 0.00   0 1,941 0.00
channel handle pool latch 292,320 0.07 0.02 0 0  
channel operations parent latch 1,296,736 0.49 0.00 0 0  
checkpoint queue latch 17,208,423 0.01 0.01 0 2,883,214 0.02
client/application info 1,306,917 0.00 0.00 0 0  
commit callback allocation 62,847 0.00   0 0  
compile environment latch 2,232,272 0.00   0 0  
dictionary lookup 78 0.00   0 0  
dml lock allocation 3,316,731 0.16 0.01 0 0  
dummy allocation 15,184 0.27 0.00 0 0  
enqueue hash chains 7,398,102 0.06 0.00 0 213 0.00
enqueues 3,957,921 0.10 0.01 0 0  
error message lists 816 1.47 0.00 0 0  
event group latch 3,825 0.00   0 0  
file cache latch 19,970 0.00   0 0  
global KZLD latch for mem in SGA 7,089 0.00   0 0  
global ctx hash table latch 17,147 0.00   0 0  
hash table column usage latch 2,305 0.04 0.00 0 10,944,257 0.00
hash table modification latch 139 0.00   0 0  
internal temp table object number allocation latc 6 0.00   0 0  
job workq parent latch 0     0 122 0.00
job_queue_processes parameter latch 120 0.00   0 0  
kks stats 24,577 0.00   0 0  
ksuosstats global area 242 0.00   0 0  
ktm global data 117,713 0.00   0 0  
kwqbsn:qsga 128 0.00   0 0  
lgwr LWN SCN 700,049 0.09 0.00 0 0  
library cache 269,176,457 0.31 0.01 3 18,323 0.65
library cache load lock 9,043 0.23 0.05 0 25 0.00
library cache lock 43,052,040 0.04 0.01 0 0  
library cache lock allocation 1,133,287 0.01 0.03 0 0  
library cache pin 168,026,758 0.10 0.01 1 22 0.00
library cache pin allocation 397,886 0.00 0.00 0 0  
list of block allocation 416,435 0.01 0.00 0 0  
loader state object freelist 226,218 0.00 0.00 0 0  
longop free list parent 33 0.00   0 33 0.00
message pool operations parent latch 296,298 0.01 0.06 0 0  
messages 5,469,380 0.55 0.01 0 0  
mostly latch-free SCN 733,800 3.45 0.00 0 0  
multiblock read objects 28,809 0.00   0 0  
ncodef allocation latch 165 0.00   0 0  
object queue header heap 3,407,470 0.02 0.15 0 286,931 0.05
object queue header operation 30,068,455 0.11 0.37 1 17,591 0.16
object stats modification 290,243 0.02 0.02 0 0  
parallel query alloc buffer 8,160 1.19 0.01 0 0  
parallel query stats 528 12.88 0.00 0 0  
parameter table allocation management 17,456 1.40 0.56 0 0  
post/wait queue 1,010,266 0.02 0.00 0 407,044 0.01
process allocation 7,669 0.10 0.75 0 3,823 0.05
process group creation 7,621 0.01 0.00 0 0  
process queue 5,030 0.85 0.00 0 0  
process queue reference 755,879 0.05 0.00 0 82,396 0.34
qmn task queue latch 512 0.00   0 0  
query server freelists 4,256 4.70 0.00 0 0  
query server process 8 0.00   0 8 0.00
redo allocation 4,457,447 1.63 0.01 0 95,757,066 1.49
redo copy 0     0 95,866,709 0.04
redo writing 3,636,392 0.23 0.00 0 0  
resmgr group change latch 604,429 0.00   0 0  
resmgr:actses active list 22,242 0.23 0.94 0 0  
resmgr:actses change group 21,653 0.00   0 0  
resmgr:free threads list 15,182 0.24 0.00 0 0  
resmgr:schema config 1 0.00   0 0  
row cache objects 91,411,570 0.15 0.00 0 7,157 0.01
rules engine aggregate statistics 30,637 0.01 0.00 0 0  
rules engine rule set statistics 99,648 0.00   0 0  
rules engine rule statistics 38,374 0.00   0 0  
sequence cache 15,623,661 0.43 0.00 0 0  
session allocation 15,687,554 0.40 0.01 0 0  
session idle bit 73,228,044 0.01 0.02 0 0  
session state list latch 43,484 0.09 0.50 0 0  
session switching 10,704 0.01 0.00 0 0  
session timer 1,258 0.00   0 0  
shared pool 6,392,041 0.15 0.05 0 0  
shared pool sim alloc 339 0.00   0 0  
shared pool simulator 2,188,374 0.00 0.10 0 0  
sim partition latch 1 0.00   0 23,229 0.08
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 1,009,811 0.09 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 227 0.00   0 0  
temporary table state object allocation 9,124 0.00   0 0  
threshold alerts latch 606 0.00   0 0  
trace latch 37 0.00   0 0  
transaction allocation 85,001 0.00   0 0  
transaction branch allocation 165 0.00   0 0  
undo global data 833,289,290 1.46 0.00 3 17,894 0.14
user lock 28,426 0.02 0.20 0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch Name Get Requests Misses Sleeps Spin Gets Sleep1 Sleep2 Sleep3
cache buffers chains 4,304,689,687 45,179,342 1,046,104 44,244,288 0 0 0
undo global data 833,289,290 12,203,650 32,174 12,175,144 0 0 0
In memory undo latch 675,579,403 11,693,188 16,193 11,679,247 0 0 0
library cache 269,176,457 843,475 6,352 837,782 0 0 0
cache buffer handles 19,196,770 288,627 191 288,456 0 0 0
library cache pin 168,026,758 168,492 1,611 167,037 0 0 0
row cache objects 91,411,570 140,928 488 140,464 0 0 0
redo allocation 4,457,447 72,780 499 72,318 0 0 0
sequence cache 15,623,661 67,310 71 67,246 0 0 0
session allocation 15,687,554 62,247 522 61,775 0 0 0
object queue header operation 30,068,455 32,523 12,134 21,333 0 0 0
messages 5,469,380 30,326 172 30,159 0 0 0
cache buffers lru chain 9,270,896 28,773 982 27,838 0 0 0
mostly latch-free SCN 733,800 25,317 35 25,286 0 0 0
library cache lock 43,052,040 17,110 96 17,020 0 0 0
shared pool 6,392,041 9,362 494 8,924 0 0 0
redo writing 3,636,392 8,508 30 8,478 0 0 0
channel operations parent latch 1,296,736 6,297 6 6,292 0 0 0
session idle bit 73,228,044 6,102 124 5,979 0 0 0
active checkpoint queue latch 1,195,866 5,509 10 5,499 0 0 0
dml lock allocation 3,316,731 5,324 42 5,285 0 0 0
enqueue hash chains 7,398,102 4,583 14 4,572 0 0 0
enqueues 3,957,921 3,942 48 3,896 0 0 0
checkpoint queue latch 17,208,423 2,131 16 2,116 0 0 0
sort extent pool 1,009,811 891 9 882 0 0 0
object queue header heap 3,407,470 700 103 600 0 0 0
lgwr LWN SCN 700,049 654 1 653 0 0 0
Consistent RBA 698,116 433 1 432 0 0 0
parameter table allocation management 17,456 244 137 128 0 0 0
post/wait queue 1,010,266 238 1 237 0 0 0
SQL memory manager workarea list latch 5,422,022 216 3 214 0 0 0
channel handle pool latch 292,320 194 4 190 0 0 0
SGA IO buffer pool latch 29,020 130 3 127 0 0 0
parallel query alloc buffer 8,160 97 1 96 0 0 0
library cache lock allocation 1,133,287 74 2 72 0 0 0
object stats modification 290,243 54 1 53 0 0 0
resmgr:actses active list 22,242 52 49 3 0 0 0
session state list latch 43,484 38 19 20 0 0 0
shared pool simulator 2,188,374 29 3 27 0 0 0
library cache load lock 9,043 21 1 20 0 0 0
message pool operations parent latch 296,298 17 1 16 0 0 0
KWQMN job cache list latch 12,074 15 13 2 0 0 0
process allocation 7,669 8 6 2 0 0 0
user lock 28,426 5 1 4 0 0 0
Memory Management Latch 1,591 3 3 0 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch Name Where NoWait Misses Sleeps Waiter Sleeps
In memory undo latch kturbk 0 7,088 9,224
In memory undo latch ktiFlush: child 0 5,441 2,778
In memory undo latch kticmt: child 0 3,026 712
In memory undo latch ktichg: child 0 481 3,420
In memory undo latch ktiTxnPoolFree 0 143 0
In memory undo latch ktiBRacquire 0 10 0
In memory undo latch ktbgfc 0 4 59
KWQMN job cache list latch kwqmnuji: update job item 0 14 3
Memory Management Latch kmgs_perform_parameter_updates1 0 3 3
SGA IO buffer pool latch ksfd_free_sgabuffer 0 2 4
SGA IO buffer pool latch ksfd_alloc_sgabuffer 0 1 0
SQL memory manager workarea list latch qesmmIUnRegisterWorkArea 0 2 2
SQL memory manager workarea list latch qesmmIRegisterWorkArea 0 1 1
active checkpoint queue latch kcbbacq: scan active checkpoints 0 10 10
cache buffer handles kcbzgs 0 120 115
cache buffer handles kcbzfs 0 71 77
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 1,220,241 1,417,651
cache buffers chains kcbgtcr: fast path 0 571,040 25,180
cache buffers chains kcbchg: kslbegin: call CR func 0 368,778 855,389
cache buffers chains kcbgtcr: kslbegin excl 0 158,514 79,206
cache buffers chains kcbzgb: scan from tail. nowait 0 96,431 0
cache buffers chains kcbrls: kslbegin 0 65,892 115,970
cache buffers chains kcbgcur: kslbegin 0 24,566 12,104
cache buffers chains kcbget: pin buffer 0 16,177 6,575
cache buffers chains kcbzwb 0 5,259 5,579
cache buffers chains kcbcge 0 2,440 5,348
cache buffers chains kcbget: exchange rls 0 552 548
cache buffers chains kcbget: exchange 0 313 1,179
cache buffers chains kcbbxsv 0 305 296
cache buffers chains kcbnlc 0 265 1,358
cache buffers chains kcb_is_private 0 165 2,745
cache buffers chains kcbgtcr: kslbegin shared 0 92 71
cache buffers chains kcbesc: escalate 0 51 22
cache buffers chains kcbnew: new latch again 0 26 4
cache buffers chains kcb_pre_apply: kcbhq61 0 25 1,531
cache buffers chains kcb_post_apply: kcbhq63 0 24 208
cache buffers chains kcbso1: set no access 0 12 25
cache buffers chains kcbbic2 0 8 3
cache buffers chains kcb_post_apply: kcbhq62 0 5 278
cache buffers chains kcbzib: finish free bufs 0 5 5
cache buffers chains kcbw_next_free 0 3 0
cache buffers chains kcbgkcbcr 0 1 2
cache buffers chains kcbzib: multi-block read: nowait 0 1 0
cache buffers lru chain kcbzgws 0 557 0
cache buffers lru chain kcbbxsv: move to being written 0 148 330
cache buffers lru chain kcbo_link_q 0 119 12
cache buffers lru chain kcbgtcr:CR Scan:KCBRSKIP 0 68 0
cache buffers lru chain kcbzgb: posted for free bufs 0 39 235
cache buffers lru chain kcbzswcu 0 17 36
cache buffers lru chain kcbbic2 0 15 198
cache buffers lru chain kcbo_ivd_proc 0 15 149
cache buffers lru chain kcbo_write_process:free_unlink 0 2 0
cache buffers lru chain kcbzfw 0 2 0
channel handle pool latch ksrchconnect() 0 4 3
channel handle pool latch ksrchdelete() 0 1 3
channel operations parent latch ksrapublish() 0 4 0
channel operations parent latch ksrchdelete() 0 3 1
channel operations parent latch ksrmfree() 0 3 0
channel operations parent latch ksrwait() 0 2 9
channel operations parent latch ksrchconnect() 0 1 3
channel operations parent latch ksrsconsume() 0 1 1
checkpoint queue latch kcbbwthc: thread checkpoint buffers 0 10 2
checkpoint queue latch kcbkubc 0 4 12
checkpoint queue latch kcbklbc: Link buffer into ckpt queue 0 2 1
cost function kzulrl 0 1 1
dml lock allocation ktaiam 0 28 26
dml lock allocation ktaidm 0 14 16
enqueue hash chains ksqgtl3 0 7 12
enqueue hash chains ksqrcl 0 7 3
enqueues ksqgel: create enqueue 0 25 15
enqueues ksqies 0 15 30
enqueues ksqdel 0 8 3
lgwr LWN SCN kcs023 0 10 0
library cache kglpndl: child: after processing 0 2,472 73
library cache kglpnp: child 0 2,382 3,364
library cache kglobpn: child: 0 463 952
library cache kglpndl: child: before processing 0 333 1,509
library cache kglLockCursor 0 176 192
library cache kglScanDependency 0 123 0
library cache kglhdgn: child: 0 76 90
library cache kglpin 0 66 30
library cache kgldte: child 0 0 49 100
library cache kgldti: 2child 0 21 2
library cache kglic 0 16 0
library cache kglrtl 0 9 0
library cache kglivl: child 0 4 0
library cache kglhdiv: child 0 2 0
library cache kgldtld: 2child 0 1 0
library cache kglget: unpin heap 0 0 1 2
library cache kglhdgc: child: 0 1 0
library cache kglini: child 0 1 0
library cache kglobld 0 1 1
library cache kglupd: child 0 1 0
library cache load lock kglllal: llatch: in loop 0 1 1
library cache lock kgllkdl: child: cleanup 0 57 68
library cache lock kgllkdl: child: no lock handle 0 47 20
library cache lock kgllkal: child: multiinstance 0 39 28
library cache lock allocation kgllkget 0 1 2
library cache lock allocation kgllkrel 0 1 1
library cache pin kglpndl 0 774 469
library cache pin kglpnp: child 0 716 883
library cache pin kglpnal: child: alloc space 0 121 259
message pool operations parent latch ksrmalloc() 0 2 1
messages ksarcv: after wait 0 82 99
messages ksarcv 0 66 16
messages ksaamb: after wakeup 0 24 60
mostly latch-free SCN kcslcu3 0 25 36
mostly latch-free SCN kcs01 0 1 1
mostly latch-free SCN kcs024 0 1 0
object queue header heap kcbo_link_q:reget 0 101 2
object queue header heap kcbw_link_q:alloc 0 2 109
object queue header operation kcbo_ivbo 0 12,415 2,537
object queue header operation kcbw_link_q 0 2,286 1,337
object queue header operation kcbw_unlink_q 0 546 3,936
object queue header operation kcbo_switch_q_bg 0 288 1,241
object queue header operation kcbo_switch_mq_bg 0 261 1,822
object queue header operation kcbo_switch_cq 0 89 1,830
object queue header operation kcbo_link_q:reget 0 24 77
object queue header operation kcbo_write_q 0 21 9
object queue header operation kcbo_service_ockpt 0 16 3
object queue header operation kcbo_swap_buf_bg 0 14 3,043
object queue header operation kcbo_swap_buf 0 7 362
object stats modification ksoslinelm 0 1 1
parallel query alloc buffer kxfpbfre 0 1 1
parameter table allocation management ksp_param_table_free 0 137 138
post/wait queue ksliwat:remove 0 1 1
process allocation ksucrp 0 4 0
process allocation ksudlp 0 2 3
redo allocation kcrfw_redo_gen: redo allocation 1 0 394 0
redo allocation kcrfw_redo_gen: redo allocation 3 0 74 310
redo allocation kcrfw_redo_gen: redo allocation 2 0 18 0
redo allocation kcrfw_redo_write: before write 0 8 73
redo allocation kcrfw_redo_write: more space 0 5 128
redo writing kcrfwcr 0 22 28
redo writing kcrfw_post: rba scn pair 0 5 0
redo writing kcrfw_post: after write 0 3 2
resmgr:actses active list kgskchclass 0 48 23
resmgr:actses active list kgskactladd 0 1 37
row cache objects kqreqd: reget 0 345 2
row cache objects kqrpre: find obj 0 109 387
row cache objects kqreqd 0 28 98
row cache objects kqrso 0 5 1
sequence cache kdnssd 0 52 2
sequence cache kdnnxt: cached seq 0 16 0
sequence cache kdnss 0 3 71
session allocation ksuxds: KSUSFCLC not set 0 200 25
session allocation ksuprc 0 100 78
session allocation ksudlc 0 79 126
session allocation ksucri 0 51 164
session allocation ksuxds: not user session 0 41 54
session allocation kxfpqidqr 0 15 36
session allocation kspallmod 0 14 0
session allocation ksudlp 0 9 1
session allocation ksursi 0 7 33
session allocation kxfprdp 0 5 5
session allocation ksucrp 0 1 1
session idle bit ksupuc: set busy 0 76 76
session idle bit ksupuc: clear busy 0 61 62
session idle bit ksuxds 0 8 7
session state list latch kpseqd 0 18 0
session state list latch kpscad 0 1 0
shared pool kghupr1 0 238 331
shared pool kghalo 0 185 103
shared pool kghfrunp: clatch: nowait 0 98 0
shared pool kghfre 0 26 44
shared pool kghfrunp: alloc: session dur 0 20 6
shared pool kghfrunp: alloc: wait 0 17 0
shared pool kghfrunp: clatch: wait 0 10 17
shared pool kghalp 0 6 5
shared pool kghfrh 0 2 0
shared pool simulator kglsim_unpin_simhp 0 3 3
sort extent pool ktstdt: dealloc sort extent 0 7 0
sort extent pool ktstaddextent1 0 1 0
sort extent pool ktstdt: return extent 0 1 1
undo global data kturimugur: child 0 31,199 29,171
undo global data ktudba: KSLBEGIN 0 936 2,954
undo global data ktucof: at start 0 12 0
undo global data ktufrbs: child 0 8 14
undo global data ktudnx:child 0 7 15
undo global data ktusmasp: ktugd_tuux 0 7 4
undo global data ktubnd:child 0 4 18

Back to Latch Statistics
Back to Top

 

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

 

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

 

Segment Statistics

Back to Top

Segments by Logical Reads

Owner Tablespace Name Object Name Subobject Name Obj. Type Logical Reads %Total
AR APPS_TS_TX_INTERFACE RA_INTERFACE_LINES_ALL   TABLE 61,944,112 3.42
INV APPS_TS_TX_IDX MTL_ITEM_CATEGORIES_U1   INDEX 49,726,544 2.75
ONT APPS_TS_TX_DATA OE_ORDER_LINES_ALL   TABLE 22,003,696 1.22
WSH APPS_TS_TX_DATA WSH_DELIVERY_DETAILS   TABLE 21,281,248 1.18
GL APPS_TS_TX_DATA GL_CODE_COMBINATIONS   TABLE 19,584,048 1.08

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Owner Tablespace Name Object Name Subobject Name Obj. Type Physical Reads %Total
GL APPS_ASSM_DATA GL_JE_LINES   TABLE 35,076 8.00
AR APPS_ASSM_DATA RA_CUSTOMER_TRX_LINES_ALL   TABLE 13,019 2.97
WSH APPS_TS_TX_DATA WSH_DELIVERY_DETAILS   TABLE 9,554 2.18
HR APPS_ASSM_DATA PAY_RUN_RESULTS   TABLE 4,047 0.92
HR APPS_TS_TX_DATA PER_ALL_ASSIGNMENTS_F   TABLE 2,227 0.51

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

Owner Tablespace Name Object Name Subobject Name Obj. Type Row Lock Waits % of Capture
WSH APPS_TS_TX_DATA WSH_TRIP_STOPS   TABLE 13,320 31.24
APPLSYS APPS_TS_TX_IDX WF_ITEM_ACTIVITY_STATUSES_N1   INDEX 10,835 25.41
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_U1   INDEX 8,597 20.16
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N6   INDEX 2,077 4.87
HR APPS_ASSM_IDX PAY_RUN_RESULT_VALUES_PK   INDEX 1,726 4.05

Back to Segment Statistics
Back to Top

Segments by ITL Waits

Owner Tablespace Name Object Name Subobject Name Obj. Type ITL Waits % of Capture
APPLSYS APPS_TS_TX_IDX WF_ITEM_ATTRIBUTE_VALUES_PK   INDEX 14 25.45
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N6   INDEX 13 23.64
GL APPS_ASSM_IDX GL_INTERFACE_N5   INDEX 6 10.91
GL APPS_ASSM_IDX GL_IMPORT_REFERENCES_N1   INDEX 5 9.09
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N5   INDEX 5 9.09

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

Owner Tablespace Name Object Name Subobject Name Obj. Type Buffer Busy Waits % of Capture
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_U1   INDEX 123,201 36.94
APPLSYS APPS_TS_TX_DATA WF_ITEM_ATTRIBUTE_VALUES   TABLE 59,372 17.80
SYS SYSTEM DBMS_LOCK_ALLOCATED   TABLE 19,050 5.71
APPLSYS APPS_TS_TX_DATA WF_ITEM_ACTIVITY_STATUSES WF_ITEM49 TABLE PARTITION 15,360 4.61
AR APPS_ASSM_DATA RA_CUST_TRX_LINE_GL_DIST_ALL   TABLE 15,223 4.56

Back to Segment Statistics
Back to Top

 

Dictionary Cache Stats

Cache Get Requests Pct Miss Scan Reqs Pct Miss Mod Reqs Final Usage
dc_awr_control 5 20.00 0   2 1
dc_constraints 648 47.07 0   648 0
dc_files 6,660 0.00 0   0 111
dc_global_oids 5,470,396 0.00 0   0 43
dc_histogram_data 47,802 1.14 0   0 652
dc_histogram_defs 315,279 3.21 0   4,044 3,275
dc_object_grants 51,120 0.07 0   0 66
dc_object_ids 8,896,506 0.02 0   58 1,226
dc_objects 134,157 1.23 0   347 775
dc_profiles 7,150 0.00 0   0 1
dc_rollback_segments 23,996 0.03 0   24 278
dc_segments 274,633 0.69 0   14,759 1,304
dc_sequences 46,378 0.14 0   46,378 112
dc_table_scns 16,844 0.05 0   0 5
dc_tablespace_quotas 14,600 0.18 0   209 40
dc_tablespaces 4,431,998 0.00 0   0 22
dc_usernames 368,614 0.01 0   0 18
dc_users 10,781,251 0.00 0   0 63
outstanding_alerts 268 0.75 0   1 43


Back to Top

 

Library Cache Activity

Namespace Get Requests Pct Miss Pin Requests Pct Miss Reloads Invali- dations
BODY 470,376 0.03 32,129,123 0.00 7 0
CLUSTER 85 2.35 205 1.46 1 0
INDEX 11,138 0.57 11,950 0.78 0 0
JAVA DATA 624 0.00 0   0 0
PIPE 35,646 2.60 52,252 1.77 0 0
SQL AREA 5,414 93.59 91,143,566 0.26 2,727 393
TABLE/PROCEDURE 297,403 0.33 44,357,016 0.01 960 0
TRIGGER 21,440 0.11 1,257,273 0.00 24 0


Back to Top

 

Memory Statistics

Back to Top

Process Memory Summary

  Category Alloc (MB) Used (MB) Avg Alloc (MB) Std Dev Alloc (MB) Max Alloc (MB) Hist Max Alloc (MB) Num Proc Num Alloc
B Other 25,940.55   11.32 6.70 38 38 2,291 2,291
  SQL 2,443.33 1,252.67 1.07 0.70 4 21 2,283 2,281
  Freeable 2,442.19 0.00 1.24 0.78 9   1,966 1,966
  PL/SQL 1,656.72 138.26 0.72 0.93 3 3 2,291 2,291
  JAVA 186.20 185.37 2.22 0.35 5 8 84 84
E Other 32,059.78   13.82 8.59 40 40 2,320 2,320
  Freeable 3,128.31 0.00 1.51 0.95 9   2,066 2,066
  SQL 2,889.92 1,513.42 1.25 0.76 5 21 2,312 2,310
  PL/SQL 1,973.93 160.17 0.85 0.97 3 3 2,320 2,320
  JAVA 186.16 185.35 2.22 0.35 5 8 84 84

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions Begin Size (Bytes) End Size (Bytes) (if different)
Database Buffers 19,058,917,376 18,907,922,432
Fixed Size 2,111,120  
Redo Buffers 14,663,680  
Variable Size 2,399,144,304 2,550,139,248

Back to Memory Statistics
Back to Top

SGA breakdown difference

Pool Name Begin MB End MB % Diff
java free memory 51.29 51.29 0.00
java joxlod exec hp 12.09 12.09 0.00
large free memory 15.94 15.94 0.00
shared ASH buffers 29.00 29.00 0.00
shared CCursor 33.13 33.48 1.05
shared KGLS heap 22.74   -100.00
shared KTI-UNDO 53.19 53.19 0.00
shared PL/SQL MPCODE 66.55 69.43 4.32
shared db_block_hash_buckets 180.00 180.00 0.00
shared event statistics per sess 63.28 63.28 0.00
shared free memory 369.08 355.26 -3.74
shared library cache 604.80 735.97 21.69
shared parameter table block 41.78 42.07 0.68
shared private strands 99.77 99.77 0.00
shared sessions 36.42 36.42 0.00
shared sql area 307.38 341.39 11.06
shared trace buffer 35.84 36.42 1.61
  buffer_cache 18,176.00 18,032.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 Name Begin value End value (if different)
O7_DICTIONARY_ACCESSIBILITY FALSE   
_b_tree_bitmap_plans FALSE   
_fast_full_scan_enabled FALSE   
_like_with_bind_as_equality TRUE   
_sort_elimination_cost_ratio 5   
_sqlexec_progression_cost 2147483647   
_swrf_mmon_dbfus FALSE   
_swrf_mmon_flush FALSE   
_system_trig_enabled TRUE   
aq_tm_processes 1   
background_dump_dest /DB/oracle/product/10.2.0/db_1/admin/VIS/bdump   
compatible 10.2.0.3   
control_files /raw_links/cntrl01, /raw_links/cntrl02, /raw_links/cntrl03   
core_dump_dest /DB/oracle/product/10.2.0/db_1/admin/VIS/cdump   
cursor_sharing exact   
cursor_space_for_time FALSE   
db_block_checking false   
db_block_checksum TRUE   
db_block_size 8192   
db_cache_advice off   
db_files 130   
db_name VIS   
db_writer_processes 3   
dml_locks 10000   
fast_start_mttr_target 180   
java_pool_size 67108864   
job_queue_processes 2   
lock_sga FALSE   
log_buffer 14219264   
log_checkpoint_timeout 1200   
log_checkpoints_to_alert TRUE   
max_dump_file_size unlimited   
nls_comp binary   
nls_date_format DD-MON-RR   
nls_language american   
nls_length_semantics BYTE   
nls_numeric_characters .,   
nls_sort binary   
nls_territory america   
olap_page_pool_size 4194304   
open_cursors 1000   
optimizer_secure_view_merging FALSE   
parallel_max_servers 8   
pga_aggregate_target 21474836480   
plsql_code_type INTERPRETED   
plsql_native_library_dir /DB/oracle/product/10.2.0/db_1/native   
plsql_native_library_subdir_count 300   
plsql_optimize_level 2   
processes 3600   
remote_login_passwordfile EXCLUSIVE   
replication_dependency_tracking FALSE   
session_cached_cursors 500   
sessions 7200   
sga_target 21474836480   
shared_pool_reserved_size 209715200   
shared_pool_size 2097152000   
timed_statistics TRUE   
trace_enabled FALSE   
undo_management AUTO   
undo_tablespace APPS_UNDOTS1   
user_dump_dest /DB/oracle/product/10.2.0/db_1/admin/VIS/udump   
utl_file_dir /usr/tmp   
workarea_size_policy AUTO   


Back to Top

End of Report