
Bruce Momjian <maillist@candle.pha.pa.us>
> 
> > Bruce Momjian wrote:
> > > 
> > > I don't know of any SQL databases that allow non-blocking lock requests.
> > > 
> > 
> > Oracle OCI has oopt() and Informix Online has dirty read that do the trick for
> > me.
> > --------
> 
> Please give me more information.  How does dirty read fix the problem?
> 

This all sounds like the Oracle NOWAIT option.

Session1.

  SQL> select value from sys_param where name = 'ASG_SYSTEM_DESC' for update;

  VALUE
  ------------------------------
  tpwmamda

  SQL> 

Session2.

  SQL> select value from sys_param where name = 'ASG_SYSTEM_DESC' for update nowait;
  ERROR:
  ORA-00054: resource busy and acquire with NOWAIT specified



  no rows selected

  SQL> 

No idea how to impliment it though!!


Mon, 31 May 1999 21:44:24 +0100 (BST)
Keith Parks <emkxp01@mtcc.demon.co.uk>
Re: [HACKERS] please?