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 05-May-09 15:36:48 3821 205.5
End Snap: 2 05-May-09 16:36:53 3824 239.0
Elapsed:   60.08 (mins)    
DB Time:   354.33 (mins)    

 

Report Summary

Cache Sizes

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

Load Profile

  Per Second Per Transaction
Redo size: 8,371,363.84 31,171.46
Logical reads: 510,641.91 1,901.42
Block changes: 51,651.78 192.33
Physical reads: 120.48 0.45
Physical writes: 812.28 3.02
User calls: 9,842.95 36.65
Parses: 1,962.10 7.31
Hard parses: 2.07 0.01
Sorts: 2,407.79 8.97
Logons: 2.10 0.01
Executes: 23,179.03 86.31
Transactions: 268.56  

% Blocks changed per Read: 10.12 Recursive Call %: 79.30
Rollback per transaction %: 19.23 Rows per Sort: 12.76

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.89 Soft Parse %: 99.89
Execute to Parse %: 91.54 Latch Hit %: 98.98
Parse CPU to Parse Elapsd %: 89.61 % Non-Parse CPU: 97.94

Shared Pool Statistics

  Begin End
Memory Usage %: 85.14 85.60
% SQL with executions>1: 90.73 91.03
% Memory for SQL w/exec>1: 68.76 69.11

Top 5 Timed Events

Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class
CPU time   16,800   79.0  
SQL*Net more data from client 1,853,113 4,495 2 21.1 Network
db file sequential read 262,909 876 3 4.1 User I/O
log file sync 389,458 458 1 2.2 Commit
log file parallel write 718,734 302 0 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,799.62 79.02
sql execute elapsed time 16,772.15 78.89
PL/SQL execution elapsed time 5,724.86 26.93
inbound PL/SQL rpc elapsed time 5,203.82 24.48
Java execution elapsed time 474.55 2.23
parse time elapsed 444.23 2.09
hard parse elapsed time 227.19 1.07
repeated bind elapsed time 58.12 0.27
sequence load elapsed time 11.52 0.05
connection management call elapsed time 7.83 0.04
PL/SQL compilation elapsed time 5.87 0.03
hard parse (sharing criteria) elapsed time 3.54 0.02
hard parse (bind mismatch) elapsed time 1.10 0.01
failed parse elapsed time 1.07 0.01
DB time 21,259.91  
background elapsed time 885.26  
background cpu time 311.27  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait Class Waits %Time -outs Total Wait Time (s) Avg wait (ms) Waits /txn
Network 40,646,752 0.00 4,526 0 41.98
User I/O 323,657 0.00 1,010 3 0.33
System I/O 1,022,774 0.00 460 0 1.06
Commit 389,458 0.00 458 1 0.40
Application 50,524 0.10 203 4 0.05
Concurrency 1,879,774 0.22 138 0 1.94
Other 113,500 27.17 28 0 0.12
Configuration 6,479 0.00 3 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
SQL*Net more data from client 1,853,113 0.00 4,495 2 1.91
db file sequential read 262,909 0.00 876 3 0.27
log file sync 389,458 0.00 458 1 0.40
log file parallel write 718,734 0.00 302 0 0.74
db file parallel write 273,145 0.00 152 1 0.28
enq: TX - row lock contention 557 6.28 123 221 0.00
read by other session 44,879 0.00 69 2 0.05
enq: UL - contention 2,407 0.71 64 27 0.00
db file scattered read 12,958 0.00 63 5 0.01
cursor: pin S wait on X 4,613 88.75 45 10 0.00
enq: TX - index contention 27,496 0.00 29 1 0.03
latch: cache buffers chains 1,184,251 0.00 21 0 1.22
library cache load lock 757 0.00 17 23 0.00
SQL*Net message to client 37,175,168 0.00 17 0 38.40
buffer busy waits 635,598 0.00 16 0 0.66
SQL*Net more data to client 1,618,471 0.00 14 0 1.67
PX Deq Credit: send blkd 22,274 0.00 8 0 0.02
SQL*Net break/reset to client 47,518 0.00 7 0 0.05
enq: RO - fast object reuse 33 0.00 7 199 0.00
rdbms ipc reply 4 50.00 6 1589 0.00
control file sequential read 29,155 0.00 5 0 0.03
kksfbc child completion 85 81.18 3 40 0.00
latch: library cache 6,399 0.00 3 0 0.01
enq: TM - contention 9 0.00 3 297 0.00
PX Deq: Signal ACK 227 33.04 3 11 0.00
os thread startup 70 0.00 2 30 0.00
latch: In memory undo latch 14,149 0.00 2 0 0.01
enq: HW - contention 2,580 0.00 2 1 0.00
latch: undo global data 4,218 0.00 1 0 0.00
log buffer space 261 0.00 1 4 0.00
local write wait 1,665 0.00 1 1 0.00
control file parallel write 1,740 0.00 1 0 0.00
latch: object queue header operation 14,382 0.00 1 0 0.01
LGWR wait for redo copy 28,992 0.00 1 0 0.03
enq: TX - contention 2,552 0.00 1 0 0.00
latch: library cache pin 1,647 0.00 1 0 0.00
enq: DV - contention 200 0.00 1 3 0.00
latch free 1,530 0.00 1 0 0.00
enq: SQ - contention 3,439 0.00 0 0 0.00
latch: cache buffers lru chain 1,027 0.00 0 0 0.00
latch: redo allocation 848 0.00 0 0 0.00
row cache lock 1,917 0.00 0 0 0.00
library cache pin 1,586 0.00 0 0 0.00
wait list latch free 28 0.00 0 11 0.00
buffer deadlock 30,306 98.90 0 0 0.03
latch: row cache objects 489 0.00 0 0 0.00
SGA: allocation forcing component growth 17 41.18 0 10 0.00
direct path read 732 0.00 0 0 0.00
latch: session allocation 396 0.00 0 0 0.00
latch: shared pool 522 0.00 0 0 0.00
library cache lock 6 0.00 0 17 0.00
enq: TX - allocate ITL entry 134 0.00 0 1 0.00
enq: CU - contention 10 0.00 0 7 0.00
enq: FB - contention 548 0.00 0 0 0.00
latch: library cache lock 109 0.00 0 1 0.00
latch: messages 182 0.00 0 0 0.00
reliable message 35 0.00 0 1 0.00
cursor: pin S 4,520 0.00 0 0 0.00
latch: cache buffer handles 127 0.00 0 0 0.00
PX qref latch 756 93.52 0 0 0.00
latch: object queue header heap 156 0.00 0 0 0.00
cursor: pin X 2 100.00 0 10 0.00
cursor: mutex S 126 0.00 0 0 0.00
latch: redo writing 60 0.00 0 0 0.00
latch: enqueue hash chains 16 0.00 0 0 0.00
latch: checkpoint queue latch 16 0.00 0 0 0.00
enq: PS - contention 44 0.00 0 0 0.00
direct path write 446 0.00 0 0 0.00
write complete waits 5 0.00 0 0 0.00
cursor: mutex X 39 0.00 0 0 0.00
direct path write temp 50 0.00 0 0 0.00
enq: US - contention 1 0.00 0 0 0.00
direct path read temp 18 0.00 0 0 0.00
L1 validation 1 0.00 0 0 0.00
SQL*Net message from client 37,175,174 0.00 7,368,902 198 38.40
pipe get 21,998 20.88 21,073 958 0.02
Streams AQ: qmn slave idle wait 129 0.00 3,504 27165 0.00
Streams AQ: qmn coordinator idle wait 258 50.00 3,504 13583 0.00
Streams AQ: waiting for time management or cleanup tasks 2,336 38.87 3,496 1497 0.00
PX Idle Wait 1,608 76.12 2,530 1573 0.00
PL/SQL lock timer 209 99.52 2,342 11207 0.00
jobq slave wait 618 99.35 1,805 2921 0.00
PX Deq: Execution Msg 5,089 0.00 35 7 0.01
PX Deq: Execute Reply 2,669 0.04 3 1 0.00
PX Deq Credit: need buffer 4,277 0.00 1 0 0.00
PX Deq: Table Q Normal 5,289 0.00 1 0 0.01
PX Deq: Msg Fragment 4,321 0.00 0 0 0.00
PX Deq: Parse Reply 268 0.00 0 0 0.00
PX Deq: Join ACK 280 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 718,726 0.00 302 0 0.74
db file parallel write 273,145 0.00 152 1 0.28
control file sequential read 827 0.00 2 2 0.00
os thread startup 62 0.00 2 31 0.00
db file scattered read 336 0.00 2 5 0.00
events in waitclass Other 35,863 0.00 1 0 0.04
db file sequential read 324 0.00 1 3 0.00
control file parallel write 1,740 0.00 1 0 0.00
direct path read 732 0.00 0 0 0.00
latch: cache buffers chains 85 0.00 0 0 0.00
latch: redo writing 60 0.00 0 0 0.00
direct path write 333 0.00 0 0 0.00
log file sync 1 0.00 0 0 0.00
latch: library cache 1 0.00 0 0 0.00
buffer busy waits 5 0.00 0 0 0.00
rdbms ipc message 1,724,648 0.71 36,291 21 1.78
pmon timer 1,327 90.96 3,513 2648 0.00
smon timer 114,563 0.00 3,507 31 0.12
Streams AQ: qmn slave idle wait 129 0.00 3,504 27165 0.00
Streams AQ: qmn coordinator idle wait 258 50.00 3,504 13583 0.00
Streams AQ: waiting for time management or cleanup tasks 2,336 38.87 3,496 1497 0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic Total
BUSY_TIME 1,797,139
IDLE_TIME 3,969,502
IOWAIT_TIME 103,394
NICE_TIME 15,600
SYS_TIME 79,383
USER_TIME 1,650,088
LOAD 4
RSRC_MGR_CPU_WAIT_TIME 0
PHYSICAL_MEMORY_BYTES 64,662,736
NUM_CPUS 16
NUM_CPU_SOCKETS 4

Back to Wait Events Statistics
Back to Top

Service Statistics

Service Name DB Time (s) DB CPU (s) Physical Reads Logical Reads
SYS$USERS 21,260.60 16,799.80 417,929 1,837,752,526
SYS$BACKGROUND 0.00 0.00 16,370 3,112,008
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 321926 100690 1879616 13563 0 0 40635187 452617
SYS$BACKGROUND 1727 292 153 193 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
691 690 303 2.28 3.25 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
411 11 20,008 0.02 1.93 fw8fr3nddyd26 PYUSLV insert into pay_run_balances(r...
398 8 10,000 0.04 1.87 38kpqs2vdwfh9 PYUSLV update pay_person_latest_balan...
360 359 55,042 0.01 1.69 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
322 322 55,036 0.01 1.52 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...
297 282 78,418 0.00 1.40 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
279 277 61,293 0.00 1.31 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
274 274 55,031 0.00 1.29 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
218 216 1,008 0.22 1.02 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
211 210 258,901 0.00 0.99 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...

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
690 691 303 2.28 3.25 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
359 360 55,042 0.01 1.69 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
322 322 55,036 0.01 1.52 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...
282 297 78,418 0.00 1.40 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
277 279 61,293 0.00 1.31 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
274 274 55,031 0.00 1.29 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
216 218 1,008 0.21 1.02 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
210 211 258,901 0.00 0.99 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
162 163 56,288 0.00 0.77 bfbyqwbr4vwms OEXOETEL begin OE_OEOL_SCH.SCHEDULE_LIN...
159 159 155,036 0.00 0.75 5kqw5535fjvw6 ARXTWMAI SELECT NVL(RCTT.ATTRIBUTE10, ...
11 411 20,008 0.00 1.93 fw8fr3nddyd26 PYUSLV insert into pay_run_balances(r...
8 398 10,000 0.00 1.87 38kpqs2vdwfh9 PYUSLV update pay_person_latest_balan...

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
57,649,331 155,036 371.84 3.13 158.71 158.93 5kqw5535fjvw6 ARXTWMAI SELECT NVL(RCTT.ATTRIBUTE10, ...
48,167,320 55,042 875.10 2.62 359.42 360.19 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
42,058,770 303 138,807.82 2.28 690.31 691.17 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
37,683,203 12,015 3,136.35 2.05 106.31 106.81 by2f4fw8tac6r ARXTWMAI UPDATE RA_CUST_TRX_LINE_GL_DIS...
27,806,877 55,031 505.29 1.51 274.01 274.30 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
27,566,981 61,293 449.76 1.50 277.14 278.95 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
27,479,760 55,036 499.31 1.49 321.64 322.25 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...
27,010,456 166,769 161.96 1.47 136.38 136.76 3b3psftuyks81 INVTTMTX BEGIN INV_TXNSTUB_PUB.postTran...
27,002,922 166,751 161.94 1.47 126.13 126.51 gf1u933c95jb5 INVTTMTX DECLARE l_ret_stat varchar2...
26,403,825 10,000 2,640.38 1.43 80.68 170.29 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
24,267,124 1,383,134 17.55 1.32 88.76 88.79 66tmsr3446uqn ap.oie.server.WebExpensesAM SELECT WIAS.ACTIVITY_STATUS, ...

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.42 80.68 170.29 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
42,040 1,680 25.02 9.68 11.62 161.87 3dssuqfjsynrk asn.lead.server.LeadUwqAM SELECT count(1) FROM (SELECT *...
28,699 1,680 17.08 6.61 78.67 182.03 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
19,399 15,146 1.28 4.47 113.60 167.60 1q78dwnrrkf6c asn.lead.server.LeadUwqAM BEGIN ASN_SALES_PVT.Lead_Proce...
9,090 5,047 1.80 2.09 81.47 107.72 8jb36w62w5hqf ibuSRDetailsActions.jsp BEGIN IBU_REQ_PKG.UpdateServic...
9,053 141,923 0.06 2.08 144.10 161.94 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
4,779 10,000 0.48 1.10 8.16 397.85 38kpqs2vdwfh9 PYUSLV update pay_person_latest_balan...
4,594 10,000 0.46 1.06 128.11 135.14 csvvv0fmhr1yc PYUSLV BEGIN FFP1893_01010001.FORMULA...
4,504 10,000 0.45 1.04 105.94 110.28 63t8zpm02skgh PYUSLV SELECT DECODE(COUNT(PRR.RUN_RE...
1,211 252 4.81 0.28 104.24 106.51 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,383,134 715,961 0.52 0.00 0.00 66tmsr3446uqn ap.oie.server.WebExpensesAM SELECT WIAS.ACTIVITY_STATUS, ...
788,361 788,362 1.00 0.00 0.00 cd9mbmqyf4qhp ap.oie.server.WebExpensesAM UPDATE WF_ITEM_ACTIVITY_STATUS...
445,577 191,814 0.43 0.00 0.00 0wrz2kbatczjk CSCCCCRC SELECT EXECUTE_FLAG FROM JTF_U...
419,095 419,092 1.00 0.00 0.00 avc1jqzz04wpr JDBC Thin Client SELECT 'x' FROM DUAL
258,901 258,901 1.00 0.00 0.00 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
258,765 201,914 0.78 0.00 0.00 fmfdkztk8vx23   SELECT CATEGORY, SEVERITY, F...
203,768 3,463,985 17.00 0.00 0.00 cwyx16zn1hpfb JDBC Thin Client select parameter, value from ...
166,769 166,769 1.00 0.00 0.00 3b3psftuyks81 INVTTMTX BEGIN INV_TXNSTUB_PUB.postTran...
166,763 166,758 1.00 0.00 0.00 6gnth2mfbs2nq INVTTMTX declare v_ret number := 0...
166,751 166,751 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,102 419,095 5.93 avc1jqzz04wpr JDBC Thin Client SELECT 'x' FROM DUAL
258,902 258,901 3.66 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
258,773 258,765 3.66 fmfdkztk8vx23   SELECT CATEGORY, SEVERITY, F...
203,768 203,768 2.88 cwyx16zn1hpfb JDBC Thin Client select parameter, value from ...
166,770 166,763 2.36 6gnth2mfbs2nq INVTTMTX declare v_ret number := 0...
141,924 141,923 2.01 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
117,620 117,617 1.66 fb13x9qx0ftks OEXOETEL begin OE_STANDARD_WF.OEOL_SELE...
111,725 111,721 1.58 1c0b7sas42w2z INVTTMTX SELECT NVL(ITEM_COST, 0), ...
88,936 88,932 1.26 76sw2a4vnc89j icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.S...
84,726 84,725 1.20 608c0n36kaw62 icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.C...
84,726 84,721 1.20 bf7uwg5pa3pj6 icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.V...
84,726 88,935 1.20 dcvv68fju01g4 icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.E...
84,246 84,246 1.19 162ttnv4ubqun OEXOETEL begin OE_DS_PVT.Check_PO_Appr...
77,956 77,956 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
0wrz2kbatczjk SELECT EXECUTE_FLAG FROM JTF_USER_HOOKS WHERE PKG_NAME = :B4 AND API_NAME = :B3 AND PROCESSING_TYPE = :B2 AND USER_HOOK_TYPE = :B1
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;
38kpqs2vdwfh9 update pay_person_latest_balances set assignment_action_id=:b1, value=:b2, expired_assignment_action_id=:b3, expired_value=:b4, prev_assignment_action_id=:b5, prev_balance_value=:b6 where rowid=:b7
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;
bfbyqwbr4vwms begin OE_OEOL_SCH.SCHEDULE_LINE (:v1, :v2, :v3, :v4, :v5); end;
bt0w082dfrm8v BEGIN WSH_SHIP_CONFIRM_ACTIONS.interface_ALL_wrp( :errbuf, :rc, :A0, :A1, :A2, :A3); END;
by2f4fw8tac6r UPDATE RA_CUST_TRX_LINE_GL_DIST LGD SET (AMOUNT, ACCTD_AMOUNT) = (SELECT NVL(LGD.AMOUNT, 0) - ( SUM(LGD2.AMOUNT) - ( DECODE(LGD.GL_DATE, REC1.GL_DATE, 1, 0) * DECODE(DECODE(LGD2.ACCOUNT_CLASS, 'UNEARN', 'REV', LGD2.ACCOUNT_CLASS), 'REV', CTL.REVENUE_AMOUNT, 'SUSPENSE', CTL.EXTENDED_AMOUNT - CTL.REVENUE_AMOUNT, CTL.EXTENDED_AMOUNT) ) ), NVL(LGD.ACCTD_AMOUNT, 0) - ( SUM(LGD2.ACCTD_AMOUNT) - ( DECODE(LGD.GL_DATE, REC1.GL_DATE, 1, 0) * DECODE(:B2 , NULL, ROUND(DECODE(DECODE(LGD2.ACCOUNT_CLASS, 'UNEARN', 'REV', LGD2.ACCOUNT_CLASS), 'REV', CTL.REVENUE_AMOUNT, 'SUSPENSE', CTL.EXTENDED_AMOUNT - CTL.REVENUE_AMOUNT, CTL.EXTENDED_AMOUNT) * NVL(CT.EXCHANGE_RATE, 1), :B3 ), ROUND( (DECODE(DECODE(LGD2.ACCOUNT_CLASS, 'UNEARN', 'REV', LGD2.ACCOUNT_CLASS), 'REV', CTL.REVENUE_AMOUNT, 'SUSPENSE', CTL.EXTENDED_AMOUNT - CTL.REVENUE_AMOUNT, CTL.EXTENDED_AMOUNT) * NVL(CT.EXCHANGE_RATE, 1) ) / :B2 ) * :B2 ) ) ) FROM RA_CUST_TRX_LINE_GL_DIST LGD2, RA_CUSTOMER_TRX_LINES CTL, RA_CUSTOMER_TRX CT, RA_CUST_TRX_LINE_GL_DIST REC1 WHERE REC1.CUSTOMER_TRX_ID = LGD.CUSTOMER_TRX_ID AND REC1.ACCOUNT_CLASS = 'REC' AND REC1.LATEST_REC_FLAG = 'Y' AND CT.CUSTOMER_TRX_ID = REC1.CUSTOMER_TRX_ID AND CTL.CUSTOMER_TRX_ID = CT.CUSTOMER_TRX_ID AND CTL.CUSTOMER_TRX_LINE_ID = LGD.CUSTOMER_TRX_LINE_ID AND LGD2.CUSTOMER_TRX_LINE_ID = LGD.CUSTOMER_TRX_LINE_ID AND LGD2.ACCOUNT_CLASS = LGD.ACCOUNT_CLASS AND LGD2.ACCOUNT_SET_FLAG = 'N' AND NVL(LGD2.GL_DATE, TO_DATE( 2415021, 'J') ) = NVL(LGD .GL_DATE, TO_DATE( 2415021, 'J') ) GROUP BY CTL.CUSTOMER_TRX_LINE_ID, DECODE(LGD2.ACCOUNT_CLASS, 'UNEARN', 'REV', LGD2.ACCOUNT_CLASS), REC1.GL_DATE, CTL.EXTENDED_AMOUNT, CTL.REVENUE_AMOUNT, CT.EXCHANGE_RATE ), PERCENT = (SELECT DECODE(LGD.ACCOUNT_CLASS || LGD.ACCOUNT_SET_FLAG, 'SUSPENSEN', LGD.PERCENT, 'UNBILLN', LGD.PERCENT, 'UNEARNN', LGD.PERCENT, NVL(LGD.PERCENT, 0) - ( SUM(NVL(LGD4.PERCENT, 0)) - DECODE(REC2.GL_DATE, NVL(LGD.GL_DATE, REC2.GL_DATE), 100, 0) ) ) FROM RA_CUST_TRX_LINE_GL_DIST LGD4, RA_CUST_TRX_LINE_GL_DIST REC2 WHERE REC2.CUSTOMER_TRX_ID = LGD.CUSTOMER_TRX_ID AND REC2.ACCOUNT_CLASS = 'REC' AND REC2.LATEST_REC_FLAG = 'Y' AND LGD4.CUSTOMER_TRX_LINE_ID = LGD.CUSTOMER_TRX_LINE_ID AND LGD4.ACCOUNT_SET_FLAG = LGD.ACCOUNT_SET_FLAG AND DECODE(LGD4.ACCOUNT_SET_FLAG, 'Y', LGD4.ACCOUNT_CLASS, LGD.ACCOUNT_CLASS) = LGD.ACCOUNT_CLASS AND NVL(LGD4.GL_DATE, TO_DATE( 2415021, 'J') ) = NVL(LGD.GL_DATE, TO_DATE( 2415021, 'J') ) GROUP BY REC2.GL_DATE, LGD.GL_DATE ), LAST_UPDATED_BY = :B1 , LAST_UPDATE_DATE = SYSDATE WHERE CUST_TRX_LINE_GL_DIST_ID IN (SELECT MIN(DECODE(LGD3.GL_POSTED_DATE, NULL, LGD3.CUST_TRX_LINE_GL_DIST_ID, NULL) ) FROM RA_CUSTOMER_TRX_LINES CTL, RA_CUST_TRX_LINE_GL_DIST LGD3, RA_CUST_TRX_LINE_GL_DIST REC3, RA_CUSTOMER_TRX T WHERE T.CUSTOMER_TRX_ID = :B5 AND REC3.CUSTOMER_TRX_ID = T.CUSTOMER_TRX_ID AND REC3.ACCOUNT_CLASS = 'REC' AND REC3.LATEST_REC_FLAG = 'Y' AND LGD3.CUSTOMER_TRX_ID = T.CUSTOMER_TRX_ID AND LGD3.ACCOUNT_S ET_FLAG = 'N' AND CTL.CUSTOMER_TRX_LINE_ID = LGD3.CUSTOMER_TRX_LINE_ID AND ( CTL.LINE_TYPE IN ('TAX', 'FREIGHT', 'CHARGES', 'SUSPENSE') OR (CTL.LINE_TYPE = 'LINE' AND CTL.ACCOUNTING_RULE_ID IS NULL) ) AND NVL(T.PREVIOUS_CUSTOMER_TRX_ID, -1) = DECODE(:B4 , 'INV', -1, 'REGULAR_CM', T.PREVIOUS_CUSTOMER_TRX_ID, NVL(T.PREVIOUS_CUSTOMER_TRX_ID, -1) ) GROUP BY CTL.CUSTOMER_TRX_LINE_ID, DECODE(LGD3.ACCOUNT_CLASS, 'UNEARN', 'REV', LGD3.ACCOUNT_CLASS), LGD3.GL_DATE, REC3.GL_DATE, CTL.EXTENDED_AMOUNT, CTL.REVENUE_AMOUNT, T.EXCHANGE_RATE HAVING ( SUM(NVL(LGD3.AMOUNT, 0)) <> DECODE(DECODE(LGD3.ACCOUNT_CLASS, 'UNEARN', 'REV', LGD3.ACCOUNT_CLASS), 'REV', CTL.REVENUE_AMOUNT, 'SUSPENSE', CTL.EXTENDED_AMOUNT - CTL.REVENUE_AMOUNT, CTL.EXTENDED_AMOUNT) * DECODE(LGD3.GL_DATE, REC3.GL_DATE, 1, 0) OR SUM(NVL(LGD3.ACCTD_AMOUNT, 0)) <> DECODE(LGD3.GL_DATE, REC3.GL_DATE, 1, 0) * DECODE(:B2 , NULL, ROUND(DECODE(DECODE(LGD3.ACCOUNT_CLASS, 'UNEARN', 'REV', LGD3.ACCOUNT_CLASS), 'REV', CTL.REVENUE_AMOUNT, 'SUSPENSE', CTL.EXTENDED_AMOUNT - CTL.REVENUE_AMOUNT, CTL.EXTENDED_AMOUNT) * NVL(T.EXCHANGE_RATE, 1), :B3 ), ROUND( (DECODE(DECODE(LGD3.ACCOUNT_CLASS, 'UNEARN', 'REV', LGD3.ACCOUNT_CLASS), 'REV', CTL.REVENUE_AMOUNT, 'SUSPENSE', CTL.EXTENDED_AMOUNT - CTL.REVENUE_AMOUNT, CTL.EXTENDED_AMOUNT) * NVL(T.EXCHANGE_RATE, 1) ) / :B2 ) * :B2 ) ) UNION SELECT TO_NUMBER( MIN(DECODE(LGD5.GL_POSTED_DATE||LGD5.ACCOUNT_CLASS|| LGD5.ACCOUNT_SET_FLAG, 'REVN', LGD 5.CUST_TRX_LINE_GL_DIST_ID, 'REVY', LGD5.CUST_TRX_LINE_GL_DIST_ID, 'TAXN', LGD5.CUST_TRX_LINE_GL_DIST_ID, 'TAXY', LGD5.CUST_TRX_LINE_GL_DIST_ID, 'FREIGHTN', LGD5.CUST_TRX_LINE_GL_DIST_ID, 'FREIGHTY', LGD5.CUST_TRX_LINE_GL_DIST_ID, 'CHARGESN', LGD5.CUST_TRX_LINE_GL_DIST_ID, 'CHARGESY', LGD5.CUST_TRX_LINE_GL_DIST_ID, 'UNEARNY', LGD5.CUST_TRX_LINE_GL_DIST_ID, 'UNBILLY', LGD5.CUST_TRX_LINE_GL_DIST_ID, NULL ) ) ) FROM RA_CUST_TRX_LINE_GL_DIST REC5, RA_CUST_TRX_LINE_GL_DIST LGD5, RA_CUSTOMER_TRX_LINES CTL2 WHERE CTL2.CUSTOMER_TRX_ID = :B5 AND REC5.CUSTOMER_TRX_ID = LGD5.CUSTOMER_TRX_ID AND REC5.ACCOUNT_CLASS = 'REC' AND REC5.LATEST_REC_FLAG = 'Y' AND LGD5.CUSTOMER_TRX_LINE_ID = CTL2.CUSTOMER_TRX_LINE_ID AND ( CTL2.LINE_TYPE IN ('TAX', 'FREIGHT', 'CHARGES', 'SUSPENSE') OR (CTL2.LINE_TYPE = 'LINE' AND (CTL2.ACCOUNTING_RULE_ID IS NULL OR LGD5.ACCOUNT_SET_FLAG = 'Y') ) ) GROUP BY LGD5.CUSTOMER_TRX_LINE_ID, LGD5.GL_DATE, REC5.GL_DATE, LGD5.ACCOUNT_SET_FLAG, DECODE(LGD5.ACCOUNT_SET_FLAG, 'N', NULL, LGD5.ACCOUNT_CLASS) HAVING SUM(NVL(LGD5.PERCENT, 0)) <> DECODE( NVL(LGD5.GL_DATE, REC5.GL_DATE), REC5.GL_DATE, 100, 0) )
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;
fw8fr3nddyd26 insert into pay_run_balances(run_balance_id, assignment_action_id, assignment_id, action_sequence, defined_balance_id, balance_value, payroll_action_id, effective_date, tax_unit_id, jurisdiction_code, jurisdiction_comp1, jurisdiction_comp2, jurisdiction_comp3, source_id, source_text, tax_group, source_number, source_text2) values (:b1, :b2:b3, :b4:b5, :b6:b7, :b8, :b9, :b10:b11, to_date(:b12, :b13), :b14:b15, :b16:b17, :b18:b19, :b20:b21, :b22:b23, :b24:b25, :b26:b27, :b28:b29, :b30:b31, :b32:b33)
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,664,885 461.83 1.72
CPU used when call started 1,661,234 460.82 1.72
CR blocks created 14,324,364 3,973.49 14.80
Cached Commit SCN referenced 46,156 12.80 0.05
Commit SCN cached 8 0.00 0.00
DB time 4,809,406 1,334.10 4.97
DBWR checkpoint buffers written 2,847,021 789.75 2.94
DBWR checkpoints 34 0.01 0.00
DBWR object drop buffers written 56,968 15.80 0.06
DBWR revisited being-written buffer 263 0.07 0.00
DBWR thread checkpoint buffers written 746,773 207.15 0.77
DBWR transaction table writes 1,717 0.48 0.00
DBWR undo block writes 1,518,500 421.22 1.57
DFO trees parallelized 48 0.01 0.00
IMU CR rollbacks 32,592,737 9,041.02 33.66
IMU Flushes 293,819 81.50 0.30
IMU Redo allocation size 1,930,189,108 535,422.08 1,993.69
IMU commits 505,634 140.26 0.52
IMU contention 33,238 9.22 0.03
IMU ktichg flush 8,401 2.33 0.01
IMU pool not allocated 0 0.00 0.00
IMU recursive-transaction flush 1,310 0.36 0.00
IMU undo allocation size 4,473,646,256 1,240,960.78 4,620.82
IMU- failed to get a private strand 0 0.00 0.00
PX local messages recv'd 51,471 14.28 0.05
PX local messages sent 51,471 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,161,265 10,308.30 38.38
active txn count during cleanout 78,341,877 21,731.53 80.92
application wait time 20,299 5.63 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,013 0.28 0.00
buffer is not pinned count 533,406,154 147,963.45 550.95
buffer is pinned count 1,352,142,381 375,075.63 1,396.62
bytes received via SQL*Net from client 8,236,789,283 2,284,832.53 8,507.76
bytes sent via SQL*Net to client 7,703,084,070 2,136,786.13 7,956.50
calls to get snapshot scn: kcmgss 93,735,861 26,001.73 96.82
calls to kcmgas 18,077,540 5,014.59 18.67
calls to kcmgcs 9,186,383 2,548.24 9.49
change write time 42,000 11.65 0.04
cleanout - number of ktugct calls 21,999,617 6,102.55 22.72
cleanouts and rollbacks - consistent read gets 12,396,138 3,438.61 12.80
cleanouts only - consistent read gets 134,881 37.42 0.14
cluster key scan block gets 813,039 225.53 0.84
cluster key scans 229,486 63.66 0.24
commit batch/immediate performed 3,842 1.07 0.00
commit batch/immediate requested 3,842 1.07 0.00
commit cleanout failures: block lost 212,530 58.95 0.22
commit cleanout failures: buffer being written 532 0.15 0.00
commit cleanout failures: callback failure 103,021 28.58 0.11
commit cleanout failures: cannot pin 28,472 7.90 0.03
commit cleanouts 8,210,519 2,277.55 8.48
commit cleanouts successfully completed 7,865,964 2,181.97 8.12
commit immediate performed 3,842 1.07 0.00
commit immediate requested 3,842 1.07 0.00
commit txn count during cleanout 1,246,082 345.66 1.29
concurrency wait time 13,757 3.82 0.01
consistent changes 736,916,337 204,415.87 761.16
consistent gets 1,633,678,315 453,171.89 1,687.42
consistent gets - examination 1,162,269,185 322,406.02 1,200.51
consistent gets from cache 1,633,678,312 453,171.89 1,687.42
cursor authentications 1,903 0.53 0.00
data blocks consistent reads - undo records applied 733,768,616 203,542.71 757.91
db block changes 186,203,932 51,651.78 192.33
db block gets 207,178,609 57,470.02 213.99
db block gets direct 4,171 1.16 0.00
db block gets from cache 207,174,438 57,468.86 213.99
deferred (CURRENT) block cleanout applications 1,406,507 390.16 1.45
dirty buffers inspected 7,709 2.14 0.01
enqueue conversions 8,290 2.30 0.01
enqueue releases 3,664,450 1,016.49 3.79
enqueue requests 3,671,364 1,018.41 3.79
enqueue timeouts 6,732 1.87 0.01
enqueue waits 33,958 9.42 0.04
exchange deadlocks 30,309 8.41 0.03
execute count 83,560,076 23,179.03 86.31
failed probes on index block reclamation 10,922 3.03 0.01
free buffer inspected 2,584,660 716.97 2.67
free buffer requested 18,477,875 5,125.64 19.09
heap block compress 29,909,440 8,296.69 30.89
hot buffers moved to head of LRU 1,114,296 309.10 1.15
immediate (CR) block cleanout applications 12,531,035 3,476.03 12.94
immediate (CURRENT) block cleanout applications 1,067,743 296.19 1.10
index crx upgrade (found) 26,458 7.34 0.03
index crx upgrade (positioned) 8,291,087 2,299.89 8.56
index fast full scans (rowid ranges) 792 0.22 0.00
index fetch by key 166,863,894 46,286.97 172.35
index scans kdiixs1 118,645,675 32,911.55 122.55
java call heap collected bytes 1,247,362,808 346,010.44 1,288.40
java call heap collected count 15,467,984 4,290.72 15.98
java call heap gc count 4,232 1.17 0.00
java call heap live object count 1,475,465 409.28 1.52
java call heap live object count max 1,523,275 422.55 1.57
java call heap live size 359,355,856 99,683.01 371.18
java call heap live size max 368,597,280 102,246.52 380.72
java call heap object count 3,562,215 988.14 3.68
java call heap object count max 3,575,140 991.72 3.69
java call heap total size 464,519,168 128,854.64 479.80
java call heap total size max 476,055,552 132,054.76 491.72
java call heap used size 494,118,440 137,065.29 510.37
java call heap used size max 500,463,152 138,825.27 516.93
leaf node 90-10 splits 18,971 5.26 0.02
leaf node splits 232,381 64.46 0.24
lob reads 16,678 4.63 0.02
lob writes 28,970 8.04 0.03
lob writes unaligned 28,970 8.04 0.03
logons cumulative 7,570 2.10 0.01
messages received 2,170,623 602.12 2.24
messages sent 2,170,623 602.12 2.24
no buffer to keep pinned count 16 0.00 0.00
no work - consistent read gets 428,728,683 118,926.59 442.83
opened cursors cumulative 4,521,505 1,254.24 4.67
parse count (failures) 2,526 0.70 0.00
parse count (hard) 7,477 2.07 0.01
parse count (total) 7,073,354 1,962.10 7.31
parse time cpu 34,650 9.61 0.04
parse time elapsed 38,668 10.73 0.04
physical read IO requests 276,549 76.71 0.29
physical read bytes 3,557,892,096 986,936.45 3,674.94
physical read total IO requests 305,815 84.83 0.32
physical read total bytes 4,036,476,928 1,119,692.82 4,169.27
physical read total multi block requests 12,972 3.60 0.01
physical reads 434,313 120.48 0.45
physical reads cache 433,023 120.12 0.45
physical reads cache prefetch 157,224 43.61 0.16
physical reads direct 1,290 0.36 0.00
physical reads direct temporary tablespace 558 0.15 0.00
physical reads prefetch warmup 87,247 24.20 0.09
physical write IO requests 1,044,808 289.82 1.08
physical write bytes 23,988,338,688 6,654,211.33 24,777.50
physical write total IO requests 2,130,792 591.07 2.20
physical write total bytes 55,557,722,624 15,411,356.00 57,385.45
physical write total multi block requests 1,261,024 349.80 1.30
physical writes 2,928,264 812.28 3.02
physical writes direct 5,062 1.40 0.01
physical writes direct (lob) 239 0.07 0.00
physical writes direct temporary tablespace 4,431 1.23 0.00
physical writes from cache 2,923,202 810.88 3.02
physical writes non checkpoint 2,228,126 618.07 2.30
pinned buffers inspected 3,165 0.88 0.00
prefetch warmup blocks aged out before use 214,555 59.52 0.22
prefetched blocks aged out before use 121 0.03 0.00
process last non-idle time 3,602 1.00 0.00
queries parallelized 48 0.01 0.00
recursive calls 135,933,854 37,707.18 140.41
recursive cpu usage 955,819 265.14 0.99
redo blocks written 61,492,020 17,057.49 63.51
redo buffer allocation retries 281 0.08 0.00
redo entries 96,100,296 26,657.61 99.26
redo log space requests 0 0.00 0.00
redo log space wait time 0 0.00 0.00
redo ordering marks 1,245,450 345.48 1.29
redo size 30,178,649,452 8,371,363.84 31,171.46
redo subscn max counts 2,270,982 629.96 2.35
redo synch time 46,918 13.01 0.05
redo synch writes 1,709,848 474.30 1.77
redo wastage 275,186,124 76,334.87 284.24
redo write time 33,886 9.40 0.04
redo writer latching time 91 0.03 0.00
redo writes 718,697 199.36 0.74
rollback changes - undo records applied 210,321 58.34 0.22
rollbacks only - consistent read gets 2,096,026 581.42 2.16
rows fetched via callback 87,585,729 24,295.72 90.47
session connect time 0 0.00 0.00
session cursor cache hits 4,535,467 1,258.11 4.68
session logical reads 1,840,856,947 510,641.91 1,901.42
session pga memory 9,053,988,416 2,511,518.33 9,351.84
session pga memory max 10,399,667,840 2,884,801.17 10,741.79
session uga memory ############### 74,785,389.09 278,469.54
session uga memory max 56,086,791,216 15,558,116.24 57,931.92
shared hash latch upgrades - no wait 28,860,709 8,005.78 29.81
shared hash latch upgrades - wait 39,832 11.05 0.04
sorts (memory) 8,680,033 2,407.79 8.97
sorts (rows) 110,749,633 30,721.24 114.39
sql area evicted 2,480 0.69 0.00
sql area purged 2,696 0.75 0.00
summed dirty queue length 319,602 88.66 0.33
switch current to new buffer 1,306,702 362.47 1.35
table fetch by rowid 801,242,377 222,259.50 827.60
table fetch continued row 33,595,901 9,319.29 34.70
table scan blocks gotten 70,304,821 19,502.11 72.62
table scan rows gotten 4,462,927,295 1,237,987.41 4,609.75
table scans (long tables) 2,053 0.57 0.00
table scans (rowid ranges) 2,051 0.57 0.00
table scans (short tables) 4,538,558 1,258.97 4.69
total number of times SMON posted 114,547 31.77 0.12
transaction rollbacks 3,842 1.07 0.00
transaction tables consistent read rollbacks 71 0.02 0.00
transaction tables consistent reads - undo records applied 4,358 1.21 0.00
undo change vector size 10,529,576,600 2,920,837.03 10,875.98
user I/O wait time 101,000 28.02 0.10
user calls 35,483,704 9,842.95 36.65
user commits 781,931 216.90 0.81
user rollbacks 186,219 51.66 0.19
workarea executions - onepass 4 0.00 0.00
workarea executions - optimal 4,985,560 1,382.96 5.15
write clones created in background 1,663 0.46 0.00
write clones created in foreground 3,998 1.11 0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistic Begin Value End Value
session cursor cache count 299,247 830,501
opened cursors current 785,092 914,054
workarea memory allocated 66 172
logons current 3,821 3,824

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 30 0 3.00 1.00 457,136 127 238,876 0.02
APPS_TS_TX_DATA 167,081 46 3.49 1.29 155,667 43 111,722 0.24
APPS_TS_TX_IDX 84,105 23 3.47 1.45 147,261 41 53,586 0.34
APPS_ASSM_DATA 8,544 2 1.66 6.68 139,709 39 45,795 0.38
APPS_ASSM_IDX 6,317 2 1.92 1.04 100,896 28 199,149 0.10
APPS_TS_TX_INTERFACE 1,124 0 3.66 2.17 17,796 5 9,954 0.03
TEMP 352 0 3.89 13.40 8,142 2 10 1.00
SYSTEM 5,220 1 3.68 3.74 2,225 1 17,720 0.05
APPS_TS_SEED 2,579 1 4.36 1.69 3,661 1 919 2.63
APPS_TS_SUMMARY 57 0 6.49 1.00 5,294 1 2,147 0.01
APPS_TS_QUEUES 612 0 3.99 2.76 4,061 1 526 0.23
SYSAUX 291 0 2.27 1.04 1,318 0 0 0.00
APPS_TS_ARCHIVE 63 0 3.17 1.27 1,462 0 73 1.92
APPS_TS_NOLOGGING 25 0 3.60 1.56 42 0 0 0.00
CTXSYS 24 0 3.33 1.00 6 0 0 0.00
APPS_TS_MEDIA 12 0 3.33 1.00 9 0 0 0.00
ODM 12 0 3.33 1.00 3 0 0 0.00
OLAP 12 0 2.50 1.00 3 0 0 0.00
OWAPUB 12 0 3.33 1.00 3 0 0 0.00
PORTAL 12 0 3.33 1.00 3 0 0 0.00
SYNCSERVER 12 0 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,544 2 1.66 6.68 139,709 39 45,795 0.38
APPS_ASSM_IDX /DB/visdata/apps_assm_idx.dbf 6,317 2 1.92 1.04 100,896 28 199,149 0.10
APPS_TS_ARCHIVE /DB/visdata/archive1.dbf 28 0 3.57 1.21 1,225 0 68 2.06
APPS_TS_ARCHIVE /DB/visdata/archive2.dbf 35 0 2.86 1.31 237 0 5 0.00
APPS_TS_MEDIA /DB/visdata/media1.dbf 4 0 2.50 1.00 3 0 0 0.00
APPS_TS_MEDIA /DB/visdata/media2.dbf 4 0 2.50 1.00 3 0 0 0.00
APPS_TS_MEDIA /DB/visdata/media3.dbf 4 0 5.00 1.00 3 0 0 0.00
APPS_TS_NOLOGGING /DB/visdata/nologging1.dbf 4 0 2.50 1.00 3 0 0 0.00
APPS_TS_NOLOGGING /DB/visdata/nologging2.dbf 15 0 4.00 1.00 26 0 0 0.00
APPS_TS_NOLOGGING /DB/visdata/nologging3.dbf 6 0 3.33 3.33 13 0 0 0.00
APPS_TS_QUEUES /DB/visdata/queues1.dbf 128 0 3.13 1.55 516 0 190 0.11
APPS_TS_QUEUES /DB/visdata/queues2.dbf 62 0 4.19 4.27 749 0 215 0.23
APPS_TS_QUEUES /DB/visdata/queues3.dbf 77 0 3.38 3.17 560 0 2 0.00
APPS_TS_QUEUES /DB/visdata/queues4.dbf 58 0 3.79 3.71 528 0 0 0.00
APPS_TS_QUEUES /DB/visdata/queues5.dbf 62 0 4.35 3.74 502 0 3 0.00
APPS_TS_QUEUES /DB/visdata/queues6.dbf 65 0 4.00 3.08 570 0 2 0.00
APPS_TS_QUEUES /DB/visdata/queues7.dbf 160 0 4.81 2.09 636 0 114 0.44
APPS_TS_SEED /DB/visdata/reference1.dbf 214 0 4.63 1.88 354 0 49 3.47
APPS_TS_SEED /DB/visdata/reference10.dbf 248 0 4.64 1.76 384 0 58 2.07
APPS_TS_SEED /DB/visdata/reference2.dbf 233 0 4.42 1.95 362 0 46 0.43
APPS_TS_SEED /DB/visdata/reference3.dbf 381 0 4.04 1.62 442 0 494 2.49
APPS_TS_SEED /DB/visdata/reference4.dbf 238 0 4.75 1.70 386 0 32 5.31
APPS_TS_SEED /DB/visdata/reference5.dbf 267 0 4.34 1.50 352 0 76 3.82
APPS_TS_SEED /DB/visdata/reference6.dbf 302 0 3.84 1.67 350 0 40 1.50
APPS_TS_SEED /DB/visdata/reference7.dbf 241 0 4.69 1.72 331 0 32 5.31
APPS_TS_SEED /DB/visdata/reference8.dbf 226 0 4.34 1.73 329 0 44 1.59
APPS_TS_SEED /DB/visdata/reference9.dbf 229 0 4.24 1.48 371 0 48 2.50
APPS_TS_SUMMARY /DB/visdata/summary1.dbf 5 0 4.00 1.00 661 0 277 0.00
APPS_TS_SUMMARY /DB/visdata/summary2.dbf 5 0 8.00 1.00 582 0 177 0.00
APPS_TS_SUMMARY /DB/visdata/summary3.dbf 7 0 7.14 1.00 563 0 248 0.04
APPS_TS_SUMMARY /DB/visdata/summary4.dbf 10 0 5.00 1.00 538 0 206 0.00
APPS_TS_SUMMARY /DB/visdata/summary5.dbf 7 0 7.14 1.00 612 0 261 0.00
APPS_TS_SUMMARY /DB/visdata/summary6.dbf 7 0 7.14 1.00 781 0 588 0.03
APPS_TS_SUMMARY /DB/visdata/summary7.dbf 9 0 6.67 1.00 819 0 204 0.00
APPS_TS_SUMMARY /DB/visdata/summary8.dbf 7 0 7.14 1.00 738 0 186 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data1.dbf 2,990 1 4.09 1.25 262 0 0 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data10.dbf 2,973 1 3.79 1.24 153 0 0 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data11.dbf 2,922 1 4.07 1.27 117 0 1 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data12.dbf 12,545 3 2.34 1.20 2,203 1 3,312 0.79
APPS_TS_TX_DATA /DB/visdata/tx_data13.dbf 16,851 5 3.80 1.46 3,495 1 2,449 0.84
APPS_TS_TX_DATA /DB/visdata/tx_data14.dbf 12,535 3 3.34 1.35 24,102 7 14,585 0.22
APPS_TS_TX_DATA /DB/visdata/tx_data15.dbf 8,907 2 3.28 1.42 21,457 6 13,983 0.21
APPS_TS_TX_DATA /DB/visdata/tx_data16.dbf 9,042 3 3.15 1.40 20,956 6 15,073 0.20
APPS_TS_TX_DATA /DB/visdata/tx_data17.dbf 8,835 2 3.24 1.40 19,998 6 14,704 0.22
APPS_TS_TX_DATA /DB/visdata/tx_data18.dbf 8,944 2 3.20 1.39 19,670 5 14,941 0.15
APPS_TS_TX_DATA /DB/visdata/tx_data19.dbf 8,760 2 3.17 1.40 19,872 6 14,429 0.21
APPS_TS_TX_DATA /DB/visdata/tx_data2.dbf 6,478 2 2.97 1.12 515 0 2,094 1.03
APPS_TS_TX_DATA /DB/visdata/tx_data20.dbf 8,800 2 3.35 1.42 19,861 6 14,624 0.15
APPS_TS_TX_DATA /DB/visdata/tx_data21.dbf 21,354 6 3.97 1.14 900 0 1,470 0.12
APPS_TS_TX_DATA /DB/visdata/tx_data3.dbf 3,170 1 4.22 1.41 369 0 14 2.86
APPS_TS_TX_DATA /DB/visdata/tx_data4.dbf 17,184 5 3.84 1.10 280 0 12 1.67
APPS_TS_TX_DATA /DB/visdata/tx_data5.dbf 2,912 1 3.92 1.21 290 0 5 6.00
APPS_TS_TX_DATA /DB/visdata/tx_data6.dbf 2,928 1 3.87 1.20 166 0 8 2.50
APPS_TS_TX_DATA /DB/visdata/tx_data7.dbf 2,951 1 3.84 1.19 403 0 18 3.33
APPS_TS_TX_DATA /DB/visdata/tx_data8.dbf 2,936 1 3.81 1.15 396 0 0 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data9.dbf 3,064 1 3.93 1.26 202 0 0 0.00
APPS_TS_TX_IDX /DB/visdata/tx_idx1.dbf 2,501 1 2.99 1.20 1,720 0 1,124 0.62
APPS_TS_TX_IDX /DB/visdata/tx_idx10.dbf 2,450 1 2.98 1.24 1,198 0 1,357 0.66
APPS_TS_TX_IDX /DB/visdata/tx_idx11.dbf 2,417 1 3.04 1.27 1,356 0 1,409 0.60
APPS_TS_TX_IDX /DB/visdata/tx_idx12.dbf 9,797 3 4.02 1.85 17,085 5 1,421 0.17
APPS_TS_TX_IDX /DB/visdata/tx_idx13.dbf 8,316 2 3.54 1.32 20,845 6 2,805 0.23
APPS_TS_TX_IDX /DB/visdata/tx_idx14.dbf 4,575 1 3.66 1.55 13,689 4 2,819 0.15
APPS_TS_TX_IDX /DB/visdata/tx_idx15.dbf 4,578 1 3.52 1.49 11,924 3 4,097 0.12
APPS_TS_TX_IDX /DB/visdata/tx_idx16.dbf 4,692 1 3.63 1.52 10,672 3 3,150 0.15
APPS_TS_TX_IDX /DB/visdata/tx_idx17.dbf 4,532 1 3.74 1.47 10,491 3 3,467 0.14
APPS_TS_TX_IDX /DB/visdata/tx_idx18.dbf 4,844 1 3.66 1.52 10,567 3 4,828 0.14
APPS_TS_TX_IDX /DB/visdata/tx_idx19.dbf 4,677 1 3.49 1.50 9,801 3 3,505 0.18
APPS_TS_TX_IDX /DB/visdata/tx_idx2.dbf 2,807 1 3.33 1.43 1,558 0 1,543 0.47
APPS_TS_TX_IDX /DB/visdata/tx_idx20.dbf 4,639 1 3.58 1.50 9,436 3 2,678 0.15
APPS_TS_TX_IDX /DB/visdata/tx_idx21.dbf 3,353 1 3.96 1.82 11,792 3 2,217 0.67
APPS_TS_TX_IDX /DB/visdata/tx_idx3.dbf 3,993 1 2.47 1.19 1,508 0 1,892 0.99
APPS_TS_TX_IDX /DB/visdata/tx_idx4.dbf 2,658 1 3.02 1.32 2,654 1 1,965 0.88
APPS_TS_TX_IDX /DB/visdata/tx_idx5.dbf 2,602 1 3.18 1.29 3,945 1 7,572 0.17
APPS_TS_TX_IDX /DB/visdata/tx_idx6.dbf 3,123 1 3.47 1.00 2,194 1 1,723 0.92
APPS_TS_TX_IDX /DB/visdata/tx_idx7.dbf 2,541 1 3.23 1.34 2,058 1 1,376 0.54
APPS_TS_TX_IDX /DB/visdata/tx_idx8.dbf 2,483 1 3.00 1.29 1,388 0 1,270 0.82
APPS_TS_TX_IDX /DB/visdata/tx_idx9.dbf 2,527 1 3.15 1.30 1,380 0 1,368 0.69
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte.dbf 226 0 3.50 1.68 2,673 1 1,967 0.03
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte2.dbf 225 0 3.78 2.43 3,674 1 2,284 0.05
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte3.dbf 86 0 4.07 3.87 3,165 1 1,597 0.04
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte4.dbf 136 0 4.26 2.55 2,804 1 1,174 0.01
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte5.dbf 150 0 3.40 2.29 2,648 1 1,703 0.02
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte6.dbf 301 0 3.42 1.63 2,832 1 1,229 0.04
APPS_UNDOTS1 /DB/visdata/undo01.dbf 3 0 3.33 1.00 45,862 13 26,631 0.02
APPS_UNDOTS1 /DB/visdata/undo02.dbf 3 0 6.67 1.00 45,781 13 25,531 0.01
APPS_UNDOTS1 /DB/visdata/undo03.dbf 3 0 0.00 1.00 48,198 13 25,197 0.02
APPS_UNDOTS1 /DB/visdata/undo04.dbf 3 0 3.33 1.00 45,872 13 24,583 0.02
APPS_UNDOTS1 /DB/visdata/undo05.dbf 3 0 0.00 1.00 39,646 11 25,063 0.02
APPS_UNDOTS1 /DB/visdata/undo06.dbf 3 0 3.33 1.00 40,858 11 23,472 0.02
APPS_UNDOTS1 /DB/visdata/undo07.dbf 3 0 3.33 1.00 47,828 13 23,214 0.02
APPS_UNDOTS1 /DB/visdata/undo08.dbf 3 0 3.33 1.00 50,220 14 23,042 0.02
APPS_UNDOTS1 /DB/visdata/undo09.dbf 3 0 0.00 1.00 46,092 13 21,104 0.02
APPS_UNDOTS1 /DB/visdata/undo10.dbf 3 0 6.67 1.00 46,779 13 21,039 0.02
CTXSYS /DB/visdata/ctx1.dbf 12 0 3.33 1.00 3 0 0 0.00
CTXSYS /DB/visdata/ctx2.dbf 12 0 3.33 1.00 3 0 0 0.00
ODM /DB/visdata/odm.dbf 12 0 3.33 1.00 3 0 0 0.00
OLAP /DB/visdata/olap.dbf 12 0 2.50 1.00 3 0 0 0.00
OWAPUB /DB/visdata/owa1.dbf 12 0 3.33 1.00 3 0 0 0.00
PORTAL /DB/visdata/portal.dbf 12 0 3.33 1.00 3 0 0 0.00
SYNCSERVER /DB/visdata/mobile01.dbf 12 0 5.83 1.00 3 0 0 0.00
SYSAUX /DB/visdata/sysaux01.dbf 6 0 5.00 1.00 505 0 0 0.00
SYSAUX /DB/visdata/sysaux02.dbf 285 0 2.21 1.04 813 0 0 0.00
SYSTEM /DB/visdata/sys1.dbf 556 0 3.71 4.28 97 0 69 0.00
SYSTEM /DB/visdata/sys2.dbf 593 0 3.24 4.06 148 0 96 0.21
SYSTEM /DB/visdata/sys3.dbf 691 0 3.05 3.59 195 0 15 0.67
SYSTEM /DB/visdata/sys4.dbf 565 0 3.42 4.24 210 0 9 5.56
SYSTEM /DB/visdata/sys5.dbf 889 0 4.20 3.08 612 0 552 0.25
SYSTEM /DB/visdata/sys6.dbf 557 0 3.72 4.34 96 0 17 4.12
SYSTEM /DB/visdata/sys7.dbf 440 0 3.64 4.50 152 0 76 0.13
SYSTEM /DB/visdata/sys8.dbf 389 0 3.88 3.37 388 0 16,783 0.04
SYSTEM /DB/visdata/sys9.dbf 540 0 4.26 2.61 327 0 103 0.10
TEMP /DB/visdata/temp1.dbf 73 0 3.15 3.47 2,327 1 5 2.00
TEMP /DB/visdata/temp2.dbf 76 0 4.74 1.00 2,030 1 5 0.00
TEMP /DB/visdata/temp3.dbf 102 0 3.73 24.43 1,670 0 0  
TEMP /DB/visdata/temp4.dbf 101 0 3.96 18.77 2,115 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,840,652,970 433,009 2,922,774 0 0 680,476


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 74 34897 815395 3107972 188743680 3107972  
E 180 77 38808 828691 8763933 188743680 8763933  

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,155 15

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

  PGA Aggr Target(M) Auto PGA Target(M) PGA Mem Alloc(M) W/A PGA Used(M) %PGA W/A Mem %Auto W/A Mem %Man W/A Mem Global Mem Bound(K)
B 20,480 1,280 32,722.73 0.46 0.00 100.00 0.00 1,048,576
E 20,480 1,280 40,495.77 0.17 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,524,544 4,524,544 0 0
64K 128K 11,538 11,538 0 0
128K 256K 1,061 1,061 0 0
256K 512K 1,021 1,021 0 0
512K 1024K 138,746 138,746 0 0
1M 2M 308,414 308,414 0 0
2M 4M 74 72 2 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 615,834.62 7,513.14 99.00 919
5,120 0.25 615,834.62 7,436.02 99.00 888
10,240 0.50 615,834.62 7,270.81 99.00 836
15,360 0.75 615,834.62 7,112.36 99.00 789
20,480 1.00 615,834.62 4.94 100.00 739
24,576 1.20 615,834.62 4.94 100.00 603
28,672 1.40 615,834.62 0.00 100.00 193
32,768 1.60 615,834.62 0.00 100.00 0
36,864 1.80 615,834.62 0.00 100.00 0
40,960 2.00 615,834.62 0.00 100.00 0
61,440 3.00 615,834.62 0.00 100.00 0
81,920 4.00 615,834.62 0.00 100.00 0
122,880 6.00 615,834.62 0.00 100.00 0
163,840 8.00 615,834.62 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 282 12,469 1,973,739 1.00 5,909 7.45 145,317,182
1,376 0.59 486 15,449 1,978,081 1.00 1,567 1.98 145,596,783
1,616 0.69 725 19,168 1,978,790 1.00 858 1.08 145,645,440
1,856 0.79 960 24,910 1,978,855 1.00 793 1.00 145,650,455
2,096 0.90 1,068 29,139 1,978,855 1.00 793 1.00 145,650,552
2,336 1.00 1,087 30,796 1,978,855 1.00 793 1.00 145,650,556
2,576 1.10 1,087 30,796 1,978,855 1.00 793 1.00 145,650,556
2,816 1.21 1,087 30,796 1,978,855 1.00 793 1.00 145,650,556
3,056 1.31 1,087 30,796 1,978,855 1.00 793 1.00 145,650,556
3,296 1.41 1,087 30,796 1,978,855 1.00 793 1.00 145,650,556
3,536 1.51 1,087 30,796 1,978,855 1.00 793 1.00 145,650,556
3,776 1.62 1,087 30,796 1,978,855 1.00 793 1.00 145,650,556
4,016 1.72 1,087 30,796 1,978,855 1.00 793 1.00 145,650,556
4,256 1.82 1,087 30,796 1,978,855 1.00 793 1.00 145,650,556
4,496 1.92 1,087 30,796 1,978,855 1.00 793 1.00 145,650,556
4,736 2.03 1,087 30,796 1,978,855 1.00 793 1.00 145,650,556

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

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 15 324 903 1.00 794 1.00 11,773
32 0.50 15 324 903 1.00 794 1.00 11,773
48 0.75 15 324 903 1.00 794 1.00 11,773
64 1.00 15 324 903 1.00 794 1.00 11,773
80 1.25 15 324 903 1.00 794 1.00 11,773
96 1.50 15 324 903 1.00 794 1.00 11,773
112 1.75 15 324 903 1.00 794 1.00 11,773
128 2.00 15 324 903 1.00 794 1.00 11,773

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 433,511 86 0
undo block 198,814 3 0
undo header 40,061 1 0
1st level bmb 4,900 0 0
segment header 2,459 0 0
2nd level bmb 680 0 0
file header block 40 0 0
extent map 11 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) 5,893 508 5,385 482 126 261.04
UL-User-defined 66,164 65,143 1,021 2,364 66 27.72
TX-Transaction (index contention) 26,779 26,779 0 23,877 30 1.24
RO-Multiple Object Reuse (fast object reuse) 288 288 0 31 7 217.10
TM-DML 1,661,916 1,661,867 0 8 3 342.50
HW-Segment High Water Mark 205,938 205,932 6 2,194 2 0.96
TX-Transaction 1,106,241 1,106,245 0 1,725 1 0.44
DV-Diana Versioning 22,848 22,848 0 198 1 3.74
SQ-Sequence Cache 35,972 35,972 0 2,526 1 0.22
FB-Format Block 35,088 35,088 0 395 0 0.25
TX-Transaction (allocate ITL entry) 191 191 0 114 0 0.70
CU-Cursor 7,276 7,276 0 10 0 5.00
PS-PX Process Reservation 1,864 1,544 320 33 0 0.30
US-Undo Segment 7,344 7,344 0 1 0 0.00

Back to Wait Statistics
Back to Top

 

Undo Statistics

Back to Top

Undo Segment Summary

Undo TS# Num Undo Blocks (K) Number of Transactions Max Qry Len (s) Max Tx Concurcy Min/Max TR (mins) STO/ OOS uS/uR/uU/ eS/eR/eU
1 1,476.33 1,089,172 2,675 273 176.983333333333333333333333333333333333/541.95 0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

End Time Num Undo Blocks Number of Transactions Max Qry Len (s) Max Tx Concy Tun Ret (mins) STO/ OOS uS/uR/uU/ eS/eR/eU
05-May 16:27 167,163 134,137 737 268 197 0/0 0/0/0/0/0/0
05-May 16:17 42,475 91,838 580 263 196 0/0 0/0/0/0/0/0
05-May 16:07 455,160 166,310 2,648 267 177 0/0 0/0/0/0/0/0
05-May 15:57 325,861 226,608 2,675 270 231 0/0 0/0/0/0/0/0
05-May 15:47 300,790 338,692 1,798 273 306 0/0 0/0/0/0/0/0
05-May 15:37 184,885 131,587 1,793 270 542 0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

 

Latch Statistics

Back to Top

Latch Activity

Latch Name Get Requests Pct Get Miss Avg Slps /Miss Wait Time (s) NoWait Requests Pct NoWait Miss
ASM db client latch 2,467 0.00   0 0  
AWR Alerted Metric Element list 248,720 0.00   0 0  
Consistent RBA 719,500 0.05 0.09 0 0  
FOB s.o list latch 46,965 0.01 0.00 0 0  
In memory undo latch 720,650,499 1.92 0.00 2 990,605 0.00
JOX SGA heap latch 1,866,488 0.00   0 0  
JS queue state obj latch 21,600 0.00   0 0  
JS slv state obj latch 183 0.00   0 0  
KMG MMAN ready and startup request latch 2,264 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,044 0.15 0.94 0 0  
MQL Tracking Latch 0     0 72 0.00
Memory Management Latch 1,236 0.00   0 2,255 0.00
OS process 11,793 0.00   0 0  
OS process allocation 9,071 0.00   0 0  
OS process: request allocation 7,590 0.01 0.00 0 0  
PL/SQL warning settings 3,555,886 0.00   0 0  
SGA IO buffer pool latch 27,730 0.03 0.00 0 28,658 0.42
SQL memory manager latch 1 0.00   0 1,199 0.00
SQL memory manager workarea list latch 5,418,531 0.00 0.02 0 0  
Shared B-Tree 129 0.00   0 0  
active checkpoint queue latch 1,453,736 1.09 0.00 0 2 0.00
active service list 38,341 0.09 0.00 0 1,281 0.00
begin backup scn array 157 0.00   0 0  
buffer pool 18 0.00   0 0  
cache buffer handles 19,373,315 1.37 0.00 0 0  
cache buffers chains 4,424,653,386 1.05 0.03 21 16,340,886 2.37
cache buffers lru chain 9,284,617 0.34 0.03 0 32,429,224 0.44
cache table scan latch 1,916 0.00   0 1,916 0.00
channel handle pool latch 292,511 0.08 0.00 0 0  
channel operations parent latch 1,288,712 0.47 0.00 0 0  
checkpoint queue latch 19,973,506 0.01 0.01 0 2,934,439 0.04
client/application info 1,305,620 0.00 0.00 0 0  
commit callback allocation 62,846 0.00 0.00 0 0  
compile environment latch 2,228,019 0.00   0 0  
dictionary lookup 78 0.00   0 0  
dml lock allocation 3,310,635 0.16 0.01 0 0  
dummy allocation 15,154 0.25 0.00 0 0  
enqueue hash chains 7,385,169 0.07 0.00 0 531 0.00
enqueues 3,951,359 0.11 0.01 0 0  
error message lists 816 1.47 0.00 0 0  
event group latch 3,799 0.00   0 0  
file cache latch 19,519 0.00   0 0  
global KZLD latch for mem in SGA 7,063 0.00   0 0  
global ctx hash table latch 17,148 0.00   0 0  
hash table column usage latch 1,639 0.00   0 10,949,206 0.00
hash table modification latch 145 0.00   0 0  
internal temp table object number allocation latc 6 0.00   0 0  
job workq parent latch 0     0 122 0.00
job_queue_processes parameter latch 120 0.00   0 0  
kks stats 24,840 0.00   0 0  
ksuosstats global area 242 0.00   0 0  
ktm global data 114,565 0.00   0 0  
kwqbsn:qsga 129 0.00   0 0  
lgwr LWN SCN 722,030 0.13 0.02 0 0  
library cache 268,829,229 0.31 0.01 3 19,835 0.66
library cache load lock 9,799 0.52 0.00 0 30 0.00
library cache lock 42,976,132 0.04 0.01 0 0  
library cache lock allocation 1,133,993 0.01 0.00 0 0  
library cache pin 167,834,770 0.09 0.01 1 57 0.00
library cache pin allocation 399,593 0.00 0.00 0 0  
list of block allocation 419,562 0.02 0.02 0 0  
loader state object freelist 226,608 0.00 0.00 0 0  
longop free list parent 33 0.00   0 33 0.00
message pool operations parent latch 296,542 0.01 0.00 0 0  
messages 6,238,094 0.61 0.00 0 0  
mostly latch-free SCN 759,835 3.85 0.03 0 0  
multiblock read objects 28,542 0.00 0.00 0 0  
ncodef allocation latch 167 0.00   0 0  
object queue header heap 4,040,925 0.02 0.16 0 286,207 0.05
object queue header operation 30,668,635 0.13 0.37 1 17,658 0.02
object stats modification 290,710 0.01 0.00 0 0  
parallel query alloc buffer 8,156 0.99 0.00 0 0  
parallel query stats 528 14.77 0.00 0 0  
parameter table allocation management 17,440 1.53 0.55 0 0  
post/wait queue 966,691 0.04 0.01 0 390,023 0.01
process allocation 7,638 0.07 0.60 0 3,797 0.05
process group creation 7,590 0.00   0 0  
process queue 5,030 0.72 0.00 0 0  
process queue reference 743,496 0.06 0.00 0 81,409 0.93
qmn task queue latch 516 0.00   0 0  
query server freelists 4,256 5.45 0.00 0 0  
query server process 8 0.00   0 8 0.00
redo allocation 4,661,003 3.47 0.01 0 95,883,124 2.20
redo copy 0     0 96,102,688 0.04
redo writing 3,989,628 0.55 0.00 0 0  
resmgr group change latch 603,808 0.00   0 0  
resmgr:actses active list 22,186 0.37 1.01 0 0  
resmgr:actses change group 21,575 0.00   0 0  
resmgr:free threads list 15,152 0.20 0.00 0 0  
resmgr:schema config 1 0.00   0 0  
row cache objects 91,318,926 0.16 0.00 0 7,063 0.11
rules engine aggregate statistics 30,595 0.00   0 0  
rules engine rule set statistics 99,502 0.00 0.00 0 0  
rules engine rule statistics 38,312 0.00   0 0  
sequence cache 15,580,537 0.38 0.00 0 0  
session allocation 15,695,643 0.44 0.01 0 0  
session idle bit 73,190,517 0.01 0.03 0 0  
session state list latch 43,350 0.10 0.62 0 0  
session switching 10,708 0.00   0 0  
session timer 1,282 0.00   0 0  
shared pool 6,491,994 0.15 0.05 0 0  
shared pool sim alloc 331 0.00   0 0  
shared pool simulator 1,908,264 0.00 0.07 0 0  
sim partition latch 1 0.00   0 21,181 0.11
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,007,908 0.12 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 223 0.00   0 0  
temporary table state object allocation 9,148 0.00   0 0  
threshold alerts latch 613 0.00   0 0  
trace latch 17 0.00   0 0  
transaction allocation 84,628 0.00   0 0  
transaction branch allocation 167 0.00   0 0  
undo global data 872,584,190 0.87 0.00 1 27,983 0.06
user lock 28,366 0.02 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,424,653,386 46,347,345 1,184,246 45,336,575 0 0 0
In memory undo latch 720,650,499 13,804,647 14,149 13,792,362 0 0 0
undo global data 872,584,190 7,624,672 4,218 7,621,076 0 0 0
library cache 268,829,229 826,065 6,399 820,395 0 0 0
cache buffer handles 19,373,315 265,013 127 264,912 0 0 0
redo allocation 4,661,003 161,905 848 161,182 0 0 0
library cache pin 167,834,770 158,770 1,646 157,286 0 0 0
row cache objects 91,318,926 146,275 489 145,806 0 0 0
session allocation 15,695,643 68,698 396 68,330 0 0 0
sequence cache 15,580,537 59,735 52 59,693 0 0 0
object queue header operation 30,668,635 38,971 14,382 25,702 0 0 0
messages 6,238,094 38,027 182 37,852 0 0 0
cache buffers lru chain 9,284,617 31,591 1,027 30,601 0 0 0
mostly latch-free SCN 759,835 29,250 880 28,450 0 0 0
redo writing 3,989,628 22,132 60 22,072 0 0 0
library cache lock 42,976,132 18,360 109 18,258 0 0 0
active checkpoint queue latch 1,453,736 15,776 11 15,765 0 0 0
shared pool 6,491,994 10,046 522 9,577 0 0 0
session idle bit 73,190,517 6,299 164 6,142 0 0 0
channel operations parent latch 1,288,712 6,034 6 6,028 0 0 0
dml lock allocation 3,310,635 5,444 39 5,406 0 0 0
enqueue hash chains 7,385,169 5,078 16 5,063 0 0 0
enqueues 3,951,359 4,458 28 4,432 0 0 0
checkpoint queue latch 19,973,506 2,669 16 2,653 0 0 0
sort extent pool 1,007,908 1,230 11 1,219 0 0 0
object queue header heap 4,040,925 983 156 839 0 0 0
lgwr LWN SCN 722,030 934 18 916 0 0 0
post/wait queue 966,691 430 4 426 0 0 0
Consistent RBA 719,500 384 33 358 0 0 0
parameter table allocation management 17,440 266 145 130 0 0 0
channel handle pool latch 292,511 238 1 237 0 0 0
SQL memory manager workarea list latch 5,418,531 227 5 224 0 0 0
resmgr:actses active list 22,186 83 84 0 0 0 0
list of block allocation 419,562 65 1 64 0 0 0
session state list latch 43,350 42 26 16 0 0 0
shared pool simulator 1,908,264 30 2 28 0 0 0
KWQMN job cache list latch 12,044 18 17 1 0 0 0
process allocation 7,638 5 3 2 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 5,568 7,955
In memory undo latch ktiFlush: child 0 4,529 2,792
In memory undo latch kticmt: child 0 3,395 587
In memory undo latch ktichg: child 0 502 2,732
In memory undo latch ktiTxnPoolFree 0 138 0
In memory undo latch ktbgfc 0 9 82
In memory undo latch ktiBRacquire 0 8 0
KWQMN job cache list latch kwqmnuji: update job item 0 17 1
SQL memory manager workarea list latch qesmmIRegisterWorkArea 0 5 1
active checkpoint queue latch kcbbacq: scan active checkpoints 0 11 11
cache buffer handles kcbzgs 0 83 78
cache buffer handles kcbzfs 0 44 49
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 1,381,161 1,542,707
cache buffers chains kcbchg: kslbegin: call CR func 0 598,593 1,065,140
cache buffers chains kcbgtcr: fast path 0 500,504 22,085
cache buffers chains kcbgtcr: kslbegin excl 0 150,579 65,024
cache buffers chains kcbzgb: scan from tail. nowait 0 96,016 0
cache buffers chains kcbrls: kslbegin 0 54,761 98,112
cache buffers chains kcbgcur: kslbegin 0 26,146 12,571
cache buffers chains kcbget: pin buffer 0 15,644 6,925
cache buffers chains kcbzwb 0 5,167 4,185
cache buffers chains kcbcge 0 2,613 5,501
cache buffers chains kcbget: exchange rls 0 2,448 2,680
cache buffers chains kcbget: exchange 0 1,563 4,225
cache buffers chains kcbbxsv 0 278 271
cache buffers chains kcbnlc 0 262 1,384
cache buffers chains kcb_is_private 0 197 3,263
cache buffers chains kcbesc: escalate 0 69 33
cache buffers chains kcbgtcr: kslbegin shared 0 65 55
cache buffers chains kcb_pre_apply: kcbhq61 0 55 1,725
cache buffers chains kcbso1: set no access 0 49 30
cache buffers chains kcbnew: new latch again 0 40 4
cache buffers chains kcb_post_apply: kcbhq63 0 30 342
cache buffers chains kcbbic2 0 5 6
cache buffers chains kcb_post_apply: kcbhq62 0 2 284
cache buffers chains kcbrlb1 0 1 3
cache buffers chains kcbw_next_free 0 1 0
cache buffers chains kcbzhngcbk1: get hash chain latch no wait 0 1 0
cache buffers chains kcbzib: exchange rls 0 1 1
cache buffers lru chain kcbzgws 0 579 0
cache buffers lru chain kcbbxsv: move to being written 0 201 404
cache buffers lru chain kcbo_link_q 0 101 7
cache buffers lru chain kcbgtcr:CR Scan:KCBRSKIP 0 73 0
cache buffers lru chain kcbzgb: posted for free bufs 0 35 248
cache buffers lru chain kcbo_ivd_proc 0 19 150
cache buffers lru chain kcbbic2 0 10 184
cache buffers lru chain kcbzswcu 0 6 34
cache buffers lru chain kcbo_write_process:free_unlink 0 1 0
cache buffers lru chain kcbzgpwb: KSLBEGIN use prewarm buffers 0 1 25
cache buffers lru chain kcbzib 0 1 0
channel handle pool latch ksrchconnect() 0 4 4
channel handle pool latch ksrchdelete() 0 1 1
channel operations parent latch ksrapublish() 0 12 6
channel operations parent latch ksrmfree() 0 9 2
channel operations parent latch ksrchdelete() 0 6 12
channel operations parent latch ksrwait() 0 5 10
channel operations parent latch ksrchconnect() 0 3 2
channel operations parent latch ksrsconsume() 0 2 9
checkpoint queue latch kcbbwthc: thread checkpoint buffers 0 7 6
checkpoint queue latch kcbkubc 0 6 9
checkpoint queue latch kcbklbc: Link buffer into ckpt queue 0 2 0
checkpoint queue latch kcbswcu: Switch buffers 0 1 1
dml lock allocation ktaiam 0 26 29
dml lock allocation ktaidm 0 13 10
enqueue hash chains ksqrcl 0 9 8
enqueue hash chains ksqgtl3 0 6 7
enqueue hash chains ksqcmi: get hash chain latch after wait 0 1 1
enqueues ksqies 0 12 21
enqueues ksqgel: create enqueue 0 11 1
enqueues ksqdel 0 5 6
lgwr LWN SCN kcs023 0 228 0
library cache kglpndl: child: after processing 0 2,488 44
library cache kglpnp: child 0 2,205 3,487
library cache kglobpn: child: 0 538 992
library cache kglpndl: child: before processing 0 395 1,400
library cache kglScanDependency 0 198 0
library cache kglLockCursor 0 174 225
library cache kglpin 0 70 33
library cache kgldte: child 0 0 57 106
library cache kglhdgn: child: 0 55 86
library cache kglic 0 14 0
library cache kgldti: 2child 0 7 2
library cache kglhdiv: child 0 4 0
library cache kglrtl 0 4 1
library cache kglivl: child 0 3 0
library cache kglupd: child 0 2 0
library cache kglget: unpin heap 0 0 1 1
library cache lock kgllkdl: child: cleanup 0 62 66
library cache lock kgllkdl: child: no lock handle 0 51 13
library cache lock kgllkal: child: multiinstance 0 47 43
library cache pin kglpndl 0 759 437
library cache pin kglpnp: child 0 739 922
library cache pin kglpnal: child: alloc space 0 148 287
list of block allocation ktlabl 0 1 0
message pool operations parent latch ksrmalloc() 0 1 0
messages ksaamb: after wakeup 0 66 80
messages ksarcv: after wait 0 63 83
messages ksarcv 0 52 17
messages ksaclr 0 1 2
mostly latch-free SCN kcslcu3 0 653 898
mostly latch-free SCN kcs01 0 18 33
mostly latch-free SCN kcs024 0 17 0
mostly latch-free SCN kcsnew_scn_rba 0 15 0
object queue header heap kcbo_link_q:reget 0 151 4
object queue header heap kcbw_link_q:alloc 0 5 160
object queue header operation kcbo_ivbo 0 14,816 2,996
object queue header operation kcbw_link_q 0 2,762 1,441
object queue header operation kcbw_unlink_q 0 558 4,109
object queue header operation kcbo_switch_mq_bg 0 250 2,460
object queue header operation kcbo_switch_q_bg 0 220 1,839
object queue header operation kcbo_switch_cq 0 84 2,031
object queue header operation kcbo_link_q:reget 0 41 72
object queue header operation kcbo_service_ockpt 0 27 2
object queue header operation kcbo_write_q 0 21 4
object queue header operation kcbo_swap_buf 0 7 366
object queue header operation kcbo_swap_buf_bg 0 7 3,738
parameter table allocation management ksp_param_table_free 0 145 145
post/wait queue ksliwat:remove 0 2 2
post/wait queue ksliwat:add:nowait 0 1 0
post/wait queue kslpstevent:get 0 1 2
process allocation ksucrp 0 3 0
redo allocation kcrfw_redo_gen: redo allocation 1 0 525 0
redo allocation kcrfw_redo_gen: redo allocation 3 0 217 745
redo allocation kcrfw_redo_write: before write 0 51 71
redo allocation kcrfw_redo_gen: redo allocation 2 0 34 0
redo allocation kcrfw_redo_write: more space 0 21 56
redo writing kcrfw_post: after write 0 23 0
redo writing kcrfwcr 0 17 60
redo writing kcrfw_post: rba scn pair 0 13 0
redo writing kcrfw_cal_target_rba 0 7 0
resmgr:actses active list kgskchclass 0 83 48
resmgr:actses active list kgskactladd 0 1 33
row cache objects kqreqd: reget 0 369 4
row cache objects kqrpre: find obj 0 82 364
row cache objects kqreqd 0 35 120
row cache objects kqrso 0 3 0
sequence cache kdnssd 0 30 0
sequence cache kdnnxt: cached seq 0 16 0
sequence cache kdnss 0 6 54
session allocation ksuxds: KSUSFCLC not set 0 189 4
session allocation ksuprc 0 53 72
session allocation ksudlc 0 42 94
session allocation ksuxds: not user session 0 42 61
session allocation ksucri 0 37 116
session allocation kspallmod 0 17 0
session allocation ksursi 0 5 23
session allocation ksudlp 0 4 1
session allocation kxfpqidqr 0 4 21
session allocation kxfprdp 0 3 4
session idle bit ksupuc: set busy 0 161 74
session idle bit ksupuc: clear busy 0 78 156
session idle bit ksuxds 0 10 19
session state list latch kpseqd 0 25 0
session state list latch kpscad 0 1 1
shared pool kghupr1 0 237 381
shared pool kghalo 0 216 89
shared pool kghfrunp: clatch: nowait 0 126 0
shared pool kghfre 0 34 47
shared pool kghfrunp: alloc: wait 0 24 0
shared pool kghfrunp: clatch: wait 0 7 8
shared pool kghfrunp: alloc: session dur 0 6 0
shared pool kghalp 0 4 5
shared pool kghfrh 0 1 0
shared pool simulator kglsim_unpin_simhp 0 2 1
sort extent pool ktstdt: dealloc sort extent 0 9 0
sort extent pool ktstdt: return extent 0 2 0
undo global data kturimugur: child 0 3,749 2,644
undo global data ktudba: KSLBEGIN 0 435 1,560
undo global data ktucof: at start 0 17 0
undo global data ktufrbs: child 0 8 8
undo global data ktudnx:child 0 6 2
undo global data ktusmasp: ktugd_tuux 0 3 1

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 64,938,048 3.53
INV APPS_TS_TX_IDX MTL_ITEM_CATEGORIES_U1   INDEX 50,118,704 2.72
WSH APPS_TS_TX_DATA WSH_DELIVERY_DETAILS   TABLE 21,060,208 1.14
ONT APPS_TS_TX_DATA OE_ORDER_LINES_ALL   TABLE 20,821,504 1.13
GL APPS_TS_TX_DATA GL_CODE_COMBINATIONS   TABLE 18,030,384 0.98

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,061 8.07
AR APPS_ASSM_DATA RA_CUSTOMER_TRX_LINES_ALL   TABLE 12,962 2.98
WSH APPS_TS_TX_DATA WSH_DELIVERY_DETAILS   TABLE 9,554 2.20
HR APPS_ASSM_DATA PAY_RUN_RESULTS   TABLE 4,049 0.93
GL APPS_TS_TX_DATA GL_CODE_COMBINATIONS   TABLE 1,199 0.28

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 12,439 28.86
WSH APPS_TS_TX_DATA WSH_TRIP_STOPS   TABLE 10,298 23.89
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_U1   INDEX 9,430 21.88
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N6   INDEX 3,123 7.25
HR APPS_ASSM_IDX PAY_RUN_RESULT_VALUES_PK   INDEX 1,665 3.86

Back to Segment Statistics
Back to Top

Segments by ITL Waits

Owner Tablespace Name Object Name Subobject Name Obj. Type ITL Waits % of Capture
GL APPS_ASSM_IDX GL_IMPORT_REFERENCES_N1   INDEX 17 20.00
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N6   INDEX 16 18.82
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N5   INDEX 11 12.94
APPLSYS APPS_TS_TX_IDX WF_ITEM_ATTRIBUTE_VALUES_PK   INDEX 10 11.76
GL APPS_ASSM_IDX GL_IMPORT_REFERENCES_N3   INDEX 6 7.06

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 142,463 40.08
APPLSYS APPS_TS_TX_DATA WF_ITEM_ATTRIBUTE_VALUES   TABLE 60,755 17.09
GL APPS_ASSM_DATA GL_JE_LINES   TABLE 21,503 6.05
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N6   INDEX 21,132 5.95
SYS SYSTEM DBMS_LOCK_ALLOCATED   TABLE 16,756 4.71

Back to Segment Statistics
Back to Top

 

Dictionary Cache Stats

Cache Get Requests Pct Miss Scan Reqs Pct Miss Mod Reqs Final Usage
dc_awr_control 5 20.00 0   2 1
dc_constraints 648 47.07 0   648 0
dc_files 6,660 0.00 0   0 111
dc_global_oids 5,463,133 0.00 0   0 44
dc_histogram_data 48,093 1.14 0   0 524
dc_histogram_defs 313,850 3.24 0   4,044 3,294
dc_object_grants 51,152 0.07 0   0 76
dc_object_ids 8,890,706 0.02 0   58 1,249
dc_objects 134,463 1.29 0   347 776
dc_profiles 7,124 0.00 0   0 1
dc_rollback_segments 18,539 0.02 0   9 274
dc_segments 274,202 0.79 0   14,752 1,316
dc_sequences 45,745 0.14 0   45,745 105
dc_table_scns 16,836 0.05 0   0 5
dc_tablespace_quotas 14,607 0.21 0   210 42
dc_tablespaces 4,428,324 0.00 0   0 22
dc_usernames 368,903 0.01 0   0 19
dc_users 10,773,996 0.00 0   0 64
outstanding_alerts 277 2.17 0   9 44


Back to Top

 

Library Cache Activity

Namespace Get Requests Pct Miss Pin Requests Pct Miss Reloads Invali- dations
BODY 473,047 0.03 32,098,124 0.00 8 0
CLUSTER 97 1.03 232 1.29 2 0
INDEX 11,138 0.57 11,950 0.78 0 0
JAVA DATA 622 0.00 0   0 0
PIPE 35,598 2.52 52,123 1.72 0 0
SQL AREA 5,489 92.08 90,978,671 0.20 2,709 370
TABLE/PROCEDURE 297,489 0.33 44,305,047 0.01 1,086 0
TRIGGER 21,465 0.13 1,256,479 0.00 29 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,002.27   11.27 6.74 37 37 2,308 2,308
  Freeable 2,447.19 0.00 1.24 0.77 9   1,980 1,980
  SQL 2,427.72 1,243.02 1.06 0.68 4 21 2,300 2,299
  PL/SQL 1,660.41 139.88 0.72 0.93 3 3 2,308 2,308
  JAVA 186.08 185.27 2.22 0.35 5 8 84 84
E Other 32,281.90   13.94 8.58 42 42 2,316 2,316
  Freeable 3,138.94 0.00 1.52 0.94 9   2,061 2,061
  SQL 2,904.40 1,523.36 1.26 0.76 5 21 2,308 2,307
  PL/SQL 1,985.32 161.48 0.86 0.97 3 3 2,316 2,316
  JAVA 185.98 185.16 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,075,694,592 18,924,699,648
Fixed Size 2,111,120  
Redo Buffers 14,663,680  
Variable Size 2,382,367,088 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 33.04 32.92 -0.37
shared KTI-UNDO 53.19 53.19 0.00
shared PL/SQL MPCODE 66.79 69.40 3.91
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 325.84 336.35 3.23
shared library cache 607.73 742.58 22.19
shared parameter table block 41.97 42.01 0.11
shared private strands 99.77 99.77 0.00
shared sessions 36.42 36.42 0.00
shared sql area 336.92 340.00 0.91
shared trace buffer 36.16 36.42 0.73
  buffer_cache 18,192.00 18,048.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