Re: sequential read on full-table scan?

  • From: Paul Baumgartel <paul.baumgartel@xxxxxxxxx>
  • To: Oracle-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 20 May 2005 12:50:17 -0400

The sequential reads happen during both the update and the select.=20
V$SQL_PLAN shows TABLE ACCESS FULL OE_LINEITEM_RPT for both of them.

On 5/20/05, Wolfgang Breitling <breitliw@xxxxxxxxxxxxx> wrote:
> Are the sequential reads happening during the select or during the
> update sql?
> What does v$sql_plan say about the plan?
--
//www.freelists.org/webpage/oracle-l

Other related posts: