Full Table Scan

There are about a 10,000 records in a table. A user 1 runs a query which is doing a full table scan. While doing the full table scan, user 2 changes some value x to y using a DML statement in record. What does the the 1st user see ( x or y ) ? If x, then where is the value stored?

Questions by shanthiavari

Showing Answers 1 - 7 of 7 Answers

kollati

  • Jul 18th, 2008
 

in full table scan, if another user updates the value for a given row does not affect the full table scan if the user finishes the update by the time the oracle reads that particular record will get updated value otherwise it has the old value.

  Was this answer useful?  Yes

sean21

  • Mar 8th, 2010
 

There are about a 10,000 records in a table. A user 1 runs a query which is doing a full table scan. While doing the full table scan, user 2 changes some value x to y using a DML statement in record.

What does the the 1st user see ( x or y ) ?
x because no commit issued

If x, then where is the value stored?
x value is read from datafile to memory

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions