From: kennedy-downwithspammersfamily@attbi.net   
      
   "francis70"  wrote in message   
   news:3482578.1066194657@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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)