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