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 16:10:16 3820 204.7
End Snap: 2 16-Oct-08 17:10:21 3836 238.0
Elapsed:   60.08 (mins)    
DB Time:   308.34 (mins)    

 

Report Summary

Cache Sizes

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

Load Profile

  Per Second Per Transaction
Redo size: 8,399,093.43 31,258.29
Logical reads: 505,590.93 1,881.62
Block changes: 51,797.99 192.77
Physical reads: 118.79 0.44
Physical writes: 805.22 3.00
User calls: 9,844.09 36.64
Parses: 1,954.72 7.27
Hard parses: 2.07 0.01
Sorts: 2,382.06 8.87
Logons: 2.10 0.01
Executes: 23,197.98 86.33
Transactions: 268.70  

% Blocks changed per Read: 10.25 Recursive Call %: 79.31
Rollback per transaction %: 19.22 Rows per Sort: 12.85

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.96 Redo NoWait %: 100.00
Buffer Hit %: 99.98 In-memory Sort %: 100.00
Library Hit %: 99.90 Soft Parse %: 99.89
Execute to Parse %: 91.57 Latch Hit %: 99.03
Parse CPU to Parse Elapsd %: 87.88 % Non-Parse CPU: 97.78

Shared Pool Statistics

  Begin End
Memory Usage %: 85.30 85.18
% SQL with executions>1: 90.63 90.95
% Memory for SQL w/exec>1: 68.27 69.53

Top 5 Timed Events

Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class
CPU time   16,836   91.0  
db file sequential read 254,039 985 4 5.3 User I/O
log file sync 400,441 635 2 3.4 Commit
log file parallel write 701,714 429 1 2.3 System I/O
db file parallel write 282,037 260 1 1.4 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 16,835.94 91.00
sql execute elapsed time 16,002.73 86.50
PL/SQL execution elapsed time 3,649.90 19.73
inbound PL/SQL rpc elapsed time 3,167.41 17.12
parse time elapsed 480.54 2.60
Java execution elapsed time 466.57 2.52
hard parse elapsed time 240.00 1.30
repeated bind elapsed time 60.17 0.33
sequence load elapsed time 11.40 0.06
connection management call elapsed time 7.75 0.04
PL/SQL compilation elapsed time 6.62 0.04
hard parse (sharing criteria) elapsed time 3.90 0.02
hard parse (bind mismatch) elapsed time 1.19 0.01
failed parse elapsed time 1.02 0.01
DB time 18,500.49  
background elapsed time 1,074.86  
background cpu time 320.53  

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 309,713 0.00 1,142 4 0.32
System I/O 1,014,644 0.00 699 1 1.05
Commit 400,441 0.00 635 2 0.41
Network 40,644,780 0.00 146 0 41.96
Application 50,491 0.05 112 2 0.05
Concurrency 1,484,598 0.26 110 0 1.53
Other 112,898 22.42 32 0 0.12
Configuration 6,587 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 254,039 0.00 985 4 0.26
log file sync 400,441 0.00 635 2 0.41
log file parallel write 701,714 0.00 429 1 0.72
db file parallel write 282,037 0.00 260 1 0.29
SQL*Net more data from client 1,852,194 0.00 98 0 1.91
db file scattered read 13,579 0.00 89 7 0.01
read by other session 39,046 0.00 66 2 0.04
enq: UL - contention 2,318 0.56 50 22 0.00
enq: TX - row lock contention 535 2.43 49 92 0.00
cursor: pin S wait on X 4,245 92.20 43 10 0.00
SQL*Net message to client 37,169,523 0.00 36 0 38.38
enq: TX - index contention 25,899 0.00 15 1 0.03
buffer busy waits 628,735 0.00 15 0 0.65
latch: cache buffers chains 791,630 0.00 13 0 0.82
library cache load lock 627 0.00 13 21 0.00
SQL*Net more data to client 1,623,063 0.00 13 0 1.68
PX Deq Credit: send blkd 23,697 0.00 11 0 0.02
control file sequential read 29,155 0.00 9 0 0.03
SQL*Net break/reset to client 47,604 0.00 8 0 0.05
rdbms ipc reply 5 60.00 7 1319 0.00
enq: RO - fast object reuse 31 0.00 6 182 0.00
latch: In memory undo latch 21,070 0.00 4 0 0.02
PX Deq: Signal ACK 291 34.36 3 11 0.00
kksfbc child completion 82 79.27 3 40 0.00
latch: library cache 6,289 0.00 3 0 0.01
os thread startup 69 0.00 2 29 0.00
log buffer space 205 0.00 2 9 0.00
latch: undo global data 9,011 0.00 2 0 0.01
enq: HW - contention 2,419 0.00 2 1 0.00
LGWR wait for redo copy 28,306 0.00 1 0 0.03
control file parallel write 1,738 0.00 1 1 0.00
local write wait 1,819 0.00 1 1 0.00
latch: object queue header operation 12,091 0.00 1 0 0.01
enq: TX - contention 2,740 0.00 1 0 0.00
latch: library cache pin 1,562 0.00 1 0 0.00
enq: DV - contention 176 0.00 1 3 0.00
latch: cache buffers lru chain 855 0.00 1 1 0.00
enq: SQ - contention 3,834 0.00 0 0 0.00
direct path read 732 0.00 0 1 0.00
wait list latch free 35 0.00 0 11 0.00
latch free 661 0.00 0 1 0.00
latch: row cache objects 493 0.00 0 1 0.00
buffer deadlock 25,187 98.90 0 0 0.03
latch: session allocation 530 0.00 0 0 0.00
SGA: allocation forcing component growth 23 56.52 0 11 0.00
library cache pin 1,402 0.00 0 0 0.00
latch: redo allocation 669 0.00 0 0 0.00
row cache lock 1,841 0.00 0 0 0.00
latch: shared pool 504 0.00 0 0 0.00
cursor: pin S 7,019 0.00 0 0 0.01
latch: library cache lock 97 0.00 0 1 0.00
enq: TM - contention 3 0.00 0 30 0.00
enq: FB - contention 654 0.00 0 0 0.00
latch: object queue header heap 128 0.00 0 0 0.00
PX qref latch 272 82.35 0 0 0.00
enq: TX - allocate ITL entry 86 0.00 0 1 0.00
latch: cache buffer handles 141 0.00 0 0 0.00
library cache lock 3 0.00 0 10 0.00
reliable message 36 0.00 0 1 0.00
latch: messages 172 0.00 0 0 0.00
latch: redo writing 37 0.00 0 0 0.00
latch: checkpoint queue latch 32 0.00 0 0 0.00
cursor: mutex S 117 0.00 0 0 0.00
latch: enqueue hash chains 17 0.00 0 0 0.00
direct path write 440 0.00 0 0 0.00
enq: PS - contention 63 0.00 0 0 0.00
enq: US - contention 5 0.00 0 1 0.00
write complete waits 6 0.00 0 0 0.00
direct path write temp 45 0.00 0 0 0.00
cursor: mutex X 15 0.00 0 0 0.00
direct path read temp 13 0.00 0 0 0.00
SQL*Net message from client 37,169,495 0.00 7,414,695 199 38.38
pipe get 22,132 20.89 21,077 952 0.02
Streams AQ: waiting for time management or cleanup tasks 2,341 38.74 3,504 1497 0.00
Streams AQ: qmn slave idle wait 128 0.00 3,489 27255 0.00
Streams AQ: qmn coordinator idle wait 256 50.00 3,489 13627 0.00
PX Idle Wait 1,618 76.14 2,535 1567 0.00
PL/SQL lock timer 209 99.04 2,354 11262 0.00
jobq slave wait 605 99.67 1,769 2924 0.00
PX Deq: Execution Msg 5,074 0.00 42 8 0.01
PX Deq: Execute Reply 2,655 0.00 3 1 0.00
PX Deq Credit: need buffer 3,922 0.00 1 0 0.00
PX Deq: Msg Fragment 4,300 0.00 1 0 0.00
PX Deq: Table Q Normal 5,308 0.00 0 0 0.01
PX Deq: Parse Reply 264 0.00 0 0 0.00
PX Deq: Join ACK 271 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 701,725 0.00 429 1 0.72
db file parallel write 282,037 0.00 260 1 0.29
control file sequential read 827 0.00 3 4 0.00
events in waitclass Other 33,899 0.00 2 0 0.04
db file sequential read 993 0.00 2 2 0.00
os thread startup 61 0.00 2 29 0.00
db file scattered read 277 0.00 2 5 0.00
control file parallel write 1,738 0.00 1 1 0.00
direct path read 732 0.00 0 1 0.00
latch: cache buffers chains 76 0.00 0 1 0.00
latch: redo writing 37 0.00 0 0 0.00
direct path write 333 0.00 0 0 0.00
buffer busy waits 12 0.00 0 0 0.00
log file sync 1 0.00 0 1 0.00
latch: shared pool 3 0.00 0 0 0.00
latch: library cache 1 0.00 0 0 0.00
latch: In memory undo latch 1 0.00 0 0 0.00
rdbms ipc message 1,613,115 0.75 36,936 23 1.67
pmon timer 1,305 92.57 3,511 2690 0.00
smon timer 117,236 0.00 3,508 30 0.12
Streams AQ: waiting for time management or cleanup tasks 2,341 38.74 3,504 1497 0.00
Streams AQ: qmn slave idle wait 128 0.00 3,489 27255 0.00
Streams AQ: qmn coordinator idle wait 256 50.00 3,489 13627 0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic Total
BUSY_TIME 1,806,351
IDLE_TIME 3,961,222
IOWAIT_TIME 76,261
NICE_TIME 0
SYS_TIME 76,451
USER_TIME 1,683,922
LOAD 3
RSRC_MGR_CPU_WAIT_TIME 0
PHYSICAL_MEMORY_BYTES 64,691,772
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 18,499.80 16,835.40 414,898 1,819,497,826
SYS$BACKGROUND 0.00 0.00 13,422 2,974,512
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 307363 113785 1484436 10788 0 0 40633285 14594
SYS$BACKGROUND 2340 374 154 181 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
694 689 304 2.28 3.75 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
363 361 55,047 0.01 1.96 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
324 297 78,524 0.00 1.75 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
318 317 55,043 0.01 1.72 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...
288 288 55,045 0.01 1.56 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
281 257 141,882 0.00 1.52 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
244 241 61,309 0.00 1.32 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
231 230 259,826 0.00 1.25 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
222 219 1,009 0.22 1.20 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
194 172 186,474 0.00 1.05 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
193 85 1,683 0.11 1.04 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....

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
689 694 304 2.27 3.75 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
361 363 55,047 0.01 1.96 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
317 318 55,043 0.01 1.72 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...
297 324 78,524 0.00 1.75 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
288 288 55,045 0.01 1.56 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
257 281 141,882 0.00 1.52 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
241 244 61,309 0.00 1.32 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
230 231 259,826 0.00 1.25 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
219 222 1,009 0.22 1.20 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
172 194 186,474 0.00 1.05 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
85 193 1,683 0.05 1.04 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....

Back to SQL Statistics
Back to Top

SQL ordered by Gets

Buffer Gets Executions Gets per Exec %Total CPU Time (s) Elapsed Time (s) SQL Id SQL Module SQL Text
53,359,867 141,882 376.09 2.93 257.18 280.88 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
51,818,331 186,474 277.89 2.84 171.69 193.91 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
51,140,929 155,039 329.86 2.81 138.24 138.57 5kqw5535fjvw6 ARXTWMAI SELECT NVL(RCTT.ATTRIBUTE10, ...
46,793,742 55,047 850.07 2.57 361.13 362.53 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
41,836,630 304 137,620.49 2.30 689.14 693.65 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
30,997,073 55,045 563.12 1.70 287.83 288.39 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
28,280,579 1,383,944 20.43 1.55 104.99 105.26 66tmsr3446uqn ap.oie.server.WebExpensesAM SELECT WIAS.ACTIVITY_STATUS, ...
27,602,516 166,869 165.41 1.51 138.89 139.02 3b3psftuyks81 INVTTMTX BEGIN INV_TXNSTUB_PUB.postTran...
27,599,838 166,865 165.40 1.51 128.42 128.52 gf1u933c95jb5 INVTTMTX DECLARE l_ret_stat varchar2...
26,399,748 10,000 2,639.97 1.45 82.22 169.06 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
23,437,890 61,309 382.29 1.29 241.35 244.03 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
23,072,718 55,043 419.18 1.27 316.99 317.88 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,238 10,000 4.52 10.56 82.22 169.06 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
39,461 1,683 23.45 9.22 11.18 175.16 3dssuqfjsynrk asn.lead.server.LeadUwqAM SELECT count(1) FROM (SELECT *...
26,928 1,683 16.00 6.29 85.44 192.56 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
19,912 15,135 1.32 4.65 113.06 179.59 1q78dwnrrkf6c asn.lead.server.LeadUwqAM BEGIN ASN_SALES_PVT.Lead_Proce...
11,228 186,474 0.06 2.62 171.69 193.91 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
9,704 504 19.25 2.27 59.33 93.38 dk0sqcvc2xjvs qotSCopHdrUpd.jsp BEGIN ASO_QUOTE_PUB_W.Create_Q...
8,315 5,048 1.65 1.94 82.14 114.32 8jb36w62w5hqf ibuSRDetailsActions.jsp BEGIN IBU_REQ_PKG.UpdateServic...
8,270 141,882 0.06 1.93 257.18 280.88 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
4,592 10,000 0.46 1.07 125.67 136.66 csvvv0fmhr1yc PYUSLV BEGIN FFP1893_01010001.FORMULA...
4,504 10,000 0.45 1.05 104.03 112.84 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,383,944 716,434 0.52 0.00 0.00 66tmsr3446uqn ap.oie.server.WebExpensesAM SELECT WIAS.ACTIVITY_STATUS, ...
788,541 788,542 1.00 0.00 0.00 cd9mbmqyf4qhp ap.oie.server.WebExpensesAM UPDATE WF_ITEM_ACTIVITY_STATUS...
419,285 419,281 1.00 0.00 0.00 avc1jqzz04wpr JDBC Thin Client SELECT 'x' FROM DUAL
259,826 259,821 1.00 0.00 0.00 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
259,067 202,173 0.78 0.00 0.00 fmfdkztk8vx23   SELECT CATEGORY, SEVERITY, F...
203,869 3,465,682 17.00 0.00 0.00 cwyx16zn1hpfb JDBC Thin Client select parameter, value from ...
186,474 0 0.00 0.00 0.00 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
166,869 166,869 1.00 0.00 0.00 3b3psftuyks81 INVTTMTX BEGIN INV_TXNSTUB_PUB.postTran...
166,868 166,868 1.00 0.00 0.00 6gnth2mfbs2nq INVTTMTX declare v_ret number := 0...
166,865 166,865 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,285 419,285 5.95 avc1jqzz04wpr JDBC Thin Client SELECT 'x' FROM DUAL
259,823 259,826 3.69 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
259,066 259,067 3.68 fmfdkztk8vx23   SELECT CATEGORY, SEVERITY, F...
203,871 203,869 2.89 cwyx16zn1hpfb JDBC Thin Client select parameter, value from ...
166,870 166,868 2.37 6gnth2mfbs2nq INVTTMTX declare v_ret number := 0...
141,882 141,882 2.01 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
117,685 117,685 1.67 fb13x9qx0ftks OEXOETEL begin OE_STANDARD_WF.OEOL_SELE...
111,820 111,820 1.59 1c0b7sas42w2z INVTTMTX SELECT NVL(ITEM_COST, 0), ...
88,961 88,959 1.26 76sw2a4vnc89j icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.S...
84,746 84,742 1.20 608c0n36kaw62 icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.C...
84,746 84,746 1.20 bf7uwg5pa3pj6 icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.V...
84,746 88,961 1.20 dcvv68fju01g4 icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.E...
84,308 84,308 1.20 162ttnv4ubqun OEXOETEL begin OE_DS_PVT.Check_PO_Appr...
77,988 77,988 1.11 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;
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,667,821 462.70 1.72
CPU used when call started 1,664,412 461.75 1.72
CR blocks created 14,410,084 3,997.75 14.88
Cached Commit SCN referenced 46,446 12.89 0.05
Commit SCN cached 8 0.00 0.00
DB time 4,532,837 1,257.53 4.68
DBWR checkpoint buffers written 2,820,332 782.44 2.91
DBWR checkpoints 34 0.01 0.00
DBWR object drop buffers written 57,713 16.01 0.06
DBWR revisited being-written buffer 134 0.04 0.00
DBWR thread checkpoint buffers written 973,137 269.97 1.00
DBWR transaction table writes 1,836 0.51 0.00
DBWR undo block writes 1,520,066 421.71 1.57
DFO trees parallelized 48 0.01 0.00
IMU CR rollbacks 31,579,928 8,761.13 32.61
IMU Flushes 291,645 80.91 0.30
IMU Redo allocation size 2,015,213,732 559,075.29 2,080.67
IMU commits 507,084 140.68 0.52
IMU contention 31,861 8.84 0.03
IMU ktichg flush 8,472 2.35 0.01
IMU pool not allocated 0 0.00 0.00
IMU recursive-transaction flush 1,500 0.42 0.00
IMU undo allocation size 4,616,342,328 1,280,699.36 4,766.28
IMU- failed to get a private strand 0 0.00 0.00
PX local messages recv'd 51,678 14.34 0.05
PX local messages sent 51,678 14.34 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,162,791 10,309.97 38.37
active txn count during cleanout 92,278,235 25,600.50 95.28
application wait time 11,232 3.12 0.01
background checkpoints completed 3 0.00 0.00
background checkpoints started 2 0.00 0.00
background timeouts 13,907 3.86 0.01
branch node splits 1,011 0.28 0.00
buffer is not pinned count 550,898,041 152,834.15 568.79
buffer is pinned count 1,388,844,373 385,303.34 1,433.96
bytes received via SQL*Net from client 8,234,064,881 2,284,354.34 8,501.51
bytes sent via SQL*Net to client 7,712,180,053 2,139,569.25 7,962.68
calls to get snapshot scn: kcmgss 93,563,029 25,956.94 96.60
calls to kcmgas 18,155,619 5,036.86 18.75
calls to kcmgcs 12,978,204 3,600.51 13.40
change write time 41,496 11.51 0.04
cleanout - number of ktugct calls 25,751,841 7,144.26 26.59
cleanouts and rollbacks - consistent read gets 12,363,341 3,429.93 12.76
cleanouts only - consistent read gets 132,940 36.88 0.14
cluster key scan block gets 813,120 225.58 0.84
cluster key scans 229,975 63.80 0.24
commit batch/immediate performed 3,668 1.02 0.00
commit batch/immediate requested 3,668 1.02 0.00
commit cleanout failures: block lost 212,664 59.00 0.22
commit cleanout failures: buffer being written 666 0.18 0.00
commit cleanout failures: callback failure 102,637 28.47 0.11
commit cleanout failures: cannot pin 31,111 8.63 0.03
commit cleanouts 8,181,309 2,269.72 8.45
commit cleanouts successfully completed 7,834,231 2,173.43 8.09
commit immediate performed 3,668 1.02 0.00
commit immediate requested 3,668 1.02 0.00
commit txn count during cleanout 1,221,080 338.76 1.26
concurrency wait time 10,968 3.04 0.01
consistent changes 681,910,304 189,180.53 704.06
consistent gets 1,609,691,516 446,572.36 1,661.98
consistent gets - examination 1,122,530,192 311,420.51 1,158.99
consistent gets from cache 1,609,691,561 446,572.37 1,661.98
cursor authentications 1,901 0.53 0.00
data blocks consistent reads - undo records applied 678,760,909 188,306.80 700.81
db block changes 186,708,347 51,797.99 192.77
db block gets 212,738,098 59,019.35 219.65
db block gets direct 4,180 1.16 0.00
db block gets from cache 212,733,918 59,018.20 219.64
deferred (CURRENT) block cleanout applications 1,413,836 392.24 1.46
dirty buffers inspected 8,769 2.43 0.01
enqueue conversions 8,304 2.30 0.01
enqueue releases 3,664,497 1,016.63 3.78
enqueue requests 3,669,895 1,018.13 3.79
enqueue timeouts 5,250 1.46 0.01
enqueue waits 32,558 9.03 0.03
exchange deadlocks 25,187 6.99 0.03
execute count 83,618,233 23,197.98 86.33
failed probes on index block reclamation 9,814 2.72 0.01
free buffer inspected 2,487,241 690.03 2.57
free buffer requested 18,544,521 5,144.76 19.15
heap block compress 29,515,420 8,188.38 30.47
hot buffers moved to head of LRU 1,063,401 295.02 1.10
immediate (CR) block cleanout applications 12,496,291 3,466.81 12.90
immediate (CURRENT) block cleanout applications 1,076,220 298.57 1.11
index crx upgrade (found) 13,055 3.62 0.01
index crx upgrade (positioned) 8,289,709 2,299.79 8.56
index fast full scans (rowid ranges) 792 0.22 0.00
index fetch by key 166,546,375 46,204.51 171.96
index scans kdiixs1 134,910,024 37,427.72 139.29
java call heap collected bytes 1,247,602,296 346,118.93 1,288.13
java call heap collected count 15,456,932 4,288.17 15.96
java call heap gc count 4,237 1.18 0.00
java call heap live object count 1,491,563 413.80 1.54
java call heap live object count max 1,535,163 425.90 1.59
java call heap live size 360,563,968 100,030.29 372.28
java call heap live size max 369,045,592 102,383.32 381.03
java call heap object count 3,582,265 993.82 3.70
java call heap object count max 3,595,274 997.43 3.71
java call heap total size 463,601,664 128,615.76 478.66
java call heap total size max 474,087,424 131,524.79 489.49
java call heap used size 495,372,920 137,429.97 511.46
java call heap used size max 501,298,752 139,073.96 517.58
leaf node 90-10 splits 19,172 5.32 0.02
leaf node splits 231,931 64.34 0.24
lob reads 16,701 4.63 0.02
lob writes 28,989 8.04 0.03
lob writes unaligned 28,989 8.04 0.03
logons cumulative 7,586 2.10 0.01
messages received 1,948,822 540.66 2.01
messages sent 1,948,822 540.66 2.01
no buffer to keep pinned count 16 0.00 0.00
no work - consistent read gets 444,596,714 123,343.26 459.04
opened cursors cumulative 4,491,852 1,246.16 4.64
parse count (failures) 2,520 0.70 0.00
parse count (hard) 7,448 2.07 0.01
parse count (total) 7,045,881 1,954.72 7.27
parse time cpu 37,367 10.37 0.04
parse time elapsed 42,521 11.80 0.04
physical read IO requests 268,299 74.43 0.28
physical read bytes 3,507,781,632 973,154.37 3,621.72
physical read total IO requests 297,564 82.55 0.31
physical read total bytes 3,986,358,272 1,105,924.59 4,115.84
physical read total multi block requests 13,572 3.77 0.01
physical reads 428,196 118.79 0.44
physical reads cache 427,061 118.48 0.44
physical reads cache prefetch 159,507 44.25 0.16
physical reads direct 1,135 0.31 0.00
physical reads direct temporary tablespace 403 0.11 0.00
physical reads prefetch warmup 92,872 25.77 0.10
physical write IO requests 1,079,647 299.52 1.11
physical write bytes 23,776,927,744 6,596,368.74 24,549.22
physical write total IO requests 2,127,683 590.28 2.20
physical write total bytes 55,436,521,984 15,379,604.32 57,237.15
physical write total multi block requests 1,226,409 340.24 1.27
physical writes 2,902,457 805.22 3.00
physical writes direct 4,916 1.36 0.01
physical writes direct (lob) 235 0.07 0.00
physical writes direct temporary tablespace 4,300 1.19 0.00
physical writes from cache 2,897,541 803.86 2.99
physical writes non checkpoint 2,232,511 619.36 2.31
pinned buffers inspected 2,587 0.72 0.00
prefetch clients - default 1 0.00 0.00
prefetch warmup blocks aged out before use 217,041 60.21 0.22
prefetched blocks aged out before use 121 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 136,017,154 37,734.87 140.44
recursive cpu usage 953,814 264.61 0.98
redo blocks written 61,668,246 17,108.45 63.67
redo buffer allocation retries 206 0.06 0.00
redo entries 96,227,941 26,696.26 99.35
redo log space requests 0 0.00 0.00
redo log space wait time 0 0.00 0.00
redo ordering marks 1,255,063 348.19 1.30
redo size 30,274,935,420 8,399,093.43 31,258.29
redo subscn max counts 2,232,762 619.43 2.31
redo synch time 65,502 18.17 0.07
redo synch writes 1,709,346 474.22 1.76
redo wastage 266,471,236 73,926.39 275.13
redo write time 46,577 12.92 0.05
redo writer latching time 167 0.05 0.00
redo writes 701,741 194.68 0.72
rollback changes - undo records applied 337,233 93.56 0.35
rollbacks only - consistent read gets 2,221,578 616.33 2.29
rows fetched via callback 87,380,160 24,241.64 90.22
session connect time 0 0.00 0.00
session cursor cache hits 4,537,145 1,258.73 4.68
session logical reads 1,822,426,758 505,590.93 1,881.62
session pga memory 8,887,556,744 2,465,650.82 9,176.23
session pga memory max 10,267,101,224 2,848,374.12 10,600.59
session uga memory ############### 74,747,862.32 278,183.64
session uga memory max 55,906,783,792 15,510,067.78 57,722.68
shared hash latch upgrades - no wait 28,828,259 7,997.75 29.76
shared hash latch upgrades - wait 27,260 7.56 0.03
sorts (memory) 8,586,245 2,382.06 8.87
sorts (rows) 110,330,350 30,608.65 113.91
sql area evicted 2,387 0.66 0.00
sql area purged 2,690 0.75 0.00
summed dirty queue length 188,238 52.22 0.19
switch current to new buffer 1,288,034 357.34 1.33
table fetch by rowid 821,500,242 227,906.59 848.18
table fetch continued row 32,585,566 9,040.13 33.64
table scan blocks gotten 54,906,488 15,232.56 56.69
table scan rows gotten 1,636,783,528 454,088.43 1,689.95
table scans (long tables) 2,056 0.57 0.00
table scans (rowid ranges) 2,054 0.57 0.00
table scans (short tables) 4,484,327 1,244.07 4.63
total number of times SMON posted 117,211 32.52 0.12
transaction rollbacks 3,668 1.02 0.00
transaction tables consistent read rollbacks 68 0.02 0.00
transaction tables consistent reads - undo records applied 8,256 2.29 0.01
undo change vector size 10,552,112,200 2,927,443.94 10,894.85
user I/O wait time 114,184 31.68 0.12
user calls 35,483,497 9,844.09 36.64
user commits 782,350 217.05 0.81
user rollbacks 186,191 51.65 0.19
workarea executions - onepass 2 0.00 0.00
workarea executions - optimal 4,892,993 1,357.45 5.05
write clones created in background 1,818 0.50 0.00
write clones created in foreground 4,308 1.20 0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistic Begin Value End Value
session cursor cache count 300,114 827,523
opened cursors current 781,921 913,020
workarea memory allocated 144 1,908
logons current 3,820 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 37 0 9.19 1.00 465,749 129 246,420 0.02
APPS_TS_TX_DATA 162,347 45 4.11 1.32 164,207 46 106,624 0.24
APPS_TS_TX_IDX 80,304 22 4.19 1.50 158,787 44 47,723 0.33
APPS_ASSM_DATA 8,590 2 2.02 6.66 133,470 37 35,340 0.48
APPS_ASSM_IDX 6,327 2 2.07 1.05 104,589 29 189,803 0.10
APPS_TS_TX_INTERFACE 1,106 0 1.94 2.19 25,147 7 18,574 0.02
TEMP 320 0 4.44 14.25 8,840 2 41 1.71
SYSTEM 5,243 1 4.04 3.12 2,237 1 19,925 0.04
APPS_TS_SEED 2,308 1 6.15 1.82 3,731 1 719 2.81
APPS_TS_SUMMARY 70 0 5.43 1.00 5,756 2 1,955 0.02
APPS_TS_QUEUES 1,109 0 2.98 1.53 4,085 1 585 0.14
SYSAUX 302 0 2.62 1.10 1,389 0 0 0.00
APPS_TS_ARCHIVE 49 0 5.10 1.43 1,604 0 70 3.14
APPS_TS_NOLOGGING 28 0 5.36 1.50 36 0 0 0.00
CTXSYS 24 0 8.75 1.00 6 0 0 0.00
APPS_TS_MEDIA 15 0 9.33 1.00 9 0 0 0.00
ODM 13 0 5.38 1.00 3 0 0 0.00
OLAP 13 0 6.92 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 5.83 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,590 2 2.02 6.66 133,470 37 35,340 0.48
APPS_ASSM_IDX /DB/visdata/apps_assm_idx.dbf 6,327 2 2.07 1.05 104,589 29 189,803 0.10
APPS_TS_ARCHIVE /DB/visdata/archive1.dbf 20 0 7.50 1.50 1,368 0 67 2.99
APPS_TS_ARCHIVE /DB/visdata/archive2.dbf 29 0 3.45 1.38 236 0 3 6.67
APPS_TS_MEDIA /DB/visdata/media1.dbf 5 0 8.00 1.00 3 0 0 0.00
APPS_TS_MEDIA /DB/visdata/media2.dbf 5 0 6.00 1.00 3 0 0 0.00
APPS_TS_MEDIA /DB/visdata/media3.dbf 5 0 14.00 1.00 3 0 0 0.00
APPS_TS_NOLOGGING /DB/visdata/nologging1.dbf 5 0 6.00 1.00 3 0 0 0.00
APPS_TS_NOLOGGING /DB/visdata/nologging2.dbf 16 0 3.75 1.00 19 0 0 0.00
APPS_TS_NOLOGGING /DB/visdata/nologging3.dbf 7 0 8.57 3.00 14 0 0 0.00
APPS_TS_QUEUES /DB/visdata/queues1.dbf 177 0 2.60 1.29 514 0 143 0.14
APPS_TS_QUEUES /DB/visdata/queues2.dbf 143 0 2.24 1.52 715 0 383 0.16
APPS_TS_QUEUES /DB/visdata/queues3.dbf 137 0 2.92 1.55 553 0 5 0.00
APPS_TS_QUEUES /DB/visdata/queues4.dbf 134 0 2.46 1.52 548 0 2 0.00
APPS_TS_QUEUES /DB/visdata/queues5.dbf 132 0 3.18 1.58 562 0 1 0.00
APPS_TS_QUEUES /DB/visdata/queues6.dbf 131 0 2.37 1.69 467 0 1 0.00
APPS_TS_QUEUES /DB/visdata/queues7.dbf 255 0 4.20 1.58 726 0 50 0.00
APPS_TS_SEED /DB/visdata/reference1.dbf 197 0 5.94 1.89 357 0 43 2.79
APPS_TS_SEED /DB/visdata/reference10.dbf 217 0 5.99 1.88 378 0 50 3.00
APPS_TS_SEED /DB/visdata/reference2.dbf 209 0 6.94 2.07 373 0 34 4.41
APPS_TS_SEED /DB/visdata/reference3.dbf 355 0 5.89 1.69 458 0 344 2.76
APPS_TS_SEED /DB/visdata/reference4.dbf 217 0 6.87 1.87 382 0 31 3.23
APPS_TS_SEED /DB/visdata/reference5.dbf 245 0 6.41 1.67 363 0 66 4.55
APPS_TS_SEED /DB/visdata/reference6.dbf 233 0 6.14 1.83 363 0 34 1.18
APPS_TS_SEED /DB/visdata/reference7.dbf 220 0 5.36 1.87 326 0 30 2.00
APPS_TS_SEED /DB/visdata/reference8.dbf 214 0 6.50 1.86 332 0 34 2.35
APPS_TS_SEED /DB/visdata/reference9.dbf 201 0 5.62 1.65 399 0 53 1.32
APPS_TS_SUMMARY /DB/visdata/summary1.dbf 6 0 8.33 1.00 675 0 279 0.04
APPS_TS_SUMMARY /DB/visdata/summary2.dbf 6 0 5.00 1.00 584 0 153 0.07
APPS_TS_SUMMARY /DB/visdata/summary3.dbf 12 0 6.67 1.00 611 0 154 0.00
APPS_TS_SUMMARY /DB/visdata/summary4.dbf 14 0 3.57 1.00 693 0 229 0.00
APPS_TS_SUMMARY /DB/visdata/summary5.dbf 8 0 5.00 1.00 703 0 311 0.00
APPS_TS_SUMMARY /DB/visdata/summary6.dbf 8 0 7.50 1.00 792 0 511 0.02
APPS_TS_SUMMARY /DB/visdata/summary7.dbf 8 0 3.75 1.00 907 0 153 0.00
APPS_TS_SUMMARY /DB/visdata/summary8.dbf 8 0 5.00 1.00 791 0 165 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data1.dbf 2,900 1 5.12 1.31 275 0 0 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data10.dbf 2,840 1 4.47 1.25 167 0 0 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data11.dbf 2,821 1 4.46 1.30 115 0 4 17.50
APPS_TS_TX_DATA /DB/visdata/tx_data12.dbf 12,361 3 2.73 1.23 2,108 1 2,925 1.02
APPS_TS_TX_DATA /DB/visdata/tx_data13.dbf 16,298 5 4.60 1.51 3,616 1 2,153 1.01
APPS_TS_TX_DATA /DB/visdata/tx_data14.dbf 12,313 3 3.89 1.38 25,407 7 14,823 0.18
APPS_TS_TX_DATA /DB/visdata/tx_data15.dbf 8,754 2 3.73 1.44 22,794 6 14,435 0.22
APPS_TS_TX_DATA /DB/visdata/tx_data16.dbf 8,825 2 3.60 1.42 22,108 6 14,090 0.22
APPS_TS_TX_DATA /DB/visdata/tx_data17.dbf 8,708 2 3.80 1.44 21,116 6 13,914 0.20
APPS_TS_TX_DATA /DB/visdata/tx_data18.dbf 8,751 2 3.63 1.41 20,796 6 13,193 0.15
APPS_TS_TX_DATA /DB/visdata/tx_data19.dbf 8,577 2 3.93 1.43 20,905 6 14,245 0.16
APPS_TS_TX_DATA /DB/visdata/tx_data2.dbf 6,335 2 3.15 1.15 556 0 1,343 1.71
APPS_TS_TX_DATA /DB/visdata/tx_data20.dbf 8,652 2 3.94 1.47 21,069 6 14,115 0.12
APPS_TS_TX_DATA /DB/visdata/tx_data21.dbf 20,490 6 4.71 1.18 946 0 1,324 0.10
APPS_TS_TX_DATA /DB/visdata/tx_data3.dbf 3,136 1 5.21 1.49 388 0 14 2.86
APPS_TS_TX_DATA /DB/visdata/tx_data4.dbf 16,339 5 4.52 1.11 302 0 13 2.31
APPS_TS_TX_DATA /DB/visdata/tx_data5.dbf 2,805 1 4.73 1.24 334 0 6 5.00
APPS_TS_TX_DATA /DB/visdata/tx_data6.dbf 2,859 1 4.60 1.23 155 0 11 2.73
APPS_TS_TX_DATA /DB/visdata/tx_data7.dbf 2,803 1 4.81 1.27 397 0 16 4.38
APPS_TS_TX_DATA /DB/visdata/tx_data8.dbf 2,824 1 4.59 1.16 395 0 0 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data9.dbf 2,956 1 4.84 1.30 258 0 0 0.00
APPS_TS_TX_IDX /DB/visdata/tx_idx1.dbf 2,409 1 3.24 1.24 1,935 1 1,289 0.49
APPS_TS_TX_IDX /DB/visdata/tx_idx10.dbf 2,334 1 3.30 1.26 1,324 0 1,233 0.58
APPS_TS_TX_IDX /DB/visdata/tx_idx11.dbf 2,294 1 3.48 1.29 1,587 0 1,280 0.78
APPS_TS_TX_IDX /DB/visdata/tx_idx12.dbf 9,528 3 5.18 1.93 17,473 5 1,268 0.39
APPS_TS_TX_IDX /DB/visdata/tx_idx13.dbf 8,019 2 4.34 1.36 22,093 6 2,878 0.31
APPS_TS_TX_IDX /DB/visdata/tx_idx14.dbf 4,401 1 4.51 1.55 14,801 4 2,521 0.12
APPS_TS_TX_IDX /DB/visdata/tx_idx15.dbf 4,373 1 4.46 1.53 12,714 4 3,083 0.24
APPS_TS_TX_IDX /DB/visdata/tx_idx16.dbf 4,543 1 4.63 1.52 11,592 3 2,897 0.11
APPS_TS_TX_IDX /DB/visdata/tx_idx17.dbf 4,326 1 4.49 1.54 11,343 3 3,034 0.12
APPS_TS_TX_IDX /DB/visdata/tx_idx18.dbf 4,560 1 4.76 1.55 11,268 3 4,045 0.05
APPS_TS_TX_IDX /DB/visdata/tx_idx19.dbf 4,588 1 4.61 1.54 10,657 3 3,149 0.21
APPS_TS_TX_IDX /DB/visdata/tx_idx2.dbf 2,691 1 3.76 1.50 1,575 0 1,037 0.59
APPS_TS_TX_IDX /DB/visdata/tx_idx20.dbf 4,393 1 4.78 1.57 10,295 3 2,106 0.07
APPS_TS_TX_IDX /DB/visdata/tx_idx21.dbf 3,142 1 5.01 1.85 13,852 4 1,680 0.52
APPS_TS_TX_IDX /DB/visdata/tx_idx3.dbf 3,842 1 2.50 1.21 1,609 0 1,818 0.73
APPS_TS_TX_IDX /DB/visdata/tx_idx4.dbf 2,537 1 3.26 1.32 2,879 1 2,098 0.72
APPS_TS_TX_IDX /DB/visdata/tx_idx5.dbf 2,498 1 3.28 1.27 4,186 1 7,655 0.07
APPS_TS_TX_IDX /DB/visdata/tx_idx6.dbf 2,591 1 3.69 1.27 2,402 1 1,249 1.22
APPS_TS_TX_IDX /DB/visdata/tx_idx7.dbf 2,434 1 3.53 1.29 2,171 1 1,091 0.86
APPS_TS_TX_IDX /DB/visdata/tx_idx8.dbf 2,368 1 3.16 1.30 1,563 0 1,044 0.98
APPS_TS_TX_IDX /DB/visdata/tx_idx9.dbf 2,433 1 3.29 1.33 1,468 0 1,268 0.56
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte.dbf 222 0 0.95 1.69 3,829 1 6,399 0.02
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte2.dbf 391 0 1.69 1.83 4,963 1 4,265 0.02
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte3.dbf 172 0 2.33 2.44 4,455 1 3,517 0.01
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte4.dbf 214 0 1.07 1.99 3,888 1 1,511 0.07
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte5.dbf 64 0 5.78 4.03 4,019 1 1,968 0.01
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte6.dbf 43 0 6.51 5.35 3,993 1 914 0.02
APPS_UNDOTS1 /DB/visdata/undo01.dbf 3 0 16.67 1.00 48,400 13 22,280 0.01
APPS_UNDOTS1 /DB/visdata/undo02.dbf 6 0 5.00 1.00 48,966 14 28,287 0.02
APPS_UNDOTS1 /DB/visdata/undo03.dbf 3 0 3.33 1.00 45,618 13 21,642 0.02
APPS_UNDOTS1 /DB/visdata/undo04.dbf 3 0 16.67 1.00 44,984 12 25,923 0.02
APPS_UNDOTS1 /DB/visdata/undo05.dbf 3 0 16.67 1.00 48,248 13 23,387 0.02
APPS_UNDOTS1 /DB/visdata/undo06.dbf 3 0 3.33 1.00 44,607 12 21,338 0.02
APPS_UNDOTS1 /DB/visdata/undo07.dbf 4 0 7.50 1.00 46,183 13 22,628 0.01
APPS_UNDOTS1 /DB/visdata/undo08.dbf 4 0 7.50 1.00 50,013 14 30,608 0.02
APPS_UNDOTS1 /DB/visdata/undo09.dbf 4 0 7.50 1.00 43,431 12 23,497 0.02
APPS_UNDOTS1 /DB/visdata/undo10.dbf 4 0 12.50 1.00 45,299 13 26,830 0.02
CTXSYS /DB/visdata/ctx1.dbf 12 0 10.00 1.00 3 0 0 0.00
CTXSYS /DB/visdata/ctx2.dbf 12 0 7.50 1.00 3 0 0 0.00
ODM /DB/visdata/odm.dbf 13 0 5.38 1.00 3 0 0 0.00
OLAP /DB/visdata/olap.dbf 13 0 6.92 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 5.83 1.00 3 0 0 0.00
SYSAUX /DB/visdata/sysaux01.dbf 25 0 8.40 1.44 637 0 0 0.00
SYSAUX /DB/visdata/sysaux02.dbf 277 0 2.09 1.07 752 0 0 0.00
SYSTEM /DB/visdata/sys1.dbf 545 0 4.46 3.47 88 0 10 0.00
SYSTEM /DB/visdata/sys2.dbf 569 0 4.04 3.77 173 0 19 0.00
SYSTEM /DB/visdata/sys3.dbf 686 0 3.64 3.24 197 0 1 0.00
SYSTEM /DB/visdata/sys4.dbf 553 0 3.71 3.68 203 0 7 0.00
SYSTEM /DB/visdata/sys5.dbf 929 0 4.18 2.61 593 0 1,184 0.08
SYSTEM /DB/visdata/sys6.dbf 555 0 4.13 3.68 84 0 1 0.00
SYSTEM /DB/visdata/sys7.dbf 436 0 4.56 3.67 158 0 14 0.00
SYSTEM /DB/visdata/sys8.dbf 401 0 4.54 2.35 393 0 18,659 0.04
SYSTEM /DB/visdata/sys9.dbf 569 0 3.37 1.85 348 0 30 0.33
TEMP /DB/visdata/temp1.dbf 129 0 4.11 27.05 2,602 1 27 1.48
TEMP /DB/visdata/temp2.dbf 44 0 5.68 1.00 1,942 1 0  
TEMP /DB/visdata/temp3.dbf 78 0 4.23 10.73 2,259 1 14 2.14
TEMP /DB/visdata/temp4.dbf 69 0 4.49 2.74 2,037 1 0  

Back to IO Stats
Back to Top

 

Buffer Pool Statistics

P Number of Buffers Pool Hit% Buffer Gets Physical Reads Physical Writes Free Buff Wait Writ Comp Wait Buffer Busy Waits
D 2,232,312 100 1,822,167,375 427,047 2,897,731 0 0 667,735


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 78 35000 815750 3115314 188743680 3115314  
E 180 81 38423 823487 8765559 188743680 8765559  

Back to Advisory Statistics
Back to Top

 

Buffer Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit % W/A MB Processed Extra W/A MB Read/Written
100.00 456,208 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 32,633.82 0.14 0.00 100.00 0.00 1,048,576
E 20,480 1,280 40,237.68 2.09 0.01 100.00 0.00 1,048,576

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High Optimal Total Execs Optimal Execs 1-Pass Execs M-Pass Execs
2K 4K 4,431,576 4,431,576 0 0
64K 128K 11,499 11,499 0 0
128K 256K 1,065 1,065 0 0
256K 512K 1,033 1,033 0 0
512K 1024K 138,711 138,711 0 0
1M 2M 308,652 308,652 0 0
2M 4M 76 76 0 0
4M 8M 23 21 2 0
8M 16M 18 18 0 0
32M 64M 8 8 0 0
64M 128M 6 6 0 0
128M 256M 2 2 0 0

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

PGA Target Est (MB) Size Factr W/A MB Processed Estd Extra W/A MB Read/ Written to Disk Estd PGA Cache Hit % Estd PGA Overalloc Count
2,560 0.13 619,303.95 7,830.00 99.00 957
5,120 0.25 619,303.95 7,769.50 99.00 923
10,240 0.50 619,303.95 7,665.12 99.00 870
15,360 0.75 619,303.95 7,573.60 99.00 821
20,480 1.00 619,303.95 5.00 100.00 770
24,576 1.20 619,303.95 5.00 100.00 614
28,672 1.40 619,303.95 0.00 100.00 185
32,768 1.60 619,303.95 0.00 100.00 0
36,864 1.80 619,303.95 0.00 100.00 0
40,960 2.00 619,303.95 0.00 100.00 0
61,440 3.00 619,303.95 0.00 100.00 0
81,920 4.00 619,303.95 0.00 100.00 0
122,880 6.00 619,303.95 0.00 100.00 0
163,840 8.00 619,303.95 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,136 0.49 281 12,748 1,902,929 1.00 3,178 3.66 148,214,845
1,376 0.59 490 15,652 1,904,735 1.00 1,372 1.58 148,353,142
1,616 0.69 730 19,266 1,905,200 1.00 907 1.04 148,389,328
1,856 0.79 968 24,437 1,905,238 1.00 869 1.00 148,392,732
2,096 0.90 1,078 30,205 1,905,238 1.00 869 1.00 148,392,804
2,336 1.00 1,085 30,944 1,905,238 1.00 869 1.00 148,392,805
2,576 1.10 1,085 30,944 1,905,238 1.00 869 1.00 148,392,805
2,816 1.21 1,085 30,944 1,905,238 1.00 869 1.00 148,392,805
3,056 1.31 1,085 30,944 1,905,238 1.00 869 1.00 148,392,805
3,296 1.41 1,085 30,944 1,905,238 1.00 869 1.00 148,392,805
3,536 1.51 1,085 30,944 1,905,238 1.00 869 1.00 148,392,805
3,776 1.62 1,085 30,944 1,905,238 1.00 869 1.00 148,392,805
4,016 1.72 1,085 30,944 1,905,238 1.00 869 1.00 148,392,805
4,256 1.82 1,085 30,944 1,905,238 1.00 869 1.00 148,392,805
4,496 1.92 1,085 30,944 1,905,238 1.00 869 1.00 148,392,805
4,736 2.03 1,085 30,944 1,905,238 1.00 869 1.00 148,392,805

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

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 11 207 449 1.00 869 1.00 13,692
32 0.50 11 207 449 1.00 869 1.00 13,692
48 0.75 11 207 449 1.00 869 1.00 13,692
64 1.00 11 207 449 1.00 869 1.00 13,692
80 1.25 11 207 449 1.00 869 1.00 13,692
96 1.50 11 207 449 1.00 869 1.00 13,692
112 1.75 11 207 449 1.00 869 1.00 13,692
128 2.00 11 207 449 1.00 869 1.00 13,692

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 412,580 80 0
undo block 197,210 3 0
undo header 49,210 2 0
2nd level bmb 1,158 0 0
1st level bmb 5,339 0 0
segment header 2,187 0 0
file header block 75 0 1
extent map 21 0 0

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason) Requests Succ Gets Failed Gets Waits Wt Time (s) Av Wt Time(ms)
UL-User-defined 66,004 64,953 1,051 2,298 51 22.38
TX-Transaction (row lock contention) 4,382 495 3,887 481 50 104.49
TX-Transaction (index contention) 24,183 24,183 0 22,367 15 0.69
RO-Multiple Object Reuse (fast object reuse) 288 288 0 31 6 186.45
HW-Segment High Water Mark 206,605 206,604 1 2,064 2 0.78
TX-Transaction 1,106,965 1,106,968 0 1,798 1 0.50
DV-Diana Versioning 22,889 22,889 0 175 1 3.60
SQ-Sequence Cache 36,817 36,817 0 2,755 0 0.17
TM-DML 1,661,656 1,661,626 0 3 0 30.00
FB-Format Block 35,284 35,284 0 458 0 0.09
TX-Transaction (allocate ITL entry) 122 122 0 78 0 0.38
PS-PX Process Reservation 1,864 1,544 320 49 0 0.20
US-Undo Segment 8,267 8,267 0 4 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,505.74 1,097,292 2,676 275 179.3/999.066666666666666666666666666666666667 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 17:00 195,645 142,260 603 269 193 0/0 0/0/0/0/0/0
16-Oct 16:50 60,144 92,464 450 262 196 0/0 0/0/0/0/0/0
16-Oct 16:40 438,538 164,402 2,114 265 179 0/0 0/0/0/0/0/0
16-Oct 16:30 350,255 243,450 2,676 271 231 0/0 0/0/0/0/0/0
16-Oct 16:20 389,060 350,760 1,805 275 321 0/0 0/0/0/0/0/0
16-Oct 16:10 72,099 103,956 1,705 269 999 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,464 0.00   0 0  
AWR Alerted Metric Element list 249,322 0.00   0 0  
Consistent RBA 702,580 0.06 0.01 0 0  
FOB s.o list latch 46,358 0.01 0.00 0 0  
In memory undo latch 665,498,408 2.15 0.00 4 989,741 0.00
JOX SGA heap latch 1,868,257 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 2,521 0.00   0 0  
KMG resize request state object freelist 20 0.00   0 0  
KTF sga latch 12 0.00   0 1,214 0.00
KWQMN job cache list latch 12,048 0.12 1.00 0 0  
MQL Tracking Latch 0     0 72 0.00
Memory Management Latch 1,513 0.00   0 2,511 0.00
OS process 11,820 0.00   0 0  
OS process allocation 9,103 0.01 0.00 0 0  
OS process: request allocation 7,626 0.00   0 0  
PL/SQL warning settings 3,560,728 0.00   0 0  
SGA IO buffer pool latch 29,708 0.38 0.02 0 31,137 0.25
SQL memory manager latch 1 0.00   0 1,199 0.00
SQL memory manager workarea list latch 5,412,558 0.00 0.02 0 0  
Shared B-Tree 128 0.00   0 0  
active checkpoint queue latch 1,248,873 0.51 0.00 0 2 0.00
active service list 38,424 0.11 0.00 0 1,261 0.00
begin backup scn array 150 0.00   0 0  
buffer pool 20 0.00   0 0  
cache buffer handles 21,859,456 0.91 0.00 0 0  
cache buffers chains 4,319,710,780 0.90 0.02 13 16,434,426 2.36
cache buffers lru chain 9,213,963 0.33 0.03 1 32,578,482 0.41
cache table scan latch 1,875 0.00   0 1,875 0.00
channel handle pool latch 292,732 0.07 0.02 0 0  
channel operations parent latch 1,300,795 0.45 0.00 0 0  
checkpoint queue latch 17,752,411 0.01 0.01 0 2,908,458 0.02
client/application info 1,305,221 0.00 0.00 0 0  
commit callback allocation 62,854 0.00   0 0  
compile environment latch 2,228,635 0.00   0 0  
dictionary lookup 78 0.00   0 0  
dml lock allocation 3,310,017 0.16 0.01 0 0  
dummy allocation 15,170 0.25 0.03 0 0  
enqueue hash chains 7,382,860 0.06 0.00 0 228 0.00
enqueues 3,946,402 0.10 0.01 0 0  
error message lists 816 0.74 0.00 0 0  
event group latch 3,824 0.00   0 0  
file cache latch 20,007 0.01 0.00 0 0  
global KZLD latch for mem in SGA 7,078 0.00   0 0  
global ctx hash table latch 17,132 0.00   0 0  
hash table column usage latch 1,706 0.00   0 11,002,643 0.00
hash table modification latch 146 0.00   0 0  
internal temp table object number allocation latc 6 0.00   0 0  
job workq parent latch 0     0 122 0.00
job_queue_processes parameter latch 121 0.00   0 0  
kks stats 24,664 0.00   0 0  
ksuosstats global area 242 0.00   0 0  
ktm global data 117,201 0.00   0 0  
kwqbsn:qsga 128 0.00   0 0  
lgwr LWN SCN 704,733 0.10 0.00 0 0  
library cache 269,105,458 0.32 0.01 3 19,327 0.67
library cache load lock 9,885 0.22 0.00 0 14 0.00
library cache lock 42,912,069 0.04 0.01 0 0  
library cache lock allocation 1,131,584 0.01 0.09 0 0  
library cache pin 168,034,278 0.10 0.01 1 37 0.00
library cache pin allocation 396,520 0.00 0.00 0 0  
list of block allocation 416,838 0.02 0.00 0 0  
loader state object freelist 226,582 0.00 0.00 0 0  
longop free list parent 33 0.00   0 33 0.00
message pool operations parent latch 296,736 0.00 0.09 0 0  
messages 5,693,502 0.58 0.01 0 0  
mostly latch-free SCN 740,881 3.61 0.00 0 0  
multiblock read objects 29,820 0.00 0.00 0 0  
ncodef allocation latch 148 0.00   0 0  
object queue header heap 3,590,034 0.02 0.18 0 291,753 0.06
object queue header operation 30,038,570 0.12 0.35 1 19,548 0.03
object stats modification 290,818 0.02 0.04 0 0  
parallel query alloc buffer 8,160 0.91 0.00 0 0  
parallel query stats 528 13.64 0.00 0 0  
parameter table allocation management 17,458 1.50 0.50 0 0  
post/wait queue 992,771 0.02 0.01 0 400,858 0.01
process allocation 7,676 0.14 0.64 0 3,820 0.10
process group creation 7,628 0.00   0 0  
process queue 5,030 0.87 0.00 0 0  
process queue reference 756,752 0.05 0.00 0 82,836 0.33
qmn task queue latch 512 0.00   0 0  
query server freelists 4,256 5.31 0.00 0 0  
query server process 8 0.00   0 8 0.00
redo allocation 4,495,574 1.89 0.01 0 96,103,940 1.64
redo copy 0     0 96,230,155 0.04
redo writing 3,715,113 0.28 0.00 0 0  
resmgr group change latch 603,662 0.00   0 0  
resmgr:actses active list 22,211 0.37 0.96 0 0  
resmgr:actses change group 21,608 0.00   0 0  
resmgr:free threads list 15,168 0.31 0.00 0 0  
resmgr:schema config 1 0.00   0 0  
row cache objects 92,538,298 0.18 0.00 0 6,949 0.20
rules engine aggregate statistics 30,613 0.00 0.00 0 0  
rules engine rule set statistics 99,568 0.00 0.00 0 0  
rules engine rule statistics 38,342 0.00   0 0  
sequence cache 15,771,002 0.48 0.00 0 0  
session allocation 15,644,913 0.46 0.01 0 0  
session idle bit 73,178,655 0.01 0.02 0 0  
session state list latch 43,402 0.13 0.53 0 0  
session switching 10,704 0.00   0 0  
session timer 1,262 0.00   0 0  
shared pool 6,138,963 0.14 0.06 0 0  
shared pool sim alloc 339 0.00   0 0  
shared pool simulator 1,777,095 0.00 0.05 0 0  
sim partition latch 1 0.00   0 22,790 0.08
simulator hash latch 2,460 0.00   0 0  
simulator lru latch 1,380 0.00   0 0  
slave class 1 0.00   0 0  
slave class create 4 0.00   0 0  
sort extent pool 1,010,956 0.09 0.01 0 0  
state object free list 12 0.00   0 0  
statistics aggregation 84 0.00   0 0  
temp lob duration state obj allocation 238 0.00   0 0  
temporary table state object allocation 9,181 0.00   0 0  
threshold alerts latch 605 0.00   0 0  
trace latch 30 0.00   0 0  
transaction allocation 84,646 0.00 1.00 0 0  
transaction branch allocation 148 0.00   0 0  
undo global data 828,988,162 1.17 0.00 2 14,249 0.05
user lock 28,402 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,319,710,780 38,800,706 791,588 38,085,105 0 0 0
In memory undo latch 665,498,408 14,303,344 21,070 14,285,708 0 0 0
undo global data 828,988,162 9,729,424 9,014 9,721,389 0 0 0
library cache 269,105,458 852,547 6,285 846,920 0 0 0
cache buffer handles 21,859,456 199,007 141 198,885 0 0 0
library cache pin 168,034,278 169,044 1,562 167,652 0 0 0
row cache objects 92,538,298 163,771 488 163,305 0 0 0
redo allocation 4,495,574 84,940 669 84,339 0 0 0
sequence cache 15,771,002 75,043 73 74,981 0 0 0
session allocation 15,644,913 71,635 530 71,146 0 0 0
object queue header operation 30,038,570 34,685 12,076 23,522 0 0 0
messages 5,693,502 33,210 172 33,041 0 0 0
cache buffers lru chain 9,213,963 30,863 855 30,041 0 0 0
mostly latch-free SCN 740,881 26,717 61 26,663 0 0 0
library cache lock 42,912,069 17,846 97 17,753 0 0 0
redo writing 3,715,113 10,360 37 10,323 0 0 0
shared pool 6,138,963 8,412 505 7,954 0 0 0
session idle bit 73,178,655 6,566 113 6,456 0 0 0
active checkpoint queue latch 1,248,873 6,392 23 6,370 0 0 0
channel operations parent latch 1,300,795 5,850 7 5,845 0 0 0
dml lock allocation 3,310,017 5,238 40 5,199 0 0 0
enqueue hash chains 7,382,860 4,395 17 4,379 0 0 0
enqueues 3,946,402 4,084 45 4,040 0 0 0
checkpoint queue latch 17,752,411 2,215 32 2,184 0 0 0
sort extent pool 1,010,956 947 9 938 0 0 0
object queue header heap 3,590,034 707 128 596 0 0 0
Consistent RBA 702,580 408 3 406 0 0 0
parameter table allocation management 17,458 262 130 143 0 0 0
post/wait queue 992,771 239 3 236 0 0 0
channel handle pool latch 292,732 218 4 214 0 0 0
SQL memory manager workarea list latch 5,412,558 207 5 203 0 0 0
SGA IO buffer pool latch 29,708 113 2 111 0 0 0
resmgr:actses active list 22,211 82 79 5 0 0 0
library cache lock allocation 1,131,584 69 6 64 0 0 0
session state list latch 43,402 57 30 29 0 0 0
object stats modification 290,818 56 2 54 0 0 0
dummy allocation 15,170 38 1 37 0 0 0
shared pool simulator 1,777,095 20 1 19 0 0 0
KWQMN job cache list latch 12,048 15 15 0 0 0 0
message pool operations parent latch 296,736 11 1 10 0 0 0
process allocation 7,676 11 7 4 0 0 0
transaction allocation 84,646 1 1 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 13,960 15,917
In memory undo latch ktiFlush: child 0 3,863 2,316
In memory undo latch kticmt: child 0 2,755 590
In memory undo latch ktichg: child 0 362 2,195
In memory undo latch ktiTxnPoolFree 0 119 0
In memory undo latch ktiBRacquire 0 7 0
In memory undo latch ktbgfc 0 3 56
In memory undo latch ktuswr 0 1 0
KWQMN job cache list latch kwqmnuji: update job item 0 15 1
SGA IO buffer pool latch ksfd_free_sgabuffer 0 2 4
SQL memory manager workarea list latch qesmmIRegisterWorkArea 0 4 5
SQL memory manager workarea list latch qesmmIUnRegisterWorkArea 0 1 0
active checkpoint queue latch kcbbacq: scan active checkpoints 0 23 23
cache buffer handles kcbzgs 0 89 94
cache buffer handles kcbzfs 0 52 49
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 1,014,019 1,215,750
cache buffers chains kcbgtcr: fast path 0 513,498 19,494
cache buffers chains kcbchg: kslbegin: call CR func 0 249,515 670,873
cache buffers chains kcbzgb: scan from tail. nowait 0 87,762 0
cache buffers chains kcbgtcr: kslbegin excl 0 85,160 28,733
cache buffers chains kcbgcur: kslbegin 0 22,502 10,728
cache buffers chains kcbrls: kslbegin 0 15,312 41,421
cache buffers chains kcbget: pin buffer 0 13,190 5,542
cache buffers chains kcbzwb 0 4,283 4,959
cache buffers chains kcbcge 0 1,771 4,599
cache buffers chains kcbget: exchange rls 0 851 585
cache buffers chains kcbget: exchange 0 354 1,165
cache buffers chains kcbbxsv 0 329 323
cache buffers chains kcbnlc 0 176 1,077
cache buffers chains kcb_is_private 0 116 2,101
cache buffers chains kcbgtcr: kslbegin shared 0 55 47
cache buffers chains kcb_pre_apply: kcbhq61 0 50 1,277
cache buffers chains kcbesc: escalate 0 50 21
cache buffers chains kcbnew: new latch again 0 41 3
cache buffers chains kcb_post_apply: kcbhq63 0 27 209
cache buffers chains kcbso1: set no access 0 10 24
cache buffers chains kcbbic2 0 4 6
cache buffers chains kcbw_next_free 0 3 0
cache buffers chains kcb_post_apply: kcbhq62 0 2 238
cache buffers lru chain kcbzgws 0 463 0
cache buffers lru chain kcbbxsv: move to being written 0 164 327
cache buffers lru chain kcbo_link_q 0 83 16
cache buffers lru chain kcbgtcr:CR Scan:KCBRSKIP 0 74 0
cache buffers lru chain kcbzgb: posted for free bufs 0 34 182
cache buffers lru chain kcbbic2 0 16 168
cache buffers lru chain kcbo_ivd_proc 0 11 112
cache buffers lru chain kcbzswcu 0 8 26
cache buffers lru chain kcbbwlru 0 1 19
cache buffers lru chain kcbrlb 0 1 2
channel handle pool latch ksrchconnect() 0 5 4
channel handle pool latch ksrchdelete() 0 1 2
channel operations parent latch ksrapublish() 0 7 0
channel operations parent latch ksrchdelete() 0 3 0
channel operations parent latch ksrwait() 0 2 10
checkpoint queue latch kcbkubc 0 12 17
checkpoint queue latch kcbbwthc: thread checkpoint buffers 0 10 12
checkpoint queue latch kcbklbc: Link buffer into ckpt queue 0 8 0
checkpoint queue latch kcbswcu: Switch buffers 0 2 4
dml lock allocation ktaiam 0 26 31
dml lock allocation ktaidm 0 14 9
dummy allocation ktcdod 0 1 1
enqueue hash chains ksqrcl 0 10 7
enqueue hash chains ksqgtl3 0 7 6
enqueues ksqgel: create enqueue 0 19 9
enqueues ksqies 0 18 33
enqueues ksqdel 0 8 3
lgwr LWN SCN kcs023 0 16 0
library cache kglpndl: child: after processing 0 2,470 73
library cache kglpnp: child 0 2,261 3,316
library cache kglobpn: child: 0 525 948
library cache kglpndl: child: before processing 0 341 1,524
library cache kglLockCursor 0 165 194
library cache kglScanDependency 0 138 0
library cache kglpin 0 59 22
library cache kglhdgn: child: 0 54 71
library cache kgldte: child 0 0 51 103
library cache kgldti: 2child 0 15 2
library cache kglic 0 14 0
library cache kglrtl 0 5 0
library cache kglhdgc: child: 0 2 0
library cache kglhdiv: child 0 2 0
library cache kglivl: child 0 2 0
library cache kglget: unpin heap 0 0 1 1
library cache kglupd: child 0 1 0
library cache lock kgllkdl: child: cleanup 0 56 52
library cache lock kgllkal: child: multiinstance 0 41 44
library cache lock kgllkdl: child: no lock handle 0 39 12
library cache lock allocation kgllkget 0 6 5
library cache pin kglpndl 0 757 455
library cache pin kglpnp: child 0 703 880
library cache pin kglpnal: child: alloc space 0 102 227
message pool operations parent latch ksrmfree() 0 1 0
messages ksarcv 0 74 15
messages ksarcv: after wait 0 74 109
messages ksaamb: after wakeup 0 24 48
mostly latch-free SCN kcslcu3 0 45 61
mostly latch-free SCN kcsnew_scn_rba 0 2 0
mostly latch-free SCN kcs01 0 1 4
object queue header heap kcbo_link_q:reget 0 122 5
object queue header heap kcbw_link_q:alloc 0 3 125
object queue header heap kcbw_unlink_q 0 3 0
object queue header operation kcbo_ivbo 0 12,673 2,669
object queue header operation kcbw_link_q 0 2,320 1,217
object queue header operation kcbw_unlink_q 0 480 3,938
object queue header operation kcbo_switch_q_bg 0 256 1,310
object queue header operation kcbo_switch_mq_bg 0 255 1,891
object queue header operation kcbo_switch_cq 0 97 1,896
object queue header operation kcbo_service_ockpt 0 40 2
object queue header operation kcbo_link_q:reget 0 28 70
object queue header operation kcbo_write_q 0 24 11
object queue header operation kcbo_swap_buf_bg 0 7 3,055
object queue header operation kcbo_swap_buf 0 4 338
object queue header operation kcbw_unlink_q_bg 0 3 16
object stats modification ksoslinelm 0 2 1
parameter table allocation management ksp_param_table_free 0 129 130
parameter table allocation management kspallmod 0 1 0
post/wait queue ksliwat:remove 0 3 2
process allocation ksucrp 0 7 0
redo allocation kcrfw_redo_gen: redo allocation 1 0 507 0
redo allocation kcrfw_redo_gen: redo allocation 3 0 112 431
redo allocation kcrfw_redo_gen: redo allocation 2 0 29 0
redo allocation kcrfw_redo_write: more space 0 11 161
redo allocation kcrfw_redo_write: before write 0 10 97
redo writing kcrfwcr 0 27 34
redo writing kcrfw_post: rba scn pair 0 8 0
redo writing kcrfw_cal_target_rba 0 1 1
redo writing kcrfw_post: after write 0 1 2
resmgr:actses active list kgskchclass 0 79 45
row cache objects kqreqd: reget 0 369 4
row cache objects kqrpre: find obj 0 86 427
row cache objects kqreqd 0 31 56
row cache objects kqrso 0 1 0
sequence cache kdnssd 0 47 5
sequence cache kdnnxt: cached seq 0 23 1
sequence cache kdnss 0 3 68
session allocation ksuprc 0 148 98
session allocation ksuxds: KSUSFCLC not set 0 142 17
session allocation ksudlc 0 110 118
session allocation ksucri 0 55 199
session allocation ksuxds: not user session 0 40 69
session allocation kspallmod 0 17 0
session allocation kxfpqidqr 0 8 6
session allocation ksursi 0 5 19
session allocation ksudlp 0 3 2
session allocation kxfprdp 0 1 1
session idle bit ksupuc: set busy 0 75 64
session idle bit ksupuc: clear busy 0 65 66
session idle bit ksuxds 0 1 11
session state list latch kpseqd 0 27 0
session state list latch kpscad 0 3 1
shared pool kghupr1 0 269 380
shared pool kghalo 0 186 71
shared pool kghfrunp: clatch: nowait 0 130 0
shared pool kghfrunp: alloc: wait 0 29 2
shared pool kghfre 0 16 46
shared pool kghfrunp: clatch: wait 0 11 18
shared pool kghalp 0 4 5
shared pool kghfrunp: alloc: session dur 0 1 0
shared pool simulator kglsim_unpin_simhp 0 1 1
sort extent pool ktstdt: dealloc sort extent 0 6 2
sort extent pool ktstdt: return extent 0 2 0
sort extent pool ktstsmonmsg 0 1 8
transaction allocation ktcdso 0 1 0
undo global data kturimugur: child 0 8,325 6,888
undo global data ktudba: KSLBEGIN 0 648 2,101
undo global data ktucof: at start 0 12 0
undo global data ktudnx:child 0 11 11
undo global data ktufrbs: child 0 9 11
undo global data ktubnd:child 0 5 2
undo global data ktusmasp: ktugd_tuux 0 4 2

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 66,664,416 3.66
INV APPS_TS_TX_IDX MTL_ITEM_CATEGORIES_U1   INDEX 50,123,648 2.75
ONT APPS_TS_TX_DATA OE_ORDER_LINES_ALL   TABLE 21,682,960 1.19
WSH APPS_TS_TX_DATA WSH_DELIVERY_DETAILS   TABLE 19,949,712 1.09
GL APPS_TS_TX_DATA GL_CODE_COMBINATIONS   TABLE 18,971,056 1.04

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,070 8.19
AR APPS_ASSM_DATA RA_CUSTOMER_TRX_LINES_ALL   TABLE 13,037 3.04
WSH APPS_TS_TX_DATA WSH_DELIVERY_DETAILS   TABLE 9,555 2.23
HR APPS_TS_TX_IDX PAY_PERSON_LATEST_BALA_N50   INDEX 4,777 1.12
HR APPS_ASSM_DATA PAY_RUN_RESULTS   TABLE 4,050 0.95

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 11,186 29.61
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_U1   INDEX 9,421 24.94
WSH APPS_TS_TX_DATA WSH_TRIP_STOPS   TABLE 7,200 19.06
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N6   INDEX 2,591 6.86
HR APPS_ASSM_IDX PAY_RUN_RESULT_VALUES_PK   INDEX 1,690 4.47

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 26 43.33
GL APPS_ASSM_IDX GL_IMPORT_REFERENCES_N1   INDEX 7 11.67
APPLSYS APPS_TS_TX_IDX WF_ITEM_ATTRIBUTE_VALUES_PK   INDEX 7 11.67
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N1   INDEX 4 6.67
GL APPS_ASSM_IDX GL_INTERFACE_N2   INDEX 3 5.00

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 136,648 39.25
APPLSYS APPS_TS_TX_DATA WF_ITEM_ATTRIBUTE_VALUES   TABLE 62,165 17.85
SYS SYSTEM DBMS_LOCK_ALLOCATED   TABLE 18,646 5.36
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N6   INDEX 16,718 4.80
APPLSYS APPS_TS_TX_DATA WF_ITEM_ACTIVITY_STATUSES WF_ITEM49 TABLE PARTITION 15,601 4.48

Back to Segment Statistics
Back to Top

 

Dictionary Cache Stats

Cache Get Requests Pct Miss Scan Reqs Pct Miss Mod Reqs Final Usage
dc_awr_control 5 20.00 0   2 1
dc_constraints 648 47.22 0   648 0
dc_files 6,660 0.00 0   0 111
dc_global_oids 5,470,223 0.00 0   0 43
dc_histogram_data 5,933 9.94 0   0 586
dc_histogram_defs 315,378 3.08 0   4,044 3,420
dc_object_grants 51,192 0.07 0   0 78
dc_object_ids 9,172,402 0.02 0   58 1,275
dc_objects 134,353 1.34 0   347 783
dc_profiles 7,139 0.00 0   0 1
dc_rollback_segments 22,350 0.03 0   21 278
dc_segments 273,220 0.89 0   14,869 1,307
dc_sequences 46,367 0.14 0   46,367 106
dc_table_scns 16,848 0.05 0   0 5
dc_tablespace_quotas 14,713 0.16 0   211 40
dc_tablespaces 4,551,389 0.00 0   0 22
dc_usernames 368,834 0.01 0   0 19
dc_users 10,775,892 0.00 0   0 63
outstanding_alerts 268 0.75 0   1 43


Back to Top

 

Library Cache Activity

Namespace Get Requests Pct Miss Pin Requests Pct Miss Reloads Invali- dations
BODY 469,281 0.03 32,111,698 0.00 9 0
CLUSTER 97 1.03 245 1.22 2 0
INDEX 11,177 0.57 11,989 0.78 0 0
JAVA DATA 624 0.00 0   0 0
PIPE 35,634 2.55 52,246 1.74 0 0
SQL AREA 5,527 90.74 91,054,297 0.19 2,744 378
TABLE/PROCEDURE 297,025 0.34 44,389,425 0.01 1,161 0
TRIGGER 21,190 0.13 1,256,875 0.00 32 0


Back to Top

 

Memory Statistics

Back to Top

Process Memory Summary

  Category Alloc (MB) Used (MB) Avg Alloc (MB) Std Dev Alloc (MB) Max Alloc (MB) Hist Max Alloc (MB) Num Proc Num Alloc
B Other 25,922.54   11.23 6.66 37 37 2,309 2,309
  Freeable 2,435.19 0.00 1.23 0.78 9   1,980 1,980
  SQL 2,424.65 1,243.18 1.05 0.69 4 21 2,301 2,299
  PL/SQL 1,657.80 139.40 0.72 0.93 3 3 2,309 2,309
  JAVA 185.97 185.14 2.21 0.35 5 8 84 84
E Other 32,046.01   13.77 8.36 41 41 2,328 2,328
  Freeable 3,128.94 0.00 1.51 0.93 9   2,071 2,071
  SQL 2,904.33 1,522.47 1.25 0.76 5 21 2,320 2,318
  PL/SQL 1,975.19 162.05 0.85 0.97 3 3 2,328 2,328
  JAVA 185.93 185.09 2.21 0.35 5 8 84 84

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions Begin Size (Bytes) End Size (Bytes) (if different)
Database Buffers 19,092,471,808 18,924,699,648
Fixed Size 2,111,120  
Redo Buffers 14,663,680  
Variable Size 2,365,589,872 2,533,362,032

Back to Memory Statistics
Back to Top

SGA breakdown difference

Pool Name Begin MB End MB % Diff
java free memory 51.29 51.29 0.00
java joxlod exec hp 12.09 12.09 0.00
large free memory 15.94 15.94 0.00
shared ASH buffers 29.00 29.00 0.00
shared CCursor 32.47 32.96 1.53
shared KTI-UNDO 53.19 53.19 0.00
shared PCursor 21.79   -100.00
shared PL/SQL MPCODE 66.75 69.42 4.00
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 319.84 346.24 8.25
shared library cache 603.66 735.85 21.90
shared parameter table block 41.98 42.13 0.37
shared private strands 99.77 99.77 0.00
shared sessions 36.42 36.42 0.00
shared sql area 334.19 337.34 0.94
shared trace buffer 36.14 36.61 1.30
  buffer_cache 18,208.00 18,048.00 -0.88
  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