SQL Performance (MOSC)

MOSC Banner

DB Sequential file reads

edited May 23, 2013 5:47AM in SQL Performance (MOSC) 10 commentsAnswered ✓
Hi Gurus,
Please see the below tkprof output for one of my sql queries on an 11.2.0.3 RAC Database where storage is on ASM(SAN Disks):

********************************************************************************



call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.02       0.02          0           0            0           0
Execute    1      0.08       0.08          0           0             0           0
Fetch        5      0.41      10.69       1730       2989          0         994
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        7      0.52      10.80       1730       2989           0         994

Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: 85
Number of plan statistics captured: 1

Rows (1st) Rows (avg) Rows (max)  Row Source Operation
---------- ---------- ----------  ---------------------------------------------------
       994        994        994  INLIST ITERATOR  (cr=2989 pr=1730 pw=0 time=10683244 us)
       994        994        994   TABLE ACCESS BY INDEX ROWID VS_LOOKUP_10 (cr=2989 pr=1730 pw=0 time=10677273 us cost=1940 size=201000 card=1000)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center