Re: Is non-read consistent select possible

From: Jurij Modic <jurij.modic_at_mf.sigov.mail.si>
Date: 1997/07/29
Message-ID: <33ddbac7.12620452@www.sigov.si>#1/1

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.

Don't know of a way to achive this, I just want to mention that the export with CONSISTENT=N is conceptualy quite different from your "non-read consistent" select demand.

Even with CONSISTENT=N the export kips consistent wiew of the table it is exporting. In other words, it will export the table as it was at the moment the export of that table had begun. What the "inconsistency" in this mode can be is that different tables can be in inconsistent state in relations to each other.

>
>Any suggestions or clues?
>
>Thanks,
>Abhijit

Regards,

---

Jurij Modic                             Republic of Slovenia
jurij.modic_at_mf.sigov.mail.si		Ministry of Finance
============================================================

The above opinions are mine and do not represent any official standpoints of my employer Received on Tue Jul 29 1997 - 00:00:00 CDT