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 14-Apr-09 10:19:48 4774 205.9
End Snap: 2 14-Apr-09 11:19:53 4798 235.3
Elapsed:   60.07 (mins)    
DB Time:   342.48 (mins)    

 

Report Summary

Cache Sizes

  Begin End    
Buffer Cache: 18,016M 17,856M Std Block Size: 8K
Shared Pool Size: 2,368M 2,528M Log Buffer: 14,320K

Load Profile

  Per Second Per Transaction
Redo size: 8,747,919.31 27,244.55
Logical reads: 554,688.80 1,727.52
Block changes: 54,341.64 169.24
Physical reads: 129.72 0.40
Physical writes: 844.16 2.63
User calls: 12,472.86 38.85
Parses: 2,366.44 7.37
Hard parses: 2.45 0.01
Sorts: 2,840.41 8.85
Logons: 2.58 0.01
Executes: 27,139.86 84.52
Transactions: 321.09  

% Blocks changed per Read: 9.80 Recursive Call %: 77.89
Rollback per transaction %: 20.63 Rows per Sort: 12.46

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.97 Redo NoWait %: 100.00
Buffer Hit %: 99.98 In-memory Sort %: 100.00
Library Hit %: 99.81 Soft Parse %: 99.90
Execute to Parse %: 91.28 Latch Hit %: 98.97
Parse CPU to Parse Elapsd %: 90.12 % Non-Parse CPU: 97.83

Shared Pool Statistics

  Begin End
Memory Usage %: 85.90 86.86
% SQL with executions>1: 91.37 91.43
% Memory for SQL w/exec>1: 72.95 71.31

Top 5 Timed Events

Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class
CPU time   18,487   90.0  
db file sequential read 290,227 1,140 4 5.5 User I/O
log file sync 502,836 885 2 4.3 Commit
log file parallel write 814,349 509 1 2.5 System I/O
SQL*Net more data from client 2,334,743 181 0 .9 Network

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic Name Time (s) % of DB Time
DB CPU 18,487.07 89.97
sql execute elapsed time 17,388.88 84.62
PL/SQL execution elapsed time 4,107.76 19.99
inbound PL/SQL rpc elapsed time 3,905.73 19.01
parse time elapsed 505.27 2.46
Java execution elapsed time 469.13 2.28
hard parse elapsed time 262.92 1.28
repeated bind elapsed time 77.48 0.38
sequence load elapsed time 12.57 0.06
connection management call elapsed time 9.06 0.04
PL/SQL compilation elapsed time 6.54 0.03
hard parse (sharing criteria) elapsed time 3.24 0.02
failed parse elapsed time 1.30 0.01
hard parse (bind mismatch) elapsed time 0.97 0.00
DB time 20,549.05  
background elapsed time 1,108.72  
background cpu time 305.72  

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 351,001 0.00 1,297 4 0.30
Commit 502,836 0.00 885 2 0.43
System I/O 1,068,597 0.00 699 1 0.92
Network 51,340,817 0.00 242 0 44.36
Concurrency 1,825,446 0.21 149 0 1.58
Application 64,065 0.01 69 1 0.06
Other 119,291 21.10 36 0 0.10
Configuration 7,149 0.00 5 1 0.01

Back to Wait Events Statistics
Back to Top

Wait Events

Event Waits %Time -outs Total Wait Time (s) Avg wait (ms) Waits /txn
db file sequential read 290,227 0.00 1,140 4 0.25
log file sync 502,836 0.00 885 2 0.43
log file parallel write 814,349 0.00 509 1 0.70
SQL*Net more data from client 2,334,743 0.00 181 0 2.02
db file parallel write 223,355 0.00 179 1 0.19
db file scattered read 13,713 0.00 87 6 0.01
read by other session 43,938 0.00 68 2 0.04
SQL*Net message to client 47,104,698 0.00 46 0 40.70
cursor: pin S wait on X 4,303 90.82 43 10 0.00
enq: UL - contention 2,431 0.37 40 16 0.00
latch: cache buffers chains 1,069,388 0.00 27 0 0.92
buffer busy waits 648,009 0.00 26 0 0.56
latch: In memory undo latch 57,266 0.00 18 0 0.05
SQL*Net more data to client 1,901,376 0.00 15 0 1.64
library cache load lock 651 0.00 13 20 0.00
enq: TX - index contention 27,634 0.00 11 0 0.02
SQL*Net break/reset to client 60,960 0.00 11 0 0.05
PX Deq Credit: send blkd 23,610 0.00 9 0 0.02
control file sequential read 29,155 0.00 9 0 0.03
rdbms ipc reply 6 50.00 7 1130 0.00
enq: TX - row lock contention 633 0.00 7 11 0.00
enq: RO - fast object reuse 34 0.00 6 172 0.00
enq: TM - contention 7 0.00 6 824 0.00
latch: undo global data 7,630 0.00 6 1 0.01
latch: library cache 9,289 0.00 6 1 0.01
PX Deq: Signal ACK 285 26.32 3 11 0.00
log buffer space 355 0.00 3 8 0.00
os thread startup 69 0.00 2 31 0.00
latch: object queue header operation 17,775 0.00 2 0 0.02
kksfbc child completion 43 86.05 2 43 0.00
local write wait 1,888 0.00 2 1 0.00
enq: HW - contention 2,677 0.00 2 1 0.00
LGWR wait for redo copy 30,271 0.00 2 0 0.03
latch: cache buffers lru chain 1,766 0.00 1 1 0.00
control file parallel write 1,738 0.00 1 1 0.00
latch: library cache pin 2,432 0.00 1 0 0.00
enq: TX - contention 2,843 0.00 1 0 0.00
latch: row cache objects 835 0.00 1 1 0.00
enq: DV - contention 170 0.00 1 3 0.00
enq: SQ - contention 4,013 0.00 1 0 0.00
latch free 911 0.00 1 1 0.00
library cache pin 1,789 0.00 0 0 0.00
latch: redo allocation 968 0.00 0 0 0.00
latch: session allocation 726 0.00 0 1 0.00
buffer deadlock 25,182 98.66 0 0 0.02
row cache lock 2,781 0.00 0 0 0.00
wait list latch free 20 0.00 0 11 0.00
direct path read 732 0.00 0 0 0.00
SGA: allocation forcing component growth 21 47.62 0 10 0.00
latch: shared pool 739 0.00 0 0 0.00
enq: CU - contention 5 0.00 0 29 0.00
latch: object queue header heap 198 0.00 0 1 0.00
latch: library cache lock 151 0.00 0 1 0.00
cursor: pin S 5,414 0.00 0 0 0.00
enq: FB - contention 695 0.00 0 0 0.00
latch: cache buffer handles 222 0.00 0 0 0.00
PX qref latch 263 76.43 0 0 0.00
enq: TX - allocate ITL entry 66 0.00 0 0 0.00
reliable message 36 0.00 0 1 0.00
cursor: pin X 1 100.00 0 11 0.00
latch: messages 133 0.00 0 0 0.00
latch: redo writing 33 0.00 0 0 0.00
latch: enqueue hash chains 23 0.00 0 0 0.00
cursor: mutex S 93 0.00 0 0 0.00
direct path write 443 0.00 0 0 0.00
cursor: mutex X 17 0.00 0 0 0.00
latch: checkpoint queue latch 30 0.00 0 0 0.00
enq: PS - contention 42 0.00 0 0 0.00
write complete waits 5 0.00 0 1 0.00
direct path write temp 46 0.00 0 0 0.00
direct path read temp 14 0.00 0 0 0.00
L1 validation 2 0.00 0 0 0.00
SQL*Net message from client 47,104,656 0.00 9,204,127 195 40.70
pipe get 26,869 16.58 21,081 785 0.02
Streams AQ: waiting for time management or cleanup tasks 2,747 39.50 3,509 1277 0.00
Streams AQ: qmn slave idle wait 129 0.00 3,505 27170 0.00
Streams AQ: qmn coordinator idle wait 258 50.00 3,505 13585 0.00
PX Idle Wait 1,596 75.69 2,507 1571 0.00
PL/SQL lock timer 196 100.00 2,246 11458 0.00
jobq slave wait 604 99.67 1,768 2927 0.00
PX Deq: Execution Msg 5,061 0.00 38 8 0.00
PX Deq: Execute Reply 2,633 0.00 3 1 0.00
PX Deq Credit: need buffer 4,105 0.00 1 0 0.00
PX Deq: Msg Fragment 4,312 0.00 0 0 0.00
PX Deq: Table Q Normal 4,996 0.00 0 0 0.00
PX Deq: Parse Reply 285 0.00 0 0 0.00
PX Deq: Join ACK 267 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 814,338 0.00 509 1 0.70
db file parallel write 223,355 0.00 179 1 0.19
events in waitclass Other 37,603 0.00 3 0 0.03
control file sequential read 827 0.00 3 3 0.00
os thread startup 61 0.00 2 32 0.00
db file scattered read 474 0.00 2 4 0.00
control file parallel write 1,739 0.00 1 1 0.00
db file sequential read 231 0.00 1 3 0.00
direct path read 732 0.00 0 0 0.00
latch: cache buffers chains 94 0.00 0 0 0.00
latch: redo writing 33 0.00 0 0 0.00
direct path write 333 0.00 0 0 0.00
latch: shared pool 2 0.00 0 0 0.00
latch: library cache 1 0.00 0 0 0.00
log file sync 1 0.00 0 0 0.00
latch: row cache objects 1 0.00 0 0 0.00
buffer busy waits 3 0.00 0 0 0.00
rdbms ipc message 1,470,021 0.84 37,235 25 1.27
pmon timer 1,335 90.94 3,512 2631 0.00
Streams AQ: waiting for time management or cleanup tasks 2,747 39.50 3,509 1277 0.00
Streams AQ: qmn slave idle wait 129 0.00 3,505 27170 0.00
Streams AQ: qmn coordinator idle wait 258 50.00 3,505 13585 0.00
smon timer 147,048 0.00 3,504 24 0.13

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic Total
BUSY_TIME 1,982,797
IDLE_TIME 3,783,893
IOWAIT_TIME 90,003
NICE_TIME 0
SYS_TIME 87,897
USER_TIME 1,837,433
LOAD 4
RSRC_MGR_CPU_WAIT_TIME 0
PHYSICAL_MEMORY_BYTES 53,050,756
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 20,552.40 18,490.30 452,439 1,995,889,653
SYS$BACKGROUND 0.00 0.00 15,186 3,533,737
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 349218 129422 1825273 14729 0 0 51326751 24186
SYS$BACKGROUND 1772 277 162 200 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
680 672 304 2.24 3.31 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
398 358 101,259 0.00 1.94 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
354 352 56,479 0.01 1.72 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
335 330 63,103 0.01 1.63 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
327 324 56,480 0.01 1.59 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...
302 301 56,482 0.01 1.47 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
294 286 1,297 0.23 1.43 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
277 276 336,705 0.00 1.35 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
227 90 2,160 0.10 1.10 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
221 138 19,463 0.01 1.08 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
672 680 304 2.21 3.31 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
358 398 101,259 0.00 1.94 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
352 354 56,479 0.01 1.72 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
330 335 63,103 0.01 1.63 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
324 327 56,480 0.01 1.59 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...
301 302 56,482 0.01 1.47 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
286 294 1,297 0.22 1.43 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
276 277 336,705 0.00 1.35 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
193 201 72,817 0.00 0.98 3prk3vg9u0abb FNDOAMCOL BEGIN FND_GLOBAL.APPS_INITIA...
191 195 58,103 0.00 0.95 bfbyqwbr4vwms OEXOETEL begin OE_OEOL_SCH.SCHEDULE_LIN...
138 221 19,463 0.01 1.08 1q78dwnrrkf6c asn.lead.server.LeadUwqAM BEGIN ASN_SALES_PVT.Lead_Proce...
90 227 2,160 0.04 1.10 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....

Back to SQL Statistics
Back to Top

SQL ordered by Gets

Buffer Gets Executions Gets per Exec %Total CPU Time (s) Elapsed Time (s) SQL Id SQL Module SQL Text
56,409,025 156,480 360.49 2.82 164.42 168.15 5kqw5535fjvw6 ARXTWMAI SELECT NVL(RCTT.ATTRIBUTE10, ...
45,220,461 56,479 800.66 2.26 351.79 354.00 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
43,424,756 304 142,844.59 2.17 671.83 680.42 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
38,266,537 63,103 606.41 1.91 330.25 335.06 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
37,787,415 56,482 669.02 1.89 300.85 302.31 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
29,342,850 1,517,007 19.34 1.47 103.06 103.74 66tmsr3446uqn ap.oie.server.WebExpensesAM SELECT WIAS.ACTIVITY_STATUS, ...
29,275,599 171,589 170.61 1.46 155.57 157.30 3b3psftuyks81 INVTTMTX BEGIN INV_TXNSTUB_PUB.postTran...
29,268,608 171,573 170.59 1.46 144.83 146.52 gf1u933c95jb5 INVTTMTX DECLARE l_ret_stat varchar2...
27,694,002 1,297 21,352.35 1.39 286.44 294.04 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
26,989,495 56,480 477.86 1.35 324.26 326.89 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...
26,395,743 10,000 2,639.57 1.32 75.50 165.47 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
23,376,483 182,404 128.16 1.17 171.63 199.51 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,240 10,000 4.52 9.68 75.50 165.47 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
41,643 2,160 19.28 8.91 12.37 183.69 3dssuqfjsynrk asn.lead.server.LeadUwqAM SELECT count(1) FROM (SELECT *...
35,006 2,160 16.21 7.49 89.57 226.80 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
24,314 19,463 1.25 5.20 137.94 221.22 1q78dwnrrkf6c asn.lead.server.LeadUwqAM BEGIN ASN_SALES_PVT.Lead_Proce...
10,883 649 16.77 2.33 71.43 109.53 dk0sqcvc2xjvs qotSCopHdrUpd.jsp BEGIN ASO_QUOTE_PUB_W.Create_Q...
10,021 6,490 1.54 2.14 98.48 140.34 8jb36w62w5hqf ibuSRDetailsActions.jsp BEGIN IBU_REQ_PKG.UpdateServic...
9,984 182,404 0.05 2.14 171.63 199.51 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
4,597 9,999 0.46 0.98 117.77 128.68 csvvv0fmhr1yc PYUSLV BEGIN FFP1893_01010001.FORMULA...
4,511 10,000 0.45 0.96 97.35 105.68 63t8zpm02skgh PYUSLV SELECT DECODE(COUNT(PRR.RUN_RE...
2,025 90,848 0.02 0.43 100.89 106.00 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,517,007 784,221 0.52 0.00 0.00 66tmsr3446uqn ap.oie.server.WebExpensesAM SELECT WIAS.ACTIVITY_STATUS, ...
859,825 859,825 1.00 0.00 0.00 cd9mbmqyf4qhp ap.oie.server.WebExpensesAM UPDATE WF_ITEM_ACTIVITY_STATUS...
537,522 537,520 1.00 0.00 0.00 avc1jqzz04wpr JDBC Thin Client SELECT 'x' FROM DUAL
336,705 336,701 1.00 0.00 0.00 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
315,731 242,501 0.77 0.00 0.00 fmfdkztk8vx23   SELECT CATEGORY, SEVERITY, F...
261,849 4,451,256 17.00 0.00 0.00 cwyx16zn1hpfb JDBC Thin Client select parameter, value from ...
182,404 182,403 1.00 0.00 0.00 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
171,589 171,589 1.00 0.00 0.00 3b3psftuyks81 INVTTMTX BEGIN INV_TXNSTUB_PUB.postTran...
171,588 171,584 1.00 0.00 0.00 6gnth2mfbs2nq INVTTMTX declare v_ret number := 0...
171,573 171,573 1.00 0.00 0.00 gf1u933c95jb5 INVTTMTX DECLARE l_ret_stat varchar2...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse Calls Executions % Total Parses SQL Id SQL Module SQL Text
537,524 537,522 6.30 avc1jqzz04wpr JDBC Thin Client SELECT 'x' FROM DUAL
336,705 336,705 3.95 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
315,724 315,731 3.70 fmfdkztk8vx23   SELECT CATEGORY, SEVERITY, F...
261,851 261,849 3.07 cwyx16zn1hpfb JDBC Thin Client select parameter, value from ...
182,404 182,404 2.14 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
171,590 171,588 2.01 6gnth2mfbs2nq INVTTMTX declare v_ret number := 0...
122,690 122,686 1.44 fb13x9qx0ftks OEXOETEL begin OE_STANDARD_WF.OEOL_SELE...
115,110 115,108 1.35 1c0b7sas42w2z INVTTMTX SELECT NVL(ITEM_COST, 0), ...
108,326 108,326 1.27 162ttnv4ubqun OEXOETEL begin OE_DS_PVT.Check_PO_Appr...
100,222 100,222 1.18 8camsgjsr9zya OEXOETEL begin OE_TRANSACTION_TYPES_PK...
97,217 97,216 1.14 76sw2a4vnc89j icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.S...
91,802 91,798 1.08 608c0n36kaw62 icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.C...
91,802 91,799 1.08 bf7uwg5pa3pj6 icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.V...
91,802 97,215 1.08 dcvv68fju01g4 icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.E...

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 ) )
3prk3vg9u0abb BEGIN FND_GLOBAL.APPS_INITIALIZE( user_id=>:1 , resp_id=>:2 , resp_appl_id=>:3 , security_group_id=>:4 , server_id=>:5);END;
4yak7x2zqz0dh BEGIN inv_transfer_order_pvt.finalize_pick_confirm(:1, :2, :3, :4, :5, :6, :7); END;
5kqw5535fjvw6 SELECT NVL(RCTT.ATTRIBUTE10, ' ') FROM RA_CUST_TRX_TYPES_ALL RCTT, RA_CUSTOMER_TRX_ALL RCT WHERE RCT.CUSTOMER_TRX_ID = :B1 AND RCT.CUST_TRX_TYPE_ID = RCTT.CUST_TRX_TYPE_ID
608c0n36kaw62 begin FND_FLEX_WORKFLOW_APIS.COPY_FROM_COMBINATION (:v1, :v2, :v3, :v4, :v5); end;
63t8zpm02skgh SELECT DECODE(COUNT(PRR.RUN_RESULT_ID), 0, 'N', 'Y') FROM PAY_RUN_RESULTS PRR, PAY_ASSIGNMENT_ACTIONS ASA, PAY_PAYROLL_ACTIONS PPA WHERE PRR.SOURCE_ID = :B3 AND PRR.SOURCE_TYPE IN ('E', 'I') AND PRR.STATUS IN ('P', 'PA', 'R', 'O') AND ASA.ASSIGNMENT_ACTION_ID = PRR.ASSIGNMENT_ACTION_ID AND PPA.PAYROLL_ACTION_ID = ASA.PAYROLL_ACTION_ID AND NOT EXISTS (SELECT NULL FROM PAY_RUN_RESULTS PRR2 WHERE PRR2.SOURCE_ID = PRR.RUN_RESULT_ID AND PRR2.SOURCE_TYPE IN ('R', 'V')) AND PPA.DATE_EARNED BETWEEN :B2 AND :B1
64qc329wgjv39 select /*+ ORDERED INDEX(ASSBAL PAY_ASSIGNMENT_LATEST_BALA_N1) INDEX(DEFBAL PAY_DEFINED_BALANCES_PK) INDEX(ACT PAY_ASSIGNMENT_ACTIONS_PK) INDEX(PACT PAY_PAYROLL_ACTIONS_PK) INDEX(VALUE PAY_BALANCE_CONTEXT_VALUES_PK) USE_NL(ASSBAL DEFBAL ACT PACT VALUE) +*/ ASSBAL.defined_balance_id , DEFBAL.balance_dimension_id , to_char(ASSBAL.value) , ASSBAL.latest_balance_id , ASSBAL.rowid , to_char(ASSBAL.assignment_action_id) , ACT.payroll_action_id , to_char(PACT.effective_date, :b0) , to_number(to_char(PACT.effective_date, 'J')) , nvl(VALUE.context_id, 0) , nvl(VALUE.value, 'NULL') , to_char(ASSBAL.expired_assignment_action_id) , to_char(ASSBAL.expired_value) , to_char(ASSBAL.prev_assignment_action_id) , to_char(ASSBAL.prev_balance_value) from pay_assignment_latest_balances ASSBAL , pay_defined_balances DEFBAL , pay_assignment_actions ACT , pay_payroll_actions PACT , pay_balance_context_values VALUE where ((((ASSBAL.assignment_id=:b1 and ACT.assignment_action_id=ASSBAL.assignment_action_id) and PACT.payroll_action_id=ACT.payroll_action_id) and DEFBAL.defined_balance_id=ASSBAL.defined_balance_id) and VALUE.latest_balance_id(+)=ASSBAL.latest_balance_id) union all select /*+ ORDERED INDEX(PERBAL PAY_PERSON_LATEST_BALANCES_N2) INDEX(DEFBAL PAY_DEFINED_BALANCES_PK) INDEX(ACT PAY_ASSIGNMENT_ACTIONS_PK) INDEX(VALUE PAY_BALANCE_CONTEXT_VALUES_PK) INDEX(PACT PAY_PAYROLL_ACTIONS_PK) USE_NL(PERBAL DEFBAL ACT PACT VALUE) +*/ PERBAL.defined_balance_id , DEFBAL.balance_dimension_id , to_char (PERBAL.value) , PERBAL.latest_balance_id , PERBAL.rowid , to_char(PERBAL.assignment_action_id) , ACT.payroll_action_id , to_char(PACT.effective_date, :b0) , to_number(to_char(PACT.effective_date, 'J')) , nvl(VALUE.context_id, 0) , nvl(VALUE.value, 'NULL') , to_char(PERBAL.expired_assignment_action_id) , to_char(PERBAL.expired_value) , to_char(PERBAL.prev_assignment_action_id) , to_char(PERBAL.prev_balance_value) from pay_person_latest_balances PERBAL , pay_defined_balances DEFBAL , pay_assignment_actions ACT , pay_payroll_actions PACT , pay_balance_context_values VALUE where ((((PERBAL.person_id=:b3 and ACT.assignment_action_id=PERBAL.assignment_action_id) and PACT.payroll_action_id=ACT.payroll_action_id) and DEFBAL.defined_balance_id=PERBAL.defined_balance_id) and VALUE.latest_balance_id(+)=PERBAL.latest_balance_id) order by 6, 2, 1, 4, 10 desc
66tmsr3446uqn SELECT WIAS.ACTIVITY_STATUS, WIAS.ACTIVITY_RESULT_CODE, WIAS.ASSIGNED_USER, WIAS.NOTIFICATION_ID, WIAS.BEGIN_DATE, WIAS.END_DATE, WIAS.DUE_DATE, WIAS.ERROR_NAME, WIAS.ERROR_MESSAGE, WIAS.ERROR_STACK FROM WF_ITEM_ACTIVITY_STATUSES WIAS WHERE WIAS.ITEM_TYPE = :B3 AND WIAS.ITEM_KEY = :B2 AND WIAS.PROCESS_ACTIVITY = :B1
6gnth2mfbs2nq declare v_ret number := 0; begin if (INV_TABLE_LOCK_PVT.lock_onhand_records(:1, :2, :3, :4, :5, :6, :7) ) then v_ret := 1; end if; :8 := v_ret; end;
6h2tpcxpymqu7 BEGIN :1 := FND_AOLJ_UTIL.is_Valid_ICX(:2, NULL, 'Y', TRUE, TRUE, NULL, NULL, NULL, NULL, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, TRUE);:19 := fnd_session_management.g_enc_key;:20 := fnd_session_management.g_mac_key;END;
76sw2a4vnc89j begin FND_FLEX_WORKFLOW_APIS.START_GENERATION (:v1, :v2, :v3, :v4, :v5); end;
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,824,611 506.26 1.58
CPU used when call started 1,820,680 505.16 1.57
CR blocks created 15,408,999 4,275.37 13.32
Cached Commit SCN referenced 46,679 12.95 0.04
Commit SCN cached 8 0.00 0.00
DB time 4,751,537 1,318.36 4.11
DBWR checkpoint buffers written 2,955,809 820.12 2.55
DBWR checkpoints 34 0.01 0.00
DBWR object drop buffers written 57,462 15.94 0.05
DBWR revisited being-written buffer 467 0.13 0.00
DBWR thread checkpoint buffers written 536,951 148.98 0.46
DBWR transaction table writes 2,335 0.65 0.00
DBWR undo block writes 1,587,651 440.51 1.37
DFO trees parallelized 48 0.01 0.00
IMU CR rollbacks 36,452,613 10,114.12 31.50
IMU Flushes 336,418 93.34 0.29
IMU Redo allocation size 2,248,508,956 623,869.93 1,942.98
IMU commits 601,340 166.85 0.52
IMU contention 36,990 10.26 0.03
IMU ktichg flush 10,402 2.89 0.01
IMU pool not allocated 0 0.00 0.00
IMU recursive-transaction flush 1,610 0.45 0.00
IMU undo allocation size 5,404,226,568 1,499,453.42 4,669.90
IMU- failed to get a private strand 0 0.00 0.00
PX local messages recv'd 51,976 14.42 0.04
PX local messages sent 51,976 14.42 0.04
Parallel operations downgraded 25 to 50 pct 40 0.01 0.00
Parallel operations not downgraded 8 0.00 0.00
SQL*Net roundtrips to/from client 47,082,279 13,063.42 40.68
active txn count during cleanout 114,949,149 31,893.72 99.33
application wait time 6,869 1.91 0.01
background checkpoints completed 3 0.00 0.00
background checkpoints started 2 0.00 0.00
background timeouts 13,900 3.86 0.01
branch node splits 1,058 0.29 0.00
buffer is not pinned count 573,042,857 158,996.12 495.18
buffer is pinned count 1,481,057,296 410,933.26 1,279.81
bytes received via SQL*Net from client 10,355,832,615 2,873,323.03 8,948.69
bytes sent via SQL*Net to client 9,454,046,725 2,623,114.07 8,169.44
calls to get snapshot scn: kcmgss 109,909,001 30,495.28 94.97
calls to kcmgas 19,572,661 5,430.62 16.91
calls to kcmgcs 13,957,089 3,872.53 12.06
change write time 40,718 11.30 0.04
cleanout - number of ktugct calls 27,812,104 7,716.73 24.03
cleanouts and rollbacks - consistent read gets 13,471,205 3,737.71 11.64
cleanouts only - consistent read gets 150,507 41.76 0.13
cluster key scan block gets 852,288 236.48 0.74
cluster key scans 236,847 65.72 0.20
commit batch/immediate performed 4,385 1.22 0.00
commit batch/immediate requested 4,385 1.22 0.00
commit cleanout failures: block lost 244,080 67.72 0.21
commit cleanout failures: buffer being written 2,037 0.57 0.00
commit cleanout failures: callback failure 107,412 29.80 0.09
commit cleanout failures: cannot pin 33,400 9.27 0.03
commit cleanouts 9,192,973 2,550.68 7.94
commit cleanouts successfully completed 8,806,044 2,443.32 7.61
commit immediate performed 4,385 1.22 0.00
commit immediate requested 4,385 1.22 0.00
commit txn count during cleanout 1,364,653 378.64 1.18
concurrency wait time 14,929 4.14 0.01
consistent changes 758,119,763 210,347.45 655.11
consistent gets 1,776,202,023 492,823.94 1,534.85
consistent gets - examination 1,252,732,860 347,582.50 1,082.51
consistent gets from cache 1,776,202,101 492,823.96 1,534.85
cursor authentications 2,130 0.59 0.00
data blocks consistent reads - undo records applied 754,185,197 209,255.77 651.71
db block changes 195,854,404 54,341.64 169.24
db block gets 222,968,931 61,864.82 192.67
db block gets direct 4,206 1.17 0.00
db block gets from cache 222,964,789 61,863.68 192.67
deferred (CURRENT) block cleanout applications 1,592,225 441.78 1.38
dirty buffers inspected 10,489 2.91 0.01
enqueue conversions 9,711 2.69 0.01
enqueue releases 4,350,875 1,207.19 3.76
enqueue requests 4,358,701 1,209.36 3.77
enqueue timeouts 7,630 2.12 0.01
enqueue waits 34,840 9.67 0.03
exchange deadlocks 25,182 6.99 0.02
execute count 97,815,605 27,139.86 84.52
failed probes on index block reclamation 7,859 2.18 0.01
frame signature mismatch 190 0.05 0.00
free buffer inspected 2,982,112 827.41 2.58
free buffer requested 19,949,318 5,535.13 17.24
heap block compress 32,146,542 8,919.36 27.78
hot buffers moved to head of LRU 1,351,212 374.91 1.17
immediate (CR) block cleanout applications 13,621,715 3,779.47 11.77
immediate (CURRENT) block cleanout applications 1,129,806 313.48 0.98
index crx upgrade (found) 12,907 3.58 0.01
index crx upgrade (positioned) 9,734,712 2,700.99 8.41
index fast full scans (rowid ranges) 800 0.22 0.00
index fetch by key 183,348,774 50,871.84 158.44
index scans kdiixs1 132,749,271 36,832.53 114.71
java call heap collected bytes 1,404,022,472 389,559.22 1,213.24
java call heap collected count 17,169,334 4,763.79 14.84
java call heap gc count 4,622 1.28 0.00
java call heap live object count 1,534,232 425.69 1.33
java call heap live object count max 1,537,600 426.62 1.33
java call heap live size 364,005,576 100,996.77 314.54
java call heap live size max 364,653,944 101,176.66 315.10
java call heap object count 3,689,319 1,023.64 3.19
java call heap object count max 3,697,080 1,025.79 3.19
java call heap total size 465,829,888 129,248.88 402.53
java call heap total size max 466,355,200 129,394.63 402.99
java call heap used size 501,999,224 139,284.40 433.79
java call heap used size max 502,980,768 139,556.74 434.64
leaf node 90-10 splits 20,465 5.68 0.02
leaf node splits 242,727 67.35 0.21
lob reads 21,342 5.92 0.02
lob writes 37,194 10.32 0.03
lob writes unaligned 37,194 10.32 0.03
logons cumulative 9,313 2.58 0.01
messages received 1,872,811 519.63 1.62
messages sent 1,872,811 519.63 1.62
no buffer to keep pinned count 16 0.00 0.00
no work - consistent read gets 475,429,688 131,912.43 410.83
opened cursors cumulative 5,528,643 1,533.97 4.78
parse count (failures) 3,255 0.90 0.00
parse count (hard) 8,833 2.45 0.01
parse count (total) 8,528,964 2,366.44 7.37
parse time cpu 40,131 11.13 0.03
parse time elapsed 44,531 12.36 0.04
physical read IO requests 304,570 84.51 0.26
physical read bytes 3,829,948,416 1,062,655.16 3,309.54
physical read total IO requests 333,836 92.63 0.29
physical read total bytes 4,308,533,248 1,195,443.02 3,723.09
physical read total multi block requests 13,713 3.80 0.01
physical reads 467,523 129.72 0.40
physical reads cache 466,357 129.40 0.40
physical reads cache prefetch 162,533 45.10 0.14
physical reads direct 1,166 0.32 0.00
physical reads direct temporary tablespace 434 0.12 0.00
physical reads prefetch warmup 93,435 25.92 0.08
physical write IO requests 1,782,359 494.53 1.54
physical write bytes 24,923,758,592 6,915,330.93 21,537.13
physical write total IO requests 2,955,548 820.04 2.55
physical write total bytes 57,919,626,752 16,070,344.49 50,049.54
physical write total multi block requests 1,356,726 376.44 1.17
physical writes 3,042,451 844.16 2.63
physical writes direct 4,973 1.38 0.00
physical writes direct (lob) 233 0.06 0.00
physical writes direct temporary tablespace 4,352 1.21 0.00
physical writes from cache 3,037,478 842.78 2.62
physical writes non checkpoint 2,330,590 646.64 2.01
pinned buffers inspected 3,483 0.97 0.00
prefetch warmup blocks aged out before use 240,580 66.75 0.21
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 calls 158,410,548 43,952.49 136.89
recursive cpu usage 1,023,342 283.94 0.88
redo blocks written 64,278,133 17,834.57 55.54
redo buffer allocation retries 421 0.12 0.00
redo entries 100,601,373 27,912.80 86.93
redo log space requests 0 0.00 0.00
redo log space wait time 0 0.00 0.00
redo ordering marks 1,292,350 358.57 1.12
redo size 31,528,647,160 8,747,919.31 27,244.55
redo subscn max counts 2,337,554 648.58 2.02
redo synch time 91,535 25.40 0.08
redo synch writes 2,187,364 606.90 1.89
redo wastage 305,187,100 84,677.03 263.72
redo write time 54,660 15.17 0.05
redo writer latching time 179 0.05 0.00
redo writes 814,218 225.91 0.70
rollback changes - undo records applied 200,278 55.57 0.17
rollbacks only - consistent read gets 2,054,416 570.02 1.78
rows fetched via callback 96,242,406 26,703.36 83.17
session connect time 0 0.00 0.00
session cursor cache hits 5,355,896 1,486.04 4.63
session logical reads 1,999,171,100 554,688.80 1,727.52
session pga memory 10,491,100,520 2,910,854.38 9,065.58
session pga memory max 11,667,024,648 3,237,125.58 10,081.72
session uga memory ############### 75,169,170.10 234,107.13
session uga memory max 68,802,092,360 19,089,786.79 59,453.30
shared hash latch upgrades - no wait 31,667,140 8,786.35 27.36
shared hash latch upgrades - wait 29,103 8.07 0.03
sorts (memory) 10,237,207 2,840.41 8.85
sorts (rows) 127,569,007 35,395.22 110.23
sql area evicted 2,700 0.75 0.00
sql area purged 3,425 0.95 0.00
summed dirty queue length 318,855 88.47 0.28
switch current to new buffer 1,475,280 409.33 1.27
table fetch by rowid 878,389,766 243,717.49 759.03
table fetch continued row 28,082,102 7,791.64 24.27
table scan blocks gotten 91,385,458 25,355.75 78.97
table scan rows gotten 6,802,598,098 1,887,444.74 5,878.26
table scans (long tables) 2,036 0.56 0.00
table scans (rowid ranges) 2,034 0.56 0.00
table scans (short tables) 5,721,055 1,587.36 4.94
total number of times SMON posted 147,005 40.79 0.13
transaction rollbacks 4,385 1.22 0.00
transaction tables consistent read rollbacks 69 0.02 0.00
transaction tables consistent reads - undo records applied 5,807 1.61 0.01
undo change vector size 11,036,346,160 3,062,137.91 9,536.73
user I/O wait time 129,686 35.98 0.11
user calls 44,953,832 12,472.86 38.85
user commits 918,545 254.86 0.79
user rollbacks 238,701 66.23 0.21
workarea executions - onepass 2 0.00 0.00
workarea executions - optimal 6,071,657 1,684.64 5.25
write clones created in background 1,884 0.52 0.00
write clones created in foreground 10,558 2.93 0.01

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistic Begin Value End Value
session cursor cache count 437,461 1,098,152
opened cursors current 983,076 1,129,140
logons current 4,774 4,798

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 34 0 10.29 1.00 860,627 239 249,534 0.03
APPS_TS_TX_DATA 184,680 51 4.08 1.29 220,049 61 111,698 0.20
APPS_TS_TX_IDX 94,789 26 4.28 1.42 211,903 59 54,034 0.47
APPS_ASSM_DATA 8,673 2 1.97 6.60 250,800 70 41,551 0.52
APPS_ASSM_IDX 6,517 2 2.09 1.05 171,715 48 186,177 0.08
APPS_TS_TX_INTERFACE 1,225 0 2.06 2.08 32,130 9 24,030 0.03
TEMP 487 0 4.00 9.81 10,435 3 57 2.11
APPS_TS_SUMMARY 62 0 6.77 1.00 8,144 2 2,091 0.02
APPS_TS_SEED 2,468 1 6.08 1.77 5,095 1 848 2.71
SYSTEM 4,793 1 3.77 3.82 2,550 1 21,267 0.05
APPS_TS_QUEUES 373 0 5.07 2.24 5,104 1 567 0.28
APPS_TS_ARCHIVE 55 0 5.64 1.47 2,261 1 93 2.69
SYSAUX 289 0 2.49 1.10 1,499 0 0 0.00
APPS_TS_NOLOGGING 25 0 6.00 1.56 47 0 0 0.00
CTXSYS 24 0 1.67 1.00 6 0 0 0.00
APPS_TS_MEDIA 12 0 7.50 1.00 9 0 0 0.00
ODM 12 0 2.50 1.00 3 0 0 0.00
OLAP 12 0 3.33 1.00 3 0 0 0.00
OWAPUB 12 0 3.33 1.00 3 0 0 0.00
PORTAL 12 0 3.33 1.00 3 0 0 0.00
SYNCSERVER 12 0 2.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,673 2 1.97 6.60 250,800 70 41,551 0.52
APPS_ASSM_IDX /DB/visdata/apps_assm_idx.dbf 6,517 2 2.09 1.05 171,715 48 186,177 0.08
APPS_TS_ARCHIVE /DB/visdata/archive1.dbf 26 0 4.62 1.58 2,012 1 90 2.67
APPS_TS_ARCHIVE /DB/visdata/archive2.dbf 29 0 6.55 1.38 249 0 3 3.33
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 5.00 1.00 3 0 0 0.00
APPS_TS_MEDIA /DB/visdata/media3.dbf 4 0 10.00 1.00 3 0 0 0.00
APPS_TS_NOLOGGING /DB/visdata/nologging1.dbf 4 0 5.00 1.00 3 0 0 0.00
APPS_TS_NOLOGGING /DB/visdata/nologging2.dbf 15 0 6.00 1.00 31 0 0 0.00
APPS_TS_NOLOGGING /DB/visdata/nologging3.dbf 6 0 6.67 3.33 13 0 0 0.00
APPS_TS_QUEUES /DB/visdata/queues1.dbf 69 0 4.49 1.81 937 0 236 0.25
APPS_TS_QUEUES /DB/visdata/queues2.dbf 26 0 5.38 3.08 725 0 258 0.23
APPS_TS_QUEUES /DB/visdata/queues3.dbf 28 0 3.93 2.93 837 0 1 0.00
APPS_TS_QUEUES /DB/visdata/queues4.dbf 60 0 5.83 2.02 697 0 0 0.00
APPS_TS_QUEUES /DB/visdata/queues5.dbf 35 0 6.00 3.17 603 0 3 0.00
APPS_TS_QUEUES /DB/visdata/queues6.dbf 30 0 6.33 2.80 526 0 1 0.00
APPS_TS_QUEUES /DB/visdata/queues7.dbf 125 0 4.64 1.85 779 0 68 0.59
APPS_TS_SEED /DB/visdata/reference1.dbf 211 0 6.64 2.00 455 0 52 7.12
APPS_TS_SEED /DB/visdata/reference10.dbf 228 0 6.40 1.74 547 0 58 3.62
APPS_TS_SEED /DB/visdata/reference2.dbf 245 0 5.55 1.69 533 0 49 1.22
APPS_TS_SEED /DB/visdata/reference3.dbf 371 0 5.47 1.77 545 0 438 2.31
APPS_TS_SEED /DB/visdata/reference4.dbf 226 0 6.86 1.86 498 0 37 2.70
APPS_TS_SEED /DB/visdata/reference5.dbf 268 0 6.42 1.56 486 0 26 1.92
APPS_TS_SEED /DB/visdata/reference6.dbf 240 0 6.04 1.92 572 0 36 1.11
APPS_TS_SEED /DB/visdata/reference7.dbf 248 0 6.21 1.66 457 0 35 7.14
APPS_TS_SEED /DB/visdata/reference8.dbf 223 0 5.87 2.01 488 0 48 3.33
APPS_TS_SEED /DB/visdata/reference9.dbf 208 0 5.67 1.55 514 0 69 0.72
APPS_TS_SUMMARY /DB/visdata/summary1.dbf 5 0 4.00 1.00 934 0 304 0.00
APPS_TS_SUMMARY /DB/visdata/summary2.dbf 5 0 4.00 1.00 940 0 200 0.00
APPS_TS_SUMMARY /DB/visdata/summary3.dbf 12 0 8.33 1.00 942 0 163 0.00
APPS_TS_SUMMARY /DB/visdata/summary4.dbf 12 0 5.00 1.00 840 0 145 0.07
APPS_TS_SUMMARY /DB/visdata/summary5.dbf 7 0 5.71 1.00 1,022 0 319 0.03
APPS_TS_SUMMARY /DB/visdata/summary6.dbf 7 0 12.86 1.00 1,114 0 591 0.00
APPS_TS_SUMMARY /DB/visdata/summary7.dbf 7 0 5.71 1.00 1,163 0 218 0.05
APPS_TS_SUMMARY /DB/visdata/summary8.dbf 7 0 7.14 1.00 1,189 0 151 0.13
APPS_TS_TX_DATA /DB/visdata/tx_data1.dbf 3,358 1 4.76 1.22 381 0 6 1.67
APPS_TS_TX_DATA /DB/visdata/tx_data10.dbf 3,354 1 4.49 1.21 233 0 0 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data11.dbf 3,317 1 4.62 1.28 209 0 0 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data12.dbf 13,334 4 2.94 1.23 4,494 1 2,950 0.76
APPS_TS_TX_DATA /DB/visdata/tx_data13.dbf 18,877 5 4.55 1.46 5,609 2 2,325 0.87
APPS_TS_TX_DATA /DB/visdata/tx_data14.dbf 13,442 4 3.91 1.35 32,526 9 14,185 0.16
APPS_TS_TX_DATA /DB/visdata/tx_data15.dbf 9,617 3 3.85 1.40 31,073 9 15,304 0.17
APPS_TS_TX_DATA /DB/visdata/tx_data16.dbf 9,670 3 3.83 1.40 29,339 8 15,123 0.14
APPS_TS_TX_DATA /DB/visdata/tx_data17.dbf 9,476 3 3.73 1.40 28,308 8 14,334 0.17
APPS_TS_TX_DATA /DB/visdata/tx_data18.dbf 9,534 3 3.72 1.38 27,544 8 14,335 0.14
APPS_TS_TX_DATA /DB/visdata/tx_data19.dbf 9,455 3 3.76 1.40 27,233 8 14,962 0.15
APPS_TS_TX_DATA /DB/visdata/tx_data2.dbf 6,877 2 3.16 1.14 1,396 0 2,009 0.90
APPS_TS_TX_DATA /DB/visdata/tx_data20.dbf 9,484 3 3.90 1.43 27,851 8 14,734 0.15
APPS_TS_TX_DATA /DB/visdata/tx_data21.dbf 25,691 7 4.51 1.15 1,070 0 1,380 0.02
APPS_TS_TX_DATA /DB/visdata/tx_data3.dbf 3,886 1 4.92 1.38 441 0 11 3.64
APPS_TS_TX_DATA /DB/visdata/tx_data4.dbf 18,313 5 4.35 1.08 333 0 7 2.86
APPS_TS_TX_DATA /DB/visdata/tx_data5.dbf 3,392 1 4.55 1.19 398 0 2 10.00
APPS_TS_TX_DATA /DB/visdata/tx_data6.dbf 3,400 1 4.27 1.19 225 0 5 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data7.dbf 3,283 1 4.48 1.21 518 0 20 4.00
APPS_TS_TX_DATA /DB/visdata/tx_data8.dbf 3,358 1 4.30 1.15 549 0 5 2.00
APPS_TS_TX_DATA /DB/visdata/tx_data9.dbf 3,562 1 4.52 1.24 319 0 1 0.00
APPS_TS_TX_IDX /DB/visdata/tx_idx1.dbf 2,590 1 3.47 1.14 2,584 1 977 0.91
APPS_TS_TX_IDX /DB/visdata/tx_idx10.dbf 2,551 1 3.34 1.21 1,791 0 1,141 0.56
APPS_TS_TX_IDX /DB/visdata/tx_idx11.dbf 2,517 1 3.41 1.18 1,972 1 1,064 1.45
APPS_TS_TX_IDX /DB/visdata/tx_idx12.dbf 11,210 3 5.03 1.71 22,119 6 1,158 0.33
APPS_TS_TX_IDX /DB/visdata/tx_idx13.dbf 9,566 3 4.33 1.35 29,019 8 3,149 0.33
APPS_TS_TX_IDX /DB/visdata/tx_idx14.dbf 5,750 2 4.75 1.46 21,071 6 2,993 0.18
APPS_TS_TX_IDX /DB/visdata/tx_idx15.dbf 5,663 2 4.66 1.50 17,924 5 4,079 0.14
APPS_TS_TX_IDX /DB/visdata/tx_idx16.dbf 5,622 2 4.57 1.49 16,317 5 3,220 0.43
APPS_TS_TX_IDX /DB/visdata/tx_idx17.dbf 5,559 2 4.67 1.44 15,160 4 3,946 1.94
APPS_TS_TX_IDX /DB/visdata/tx_idx18.dbf 5,734 2 4.75 1.47 15,132 4 5,792 0.09
APPS_TS_TX_IDX /DB/visdata/tx_idx19.dbf 5,623 2 4.55 1.49 14,752 4 3,937 0.10
APPS_TS_TX_IDX /DB/visdata/tx_idx2.dbf 3,144 1 4.03 1.39 2,363 1 1,921 0.42
APPS_TS_TX_IDX /DB/visdata/tx_idx20.dbf 5,578 2 4.59 1.49 13,966 4 2,811 0.14
APPS_TS_TX_IDX /DB/visdata/tx_idx21.dbf 3,549 1 5.10 1.70 16,361 5 2,265 0.46
APPS_TS_TX_IDX /DB/visdata/tx_idx3.dbf 4,110 1 2.77 1.17 2,120 1 1,699 0.76
APPS_TS_TX_IDX /DB/visdata/tx_idx4.dbf 2,731 1 3.26 1.18 3,824 1 1,735 0.88
APPS_TS_TX_IDX /DB/visdata/tx_idx5.dbf 2,729 1 3.72 1.28 5,132 1 7,436 0.14
APPS_TS_TX_IDX /DB/visdata/tx_idx6.dbf 2,707 1 3.33 1.24 3,052 1 1,327 0.93
APPS_TS_TX_IDX /DB/visdata/tx_idx7.dbf 2,677 1 3.70 1.25 2,867 1 1,109 0.75
APPS_TS_TX_IDX /DB/visdata/tx_idx8.dbf 2,585 1 3.54 1.24 2,311 1 1,108 0.99
APPS_TS_TX_IDX /DB/visdata/tx_idx9.dbf 2,594 1 3.46 1.23 2,066 1 1,167 0.54
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte.dbf 155 0 1.48 1.99 5,246 1 10,447 0.03
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte2.dbf 250 0 3.24 2.30 6,492 2 5,361 0.02
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte3.dbf 90 0 4.67 3.74 5,583 2 3,843 0.04
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte4.dbf 159 0 1.82 2.33 4,913 1 1,681 0.03
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte5.dbf 338 0 1.09 1.57 4,996 1 1,763 0.01
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte6.dbf 233 0 1.72 1.81 4,900 1 935 0.01
APPS_UNDOTS1 /DB/visdata/undo01.dbf 3 0 13.33 1.00 86,197 24 19,788 0.02
APPS_UNDOTS1 /DB/visdata/undo02.dbf 3 0 6.67 1.00 86,908 24 20,098 0.02
APPS_UNDOTS1 /DB/visdata/undo03.dbf 4 0 7.50 1.00 90,613 25 21,408 0.02
APPS_UNDOTS1 /DB/visdata/undo04.dbf 4 0 12.50 1.00 88,179 24 20,548 0.02
APPS_UNDOTS1 /DB/visdata/undo05.dbf 3 0 13.33 1.00 84,991 24 28,447 0.03
APPS_UNDOTS1 /DB/visdata/undo06.dbf 3 0 6.67 1.00 86,065 24 22,573 0.03
APPS_UNDOTS1 /DB/visdata/undo07.dbf 4 0 7.50 1.00 83,651 23 24,127 0.02
APPS_UNDOTS1 /DB/visdata/undo08.dbf 3 0 13.33 1.00 82,162 23 32,939 0.03
APPS_UNDOTS1 /DB/visdata/undo09.dbf 4 0 5.00 1.00 85,734 24 34,719 0.06
APPS_UNDOTS1 /DB/visdata/undo10.dbf 3 0 20.00 1.00 86,127 24 24,887 0.07
CTXSYS /DB/visdata/ctx1.dbf 12 0 1.67 1.00 3 0 0 0.00
CTXSYS /DB/visdata/ctx2.dbf 12 0 1.67 1.00 3 0 0 0.00
ODM /DB/visdata/odm.dbf 12 0 2.50 1.00 3 0 0 0.00
OLAP /DB/visdata/olap.dbf 12 0 3.33 1.00 3 0 0 0.00
OWAPUB /DB/visdata/owa1.dbf 12 0 3.33 1.00 3 0 0 0.00
PORTAL /DB/visdata/portal.dbf 12 0 3.33 1.00 3 0 0 0.00
SYNCSERVER /DB/visdata/mobile01.dbf 12 0 2.50 1.00 3 0 0 0.00
SYSAUX /DB/visdata/sysaux01.dbf 5 0 12.00 1.40 587 0 0 0.00
SYSAUX /DB/visdata/sysaux02.dbf 284 0 2.32 1.10 912 0 0 0.00
SYSTEM /DB/visdata/sys1.dbf 518 0 3.09 4.31 105 0 4 0.00
SYSTEM /DB/visdata/sys2.dbf 535 0 3.63 4.36 175 0 17 0.00
SYSTEM /DB/visdata/sys3.dbf 611 0 3.44 3.81 241 0 2 0.00
SYSTEM /DB/visdata/sys4.dbf 565 0 3.45 4.06 251 0 6 5.00
SYSTEM /DB/visdata/sys5.dbf 790 0 3.99 3.14 660 0 777 0.06
SYSTEM /DB/visdata/sys6.dbf 545 0 4.37 4.25 60 0 0 0.00
SYSTEM /DB/visdata/sys7.dbf 427 0 4.33 4.42 149 0 23 0.00
SYSTEM /DB/visdata/sys8.dbf 350 0 3.77 3.46 496 0 20,427 0.04
SYSTEM /DB/visdata/sys9.dbf 452 0 3.96 2.73 413 0 11 0.00
TEMP /DB/visdata/temp1.dbf 141 0 4.11 14.28 2,962 1 25 3.20
TEMP /DB/visdata/temp2.dbf 116 0 4.40 9.37 2,786 1 15 0.67
TEMP /DB/visdata/temp3.dbf 109 0 3.49 7.96 2,422 1 17 1.76
TEMP /DB/visdata/temp4.dbf 121 0 3.97 6.69 2,265 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,208,564 100 1,998,956,213 466,348 3,037,835 0 0 691,938


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 87 44246 1050274 4015636 188743680 4015636  
E 180 90 48471 1044627 9711612 188743680 9711612  

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 578,181 10

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 41,706.35 1.37 0.00 100.00 0.00 1,048,576
E 20,480 1,280 50,338.86 1.15 0.00 100.00 0.00 1,048,576

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High Optimal Total Execs Optimal Execs 1-Pass Execs M-Pass Execs
2K 4K 5,490,718 5,490,718 0 0
64K 128K 11,703 11,703 0 0
128K 256K 1,143 1,143 0 0
256K 512K 1,111 1,111 0 0
512K 1024K 171,686 171,686 0 0
1M 2M 395,102 395,102 0 0
2M 4M 70 70 0 0
4M 8M 23 21 2 0
8M 16M 18 18 0 0
32M 64M 8 8 0 0
64M 128M 6 6 0 0
128M 256M 2 2 0 0

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

PGA Target Est (MB) Size Factr W/A MB Processed Estd Extra W/A MB Read/ Written to Disk Estd PGA Cache Hit % Estd PGA Overalloc Count
2,560 0.13 802,803.12 8,272.22 99.00 1,066
5,120 0.25 802,803.12 8,215.38 99.00 1,031
10,240 0.50 802,803.12 8,109.95 99.00 981
15,360 0.75 802,803.12 7,983.47 99.00 935
20,480 1.00 802,803.12 0.00 100.00 889
24,576 1.20 802,803.12 0.00 100.00 843
28,672 1.40 802,803.12 0.00 100.00 771
32,768 1.60 802,803.12 0.00 100.00 549
36,864 1.80 802,803.12 0.00 100.00 132
40,960 2.00 802,803.12 0.00 100.00 0
61,440 3.00 802,803.12 0.00 100.00 0
81,920 4.00 802,803.12 0.00 100.00 0
122,880 6.00 802,803.12 0.00 100.00 0
163,840 8.00 802,803.12 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,248 0.49 298 13,068 2,259,661 1.00 4,692 4.89 176,879,241
1,504 0.59 519 16,186 2,262,665 1.00 1,688 1.76 177,099,106
1,760 0.70 774 19,895 2,263,286 1.00 1,067 1.11 177,147,292
2,016 0.80 1,028 23,972 2,263,386 1.00 967 1.01 177,155,562
2,272 0.90 1,220 30,216 2,263,393 1.00 960 1.00 177,156,320
2,528 1.00 1,336 33,858 2,263,393 1.00 960 1.00 177,156,366
2,784 1.10 1,378 35,252 2,263,393 1.00 960 1.00 177,156,377
3,040 1.20 1,378 35,252 2,263,393 1.00 960 1.00 177,156,377
3,296 1.30 1,378 35,252 2,263,393 1.00 960 1.00 177,156,377
3,552 1.41 1,378 35,252 2,263,393 1.00 960 1.00 177,156,377
3,808 1.51 1,378 35,252 2,263,393 1.00 960 1.00 177,156,377
4,064 1.61 1,378 35,252 2,263,393 1.00 960 1.00 177,156,377
4,320 1.71 1,378 35,252 2,263,393 1.00 960 1.00 177,156,377
4,576 1.81 1,378 35,252 2,263,393 1.00 960 1.00 177,156,377
4,832 1.91 1,378 35,252 2,263,393 1.00 960 1.00 177,156,377
5,088 2.01 1,378 35,252 2,263,393 1.00 960 1.00 177,156,377

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

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 233 1,047 1.00 960 1.00 19,778
32 0.50 13 233 1,047 1.00 960 1.00 19,778
48 0.75 13 233 1,047 1.00 960 1.00 19,778
64 1.00 13 233 1,047 1.00 960 1.00 19,778
80 1.25 13 233 1,047 1.00 960 1.00 19,778
96 1.50 13 233 1,047 1.00 960 1.00 19,778
112 1.75 13 233 1,047 1.00 960 1.00 19,778
128 2.00 13 233 1,047 1.00 960 1.00 19,778

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 434,111 89 0
undo header 59,802 4 0
undo block 189,730 4 0
1st level bmb 4,777 0 0
file header block 74 0 2
segment header 2,334 0 0
2nd level bmb 1,105 0 0
extent map 11 0 0
bitmap index block 1 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 68,195 67,174 1,021 2,398 40 16.87
TX-Transaction (index contention) 25,828 25,828 0 23,920 11 0.48
TX-Transaction (row lock contention) 6,877 596 6,281 579 7 11.81
RO-Multiple Object Reuse (fast object reuse) 288 288 0 32 6 186.25
TM-DML 2,003,657 2,003,607 0 7 6 844.29
HW-Segment High Water Mark 255,499 255,491 8 2,282 2 0.70
TX-Transaction 1,263,887 1,263,888 0 1,946 1 0.39
DV-Diana Versioning 29,401 29,401 0 170 1 3.82
SQ-Sequence Cache 41,170 41,170 0 2,925 1 0.20
CU-Cursor 8,763 8,763 0 5 0 24.00
FB-Format Block 36,326 36,326 0 491 0 0.06
TX-Transaction (allocate ITL entry) 107 107 0 53 0 0.57
PS-PX Process Reservation 1,864 1,544 320 34 0 0.29

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,578.31 1,258,882 2,635 345   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
14-Apr 11:11 212,263 173,698 611 342 221 0/0 0/0/0/0/0/0
14-Apr 11:01 52,901 117,949 465 335 230 0/0 0/0/0/0/0/0
14-Apr 10:51 467,299 192,649 2,635 339 214 0/0 0/0/0/0/0/0
14-Apr 10:41 335,682 252,183 1,841 345 285 0/0 0/0/0/0/0/0
14-Apr 10:31 305,725 363,368 1,830 343 387 0/0 0/0/0/0/0/0
14-Apr 10:21 204,437 159,035 2,155 344 668 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 306,257 0.00   0 0  
Consistent RBA 815,248 0.06 0.00 0 0  
FOB s.o list latch 53,822 0.01 0.00 0 0  
In memory undo latch 742,073,001 3.43 0.00 18 1,182,592 0.00
JOX SGA heap latch 1,922,416 0.00   0 0  
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 3,570 0.00   0 0  
KMG resize request state object freelist 20 0.00   0 0  
KTF sga latch 12 0.00   0 1,213 0.00
KWQMN job cache list latch 13,595 0.13 0.82 0 0  
MQL Tracking Latch 0     0 72 0.00
Memory Management Latch 2,543 0.00   0 3,560 0.00
OS process 14,118 0.00   0 0  
OS process allocation 10,641 0.00   0 0  
OS process: request allocation 9,164 0.00   0 0  
PL/SQL warning settings 4,259,207 0.00   0 0  
SGA IO buffer pool latch 51,920 0.41 0.00 0 54,087 0.25
SQL memory manager latch 1 0.00   0 1,199 0.00
SQL memory manager workarea list latch 6,704,056 0.00 0.00 0 0  
Shared B-Tree 129 0.00   0 0  
active checkpoint queue latch 1,059,514 0.27 0.00 0 2 0.00
active service list 45,330 0.07 0.00 0 1,275 0.00
begin backup scn array 153 0.00   0 0  
buffer pool 20 0.00   0 0  
cache buffer handles 20,176,607 1.18 0.00 0 0  
cache buffers chains 4,708,556,073 0.86 0.03 27 17,630,523 2.36
cache buffers lru chain 10,033,794 0.32 0.05 1 34,979,442 0.47
cache table scan latch 2,101 0.00   0 2,101 0.05
channel handle pool latch 374,404 0.10 0.01 0 0  
channel operations parent latch 1,640,908 0.41 0.00 0 0  
checkpoint queue latch 15,984,870 0.01 0.02 0 3,046,131 0.02
client/application info 1,633,121 0.00 0.00 0 0  
commit callback allocation 79,997 0.00   0 0  
compile environment latch 2,844,804 0.00   0 0  
dictionary lookup 78 0.00   0 0  
dml lock allocation 3,990,992 0.17 0.01 0 0  
dummy allocation 18,626 0.19 0.00 0 0  
enqueue hash chains 8,763,628 0.06 0.00 0 240 0.00
enqueues 4,931,937 0.10 0.01 0 0  
error message lists 816 1.10 0.00 0 0  
event group latch 4,596 0.00   0 0  
file cache latch 21,342 0.00 0.00 0 0  
global KZLD latch for mem in SGA 8,808 0.00   0 0  
global ctx hash table latch 22,044 0.00   0 0  
hash table column usage latch 2,392 0.00   0 14,000,284 0.00
hash table modification latch 144 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 121 0.00   0 0  
kks stats 28,605 0.00   0 0  
ksuosstats global area 242 0.00   0 0  
ktm global data 147,018 0.00   0 0  
kwqbsn:qsga 129 0.00   0 0  
lgwr LWN SCN 817,558 0.10 0.00 0 0  
library cache 327,151,416 0.35 0.01 6 21,046 0.61
library cache load lock 10,288 0.25 0.04 0 23 0.00
library cache lock 54,437,595 0.05 0.01 0 0  
library cache lock allocation 1,417,323 0.01 0.02 0 0  
library cache pin 203,869,757 0.11 0.01 1 37 0.00
library cache pin allocation 493,999 0.00 0.00 0 0  
list of block allocation 445,471 0.01 0.00 0 0  
loader state object freelist 290,754 0.00 0.00 0 0  
longop free list parent 33 0.00   0 33 0.00
message pool operations parent latch 380,144 0.01 0.10 0 0  
messages 5,404,051 0.25 0.01 0 0  
mostly latch-free SCN 861,378 3.85 0.00 0 0  
multiblock read objects 30,100 0.01 0.00 0 0  
ncodef allocation latch 170 0.00   0 0  
object queue header heap 3,101,027 0.03 0.22 0 359,955 0.07
object queue header operation 33,886,816 0.12 0.42 2 19,442 0.35
object stats modification 372,345 0.02 0.01 0 0  
parallel query alloc buffer 8,160 1.08 0.00 0 0  
parallel query stats 528 14.77 0.00 0 0  
parameter table allocation management 21,995 1.04 0.59 0 0  
post/wait queue 1,243,846 0.04 0.06 0 503,539 0.01
process allocation 9,212 0.11 0.60 0 4,593 0.07
process group creation 9,164 0.00   0 0  
process queue 5,030 1.01 0.00 0 0  
process queue reference 755,538 0.05 0.00 0 83,236 0.32
qmn task queue latch 516 0.00   0 0  
query server freelists 4,256 5.17 0.00 0 0  
query server process 8 0.00   0 8 0.00
redo allocation 5,251,559 1.80 0.01 0 100,465,300 1.72
redo copy 0     0 100,605,460 0.04
redo writing 3,901,574 0.11 0.01 0 0  
resmgr group change latch 774,630 0.00   0 0  
resmgr:actses active list 27,400 0.51 0.96 0 0  
resmgr:actses change group 26,806 0.00   0 0  
resmgr:free threads list 18,623 0.16 0.03 0 0  
resmgr:schema config 1 0.00   0 0  
row cache objects 116,082,482 0.19 0.00 1 6,568 0.15
rules engine aggregate statistics 37,918 0.00   0 0  
rules engine rule set statistics 122,262 0.00 0.00 0 0  
rules engine rule statistics 46,426 0.00   0 0  
sequence cache 16,196,335 0.42 0.00 0 0  
session allocation 18,541,578 0.40 0.01 0 0  
session idle bit 92,753,078 0.01 0.02 0 0  
session state list latch 53,795 0.10 0.74 0 0  
session switching 13,729 0.01 0.00 0 0  
session timer 1,275 0.00   0 0  
shared pool 7,736,577 0.15 0.06 0 0  
shared pool sim alloc 366 0.00   0 0  
shared pool simulator 2,118,809 0.00 0.00 0 0  
sim partition latch 1 0.00   0 22,518 0.11
simulator hash latch 2,460 0.00   0 0  
simulator lru latch 1,380 0.00   0 0  
slave class 1 0.00   0 0  
slave class create 4 0.00   0 0  
sort extent pool 1,291,578 0.10 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 276 0.00   0 0  
temporary table state object allocation 11,473 0.00   0 0  
threshold alerts latch 606 0.00   0 0  
trace latch 40 0.00   0 0  
transaction allocation 106,362 0.00 0.00 0 0  
transaction branch allocation 170 0.00   0 0  
undo global data 949,252,996 0.83 0.00 6 8,034 0.06
user lock 35,314 0.00 0.00 0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch Name Get Requests Misses Sleeps Spin Gets Sleep1 Sleep2 Sleep3
cache buffers chains 4,708,556,073 40,447,704 1,069,381 39,492,546 0 0 0
In memory undo latch 742,073,001 25,465,854 57,267 25,419,420 0 0 0
undo global data 949,252,996 7,847,869 7,635 7,841,300 0 0 0
library cache 327,151,416 1,147,748 9,289 1,139,375 0 0 0
cache buffer handles 20,176,607 237,348 222 237,154 0 0 0
library cache pin 203,869,757 234,188 2,432 231,984 0 0 0
row cache objects 116,082,482 222,703 835 221,925 0 0 0
redo allocation 5,251,559 94,508 968 93,629 0 0 0
session allocation 18,541,578 74,233 726 73,576 0 0 0
sequence cache 16,196,335 67,925 97 67,840 0 0 0
object queue header operation 33,886,816 42,272 17,776 26,046 0 0 0
mostly latch-free SCN 861,378 33,177 61 33,126 0 0 0
cache buffers lru chain 10,033,794 32,585 1,766 30,926 0 0 0
library cache lock 54,437,595 27,021 151 26,874 0 0 0
messages 5,404,051 13,642 133 13,511 0 0 0
shared pool 7,736,577 11,948 739 11,271 0 0 0
session idle bit 92,753,078 10,937 191 10,749 0 0 0
dml lock allocation 3,990,992 6,933 86 6,856 0 0 0
channel operations parent latch 1,640,908 6,781 9 6,772 0 0 0
enqueues 4,931,937 5,108 69 5,039 0 0 0
enqueue hash chains 8,763,628 5,021 23 5,000 0 0 0
redo writing 3,901,574 4,354 33 4,321 0 0 0
active checkpoint queue latch 1,059,514 2,856 6 2,850 0 0 0
checkpoint queue latch 15,984,870 1,949 30 1,920 0 0 0
sort extent pool 1,291,578 1,278 16 1,263 0 0 0
object queue header heap 3,101,027 897 198 723 0 0 0
lgwr LWN SCN 817,558 777 2 775 0 0 0
Consistent RBA 815,248 521 2 519 0 0 0
post/wait queue 1,243,846 472 29 443 0 0 0
channel handle pool latch 374,404 359 5 354 0 0 0
SQL memory manager workarea list latch 6,704,056 310 1 309 0 0 0
parameter table allocation management 21,995 228 134 116 0 0 0
resmgr:actses active list 27,400 141 136 6 0 0 0
object stats modification 372,345 86 1 85 0 0 0
library cache lock allocation 1,417,323 82 2 80 0 0 0
session state list latch 53,795 53 39 14 0 0 0
resmgr:free threads list 18,623 29 1 28 0 0 0
library cache load lock 10,288 26 1 25 0 0 0
message pool operations parent latch 380,144 20 2 18 0 0 0
KWQMN job cache list latch 13,595 17 14 3 0 0 0
process allocation 9,212 10 6 4 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 47,499 49,788
In memory undo latch ktiFlush: child 0 5,690 2,999
In memory undo latch kticmt: child 0 3,355 934
In memory undo latch ktichg: child 0 501 3,490
In memory undo latch ktiTxnPoolFree 0 204 0
In memory undo latch ktiBRacquire 0 9 0
In memory undo latch ktbgfc 0 7 54
KWQMN job cache list latch kwqmnuji: update job item 0 15 3
SQL memory manager workarea list latch qesmmIRegisterWorkArea 0 1 1
active checkpoint queue latch kcbbacq: scan active checkpoints 0 6 6
active service list kswssyis: find service entry 1 0 1 0
cache buffer handles kcbzgs 0 130 128
cache buffer handles kcbzfs 0 92 94
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 1,198,740 1,430,796
cache buffers chains kcbgtcr: fast path 0 578,921 25,780
cache buffers chains kcbchg: kslbegin: call CR func 0 357,727 848,135
cache buffers chains kcbzgb: scan from tail. nowait 0 116,513 0
cache buffers chains kcbgtcr: kslbegin excl 0 108,988 37,156
cache buffers chains kcbgcur: kslbegin 0 23,779 12,997
cache buffers chains kcbrls: kslbegin 0 21,048 53,393
cache buffers chains kcbget: pin buffer 0 18,423 7,674
cache buffers chains kcbzwb 0 5,815 5,768
cache buffers chains kcbcge 0 2,374 5,127
cache buffers chains kcbget: exchange rls 0 1,020 826
cache buffers chains kcbget: exchange 0 551 1,590
cache buffers chains kcbnlc 0 320 1,406
cache buffers chains kcbbxsv 0 186 187
cache buffers chains kcb_is_private 0 160 1,610
cache buffers chains kcbgtcr: kslbegin shared 0 79 68
cache buffers chains kcbnew: new latch again 0 62 6
cache buffers chains kcbesc: escalate 0 57 23
cache buffers chains kcbso1: set no access 0 19 25
cache buffers chains kcb_pre_apply: kcbhq61 0 16 1,697
cache buffers chains kcbbic2 0 10 2
cache buffers chains kcb_post_apply: kcbhq63 0 9 266
cache buffers chains kcbzib: multi-block read: nowait 0 2 0
cache buffers chains kcb_post_apply: kcbhq62 0 1 358
cache buffers chains kcbo_ivd_process 0 1 37
cache buffers chains kcbrlb1 0 1 2
cache buffers chains kcbw_next_free 0 1 0
cache buffers lru chain kcbzgws 0 996 0
cache buffers lru chain kcbbxsv: move to being written 0 349 608
cache buffers lru chain kcbgtcr:CR Scan:KCBRSKIP 0 144 0
cache buffers lru chain kcbo_link_q 0 124 18
cache buffers lru chain kcbzgb: posted for free bufs 0 77 491
cache buffers lru chain kcbo_ivd_proc 0 33 287
cache buffers lru chain kcbzswcu 0 20 83
cache buffers lru chain kcbbic2 0 12 251
cache buffers lru chain kcbzib 0 4 2
cache buffers lru chain kcbo_write_process:free_unlink 0 3 0
cache buffers lru chain kcbzfw 0 2 0
cache buffers lru chain kcbbwlru 0 1 23
cache buffers lru chain kcbzgpwb: KSLBEGIN use prewarm buffers 0 1 48
channel handle pool latch ksrchconnect() 0 11 3
channel operations parent latch ksrapublish() 0 7 1
channel operations parent latch ksrwait() 0 4 18
channel operations parent latch ksrchconnect() 0 3 5
channel operations parent latch ksrchdelete() 0 3 3
channel operations parent latch ksrsconsume() 0 2 3
channel operations parent latch ksrmfree() 0 1 1
checkpoint queue latch kcbbwthc: thread checkpoint buffers 0 21 5
checkpoint queue latch kcbklbc: Link buffer into ckpt queue 0 5 1
checkpoint queue latch kcbswcu: Switch buffers 0 3 13
checkpoint queue latch kcbkubc 0 1 11
dml lock allocation ktaiam 0 59 52
dml lock allocation ktaidm 0 27 34
enqueue hash chains ksqgtl3 0 15 14
enqueue hash chains ksqrcl 0 8 11
enqueues ksqgel: create enqueue 0 29 14
enqueues ksqies 0 26 48
enqueues ksqdel 0 14 7
lgwr LWN SCN kcs023 0 16 0
library cache kglpndl: child: after processing 0 3,603 138
library cache kglpnp: child 0 3,413 4,836
library cache kglobpn: child: 0 777 1,265
library cache kglpndl: child: before processing 0 534 2,385
library cache kglLockCursor 0 234 287
library cache kglScanDependency 0 164 0
library cache kgldte: child 0 0 97 177
library cache kglpin 0 93 34
library cache kglhdgn: child: 0 92 138
library cache kgldti: 2child 0 27 6
library cache kglic 0 11 0
library cache kglhdiv: child 0 4 0
library cache kglhdgc: child: 0 3 0
library cache kglupd: child 0 3 0
library cache kglivl: child 0 2 0
library cache load lock kglllal: llatch 0 1 0
library cache lock kgllkdl: child: cleanup 0 99 90
library cache lock kgllkdl: child: no lock handle 0 70 14
library cache lock kgllkal: child: multiinstance 0 52 59
library cache lock allocation kgllkget 0 2 2
library cache pin kglpndl 0 1,163 738
library cache pin kglpnp: child 0 1,104 1,336
library cache pin kglpnal: child: alloc space 0 165 358
message pool operations parent latch ksrmalloc() 0 1 2
message pool operations parent latch ksrmfree() 0 1 1
messages ksarcv 0 58 15
messages ksarcv: after wait 0 55 85
messages ksaamb: after wakeup 0 20 34
mostly latch-free SCN kcslcu3 0 45 63
mostly latch-free SCN kcs024 0 2 0
mostly latch-free SCN kcs01 0 1 2
mostly latch-free SCN kcsnew_scn_rba 0 1 0
object queue header heap kcbo_link_q:reget 0 192 4
object queue header heap kcbw_link_q:alloc 0 5 194
object queue header heap kcbw_unlink_q 0 1 0
object queue header operation kcbo_ivbo 0 17,605 4,163
object queue header operation kcbw_link_q 0 3,334 1,931
object queue header operation kcbw_unlink_q 0 1,006 5,983
object queue header operation kcbo_switch_mq_bg 0 585 2,698
object queue header operation kcbo_switch_q_bg 0 307 1,395
object queue header operation kcbo_switch_cq 0 108 2,944
object queue header operation kcbo_link_q:reget 0 53 125
object queue header operation kcbo_write_q 0 36 41
object queue header operation kcbo_service_ockpt 0 30 6
object queue header operation kcbo_swap_buf_bg 0 7 3,609
object queue header operation kcbo_swap_buf 0 6 495
object queue header operation kcbw_unlink_q_bg 0 1 17
object stats modification ksoslinelm 0 1 0
parameter table allocation management ksp_param_table_free 0 134 134
post/wait queue ksliwat:remove 0 28 28
post/wait queue ksliwat:add:nowait 0 1 0
process allocation ksucrp 0 6 0
redo allocation kcrfw_redo_gen: redo allocation 1 0 761 0
redo allocation kcrfw_redo_gen: redo allocation 3 0 138 600
redo allocation kcrfw_redo_gen: redo allocation 2 0 37 0
redo allocation kcrfw_redo_write: before write 0 17 157
redo allocation kcrfw_redo_write: more space 0 15 227
redo writing kcrfwcr 0 25 33
redo writing kcrfw_post: after write 0 4 0
redo writing kcrfw_post: rba scn pair 0 4 0
resmgr:actses active list kgskchclass 0 136 63
resmgr:free threads list kgskthrsod 0 1 0
row cache objects kqreqd: reget 0 603 9
row cache objects kqrpre: find obj 0 169 711
row cache objects kqreqd 0 60 115
row cache objects kqrso 0 2 0
sequence cache kdnssd 0 66 3
sequence cache kdnnxt: cached seq 0 25 1
sequence cache kdnss 0 6 95
session allocation ksuxds: KSUSFCLC not set 0 258 40
session allocation ksuprc 0 145 128
session allocation ksudlc 0 101 191
session allocation ksuxds: not user session 0 92 100
session allocation ksucri 0 75 214
session allocation kspallmod 0 16 0
session allocation ksursi 0 16 31
session allocation ksudlp 0 12 1
session allocation kxfpqidqr 0 5 14
session allocation kxfprdp 0 3 5
session allocation ksucrp 0 1 0
session idle bit ksupuc: set busy 0 120 122
session idle bit ksupuc: clear busy 0 87 97
session idle bit ksuxds 0 23 11
session state list latch kpseqd 0 39 0
shared pool kghupr1 0 411 543
shared pool kghalo 0 264 121
shared pool kghfrunp: clatch: nowait 0 158 0
shared pool kghfre 0 31 62
shared pool kghfrunp: alloc: wait 0 21 2
shared pool kghalp 0 9 11
shared pool kghfrunp: clatch: wait 0 5 5
shared pool kgh: sim resz update 0 2 0
shared pool kghfrh 0 1 0
sort extent pool ktstdt: dealloc sort extent 0 13 1
sort extent pool ktstdt: return extent 0 2 0
sort extent pool ktstallobj1 0 1 0
undo global data kturimugur: child 0 6,610 4,427
undo global data ktudba: KSLBEGIN 0 961 3,176
undo global data ktufrbs: child 0 20 19
undo global data ktucof: at start 0 17 0
undo global data ktudnx:child 0 11 9
undo global data ktubnd:child 0 10 0
undo global data ktusmasp: ktugd_tuux 0 6 4

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 63,563,872 3.18
INV APPS_TS_TX_IDX MTL_ITEM_CATEGORIES_U1   INDEX 50,444,432 2.52
ONT APPS_TS_TX_DATA OE_ORDER_LINES_ALL   TABLE 23,443,760 1.17
WSH APPS_TS_TX_DATA WSH_DELIVERY_DETAILS   TABLE 20,349,664 1.02
GL APPS_TS_TX_DATA GL_CODE_COMBINATIONS   TABLE 19,829,680 0.99

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,019 7.49
AR APPS_ASSM_DATA RA_CUSTOMER_TRX_LINES_ALL   TABLE 12,993 2.78
WSH APPS_TS_TX_DATA WSH_DELIVERY_DETAILS   TABLE 9,554 2.04
HR APPS_TS_TX_IDX PAY_PERSON_LATEST_BALA_N50   INDEX 4,777 1.02
HR APPS_ASSM_DATA PAY_RUN_RESULTS   TABLE 4,050 0.87

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 12,026 29.30
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_U1   INDEX 9,410 22.92
APPLSYS APPS_TS_TX_IDX WF_ITEM_ACTIVITY_STATUSES_N1   INDEX 9,249 22.53
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N6   INDEX 2,626 6.40
HR APPS_ASSM_IDX PAY_RUN_RESULT_VALUES_PK   INDEX 1,637 3.99

Back to Segment Statistics
Back to Top

Segments by ITL Waits

Owner Tablespace Name Object Name Subobject Name Obj. Type ITL Waits % of Capture
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N6   INDEX 16 31.37
APPLSYS APPS_TS_TX_IDX WF_ITEM_ATTRIBUTE_VALUES_PK   INDEX 10 19.61
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N5   INDEX 8 15.69
GL APPS_ASSM_IDX GL_IMPORT_REFERENCES_N1   INDEX 5 9.80
GL APPS_ASSM_IDX GL_JE_LINES_N1   INDEX 3 5.88

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 132,836 37.20
APPLSYS APPS_TS_TX_DATA WF_ITEM_ATTRIBUTE_VALUES   TABLE 66,174 18.53
SYS SYSTEM DBMS_LOCK_ALLOCATED   TABLE 20,405 5.71
AR APPS_TS_TX_INTERFACE RA_INTERFACE_LINES_ALL   TABLE 20,306 5.69
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N6   INDEX 16,296 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.22 0   648 0
dc_files 6,660 0.00 0   0 111
dc_global_oids 7,049,040 0.00 0   0 45
dc_histogram_data 61,580 1.65 0   0 612
dc_histogram_defs 382,438 2.96 0   4,044 2,308
dc_object_grants 65,592 0.08 0   0 76
dc_object_ids 11,391,685 0.02 0   58 1,079
dc_objects 166,032 1.15 0   347 783
dc_profiles 8,868 0.00 0   0 1
dc_rollback_segments 19,342 0.00 0   0 353
dc_segments 335,946 0.79 0   15,553 1,308
dc_sequences 51,203 0.14 0   51,203 112
dc_table_scns 19,381 0.04 0   0 5
dc_tablespace_quotas 15,416 0.16 0   214 41
dc_tablespaces 5,480,125 0.00 0   0 21
dc_usernames 466,538 0.00 0   0 19
dc_users 13,720,556 0.00 0   0 62
outstanding_alerts 268 15.30 0   1 42


Back to Top

 

Library Cache Activity

Namespace Get Requests Pct Miss Pin Requests Pct Miss Reloads Invali- dations
BODY 586,904 0.02 39,098,699 0.00 20 0
CLUSTER 118 0.85 283 1.41 3 0
INDEX 14,259 0.45 15,070 0.62 0 0
JAVA DATA 624 0.00 0   0 0
PIPE 45,627 2.55 67,182 1.73 0 0
SQL AREA 6,288 85.62 106,867,691 0.35 3,694 507
TABLE/PROCEDURE 373,943 0.26 53,424,127 0.01 1,145 0
TRIGGER 26,455 0.10 1,357,707 0.00 28 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 33,046.43   11.68 6.83 38 38 2,829 2,829
  Freeable 3,205.38 0.00 1.30 0.81 9   2,459 2,459
  SQL 3,095.43 1,582.78 1.10 0.70 4 21 2,821 2,819
  PL/SQL 2,118.31 171.49 0.75 0.95 3 3 2,829 2,829
  JAVA 241.80 240.87 2.24 0.33 5 8 108 108
E Other 40,079.78   14.02 8.54 40 40 2,858 2,858
  Freeable 3,888.56 0.00 1.52 0.94 9   2,559 2,559
  SQL 3,632.76 1,896.51 1.27 0.76 5 21 2,850 2,848
  PL/SQL 2,495.81 197.09 0.87 0.98 3 3 2,858 2,858
  JAVA 241.73 240.79 2.24 0.33 5 8 108 108

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions Begin Size (Bytes) End Size (Bytes) (if different)
Database Buffers 18,891,145,216 18,723,373,056
Fixed Size 2,111,120  
Redo Buffers 14,663,680  
Variable Size 2,566,916,464 2,734,688,624

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 32.94 34.01 3.25
shared KGLS heap 27.58   -100.00
shared KTI-UNDO 53.19 53.19 0.00
shared PL/SQL MPCODE 66.54 68.86 3.49
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 333.81 332.12 -0.51
shared library cache 760.55 914.53 20.25
shared parameter table block 52.47 52.72 0.46
shared private strands 99.77 99.77 0.00
shared sessions 36.42 36.42 0.00
shared sql area 306.64 323.93 5.64
shared trace buffer 44.31 44.91 1.34
  buffer_cache 18,016.00 17,856.00 -0.89
  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