| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Is non-read consistent select possible
On 28 Jul 1997 21:34:18 GMT, emrynsoft_at_aol.com (Emrynsoft) wrote:
>Hi,
>
>Is there any way to do a non-read consistent select? Which means that the
>select should read the dirty blocks and not go to the rollback segments
>for maintaining read-consitency. This would be similar to what export does
>when consistent=N is specified.
>
>Any suggestions or clues?
>
>Thanks,
>Abhijit
No there is not.
when you specify consistent=n for export it means that each SQL statement to read data will be consistent but across statements it will not be. Export does not bypass anything the database does. It does not do a dirty read. Each statement is consistent with respect to a point in time, each of the statements may be inconsistent with eachother. Consistent=Y will make sure that each statements result set is consistent with every other statement.
What are you trying to do? Why do you think you need a dirty read?
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Bethesda MD
http://govt.us.oracle.com/ -- downloadable utilities
 |
 |