Re: How to read UNCOMMITED data in Oracle?

"francis70" <member41542_at_dbforums.com> wrote in message news:3482578.1066194657_at_dbforums.com...
>
> Hi,
>
>
>
> I have these 2 problem? Is there a way in Oracle to read UNCOMMITED
> data. i.e. in Oracle the normal behaviour is that a user's updates to a
> table are visible to other users ONLY when the user commits. But in
> Informix there is this thing called ISOLATION LEVELS. For example by
> setting the ISOLATION LEVEL to DIRTY READ, a user will read dirty data,
> i.e. the last uncommited updated value of a field by some other user. Is
> this possible in Oracle by setting some parameter, say in the INIT file?
>
>
That really isn't a feature; it is a behavior to get around a poor locking model.
>
> Also WHAT IS THE DEFAULT LOCKING BEHAVIOUR IN ORACLE? I mean if I want
> Oracle to automatically issue a READ LOCK (so that nobody can update a
> record, but view only) everytime a table (or row) is read, and for this
> to be made effective for the ENTIER DATABASE, how can we achive this? Is
> there a parameter to change in some INIT file???
>
>
So you are going to serialize database usage a lot, ouch! Why do you want to do this? If most data is read and not changed then this is going to cause you a lot of headaches.
Jim
>
> Thanks & Regards,
>
> Channa.
>
>
> --
> Posted via http://dbforums.com
Received on Wed Oct 15 2003 - 14:45:11 CEST