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-Oct-08 10:33:20 4772 211.1
End Snap: 2 16-Oct-08 11:33:24 4785 232.3
Elapsed:   60.08 (mins)    
DB Time:   366.38 (mins)    

 

Report Summary

Cache Sizes

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

Load Profile

  Per Second Per Transaction
Redo size: 8,767,171.70 27,306.06
Logical reads: 569,125.26 1,772.59
Block changes: 54,433.87 169.54
Physical reads: 119.95 0.37
Physical writes: 856.37 2.67
User calls: 12,472.57 38.85
Parses: 2,348.08 7.31
Hard parses: 2.42 0.01
Sorts: 2,840.43 8.85
Logons: 2.58 0.01
Executes: 27,148.93 84.56
Transactions: 321.07  

% Blocks changed per Read: 9.56 Recursive Call %: 77.90
Rollback per transaction %: 20.64 Rows per Sort: 12.42

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.77 Soft Parse %: 99.90
Execute to Parse %: 91.35 Latch Hit %: 98.95
Parse CPU to Parse Elapsd %: 90.81 % Non-Parse CPU: 97.62

Shared Pool Statistics

  Begin End
Memory Usage %: 86.48 86.93
% SQL with executions>1: 90.27 91.02
% Memory for SQL w/exec>1: 69.81 69.74

Top 5 Timed Events

Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class
CPU time   19,910   90.6  
db file sequential read 269,711 1,108 4 5.0 User I/O
log file sync 507,337 963 2 4.4 Commit
log file parallel write 800,946 481 1 2.2 System I/O
db file parallel write 248,677 210 1 1.0 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 19,910.18 90.57
sql execute elapsed time 18,600.26 84.61
PL/SQL execution elapsed time 4,407.06 20.05
inbound PL/SQL rpc elapsed time 4,189.07 19.06
parse time elapsed 586.17 2.67
Java execution elapsed time 499.27 2.27
hard parse elapsed time 299.65 1.36
repeated bind elapsed time 79.41 0.36
sequence load elapsed time 13.42 0.06
connection management call elapsed time 9.74 0.04
PL/SQL compilation elapsed time 6.97 0.03
hard parse (sharing criteria) elapsed time 3.87 0.02
failed parse elapsed time 1.34 0.01
hard parse (bind mismatch) elapsed time 1.26 0.01
DB time 21,983.04  
background elapsed time 1,142.46  
background cpu time 362.85  

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 320,637 0.00 1,252 4 0.28
Commit 507,337 0.00 963 2 0.44
System I/O 1,080,516 0.00 702 1 0.93
Network 51,327,747 0.00 196 0 44.35
Concurrency 1,740,262 0.22 136 0 1.50
Application 63,697 0.03 101 2 0.06
Other 142,719 18.17 44 0 0.12
Configuration 7,938 0.00 13 2 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 269,711 0.00 1,108 4 0.23
log file sync 507,337 0.00 963 2 0.44
log file parallel write 800,946 0.00 481 1 0.69
db file parallel write 248,677 0.00 210 1 0.21
SQL*Net more data from client 2,331,935 0.00 134 0 2.01
db file scattered read 12,096 0.00 77 6 0.01
read by other session 36,205 0.00 65 2 0.03
enq: TX - row lock contention 623 2.89 57 92 0.00
SQL*Net message to client 47,091,381 0.00 47 0 40.69
cursor: pin S wait on X 4,256 91.45 42 10 0.00
latch: cache buffers chains 994,377 0.00 28 0 0.86
enq: UL - contention 2,167 0.18 24 11 0.00
buffer busy waits 673,513 0.00 21 0 0.58
SQL*Net more data to client 1,904,431 0.00 16 0 1.65
library cache load lock 595 0.00 15 25 0.00
enq: TX - index contention 28,368 0.00 12 0 0.02
PX Deq Credit: send blkd 22,189 0.00 12 1 0.02
SQL*Net break/reset to client 60,880 0.00 11 0 0.05
log buffer space 640 0.00 10 16 0.00
control file sequential read 29,154 0.00 9 0 0.03
enq: RO - fast object reuse 26 0.00 9 345 0.00
latch: undo global data 20,260 0.00 8 0 0.02
rdbms ipc reply 5 60.00 8 1570 0.00
latch: library cache 10,115 0.00 6 1 0.01
latch: In memory undo latch 20,100 0.00 6 0 0.02
kksfbc child completion 65 81.54 3 41 0.00
PX Deq: Signal ACK 259 34.36 3 10 0.00
LGWR wait for redo copy 31,428 0.00 2 0 0.03
latch: object queue header operation 17,842 0.00 2 0 0.02
enq: HW - contention 2,560 0.00 2 1 0.00
os thread startup 70 0.00 2 30 0.00
local write wait 1,401 0.00 2 1 0.00
latch: library cache pin 2,717 0.00 1 1 0.00
control file parallel write 1,739 0.00 1 1 0.00
latch: cache buffers lru chain 1,442 0.00 1 1 0.00
enq: TX - contention 2,881 0.00 1 0 0.00
buffer deadlock 25,792 98.77 1 0 0.02
enq: SQ - contention 4,598 0.00 1 0 0.00
enq: DV - contention 151 0.00 1 4 0.00
latch: row cache objects 823 0.00 1 1 0.00
direct path read 732 0.00 1 1 0.00
wait list latch free 49 0.00 1 11 0.00
latch: redo allocation 1,156 0.00 1 0 0.00
latch free 876 0.00 1 1 0.00
latch: session allocation 694 0.00 1 1 0.00
library cache pin 1,739 0.00 0 0 0.00
row cache lock 2,493 0.00 0 0 0.00
enq: TM - contention 1 0.00 0 304 0.00
SGA: allocation forcing component growth 22 40.91 0 9 0.00
latch: shared pool 627 0.00 0 0 0.00
enq: TX - allocate ITL entry 94 0.00 0 1 0.00
cursor: pin S 15,935 0.00 0 0 0.01
latch: library cache lock 153 0.00 0 1 0.00
latch: cache buffer handles 275 0.00 0 0 0.00
latch: object queue header heap 159 0.00 0 1 0.00
enq: FB - contention 636 0.00 0 0 0.00
PX qref latch 386 80.05 0 0 0.00
reliable message 27 0.00 0 1 0.00
latch: enqueue hash chains 15 0.00 0 1 0.00
latch: messages 101 0.00 0 0 0.00
library cache lock 1 0.00 0 20 0.00
cursor: mutex S 138 0.00 0 0 0.00
cursor: pin X 1 100.00 0 10 0.00
direct path write 434 0.00 0 0 0.00
write complete waits 8 0.00 0 1 0.00
enq: PS - contention 48 0.00 0 0 0.00
latch: redo writing 38 0.00 0 0 0.00
latch: checkpoint queue latch 21 0.00 0 0 0.00
enq: CU - contention 1 0.00 0 1 0.00
cursor: mutex X 177 0.00 0 0 0.00
direct path write temp 45 0.00 0 0 0.00
kkdlgon 2 0.00 0 0 0.00
direct path read temp 13 0.00 0 0 0.00
L1 validation 1 0.00 0 0 0.00
SQL*Net message from client 47,091,385 0.00 9,132,843 194 40.69
pipe get 26,876 16.63 21,050 783 0.02
Streams AQ: waiting for time management or cleanup tasks 2,731 39.51 3,507 1284 0.00
Streams AQ: qmn slave idle wait 129 0.00 3,501 27136 0.00
Streams AQ: qmn coordinator idle wait 258 50.00 3,501 13568 0.00
PX Idle Wait 1,616 75.74 2,540 1572 0.00
PL/SQL lock timer 222 99.55 2,482 11179 0.00
jobq slave wait 612 99.84 1,793 2929 0.00
PX Deq: Execution Msg 5,160 0.00 37 7 0.00
PX Deq: Execute Reply 2,692 0.00 3 1 0.00
PX Deq Credit: need buffer 4,948 0.00 1 0 0.00
PX Deq: Msg Fragment 4,387 0.00 1 0 0.00
PX Deq: Table Q Normal 6,886 0.00 0 0 0.01
PX Deq: Parse Reply 239 0.00 0 1 0.00
PX Deq: Join ACK 263 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 800,954 0.00 481 1 0.69
db file parallel write 248,677 0.00 210 1 0.21
events in waitclass Other 38,204 0.00 4 0 0.03
control file sequential read 827 0.00 3 4 0.00
os thread startup 62 0.00 2 31 0.00
db file scattered read 475 0.00 2 4 0.00
control file parallel write 1,739 0.00 1 1 0.00
db file sequential read 191 0.00 1 3 0.00
direct path read 732 0.00 1 1 0.00
latch: cache buffers chains 54 0.00 0 1 0.00
direct path write 333 0.00 0 0 0.00
latch: library cache 3 0.00 0 2 0.00
latch: redo writing 38 0.00 0 0 0.00
log buffer space 1 0.00 0 2 0.00
latch: shared pool 5 0.00 0 0 0.00
log file sync 1 0.00 0 0 0.00
latch: In memory undo latch 1 0.00 0 0 0.00
buffer busy waits 5 0.00 0 0 0.00
rdbms ipc message 1,374,943 0.90 36,254 26 1.19
pmon timer 1,308 92.81 3,511 2685 0.00
Streams AQ: waiting for time management or cleanup tasks 2,731 39.51 3,507 1284 0.00
smon timer 145,935 0.00 3,503 24 0.13
Streams AQ: qmn slave idle wait 129 0.00 3,501 27136 0.00
Streams AQ: qmn coordinator idle wait 258 50.00 3,501 13568 0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic Total
BUSY_TIME 2,139,075
IDLE_TIME 3,628,680
IOWAIT_TIME 82,372
NICE_TIME 0
SYS_TIME 95,151
USER_TIME 1,983,661
LOAD 5
RSRC_MGR_CPU_WAIT_TIME 0
PHYSICAL_MEMORY_BYTES 53,646,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 21,976.70 19,905.40 417,342 2,047,897,991
SYS$BACKGROUND 0.00 0.00 14,932 3,429,085
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 318897 124921 1740121 13455 0 0 51312159 19599
SYS$BACKGROUND 1736 304 130 194 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
748 735 305 2.45 3.40 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
437 391 101,472 0.00 1.99 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
365 362 56,484 0.01 1.66 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
363 335 182,479 0.00 1.65 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
349 346 56,502 0.01 1.59 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...
322 319 56,505 0.01 1.46 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
320 311 1,301 0.25 1.45 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
319 315 63,130 0.01 1.45 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
308 306 336,885 0.00 1.40 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
249 224 240,062 0.00 1.13 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
233 148 19,471 0.01 1.06 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
735 748 305 2.41 3.40 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
391 437 101,472 0.00 1.99 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
362 365 56,484 0.01 1.66 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
346 349 56,502 0.01 1.59 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...
335 363 182,479 0.00 1.65 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
319 322 56,505 0.01 1.46 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
315 319 63,130 0.00 1.45 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
311 320 1,301 0.24 1.45 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
306 308 336,885 0.00 1.40 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
224 249 240,062 0.00 1.13 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
148 233 19,471 0.01 1.06 1q78dwnrrkf6c asn.lead.server.LeadUwqAM BEGIN ASN_SALES_PVT.Lead_Proce...

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
68,714,682 182,479 376.56 3.35 335.01 362.84 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
66,724,536 240,062 277.95 3.25 224.06 249.03 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
50,249,385 156,485 321.11 2.45 137.44 138.41 5kqw5535fjvw6 ARXTWMAI SELECT NVL(RCTT.ATTRIBUTE10, ...
43,982,297 56,484 778.67 2.14 362.16 365.17 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
43,568,167 305 142,846.45 2.12 735.19 748.25 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
36,928,789 56,505 653.55 1.80 319.13 321.87 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
32,601,263 63,130 516.41 1.59 314.90 318.84 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
30,585,488 171,724 178.11 1.49 169.61 172.35 3b3psftuyks81 INVTTMTX BEGIN INV_TXNSTUB_PUB.postTran...
30,577,553 171,707 178.08 1.49 158.62 161.27 gf1u933c95jb5 INVTTMTX DECLARE l_ret_stat varchar2...
29,538,555 1,516,939 19.47 1.44 111.17 112.34 66tmsr3446uqn ap.oie.server.WebExpensesAM SELECT WIAS.ACTIVITY_STATUS, ...
27,624,862 1,301 21,233.56 1.35 311.41 319.75 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
26,870,165 56,502 475.56 1.31 345.88 348.68 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...
26,399,407 10,000 2,639.94 1.29 82.59 170.61 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...

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 10.46 82.59 170.61 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
35,086 2,171 16.16 8.11 13.22 175.15 3dssuqfjsynrk asn.lead.server.LeadUwqAM SELECT count(1) FROM (SELECT *...
29,080 2,171 13.39 6.73 101.39 219.58 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
21,997 19,471 1.13 5.09 148.35 232.99 1q78dwnrrkf6c asn.lead.server.LeadUwqAM BEGIN ASN_SALES_PVT.Lead_Proce...
12,414 240,062 0.05 2.87 224.06 249.03 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
10,178 648 15.71 2.35 77.93 117.78 dk0sqcvc2xjvs qotSCopHdrUpd.jsp BEGIN ASO_QUOTE_PUB_W.Create_Q...
8,653 6,488 1.33 2.00 106.12 145.09 8jb36w62w5hqf ibuSRDetailsActions.jsp BEGIN IBU_REQ_PKG.UpdateServic...
8,623 182,479 0.05 1.99 335.01 362.84 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
4,590 10,000 0.46 1.06 127.08 138.83 csvvv0fmhr1yc PYUSLV BEGIN FFP1893_01010001.FORMULA...
4,508 10,000 0.45 1.04 104.79 114.35 63t8zpm02skgh PYUSLV SELECT DECODE(COUNT(PRR.RUN_RE...

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,516,939 784,359 0.52 0.00 0.00 66tmsr3446uqn ap.oie.server.WebExpensesAM SELECT WIAS.ACTIVITY_STATUS, ...
859,720 859,721 1.00 0.00 0.00 cd9mbmqyf4qhp ap.oie.server.WebExpensesAM UPDATE WF_ITEM_ACTIVITY_STATUS...
537,727 537,720 1.00 0.00 0.00 avc1jqzz04wpr JDBC Thin Client SELECT 'x' FROM DUAL
336,885 336,883 1.00 0.00 0.00 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
315,625 242,505 0.77 0.00 0.00 fmfdkztk8vx23   SELECT CATEGORY, SEVERITY, F...
261,992 4,453,769 17.00 0.00 0.00 cwyx16zn1hpfb JDBC Thin Client select parameter, value from ...
240,062 0 0.00 0.00 0.00 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
182,479 182,478 1.00 0.00 0.00 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
171,724 171,724 1.00 0.00 0.00 3b3psftuyks81 INVTTMTX BEGIN INV_TXNSTUB_PUB.postTran...
171,722 171,721 1.00 0.00 0.00 6gnth2mfbs2nq INVTTMTX declare v_ret number := 0...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse Calls Executions % Total Parses SQL Id SQL Module SQL Text
537,727 537,727 6.35 avc1jqzz04wpr JDBC Thin Client SELECT 'x' FROM DUAL
336,884 336,885 3.98 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
315,620 315,625 3.73 fmfdkztk8vx23   SELECT CATEGORY, SEVERITY, F...
261,992 261,992 3.10 cwyx16zn1hpfb JDBC Thin Client select parameter, value from ...
182,478 182,479 2.16 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
171,725 171,722 2.03 6gnth2mfbs2nq INVTTMTX declare v_ret number := 0...
122,755 122,753 1.45 fb13x9qx0ftks OEXOETEL begin OE_STANDARD_WF.OEOL_SELE...
115,240 115,238 1.36 1c0b7sas42w2z INVTTMTX SELECT NVL(ITEM_COST, 0), ...
108,334 108,335 1.28 162ttnv4ubqun OEXOETEL begin OE_DS_PVT.Check_PO_Appr...
100,210 100,210 1.18 8camsgjsr9zya OEXOETEL begin OE_TRANSACTION_TYPES_PK...
97,205 97,203 1.15 76sw2a4vnc89j icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.S...
91,800 91,798 1.08 608c0n36kaw62 icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.C...
91,800 91,800 1.08 bf7uwg5pa3pj6 icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.V...
91,800 97,204 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;
25wzrzwd46a44 SELECT 1 FROM DUAL WHERE EXISTS ( SELECT 1 FROM FND_GRANTS G, WF_USER_ROLES R WHERE G.GRANTEE_KEY = R.ROLE_NAME AND R.USER_NAME IN (SELECT INCRNS.NAME FROM WF_LOCAL_ROLES SRC , WF_LOCAL_ROLES INCRNS WHERE SRC.NAME = :B4 AND SRC.PARENT_ORIG_SYSTEM = INCRNS.PARENT_ORIG_SYSTEM AND SRC.PARENT_ORIG_SYSTEM_ID = INCRNS.PARENT_ORIG_SYSTEM_ID) AND G.OBJECT_ID = :B3 AND ((:B2 = -1) OR (G.MENU_ID IN (SELECT CMF.MENU_ID FROM FND_COMPILED_MENU_FUNCTIONS CMF WHERE CMF.FUNCTION_ID = :B2 ))) AND ( G.CTX_SECGRP_ID = -1 OR G.CTX_SECGRP_ID = SYS_CONTEXT('FND', 'SECURITY_GROUP_ID')) AND ( G.CTX_RESP_ID = -1 OR G.CTX_RESP_ID = SYS_CONTEXT('FND', 'RESP_ID')) AND ( G.CTX_RESP_APPL_ID = -1 OR G.CTX_RESP_APPL_ID = SYS_CONTEXT('FND', 'RESP_APPL_ID')) AND ( G.CTX_ORG_ID = -1 OR G.CTX_ORG_ID = SYS_CONTEXT('FND', 'ORG_ID')) AND G.START_DATE <= SYSDATE AND ( G.END_DATE IS NULL OR G.END_DATE >= SYSDATE ) AND G.INSTANCE_TYPE = :B1 )
3b3psftuyks81 BEGIN INV_TXNSTUB_PUB.postTransaction(:1, :2, :3); END;
3dssuqfjsynrk SELECT count(1) FROM (SELECT * FROM ( SELECT LeadEO.sales_lead_id as SalesLeadId , to_char(hz_timezone_pub.convert_datetime(:1, hcp.timezone_id, SYSDATE), 'HH:MI AM ') ||' '||ht.standard_time_short_code as PrimaryContactLocalTime , SUBSTRB(LeadEO.description, 1, 240) as Description , hp.party_name as ContactName , custParty.party_name as CustomerName , aslt.meaning as RankName , ast.meaning as LeadStatus , ROUND(SYSDATE - LeadEO.creation_date) as Age , DECODE(LeadEO.status_code, 'CONVERTED_TO_OPPORTUNITY', 'ASNCnvToOpptyDsbld', 'ASNCnvToOpptyEnbld') as ASNLeadLstCnvToOppty , LeadEO.customer_id , hp.party_id , LeadEO.primary_contact_party_id , hr.relationship_id FROM as_sales_leads LeadEO , ( SELECT /*+ no_merge */ distinct aaa.sales_lead_id, aaa.customer_id FROM as_accesses_all aaa WHERE aaa.sales_lead_id IS NOT NULL AND aaa.lead_id IS NULL AND aaa.salesforce_id = :2) secu , as_statuses_tl ast , as_sales_lead_ranks_tl aslt , hz_parties CustParty , hz_parties hp, hz_relationships hr , hz_contact_points hcp , hz_timezones ht , ams_source_codes amsc WHERE LeadEO.sales_lead_id = secu.sales_lead_id AND LeadEO.customer_id = secu.customer_id AND LeadEO.status_code = ast.status_code AND ast.language = USERENV('LANG') AND LeadEO.lead_rank_id = aslt.rank_id (+) AND aslt.language (+) = USERENV('LANG') AND LeadEO.customer_id = CustParty.party_id AND LeadEO.primary_contact_party_id = hr.party_id(+) AND hr.subject_ id = hp.party_id (+) AND hr.subject_table_name (+) = 'HZ_PARTIES' AND hr.object_id(+) = LeadEO.customer_id AND hr.object_table_name (+) = 'HZ_PARTIES' AND LeadEO.primary_contact_party_id = hcp.owner_table_id(+) AND hcp.owner_table_name (+) = 'HZ_PARTIES' AND hcp.primary_flag (+) = 'Y' AND hcp.contact_point_type (+) = 'PHONE' AND hcp.timezone_id = ht.timezone_id (+) AND LeadEO.source_promotion_id = amsc.source_code_id AND amsc.source_code_for_id = :3 AND LeadEO.status_code = :4 ORDER BY age ) )
4yak7x2zqz0dh BEGIN inv_transfer_order_pvt.finalize_pick_confirm(:1, :2, :3, :4, :5, :6, :7); END;
5kqw5535fjvw6 SELECT NVL(RCTT.ATTRIBUTE10, ' ') FROM RA_CUST_TRX_TYPES_ALL RCTT, RA_CUSTOMER_TRX_ALL RCT WHERE RCT.CUSTOMER_TRX_ID = :B1 AND RCT.CUST_TRX_TYPE_ID = RCTT.CUST_TRX_TYPE_ID
608c0n36kaw62 begin FND_FLEX_WORKFLOW_APIS.COPY_FROM_COMBINATION (:v1, :v2, :v3, :v4, :v5); end;
63t8zpm02skgh SELECT DECODE(COUNT(PRR.RUN_RESULT_ID), 0, 'N', 'Y') FROM PAY_RUN_RESULTS PRR, PAY_ASSIGNMENT_ACTIONS ASA, PAY_PAYROLL_ACTIONS PPA WHERE PRR.SOURCE_ID = :B3 AND PRR.SOURCE_TYPE IN ('E', 'I') AND PRR.STATUS IN ('P', 'PA', 'R', 'O') AND ASA.ASSIGNMENT_ACTION_ID = PRR.ASSIGNMENT_ACTION_ID AND PPA.PAYROLL_ACTION_ID = ASA.PAYROLL_ACTION_ID AND NOT EXISTS (SELECT NULL FROM PAY_RUN_RESULTS PRR2 WHERE PRR2.SOURCE_ID = PRR.RUN_RESULT_ID AND PRR2.SOURCE_TYPE IN ('R', 'V')) AND PPA.DATE_EARNED BETWEEN :B2 AND :B1
64qc329wgjv39 select /*+ ORDERED INDEX(ASSBAL PAY_ASSIGNMENT_LATEST_BALA_N1) INDEX(DEFBAL PAY_DEFINED_BALANCES_PK) INDEX(ACT PAY_ASSIGNMENT_ACTIONS_PK) INDEX(PACT PAY_PAYROLL_ACTIONS_PK) INDEX(VALUE PAY_BALANCE_CONTEXT_VALUES_PK) USE_NL(ASSBAL DEFBAL ACT PACT VALUE) +*/ ASSBAL.defined_balance_id , DEFBAL.balance_dimension_id , to_char(ASSBAL.value) , ASSBAL.latest_balance_id , ASSBAL.rowid , to_char(ASSBAL.assignment_action_id) , ACT.payroll_action_id , to_char(PACT.effective_date, :b0) , to_number(to_char(PACT.effective_date, 'J')) , nvl(VALUE.context_id, 0) , nvl(VALUE.value, 'NULL') , to_char(ASSBAL.expired_assignment_action_id) , to_char(ASSBAL.expired_value) , to_char(ASSBAL.prev_assignment_action_id) , to_char(ASSBAL.prev_balance_value) from pay_assignment_latest_balances ASSBAL , pay_defined_balances DEFBAL , pay_assignment_actions ACT , pay_payroll_actions PACT , pay_balance_context_values VALUE where ((((ASSBAL.assignment_id=:b1 and ACT.assignment_action_id=ASSBAL.assignment_action_id) and PACT.payroll_action_id=ACT.payroll_action_id) and DEFBAL.defined_balance_id=ASSBAL.defined_balance_id) and VALUE.latest_balance_id(+)=ASSBAL.latest_balance_id) union all select /*+ ORDERED INDEX(PERBAL PAY_PERSON_LATEST_BALANCES_N2) INDEX(DEFBAL PAY_DEFINED_BALANCES_PK) INDEX(ACT PAY_ASSIGNMENT_ACTIONS_PK) INDEX(VALUE PAY_BALANCE_CONTEXT_VALUES_PK) INDEX(PACT PAY_PAYROLL_ACTIONS_PK) USE_NL(PERBAL DEFBAL ACT PACT VALUE) +*/ PERBAL.defined_balance_id , DEFBAL.balance_dimension_id , to_char (PERBAL.value) , PERBAL.latest_balance_id , PERBAL.rowid , to_char(PERBAL.assignment_action_id) , ACT.payroll_action_id , to_char(PACT.effective_date, :b0) , to_number(to_char(PACT.effective_date, 'J')) , nvl(VALUE.context_id, 0) , nvl(VALUE.value, 'NULL') , to_char(PERBAL.expired_assignment_action_id) , to_char(PERBAL.expired_value) , to_char(PERBAL.prev_assignment_action_id) , to_char(PERBAL.prev_balance_value) from pay_person_latest_balances PERBAL , pay_defined_balances DEFBAL , pay_assignment_actions ACT , pay_payroll_actions PACT , pay_balance_context_values VALUE where ((((PERBAL.person_id=:b3 and ACT.assignment_action_id=PERBAL.assignment_action_id) and PACT.payroll_action_id=ACT.payroll_action_id) and DEFBAL.defined_balance_id=PERBAL.defined_balance_id) and VALUE.latest_balance_id(+)=PERBAL.latest_balance_id) order by 6, 2, 1, 4, 10 desc
66tmsr3446uqn SELECT WIAS.ACTIVITY_STATUS, WIAS.ACTIVITY_RESULT_CODE, WIAS.ASSIGNED_USER, WIAS.NOTIFICATION_ID, WIAS.BEGIN_DATE, WIAS.END_DATE, WIAS.DUE_DATE, WIAS.ERROR_NAME, WIAS.ERROR_MESSAGE, WIAS.ERROR_STACK FROM WF_ITEM_ACTIVITY_STATUSES WIAS WHERE WIAS.ITEM_TYPE = :B3 AND WIAS.ITEM_KEY = :B2 AND WIAS.PROCESS_ACTIVITY = :B1
6gnth2mfbs2nq declare v_ret number := 0; begin if (INV_TABLE_LOCK_PVT.lock_onhand_records(:1, :2, :3, :4, :5, :6, :7) ) then v_ret := 1; end if; :8 := v_ret; end;
6h2tpcxpymqu7 BEGIN :1 := FND_AOLJ_UTIL.is_Valid_ICX(:2, NULL, 'Y', TRUE, TRUE, NULL, NULL, NULL, NULL, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, TRUE);:19 := fnd_session_management.g_enc_key;:20 := fnd_session_management.g_mac_key;END;
76sw2a4vnc89j begin FND_FLEX_WORKFLOW_APIS.START_GENERATION (:v1, :v2, :v3, :v4, :v5); end;
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;
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,965,774 545.36 1.70
CPU used when call started 1,961,714 544.23 1.70
CR blocks created 15,894,470 4,409.53 13.73
Cached Commit SCN referenced 47,595 13.20 0.04
Commit SCN cached 8 0.00 0.00
DB time 4,924,908 1,366.29 4.26
DBWR checkpoint buffers written 3,001,107 832.58 2.59
DBWR checkpoints 28 0.01 0.00
DBWR object drop buffers written 55,947 15.52 0.05
DBWR revisited being-written buffer 366 0.10 0.00
DBWR thread checkpoint buffers written 507,367 140.76 0.44
DBWR transaction table writes 2,255 0.63 0.00
DBWR undo block writes 1,590,451 441.23 1.37
DFO trees parallelized 48 0.01 0.00
IMU CR rollbacks 38,052,751 10,556.79 32.88
IMU Flushes 339,334 94.14 0.29
IMU Redo allocation size 2,270,627,088 629,929.04 1,961.96
IMU commits 598,505 166.04 0.52
IMU contention 38,307 10.63 0.03
IMU ktichg flush 10,458 2.90 0.01
IMU pool not allocated 0 0.00 0.00
IMU recursive-transaction flush 1,608 0.45 0.00
IMU undo allocation size 5,340,877,000 1,481,693.55 4,614.85
IMU- failed to get a private strand 0 0.00 0.00
PX local messages recv'd 52,834 14.66 0.05
PX local messages sent 52,834 14.66 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 47,088,245 13,063.46 40.69
active txn count during cleanout 126,907,114 35,207.22 109.66
application wait time 10,129 2.81 0.01
background checkpoints completed 3 0.00 0.00
background checkpoints started 2 0.00 0.00
background timeouts 13,899 3.86 0.01
branch node splits 1,057 0.29 0.00
buffer is not pinned count 603,511,760 167,429.33 521.47
buffer is pinned count 1,541,178,847 427,561.76 1,331.68
bytes received via SQL*Net from client 10,344,980,308 2,869,957.61 8,938.71
bytes sent via SQL*Net to client 9,464,969,237 2,625,820.41 8,178.33
calls to get snapshot scn: kcmgss 109,737,154 30,443.85 94.82
calls to kcmgas 19,967,410 5,539.46 17.25
calls to kcmgcs 15,632,591 4,336.87 13.51
change write time 44,749 12.41 0.04
cleanout - number of ktugct calls 29,733,177 8,248.73 25.69
cleanouts and rollbacks - consistent read gets 13,705,069 3,802.13 11.84
cleanouts only - consistent read gets 153,340 42.54 0.13
cluster key scan block gets 851,485 236.22 0.74
cluster key scans 235,909 65.45 0.20
commit batch/immediate performed 4,215 1.17 0.00
commit batch/immediate requested 4,215 1.17 0.00
commit cleanout failures: block lost 244,873 67.93 0.21
commit cleanout failures: buffer being written 2,087 0.58 0.00
commit cleanout failures: callback failure 108,607 30.13 0.09
commit cleanout failures: cannot pin 33,760 9.37 0.03
commit cleanouts 9,185,046 2,548.16 7.94
commit cleanouts successfully completed 8,795,719 2,440.15 7.60
commit immediate performed 4,215 1.17 0.00
commit immediate requested 4,215 1.17 0.00
commit txn count during cleanout 1,368,302 379.60 1.18
concurrency wait time 13,650 3.79 0.01
consistent changes 767,692,248 212,977.13 663.33
consistent gets 1,826,438,897 506,700.07 1,578.16
consistent gets - examination 1,273,510,546 353,303.84 1,100.39
consistent gets from cache 1,826,439,009 506,700.10 1,578.16
cursor authentications 2,124 0.59 0.00
data blocks consistent reads - undo records applied 763,749,019 211,883.18 659.93
db block changes 196,211,039 54,433.87 169.54
db block gets 225,017,914 62,425.63 194.43
db block gets direct 4,267 1.18 0.00
db block gets from cache 225,013,647 62,424.44 194.43
deferred (CURRENT) block cleanout applications 1,571,040 435.85 1.36
dirty buffers inspected 8,857 2.46 0.01
doubling up with imu segment 0 0.00 0.00
enqueue conversions 9,692 2.69 0.01
enqueue releases 4,348,462 1,206.37 3.76
enqueue requests 4,357,451 1,208.87 3.77
enqueue timeouts 8,912 2.47 0.01
enqueue waits 35,202 9.77 0.03
exchange deadlocks 25,793 7.16 0.02
execute count 97,860,385 27,148.93 84.56
failed probes on index block reclamation 12,150 3.37 0.01
frame signature mismatch 240 0.07 0.00
free buffer inspected 3,076,533 853.51 2.66
free buffer requested 20,314,645 5,635.79 17.55
heap block compress 30,577,992 8,483.10 26.42
hot buffers moved to head of LRU 1,314,006 364.54 1.14
immediate (CR) block cleanout applications 13,858,419 3,844.67 11.97
immediate (CURRENT) block cleanout applications 1,115,176 309.38 0.96
index crx upgrade (found) 22,541 6.25 0.02
index crx upgrade (positioned) 9,760,254 2,707.74 8.43
index fast full scans (rowid ranges) 824 0.23 0.00
index fetch by key 182,071,431 50,511.19 157.32
index scans kdiixs1 156,962,576 43,545.36 135.63
java call heap collected bytes 1,410,289,576 391,249.78 1,218.58
java call heap collected count 17,269,305 4,790.94 14.92
java call heap gc count 4,632 1.29 0.00
java call heap live object count 1,546,799 429.12 1.34
java call heap live object count max 1,540,387 427.34 1.33
java call heap live size 375,043,440 104,046.48 324.06
java call heap live size max 373,637,088 103,656.32 322.85
java call heap object count 3,709,800 1,029.19 3.21
java call heap object count max 3,715,142 1,030.67 3.21
java call heap total size 482,744,320 133,925.41 417.12
java call heap total size max 480,656,384 133,346.16 415.32
java call heap used size 513,454,352 142,445.15 443.66
java call heap used size max 513,046,328 142,331.95 443.30
leaf node 90-10 splits 20,160 5.59 0.02
leaf node splits 243,639 67.59 0.21
lob reads 21,405 5.94 0.02
lob writes 37,179 10.31 0.03
lob writes unaligned 37,179 10.31 0.03
logons cumulative 9,306 2.58 0.01
messages received 1,791,790 497.09 1.55
messages sent 1,791,790 497.09 1.55
no buffer to keep pinned count 12 0.00 0.00
no work - consistent read gets 504,525,871 139,968.16 435.94
opened cursors cumulative 5,461,711 1,515.22 4.72
parse count (failures) 3,240 0.90 0.00
parse count (hard) 8,719 2.42 0.01
parse count (total) 8,463,830 2,348.08 7.31
parse time cpu 47,367 13.14 0.04
parse time elapsed 52,161 14.47 0.05
physical read IO requests 282,633 78.41 0.24
physical read bytes 3,542,024,192 982,646.56 3,060.53
physical read total IO requests 311,898 86.53 0.27
physical read total bytes 4,020,592,640 1,115,413.47 3,474.05
physical read total multi block requests 12,098 3.36 0.01
physical reads 432,376 119.95 0.37
physical reads cache 431,241 119.64 0.37
physical reads cache prefetch 149,353 41.43 0.13
physical reads direct 1,135 0.31 0.00
physical reads direct temporary tablespace 403 0.11 0.00
physical reads prefetch warmup 80,456 22.32 0.07
physical write IO requests 1,597,242 443.12 1.38
physical write bytes 25,287,581,696 7,015,410.88 21,850.06
physical write total IO requests 2,781,018 771.52 2.40
physical write total bytes 58,357,509,632 16,189,840.26 50,424.57
physical write total multi block requests 1,364,756 378.62 1.18
physical writes 3,086,863 856.37 2.67
physical writes direct 5,003 1.39 0.00
physical writes direct (lob) 217 0.06 0.00
physical writes direct temporary tablespace 4,396 1.22 0.00
physical writes from cache 3,081,860 854.99 2.66
physical writes non checkpoint 2,328,827 646.08 2.01
pinned buffers inspected 3,719 1.03 0.00
prefetch warmup blocks aged out before use 243,408 67.53 0.21
prefetched blocks aged out before use 120 0.03 0.00
process last non-idle time 3,605 1.00 0.00
queries parallelized 48 0.01 0.00
recursive aborts on index block reclamation 1 0.00 0.00
recursive calls 158,458,199 43,960.29 136.92
recursive cpu usage 1,111,121 308.25 0.96
redo blocks written 64,422,755 17,872.49 55.67
redo buffer allocation retries 734 0.20 0.00
redo entries 100,965,456 28,010.36 87.24
redo log space requests 0 0.00 0.00
redo log space wait time 0 0.00 0.00
redo ordering marks 1,288,015 357.33 1.11
redo size 31,601,936,712 8,767,171.70 27,306.06
redo subscn max counts 2,368,205 657.00 2.05
redo synch time 99,315 27.55 0.09
redo synch writes 2,189,470 607.41 1.89
redo wastage 304,025,264 84,344.25 262.70
redo write time 52,310 14.51 0.05
redo writer latching time 246 0.07 0.00
redo writes 801,080 222.24 0.69
rollback changes - undo records applied 240,188 66.63 0.21
rollbacks only - consistent read gets 2,365,873 656.35 2.04
rows fetched via callback 95,905,133 26,606.49 82.87
session connect time 0 0.00 0.00
session cursor cache hits 5,377,790 1,491.93 4.65
session logical reads 2,051,455,244 569,125.26 1,772.59
session pga memory 8,935,195,344 2,478,847.82 7,720.57
session pga memory max 10,119,248,624 2,807,333.96 8,743.67
session uga memory ############### 74,774,859.85 232,892.34
session uga memory max 67,373,086,656 18,690,987.97 58,214.59
shared hash latch upgrades - no wait 31,653,115 8,781.37 27.35
shared hash latch upgrades - wait 39,139 10.86 0.03
sorts (memory) 10,238,554 2,840.43 8.85
sorts (rows) 127,212,199 35,291.86 109.92
sql area evicted 2,612 0.72 0.00
sql area purged 3,376 0.94 0.00
summed dirty queue length 502,237 139.33 0.43
switch current to new buffer 1,389,820 385.57 1.20
table fetch by rowid 910,588,709 252,620.20 786.81
table fetch continued row 31,987,228 8,874.06 27.64
table scan blocks gotten 69,381,905 19,248.28 59.95
table scan rows gotten 2,088,144,436 579,303.76 1,804.29
table scans (long tables) 2,055 0.57 0.00
table scans (rowid ranges) 2,053 0.57 0.00
table scans (short tables) 5,645,925 1,566.32 4.88
total number of times SMON posted 145,932 40.49 0.13
transaction rollbacks 4,215 1.17 0.00
transaction tables consistent read rollbacks 68 0.02 0.00
transaction tables consistent reads - undo records applied 8,516 2.36 0.01
undo change vector size 11,050,228,260 3,065,611.12 9,548.09
user I/O wait time 125,317 34.77 0.11
user calls 44,958,326 12,472.57 38.85
user commits 918,491 254.81 0.79
user rollbacks 238,832 66.26 0.21
workarea executions - onepass 2 0.00 0.00
workarea executions - optimal 5,966,569 1,655.28 5.16
write clones created in background 1,400 0.39 0.00
write clones created in foreground 10,746 2.98 0.01

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistic Begin Value End Value
session cursor cache count 501,653 1,146,302
opened cursors current 1,007,277 1,111,497
workarea memory allocated 102 188
logons current 4,772 4,785

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 32 0 7.19 1.00 748,195 208 257,029 0.03
APPS_TS_TX_DATA 167,015 46 4.33 1.31 214,238 59 124,082 0.19
APPS_TS_TX_IDX 90,612 25 4.28 1.32 210,790 58 58,385 0.32
APPS_ASSM_DATA 8,747 2 2.24 6.55 209,258 58 44,143 0.40
APPS_ASSM_IDX 6,634 2 2.16 1.04 145,116 40 182,863 0.10
APPS_TS_TX_INTERFACE 993 0 3.17 2.33 35,367 10 16,556 0.03
TEMP 388 0 5.10 12.17 9,120 3 35 5.43
APPS_TS_SUMMARY 58 0 7.76 1.00 8,460 2 2,541 0.01
SYSTEM 5,008 1 3.83 3.68 2,593 1 22,660 0.06
APPS_TS_SEED 2,137 1 6.60 1.73 5,112 1 828 2.68
APPS_TS_QUEUES 343 0 5.92 2.17 5,216 1 486 0.37
APPS_TS_ARCHIVE 53 0 4.34 1.47 2,362 1 107 2.06
SYSAUX 297 0 2.22 1.11 1,451 0 0 0.00
APPS_TS_NOLOGGING 25 0 8.00 1.56 46 0 0 0.00
CTXSYS 24 0 7.50 1.00 6 0 0 0.00
APPS_TS_MEDIA 12 0 6.67 1.00 9 0 0 0.00
ODM 12 0 4.17 1.00 3 0 0 0.00
OLAP 12 0 3.33 1.00 3 0 0 0.00
OWAPUB 12 0 4.17 1.00 3 0 0 0.00
PORTAL 12 0 5.00 1.00 3 0 0 0.00
SYNCSERVER 12 0 4.17 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,747 2 2.24 6.55 209,258 58 44,143 0.40
APPS_ASSM_IDX /DB/visdata/apps_assm_idx.dbf 6,634 2 2.16 1.04 145,116 40 182,863 0.10
APPS_TS_ARCHIVE /DB/visdata/archive1.dbf 25 0 5.20 1.56 2,102 1 99 2.22
APPS_TS_ARCHIVE /DB/visdata/archive2.dbf 28 0 3.57 1.39 260 0 8 0.00
APPS_TS_MEDIA /DB/visdata/media1.dbf 4 0 5.00 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 7.50 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 5.33 1.00 31 0 0 0.00
APPS_TS_NOLOGGING /DB/visdata/nologging3.dbf 6 0 15.00 3.33 12 0 0 0.00
APPS_TS_QUEUES /DB/visdata/queues1.dbf 36 0 6.39 1.92 865 0 125 0.32
APPS_TS_QUEUES /DB/visdata/queues2.dbf 32 0 5.00 3.47 768 0 288 0.31
APPS_TS_QUEUES /DB/visdata/queues3.dbf 36 0 3.33 2.22 723 0 2 0.00
APPS_TS_QUEUES /DB/visdata/queues4.dbf 46 0 7.61 2.41 838 0 0 0.00
APPS_TS_QUEUES /DB/visdata/queues5.dbf 30 0 6.00 2.77 506 0 2 0.00
APPS_TS_QUEUES /DB/visdata/queues6.dbf 28 0 4.29 2.04 685 0 0 0.00
APPS_TS_QUEUES /DB/visdata/queues7.dbf 135 0 6.44 1.73 831 0 69 0.72
APPS_TS_SEED /DB/visdata/reference1.dbf 184 0 7.17 1.85 462 0 52 3.46
APPS_TS_SEED /DB/visdata/reference10.dbf 178 0 5.45 1.78 527 0 62 2.90
APPS_TS_SEED /DB/visdata/reference2.dbf 209 0 7.03 1.61 553 0 40 1.50
APPS_TS_SEED /DB/visdata/reference3.dbf 344 0 6.16 1.69 573 0 393 2.37
APPS_TS_SEED /DB/visdata/reference4.dbf 188 0 6.17 1.84 495 0 36 5.56
APPS_TS_SEED /DB/visdata/reference5.dbf 239 0 6.65 1.64 500 0 36 5.56
APPS_TS_SEED /DB/visdata/reference6.dbf 221 0 6.88 1.86 529 0 44 2.50
APPS_TS_SEED /DB/visdata/reference7.dbf 214 0 7.71 1.65 465 0 38 1.05
APPS_TS_SEED /DB/visdata/reference8.dbf 190 0 6.32 1.76 487 0 52 4.42
APPS_TS_SEED /DB/visdata/reference9.dbf 170 0 6.47 1.68 521 0 75 1.20
APPS_TS_SUMMARY /DB/visdata/summary1.dbf 6 0 8.33 1.00 1,058 0 251 0.08
APPS_TS_SUMMARY /DB/visdata/summary2.dbf 5 0 6.00 1.00 942 0 248 0.00
APPS_TS_SUMMARY /DB/visdata/summary3.dbf 12 0 4.17 1.00 1,041 0 286 0.00
APPS_TS_SUMMARY /DB/visdata/summary4.dbf 7 0 8.57 1.00 924 0 250 0.00
APPS_TS_SUMMARY /DB/visdata/summary5.dbf 7 0 14.29 1.00 1,007 0 324 0.03
APPS_TS_SUMMARY /DB/visdata/summary6.dbf 7 0 5.71 1.00 1,133 0 695 0.00
APPS_TS_SUMMARY /DB/visdata/summary7.dbf 7 0 11.43 1.00 1,094 0 205 0.00
APPS_TS_SUMMARY /DB/visdata/summary8.dbf 7 0 5.71 1.00 1,261 0 282 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data1.dbf 2,988 1 5.15 1.18 355 0 8 3.75
APPS_TS_TX_DATA /DB/visdata/tx_data10.dbf 2,931 1 4.80 1.18 233 0 0 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data11.dbf 2,924 1 5.04 1.29 228 0 0 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data12.dbf 12,833 4 3.07 1.21 3,148 1 3,091 0.71
APPS_TS_TX_DATA /DB/visdata/tx_data13.dbf 17,234 5 4.78 1.49 5,036 1 2,312 0.97
APPS_TS_TX_DATA /DB/visdata/tx_data14.dbf 12,680 4 4.09 1.34 31,349 9 16,139 0.15
APPS_TS_TX_DATA /DB/visdata/tx_data15.dbf 8,918 2 3.96 1.39 30,735 9 16,682 0.16
APPS_TS_TX_DATA /DB/visdata/tx_data16.dbf 8,918 2 3.84 1.42 28,875 8 16,727 0.18
APPS_TS_TX_DATA /DB/visdata/tx_data17.dbf 8,817 2 3.89 1.42 28,104 8 16,991 0.12
APPS_TS_TX_DATA /DB/visdata/tx_data18.dbf 8,913 2 3.89 1.39 27,217 8 16,035 0.18
APPS_TS_TX_DATA /DB/visdata/tx_data19.dbf 8,806 2 3.94 1.40 27,341 8 16,259 0.17
APPS_TS_TX_DATA /DB/visdata/tx_data2.dbf 6,415 2 3.25 1.14 822 0 1,825 0.62
APPS_TS_TX_DATA /DB/visdata/tx_data20.dbf 8,908 2 3.98 1.44 27,081 8 16,683 0.13
APPS_TS_TX_DATA /DB/visdata/tx_data21.dbf 21,077 6 4.98 1.25 1,031 0 1,294 0.04
APPS_TS_TX_DATA /DB/visdata/tx_data3.dbf 3,539 1 5.37 1.36 459 0 3 6.67
APPS_TS_TX_DATA /DB/visdata/tx_data4.dbf 16,170 4 4.87 1.08 306 0 1 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data5.dbf 2,989 1 4.80 1.20 421 0 0 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data6.dbf 3,012 1 5.09 1.20 219 0 2 25.00
APPS_TS_TX_DATA /DB/visdata/tx_data7.dbf 2,932 1 4.83 1.23 497 0 23 2.61
APPS_TS_TX_DATA /DB/visdata/tx_data8.dbf 2,930 1 4.71 1.18 491 0 6 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data9.dbf 3,081 1 5.20 1.28 290 0 1 10.00
APPS_TS_TX_IDX /DB/visdata/tx_idx1.dbf 2,425 1 3.29 1.12 2,523 1 964 0.81
APPS_TS_TX_IDX /DB/visdata/tx_idx10.dbf 2,421 1 3.31 1.14 1,754 0 969 0.70
APPS_TS_TX_IDX /DB/visdata/tx_idx11.dbf 2,378 1 3.66 1.14 1,881 1 1,096 0.57
APPS_TS_TX_IDX /DB/visdata/tx_idx12.dbf 10,785 3 5.12 1.59 21,686 6 912 0.33
APPS_TS_TX_IDX /DB/visdata/tx_idx13.dbf 9,327 3 4.48 1.25 29,329 8 3,375 0.23
APPS_TS_TX_IDX /DB/visdata/tx_idx14.dbf 5,479 2 4.68 1.35 21,125 6 3,876 0.14
APPS_TS_TX_IDX /DB/visdata/tx_idx15.dbf 5,452 2 4.91 1.37 18,404 5 5,100 0.21
APPS_TS_TX_IDX /DB/visdata/tx_idx16.dbf 5,378 1 4.59 1.36 17,034 5 3,237 0.19
APPS_TS_TX_IDX /DB/visdata/tx_idx17.dbf 5,314 1 4.67 1.31 15,685 4 3,684 0.16
APPS_TS_TX_IDX /DB/visdata/tx_idx18.dbf 5,457 2 4.73 1.35 15,612 4 5,645 0.19
APPS_TS_TX_IDX /DB/visdata/tx_idx19.dbf 5,451 2 4.64 1.37 15,222 4 4,349 0.24
APPS_TS_TX_IDX /DB/visdata/tx_idx2.dbf 2,933 1 3.78 1.26 2,085 1 2,295 0.19
APPS_TS_TX_IDX /DB/visdata/tx_idx20.dbf 5,284 1 4.67 1.39 14,290 4 4,129 0.11
APPS_TS_TX_IDX /DB/visdata/tx_idx21.dbf 3,386 1 5.15 1.50 15,027 4 2,495 0.40
APPS_TS_TX_IDX /DB/visdata/tx_idx3.dbf 3,951 1 2.67 1.12 1,919 1 1,900 1.07
APPS_TS_TX_IDX /DB/visdata/tx_idx4.dbf 2,618 1 3.44 1.14 3,338 1 1,635 1.15
APPS_TS_TX_IDX /DB/visdata/tx_idx5.dbf 2,600 1 3.16 1.18 4,734 1 8,188 0.17
APPS_TS_TX_IDX /DB/visdata/tx_idx6.dbf 2,566 1 3.25 1.20 2,606 1 1,339 0.58
APPS_TS_TX_IDX /DB/visdata/tx_idx7.dbf 2,460 1 3.10 1.14 2,573 1 1,026 0.64
APPS_TS_TX_IDX /DB/visdata/tx_idx8.dbf 2,456 1 3.32 1.16 2,023 1 1,024 0.91
APPS_TS_TX_IDX /DB/visdata/tx_idx9.dbf 2,491 1 3.32 1.16 1,940 1 1,147 0.99
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte.dbf 65 0 7.08 3.35 5,557 2 5,346 0.02
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte2.dbf 306 0 2.35 2.06 6,710 2 3,708 0.04
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte3.dbf 184 0 3.37 2.34 6,067 2 2,925 0.03
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte4.dbf 221 0 2.08 1.95 5,921 2 1,688 0.02
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte5.dbf 158 0 3.99 2.23 5,603 2 1,710 0.04
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte6.dbf 59 0 4.41 4.19 5,509 2 1,179 0.07
APPS_UNDOTS1 /DB/visdata/undo01.dbf 3 0 0.00 1.00 74,004 21 21,340 0.02
APPS_UNDOTS1 /DB/visdata/undo02.dbf 3 0 16.67 1.00 77,486 21 21,870 0.03
APPS_UNDOTS1 /DB/visdata/undo03.dbf 3 0 6.67 1.00 74,850 21 22,931 0.03
APPS_UNDOTS1 /DB/visdata/undo04.dbf 5 0 10.00 1.00 70,213 19 24,894 0.02
APPS_UNDOTS1 /DB/visdata/undo05.dbf 3 0 10.00 1.00 70,765 20 25,950 0.03
APPS_UNDOTS1 /DB/visdata/undo06.dbf 3 0 10.00 1.00 70,990 20 32,766 0.06
APPS_UNDOTS1 /DB/visdata/undo07.dbf 3 0 3.33 1.00 70,984 20 24,536 0.03
APPS_UNDOTS1 /DB/visdata/undo08.dbf 3 0 6.67 1.00 77,186 21 25,455 0.03
APPS_UNDOTS1 /DB/visdata/undo09.dbf 3 0 3.33 1.00 83,277 23 31,324 0.04
APPS_UNDOTS1 /DB/visdata/undo10.dbf 3 0 3.33 1.00 78,440 22 25,963 0.03
CTXSYS /DB/visdata/ctx1.dbf 12 0 10.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 4.17 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 4.17 1.00 3 0 0 0.00
PORTAL /DB/visdata/portal.dbf 12 0 5.00 1.00 3 0 0 0.00
SYNCSERVER /DB/visdata/mobile01.dbf 12 0 4.17 1.00 3 0 0 0.00
SYSAUX /DB/visdata/sysaux01.dbf 18 0 6.67 1.78 690 0 0 0.00
SYSAUX /DB/visdata/sysaux02.dbf 279 0 1.94 1.07 761 0 0 0.00
SYSTEM /DB/visdata/sys1.dbf 545 0 3.83 4.05 102 0 77 0.91
SYSTEM /DB/visdata/sys2.dbf 522 0 3.66 4.39 195 0 70 0.00
SYSTEM /DB/visdata/sys3.dbf 687 0 3.00 3.52 242 0 9 0.00
SYSTEM /DB/visdata/sys4.dbf 623 0 3.23 3.75 250 0 0 0.00
SYSTEM /DB/visdata/sys5.dbf 796 0 4.18 3.10 656 0 400 0.03
SYSTEM /DB/visdata/sys6.dbf 541 0 3.59 4.29 57 0 9 0.00
SYSTEM /DB/visdata/sys7.dbf 441 0 4.67 4.33 165 0 84 0.48
SYSTEM /DB/visdata/sys8.dbf 391 0 4.14 3.15 469 0 21,993 0.06
SYSTEM /DB/visdata/sys9.dbf 462 0 4.72 2.71 457 0 18 0.00
TEMP /DB/visdata/temp1.dbf 126 0 5.87 18.81 2,345 1 20 4.00
TEMP /DB/visdata/temp2.dbf 104 0 5.48 6.79 2,229 1 0  
TEMP /DB/visdata/temp3.dbf 90 0 4.78 12.12 2,394 1 10 11.00
TEMP /DB/visdata/temp4.dbf 68 0 3.53 8.18 2,152 1 5 0.00

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 2,051,183,418 431,254 3,081,811 0 0 709,724


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 93 44326 1054379 4141775 188743680 4141775  
E 180 95 48465 1054681 9726381 188743680 9726381  

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 577,855 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 43,109.22 0.10 0.00 100.00 0.00 1,048,576
E 20,480 1,280 49,263.46 0.18 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,385,372 5,385,372 0 0
64K 128K 11,695 11,695 0 0
128K 256K 1,138 1,138 0 0
256K 512K 1,094 1,094 0 0
512K 1024K 171,776 171,776 0 0
1M 2M 394,928 394,928 0 0
2M 4M 72 72 0 0
4M 8M 21 19 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 861,717.89 8,530.14 99.00 1,152
5,120 0.25 861,717.89 8,470.86 99.00 1,118
10,240 0.50 861,717.89 8,345.86 99.00 1,062
15,360 0.75 861,717.89 8,201.16 99.00 1,017
20,480 1.00 861,717.89 5.23 100.00 969
24,576 1.20 861,717.89 5.23 100.00 922
28,672 1.40 861,717.89 5.23 100.00 837
32,768 1.60 861,717.89 5.23 100.00 611
36,864 1.80 861,717.89 0.00 100.00 118
40,960 2.00 861,717.89 0.00 100.00 0
61,440 3.00 861,717.89 0.00 100.00 0
81,920 4.00 861,717.89 0.00 100.00 0
122,880 6.00 861,717.89 0.00 100.00 0
163,840 8.00 861,717.89 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
992 0.39 295 13,271 2,517,608 1.00 3,209 2.76 202,886,956
1,248 0.49 519 16,509 2,519,141 1.00 1,676 1.44 203,013,039
1,504 0.59 776 20,052 2,519,578 1.00 1,239 1.07 203,048,508
1,760 0.70 1,030 23,822 2,519,648 1.00 1,169 1.01 203,054,517
2,016 0.80 1,263 29,623 2,519,654 1.00 1,163 1.00 203,055,143
2,272 0.90 1,427 34,602 2,519,654 1.00 1,163 1.00 203,055,214
2,528 1.00 1,475 36,064 2,519,654 1.00 1,163 1.00 203,055,226
2,784 1.10 1,475 36,064 2,519,654 1.00 1,163 1.00 203,055,226
3,040 1.20 1,475 36,064 2,519,654 1.00 1,163 1.00 203,055,226
3,296 1.30 1,475 36,064 2,519,654 1.00 1,163 1.00 203,055,226
3,552 1.41 1,475 36,064 2,519,654 1.00 1,163 1.00 203,055,226
3,808 1.51 1,475 36,064 2,519,654 1.00 1,163 1.00 203,055,226
4,064 1.61 1,475 36,064 2,519,654 1.00 1,163 1.00 203,055,226
4,320 1.71 1,475 36,064 2,519,654 1.00 1,163 1.00 203,055,226
4,576 1.81 1,475 36,064 2,519,654 1.00 1,163 1.00 203,055,226
4,832 1.91 1,475 36,064 2,519,654 1.00 1,163 1.00 203,055,226
5,088 2.01 1,475 36,064 2,519,654 1.00 1,163 1.00 203,055,226

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 28,915  
10,240 0.50 28,915  
15,360 0.75 28,919  
20,480 1.00 28,914  
25,600 1.25 28,919  
30,720 1.50 28,919  
35,840 1.75 28,921  
40,960 2.00 28,921  

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 179 854 1.00 1,164 1.00 16,990
32 0.50 13 179 854 1.00 1,164 1.00 16,990
48 0.75 13 179 854 1.00 1,164 1.00 16,990
64 1.00 13 179 854 1.00 1,164 1.00 16,990
80 1.25 13 179 854 1.00 1,164 1.00 16,990
96 1.50 13 179 854 1.00 1,164 1.00 16,990
112 1.75 13 179 854 1.00 1,164 1.00 16,990
128 2.00 13 179 854 1.00 1,164 1.00 16,990

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 444,690 82 0
undo block 200,441 5 0
undo header 56,588 3 0
segment header 2,154 0 0
1st level bmb 4,987 0 0
2nd level bmb 779 0 0
file header block 62 0 3
extent map 15 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)
TX-Transaction (row lock contention) 8,119 592 7,527 566 58 103.11
UL-User-defined 68,399 67,345 1,054 2,128 25 11.62
TX-Transaction (index contention) 26,373 26,373 0 24,298 13 0.53
RO-Multiple Object Reuse (fast object reuse) 234 234 0 25 9 366.80
HW-Segment High Water Mark 255,209 255,203 6 2,185 2 1.02
TX-Transaction 1,264,266 1,264,267 0 1,880 1 0.46
SQ-Sequence Cache 41,700 41,700 0 3,383 1 0.20
DV-Diana Versioning 29,232 29,232 0 149 1 3.96
TM-DML 2,004,466 2,004,415 1 1 0 310.00
TX-Transaction (allocate ITL entry) 147 147 0 83 0 1.93
FB-Format Block 36,415 36,415 0 465 0 0.17
PS-PX Process Reservation 1,864 1,544 320 38 0 0.00
CU-Cursor 8,638 8,638 0 1 0 0.00

Back to Wait Statistics
Back to Top

 

Undo Statistics

Back to Top

Undo Segment Summary

Undo TS# Num Undo Blocks (K) Number of Transactions Max Qry Len (s) Max Tx Concurcy Min/Max TR (mins) STO/ OOS uS/uR/uU/ eS/eR/eU
1 1,562.02 1,248,416 2,578 346 199.3/827.95 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-Oct 11:23 194,453 164,257 494 341 199 0/0 0/0/0/0/0/0
16-Oct 11:13 181,648 144,831 768 343 203 0/0 0/0/0/0/0/0
16-Oct 11:03 345,844 174,503 631 338 205 0/0 0/0/0/0/0/0
16-Oct 10:53 363,604 262,724 2,578 341 244 0/0 0/0/0/0/0/0
16-Oct 10:43 398,562 375,804 2,216 346 335 0/0 0/0/0/0/0/0
16-Oct 10:33 77,911 126,297 2,219 345 828 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,453 0.00   0 0  
AWR Alerted Metric Element list 305,807 0.00   0 0  
Consistent RBA 801,915 0.05 0.01 0 0  
FOB s.o list latch 49,502 0.02 0.00 0 0  
In memory undo latch 744,233,518 1.72 0.00 6 1,182,950 0.00
JOX SGA heap latch 1,922,269 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,842 0.00   0 0  
KMG resize request state object freelist 22 0.00   0 0  
KTF sga latch 12 0.00   0 1,214 0.00
KWQMN job cache list latch 13,564 0.18 1.00 0 0  
MQL Tracking Latch 0     0 72 0.00
Memory Management Latch 1,816 0.00   0 2,831 0.00
OS process 14,109 0.00   0 0  
OS process allocation 10,623 0.01 0.00 0 0  
OS process: request allocation 9,142 0.02 0.50 0 0  
PL/SQL warning settings 4,258,592 0.00   0 0  
SGA IO buffer pool latch 40,532 0.27 0.00 0 41,819 0.21
SQL memory manager latch 1 0.00   0 1,198 0.00
SQL memory manager workarea list latch 6,626,972 0.00 0.02 0 0  
Shared B-Tree 129 0.00   0 0  
active checkpoint queue latch 992,380 0.52 0.00 0 2 0.00
active service list 45,249 0.05 0.00 0 1,264 0.00
begin backup scn array 136 0.00   0 0  
buffer pool 18 0.00   0 0  
cache buffer handles 23,607,639 1.22 0.00 0 0  
cache buffers chains 4,819,105,039 0.99 0.02 28 17,966,572 2.48
cache buffers lru chain 9,932,020 0.33 0.04 1 35,823,192 0.46
cache table scan latch 2,099 0.00   0 2,099 0.00
channel handle pool latch 373,636 0.08 0.00 0 0  
channel operations parent latch 1,632,849 0.42 0.00 0 0  
checkpoint queue latch 15,517,712 0.02 0.01 0 3,093,019 0.02
client/application info 1,632,482 0.00 0.18 0 0  
commit callback allocation 79,945 0.00   0 0  
compile environment latch 2,845,186 0.00   0 0  
dictionary lookup 72 0.00   0 0  
dml lock allocation 3,993,357 0.17 0.01 0 0  
dummy allocation 18,608 0.21 0.00 0 0  
enqueue hash chains 8,758,104 0.06 0.00 0 277 0.00
enqueues 4,922,718 0.11 0.01 0 0  
error message lists 816 1.10 0.00 0 0  
event group latch 4,579 0.00   0 0  
file cache latch 21,127 0.00   0 0  
global KZLD latch for mem in SGA 8,794 0.00   0 0  
global ctx hash table latch 22,063 0.00   0 0  
hash table column usage latch 1,867 0.05 0.00 0 14,016,952 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 120 0.00   0 0  
kks stats 28,438 0.00   0 0  
ksuosstats global area 242 0.00   0 0  
ktm global data 145,931 0.00   0 0  
kwqbsn:qsga 129 0.00   0 0  
lgwr LWN SCN 804,348 0.09 0.00 0 0  
library cache 326,829,378 0.37 0.01 6 20,206 0.66
library cache load lock 10,479 0.35 0.05 0 13 0.00
library cache lock 54,001,129 0.05 0.01 0 0  
library cache lock allocation 1,396,938 0.01 0.04 0 0  
library cache pin 203,915,160 0.12 0.01 1 32 0.00
library cache pin allocation 488,357 0.00 0.06 0 0  
list of block allocation 444,254 0.01 0.00 0 0  
loader state object freelist 290,044 0.00 0.00 0 0  
longop free list parent 31 0.00   0 31 0.00
message pool operations parent latch 379,446 0.01 0.09 0 0  
messages 5,149,504 0.39 0.01 0 0  
mostly latch-free SCN 849,588 3.72 0.00 0 0  
multiblock read objects 26,712 0.00 0.00 0 0  
ncodef allocation latch 146 0.00   0 0  
object queue header heap 2,940,826 0.03 0.21 0 362,465 0.06
object queue header operation 33,596,011 0.13 0.39 2 17,597 1.07
object stats modification 371,474 0.02 0.00 0 0  
parallel query alloc buffer 8,156 0.91 0.00 0 0  
parallel query stats 528 16.86 0.00 0 0  
parameter table allocation management 21,957 1.07 0.47 0 0  
post/wait queue 1,245,859 0.03 0.04 0 508,279 0.01
process allocation 9,190 0.15 0.79 0 4,577 0.04
process group creation 9,142 0.00   0 0  
process queue 5,030 1.05 0.00 0 0  
process queue reference 785,053 0.04 0.00 0 83,605 0.46
qmn task queue latch 516 0.00   0 0  
query server freelists 4,256 5.10 0.00 0 0  
query server process 8 0.00   0 8 0.00
redo allocation 5,257,926 2.28 0.01 1 100,793,454 1.89
redo copy 0     0 100,967,279 0.04
redo writing 3,806,256 0.19 0.01 0 0  
resmgr group change latch 774,408 0.00   0 0  
resmgr:actses active list 27,364 0.39 1.00 0 0  
resmgr:actses change group 26,754 0.00   0 0  
resmgr:free threads list 18,606 0.24 0.07 0 0  
resmgr:schema config 1 0.00   0 0  
row cache objects 116,971,942 0.21 0.00 1 6,100 0.23
rules engine aggregate statistics 37,911 0.00 0.00 0 0  
rules engine rule set statistics 122,242 0.00   0 0  
rules engine rule statistics 46,421 0.00   0 0  
sequence cache 16,350,665 0.47 0.00 0 0  
session allocation 18,448,385 0.42 0.01 1 0  
session idle bit 92,728,956 0.01 0.02 0 0  
session state list latch 53,701 0.12 0.76 0 0  
session switching 13,672 0.00   0 0  
session timer 1,265 0.00   0 0  
shared pool 7,505,545 0.15 0.05 0 0  
shared pool sim alloc 364 0.00   0 0  
shared pool simulator 2,407,992 0.00 0.03 0 0  
sim partition latch 1 0.00   0 22,383 0.12
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,287,172 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 213 0.00   0 0  
temporary table state object allocation 11,453 0.00   0 0  
threshold alerts latch 605 0.00   0 0  
trace latch 28 0.00   0 0  
transaction allocation 106,531 0.00   0 0  
transaction branch allocation 146 0.00   0 0  
undo global data 971,822,094 1.65 0.00 8 18,691 0.04
user lock 35,274 0.01 0.25 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,819,105,039 47,634,764 994,378 46,743,009 0 0 0
undo global data 971,822,094 16,081,483 20,264 16,063,830 0 0 0
In memory undo latch 744,233,518 12,767,043 20,100 12,749,901 0 0 0
library cache 326,829,378 1,218,847 10,114 1,209,815 0 0 0
cache buffer handles 23,607,639 287,812 275 287,576 0 0 0
row cache objects 116,971,942 240,737 823 239,959 0 0 0
library cache pin 203,915,160 237,669 2,717 235,228 0 0 0
redo allocation 5,257,926 119,699 1,156 118,654 0 0 0
session allocation 18,448,385 77,487 694 76,859 0 0 0
sequence cache 16,350,665 76,132 78 76,063 0 0 0
object queue header operation 33,596,011 45,251 17,843 29,062 0 0 0
cache buffers lru chain 9,932,020 33,255 1,442 31,908 0 0 0
mostly latch-free SCN 849,588 31,596 74 31,528 0 0 0
library cache lock 54,001,129 26,762 153 26,618 0 0 0
messages 5,149,504 19,871 101 19,773 0 0 0
shared pool 7,505,545 11,450 627 10,885 0 0 0
session idle bit 92,728,956 11,036 199 10,843 0 0 0
redo writing 3,806,256 7,269 38 7,231 0 0 0
dml lock allocation 3,993,357 6,912 59 6,856 0 0 0
channel operations parent latch 1,632,849 6,889 16 6,874 0 0 0
enqueues 4,922,718 5,181 64 5,120 0 0 0
active checkpoint queue latch 992,380 5,152 23 5,129 0 0 0
enqueue hash chains 8,758,104 4,914 15 4,900 0 0 0
checkpoint queue latch 15,517,712 2,372 21 2,352 0 0 0
sort extent pool 1,287,172 1,288 17 1,272 0 0 0
object queue header heap 2,940,826 750 159 610 0 0 0
Consistent RBA 801,915 400 4 397 0 0 0
post/wait queue 1,245,859 400 14 386 0 0 0
process queue reference 785,053 349 1 348 0 0 0
channel handle pool latch 373,636 314 1 313 0 0 0
SQL memory manager workarea list latch 6,626,972 309 7 302 0 0 0
parameter table allocation management 21,957 235 111 129 0 0 0
resmgr:actses active list 27,364 107 107 3 0 0 0
library cache lock allocation 1,396,938 94 4 90 0 0 0
session state list latch 53,701 63 48 18 0 0 0
resmgr:free threads list 18,606 44 3 41 0 0 0
library cache load lock 10,479 37 2 35 0 0 0
shared pool simulator 2,407,992 37 1 36 0 0 0
KWQMN job cache list latch 13,564 24 24 0 0 0 0
message pool operations parent latch 379,446 22 2 20 0 0 0
client/application info 1,632,482 17 3 14 0 0 0
library cache pin allocation 488,357 16 1 15 0 0 0
process allocation 9,190 14 11 3 0 0 0
user lock 35,274 4 1 3 0 0 0
OS process: request allocation 9,142 2 1 1 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 11,164 13,581
In memory undo latch ktiFlush: child 0 4,861 2,890
In memory undo latch kticmt: child 0 3,331 618
In memory undo latch ktichg: child 0 538 2,933
In memory undo latch ktiTxnPoolFree 0 189 0
In memory undo latch ktbgfc 0 10 96
In memory undo latch ktiBRacquire 0 7 0
KWQMN job cache list latch kwqmnuji: update job item 0 24 3
OS process: request allocation kso_new_process 0 1 0
SQL memory manager workarea list latch qesmmIRegisterWorkArea 0 4 2
SQL memory manager workarea list latch qesmmIUnRegisterWorkArea 0 3 4
active checkpoint queue latch kcbbacq: scan active checkpoints 0 23 23
cache buffer handles kcbzgs 0 164 160
cache buffer handles kcbzfs 0 111 115
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 1,235,747 1,466,688
cache buffers chains kcbgtcr: fast path 0 596,876 24,431
cache buffers chains kcbchg: kslbegin: call CR func 0 349,829 842,910
cache buffers chains kcbzgb: scan from tail. nowait 0 114,639 0
cache buffers chains kcbgtcr: kslbegin excl 0 113,980 52,099
cache buffers chains kcbrls: kslbegin 0 37,869 74,330
cache buffers chains kcbgcur: kslbegin 0 22,351 11,955
cache buffers chains kcbget: pin buffer 0 17,046 7,015
cache buffers chains kcbzwb 0 5,056 5,363
cache buffers chains kcbcge 0 2,044 5,249
cache buffers chains kcbget: exchange rls 0 771 744
cache buffers chains kcbget: exchange 0 395 1,279
cache buffers chains kcb_is_private 0 171 1,703
cache buffers chains kcbnlc 0 165 1,325
cache buffers chains kcbbxsv 0 156 146
cache buffers chains kcbgtcr: kslbegin shared 0 66 58
cache buffers chains kcbnew: new latch again 0 57 8
cache buffers chains kcbesc: escalate 0 46 26
cache buffers chains kcb_pre_apply: kcbhq61 0 27 1,613
cache buffers chains kcb_post_apply: kcbhq63 0 14 219
cache buffers chains kcbso1: set no access 0 11 26
cache buffers chains kcbbic2 0 6 3
cache buffers chains kcb_post_apply: kcbhq62 0 5 287
cache buffers chains kcbnew_1 0 1 3
cache buffers chains kcbzib: finish free bufs 0 1 2
cache buffers chains kcbzib: multi-block read: nowait 0 1 0
cache buffers lru chain kcbzgws 0 830 0
cache buffers lru chain kcbbxsv: move to being written 0 197 414
cache buffers lru chain kcbgtcr:CR Scan:KCBRSKIP 0 142 0
cache buffers lru chain kcbo_link_q 0 128 17
cache buffers lru chain kcbzgb: posted for free bufs 0 65 350
cache buffers lru chain kcbo_ivd_proc 0 34 339
cache buffers lru chain kcbzswcu 0 21 58
cache buffers lru chain kcbbic2 0 19 215
cache buffers lru chain kcbzib 0 2 1
cache buffers lru chain kcbo_write_process:free_unlink 0 1 0
cache buffers lru chain kcbrlb 0 1 4
cache buffers lru chain kcbz_decr_wspwbcnt 0 1 23
cache buffers lru chain kcbzgpwb: KSLBEGIN use prewarm buffers 0 1 30
channel handle pool latch ksrchconnect() 0 4 1
channel operations parent latch ksrapublish() 0 9 0
channel operations parent latch ksrchdelete() 0 9 2
channel operations parent latch ksrwait() 0 3 17
channel operations parent latch ksrmfree() 0 2 0
channel operations parent latch ksrchconnect() 0 1 6
checkpoint queue latch kcbbwthc: thread checkpoint buffers 0 16 2
checkpoint queue latch kcbklbc: Link buffer into ckpt queue 0 4 0
checkpoint queue latch kcbkubc 0 1 8
client/application info kskirefrattrmap 0 2 1
client/application info kqp327i 0 1 2
cost function kzulrl 0 1 1
dml lock allocation ktaiam 0 44 41
dml lock allocation ktaidm 0 15 18
enqueue hash chains ksqgtl3 0 11 7
enqueue hash chains ksqrcl 0 4 8
enqueues ksqgel: create enqueue 0 27 11
enqueues ksqies 0 21 48
enqueues ksqdel 0 16 5
lgwr LWN SCN kcs023 0 22 0
library cache kglpndl: child: after processing 0 4,021 145
library cache kglpnp: child 0 3,651 5,255
library cache kglobpn: child: 0 797 1,375
library cache kglpndl: child: before processing 0 636 2,567
library cache kglLockCursor 0 232 309
library cache kglScanDependency 0 158 0
library cache kgldte: child 0 0 115 197
library cache kglpin 0 114 47
library cache kglhdgn: child: 0 77 165
library cache kglic 0 28 0
library cache kgldti: 2child 0 13 5
library cache kglivl: child 0 5 0
library cache kgldtld: 2child 0 3 8
library cache kglhdiv: child 0 3 0
library cache kglrtl 0 3 0
library cache kgldrp: child 0 1 0
library cache kglget: unpin heap 0 0 1 1
library cache kglhdbrnl: child 0 1 0
library cache kglhdgc: child: 0 1 0
library cache kglhdgh: child: 0 1 0
library cache kglupd: child 0 1 0
library cache load lock kglllal: llatch: in loop 0 2 2
library cache lock kgllkdl: child: cleanup 0 90 95
library cache lock kgllkdl: child: no lock handle 0 77 27
library cache lock kgllkal: child: multiinstance 0 63 58
library cache lock allocation kgllkget 0 4 4
library cache pin kglpndl 0 1,326 743
library cache pin kglpnp: child 0 1,209 1,579
library cache pin kglpnal: child: alloc space 0 182 395
library cache pin allocation kglpnget 0 1 1
message pool operations parent latch ksrmalloc() 0 2 0
messages ksarcv: after wait 0 45 58
messages ksarcv 0 32 12
messages ksaamb: after wakeup 0 24 32
mostly latch-free SCN kcslcu3 0 52 74
mostly latch-free SCN kcsnew_scn_rba 0 3 0
mostly latch-free SCN kcs01 0 1 5
object queue header heap kcbo_link_q:reget 0 151 3
object queue header heap kcbw_link_q:alloc 0 8 156
object queue header operation kcbo_ivbo 0 18,433 4,242
object queue header operation kcbw_link_q 0 3,127 2,148
object queue header operation kcbw_unlink_q 0 996 6,535
object queue header operation kcbo_switch_mq_bg 0 304 2,534
object queue header operation kcbo_switch_q_bg 0 267 1,578
object queue header operation kcbo_switch_cq 0 94 2,676
object queue header operation kcbo_link_q:reget 0 72 109
object queue header operation kcbo_service_ockpt 0 48 1
object queue header operation kcbo_write_q 0 45 11
object queue header operation kcbo_swap_buf 0 11 531
object queue header operation kcbo_swap_buf_bg 0 7 3,293
object queue header operation kcbw_make_free_nowait 0 1 0
object queue header operation kcbw_unlink_q_bg 0 1 12
parameter table allocation management ksp_param_table_free 0 110 110
parameter table allocation management kspallmod 0 1 0
post/wait queue ksliwat:remove 0 13 13
post/wait queue ksliwat:add:nowait 0 1 0
process allocation ksucrp 0 9 0
process allocation ksudlp 0 2 7
process queue reference kxfpqrsnd 0 1 0
redo allocation kcrfw_redo_gen: redo allocation 1 0 883 0
redo allocation kcrfw_redo_gen: redo allocation 3 0 196 731
redo allocation kcrfw_redo_gen: redo allocation 2 0 48 0
redo allocation kcrfw_redo_write: before write 0 20 142
redo allocation kcrfw_redo_write: more space 0 9 299
redo writing kcrfwcr 0 24 37
redo writing kcrfw_post: rba scn pair 0 11 0
redo writing kcrfw_post: after write 0 2 0
redo writing kcrfw_cal_target_rba 0 1 0
resmgr:actses active list kgskchclass 0 107 50
resmgr:free threads list kgskthrcreate 0 3 3
row cache objects kqreqd: reget 0 622 2
row cache objects kqrpre: find obj 0 136 721
row cache objects kqreqd 0 58 98
row cache objects kqrso 0 2 0
sequence cache kdnssd 0 58 6
sequence cache kdnnxt: cached seq 0 14 1
sequence cache kdnss 0 6 72
session allocation ksuxds: KSUSFCLC not set 0 193 12
session allocation ksuprc 0 161 125
session allocation ksudlc 0 110 151
session allocation ksucri 0 97 250
session allocation ksuxds: not user session 0 75 96
session allocation kspallmod 0 24 0
session allocation kxfpqidqr 0 13 24
session allocation ksursi 0 8 31
session allocation ksudlp 0 6 0
session allocation kxfprdp 0 6 3
session allocation ksucrp 0 1 2
session idle bit ksupuc: set busy 0 145 110
session idle bit ksupuc: clear busy 0 97 127
session idle bit ksuxds 0 12 17
session state list latch kpseqd 0 43 0
session state list latch kpscad 0 3 2
session state list latch kpseqa 0 2 44
shared pool kghupr1 0 341 443
shared pool kghalo 0 216 117
shared pool kghfrunp: clatch: nowait 0 173 0
shared pool kghfrunp: alloc: wait 0 36 0
shared pool kghfre 0 25 56
shared pool kghfrunp: clatch: wait 0 11 15
shared pool kghalp 0 8 10
shared pool kghfrh 0 1 0
shared pool simulator kglsim_scan_lru: scan 0 1 1
sort extent pool ktstdt: dealloc sort extent 0 15 0
sort extent pool ktstcrtobj 0 1 0
sort extent pool ktstdt: return extent 0 1 1
undo global data kturimugur: child 0 18,925 15,483
undo global data ktudba: KSLBEGIN 0 1,260 4,750
undo global data ktufrbs: child 0 23 10
undo global data ktucof: at start 0 22 0
undo global data ktudnx:child 0 15 14
undo global data ktubnd:child 0 11 4
undo global data ktusmasp: ktugd_tuux 0 8 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 69,168,064 3.37
INV APPS_TS_TX_IDX MTL_ITEM_CATEGORIES_U1   INDEX 50,608,048 2.47
ONT APPS_TS_TX_DATA OE_ORDER_LINES_ALL   TABLE 23,029,648 1.12
WSH APPS_TS_TX_DATA WSH_DELIVERY_DETAILS   TABLE 20,582,560 1.00
APPLSYS APPS_TS_TX_DATA WF_LOCAL_USER_ROLES FND_RESP TABLE PARTITION 20,232,672 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,014 8.10
AR APPS_ASSM_DATA RA_CUSTOMER_TRX_LINES_ALL   TABLE 13,075 3.02
WSH APPS_TS_TX_DATA WSH_DELIVERY_DETAILS   TABLE 9,554 2.21
HR APPS_TS_TX_IDX PAY_PERSON_LATEST_BALA_N50   INDEX 4,777 1.10
HR APPS_ASSM_DATA PAY_RUN_RESULTS   TABLE 4,048 0.94

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 14,600 30.55
APPLSYS APPS_TS_TX_IDX WF_ITEM_ACTIVITY_STATUSES_N1   INDEX 13,813 28.91
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_U1   INDEX 9,230 19.31
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N6   INDEX 2,433 5.09
HR APPS_ASSM_IDX PAY_RUN_RESULT_VALUES_PK   INDEX 1,642 3.44

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 19 36.54
APPLSYS APPS_TS_TX_IDX WF_ITEM_ATTRIBUTE_VALUES_PK   INDEX 10 19.23
GL APPS_ASSM_IDX GL_INTERFACE_N2   INDEX 5 9.62
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N5   INDEX 4 7.69
GL APPS_ASSM_IDX GL_IMPORT_REFERENCES_N1   INDEX 3 5.77

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 131,906 35.30
APPLSYS APPS_TS_TX_DATA WF_ITEM_ATTRIBUTE_VALUES   TABLE 75,491 20.20
SYS SYSTEM DBMS_LOCK_ALLOCATED   TABLE 21,987 5.88
GL APPS_ASSM_DATA GL_JE_LINES   TABLE 17,088 4.57
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N6   INDEX 15,668 4.19

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 552 46.56 0   552 0
dc_files 6,660 0.00 0   0 111
dc_global_oids 7,056,181 0.00 0   0 45
dc_histogram_data 6,248 20.12 0   0 529
dc_histogram_defs 383,967 3.02 0   3,982 1,701
dc_object_grants 65,566 0.10 0   0 82
dc_object_ids 11,749,405 0.02 0   50 1,035
dc_objects 165,026 1.19 0   280 774
dc_profiles 8,855 0.00 0   0 1
dc_rollback_segments 19,177 0.00 0   0 350
dc_segments 334,489 0.71 0   15,728 1,344
dc_sequences 51,287 0.16 0   51,287 111
dc_table_scns 19,366 0.04 0   0 5
dc_tablespace_quotas 15,604 0.17 0   217 41
dc_tablespaces 5,471,943 0.00 0   0 21
dc_usernames 465,681 0.00 0   0 19
dc_users 13,682,514 0.00 0   0 62
outstanding_alerts 268 0.75 0   1 42


Back to Top

 

Library Cache Activity

Namespace Get Requests Pct Miss Pin Requests Pct Miss Reloads Invali- dations
BODY 567,469 0.02 39,095,359 0.00 18 0
CLUSTER 110 0.91 269 1.12 2 0
INDEX 14,269 0.39 15,040 0.54 0 0
JAVA DATA 624 0.00 0   0 0
PIPE 45,504 2.52 66,923 1.72 0 0
SQL AREA 6,234 87.54 106,888,861 0.42 3,615 415
TABLE/PROCEDURE 368,269 0.28 53,450,909 0.01 1,213 0
TRIGGER 26,211 0.10 1,357,411 0.00 23 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 34,139.39   12.08 7.10 38 38 2,826 2,826
  Freeable 3,379.19 0.00 1.35 0.81 9   2,511 2,511
  SQL 3,176.45 1,628.69 1.13 0.71 4 22 2,818 2,817
  PL/SQL 2,173.10 174.99 0.77 0.96 3 3 2,826 2,826
  JAVA 242.30 241.18 2.24 0.33 5 8 108 108
E Other 39,121.52   13.76 8.49 40 40 2,844 2,844
  Freeable 3,832.50 0.00 1.50 0.94 9   2,557 2,557
  SQL 3,582.78 1,875.03 1.26 0.76 5 22 2,836 2,835
  PL/SQL 2,482.40 195.04 0.87 0.99 3 3 2,844 2,844
  JAVA 242.33 241.19 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,874,368,000 18,723,373,056
Fixed Size 2,111,120  
Redo Buffers 14,663,680  
Variable Size 2,583,693,680 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 34.53 34.60 0.21
shared KTI-UNDO 53.19 53.19 0.00
shared PL/SQL MPCODE 66.49 68.82 3.50
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 322.29 330.36 2.50
shared library cache 779.54 903.62 15.92
shared parameter table block 52.43 52.55 0.23
shared private strands 99.77 99.77 0.00
shared sessions 36.42 36.42 0.00
shared sql area 324.69 337.60 3.98
shared trace buffer 44.27 44.70 0.99
  buffer_cache 18,000.00 17,856.00 -0.80
  fixed_sga 2.01 2.01 0.00
  log_buffer 13.98 13.98 0.00

Back to Memory Statistics
Back to Top

 

Streams Statistics

Back to Top

 

Streams CPU/IO Usage

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

Rule Set

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

 

Resource Limit Stats

No data exists for this section of the report.


Back to Top

 

init.ora Parameters

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


Back to Top

End of Report