From: member41542@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?   
      
      
      
   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???   
      
      
      
   Thanks & Regards,   
      
   Channa.   
      
      
   --   
   Posted via http://dbforums.com   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)