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 06-Aug-08 11:29:15 3832 207.3
End Snap: 2 06-Aug-08 12:29:20 3836 240.4
Elapsed:   60.09 (mins)    
DB Time:   462.36 (mins)    

 

Report Summary

Cache Sizes

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

Load Profile

  Per Second Per Transaction
Redo size: 8,396,263.24 31,211.81
Logical reads: 515,218.79 1,915.25
Block changes: 51,835.78 192.69
Physical reads: 120.95 0.45
Physical writes: 829.33 3.08
User calls: 9,845.31 36.60
Parses: 1,960.39 7.29
Hard parses: 2.09 0.01
Sorts: 2,385.02 8.87
Logons: 2.10 0.01
Executes: 23,209.52 86.28
Transactions: 269.01  

% Blocks changed per Read: 10.06 Recursive Call %: 79.32
Rollback per transaction %: 19.25 Rows per Sort: 12.81

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.95 Redo NoWait %: 100.00
Buffer Hit %: 99.98 In-memory Sort %: 100.00
Library Hit %: 99.74 Soft Parse %: 99.89
Execute to Parse %: 91.55 Latch Hit %: 98.26
Parse CPU to Parse Elapsd %: 89.05 % Non-Parse CPU: 97.85

Shared Pool Statistics

  Begin End
Memory Usage %: 83.04 85.74
% SQL with executions>1: 92.12 90.55
% Memory for SQL w/exec>1: 74.30 69.27

Top 5 Timed Events

Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class
CPU time   25,573   92.2  
db file sequential read 233,880 903 4 3.3 User I/O
log file sync 396,699 894 2 3.2 Commit
log file parallel write 683,370 463 1 1.7 System I/O
db file parallel write 254,179 229 1 .8 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 25,572.73 92.18
sql execute elapsed time 24,005.81 86.53
PL/SQL execution elapsed time 5,330.50 19.21
inbound PL/SQL rpc elapsed time 4,943.10 17.82
Java execution elapsed time 694.91 2.50
parse time elapsed 688.48 2.48
hard parse elapsed time 317.52 1.14
repeated bind elapsed time 92.27 0.33
sequence load elapsed time 20.00 0.07
connection management call elapsed time 12.68 0.05
PL/SQL compilation elapsed time 8.03 0.03
hard parse (sharing criteria) elapsed time 3.86 0.01
failed parse elapsed time 1.52 0.01
hard parse (bind mismatch) elapsed time 1.04 0.00
DB time 27,741.90  
background elapsed time 1,328.79  
background cpu time 552.21  

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 284,683 0.00 1,084 4 0.29
Commit 396,699 0.00 894 2 0.41
System I/O 968,438 0.00 704 1 1.00
Concurrency 2,864,072 0.16 326 0 2.95
Application 50,326 0.11 206 4 0.05
Network 40,664,386 0.00 135 0 41.92
Other 150,264 31.73 60 0 0.15
Configuration 7,088 0.00 4 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 233,880 0.00 903 4 0.24
log file sync 396,699 0.00 894 2 0.41
log file parallel write 683,370 0.00 463 1 0.70
db file parallel write 254,179 0.00 229 1 0.26
latch: cache buffers chains 1,917,509 0.00 157 0 1.98
enq: TX - row lock contention 565 7.26 128 226 0.00
db file scattered read 16,443 0.00 117 7 0.02
read by other session 31,379 0.00 62 2 0.03
enq: UL - contention 2,399 0.63 61 26 0.00
SQL*Net more data from client 1,856,110 0.00 60 0 1.91
buffer busy waits 860,726 0.00 54 0 0.89
cursor: pin S wait on X 5,049 91.94 50 10 0.01
SQL*Net message to client 37,184,960 0.00 48 0 38.34
SQL*Net more data to client 1,623,316 0.00 28 0 1.67
enq: TX - index contention 30,092 0.00 19 1 0.03
library cache load lock 755 0.00 15 19 0.00
PX Deq Credit: send blkd 21,424 0.00 12 1 0.02
latch: library cache 12,159 0.00 12 1 0.01
latch: undo global data 14,796 0.00 11 1 0.02
control file sequential read 29,150 0.00 10 0 0.03
latch: In memory undo latch 29,039 0.00 10 0 0.03
rdbms ipc reply 6 66.67 10 1608 0.00
SQL*Net break/reset to client 47,328 0.00 9 0 0.05
enq: RO - fast object reuse 34 0.00 8 247 0.00
kksfbc child completion 120 90.00 5 45 0.00
wait list latch free 381 0.00 4 11 0.00
latch: object queue header operation 17,550 0.00 3 0 0.02
os thread startup 69 0.00 3 45 0.00
LGWR wait for redo copy 27,571 0.01 3 0 0.03
latch: library cache pin 3,104 0.00 3 1 0.00
PX Deq: Signal ACK 230 35.22 2 10 0.00
latch: cache buffers lru chain 1,944 0.00 2 1 0.00
local write wait 1,766 0.00 2 1 0.00
enq: HW - contention 2,705 0.00 2 1 0.00
buffer deadlock 47,953 98.36 2 0 0.05
control file parallel write 1,739 0.00 1 1 0.00
latch: redo allocation 2,220 0.00 1 1 0.00
log buffer space 220 0.00 1 6 0.00
enq: TX - contention 2,575 0.00 1 0 0.00
latch: row cache objects 1,512 0.00 1 1 0.00
row cache lock 1,458 0.00 1 1 0.00
enq: DV - contention 203 0.00 1 5 0.00
enq: SQ - contention 3,940 0.00 1 0 0.00
latch: session allocation 1,359 0.00 1 1 0.00
latch free 1,370 0.00 1 0 0.00
SGA: allocation forcing component growth 26 61.54 0 11 0.00
direct path read 732 0.00 0 0 0.00
library cache lock 16 0.00 0 16 0.00
latch: shared pool 680 0.00 0 0 0.00
cursor: pin S 8,259 0.00 0 0 0.01
latch: cache buffer handles 316 0.00 0 1 0.00
latch: library cache lock 217 0.00 0 1 0.00
enq: FB - contention 851 0.00 0 0 0.00
latch: object queue header heap 333 0.00 0 0 0.00
library cache pin 1,458 0.00 0 0 0.00
enq: TX - allocate ITL entry 126 0.00 0 1 0.00
PX qref latch 370 81.08 0 0 0.00
latch: redo writing 90 0.00 0 1 0.00
latch: messages 273 0.00 0 0 0.00
latch: enqueue hash chains 38 0.00 0 1 0.00
reliable message 28 0.00 0 1 0.00
latch: checkpoint queue latch 26 0.00 0 1 0.00
L1 validation 3 33.33 0 3 0.00
cursor: mutex S 137 0.00 0 0 0.00
write complete waits 7 0.00 0 1 0.00
enq: CU - contention 4 0.00 0 2 0.00
direct path write 439 0.00 0 0 0.00
enq: PS - contention 35 0.00 0 0 0.00
cursor: mutex X 92 0.00 0 0 0.00
direct path write temp 38 0.00 0 0 0.00
direct path read temp 6 0.00 0 0 0.00
SQL*Net message from client 37,184,954 0.00 7,437,332 200 38.34
pipe get 22,572 20.37 21,063 933 0.02
Streams AQ: qmn slave idle wait 129 0.00 3,508 27191 0.00
Streams AQ: qmn coordinator idle wait 258 50.00 3,508 13595 0.00
Streams AQ: waiting for time management or cleanup tasks 2,331 39.04 3,507 1504 0.00
PL/SQL lock timer 247 99.19 2,719 11009 0.00
PX Idle Wait 1,638 76.68 2,595 1584 0.00
jobq slave wait 606 99.50 1,773 2925 0.00
PX Deq: Execution Msg 5,270 0.00 38 7 0.01
PX Deq: Execute Reply 2,647 0.00 4 2 0.00
PX Deq Credit: need buffer 5,033 0.00 1 0 0.01
PX Deq: Msg Fragment 4,462 0.00 1 0 0.00
PX Deq: Table Q Normal 6,942 0.00 1 0 0.01
PX Deq: Parse Reply 240 0.00 0 1 0.00
PX Deq: Join ACK 212 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 683,366 0.00 463 1 0.70
db file parallel write 254,179 0.00 229 1 0.26
events in waitclass Other 36,112 0.01 6 0 0.04
control file sequential read 827 0.00 3 4 0.00
os thread startup 61 0.00 3 45 0.00
db file scattered read 391 0.00 2 5 0.00
control file parallel write 1,739 0.00 1 1 0.00
db file sequential read 385 0.00 1 3 0.00
direct path read 732 0.00 0 0 0.00
latch: cache buffers chains 207 0.00 0 1 0.00
latch: redo writing 90 0.00 0 1 0.00
latch: row cache objects 1 0.00 0 9 0.00
log file sync 1 0.00 0 4 0.00
direct path write 333 0.00 0 0 0.00
buffer busy waits 17 0.00 0 0 0.00
latch: shared pool 1 0.00 0 0 0.00
latch: library cache 2 0.00 0 0 0.00
rdbms ipc message 1,706,415 0.68 36,550 21 1.76
pmon timer 1,255 96.81 3,515 2801 0.00
Streams AQ: qmn slave idle wait 129 0.00 3,508 27191 0.00
Streams AQ: qmn coordinator idle wait 258 50.00 3,508 13595 0.00
Streams AQ: waiting for time management or cleanup tasks 2,331 39.04 3,507 1504 0.00
smon timer 108,654 0.00 3,500 32 0.11

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic Total
BUSY_TIME 2,800,109
IDLE_TIME 2,956,418
IOWAIT_TIME 75,460
NICE_TIME 0
SYS_TIME 159,000
USER_TIME 2,549,767
LOAD 5
RSRC_MGR_CPU_WAIT_TIME 0
PHYSICAL_MEMORY_BYTES 64,101,664
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 27,737.80 25,568.80 419,870 1,854,451,451
SYS$BACKGROUND 0.00 0.00 16,286 3,108,878
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 282836 108029 2863780 32315 0 0 40652231 13526
SYS$BACKGROUND 1846 349 289 287 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
990 984 300 3.30 3.57 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
546 535 54,989 0.01 1.97 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
526 474 78,561 0.01 1.90 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
469 463 54,996 0.01 1.69 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...
446 440 55,016 0.01 1.61 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
435 407 141,939 0.00 1.57 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
397 395 259,750 0.00 1.43 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
364 360 61,305 0.01 1.31 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
352 343 1,009 0.35 1.27 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
299 278 186,543 0.00 1.08 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...

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
984 990 300 3.28 3.57 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
535 546 54,989 0.01 1.97 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
474 526 78,561 0.01 1.90 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
463 469 54,996 0.01 1.69 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...
440 446 55,016 0.01 1.61 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
407 435 141,939 0.00 1.57 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
395 397 259,750 0.00 1.43 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
360 364 61,305 0.01 1.31 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
343 352 1,009 0.34 1.27 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
278 299 186,543 0.00 1.08 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...

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
53,373,994 141,939 376.03 2.87 406.54 435.21 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
51,831,964 186,543 277.86 2.79 278.16 299.46 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
49,019,664 54,989 891.44 2.64 535.11 546.06 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
42,774,274 155,029 275.91 2.30 194.57 207.51 5kqw5535fjvw6 ARXTWMAI SELECT NVL(RCTT.ATTRIBUTE10, ...
42,256,616 300 140,855.39 2.27 984.35 989.78 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
34,744,266 55,016 631.53 1.87 439.55 446.27 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
29,654,092 1,382,675 21.45 1.60 177.22 183.12 66tmsr3446uqn ap.oie.server.WebExpensesAM SELECT WIAS.ACTIVITY_STATUS, ...
29,184,913 166,751 175.02 1.57 227.57 235.02 gf1u933c95jb5 INVTTMTX DECLARE l_ret_stat varchar2...
29,062,586 166,637 174.41 1.56 245.04 252.67 3b3psftuyks81 INVTTMTX BEGIN INV_TXNSTUB_PUB.postTran...
26,394,782 10,000 2,639.48 1.42 144.84 233.54 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
24,185,005 61,305 394.50 1.30 360.35 364.28 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
23,070,428 54,996 419.49 1.24 462.91 469.41 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...

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,235 10,000 4.52 10.37 144.84 233.54 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
33,287 1,686 19.74 7.63 16.37 154.63 3dssuqfjsynrk asn.lead.server.LeadUwqAM SELECT count(1) FROM (SELECT *...
24,253 1,686 14.38 5.56 129.92 231.45 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
22,825 15,137 1.51 5.23 163.41 230.82 1q78dwnrrkf6c asn.lead.server.LeadUwqAM BEGIN ASN_SALES_PVT.Lead_Proce...
12,526 186,543 0.07 2.87 278.16 299.46 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
8,983 5,048 1.78 2.06 123.93 155.85 8jb36w62w5hqf ibuSRDetailsActions.jsp BEGIN IBU_REQ_PKG.UpdateServic...
8,946 141,939 0.06 2.05 406.54 435.21 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
4,585 9,993 0.46 1.05 195.46 207.91 csvvv0fmhr1yc PYUSLV BEGIN FFP1893_01010001.FORMULA...
4,507 9,999 0.45 1.03 160.73 170.27 63t8zpm02skgh PYUSLV SELECT DECODE(COUNT(PRR.RUN_RE...
1,083 254 4.26 0.25 144.30 147.95 fumydqvpk1g21 qotSCopOverview.jsp BEGIN ASO_QUOTE_PUB_W.SUBMIT_Q...

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,382,675 716,310 0.52 0.00 0.00 66tmsr3446uqn ap.oie.server.WebExpensesAM SELECT WIAS.ACTIVITY_STATUS, ...
787,999 787,792 1.00 0.00 0.00 cd9mbmqyf4qhp ap.oie.server.WebExpensesAM UPDATE WF_ITEM_ACTIVITY_STATUS...
735,706 735,652 1.00 0.00 0.00 gnhmcahkmrnzs ap.oie.server.WebExpensesAM INSERT INTO WF_ITEM_ACTIVITY_S...
419,728 419,712 1.00 0.00 0.00 avc1jqzz04wpr JDBC Thin Client SELECT 'x' FROM DUAL
259,750 259,735 1.00 0.00 0.00 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
258,759 201,898 0.78 0.00 0.00 fmfdkztk8vx23   SELECT CATEGORY, SEVERITY, F...
204,155 3,470,584 17.00 0.00 0.00 cwyx16zn1hpfb JDBC Thin Client select parameter, value from ...
186,543 0 0.00 0.00 0.00 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
166,780 166,747 1.00 0.00 0.00 6gnth2mfbs2nq INVTTMTX declare v_ret number := 0...
166,751 166,744 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
419,717 419,728 5.94 avc1jqzz04wpr JDBC Thin Client SELECT 'x' FROM DUAL
259,753 259,750 3.67 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
258,764 258,759 3.66 fmfdkztk8vx23   SELECT CATEGORY, SEVERITY, F...
204,150 204,155 2.89 cwyx16zn1hpfb JDBC Thin Client select parameter, value from ...
165,910 166,780 2.35 6gnth2mfbs2nq INVTTMTX declare v_ret number := 0...
141,940 141,939 2.01 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
117,348 117,669 1.66 fb13x9qx0ftks OEXOETEL begin OE_STANDARD_WF.OEOL_SELE...
111,384 111,763 1.58 1c0b7sas42w2z INVTTMTX SELECT NVL(ITEM_COST, 0), ...
88,853 88,930 1.26 76sw2a4vnc89j icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.S...
84,684 84,710 1.20 608c0n36kaw62 icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.C...
84,662 88,937 1.20 dcvv68fju01g4 icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.E...
84,656 84,706 1.20 bf7uwg5pa3pj6 icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.V...
84,320 84,319 1.19 162ttnv4ubqun OEXOETEL begin OE_DS_PVT.Check_PO_Appr...
77,992 78,006 1.10 8camsgjsr9zya OEXOETEL begin OE_TRANSACTION_TYPES_PK...

Back to SQL Statistics
Back to Top

 

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

 

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

 

Complete List of SQL Text

SQL Id SQL Text
0z318y6g3uagc declare l_retstat varchar2 ( 3 ) ; l_msg_data varchar2 ( 244 ) ; l_msg_cnt number ; l_trx_cnt number ; BEGIN :retval := INV_TXN_MANAGER_PUB . process_Transactions ( p_api_version => 1.0 , p_commit => fnd_api . g_true , x_return_status => l_retstat , x_msg_count => l_msg_cnt , x_msg_data => l_msg_data , x_trans_count => l_trx_cnt , p_table => 1 , p_header_id => :header_id ) ; END ;
162ttnv4ubqun begin OE_DS_PVT.Check_PO_Approved( :t_application_id, :t_entity_short_name, :t_validation_entity_short_name, :t_validation_tmplt_short_name, :t_record_set_short_name, :t_scope, :t_result ); end;
1c0b7sas42w2z SELECT NVL(ITEM_COST, 0), COST_UPDATE_ID FROM CST_ITEM_COSTS WHERE INVENTORY_ITEM_ID = :1 AND ORGANIZATION_ID = :2 AND COST_TYPE_ID = :3
1q78dwnrrkf6c BEGIN ASN_SALES_PVT.Lead_Process_After_Update( P_Api_Version_Number => 2.0, P_Init_Msg_List => FND_API.G_TRUE, p_Commit => FND_API.G_FALSE, p_Validation_Level => FND_API.G_VALID_LEVEL_NONE, P_Identity_Salesforce_Id => :1, P_Salesgroup_id => :2, P_Sales_Lead_Id => :3, X_Return_Status => :4, X_Msg_Count => :5, X_Msg_Data => :6); END;
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;
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
fumydqvpk1g21 BEGIN ASO_QUOTE_PUB_W.SUBMIT_Quote(x_return_status => :1, x_msg_count => :2, x_msg_data => :3, p_q_quote_header_id => :4, p_q_last_update_date => :5, p_q_quote_expiration_date => :6, p_sc_book_flag => :7, p_sc_reserve_flag => :8, p_sc_calculate_price => :9, p_sc_server_id => :10, x_order_number => :11, x_order_header_id => :12, x_order_request_id => :13, x_contract_id => :14, x_status => :15 ); END;
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;
gnhmcahkmrnzs INSERT INTO WF_ITEM_ACTIVITY_STATUSES ( ITEM_TYPE, ITEM_KEY, PROCESS_ACTIVITY, ACTIVITY_STATUS, ACTIVITY_RESULT_CODE, ASSIGNED_USER, NOTIFICATION_ID, BEGIN_DATE, END_DATE, DUE_DATE, EXECUTION_TIME, OUTBOUND_QUEUE_ID ) VALUES ( :B13 , :B12 , :B11 , :B6 , :B10 , NULL, NULL, :B9 , :B8 , :B7 , DECODE(:B6 , :B5 , :B2 , :B4 , :B2 , :B3 , :B2 , NULL), :B1 )

Back to SQL Statistics
Back to Top

 

Instance Activity Statistics

Back to Top

Instance Activity Stats

Statistic Total per Second per Trans
CPU used by this session 2,553,697 708.24 2.63
CPU used when call started 2,548,451 706.79 2.63
CR blocks created 15,119,820 4,193.33 15.59
Cached Commit SCN referenced 45,861 12.72 0.05
Commit SCN cached 8 0.00 0.00
DB time 5,525,945 1,532.56 5.70
DBWR checkpoint buffers written 2,908,080 806.53 3.00
DBWR checkpoints 31 0.01 0.00
DBWR object drop buffers written 56,806 15.75 0.06
DBWR revisited being-written buffer 205 0.06 0.00
DBWR thread checkpoint buffers written 877,724 243.43 0.90
DBWR transaction table writes 1,900 0.53 0.00
DBWR undo block writes 1,517,962 420.99 1.56
DFO trees parallelized 48 0.01 0.00
IMU CR rollbacks 28,563,105 7,921.69 29.45
IMU Flushes 295,049 81.83 0.30
IMU Redo allocation size 1,937,367,648 537,309.33 1,997.36
IMU commits 505,178 140.11 0.52
IMU contention 34,488 9.56 0.04
IMU ktichg flush 8,324 2.31 0.01
IMU pool not allocated 0 0.00 0.00
IMU recursive-transaction flush 1,257 0.35 0.00
IMU undo allocation size 4,479,724,816 1,242,406.38 4,618.45
IMU- failed to get a private strand 0 0.00 0.00
PX local messages recv'd 51,505 14.28 0.05
PX local messages sent 51,505 14.28 0.05
Parallel operations downgraded 25 to 50 pct 40 0.01 0.00
Parallel operations not downgraded 8 0.00 0.00
SQL*Net roundtrips to/from client 37,178,991 10,311.22 38.33
active txn count during cleanout 125,446,689 34,791.37 129.33
application wait time 20,628 5.72 0.02
background checkpoints completed 3 0.00 0.00
background checkpoints started 2 0.00 0.00
background timeouts 13,906 3.86 0.01
branch node splits 1,023 0.28 0.00
buffer is not pinned count 551,219,140 152,875.06 568.29
buffer is pinned count 1,396,798,002 387,387.80 1,440.05
bytes received via SQL*Net from client 8,247,891,980 2,287,469.45 8,503.31
bytes sent via SQL*Net to client 7,714,724,844 2,139,600.93 7,953.64
calls to get snapshot scn: kcmgss 93,603,245 25,959.91 96.50
calls to kcmgas 18,715,113 5,190.45 19.29
calls to kcmgcs 19,143,357 5,309.22 19.74
change write time 67,716 18.78 0.07
cleanout - number of ktugct calls 32,512,140 9,016.91 33.52
cleanouts and rollbacks - consistent read gets 12,930,225 3,586.07 13.33
cleanouts only - consistent read gets 138,857 38.51 0.14
cluster key scan block gets 812,212 225.26 0.84
cluster key scans 228,803 63.46 0.24
commit batch/immediate performed 3,959 1.10 0.00
commit batch/immediate requested 3,959 1.10 0.00
commit cleanout failures: block lost 212,676 58.98 0.22
commit cleanout failures: buffer being written 704 0.20 0.00
commit cleanout failures: callback failure 103,708 28.76 0.11
commit cleanout failures: cannot pin 30,583 8.48 0.03
commit cleanouts 8,142,990 2,258.38 8.40
commit cleanouts successfully completed 7,795,319 2,161.95 8.04
commit immediate performed 3,959 1.10 0.00
commit immediate requested 3,959 1.10 0.00
commit txn count during cleanout 1,195,219 331.48 1.23
concurrency wait time 32,602 9.04 0.03
consistent changes 671,739,631 186,300.19 692.54
consistent gets 1,637,678,008 454,193.44 1,688.39
consistent gets - examination 1,152,272,547 319,571.14 1,187.96
consistent gets from cache 1,637,678,139 454,193.47 1,688.39
cursor authentications 2,006 0.56 0.00
data blocks consistent reads - undo records applied 668,556,411 185,417.36 689.26
db block changes 186,903,442 51,835.78 192.69
db block gets 220,039,092 61,025.62 226.85
db block gets direct 4,149 1.15 0.00
db block gets from cache 220,034,977 61,024.48 226.85
deferred (CURRENT) block cleanout applications 1,413,044 391.89 1.46
dirty buffers inspected 7,908 2.19 0.01
doubling up with imu segment 0 0.00 0.00
enqueue conversions 8,255 2.29 0.01
enqueue releases 3,672,578 1,018.55 3.79
enqueue requests 3,678,400 1,020.17 3.79
enqueue timeouts 5,676 1.57 0.01
enqueue waits 37,297 10.34 0.04
exchange deadlocks 47,957 13.30 0.05
execute count 83,686,212 23,209.52 86.28
failed probes on index block reclamation 8,932 2.48 0.01
frame signature mismatch 229 0.06 0.00
free buffer inspected 2,476,342 686.79 2.55
free buffer requested 19,219,055 5,330.21 19.81
heap block compress 32,034,316 8,884.39 33.03
hot buffers moved to head of LRU 1,038,343 287.97 1.07
immediate (CR) block cleanout applications 13,069,102 3,624.58 13.47
immediate (CURRENT) block cleanout applications 1,054,978 292.59 1.09
index crx upgrade (found) 65,043 18.04 0.07
index crx upgrade (positioned) 8,295,453 2,300.66 8.55
index fast full scans (rowid ranges) 792 0.22 0.00
index fetch by key 168,151,439 46,635.10 173.36
index scans kdiixs1 131,850,099 36,567.29 135.93
java call heap collected bytes 1,254,932,664 348,042.89 1,293.80
java call heap collected count 15,591,940 4,324.27 16.07
java call heap gc count 4,227 1.17 0.00
java call heap live object count 1,472,272 408.32 1.52
java call heap live object count max 1,517,173 420.77 1.56
java call heap live size 369,029,808 102,346.69 380.46
java call heap live size max 377,879,352 104,801.02 389.58
java call heap object count 3,588,947 995.36 3.70
java call heap object count max 3,602,413 999.09 3.71
java call heap total size 480,116,736 133,155.52 494.99
java call heap total size max 491,128,832 136,209.62 506.34
java call heap used size 505,497,528 140,194.63 521.15
java call heap used size max 511,747,144 141,927.90 527.60
leaf node 90-10 splits 17,660 4.90 0.02
leaf node splits 232,348 64.44 0.24
lob reads 16,668 4.62 0.02
lob writes 28,994 8.04 0.03
lob writes unaligned 28,994 8.04 0.03
logons cumulative 7,560 2.10 0.01
messages received 2,081,100 577.17 2.15
messages sent 2,081,099 577.17 2.15
no buffer to keep pinned count 14 0.00 0.00
no work - consistent read gets 442,114,297 122,615.93 455.81
opened cursors cumulative 4,515,574 1,252.35 4.66
parse count (failures) 2,521 0.70 0.00
parse count (hard) 7,520 2.09 0.01
parse count (total) 7,068,546 1,960.39 7.29
parse time cpu 55,077 15.28 0.06
parse time elapsed 61,847 17.15 0.06
physical read IO requests 250,989 69.61 0.26
physical read bytes 3,572,514,816 990,800.86 3,683.15
physical read total IO requests 280,249 77.72 0.29
physical read total bytes 4,051,009,536 1,123,506.53 4,176.46
physical read total multi block requests 16,436 4.56 0.02
physical reads 436,098 120.95 0.45
physical reads cache 435,180 120.69 0.45
physical reads cache prefetch 184,929 51.29 0.19
physical reads direct 918 0.25 0.00
physical reads direct temporary tablespace 186 0.05 0.00
physical reads prefetch warmup 115,273 31.97 0.12
physical write IO requests 1,232,518 341.83 1.27
physical write bytes 24,496,472,064 6,793,848.84 25,255.08
physical write total IO requests 2,359,980 654.52 2.43
physical write total bytes 56,173,497,856 15,579,151.65 57,913.09
physical write total multi block requests 1,298,480 360.12 1.34
physical writes 2,990,292 829.33 3.08
physical writes direct 4,668 1.29 0.00
physical writes direct (lob) 230 0.06 0.00
physical writes direct temporary tablespace 4,035 1.12 0.00
physical writes from cache 2,985,624 828.03 3.08
physical writes non checkpoint 2,230,069 618.49 2.30
pinned buffers inspected 2,658 0.74 0.00
prefetch warmup blocks aged out before use 227,990 63.23 0.24
prefetched blocks aged out before use 120 0.03 0.00
process last non-idle time 3,607 1.00 0.00
queries parallelized 48 0.01 0.00
recursive aborts on index block reclamation 3 0.00 0.00
recursive calls 136,157,306 37,761.85 140.37
recursive cpu usage 1,453,407 403.09 1.50
redo blocks written 61,702,258 17,112.50 63.61
redo buffer allocation retries 243 0.07 0.00
redo entries 96,709,924 26,821.52 99.70
redo log space requests 0 0.00 0.00
redo log space wait time 0 0.00 0.00
redo ordering marks 1,149,441 318.79 1.19
redo size 30,274,272,008 8,396,263.24 31,211.81
redo subscn max counts 2,267,385 628.84 2.34
redo synch time 92,177 25.56 0.10
redo synch writes 1,714,507 475.50 1.77
redo wastage 283,738,292 78,691.95 292.53
redo write time 52,928 14.68 0.05
redo writer latching time 272 0.08 0.00
redo writes 683,566 189.58 0.70
rollback changes - undo records applied 256,192 71.05 0.26
rollbacks only - consistent read gets 2,354,780 653.07 2.43
rows fetched via callback 88,867,438 24,646.49 91.62
session connect time 0 0.00 0.00
session cursor cache hits 4,536,506 1,258.15 4.68
session logical reads 1,857,716,151 515,218.79 1,915.25
session pga memory 9,255,475,016 2,566,912.41 9,542.10
session pga memory max 10,603,627,752 2,940,808.94 10,932.00
session uga memory ############### 74,814,797.21 278,112.46
session uga memory max 56,348,895,016 15,627,796.28 58,093.92
shared hash latch upgrades - no wait 28,699,430 7,959.50 29.59
shared hash latch upgrades - wait 98,036 27.19 0.10
sorts (memory) 8,599,614 2,385.02 8.87
sorts (rows) 110,162,331 30,552.41 113.57
sql area evicted 2,200 0.61 0.00
sql area purged 2,673 0.74 0.00
summed dirty queue length 170,231 47.21 0.18
switch current to new buffer 1,238,600 343.51 1.28
table fetch by rowid 824,008,828 228,530.52 849.53
table fetch continued row 36,045,434 9,996.84 37.16
table scan blocks gotten 54,967,387 15,244.65 56.67
table scan rows gotten 1,636,278,128 453,805.19 1,686.95
table scans (long tables) 2,058 0.57 0.00
table scans (rowid ranges) 2,056 0.57 0.00
table scans (short tables) 4,466,092 1,238.63 4.60
total number of times SMON posted 108,728 30.15 0.11
transaction rollbacks 3,959 1.10 0.00
transaction tables consistent read rollbacks 80 0.02 0.00
transaction tables consistent reads - undo records applied 5,188 1.44 0.01
undo change vector size 10,544,761,852 2,924,483.08 10,871.31
user I/O wait time 108,397 30.06 0.11
user calls 35,499,073 9,845.31 36.60
user commits 783,214 217.22 0.81
user rollbacks 186,748 51.79 0.19
workarea executions - onepass 2 0.00 0.00
workarea executions - optimal 4,904,697 1,360.27 5.06
write clones created in background 1,760 0.49 0.00
write clones created in foreground 7,344 2.04 0.01

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistic Begin Value End Value
session cursor cache count 312,446 849,990
opened cursors current 794,484 922,156
workarea memory allocated 559 945
logons current 3,832 3,836

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 33 0 7.88 1.00 521,775 145 295,154 0.05
APPS_TS_TX_DATA 149,034 41 4.19 1.42 169,502 47 141,665 0.24
APPS_TS_TX_IDX 77,621 22 4.20 1.66 157,089 44 80,776 0.28
APPS_ASSM_DATA 8,561 2 2.10 6.67 209,338 58 48,896 0.26
APPS_ASSM_IDX 6,374 2 2.16 1.05 117,555 33 275,822 0.11
APPS_TS_TX_INTERFACE 932 0 4.81 2.42 28,030 8 25,708 0.14
TEMP 277 0 4.30 15.37 8,292 2 63 2.54
SYSTEM 4,836 1 4.08 3.91 2,273 1 19,791 0.12
APPS_TS_SUMMARY 62 0 7.74 1.00 6,373 2 2,669 0.05
APPS_TS_SEED 2,200 1 5.80 1.86 3,773 1 819 2.82
APPS_TS_QUEUES 551 0 4.50 3.06 4,246 1 369 0.22
APPS_TS_ARCHIVE 51 0 4.90 1.49 1,754 0 96 2.81
SYSAUX 298 0 2.79 1.09 1,380 0 0 0.00
APPS_TS_NOLOGGING 25 0 8.40 1.56 56 0 11 5.45
CTXSYS 24 0 7.08 1.00 6 0 0 0.00
APPS_TS_MEDIA 12 0 6.67 1.00 9 0 0 0.00
ODM 12 0 6.67 1.00 3 0 0 0.00
OLAP 12 0 6.67 1.00 3 0 0 0.00
OWAPUB 12 0 6.67 1.00 3 0 0 0.00
PORTAL 12 0 7.50 1.00 3 0 0 0.00
SYNCSERVER 12 0 6.67 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,561 2 2.10 6.67 209,338 58 48,896 0.26
APPS_ASSM_IDX /DB/visdata/apps_assm_idx.dbf 6,374 2 2.16 1.05 117,555 33 275,822 0.11
APPS_TS_ARCHIVE /DB/visdata/archive1.dbf 18 0 6.11 1.78 1,526 0 92 2.93
APPS_TS_ARCHIVE /DB/visdata/archive2.dbf 33 0 4.24 1.33 228 0 4 0.00
APPS_TS_MEDIA /DB/visdata/media1.dbf 4 0 7.50 1.00 3 0 0 0.00
APPS_TS_MEDIA /DB/visdata/media2.dbf 4 0 5.00 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 8.00 1.00 42 0 11 5.45
APPS_TS_NOLOGGING /DB/visdata/nologging3.dbf 6 0 10.00 3.33 11 0 0 0.00
APPS_TS_QUEUES /DB/visdata/queues1.dbf 141 0 2.70 1.40 424 0 136 0.37
APPS_TS_QUEUES /DB/visdata/queues2.dbf 47 0 6.81 5.30 784 0 156 0.19
APPS_TS_QUEUES /DB/visdata/queues3.dbf 58 0 3.97 3.98 649 0 9 0.00
APPS_TS_QUEUES /DB/visdata/queues4.dbf 51 0 5.49 4.04 585 0 1 0.00
APPS_TS_QUEUES /DB/visdata/queues5.dbf 48 0 5.63 4.31 552 0 0 0.00
APPS_TS_QUEUES /DB/visdata/queues6.dbf 56 0 5.00 4.23 554 0 3 0.00
APPS_TS_QUEUES /DB/visdata/queues7.dbf 150 0 4.80 2.38 698 0 64 0.00
APPS_TS_SEED /DB/visdata/reference1.dbf 178 0 5.67 2.08 357 0 48 3.54
APPS_TS_SEED /DB/visdata/reference10.dbf 205 0 6.44 1.92 377 0 62 4.03
APPS_TS_SEED /DB/visdata/reference2.dbf 210 0 6.24 2.10 378 0 40 1.00
APPS_TS_SEED /DB/visdata/reference3.dbf 344 0 5.00 1.74 458 0 393 2.98
APPS_TS_SEED /DB/visdata/reference4.dbf 197 0 5.63 1.89 384 0 35 3.71
APPS_TS_SEED /DB/visdata/reference5.dbf 220 0 6.23 1.70 365 0 29 3.45
APPS_TS_SEED /DB/visdata/reference6.dbf 260 0 5.35 1.82 362 0 41 1.46
APPS_TS_SEED /DB/visdata/reference7.dbf 209 0 6.17 1.82 335 0 38 6.05
APPS_TS_SEED /DB/visdata/reference8.dbf 193 0 6.01 1.97 354 0 55 1.27
APPS_TS_SEED /DB/visdata/reference9.dbf 184 0 5.87 1.68 403 0 78 1.15
APPS_TS_SUMMARY /DB/visdata/summary1.dbf 5 0 8.00 1.00 733 0 378 0.00
APPS_TS_SUMMARY /DB/visdata/summary2.dbf 5 0 10.00 1.00 685 0 292 0.17
APPS_TS_SUMMARY /DB/visdata/summary3.dbf 10 0 10.00 1.00 735 0 210 0.05
APPS_TS_SUMMARY /DB/visdata/summary4.dbf 12 0 9.17 1.00 751 0 197 0.05
APPS_TS_SUMMARY /DB/visdata/summary5.dbf 7 0 7.14 1.00 795 0 311 0.03
APPS_TS_SUMMARY /DB/visdata/summary6.dbf 7 0 7.14 1.00 921 0 723 0.06
APPS_TS_SUMMARY /DB/visdata/summary7.dbf 9 0 4.44 1.00 887 0 355 0.00
APPS_TS_SUMMARY /DB/visdata/summary8.dbf 7 0 5.71 1.00 866 0 203 0.05
APPS_TS_TX_DATA /DB/visdata/tx_data1.dbf 2,468 1 5.12 1.40 299 0 3 6.67
APPS_TS_TX_DATA /DB/visdata/tx_data10.dbf 2,471 1 4.70 1.34 145 0 0 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data11.dbf 2,461 1 4.95 1.41 126 0 0 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data12.dbf 11,937 3 2.67 1.28 1,884 1 3,261 1.52
APPS_TS_TX_DATA /DB/visdata/tx_data13.dbf 15,433 4 4.74 1.72 3,837 1 2,295 0.87
APPS_TS_TX_DATA /DB/visdata/tx_data14.dbf 11,795 3 3.97 1.44 25,958 7 18,978 0.16
APPS_TS_TX_DATA /DB/visdata/tx_data15.dbf 8,288 2 3.96 1.54 24,005 7 18,638 0.24
APPS_TS_TX_DATA /DB/visdata/tx_data16.dbf 8,328 2 3.79 1.51 22,784 6 18,720 0.16
APPS_TS_TX_DATA /DB/visdata/tx_data17.dbf 8,251 2 3.69 1.50 22,075 6 19,834 0.18
APPS_TS_TX_DATA /DB/visdata/tx_data18.dbf 8,249 2 3.76 1.49 21,629 6 18,922 0.21
APPS_TS_TX_DATA /DB/visdata/tx_data19.dbf 8,114 2 3.87 1.52 21,429 6 19,808 0.20
APPS_TS_TX_DATA /DB/visdata/tx_data2.dbf 6,015 2 3.20 1.17 564 0 2,011 0.93
APPS_TS_TX_DATA /DB/visdata/tx_data20.dbf 8,070 2 3.81 1.54 21,634 6 17,776 0.18
APPS_TS_TX_DATA /DB/visdata/tx_data21.dbf 17,964 5 4.93 1.27 926 0 1,388 0.07
APPS_TS_TX_DATA /DB/visdata/tx_data3.dbf 2,877 1 5.43 1.68 368 0 5 2.00
APPS_TS_TX_DATA /DB/visdata/tx_data4.dbf 13,825 4 4.74 1.15 320 0 4 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data5.dbf 2,460 1 4.83 1.38 313 0 3 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data6.dbf 2,513 1 4.70 1.36 176 0 7 4.29
APPS_TS_TX_DATA /DB/visdata/tx_data7.dbf 2,434 1 4.84 1.33 403 0 6 3.33
APPS_TS_TX_DATA /DB/visdata/tx_data8.dbf 2,526 1 4.66 1.30 407 0 6 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data9.dbf 2,555 1 4.84 1.41 220 0 0 0.00
APPS_TS_TX_IDX /DB/visdata/tx_idx1.dbf 2,296 1 3.22 1.24 1,852 1 1,708 0.49
APPS_TS_TX_IDX /DB/visdata/tx_idx10.dbf 2,250 1 3.11 1.29 1,206 0 2,190 0.26
APPS_TS_TX_IDX /DB/visdata/tx_idx11.dbf 2,270 1 3.22 1.33 1,422 0 2,034 0.53
APPS_TS_TX_IDX /DB/visdata/tx_idx12.dbf 8,733 2 5.27 2.28 17,317 5 1,930 0.23
APPS_TS_TX_IDX /DB/visdata/tx_idx13.dbf 7,957 2 4.38 1.50 22,715 6 4,550 0.32
APPS_TS_TX_IDX /DB/visdata/tx_idx14.dbf 4,382 1 4.75 1.81 15,329 4 5,059 0.13
APPS_TS_TX_IDX /DB/visdata/tx_idx15.dbf 4,410 1 4.64 1.75 12,491 3 5,697 0.15
APPS_TS_TX_IDX /DB/visdata/tx_idx16.dbf 4,377 1 4.68 1.77 11,765 3 4,914 0.21
APPS_TS_TX_IDX /DB/visdata/tx_idx17.dbf 4,201 1 4.63 1.77 10,988 3 5,124 0.16
APPS_TS_TX_IDX /DB/visdata/tx_idx18.dbf 4,472 1 4.64 1.81 11,279 3 7,874 0.13
APPS_TS_TX_IDX /DB/visdata/tx_idx19.dbf 4,364 1 4.61 1.79 10,159 3 5,815 0.15
APPS_TS_TX_IDX /DB/visdata/tx_idx2.dbf 2,556 1 4.10 1.52 1,466 0 2,882 0.29
APPS_TS_TX_IDX /DB/visdata/tx_idx20.dbf 4,284 1 4.71 1.77 10,074 3 4,687 0.11
APPS_TS_TX_IDX /DB/visdata/tx_idx21.dbf 2,973 1 5.06 2.02 13,445 4 3,131 0.58
APPS_TS_TX_IDX /DB/visdata/tx_idx3.dbf 3,771 1 2.51 1.27 1,539 0 2,498 0.62
APPS_TS_TX_IDX /DB/visdata/tx_idx4.dbf 2,475 1 3.13 1.36 2,720 1 2,351 0.78
APPS_TS_TX_IDX /DB/visdata/tx_idx5.dbf 2,407 1 3.38 1.35 4,082 1 10,979 0.18
APPS_TS_TX_IDX /DB/visdata/tx_idx6.dbf 2,441 1 3.33 1.36 2,233 1 2,112 0.73
APPS_TS_TX_IDX /DB/visdata/tx_idx7.dbf 2,387 1 3.15 1.38 2,166 1 1,600 0.53
APPS_TS_TX_IDX /DB/visdata/tx_idx8.dbf 2,303 1 3.36 1.34 1,424 0 1,787 0.44
APPS_TS_TX_IDX /DB/visdata/tx_idx9.dbf 2,312 1 3.10 1.38 1,417 0 1,854 0.54
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte.dbf 130 0 5.08 2.18 4,344 1 10,165 0.11
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte2.dbf 138 0 5.00 3.34 5,545 2 6,077 0.19
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte3.dbf 288 0 4.58 1.87 4,859 1 4,305 0.14
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte4.dbf 127 0 5.51 2.66 4,446 1 2,418 0.16
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte5.dbf 133 0 4.44 2.46 4,438 1 1,667 0.10
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte6.dbf 116 0 4.48 2.62 4,398 1 1,076 0.09
APPS_UNDOTS1 /DB/visdata/undo01.dbf 3 0 6.67 1.00 51,157 14 26,964 0.05
APPS_UNDOTS1 /DB/visdata/undo02.dbf 3 0 10.00 1.00 53,096 15 25,394 0.05
APPS_UNDOTS1 /DB/visdata/undo03.dbf 3 0 6.67 1.00 51,811 14 27,758 0.05
APPS_UNDOTS1 /DB/visdata/undo04.dbf 3 0 10.00 1.00 49,221 14 26,206 0.04
APPS_UNDOTS1 /DB/visdata/undo05.dbf 3 0 6.67 1.00 53,147 15 38,716 0.06
APPS_UNDOTS1 /DB/visdata/undo06.dbf 3 0 13.33 1.00 53,573 15 39,783 0.05
APPS_UNDOTS1 /DB/visdata/undo07.dbf 3 0 13.33 1.00 50,484 14 33,354 0.08
APPS_UNDOTS1 /DB/visdata/undo08.dbf 4 0 5.00 1.00 53,596 15 25,809 0.04
APPS_UNDOTS1 /DB/visdata/undo09.dbf 4 0 5.00 1.00 53,401 15 27,840 0.04
APPS_UNDOTS1 /DB/visdata/undo10.dbf 4 0 5.00 1.00 52,289 15 23,330 0.05
CTXSYS /DB/visdata/ctx1.dbf 12 0 7.50 1.00 3 0 0 0.00
CTXSYS /DB/visdata/ctx2.dbf 12 0 6.67 1.00 3 0 0 0.00
ODM /DB/visdata/odm.dbf 12 0 6.67 1.00 3 0 0 0.00
OLAP /DB/visdata/olap.dbf 12 0 6.67 1.00 3 0 0 0.00
OWAPUB /DB/visdata/owa1.dbf 12 0 6.67 1.00 3 0 0 0.00
PORTAL /DB/visdata/portal.dbf 12 0 7.50 1.00 3 0 0 0.00
SYNCSERVER /DB/visdata/mobile01.dbf 12 0 6.67 1.00 3 0 0 0.00
SYSAUX /DB/visdata/sysaux01.dbf 20 0 8.50 1.35 620 0 0 0.00
SYSAUX /DB/visdata/sysaux02.dbf 278 0 2.37 1.07 760 0 0 0.00
SYSTEM /DB/visdata/sys1.dbf 497 0 3.98 4.61 100 0 105 0.10
SYSTEM /DB/visdata/sys2.dbf 552 0 3.50 4.28 173 0 121 0.17
SYSTEM /DB/visdata/sys3.dbf 635 0 3.69 3.82 209 0 26 0.38
SYSTEM /DB/visdata/sys4.dbf 551 0 3.58 4.27 212 0 7 12.86
SYSTEM /DB/visdata/sys5.dbf 820 0 4.46 3.24 626 0 2,027 0.19
SYSTEM /DB/visdata/sys6.dbf 495 0 4.30 4.71 65 0 6 0.00
SYSTEM /DB/visdata/sys7.dbf 425 0 4.71 4.56 137 0 58 0.00
SYSTEM /DB/visdata/sys8.dbf 356 0 4.61 3.44 403 0 17,335 0.10
SYSTEM /DB/visdata/sys9.dbf 505 0 4.10 2.59 348 0 106 1.13
TEMP /DB/visdata/temp1.dbf 63 0 3.65 4.62 2,465 1 38 2.11
TEMP /DB/visdata/temp2.dbf 58 0 4.14 1.00 1,735 0 0  
TEMP /DB/visdata/temp3.dbf 83 0 4.70 20.20 1,980 1 0  
TEMP /DB/visdata/temp4.dbf 73 0 4.52 30.58 2,112 1 25 3.20

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,228,354 100 1,836,001,154 435,170 2,985,596 0 0 891,995


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 82 34821 817629 3131026 188743680 3131026  
E 180 84 38376 830600 8818360 188743680 8818360  

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 455,992 5

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

  PGA Aggr Target(M) Auto PGA Target(M) PGA Mem Alloc(M) W/A PGA Used(M) %PGA W/A Mem %Auto W/A Mem %Man W/A Mem Global Mem Bound(K)
B 20,480 1,280 32,955.26 0.14 0.00 100.00 0.00 1,048,576
E 20,480 1,280 40,917.89 0.92 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 4,439,159 4,439,159 0 0
64K 128K 11,507 11,507 0 0
128K 256K 1,078 1,078 0 0
256K 512K 1,008 1,008 0 0
512K 1024K 138,751 138,751 0 0
1M 2M 308,577 308,577 0 0
2M 4M 72 70 2 0
4M 8M 13 13 0 0
8M 16M 22 22 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 619,072.56 8,668.27 99.00 1,094
5,120 0.25 619,072.56 8,578.94 99.00 1,053
10,240 0.50 619,072.56 8,371.54 99.00 991
15,360 0.75 619,072.56 8,180.59 99.00 932
20,480 1.00 619,072.56 0.00 100.00 877
24,576 1.20 619,072.56 0.00 100.00 746
28,672 1.40 619,072.56 0.00 100.00 256
32,768 1.60 619,072.56 0.00 100.00 0
36,864 1.80 619,072.56 0.00 100.00 0
40,960 2.00 619,072.56 0.00 100.00 0
61,440 3.00 619,072.56 0.00 100.00 0
81,920 4.00 619,072.56 0.00 100.00 0
122,880 6.00 619,072.56 0.00 100.00 0
163,840 8.00 619,072.56 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,648 0.70 276 12,697 1,944,214 1.00 6,240 4.92 118,851,775
1,888 0.80 485 16,292 1,948,471 1.00 1,983 1.56 119,085,021
2,128 0.90 724 19,900 1,949,127 1.00 1,327 1.05 119,123,704
2,368 1.00 962 25,456 1,949,185 1.00 1,269 1.00 119,127,695
2,608 1.10 1,113 30,255 1,949,185 1.00 1,269 1.00 119,127,770
2,848 1.20 1,147 32,872 1,949,185 1.00 1,269 1.00 119,127,777
3,088 1.30 1,147 32,872 1,949,185 1.00 1,269 1.00 119,127,777
3,328 1.41 1,147 32,872 1,949,185 1.00 1,269 1.00 119,127,777
3,568 1.51 1,147 32,872 1,949,185 1.00 1,269 1.00 119,127,777
3,808 1.61 1,147 32,872 1,949,185 1.00 1,269 1.00 119,127,777
4,048 1.71 1,147 32,872 1,949,185 1.00 1,269 1.00 119,127,777
4,288 1.81 1,147 32,872 1,949,185 1.00 1,269 1.00 119,127,777
4,528 1.91 1,147 32,872 1,949,185 1.00 1,269 1.00 119,127,777
4,768 2.01 1,147 32,872 1,949,185 1.00 1,269 1.00 119,127,777

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 34,108  
10,240 0.50 34,108  
15,360 0.75 34,109  
20,480 1.00 34,103  
25,600 1.25 34,109  
30,720 1.50 34,109  
35,840 1.75 34,109  
40,960 2.00 34,110  

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 8 261 1,038 1.00 1,270 1.00 17,581
32 0.50 8 261 1,038 1.00 1,270 1.00 17,581
48 0.75 8 261 1,038 1.00 1,270 1.00 17,581
64 1.00 8 261 1,038 1.00 1,270 1.00 17,581
80 1.25 8 261 1,038 1.00 1,270 1.00 17,581
96 1.50 8 261 1,038 1.00 1,270 1.00 17,581
112 1.75 8 261 1,038 1.00 1,270 1.00 17,581
128 2.00 8 261 1,038 1.00 1,270 1.00 17,581

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 587,483 107 0
undo block 228,102 10 0
undo header 67,040 6 0
1st level bmb 6,300 0 0
file header block 92 0 2
segment header 2,223 0 0
2nd level bmb 529 0 0
extent map 8 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) 4,832 537 4,295 502 131 260.48
UL-User-defined 66,469 65,417 1,052 2,344 63 26.66
TX-Transaction (index contention) 29,068 29,068 0 26,467 20 0.75
RO-Multiple Object Reuse (fast object reuse) 261 261 0 29 9 296.55
HW-Segment High Water Mark 206,819 206,813 7 2,319 2 0.95
DV-Diana Versioning 22,848 22,848 0 200 1 6.25
TX-Transaction 1,108,246 1,108,356 0 1,797 1 0.66
SQ-Sequence Cache 36,975 36,975 0 2,915 1 0.37
FB-Format Block 35,369 35,369 0 588 0 0.36
TX-Transaction (allocate ITL entry) 183 183 0 105 0 0.95
PS-PX Process Reservation 1,864 1,543 320 28 0 0.00
CU-Cursor 7,371 7,372 0 3 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,492.55 1,094,936 2,636 274   0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

End Time Num Undo Blocks Number of Transactions Max Qry Len (s) Max Tx Concy Tun Ret (mins) STO/ OOS uS/uR/uU/ eS/eR/eU
06-Aug 12:20 185,629 139,520 768 273 194 0/0 0/0/0/0/0/0
06-Aug 12:10 325,894 147,219 634 271 196 0/0 0/0/0/0/0/0
06-Aug 12:00 389,742 209,508 2,636 271 225 0/0 0/0/0/0/0/0
06-Aug 11:50 195,532 168,790 2,031 272 308 0/0 0/0/0/0/0/0
06-Aug 11:40 280,825 315,628 1,720 272 365 0/0 0/0/0/0/0/0
06-Aug 11:30 114,928 114,271 1,777 274 746 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,459 0.00   0 0  
AWR Alerted Metric Element list 249,420 0.00   0 0  
Consistent RBA 683,808 0.02 0.08 0 0  
FOB s.o list latch 45,866 0.03 0.00 0 0  
In memory undo latch 641,398,988 2.66 0.00 10 991,401 0.00
JOX SGA heap latch 1,864,730 0.00   0 0  
JS queue state obj latch 21,630 0.00   0 0  
JS slv state obj latch 180 0.00   0 0  
KMG MMAN ready and startup request latch 1,792 0.00   0 0  
KMG resize request state object freelist 18 0.00   0 0  
KTF sga latch 12 0.00   0 1,214 0.00
KWQMN job cache list latch 12,046 0.44 1.00 0 0  
MQL Tracking Latch 0     0 72 0.00
Memory Management Latch 755 0.00   0 1,783 0.00
OS process 11,748 0.00   0 0  
OS process allocation 9,041 0.00   0 0  
OS process: request allocation 7,564 0.00   0 0  
PL/SQL warning settings 3,553,931 0.00   0 0  
SGA IO buffer pool latch 32,552 0.02 0.00 0 32,678 0.48
SQL memory manager latch 1 0.00   0 1,199 0.00
SQL memory manager workarea list latch 5,373,079 0.01 0.02 0 0  
Shared B-Tree 129 0.00   0 0  
active checkpoint queue latch 1,399,954 0.58 0.00 0 2 0.00
active service list 38,290 0.15 0.00 0 1,244 0.00
begin backup scn array 153 0.00   0 0  
buffer pool 18 0.00   0 0  
cache buffer handles 21,705,551 1.80 0.00 0 0  
cache buffers chains 4,340,869,064 1.56 0.03 157 17,299,319 2.70
cache buffers lru chain 9,325,624 0.61 0.03 2 33,983,593 0.79
cache table scan latch 1,956 0.05 0.00 0 1,956 0.00
channel handle pool latch 292,539 0.08 0.05 0 0  
channel operations parent latch 1,286,979 0.53 0.00 0 0  
checkpoint queue latch 19,527,978 0.02 0.01 0 3,010,461 0.04
client/application info 1,307,022 0.01 0.00 0 0  
commit callback allocation 62,843 0.00   0 0  
compile environment latch 2,234,169 0.00   0 0  
dictionary lookup 72 0.00   0 0  
dml lock allocation 3,314,044 0.43 0.01 0 0  
dummy allocation 15,131 0.64 0.00 0 0  
enqueue hash chains 7,402,536 0.19 0.00 0 403 0.25
enqueues 3,960,176 0.21 0.01 0 0  
error message lists 816 5.64 0.00 0 0  
event group latch 3,786 0.00   0 0  
file cache latch 20,003 0.00   0 0  
global KZLD latch for mem in SGA 7,052 0.00   0 0  
global ctx hash table latch 17,151 0.00   0 0  
hash table column usage latch 2,378 0.08 0.00 0 11,024,198 0.00
hash table modification latch 149 0.00   0 0  
internal temp table object number allocation latc 3 0.00   0 0  
job workq parent latch 0     0 122 0.00
job_queue_processes parameter latch 121 0.00   0 0  
kks stats 23,732 0.02 0.00 0 0  
ksuosstats global area 243 0.00   0 0  
ktm global data 108,703 0.00   0 0  
kwqbsn:qsga 129 0.00   0 0  
lgwr LWN SCN 687,481 0.09 0.00 0 0  
library cache 269,240,342 0.63 0.01 12 17,369 0.83
library cache load lock 9,922 0.95 0.00 0 21 0.00
library cache lock 42,996,902 0.09 0.01 0 2 0.00
library cache lock allocation 1,133,989 0.01 0.03 0 0  
library cache pin 168,101,827 0.26 0.01 3 31 0.00
library cache pin allocation 400,188 0.00 0.00 0 0  
list of block allocation 412,554 0.01 0.00 0 0  
loader state object freelist 226,724 0.01 0.00 0 0  
longop free list parent 33 0.00   0 33 0.00
message pool operations parent latch 296,589 0.02 0.04 0 0  
messages 6,062,608 0.45 0.01 0 0  
mostly latch-free SCN 770,602 7.56 0.00 0 0  
multiblock read objects 35,942 0.00 0.00 0 0  
ncodef allocation latch 91 0.00   0 0  
object queue header heap 3,944,188 0.03 0.31 0 303,854 0.10
object queue header operation 30,587,160 0.17 0.34 3 17,450 0.02
object stats modification 290,708 0.03 0.00 0 0  
parallel query alloc buffer 8,160 2.11 0.00 0 0  
parallel query stats 528 23.48 0.06 0 0  
parameter table allocation management 17,439 1.01 0.54 0 0  
post/wait queue 976,493 0.05 0.01 0 397,254 0.02
process allocation 7,612 0.07 1.00 0 3,786 0.00
process group creation 7,564 0.00   0 0  
process queue 5,030 1.77 0.00 0 0  
process queue reference 773,217 0.07 0.00 0 81,605 0.45
qmn task queue latch 516 0.00   0 0  
query server freelists 4,256 9.28 0.00 0 0  
query server process 8 0.00   0 8 0.00
redo allocation 4,757,000 5.91 0.01 1 96,369,158 3.25
redo copy 0     0 96,710,901 0.04
redo writing 3,907,616 0.32 0.01 0 0  
resmgr group change latch 604,537 0.00   0 0  
resmgr:actses active list 22,151 0.30 0.98 0 0  
resmgr:actses change group 21,540 0.00   0 0  
resmgr:free threads list 15,129 0.63 0.00 0 0  
resmgr:schema config 1 0.00   0 0  
row cache objects 92,216,684 0.36 0.00 1 7,161 0.22
rules engine aggregate statistics 30,613 0.06 0.00 0 0  
rules engine rule set statistics 99,558 0.03 0.00 0 0  
rules engine rule statistics 38,342 0.00   0 0  
sequence cache 15,770,751 1.23 0.00 0 0  
session allocation 15,604,087 0.74 0.01 1 0  
session idle bit 73,211,879 0.03 0.02 0 0  
session state list latch 43,280 0.17 0.20 0 0  
session switching 10,631 0.00   0 0  
session timer 1,244 0.00   0 0  
shared pool 6,269,292 0.24 0.05 0 0  
shared pool sim alloc 338 0.30 0.00 0 0  
shared pool simulator 2,150,906 0.00 0.05 0 0  
sim partition latch 1 0.00   0 21,157 0.13
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,002,694 0.11 0.02 0 0  
state object free list 12 0.00   0 0  
statistics aggregation 84 0.00   0 0  
temp lob duration state obj allocation 239 0.00   0 0  
temporary table state object allocation 9,140 0.01 0.00 0 0  
threshold alerts latch 605 0.00   0 0  
trace latch 20 0.00   0 0  
transaction allocation 84,586 0.00 0.00 0 0  
transaction branch allocation 91 0.00   0 0  
undo global data 854,806,960 3.16 0.00 11 9,482 0.14
user lock 28,324 0.01 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,340,869,064 67,894,532 1,917,522 66,151,434 0 0 0
undo global data 854,806,960 27,007,968 14,809 26,994,799 0 0 0
In memory undo latch 641,398,988 17,082,023 29,040 17,056,287 0 0 0
library cache 269,240,342 1,685,882 12,161 1,674,798 0 0 0
library cache pin 168,101,827 439,181 3,104 436,347 0 0 0
cache buffer handles 21,705,551 390,850 316 390,574 0 0 0
row cache objects 92,216,684 329,795 1,512 328,352 0 0 0
redo allocation 4,757,000 281,245 2,220 279,289 0 0 0
sequence cache 15,770,751 194,524 142 194,397 0 0 0
session allocation 15,604,087 115,255 1,359 114,005 0 0 0
mostly latch-free SCN 770,602 58,264 136 58,139 0 0 0
cache buffers lru chain 9,325,624 56,432 1,944 54,574 0 0 0
object queue header operation 30,587,160 51,914 17,550 35,448 0 0 0
library cache lock 42,996,902 37,231 217 37,024 0 0 0
messages 6,062,608 27,285 273 27,012 0 0 0
session idle bit 73,211,879 24,390 501 23,907 0 0 0
shared pool 6,269,292 15,050 682 14,434 0 0 0
dml lock allocation 3,314,044 14,104 121 13,990 0 0 0
enqueue hash chains 7,402,536 14,084 38 14,049 0 0 0
redo writing 3,907,616 12,415 90 12,325 0 0 0
enqueues 3,960,176 8,500 98 8,405 0 0 0
active checkpoint queue latch 1,399,954 8,108 36 8,072 0 0 0
channel operations parent latch 1,286,979 6,784 26 6,760 0 0 0
checkpoint queue latch 19,527,978 4,035 26 4,009 0 0 0
sort extent pool 1,002,694 1,139 19 1,121 0 0 0
object queue header heap 3,944,188 1,084 333 782 0 0 0
lgwr LWN SCN 687,481 621 1 620 0 0 0
process queue reference 773,217 536 1 518 0 0 0
SQL memory manager workarea list latch 5,373,079 535 10 527 0 0 0
post/wait queue 976,493 477 7 470 0 0 0
channel handle pool latch 292,539 228 12 217 0 0 0
parameter table allocation management 17,439 176 95 92 0 0 0
parallel query stats 528 124 7 117 0 0 0
Consistent RBA 683,808 122 10 114 0 0 0
library cache lock allocation 1,133,989 114 3 111 0 0 0
shared pool simulator 2,150,906 103 5 100 0 0 0
session state list latch 43,280 75 15 62 0 0 0
resmgr:actses active list 22,151 66 65 2 0 0 0
message pool operations parent latch 296,589 54 2 52 0 0 0
KWQMN job cache list latch 12,046 53 53 2 0 0 0
process allocation 7,612 5 5 0 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch Name Where NoWait Misses Sleeps Waiter Sleeps
In memory undo latch kturbk 0 17,289 19,830
In memory undo latch ktiFlush: child 0 6,890 4,007
In memory undo latch kticmt: child 0 3,469 714
In memory undo latch ktichg: child 0 1,081 4,388
In memory undo latch ktiTxnPoolFree 0 264 0
In memory undo latch ktiBRacquire 0 21 0
In memory undo latch ktbgfc 0 7 84
KWQMN job cache list latch kwqmnuji: update job item 0 53 4
SQL memory manager workarea list latch qesmmIRegisterWorkArea 0 6 5
SQL memory manager workarea list latch qesmmIUnRegisterWorkArea 0 4 5
active checkpoint queue latch kcbbacq: scan active checkpoints 0 36 36
cache buffer handles kcbzgs 0 208 178
cache buffer handles kcbzfs 0 108 138
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 1,913,680 2,197,272
cache buffers chains kcbchg: kslbegin: call CR func 0 855,016 1,486,349
cache buffers chains kcbgtcr: fast path 0 677,149 51,250
cache buffers chains kcbgtcr: kslbegin excl 0 396,630 290,341
cache buffers chains kcbzgb: scan from tail. nowait 0 190,793 0
cache buffers chains kcbrls: kslbegin 0 190,263 319,541
cache buffers chains kcbgcur: kslbegin 0 64,147 31,610
cache buffers chains kcbget: pin buffer 0 30,954 12,090
cache buffers chains kcbget: exchange 0 15,709 20,677
cache buffers chains kcbget: exchange rls 0 14,352 15,986
cache buffers chains kcbzwb 0 13,324 10,200
cache buffers chains kcbcge 0 3,727 7,748
cache buffers chains kcbnlc 0 2,482 2,253
cache buffers chains kcbso1: set no access 0 594 188
cache buffers chains kcbbxsv 0 553 534
cache buffers chains kcbgtcr: kslbegin shared 0 230 189
cache buffers chains kcb_is_private 0 171 2,466
cache buffers chains kcbesc: escalate 0 141 49
cache buffers chains kcbnew: new latch again 0 61 6
cache buffers chains kcb_pre_apply: kcbhq61 0 39 1,405
cache buffers chains kcbbic2 0 23 6
cache buffers chains kcb_post_apply: kcbhq63 0 16 240
cache buffers chains kcbzhngcbk1: get hash chain latch no wait 0 8 0
cache buffers chains kcb_post_apply: kcbhq62 0 4 225
cache buffers chains kcbzib: multi-block read: nowait 0 3 0
cache buffers chains kcbrlb1 0 2 15
cache buffers chains kcbw_next_free 0 2 0
cache buffers chains kcbbic1 0 1 7
cache buffers chains kcbgkcbcr 0 1 5
cache buffers chains kcbo_ivd_process 0 1 12
cache buffers chains kcbzib: finish free bufs 0 1 6
cache buffers lru chain kcbzgws 0 848 0
cache buffers lru chain kcbo_link_q 0 377 33
cache buffers lru chain kcbbxsv: move to being written 0 289 665
cache buffers lru chain kcbgtcr:CR Scan:KCBRSKIP 0 213 0
cache buffers lru chain kcbzgb: posted for free bufs 0 96 393
cache buffers lru chain kcbo_ivd_proc 0 38 345
cache buffers lru chain kcbzswcu 0 38 77
cache buffers lru chain kcbbic2 0 37 390
cache buffers lru chain kcbzib 0 3 2
cache buffers lru chain kcbzfw 0 2 1
cache buffers lru chain kcbzar: KSLNBEGIN 0 1 0
cache buffers lru chain kcbzgm 0 1 0
cache buffers lru chain kcbzgpwb: KSLBEGIN use prewarm buffers 0 1 22
channel handle pool latch ksrchconnect() 0 34 28
channel handle pool latch ksrchdelete() 0 3 12
channel operations parent latch ksrapublish() 0 22 14
channel operations parent latch ksrchdelete() 0 14 18
channel operations parent latch ksrmfree() 0 14 2
channel operations parent latch ksrchconnect() 0 6 5
channel operations parent latch ksrsconsume() 0 5 5
channel operations parent latch ksrwait() 0 5 22
checkpoint queue latch kcbbwthc: thread checkpoint buffers 0 11 7
checkpoint queue latch kcbkubc 0 10 15
checkpoint queue latch kcbklbc: Link buffer into ckpt queue 0 4 2
checkpoint queue latch kcbswcu: Switch buffers 0 1 2
dml lock allocation ktaiam 0 74 71
dml lock allocation ktaidm 0 47 50
enqueue hash chains ksqgtl3 0 19 20
enqueue hash chains ksqrcl 0 17 16
enqueue hash chains ksqcmi: get hash chain latch after wait 0 1 1
enqueue hash chains ksqcmi: kslgpl 0 1 1
enqueues ksqgel: create enqueue 0 45 22
enqueues ksqies 0 31 73
enqueues ksqdel 0 22 3
lgwr LWN SCN kcs023 0 34 0
library cache kglpndl: child: after processing 0 4,941 345
library cache kglpnp: child 0 4,260 5,926
library cache kglobpn: child: 0 1,183 1,677
library cache kglpndl: child: before processing 0 701 3,387
library cache kglLockCursor 0 286 393
library cache kglScanDependency 0 199 1
library cache kglpin 0 111 49
library cache kgldte: child 0 0 107 184
library cache kglhdgn: child: 0 91 149
library cache kgldti: 2child 0 15 1
library cache kglic 0 15 0
library cache kglhdgc: child: 0 7 3
library cache kglivl: child 0 4 0
library cache kglhdiv: child 0 3 0
library cache kglobld 0 2 2
library cache kglrtl 0 2 0
library cache kglupd: child 0 2 0
library cache kglati 0 1 0
library cache kgldrp: child 0 1 0
library cache kglget: unpin heap 0 0 1 2
library cache kglukp: child 0 1 1
library cache lock kgllkdl: child: cleanup 0 127 119
library cache lock kgllkal: child: multiinstance 0 90 98
library cache lock kgllkdl: child: no lock handle 0 90 23
library cache lock allocation kgllkget 0 3 3
library cache pin kglpndl 0 1,507 1,080
library cache pin kglpnp: child 0 1,327 1,570
library cache pin kglpnal: child: alloc space 0 270 454
message pool operations parent latch ksrmalloc() 0 4 1
messages ksarcv: after wait 0 127 200
messages ksarcv 0 121 21
messages ksaamb: after wakeup 0 25 52
mostly latch-free SCN kcslcu3 0 102 137
mostly latch-free SCN kcs01 0 5 10
mostly latch-free SCN kcsnew_scn_rba 0 5 0
mostly latch-free SCN kcs024 0 1 0
object queue header heap kcbo_link_q:reget 0 326 3
object queue header heap kcbw_unlink_q 0 4 0
object queue header heap kcbw_link_q:alloc 0 3 334
object queue header operation kcbo_ivbo 0 17,069 3,740
object queue header operation kcbw_link_q 0 4,332 1,761
object queue header operation kcbw_unlink_q 0 1,172 5,418
object queue header operation kcbo_switch_mq_bg 0 677 3,024
object queue header operation kcbo_switch_q_bg 0 564 1,616
object queue header operation kcbo_switch_cq 0 178 3,296
object queue header operation kcbo_link_q:reget 0 54 104
object queue header operation kcbo_write_q 0 28 11
object queue header operation kcbo_service_ockpt 0 26 1
object queue header operation kcbo_swap_buf 0 19 511
object queue header operation kcbo_swap_buf_bg 0 17 4,733
object queue header operation kcbw_unlink_q_bg 0 2 16
parallel query stats kxfprst: KSLBEGIN:1 0 7 7
parameter table allocation management ksp_param_table_free 0 95 95
post/wait queue ksliwat:remove 0 6 4
post/wait queue kslpstevent:get 0 1 1
process allocation ksucrp 0 5 0
process queue reference kxfpqrsnd 0 1 0
redo allocation kcrfw_redo_gen: redo allocation 1 0 1,546 0
redo allocation kcrfw_redo_gen: redo allocation 3 0 446 1,818
redo allocation kcrfw_redo_gen: redo allocation 2 0 165 0
redo allocation kcrfw_redo_write: more space 0 35 252
redo allocation kcrfw_redo_write: before write 0 27 161
redo writing kcrfwcr 0 58 85
redo writing kcrfw_post: rba scn pair 0 21 0
redo writing kcrfw_post: after write 0 9 4
redo writing kcrfw_cal_target_rba 0 2 1
resmgr:actses active list kgskchclass 0 65 30
row cache objects kqreqd: reget 0 1,171 18
row cache objects kqrpre: find obj 0 231 949
row cache objects kqreqd 0 108 543
row cache objects kqrso 0 2 2
sequence cache kdnssd 0 107 8
sequence cache kdnnxt: cached seq 0 30 4
sequence cache kdnss 0 5 130
session allocation ksuxds: KSUSFCLC not set 0 481 149
session allocation ksuprc 0 280 271
session allocation ksuxds: not user session 0 156 160
session allocation ksucri 0 153 352
session allocation ksudlc 0 151 278
session allocation ksursi 0 45 78
session allocation kxfpqidqr 0 45 52
session allocation kspallmod 0 17 0
session allocation kxfprdp 0 17 13
session allocation ksudlp 0 16 7
session idle bit ksupuc: set busy 0 462 218
session idle bit ksupuc: clear busy 0 243 485
session idle bit ksuxds 0 30 32
session state list latch kpseqd 0 12 2
session state list latch kpscad 0 2 2
session state list latch kpscdl 0 1 2
shared pool kghupr1 0 355 476
shared pool kghalo 0 245 140
shared pool kghfrunp: clatch: nowait 0 120 0
shared pool kghfrunp: alloc: wait 0 39 0
shared pool kghfre 0 28 56
shared pool kghfrunp: clatch: wait 0 18 18
shared pool kghfrunp: alloc: session dur 0 8 5
shared pool kghalp 0 5 5
shared pool kgh: sim resz update 0 2 0
shared pool simulator kglsim_unpin_simhp 0 5 5
sort extent pool ktstdt: dealloc sort extent 0 17 0
sort extent pool ktstdt: return extent 0 1 3
sort extent pool ktstsmonmsg 0 1 21
undo global data kturimugur: child 0 11,174 8,366
undo global data ktudba: KSLBEGIN 0 3,503 6,401
undo global data ktudnx:child 0 35 17
undo global data ktufrbs: child 0 30 10
undo global data ktubnd:child 0 19 3
undo global data ktucof: at start 0 15 0
undo global data ktusmasp: ktugd_tuux 0 10 1
undo global data ktumof: KSLBEGIN 0 3 0

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 76,873,872 4.14
INV APPS_TS_TX_IDX MTL_ITEM_CATEGORIES_U1   INDEX 49,281,008 2.65
ONT APPS_TS_TX_DATA OE_ORDER_LINES_ALL   TABLE 22,447,104 1.21
WSH APPS_TS_TX_DATA WSH_DELIVERY_DETAILS   TABLE 20,659,232 1.11
GL APPS_TS_TX_DATA GL_CODE_COMBINATIONS   TABLE 19,225,296 1.03

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,063 8.04
AR APPS_ASSM_DATA RA_CUSTOMER_TRX_LINES_ALL   TABLE 12,979 2.98
WSH APPS_TS_TX_DATA WSH_DELIVERY_DETAILS   TABLE 9,557 2.19
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.93

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
APPLSYS APPS_TS_TX_IDX WF_ITEM_ACTIVITY_STATUSES_N1   INDEX 10,505 25.21
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_U1   INDEX 9,924 23.82
WSH APPS_TS_TX_DATA WSH_TRIP_STOPS   TABLE 8,326 19.98
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N6   INDEX 3,619 8.68
HR APPS_ASSM_IDX PAY_RUN_RESULT_VALUES_PK   INDEX 1,730 4.15

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 28 31.82
GL APPS_ASSM_IDX GL_IMPORT_REFERENCES_N1   INDEX 15 17.05
APPLSYS APPS_TS_TX_IDX WF_ITEM_ATTRIBUTE_VALUES_PK   INDEX 13 14.77
GL APPS_ASSM_IDX GL_IMPORT_REFERENCES_N3   INDEX 6 6.82
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N5   INDEX 6 6.82

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 189,225 37.84
APPLSYS APPS_TS_TX_DATA WF_ITEM_ATTRIBUTE_VALUES   TABLE 82,322 16.46
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N6   INDEX 29,850 5.97
AR APPS_TS_TX_INTERFACE RA_INTERFACE_LINES_ALL   TABLE 22,797 4.56
GL APPS_ASSM_DATA GL_JE_LINES   TABLE 19,431 3.89

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 600 46.83 0   600 0
dc_files 6,660 0.00 0   0 111
dc_global_oids 5,471,720 0.00 0   0 47
dc_histogram_data 5,700 10.98 0   0 606
dc_histogram_defs 317,000 3.37 0   4,011 4,122
dc_object_grants 51,175 0.10 0   0 74
dc_object_ids 9,179,345 0.02 0   53 1,302
dc_objects 134,500 1.34 0   311 836
dc_profiles 7,114 0.00 0   0 1
dc_rollback_segments 14,717 0.00 0   0 279
dc_segments 275,182 0.83 0   14,863 1,272
dc_sequences 46,379 0.14 0   46,379 110
dc_table_scns 16,814 0.05 0   0 5
dc_tablespace_quotas 14,733 0.18 0   214 45
dc_tablespaces 4,453,508 0.00 0   0 21
dc_usernames 369,053 0.00 0   0 25
dc_users 10,760,875 0.00 0   0 64
outstanding_alerts 268 16.42 0   1 43


Back to Top

 

Library Cache Activity

Namespace Get Requests Pct Miss Pin Requests Pct Miss Reloads Invali- dations
BODY 477,325 0.03 32,099,007 -0.02 11 0
CLUSTER 90 1.11 211 0.47 0 0
INDEX 11,142 0.54 11,935 0.73 0 0
JAVA DATA 616 0.00 0   0 0
PIPE 35,664 2.59 52,650 1.71 0 0
SQL AREA 5,632 89.31 90,756,464 0.50 2,746 384
TABLE/PROCEDURE 298,871 0.33 44,326,456 -0.05 1,022 0
TRIGGER 21,421 0.12 1,256,446 0.00 26 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 26,118.89   11.26 6.61 36 36 2,319 2,319
  SQL 2,491.92 1,276.09 1.08 0.69 4 22 2,311 2,310
  Freeable 2,487.56 0.00 1.24 0.76 9   2,008 2,008
  PL/SQL 1,667.92 141.43 0.72 0.92 3 3 2,319 2,319
  JAVA 187.06 186.25 2.23 0.31 4 7 84 84
E Other 32,550.38   13.99 8.55 40 40 2,327 2,327
  Freeable 3,200.50 0.00 1.54 0.95 9   2,079 2,079
  SQL 2,960.51 1,548.47 1.28 0.77 5 22 2,319 2,318
  PL/SQL 2,011.92 162.60 0.86 0.97 3 3 2,327 2,327
  JAVA 186.91 186.09 2.23 0.31 4 7 84 84

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions Begin Size (Bytes) End Size (Bytes) (if different)
Database Buffers 19,042,140,160 18,891,145,216
Fixed Size 2,111,120  
Redo Buffers 14,663,680  
Variable Size 2,415,921,520 2,566,916,464

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.10 36.15 6.03
shared KGLS heap 23.27   -100.00
shared KTI-UNDO 53.19 53.19 0.00
shared PL/SQL MPCODE 66.57 69.95 5.08
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 377.18 337.61 -10.49
shared library cache 611.83 753.56 23.16
shared parameter table block 42.10 42.15 0.10
shared private strands 99.77 99.77 0.00
shared sessions 36.42 36.42 0.00
shared sql area 303.36 347.61 14.59
shared trace buffer 36.27 36.58 0.86
  buffer_cache 18,160.00 18,016.00 -0.79
  fixed_sga 2.01 2.01 0.00
  log_buffer 13.98 13.98 0.00

Back to Memory Statistics
Back to Top

 

Streams Statistics

Back to Top

 

Streams CPU/IO Usage

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

Rule Set

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

 

 

Resource Limit Stats

No data exists for this section of the report.


Back to Top

 

init.ora Parameters

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


Back to Top

End of Report