DB Sequential file reads
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)
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)
0