Oracle
Sitefinder
    WorldwideChange Country, Oracle Worldwide Web Sites
Secure Search

AWR Report

WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
VIS187584551VIS110.2.0.3.0NOhpdb1.zko.hp

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:126-Aug-08 07:12:014775 207.6
End Snap:226-Aug-08 08:12:064807 237.6
Elapsed:  60.09 (mins)  
DB Time:  434.92 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 17,840M 17,664MStd Block Size: 8K
Shared Pool Size: 2,512M 2,688MLog Buffer: 14,320K

Load Profile

Per SecondPer Transaction
Redo size: 8,768,802.13 27,305.14
Logical reads: 553,776.68 1,724.40
Block changes: 54,464.02 169.60
Physical reads: 131.47 0.41
Physical writes: 874.44 2.72
User calls: 12,478.89 38.86
Parses: 2,365.04 7.36
Hard parses: 2.43 0.01
Sorts: 2,831.71 8.82
Logons: 2.58 0.01
Executes: 27,161.24 84.58
Transactions: 321.14 

% Blocks changed per Read: 9.84Recursive Call %: 77.89
Rollback per transaction %: 20.64Rows per Sort: 12.45

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.95Redo NoWait %: 100.00
Buffer Hit %: 99.98In-memory Sort %: 100.00
Library Hit %: 99.96Soft Parse %: 99.90
Execute to Parse %: 91.29Latch Hit %: 98.47
Parse CPU to Parse Elapsd %: 89.79% Non-Parse CPU: 97.59

Shared Pool Statistics

BeginEnd
Memory Usage %: 84.01 85.31
% SQL with executions>1: 90.02 89.77
% Memory for SQL w/exec>1: 68.33 66.90

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
CPU time  23,983  91.9 
db file sequential read 280,545 1,162 4 4.5User I/O
log file sync 488,290 683 1 2.6Commit
log file parallel write 843,813 439 1 1.7System I/O
db file parallel write 235,714 197 1 .8System I/O

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

  • Total time in database user-calls (DB Time): 26095.1s
  • Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic
  • Ordered by % or DB time desc, Statistic name
Statistic NameTime (s)% of DB Time
DB CPU 23,982.89 91.91
sql execute elapsed time 22,400.70 85.84
PL/SQL execution elapsed time 5,148.80 19.73
inbound PL/SQL rpc elapsed time 5,123.02 19.63
parse time elapsed 717.32 2.75
Java execution elapsed time 472.10 1.81
hard parse elapsed time 358.21 1.37
repeated bind elapsed time 89.58 0.34
sequence load elapsed time 17.17 0.07
connection management call elapsed time 13.49 0.05
PL/SQL compilation elapsed time 8.33 0.03
hard parse (sharing criteria) elapsed time 3.75 0.01
failed parse elapsed time 1.77 0.01
hard parse (bind mismatch) elapsed time 1.20 0.00
DB time 26,095.06  
background elapsed time 1,222.06  
background cpu time 489.83  

Back to Wait Events Statistics
Back to Top

Wait Class

  • s - second
  • cs - centisecond - 100th of a second
  • ms - millisecond - 1000th of a second
  • us - microsecond - 1000000th of a second
  • ordered by wait time desc, waits desc
Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
User I/O 334,919 0.00 1,341 4 0.29
Commit 488,290 0.00 683 1 0.42
System I/O 1,110,416 0.00 647 1 0.96
Application 62,747 0.11 255 4 0.05
Network 51,375,053 0.00 178 0 44.37
Concurrency 3,322,074 0.14 151 0 2.87
Other 157,872 35.22 40 0 0.14
Configuration 8,311 0.04 4 1 0.01

Back to Wait Events Statistics
Back to Top

Wait Events

  • s - second
  • cs - centisecond - 100th of a second
  • ms - millisecond - 1000th of a second
  • us - microsecond - 1000000th of a second
  • ordered by wait time desc, waits desc (idle events last)
EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
db file sequential read 280,545 0.00 1,162 4 0.24
log file sync 488,290 0.00 683 1 0.42
log file parallel write 843,813 0.00 439 1 0.73
db file parallel write 235,714 0.00 197 1 0.20
enq: TX - row lock contention 462 11.47 179 388 0.00
db file scattered read 15,765 0.00 104 7 0.01
SQL*Net more data from client 2,334,043 0.00 97 0 2.02
read by other session 35,401 0.00 71 2 0.03
enq: UL - contention 1,531 1.05 59 39 0.00
SQL*Net message to client 47,136,655 0.00 55 0 40.71
cursor: pin S wait on X 4,964 92.49 50 10 0.00
latch: cache buffers chains 2,239,041 0.00 37 0 1.93
buffer busy waits 1,013,896 0.00 28 0 0.88
SQL*Net more data to client 1,904,355 0.00 27 0 1.64
enq: TX - index contention 32,757 0.00 15 0 0.03
library cache load lock 782 0.00 14 18 0.00
PX Deq Credit: send blkd 23,362 0.00 11 0 0.02
SQL*Net break/reset to client 60,722 0.00 10 0 0.05
control file sequential read 29,150 0.00 9 0 0.03
rdbms ipc reply 5 60.00 7 1456 0.00
enq: RO - fast object reuse 30 0.00 6 209 0.00
kksfbc child completion 128 82.81 5 41 0.00
buffer exterminate 6 83.33 5 815 0.00
local write wait 1,990 0.00 4 2 0.00
os thread startup 70 0.00 3 40 0.00
PX Deq: Signal ACK 206 35.92 2 12 0.00
enq: HW - contention 3,396 0.00 2 1 0.00
latch: library cache 6,201 0.00 2 0 0.01
wait list latch free 177 0.00 2 11 0.00
latch: object queue header operation 26,787 0.00 1 0 0.02
LGWR wait for redo copy 35,316 0.00 1 0 0.03
enq: TX - contention 3,025 0.00 1 0 0.00
control file parallel write 1,739 0.00 1 1 0.00
enq: DV - contention 185 0.00 1 5 0.00
row cache lock 3,604 0.00 1 0 0.00
log buffer space 162 0.00 1 5 0.00
latch: In memory undo latch 13,868 0.00 1 0 0.01
enq: SQ - contention 4,569 0.00 1 0 0.00
latch free 1,212 0.00 1 1 0.00
latch: library cache pin 1,953 0.00 1 0 0.00
direct path read 732 0.00 0 1 0.00
latch: undo global data 3,148 0.00 0 0 0.00
write complete waits 8 37.50 0 49 0.00
SGA: allocation forcing component growth 32 56.25 0 10 0.00
buffer deadlock 54,652 98.58 0 0 0.05
latch: session allocation 1,322 0.00 0 0 0.00
library cache pin 2,366 0.00 0 0 0.00
latch: row cache objects 1,263 0.00 0 0 0.00
enq: TX - allocate ITL entry 146 0.00 0 1 0.00
latch: cache buffers lru chain 1,232 0.00 0 0 0.00
library cache lock 9 0.00 0 19 0.00
latch: redo allocation 776 0.00 0 0 0.00
enq: FB - contention 829 0.00 0 0 0.00
latch: shared pool 605 0.00 0 0 0.00
latch: library cache lock 198 0.00 0 0 0.00
cursor: pin S 3,282 0.00 0 0 0.00
latch: messages 168 0.00 0 0 0.00
PX qref latch 1,561 97.37 0 0 0.00
enq: TM - contention 2 0.00 0 12 0.00
enq: CU - contention 3 0.00 0 8 0.00
latch: object queue header heap 192 0.00 0 0 0.00
latch: cache buffer handles 148 0.00 0 0 0.00
reliable message 33 0.00 0 0 0.00
L1 validation 3 33.33 0 4 0.00
cursor: mutex S 199 0.00 0 0 0.00
latch: redo writing 30 0.00 0 0 0.00
enq: PS - contention 37 0.00 0 0 0.00
direct path write 442 0.00 0 0 0.00
latch: checkpoint queue latch 27 0.00 0 0 0.00
latch: enqueue hash chains 18 0.00 0 0 0.00
cursor: mutex X 298 0.00 0 0 0.00
direct path write temp 38 0.00 0 0 0.00
direct path read temp 6 0.00 0 0 0.00
SQL*Net message from client 47,136,617 0.00 9,269,840 197 40.71
pipe get 26,946 16.35 21,072 782 0.02
Streams AQ: waiting for time management or cleanup tasks 2,714 39.90 3,505 1291 0.00
Streams AQ: qmn slave idle wait 128 0.00 3,484 27218 0.00
Streams AQ: qmn coordinator idle wait 256 50.00 3,484 13609 0.00
PX Idle Wait 1,645 76.35 2,575 1565 0.00
PL/SQL lock timer 222 99.10 2,473 11138 0.00
jobq slave wait 615 99.67 1,800 2927 0.00
PX Deq: Execution Msg 5,097 0.00 35 7 0.00
PX Deq: Execute Reply 2,680 0.00 3 1 0.00
PX Deq Credit: need buffer 3,895 0.00 1 0 0.00
PX Deq: Msg Fragment 4,356 0.00 0 0 0.00
PX Deq: Table Q Normal 5,783 0.00 0 0 0.00
PX Deq: Parse Reply 288 0.00 0 1 0.00
PX Deq: Join ACK 228 0.00 0 0 0.00
class slave wait 1 0.00 0 1 0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

  • ordered by wait time desc, waits desc (idle events last)
EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
log file parallel write 843,800 0.00 439 1 0.73
db file parallel write 235,714 0.00 197 1 0.20
control file sequential read 827 0.00 3 4 0.00
os thread startup 62 0.00 3 40 0.00
events in waitclass Other 45,339 0.00 2 0 0.04
db file scattered read 501 0.00 2 4 0.00
control file parallel write 1,739 0.00 1 1 0.00
db file sequential read 289 0.00 1 3 0.00
direct path read 732 0.00 0 1 0.00
latch: cache buffers chains 168 0.00 0 0 0.00
latch: redo writing 30 0.00 0 0 0.00
direct path write 333 0.00 0 0 0.00
latch: library cache lock 1 0.00 0 1 0.00
log file sync 1 0.00 0 1 0.00
buffer busy waits 15 0.00 0 0 0.00
latch: shared pool 2 0.00 0 0 0.00
latch: In memory undo latch 1 0.00 0 0 0.00
rdbms ipc message 1,690,773 0.72 37,540 22 1.46
pmon timer 1,263 96.36 3,514 2782 0.00
Streams AQ: waiting for time management or cleanup tasks 2,714 39.90 3,505 1291 0.00
smon timer 158,837 0.00 3,497 22 0.14
Streams AQ: qmn slave idle wait 128 0.00 3,484 27218 0.00
Streams AQ: qmn coordinator idle wait 256 50.00 3,484 13609 0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
BUSY_TIME 2,636,807
IDLE_TIME 5,931,270
IOWAIT_TIME 97,414
NICE_TIME 0
SYS_TIME 158,231
USER_TIME 2,389,063
LOAD 5
RSRC_MGR_CPU_WAIT_TIME 0
PHYSICAL_MEMORY_BYTES 52,617,128
NUM_CPUS 24
NUM_CPU_SOCKETS 4

Back to Wait Events Statistics
Back to Top

Service Statistics

  • ordered by DB Time
Service NameDB Time (s)DB CPU (s)Physical ReadsLogical Reads
SYS$USERS 26,094.50 23,982.60 458,893 1,992,929,728
SYS$BACKGROUND 0.00 0.00 15,087 3,500,839
VIS 0.00 0.00 0 0

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

  • Wait Class info for services in the Service Statistics section.
  • Total Waits and Time Waited displayed for the following wait classes: User I/O, Concurrency, Administrative, Network
  • Time Waited (Wt Time) in centisecond (100th of a second)
Service NameUser I/O Total WtsUser I/O Wt TimeConcurcy Total WtsConcurcy Wt TimeAdmin Total WtsAdmin Wt TimeNetwork Total WtsNetwork Wt Time
SYS$USERS 333058 133815 3321783 14894 0 0 51354820 17843
SYS$BACKGROUND 1857 304 249 252 0 0 0 0

Back to Wait Events Statistics
Back to Top

SQL Statistics

Back to Top

SQL ordered by Elapsed Time

  • Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
  • % Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100
Elapsed Time (s)CPU Time (s)Executions Elap per Exec (s) % Total DB Time SQL IdSQL ModuleSQL Text
764 763 304 2.51 2.93 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
602 593 16 37.65 2.31 7g05xfvc5vp74 ARTERRPW BEGIN arp_run.revenue_recognit...
540 511 101,548 0.01 2.07 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
469 438 182,335 0.00 1.80 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
429 424 56,284 0.01 1.64 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
419 418 337,977 0.00 1.61 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
396 394 56,017 0.01 1.52 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...
395 393 1,296 0.31 1.52 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
368 367 63,094 0.01 1.41 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
359 357 56,400 0.01 1.37 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
333 306 239,765 0.00 1.28 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
287 280 72,460 0.00 1.10 3prk3vg9u0abb FNDOAMCOL BEGIN FND_GLOBAL.APPS_INITIA...
279 132 2,164 0.13 1.07 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

  • Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
  • % Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100
CPU Time (s)Elapsed Time (s)Executions CPU per Exec (s)% Total DB Time SQL IdSQL ModuleSQL Text
763 764 304 2.51 2.93 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
593 602 16 37.04 2.31 7g05xfvc5vp74 ARTERRPW BEGIN arp_run.revenue_recognit...
511 540 101,548 0.01 2.07 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
438 469 182,335 0.00 1.80 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
424 429 56,284 0.01 1.64 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
418 419 337,977 0.00 1.61 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
394 396 56,017 0.01 1.52 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...
393 395 1,296 0.30 1.52 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
367 368 63,094 0.01 1.41 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
357 359 56,400 0.01 1.37 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
306 333 239,765 0.00 1.28 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
280 287 72,460 0.00 1.10 3prk3vg9u0abb FNDOAMCOL BEGIN FND_GLOBAL.APPS_INITIA...
132 279 2,164 0.06 1.07 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....

Back to SQL Statistics
Back to Top

SQL ordered by Gets

  • Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
  • Total Buffer Gets: 1,996,474,580
  • Captured SQL account for 11.6% of Total
Buffer Gets Executions Gets per Exec %TotalCPU Time (s)Elapsed Time (s) SQL IdSQL ModuleSQL Text
101,280,711 16 6,330,044.44 5.07 592.64 602.47 7g05xfvc5vp74 ARTERRPW BEGIN arp_run.revenue_recognit...
68,618,659 182,335 376.33 3.44 437.60 469.30 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
66,630,273 239,765 277.90 3.34 305.81 333.05 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
47,311,611 56,284 840.59 2.37 424.45 428.80 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f...
43,611,136 304 143,457.68 2.18 762.75 763.64 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3...
41,928,020 156,479 267.95 2.10 148.18 148.61 5kqw5535fjvw6 ARXTWMAI SELECT NVL(RCTT.ATTRIBUTE10, ...
37,877,824 56,400 671.59 1.90 357.04 358.75 9wdrypwkpf607 WSHINTERFACE begin OE_FULFILL_WF.START_FULF...
32,811,498 63,094 520.04 1.64 366.60 368.45 g8102j8yynbwz OEXOETEL begin WF_STANDARD.CONTINUEFLOW...
32,315,518 1,517,587 21.29 1.62 150.56 150.82 66tmsr3446uqn ap.oie.server.WebExpensesAM SELECT WIAS.ACTIVITY_STATUS, ...
27,899,886 1,296 21,527.69 1.40 392.96 395.36 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS...
27,839,322 171,469 162.36 1.39 190.00 192.44 3b3psftuyks81 INVTTMTX BEGIN INV_TXNSTUB_PUB.postTran...
27,640,236 171,302 161.35 1.38 178.94 181.35 gf1u933c95jb5 INVTTMTX DECLARE l_ret_stat varchar2...
26,395,244 56,017 471.20 1.32 393.69 396.31 gksvm8wmzk8w0 WSHINTERFACE begin OE_INVOICE_WF.INVOICE_IN...
26,392,236 9,999 2,639.49 1.32 121.65 220.22 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

  • Total Disk Reads: 473,960
  • Captured SQL account for 30.6% of Total
Physical ReadsExecutionsReads per Exec %TotalCPU Time (s)Elapsed Time (s) SQL IdSQL ModuleSQL Text
45,240 9,999 4.52 9.55 121.65 220.22 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS...
41,450 2,164 19.15 8.75 132.41 278.99 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO....
39,001 2,164 18.02 8.23 17.89 190.52 3dssuqfjsynrk asn.lead.server.LeadUwqAM SELECT count(1) FROM (SELECT *...
25,686 19,470 1.32 5.42 170.80 258.14 1q78dwnrrkf6c asn.lead.server.LeadUwqAM BEGIN ASN_SALES_PVT.Lead_Proce...
13,599 239,765 0.06 2.87 305.81 333.05 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
9,559 6,488 1.47 2.02 131.85 169.60 8jb36w62w5hqf ibuSRDetailsActions.jsp BEGIN IBU_REQ_PKG.UpdateServic...
9,527 182,335 0.05 2.01 437.60 469.30 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
4,551 9,951 0.46 0.96 159.07 171.51 csvvv0fmhr1yc PYUSLV BEGIN FFP1893_01010001.FORMULA...
4,513 9,996 0.45 0.95 131.73 141.91 63t8zpm02skgh PYUSLV SELECT DECODE(COUNT(PRR.RUN_RE...
1,236 324 3.81 0.26 149.41 152.80 fumydqvpk1g21 qotSCopOverview.jsp BEGIN ASO_QUOTE_PUB_W.SUBMIT_Q...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

  • Total Executions: 97,921,653
  • Captured SQL account for 7.6% of Total
Executions Rows ProcessedRows per ExecCPU per Exec (s)Elap per Exec (s) SQL IdSQL ModuleSQL Text
1,517,587 784,422 0.52 0.00 0.00 66tmsr3446uqn ap.oie.server.WebExpensesAM SELECT WIAS.ACTIVITY_STATUS, ...
859,241 859,141 1.00 0.00 0.00 cd9mbmqyf4qhp ap.oie.server.WebExpensesAM UPDATE WF_ITEM_ACTIVITY_STATUS...
537,796 537,754 1.00 0.00 0.00 avc1jqzz04wpr JDBC Thin Client SELECT 'x' FROM DUAL
337,977 337,961 1.00 0.00 0.00 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
315,636 242,361 0.77 0.00 0.00 fmfdkztk8vx23   SELECT CATEGORY, SEVERITY, F...
262,067 4,454,780 17.00 0.00 0.00 cwyx16zn1hpfb JDBC Thin Client select parameter, value from ...
239,765 0 0.00 0.00 0.00 25wzrzwd46a44 asn.dashboard.server.DashboardAM SELECT 1 FROM DUAL WHERE EXIST...
182,335 182,332 1.00 0.00 0.00 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
171,469 171,465 1.00 0.00 0.00 3b3psftuyks81 INVTTMTX BEGIN INV_TXNSTUB_PUB.postTran...
171,420 171,364 1.00 0.00 0.00 6gnth2mfbs2nq INVTTMTX declare v_ret number := 0...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

  • Total Parse Calls: 8,526,421
  • Captured SQL account for 43.1% of Total
Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
537,764 537,796 6.31 avc1jqzz04wpr JDBC Thin Client SELECT 'x' FROM DUAL
337,974 337,977 3.96 a29grr748ghc4 fnd.framework.navigate.server.OANavigatePortletA BEGIN jdr_custom_internal.getA...
315,638 315,636 3.70 fmfdkztk8vx23   SELECT CATEGORY, SEVERITY, F...
262,058 262,067 3.07 cwyx16zn1hpfb JDBC Thin Client select parameter, value from ...
182,327 182,335 2.14 827gtfny5uagb CSCCCCRC begin :con := FND_GENERIC_POLI...
168,123 171,420 1.97 6gnth2mfbs2nq INVTTMTX declare v_ret number := 0...
121,866 122,610 1.43 fb13x9qx0ftks OEXOETEL begin OE_STANDARD_WF.OEOL_SELE...
113,627 114,883 1.33 1c0b7sas42w2z INVTTMTX SELECT NVL(ITEM_COST, 0), ...
108,360 108,373 1.27 162ttnv4ubqun OEXOETEL begin OE_DS_PVT.Check_PO_Appr...
100,206 100,269 1.18 8camsgjsr9zya OEXOETEL begin OE_TRANSACTION_TYPES_PK...
97,062 97,173 1.14 76sw2a4vnc89j icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.S...
91,729 97,203 1.08 dcvv68fju01g4 icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.E...
91,662 91,773 1.08 608c0n36kaw62 icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.C...
91,627 91,790 1.07 bf7uwg5pa3pj6 icx.por.req.server.RequisitionAM begin FND_FLEX_WORKFLOW_APIS.V...

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

  • Only Statements with Version Count greater than 20 are displayed
Version Count Executions SQL IdSQL ModuleSQL Text
22 91 axmdf8vq7k1rh   select increment$, minvalue, m...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
0z318y6g3uagcdeclare 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
1q78dwnrrkf6cBEGIN 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;
25wzrzwd46a44SELECT 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 )
3b3psftuyks81BEGIN 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 ) )
3prk3vg9u0abbBEGIN FND_GLOBAL.APPS_INITIALIZE( user_id=>:1 , resp_id=>:2 , resp_appl_id=>:3 , security_group_id=>:4 , server_id=>:5);END;
4yak7x2zqz0dhBEGIN inv_transfer_order_pvt.finalize_pick_confirm(:1, :2, :3, :4, :5, :6, :7); END;
5kqw5535fjvw6SELECT 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
608c0n36kaw62begin FND_FLEX_WORKFLOW_APIS.COPY_FROM_COMBINATION (:v1, :v2, :v3, :v4, :v5); end;
63t8zpm02skghSELECT 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
66tmsr3446uqnSELECT 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;
6h2tpcxpymqu7BEGIN :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;
76sw2a4vnc89jbegin FND_FLEX_WORKFLOW_APIS.START_GENERATION (:v1, :v2, :v3, :v4, :v5); end;
7g05xfvc5vp74BEGIN arp_run.revenue_recognition( :errbuf, :rc, :A0, :A1, :A2); END;
827gtfny5uagbbegin :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;
8jb36w62w5hqfBEGIN IBU_REQ_PKG.UpdateServiceRequest(:1, :2, -1, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16); END;
9wdrypwkpf607begin OE_FULFILL_WF.START_FULFILLMENT (:v1, :v2, :v3, :v4, :v5); end;
a29grr748ghc4BEGIN jdr_custom_internal.getActiveLayers(:1, :2, :3, :4, :5); END;
avc1jqzz04wprSELECT 'x' FROM DUAL
axmdf8vq7k1rhselect increment$, minvalue, maxvalue, cycle#, order$, cache, highwater, audit$, flags from seq$ where obj#=:1
bf7uwg5pa3pj6begin FND_FLEX_WORKFLOW_APIS.VALIDATE_COMBINATION (:v1, :v2, :v3, :v4, :v5); end;
bt0w082dfrm8vBEGIN WSH_SHIP_CONFIRM_ACTIONS.interface_ALL_wrp( :errbuf, :rc, :A0, :A1, :A2, :A3); END;
cd9mbmqyf4qhpUPDATE 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
csvvv0fmhr1ycBEGIN 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;
cwyx16zn1hpfbselect parameter, value from nls_session_parameters
dcvv68fju01g4begin FND_FLEX_WORKFLOW_APIS.END_GENERATION (:v1, :v2, :v3, :v4, :v5); end;
fb13x9qx0ftksbegin OE_STANDARD_WF.OEOL_SELECTOR (:v1, :v2, :v3, :v4, :v5); end;
fmfdkztk8vx23SELECT CATEGORY, SEVERITY, FND_LOG_SEVERITY FROM FND_NEW_MESSAGES WHERE MESSAGE_NAME = :B1 AND APPLICATION_ID = :B2 AND LANGUAGE_CODE = :B3 AND ROWNUM = 1
fumydqvpk1g21BEGIN 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;
g8102j8yynbwzbegin WF_STANDARD.CONTINUEFLOW (:v1, :v2, :v3, :v4, :v5); end;
gf1u933c95jb5DECLARE 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;
gksvm8wmzk8w0begin 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

StatisticTotalper Secondper Trans
CPU used by this session 2,391,123 663.24 2.07
CPU used when call started 2,385,221 661.61 2.06
CR blocks created 15,958,432 4,426.51 13.78
Cached Commit SCN referenced 46,929 13.02 0.04
Commit SCN cached 8 0.00 0.00
DB time 5,338,236 1,480.71 4.61
DBWR checkpoint buffers written 3,066,020 850.44 2.65
DBWR checkpoints 31 0.01 0.00
DBWR object drop buffers written 56,390 15.64 0.05
DBWR revisited being-written buffer 428 0.12 0.00
DBWR thread checkpoint buffers written 562,267 155.96 0.49
DBWR transaction table writes 2,474 0.69 0.00
DBWR undo block writes 1,589,998 441.03 1.37
DFO trees parallelized 48 0.01 0.00
IMU CR rollbacks 41,646,430 11,551.77 35.97
IMU Flushes 339,901 94.28 0.29
IMU Redo allocation size 2,225,423,536 617,281.92 1,922.15
IMU commits 598,205 165.93 0.52
IMU contention 41,615 11.54 0.04
IMU ktichg flush 10,459 2.90 0.01
IMU pool not allocated 0 0.00 0.00
IMU recursive-transaction flush 1,731 0.48 0.00
IMU undo allocation size 5,368,831,416 1,489,191.83 4,637.19
IMU- failed to get a private strand 0 0.00 0.00
PX local messages recv'd 52,293 14.50 0.05
PX local messages sent 52,293 14.50 0.05
Parallel operations downgraded 25 to 50 pct 40 0.01 0.00
Parallel operations not downgraded 8 0.00 0.00
SQL*Net roundtrips to/from client 47,119,888 13,069.99 40.70
active txn count during cleanout 116,700,513 32,370.07 100.80
application wait time 25,455 7.06 0.02
background checkpoints completed 3 0.00 0.00
background checkpoints started 2 0.00 0.00
background timeouts 13,895 3.85 0.01
branch node splits 1,054 0.29 0.00
buffer is not pinned count 596,542,033 165,467.20 515.25
buffer is pinned count 1,538,927,771 426,863.59 1,329.21
bytes received via SQL*Net from client 10,359,802,586 2,873,573.82 8,948.01
bytes sent via SQL*Net to client 9,466,371,494 2,625,756.34 8,176.33
calls to get snapshot scn: kcmgss 109,604,676 30,401.85 94.67
calls to kcmgas 19,926,877 5,527.26 17.21
calls to kcmgcs 16,490,865 4,574.19 14.24
change write time 63,284 17.55 0.05
cleanout - number of ktugct calls 30,800,092 8,543.25 26.60
cleanouts and rollbacks - consistent read gets 13,873,827 3,848.28 11.98
cleanouts only - consistent read gets 150,300 41.69 0.13
cluster key scan block gets 851,659 236.23 0.74
cluster key scans 235,117 65.22 0.20
commit batch/immediate performed 4,745 1.32 0.00
commit batch/immediate requested 4,745 1.32 0.00
commit cleanout failures: block lost 244,135 67.72 0.21
commit cleanout failures: buffer being written 948 0.26 0.00
commit cleanout failures: callback failure 109,028 30.24 0.09
commit cleanout failures: cannot pin 30,560 8.48 0.03
commit cleanouts 9,136,364 2,534.22 7.89
commit cleanouts successfully completed 8,751,693 2,427.52 7.56
commit immediate performed 4,745 1.32 0.00
commit immediate requested 4,745 1.32 0.00
commit txn count during cleanout 1,333,708 369.94 1.15
concurrency wait time 15,147 4.20 0.01
consistent changes 735,709,229 204,069.02 635.45
consistent gets 1,770,294,763 491,039.54 1,529.05
consistent gets - examination 1,228,477,897 340,751.85 1,061.07
consistent gets from cache 1,770,294,858 491,039.57 1,529.05
cursor authentications 2,089 0.58 0.00
data blocks consistent reads - undo records applied 731,700,909 202,957.20 631.99
db block changes 196,353,568 54,464.02 169.60
db block gets 226,179,456 62,737.04 195.36
db block gets direct 4,242 1.18 0.00
db block gets from cache 226,175,211 62,735.86 195.35
deferred (CURRENT) block cleanout applications 1,606,488 445.60 1.39
dirty buffers inspected 11,556 3.21 0.01
doubling up with imu segment 0 0.00 0.00
enqueue conversions 9,696 2.69 0.01
enqueue releases 4,358,195 1,208.86 3.76
enqueue requests 4,364,748 1,210.68 3.77
enqueue timeouts 6,330 1.76 0.01
enqueue waits 40,293 11.18 0.03
exchange deadlocks 54,669 15.16 0.05
execute count 97,921,653 27,161.24 84.58
failed probes on index block reclamation 12,393 3.44 0.01
frame signature mismatch 1 0.00 0.00
free buffer inspected 2,986,396 828.36 2.58
free buffer requested 20,403,013 5,659.33 17.62
heap block compress 28,672,411 7,953.08 24.77
hot buffers moved to head of LRU 1,270,189 352.32 1.10
immediate (CR) block cleanout applications 14,024,135 3,889.98 12.11
immediate (CURRENT) block cleanout applications 1,138,996 315.93 0.98
index crx upgrade (found) 110,833 30.74 0.10
index crx upgrade (positioned) 9,792,563 2,716.23 8.46
index fast full scans (rowid ranges) 808 0.22 0.00
index fetch by key 182,538,004 50,631.89 157.66
index scans kdiixs1 151,643,170 42,062.37 130.98
java call heap collected bytes 1,455,536,224 403,732.67 1,257.18
java call heap collected count 17,964,687 4,983.00 15.52
java call heap gc count 4,633 1.29 0.00
java call heap live object count 1,583,290 439.17 1.37
java call heap live object count max 1,585,289 439.72 1.37
java call heap live size 447,250,872 124,057.23 386.30
java call heap live size max 447,407,184 124,100.59 386.44
java call heap object count 3,809,297 1,056.61 3.29
java call heap object count max 3,814,970 1,058.19 3.30
java call heap total size 595,853,312 165,276.17 514.65
java call heap total size max 595,855,360 165,276.74 514.65
java call heap used size 591,066,096 163,948.30 510.52
java call heap used size max 591,541,088 164,080.06 510.93
leaf node 90-10 splits 19,688 5.46 0.02
leaf node splits 243,740 67.61 0.21
lob reads 21,405 5.94 0.02
lob writes 37,164 10.31 0.03
lob writes unaligned 37,164 10.31 0.03
logons cumulative 9,317 2.58 0.01
messages received 1,949,590 540.77 1.68
messages sent 1,949,591 540.77 1.68
no buffer to keep pinned count 14 0.00 0.00
no work - consistent read gets 493,577,108 136,907.07 426.31
opened cursors cumulative 5,522,904 1,531.93 4.77
parse count (failures) 3,236 0.90 0.00
parse count (hard) 8,749 2.43 0.01
parse count (total) 8,526,421 2,365.04 7.36
parse time cpu 57,879 16.05 0.05
parse time elapsed 64,462 17.88 0.06
physical read IO requests 297,036 82.39 0.26
physical read bytes 3,882,680,320 1,076,967.29 3,353.56
physical read total IO requests 326,297 90.51 0.28
physical read total bytes 4,361,183,232 1,209,693.12 3,766.86
physical read total multi block requests 15,756 4.37 0.01
physical reads 473,960 131.47 0.41
physical reads cache 473,042 131.21 0.41
physical reads cache prefetch 176,744 49.02 0.15
physical reads direct 918 0.25 0.00
physical reads direct temporary tablespace 186 0.05 0.00
physical reads prefetch warmup 107,842 29.91 0.09
physical write IO requests 1,753,778 486.46 1.51
physical write bytes 25,825,419,264 7,163,384.44 22,306.04
physical write total IO requests 3,088,458 856.67 2.67
physical write total bytes 58,948,412,928 16,350,950.19 50,915.17
physical write total multi block requests 1,507,238 418.07 1.30
physical writes 3,152,528 874.44 2.72
physical writes direct 4,761 1.32 0.00
physical writes direct (lob) 234 0.06 0.00
physical writes direct temporary tablespace 4,125 1.14 0.00
physical writes from cache 3,147,761 873.12 2.72
physical writes non checkpoint 2,336,142 647.99 2.02
pinned buffers inspected 2,880 0.80 0.00
prefetch warmup blocks aged out before use 243,924 67.66 0.21
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 calls 158,528,717 43,972.26 136.93
recursive cpu usage 1,349,671 374.37 1.17
redo blocks written 64,523,928 17,897.47 55.73
redo buffer allocation retries 191 0.05 0.00
redo entries 101,076,987 28,036.46 87.30
redo log space requests 0 0.00 0.00
redo log space wait time 0 0.00 0.00
redo ordering marks 1,211,816 336.13 1.05
redo size 31,613,267,916 8,768,802.13 27,305.14
redo subscn max counts 2,373,508 658.36 2.05
redo synch time 70,646 19.60 0.06
redo synch writes 2,188,866 607.14 1.89
redo wastage 342,588,632 95,026.30 295.90
redo write time 49,503 13.73 0.04
redo writer latching time 140 0.04 0.00
redo writes 843,698 234.02 0.73
rollback changes - undo records applied 225,118 62.44 0.19
rollbacks only - consistent read gets 2,282,920 633.23 1.97
rows fetched via callback 96,530,393 26,775.34 83.38
session connect time 0 0.00 0.00
session cursor cache hits 5,355,775 1,485.57 4.63
session logical reads 1,996,474,580 553,776.68 1,724.40
session pga memory 10,664,327,400 2,958,042.08 9,211.04
session pga memory max 11,933,853,992 3,310,179.91 10,307.56
session uga memory ############### 75,193,103.87 234,143.56
session uga memory max 68,942,103,784 19,122,972.94 59,546.96
shared hash latch upgrades - no wait 31,666,071 8,783.45 27.35
shared hash latch upgrades - wait 188,948 52.41 0.16
sorts (memory) 10,208,858 2,831.71 8.82
sorts (rows) 127,081,832 35,249.61 109.76
sql area evicted 2,630 0.73 0.00
sql area purged 3,389 0.94 0.00
summed dirty queue length 305,253 84.67 0.26
switch current to new buffer 1,360,970 377.50 1.18
table fetch by rowid 907,230,632 251,645.16 783.60
table fetch continued row 33,414,642 9,268.46 28.86
table scan blocks gotten 67,515,277 18,727.20 58.31
table scan rows gotten 2,058,749,588 571,050.35 1,778.19
table scans (long tables) 2,052 0.57 0.00
table scans (rowid ranges) 2,050 0.57 0.00
table scans (short tables) 5,602,977 1,554.14 4.84
total number of times SMON posted 158,824 44.05 0.14
transaction rollbacks 4,745 1.32 0.00
transaction tables consistent read rollbacks 85 0.02 0.00
transaction tables consistent reads - undo records applied 4,267 1.18 0.00
undo change vector size 11,051,961,440 3,065,562.96 9,545.85
user I/O wait time 134,158 37.21 0.12
user calls 44,988,866 12,478.89 38.86
user commits 918,820 254.86 0.79
user rollbacks 238,957 66.28 0.21
workarea executions - onepass 2 0.00 0.00
workarea executions - optimal 5,951,473 1,650.80 5.14
write clones created in background 1,983 0.55 0.00
write clones created in foreground 11,920 3.31 0.01

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

  • Statistics with absolute values (should not be diffed)
StatisticBegin ValueEnd Value
session cursor cache count 438,186 1,096,254
opened cursors current 991,516 1,142,195
workarea memory allocated 172 1,725
logons current 4,775 4,807

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

  • Statistics identified by '(derived)' come from sources other than SYSSTAT
StatisticTotalper Hour
log switches (derived) 0 0.00

Back to Instance Activity Statistics
Back to Top

IO Stats

Back to Top

Tablespace IO Stats

  • ordered by IOs (Reads + Writes) desc
TablespaceReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
APPS_UNDOTS1 32 0 10.63 1.00 812,813 225 343,140 0.02
APPS_TS_TX_DATA 179,230 50 4.38 1.36 202,863 56 175,796 0.20
APPS_TS_TX_IDX 92,429 26 4.40 1.46 214,690 60 111,826 0.19
APPS_ASSM_DATA 8,722 2 2.13 6.57 271,722 75 44,851 0.29
APPS_ASSM_IDX 6,665 2 2.41 1.04 176,522 49 309,190 0.07
APPS_TS_TX_INTERFACE 1,062 0 5.13 2.24 37,443 10 26,706 0.03
TEMP 469 0 4.61 9.68 10,899 3 87 4.14
APPS_TS_SUMMARY 62 0 11.94 1.00 8,333 2 2,611 0.01
SYSTEM 5,280 1 3.77 3.52 2,689 1 32,954 0.06
APPS_TS_SEED 2,146 1 6.40 1.63 5,188 1 891 2.46
APPS_TS_QUEUES 355 0 7.04 2.64 5,094 1 745 0.13
APPS_TS_ARCHIVE 61 0 5.90 1.59 2,346 1 181 3.59
SYSAUX 293 0 2.42 1.10 1,534 0 1 0.00
APPS_TS_NOLOGGING 25 0 10.00 1.56 50 0 1 0.00
CTXSYS 24 0 7.50 1.00 6 0 0 0.00
APPS_TS_MEDIA 12 0 19.17 1.00 9 0 0 0.00
ODM 12 0 5.83 1.00 3 0 0 0.00
OLAP 12 0 9.17 1.00 3 0 0 0.00
OWAPUB 12 0 5.83 1.00 3 0 0 0.00
PORTAL 12 0 9.17 1.00 3 0 0 0.00
SYNCSERVER 12 0 8.33 1.00 3 0 0 0.00

Back to IO Stats
Back to Top

File IO Stats

  • ordered by Tablespace, File
TablespaceFilenameReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
APPS_ASSM_DATA /DB/visdata/apps_assm_data.dbf 8,722 2 2.13 6.57 271,722 75 44,851 0.29
APPS_ASSM_IDX /DB/visdata/apps_assm_idx.dbf 6,665 2 2.41 1.04 176,522 49 309,190 0.07
APPS_TS_ARCHIVE /DB/visdata/archive1.dbf 29 0 7.59 1.48 2,068 1 174 1.84
APPS_TS_ARCHIVE /DB/visdata/archive2.dbf 32 0 4.38 1.69 278 0 7 47.14
APPS_TS_MEDIA /DB/visdata/media1.dbf 4 0 10.00 1.00 3 0 0 0.00
APPS_TS_MEDIA /DB/visdata/media2.dbf 4 0 32.50 1.00 3 0 0 0.00
APPS_TS_MEDIA /DB/visdata/media3.dbf 4 0 15.00 1.00 3 0 0 0.00
APPS_TS_NOLOGGING /DB/visdata/nologging1.dbf 4 0 7.50 1.00 3 0 0 0.00
APPS_TS_NOLOGGING /DB/visdata/nologging2.dbf 15 0 9.33 1.00 34 0 0 0.00
APPS_TS_NOLOGGING /DB/visdata/nologging3.dbf 6 0 13.33 3.33 13 0 1 0.00
APPS_TS_QUEUES /DB/visdata/queues1.dbf 37 0 8.65 2.57 605 0 273 0.18
APPS_TS_QUEUES /DB/visdata/queues2.dbf 42 0 6.43 3.17 777 0 214 0.09
APPS_TS_QUEUES /DB/visdata/queues3.dbf 36 0 6.39 2.58 791 0 14 0.00
APPS_TS_QUEUES /DB/visdata/queues4.dbf 43 0 6.05 3.47 693 0 15 0.00
APPS_TS_QUEUES /DB/visdata/queues5.dbf 36 0 7.22 3.11 817 0 11 0.00
APPS_TS_QUEUES /DB/visdata/queues6.dbf 39 0 6.92 3.41 640 0 8 0.00
APPS_TS_QUEUES /DB/visdata/queues7.dbf 122 0 7.30 1.83 771 0 210 0.14
APPS_TS_SEED /DB/visdata/reference1.dbf 184 0 7.07 1.76 484 0 41 2.68
APPS_TS_SEED /DB/visdata/reference10.dbf 185 0 6.05 1.65 528 0 53 1.70
APPS_TS_SEED /DB/visdata/reference2.dbf 212 0 5.71 1.47 529 0 33 2.73
APPS_TS_SEED /DB/visdata/reference3.dbf 322 0 5.47 1.57 560 0 448 2.57
APPS_TS_SEED /DB/visdata/reference4.dbf 196 0 6.73 1.63 514 0 32 0.31
APPS_TS_SEED /DB/visdata/reference5.dbf 240 0 6.25 1.37 502 0 70 3.43
APPS_TS_SEED /DB/visdata/reference6.dbf 232 0 6.34 2.20 554 0 38 6.05
APPS_TS_SEED /DB/visdata/reference7.dbf 215 0 7.86 1.51 486 0 29 0.69
APPS_TS_SEED /DB/visdata/reference8.dbf 188 0 5.74 1.73 490 0 42 4.05
APPS_TS_SEED /DB/visdata/reference9.dbf 172 0 7.44 1.40 541 0 105 0.76
APPS_TS_SUMMARY /DB/visdata/summary1.dbf 5 0 10.00 1.00 993 0 390 0.00
APPS_TS_SUMMARY /DB/visdata/summary2.dbf 5 0 20.00 1.00 941 0 310 0.00
APPS_TS_SUMMARY /DB/visdata/summary3.dbf 12 0 9.17 1.00 1,000 0 197 0.00
APPS_TS_SUMMARY /DB/visdata/summary4.dbf 12 0 10.00 1.00 919 0 223 0.00
APPS_TS_SUMMARY /DB/visdata/summary5.dbf 7 0 17.14 1.00 999 0 456 0.00
APPS_TS_SUMMARY /DB/visdata/summary6.dbf 7 0 12.86 1.00 1,078 0 655 0.02
APPS_TS_SUMMARY /DB/visdata/summary7.dbf 7 0 10.00 1.00 1,146 0 196 0.00
APPS_TS_SUMMARY /DB/visdata/summary8.dbf 7 0 11.43 1.00 1,257 0 184 0.05
APPS_TS_TX_DATA /DB/visdata/tx_data1.dbf 3,288 1 5.23 1.31 388 0 0 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data10.dbf 3,266 1 4.80 1.28 257 0 0 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data11.dbf 3,327 1 5.06 1.34 197 0 0 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data12.dbf 13,297 4 3.13 1.27 4,085 1 4,067 1.54
APPS_TS_TX_DATA /DB/visdata/tx_data13.dbf 18,128 5 4.73 1.51 5,281 1 3,696 0.54
APPS_TS_TX_DATA /DB/visdata/tx_data14.dbf 13,258 4 4.17 1.39 29,975 8 23,035 0.13
APPS_TS_TX_DATA /DB/visdata/tx_data15.dbf 9,553 3 4.25 1.48 29,037 8 23,025 0.14
APPS_TS_TX_DATA /DB/visdata/tx_data16.dbf 9,593 3 4.11 1.46 26,938 7 23,967 0.16
APPS_TS_TX_DATA /DB/visdata/tx_data17.dbf 9,334 3 3.92 1.46 25,778 7 24,189 0.20
APPS_TS_TX_DATA /DB/visdata/tx_data18.dbf 9,425 3 3.99 1.43 25,233 7 23,610 0.18
APPS_TS_TX_DATA /DB/visdata/tx_data19.dbf 9,391 3 4.17 1.45 25,243 7 21,998 0.13
APPS_TS_TX_DATA /DB/visdata/tx_data2.dbf 6,861 2 3.63 1.18 1,190 0 3,256 0.66
APPS_TS_TX_DATA /DB/visdata/tx_data20.dbf 9,365 3 4.05 1.52 25,286 7 23,271 0.08
APPS_TS_TX_DATA /DB/visdata/tx_data21.dbf 23,145 6 4.92 1.32 1,095 0 1,654 0.08
APPS_TS_TX_DATA /DB/visdata/tx_data3.dbf 3,885 1 5.08 1.50 488 0 5 2.00
APPS_TS_TX_DATA /DB/visdata/tx_data4.dbf 17,371 5 4.72 1.10 324 0 3 10.00
APPS_TS_TX_DATA /DB/visdata/tx_data5.dbf 3,349 1 4.81 1.27 427 0 0 0.00
APPS_TS_TX_DATA /DB/visdata/tx_data6.dbf 3,413 1 4.71 1.29 232 0 4 5.00
APPS_TS_TX_DATA /DB/visdata/tx_data7.dbf 3,269 1 4.98 1.31 508 0 7 7.14
APPS_TS_TX_DATA /DB/visdata/tx_data8.dbf 3,285 1 4.48 1.25 552 0 8 1.25
APPS_TS_TX_DATA /DB/visdata/tx_data9.dbf 3,427 1 5.09 1.34 349 0 1 10.00
APPS_TS_TX_IDX /DB/visdata/tx_idx1.dbf 2,422 1 3.42 1.15 2,507 1 1,830 0.49
APPS_TS_TX_IDX /DB/visdata/tx_idx10.dbf 2,427 1 3.37 1.24 1,733 0 2,185 0.46
APPS_TS_TX_IDX /DB/visdata/tx_idx11.dbf 2,411 1 3.67 1.20 1,901 1 1,916 0.45
APPS_TS_TX_IDX /DB/visdata/tx_idx12.dbf 10,971 3 5.32 1.78 22,307 6 2,270 0.15
APPS_TS_TX_IDX /DB/visdata/tx_idx13.dbf 9,441 3 4.59 1.40 30,521 8 5,732 0.20
APPS_TS_TX_IDX /DB/visdata/tx_idx14.dbf 5,631 2 4.81 1.53 21,453 6 5,112 0.13
APPS_TS_TX_IDX /DB/visdata/tx_idx15.dbf 5,590 2 4.74 1.54 18,157 5 8,929 0.07
APPS_TS_TX_IDX /DB/visdata/tx_idx16.dbf 5,568 2 4.72 1.60 16,947 5 6,810 0.11
APPS_TS_TX_IDX /DB/visdata/tx_idx17.dbf 5,435 2 4.46 1.50 15,657 4 7,141 0.11
APPS_TS_TX_IDX /DB/visdata/tx_idx18.dbf 5,677 2 4.88 1.54 15,401 4 11,207 0.07
APPS_TS_TX_IDX /DB/visdata/tx_idx19.dbf 5,584 2 4.85 1.60 14,787 4 11,267 0.13
APPS_TS_TX_IDX /DB/visdata/tx_idx2.dbf 2,996 1 4.04 1.39 2,178 1 2,865 0.25
APPS_TS_TX_IDX /DB/visdata/tx_idx20.dbf 5,503 2 4.92 1.52 14,034 4 5,298 0.13
APPS_TS_TX_IDX /DB/visdata/tx_idx21.dbf 3,419 1 5.24 1.65 16,334 5 3,631 0.36
APPS_TS_TX_IDX /DB/visdata/tx_idx3.dbf 3,965 1 2.87 1.18 1,947 1 3,246 0.69
APPS_TS_TX_IDX /DB/visdata/tx_idx4.dbf 2,634 1 3.40 1.17 3,721 1 4,202 0.38
APPS_TS_TX_IDX /DB/visdata/tx_idx5.dbf 2,652 1 3.57 1.28 5,035 1 15,861 0.09
APPS_TS_TX_IDX /DB/visdata/tx_idx6.dbf 2,600 1 3.33 1.29 3,009 1 4,483 0.30
APPS_TS_TX_IDX /DB/visdata/tx_idx7.dbf 2,534 1 3.30 1.24 2,886 1 2,667 0.32
APPS_TS_TX_IDX /DB/visdata/tx_idx8.dbf 2,502 1 3.43 1.22 2,132 1 2,834 0.43
APPS_TS_TX_IDX /DB/visdata/tx_idx9.dbf 2,467 1 3.52 1.24 2,043 1 2,340 0.43
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte.dbf 146 0 5.00 2.05 5,858 2 7,963 0.02
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte2.dbf 223 0 4.98 2.46 7,119 2 6,274 0.03
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte3.dbf 251 0 4.90 1.98 6,483 2 4,464 0.03
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte4.dbf 64 0 6.25 4.31 6,182 2 3,082 0.03
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte5.dbf 159 0 6.42 2.22 5,851 2 3,172 0.04
APPS_TS_TX_INTERFACE /DB/visdata/ts_tx_inte6.dbf 219 0 4.38 1.86 5,950 2 1,751 0.03
APPS_UNDOTS1 /DB/visdata/undo01.dbf 4 0 10.00 1.00 78,065 22 45,417 0.03
APPS_UNDOTS1 /DB/visdata/undo02.dbf 3 0 13.33 1.00 77,275 21 34,425 0.02
APPS_UNDOTS1 /DB/visdata/undo03.dbf 3 0 10.00 1.00 78,512 22 29,792 0.03
APPS_UNDOTS1 /DB/visdata/undo04.dbf 4 0 7.50 1.00 76,823 21 31,019 0.03
APPS_UNDOTS1 /DB/visdata/undo05.dbf 3 0 10.00 1.00 85,232 24 31,529 0.02
APPS_UNDOTS1 /DB/visdata/undo06.dbf 3 0 13.33 1.00 88,770 25 33,805 0.02
APPS_UNDOTS1 /DB/visdata/undo07.dbf 3 0 20.00 1.00 82,150 23 29,670 0.02
APPS_UNDOTS1 /DB/visdata/undo08.dbf 3 0 6.67 1.00 85,286 24 41,236 0.02
APPS_UNDOTS1 /DB/visdata/undo09.dbf 3 0 10.00 1.00 81,051 22 34,787 0.02
APPS_UNDOTS1 /DB/visdata/undo10.dbf 3 0 6.67 1.00 79,649 22 31,460 0.02
CTXSYS /DB/visdata/ctx1.dbf 12 0 6.67 1.00 3 0 0 0.00
CTXSYS /DB/visdata/ctx2.dbf 12 0 8.33 1.00 3 0 0 0.00
ODM /DB/visdata/odm.dbf 12 0 5.83 1.00 3 0 0 0.00
OLAP /DB/visdata/olap.dbf 12 0 9.17 1.00 3 0 0 0.00
OWAPUB /DB/visdata/owa1.dbf 12 0 5.83 1.00 3 0 0 0.00
PORTAL /DB/visdata/portal.dbf 12 0 9.17 1.00 3 0 0 0.00
SYNCSERVER /DB/visdata/mobile01.dbf 12 0 8.33 1.00 3 0 0 0.00
SYSAUX /DB/visdata/sysaux01.dbf 19 0 8.42 1.42 744 0 1 0.00
SYSAUX /DB/visdata/sysaux02.dbf 274 0 2.01 1.07 790 0 0 0.00
SYSTEM /DB/visdata/sys1.dbf 567 0 3.62 3.87 105 0 108 0.09
SYSTEM /DB/visdata/sys2.dbf 571 0 3.71 4.07 179 0 132 0.08
SYSTEM /DB/visdata/sys3.dbf 708 0 3.15 3.41 253 0 23 0.43
SYSTEM /DB/visdata/sys4.dbf 661 0 3.09 3.53 265 0 8 0.00
SYSTEM /DB/visdata/sys5.dbf 889 0 4.02 2.88 683 0 992 0.10
SYSTEM /DB/visdata/sys6.dbf 563 0 4.71 4.17 82 0 7 1.43
SYSTEM /DB/visdata/sys7.dbf 456 0 4.30 4.25 165 0 122 0.25
SYSTEM /DB/visdata/sys8.dbf 376 0 3.80 3.28 519 0 31,470 0.05
SYSTEM /DB/visdata/sys9.dbf 489 0 3.74 2.58 438 0 92 0.76
TEMP /DB/visdata/temp1.dbf 210 0 4.67 20.39 4,058 1 65 4.00
TEMP /DB/visdata/temp2.dbf 102 0 5.00 1.00 2,430 1 6 1.67
TEMP /DB/visdata/temp3.dbf 92 0 4.02 1.00 2,159 1 13 0.77
TEMP /DB/visdata/temp4.dbf 65 0 4.62 1.00 2,252 1 3 26.67

Back to IO Stats
Back to Top

Buffer Pool Statistics

  • Standard block size Pools D: default, K: keep, R: recycle
  • Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k
PNumber of BuffersPool Hit%Buffer GetsPhysical ReadsPhysical WritesFree Buff WaitWrit Comp WaitBuffer Busy Waits
D 2,184,816 100 1,988,947,289 473,015 3,148,046 0 0 1,049,207


Back to Top

Advisory Statistics

Back to Top

Instance Recovery Stats

  • B: Begin snapshot, E: End snapshot
Targt MTTR (s) Estd MTTR (s)Recovery Estd IOsActual Redo BlksTarget Redo BlksLog File Size Redo BlksLog Ckpt Timeout Redo BlksLog Ckpt Interval Redo Blks
B 180 95 43825 1060706 4046248 188743680 4046248  
E 180 97 47646 1055654 9765482 188743680 9765482  

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 ProcessedExtra W/A MB Read/Written
100.00 577,830 5

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

PGA Aggr Target(M)Auto PGA Target(M)PGA Mem Alloc(M) W/A PGA Used(M) %PGA W/A Mem%Auto W/A Mem%Man W/A MemGlobal Mem Bound(K)
B 20,480 1,280 42,088.60 0.17 0.00 100.00 0.00 1,048,576
E 20,480 1,280 50,774.24 1.84 0.00 100.00 0.00 1,048,576

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K 4K 5,360,230 5,360,230 0 0
64K 128K 11,701 11,701 0 0
128K 256K 1,140 1,140 0 0
256K 512K 1,077 1,077 0 0
512K 1024K 171,709 171,709 0 0
1M 2M 395,104 395,104 0 0
2M 4M 68 66 2 0
4M 8M 13 13 0 0
8M 16M 22 22 0 0
32M 64M 8 8 0 0
64M 128M 6 6 0 0
128M 256M 2 2 0 0

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

PGA Target Est (MB)Size FactrW/A MB ProcessedEstd Extra W/A MB Read/ Written to Disk Estd PGA Cache Hit %Estd PGA Overalloc Count
2,560 0.13 804,037.03 8,930.00 99.00 1,127
5,120 0.25 804,037.03 8,872.39 99.00 1,095
10,240 0.50 804,037.03 8,757.71 99.00 1,040
15,360 0.75 804,037.03 8,607.57 99.00 989
20,480 1.00 804,037.03 2.73 100.00 942
24,576 1.20 804,037.03 2.73 100.00 899
28,672 1.40 804,037.03 2.73 100.00 828
32,768 1.60 804,037.03 2.73 100.00 604
36,864 1.80 804,037.03 0.00 100.00 177
40,960 2.00 804,037.03 0.00 100.00 0
61,440 3.00 804,037.03 0.00 100.00 0
81,920 4.00 804,037.03 0.00 100.00 0
122,880 6.00 804,037.03 0.00 100.00 0
163,840 8.00 804,037.03 0.00 100.00 0

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

Shared Pool Size(M)SP Size FactrEst LC Size (M)Est LC Mem ObjEst LC Time Saved (s)Est LC Time Saved FactrEst LC Load Time (s)Est LC Load Time FactrEst LC Mem Obj Hits
1,888 0.70 313 13,727 2,385,934 1.00 3,068 2.21 178,753,303
2,160 0.80 555 16,959 2,387,203 1.00 1,799 1.30 178,833,755
2,432 0.90 822 20,904 2,387,556 1.00 1,446 1.04 178,858,471
2,704 1.00 1,076 26,232 2,387,616 1.00 1,386 1.00 178,863,053
2,976 1.10 1,268 32,763 2,387,620 1.00 1,382 1.00 178,863,499
3,248 1.20 1,313 33,523 2,387,620 1.00 1,382 1.00 178,863,532
3,520 1.30 1,359 34,733 2,387,620 1.00 1,382 1.00 178,863,559
3,792 1.40 1,359 34,733 2,387,620 1.00 1,382 1.00 178,863,559
4,064 1.50 1,359 34,733 2,387,620 1.00 1,382 1.00 178,863,559
4,336 1.60 1,359 34,733 2,387,620 1.00 1,382 1.00 178,863,559
4,608 1.70 1,359 34,733 2,387,620 1.00 1,382 1.00 178,863,559
4,880 1.80 1,359 34,733 2,387,620 1.00 1,382 1.00 178,863,559
5,152 1.91 1,359 34,733 2,387,620 1.00 1,382 1.00 178,863,559
5,424 2.01 1,359 34,733 2,387,620 1.00 1,382 1.00 178,863,559

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
5,120 0.25 33,323  
10,240 0.50 33,323  
15,360 0.75 33,323  
20,480 1.00 33,322  
25,600 1.25 33,327  
30,720 1.50 33,327  
35,840 1.75 33,327  
40,960 2.00 33,328  

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 FactrEst LC Size (M)Est LC Mem ObjEst LC Time Saved (s)Est LC Time Saved FactrEst LC Load Time (s)Est LC Load Time FactrEst LC Mem Obj Hits
32 0.33 11 337 53 1.00 1,386 1.00 7,428
48 0.50 12 341 53 1.00 1,386 1.00 7,428
64 0.67 12 341 53 1.00 1,386 1.00 7,428
80 0.83 12 341 53 1.00 1,386 1.00 7,428
96 1.00 12 341 53 1.00 1,386 1.00 7,428
112 1.17 12 341 53 1.00 1,386 1.00 7,428
128 1.33 12 341 53 1.00 1,386 1.00 7,428
144 1.50 12 341 53 1.00 1,386 1.00 7,428
160 1.67 12 341 53 1.00 1,386 1.00 7,428
176 1.83 12 341 53 1.00 1,386 1.00 7,428
192 2.00 12 341 53 1.00 1,386 1.00 7,428
208 2.17 12 341 53 1.00 1,386 1.00 7,428

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
data block 694,365 96 0
undo block 278,450 5 0
undo header 64,736 3 0
2nd level bmb 1,171 0 0
1st level bmb 7,431 0 0
file header block 95 0 4
segment header 2,814 0 0
extent map 8 0 0
bitmap index block 1 0 0

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
TX-Transaction (row lock contention) 5,342 393 4,949 364 184 504.84
UL-User-defined 68,208 67,161 1,047 1,475 60 41.01
TX-Transaction (index contention) 31,616 31,616 0 29,153 16 0.53
RO-Multiple Object Reuse (fast object reuse) 261 261 0 29 6 221.72
HW-Segment High Water Mark 256,416 256,402 14 2,905 2 0.76
TX-Transaction 1,263,339 1,263,807 0 2,093 1 0.53
DV-Diana Versioning 29,064 29,064 0 181 1 5.58
SQ-Sequence Cache 41,633 41,633 0 3,369 1 0.16
TX-Transaction (allocate ITL entry) 202 202 0 129 0 1.47
FB-Format Block 36,610 36,610 0 565 0 0.19
CU-Cursor 8,601 8,602 0 2 0 10.00
TM-DML 2,003,899 2,003,826 0 2 0 10.00
PS-PX Process Reservation 1,864 1,540 320 26 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 TransactionsMax Qry Len (s)Max Tx ConcurcyMin/Max TR (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
1 1,591.92 1,266,754 2,198 346   0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

End TimeNum Undo BlocksNumber of TransactionsMax Qry Len (s)Max Tx ConcyTun Ret (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
26-Aug 08:08 224,221 176,854 496 344 196 0/0 0/0/0/0/0/0
26-Aug 07:58 53,552 122,875 794 337 203 0/0 0/0/0/0/0/0
26-Aug 07:48 345,681 174,558 652 342 187 0/0 0/0/0/0/0/0
26-Aug 07:38 387,917 231,487 2,198 341 215 0/0 0/0/0/0/0/0
26-Aug 07:28 237,004 226,237 2,116 345 286 0/0 0/0/0/0/0/0
26-Aug 07:18 343,540 334,743 1,858 346 358 0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

Back to Top

Latch Activity

Latch NameGet RequestsPct Get MissAvg Slps /MissWait Time (s)NoWait RequestsPct NoWait Miss
ASM db client latch 2,461 0.00   0 0  
AWR Alerted Metric Element list 306,574 0.00   0 0  
Consistent RBA 843,993 0.01 0.02 0 0  
FOB s.o list latch 53,134 0.02 0.00 0 0  
In memory undo latch 708,349,057 2.57 0.00 1 1,182,707 0.00
JOX SGA heap latch 1,920,221 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,376 0.00   0 0  
KMG resize request state object freelist 22 0.00   0 0  
KTF sga latch 12 0.00   0 1,214 0.00
KWQMN job cache list latch 13,567 0.40 0.80 0 0  
MQL Tracking Latch 0     0 71 0.00
Memory Management Latch 1,374 0.00   0 2,363 0.08
OS process 14,097 0.00   0 0  
OS process allocation 10,634 0.05 0.00 0 0  
OS process: request allocation 9,152 0.00   0 0  
PL/SQL warning settings 4,254,075 0.00   0 0  
SGA IO buffer pool latch 51,137 1.33 0.00 0 52,627 0.55
SQL memory manager latch 1 0.00   0 1,199 0.00
SQL memory manager workarea list latch 6,613,393 0.02 0.01 0 0  
Shared B-Tree 128 0.00   0 0  
active checkpoint queue latch 1,107,938 0.95 0.00 0 2 0.00
active service list 45,294 0.31 0.00 0 1,249 0.00
begin backup scn array 155 0.00   0 0  
buffer pool 22 0.00   0 0  
cache buffer handles 23,367,851 1.82 0.00 0 0  
cache buffers chains 4,692,118,256 1.49 0.03 37 18,645,524 2.46
cache buffers lru chain 10,086,051 0.41 0.03 0 36,035,153 0.67
cache table scan latch 2,129 0.00   0 2,129 0.00
channel handle pool latch 374,606 0.22 0.03 0 0  
channel operations parent latch 1,691,745 0.44 0.00 0 0  
checkpoint queue latch 22,559,535 0.02 0.01 0 3,179,633 0.03
client/application info 1,632,816 0.00 0.06 0 0  
commit callback allocation 79,992 0.00 0.00 0 0  
compile environment latch 2,844,247 0.00   0 0  
dictionary lookup 72 0.00   0 0  
dml lock allocation 3,991,536 0.69 0.00 0 0  
dummy allocation 18,619 1.43 0.00 0 0  
enqueue hash chains 8,781,725 0.27 0.00 0 388 0.26
enqueues 4,941,410 0.19 0.01 0 0  
error message lists 816 8.58 0.00 0 0  
event group latch 4,593 0.00   0 0  
file cache latch 21,458 0.00   0 0  
global KZLD latch for mem in SGA 8,808 0.00   0 0  
global ctx hash table latch 22,068 0.00   0 0  
hash table column usage latch 2,202 0.09 0.00 0 14,122,333 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 120 0.00   0 0  
kks stats 28,471 0.01 0.50 0 0  
ksuosstats global area 242 0.00   0 0  
ktm global data 158,826 0.00   0 0  
kwqbsn:qsga 128 0.00   0 0  
lgwr LWN SCN 849,233 0.44 0.00 0 0  
library cache 327,188,648 0.54 0.00 2 17,913 10.72
library cache load lock 9,828 0.80 0.00 0 48 0.00
library cache lock 54,279,684 0.11 0.00 0 0  
library cache lock allocation 1,416,221 0.01 0.00 0 0  
library cache pin 203,986,714 0.35 0.00 1 31 3.23
library cache pin allocation 495,181 0.00 0.10 0 0  
list of block allocation 439,956 0.02 0.01 0 0  
loader state object freelist 291,078 0.01 0.00 0 0  
longop free list parent 33 0.00   0 33 0.00
message pool operations parent latch 380,381 0.08 0.02 0 0  
messages 5,804,612 0.54 0.01 0 0  
mostly latch-free SCN 973,957 11.88 0.00 0 0  
multiblock read objects 34,462 0.01 0.00 0 0  
ncodef allocation latch 95 0.00   0 0  
object queue header heap 4,811,282 0.03 0.14 0 387,027 0.06
object queue header operation 41,555,458 0.17 0.38 1 21,560 0.03
object stats modification 372,599 0.04 0.00 0 0  
parallel query alloc buffer 8,160 3.14 0.00 0 0  
parallel query stats 528 37.12 0.04 0 0  
parameter table allocation management 21,979 1.19 0.90 0 0  
post/wait queue 1,209,889 0.06 0.00 0 488,649 0.04
process allocation 9,200 0.34 0.94 0 4,591 0.04
process group creation 9,152 0.03 0.00 0 0  
process queue 5,030 3.72 0.00 0 0  
process queue reference 756,129 0.06 0.00 0 82,867 1.88
qmn task queue latch 512 0.00   0 0  
query server freelists 4,256 16.05 0.00 0 0  
query server process 8 0.00   0 8 0.00
redo allocation 5,686,369 4.76 0.00 0 100,721,162 3.20
redo copy 0     0 101,079,389 0.05
redo writing 4,165,666 0.43 0.00 0 0  
resmgr group change latch 774,313 0.00   0 0  
resmgr:actses active list 27,397 0.65 1.04 0 0  
resmgr:actses change group 26,813 0.00   0 0  
resmgr:free threads list 18,617 1.36 0.01 0 0  
resmgr:schema config 1 0.00   0 0  
row cache objects 117,152,261 0.48 0.00 0 5,807 0.12
rules engine aggregate statistics 37,897 0.12 0.00 0 0  
rules engine rule set statistics 122,181 0.06 0.00 0 0  
rules engine rule statistics 46,402 0.00   0 0  
sequence cache 16,347,884 1.09 0.00 0 0  
session allocation 18,360,296 0.90 0.01 0 0  
session idle bit 92,814,910 0.02 0.01 0 0  
session state list latch 53,799 0.35 0.18 0 0  
session switching 13,645 0.01 0.00 0 0  
session timer 1,249 0.00   0 0  
shared pool 6,997,710 0.27 0.03 0 0  
shared pool sim alloc 365 0.27 0.00 0 0  
shared pool simulator 2,129,906 0.00 0.00 0 0  
sim partition latch 1 0.00   0 21,800 0.15
simulator hash latch 2,460 0.00   0 0  
simulator lru latch 2,266 0.00   0 0  
slave class 1 0.00   0 0  
slave class create 4 0.00   0 0  
sort extent pool 1,304,597 0.20 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 260 0.00   0 0  
temporary table state object allocation 11,497 0.08 0.00 0 0  
threshold alerts latch 606 0.00   0 0  
trace latch 45 0.00   0 0  
transaction allocation 106,260 0.01 0.00 0 0  
transaction branch allocation 95 0.00   0 0  
undo global data 929,737,656 2.16 0.00 0 13,383 0.08
user lock 35,296 0.04 0.00 0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
cache buffers chains 4,692,118,256 69,716,767 2,239,031 67,626,166 0 0 0
undo global data 929,737,656 20,086,083 3,155 20,083,240 0 0 0
In memory undo latch 708,349,057 18,184,772 13,868 18,172,596 0 0 0
library cache 327,188,648 1,754,190 6,200 1,748,487 0 0 0
library cache pin 203,986,714 709,291 1,953 707,477 0 0 0
row cache objects 117,152,261 561,760 1,263 560,536 0 0 0
cache buffer handles 23,367,851 425,086 148 424,956 0 0 0
redo allocation 5,686,369 270,689 777 269,987 0 0 0
sequence cache 16,347,884 178,343 64 178,284 0 0 0
session allocation 18,360,296 165,741 1,323 164,503 0 0 0
mostly latch-free SCN 973,957 115,704 149 115,574 0 0 0
object queue header operation 41,555,458 70,467 26,787 45,347 0 0 0
library cache lock 54,279,684 61,756 198 61,566 0 0 0
cache buffers lru chain 10,086,051 41,094 1,232 39,913 0 0 0
messages 5,804,612 31,278 168 31,110 0 0 0
dml lock allocation 3,991,536 27,679 47 27,635 0 0 0
enqueue hash chains 8,781,725 23,602 18 23,586 0 0 0
shared pool 6,997,710 19,200 606 18,654 0 0 0
session idle bit 92,814,910 18,952 261 18,695 0 0 0
redo writing 4,165,666 18,046 30 18,016 0 0 0
active checkpoint queue latch 1,107,938 10,501 6 10,495 0 0 0
enqueues 4,941,410 9,307 66 9,242 0 0 0
channel operations parent latch 1,691,745 7,360 24 7,338 0 0 0
lgwr LWN SCN 849,233 3,748 1 3,747 0 0 0
checkpoint queue latch 22,559,535 3,708 27 3,682 0 0 0
sort extent pool 1,304,597 2,659 14 2,645 0 0 0
object queue header heap 4,811,282 1,378 192 1,201 0 0 0
SQL memory manager workarea list latch 6,613,393 1,020 8 1,014 0 0 0
channel handle pool latch 374,606 817 22 798 0 0 0
post/wait queue 1,209,889 671 1 670 0 0 0
process queue reference 756,129 458 1 457 0 0 0
message pool operations parent latch 380,381 319 5 316 0 0 0
parameter table allocation management 21,979 262 237 61 0 0 0
resmgr:free threads list 18,617 253 2 251 0 0 0
parallel query stats 528 196 7 189 0 0 0
session state list latch 53,799 186 34 152 0 0 0
resmgr:actses active list 27,397 178 185 3 0 0 0
Consistent RBA 843,993 118 2 116 0 0 0
list of block allocation 439,956 103 1 102 0 0 0
KWQMN job cache list latch 13,567 54 43 11 0 0 0
process allocation 9,200 31 29 2 0 0 0
client/application info 1,632,816 16 1 15 0 0 0
library cache pin allocation 495,181 10 1 9 0 0 0
kks stats 28,471 2 1 1 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
In memory undo latch ktiFlush: child 0 6,363 3,734
In memory undo latch kturbk 0 3,088 5,521
In memory undo latch kticmt: child 0 3,018 543
In memory undo latch ktichg: child 0 1,216 4,015
In memory undo latch ktiTxnPoolFree 0 169 1
In memory undo latch ktiBRacquire 0 5 0
In memory undo latch ktbgfc 0 2 48
KWQMN job cache list latch kwqmnuji: update job item 0 48 9
SQL memory manager workarea list latch qesmmIRegisterWorkArea 0 8 5
active checkpoint queue latch kcbbacq: scan active checkpoints 0 6 6
cache buffer handles kcbzgs 0 103 76
cache buffer handles kcbzfs 0 45 72
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 2,563,937 2,741,839
cache buffers chains kcbchg: kslbegin: call CR func 0 1,177,458 1,960,703
cache buffers chains kcbgtcr: fast path 0 670,753 43,592
cache buffers chains kcbgtcr: kslbegin excl 0 330,739 217,974
cache buffers chains kcbzgb: scan from tail. nowait 0 157,079 0
cache buffers chains kcbrls: kslbegin 0 116,766 180,022
cache buffers chains kcbgcur: kslbegin 0 45,513 23,439
cache buffers chains kcbget: pin buffer 0 24,159 11,193
cache buffers chains kcbzwb 0 11,841 10,482
cache buffers chains kcbget: exchange rls 0 9,859 10,952
cache buffers chains kcbget: exchange 0 8,297 11,715
cache buffers chains kcbcge 0 7,120 15,003
cache buffers chains kcbnlc 0 1,346 2,094
cache buffers chains kcbbxsv 0 468 452
cache buffers chains kcbso1: set no access 0 287 106
cache buffers chains kcb_is_private 0 279 5,736
cache buffers chains kcbgtcr: kslbegin shared 0 244 193
cache buffers chains kcbesc: escalate 0 123 66
cache buffers chains kcb_pre_apply: kcbhq61 0 91 1,286
cache buffers chains kcbnew: new latch again 0 72 7
cache buffers chains kcb_post_apply: kcbhq63 0 49 313
cache buffers chains kcbbic2 0 34 6
cache buffers chains kcb_post_apply: kcbhq62 0 13 234
cache buffers chains kcbzib: finish free bufs 0 5 7
cache buffers chains kcbzhngcbk1: get hash chain latch no wait 0 2 0
cache buffers chains kcbnew_1 0 1 3
cache buffers chains kcbzib: exchange rls 0 1 2
cache buffers chains kcbzib: multi-block read: nowait 0 1 0
cache buffers lru chain kcbzgws 0 559 0
cache buffers lru chain kcbo_link_q 0 303 26
cache buffers lru chain kcbbxsv: move to being written 0 233 461
cache buffers lru chain kcbzgb: posted for free bufs 0 51 308
cache buffers lru chain kcbgtcr:CR Scan:KCBRSKIP 0 43 0
cache buffers lru chain kcbbic2 0 18 291
cache buffers lru chain kcbzib 0 8 0
cache buffers lru chain kcbo_ivd_proc 0 7 75
cache buffers lru chain kcbzswcu 0 7 56
cache buffers lru chain kcbo_write_process:free_unlink 0 2 0
cache buffers lru chain kcbzfw 0 1 0
channel handle pool latch ksrchconnect() 0 73 63
channel handle pool latch ksrchdelete() 0 7 25
channel operations parent latch ksrapublish() 0 42 19
channel operations parent latch ksrchdelete() 0 28 8
channel operations parent latch ksrchconnect() 0 4 10
channel operations parent latch ksrmfree() 0 4 11
channel operations parent latch ksrsconsume() 0 3 10
channel operations parent latch ksrwait() 0 2 29
checkpoint queue latch kcbbwthc: thread checkpoint buffers 0 18 7
checkpoint queue latch kcbkubc 0 5 10
checkpoint queue latch kcbklbc: Link buffer into ckpt queue 0 2 1
checkpoint queue latch kcbswcu: Switch buffers 0 2 9
client/application info kqp327i 0 1 1
dml lock allocation ktaiam 0 34 34
dml lock allocation ktaidm 0 13 18
enqueue hash chains ksqgtl3 0 10 10
enqueue hash chains ksqrcl 0 6 6
enqueue hash chains ksqcmi: get hash chain latch after wait 0 1 1
enqueue hash chains ksqcmi: kslgpl 0 1 1
enqueues ksqgel: create enqueue 0 33 17
enqueues ksqies 0 17 36
enqueues ksqdel 0 16 13
kks stats kks stats alloc/free 0 1 1
lgwr LWN SCN kcs023 0 42 0
library cache kglpndl: child: after processing 0 2,345 149
library cache kglpnp: child 0 2,064 2,859
library cache kglobpn: child: 0 660 1,059
library cache kglpndl: child: before processing 0 320 1,698
library cache kglScanDependency 0 162 0
library cache kglLockCursor 0 128 198
library cache kglhdgn: child: 0 75 83
library cache kgldti: 2child 0 73 3
library cache kglpin 0 63 25
library cache kgldte: child 0 0 52 94
library cache kglhdgc: child: 0 22 4
library cache kglic 0 12 0
library cache kglhdiv: child 0 3 0
library cache kglrtl 0 3 0
library cache kgldtld: 2child 0 2 0
library cache kglobld 0 2 2
library cache kglivl: child 0 1 0
library cache kglupd: child 0 1 0
library cache lock kgllkdl: child: cleanup 0 129 128
library cache lock kgllkal: child: multiinstance 0 69 70
library cache lock kgllkdl: child: no lock handle 0 39 14
library cache pin kglpndl 0 906 681
library cache pin kglpnp: child 0 893 940
library cache pin kglpnal: child: alloc space 0 154 332
library cache pin allocation kglpnget 0 1 1
list of block allocation ktlabl 0 1 1
message pool operations parent latch ksrmalloc() 0 6 4
messages ksarcv: after wait 0 86 135
messages ksarcv 0 68 10
messages ksaamb: after wakeup 0 14 23
mostly latch-free SCN kcslcu3 0 107 150
mostly latch-free SCN kcs01 0 2 2
mostly latch-free SCN kcs024 0 1 0
object queue header heap kcbo_link_q:reget 0 188 3
object queue header heap kcbw_link_q:alloc 0 3 189
object queue header heap kcbw_unlink_q 0 1 0
object queue header operation kcbo_ivbo 0 27,834 10,891
object queue header operation kcbw_link_q 0 4,295 2,771
object queue header operation kcbw_unlink_q 0 1,202 5,513
object queue header operation kcbo_switch_mq_bg 0 476 3,317
object queue header operation kcbo_switch_q_bg 0 426 1,949
object queue header operation kcbo_switch_cq 0 131 3,244
object queue header operation kcbo_link_q:reget 0 57 158
object queue header operation kcbo_write_q 0 47 8
object queue header operation kcbo_service_ockpt 0 15 0
object queue header operation kcbo_swap_buf 0 10 519
object queue header operation kcbo_swap_buf_bg 0 7 6,433
object queue header operation kcbw_unlink_q_bg 0 1 27
parallel query stats kxfprst: KSLBEGIN:1 0 7 7
parameter table allocation management ksp_param_table_free 0 236 236
parameter table allocation management kspallmod 0 1 0
post/wait queue ksliwat:remove 0 1 1
process allocation ksucrp 0 26 0
process allocation ksudlp 0 3 14
process queue reference kxfpqrsnd 0 1 0
redo allocation kcrfw_redo_gen: redo allocation 1 0 540 0
redo allocation kcrfw_redo_gen: redo allocation 3 0 152 606
redo allocation kcrfw_redo_gen: redo allocation 2 0 45 0
redo allocation kcrfw_redo_write: more space 0 22 113
redo allocation kcrfw_redo_write: before write 0 17 65
redo writing kcrfwcr 0 19 28
redo writing kcrfw_post: rba scn pair 0 7 0
redo writing kcrfw_cal_target_rba 0 2 0
redo writing kcrfw_post: after write 0 2 2
resmgr:actses active list kgskchclass 0 183 87
resmgr:actses active list kgskactladd 0 1 93
resmgr:actses active list kgskactlrem 0 1 75
resmgr:free threads list kgskthrcreate 0 1 1
resmgr:free threads list kgskthrsod 0 1 1
row cache objects kqreqd: reget 0 939 15
row cache objects kqrpre: find obj 0 229 612
row cache objects kqreqd 0 81 633
row cache objects kqrso 0 11 1
sequence cache kdnssd 0 41 6
sequence cache kdnnxt: cached seq 0 19 2
sequence cache kdnss 0 4 59
session allocation ksuxds: KSUSFCLC not set 0 769 129
session allocation ksucri 0 147 329
session allocation ksuprc 0 113 254
session allocation ksuxds: not user session 0 110 206
session allocation ksudlc 0 105 330
session allocation kxfpqidqr 0 25 37
session allocation kspallmod 0 22 0
session allocation ksursi 0 18 28
session allocation ksudlp 0 9 4
session allocation kxfprdp 0 5 5
session idle bit ksupuc: set busy 0 244 112
session idle bit ksupuc: clear busy 0 130 259
session idle bit ksuxds 0 14 17
session state list latch kpseqd 0 34 0
shared pool kghupr1 0 287 396
shared pool kghalo 0 205 119
shared pool kghfrunp: clatch: nowait 0 160 0
shared pool kghalp 0 45 16
shared pool kghfrunp: alloc: wait 0 23 0
shared pool kghfre 0 21 75
shared pool kghfrunp: alloc: cursor dur 0 21 0
shared pool kghfrunp: clatch: wait 0 15 11
shared pool kgh: sim resz update 0 3 0
shared pool kghfrh 0 1 0
sort extent pool ktstdt: dealloc sort extent 0 9 3
sort extent pool ktstaddextent1 0 2 1
sort extent pool ktstsmonmsg 0 2 10
sort extent pool ktstdt: return extent 0 1 1
undo global data kturimugur: child 0 2,707 2,263
undo global data ktudba: KSLBEGIN 0 384 874
undo global data ktucof: at start 0 23 0
undo global data ktusmasp: ktugd_tuux 0 8 1
undo global data ktubnd:child 0 7 0
undo global data ktudnx:child 0 7 2
undo global data ktufrbs: child 0 7 4
undo global data ktumof: KSLBEGIN 0 2 0

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Back to Top

Segments by Logical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeLogical Reads%Total
AR APPS_TS_TX_INTERFACE RA_INTERFACE_LINES_ALL   TABLE 69,203,872 3.47
INV APPS_TS_TX_IDX MTL_ITEM_CATEGORIES_U1   INDEX 50,717,968 2.54
ONT APPS_TS_TX_DATA OE_ORDER_LINES_ALL   TABLE 23,377,776 1.17
WSH APPS_TS_TX_DATA WSH_DELIVERY_DETAILS   TABLE 20,462,656 1.02
APPLSYS APPS_TS_TX_DATA WF_LOCAL_USER_ROLES FND_RESP TABLE PARTITION 20,214,384 1.01

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
GL APPS_ASSM_DATA GL_JE_LINES   TABLE 35,014 7.39
AR APPS_ASSM_DATA RA_CUSTOMER_TRX_LINES_ALL   TABLE 13,044 2.75
WSH APPS_TS_TX_DATA WSH_DELIVERY_DETAILS   TABLE 9,554 2.02
HR APPS_TS_TX_IDX PAY_PERSON_LATEST_BALA_N50   INDEX 4,776 1.01
HR APPS_ASSM_DATA PAY_RUN_RESULTS   TABLE 4,047 0.85

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
APPLSYS APPS_TS_TX_IDX WF_ITEM_ACTIVITY_STATUSES_N1   INDEX 14,166 29.51
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_U1   INDEX 9,744 20.30
WSH APPS_TS_TX_DATA WSH_TRIP_STOPS   TABLE 9,600 20.00
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N6   INDEX 3,411 7.11
HR APPS_ASSM_IDX PAY_RUN_RESULT_VALUES_PK   INDEX 2,010 4.19

Back to Segment Statistics
Back to Top

Segments by ITL Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeITL Waits% of Capture
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N6   INDEX 31 30.10
APPLSYS APPS_TS_TX_IDX WF_ITEM_ATTRIBUTE_VALUES_PK   INDEX 25 24.27
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N5   INDEX 12 11.65
GL APPS_ASSM_IDX GL_IMPORT_REFERENCES_N3   INDEX 9 8.74
GL APPS_ASSM_IDX GL_IMPORT_REFERENCES_N1   INDEX 4 3.88

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_U1   INDEX 185,535 32.32
APPLSYS APPS_TS_TX_DATA WF_ITEM_ATTRIBUTE_VALUES   TABLE 101,411 17.67
SYS SYSTEM DBMS_LOCK_ALLOCATED   TABLE 31,440 5.48
AR APPS_ASSM_IDX RA_CUST_TRX_LINE_GL_DIST_N6   INDEX 30,857 5.38
AR APPS_TS_TX_INTERFACE RA_INTERFACE_LINES_ALL   TABLE 19,700 3.43

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control 5 20.00 0   2 1
dc_constraints 600 46.83 0   600 0
dc_files 6,660 0.00 0   0 111
dc_global_oids 7,068,180 0.00 0   0 48
dc_histogram_data 5,618 11.98 0   0 776
dc_histogram_defs 389,069 2.71 0   4,013 4,052
dc_object_grants 65,473 0.08 0   0 67
dc_object_ids 11,779,719 0.02 0   54 1,083
dc_objects 165,855 1.13 0   313 786
dc_profiles 8,870 0.00 0   0 1
dc_rollback_segments 19,342 0.00 0   0 353
dc_segments 338,360 0.62 0   15,667 1,371
dc_sequences 51,233 0.13 0   51,233 108
dc_table_scns 19,366 0.04 0   0 5
dc_tablespace_quotas 15,533 0.14 0   216 43
dc_tablespaces 5,463,300 0.00 0   0 22
dc_usernames 466,635 0.00 0   0 19
dc_users 13,697,347 0.00 0   0 64
outstanding_alerts 268 0.75 0   1 43


Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY 589,629 0.02 39,092,870 -0.00 11 0
CLUSTER 96 0.00 233 0.86 2 0
INDEX 14,251 0.42 15,042 0.58 0 0
JAVA DATA 624 0.00 0   0 0
PIPE 45,623 2.56 67,269 1.74 0 0
SQL AREA 6,047 91.04 106,468,596 0.09 3,483 387
TABLE/PROCEDURE 373,961 0.27 53,439,290 -0.01 955 0
TRIGGER 26,331 0.10 1,357,602 0.00 27 0


Back to Top

Memory Statistics

Back to Top

Process Memory Summary

CategoryAlloc (MB)Used (MB)Avg Alloc (MB)Std Dev Alloc (MB)Max Alloc (MB)Hist Max Alloc (MB)Num ProcNum Alloc
B Other 33,316.63   11.77 6.83 40 40 2,831 2,831
  Freeable 3,254.31 0.00 1.31 0.80 9   2,489 2,489
  SQL 3,138.49 1,606.32 1.11 0.70 5 22 2,823 2,821
  PL/SQL 2,136.00 172.41 0.75 0.95 3 3 2,831 2,831
  JAVA 240.60 239.36 2.23 0.27 4 6 108 108
E Other 40,395.70   14.09 8.46 42 42 2,866 2,866
  Freeable 3,917.44 0.00 1.51 0.94 9   2,586 2,586
  SQL 3,694.22 1,931.98 1.29 0.76 5 22 2,858 2,856
  PL/SQL 2,535.68 199.01 0.88 0.98 3 3 2,866 2,866
  JAVA 240.67 239.42 2.23 0.27 4 7 108 108

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers 18,706,595,840 18,522,046,464
Fixed Size 2,111,120  
Redo Buffers 14,663,680  
Variable Size 2,751,465,840 2,936,015,216

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
java free memory 83.29 83.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 40.50 40.50 0.00
shared CCursor 33.84 34.84 2.93
shared KTI-UNDO 53.19 53.19 0.00
shared PL/SQL MPCODE 66.67 68.97 3.46
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 401.61 394.92 -1.67
shared library cache 775.45 934.41 20.50
shared parameter table block 52.46 52.80 0.65
shared private strands 99.77 99.77 0.00
shared sessions 36.42 36.42 0.00
shared sql area 355.02 379.34 6.85
shared trace buffer 44.33 45.03 1.59
  buffer_cache 17,840.00 17,664.00 -0.99
  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

Resource NameCurrent UtilizationMaximum Utilization Initial Allocation Limit
processes 2,866 2,883 3600 3600


Back to Top

init.ora Parameters

Parameter NameBegin valueEnd 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
email this page E-mail this page printer view Printer View
Oracle Is The Information Company About Oracle | Oracle RSS Feeds | Subscribe | Careers | Contact Us | Site Maps | Legal Notices | Terms of Use | Your Privacy Rights