Re: sequential read on full-table scan?

Are the sequential reads happening during the select or during the update sql?
What does v$sql_plan say about the plan?

Paul Baumgartel wrote:
> SELECT SUM(OPTIONS_VESTED) SUM_VESTED,SUM(ACTUAL_FORFEITURE)
...
> followed by=20
>
> UPDATE /*+ rule */OE_LINEITEM_RPT R SET FAS123_TURNOVER=3DROUND(:b1 /
...
>
> (and statspack reports) show that the process is spending 80% of its
> time waiting for db file sequential read of 1 block from the table.=20

Just because they are sequential reads (or rather single block reads) doesn't mean it's not a FTS. Oracle CAN do FTS using single block reads.

-- 
Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com
--
http://www.freelists.org/webpage/oracle-l