Thread: Re: [HACKERS] please?

Re: [HACKERS] please?

From
Keith Parks
Date:
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
acquirewith NOWAIT specified
 


 no rows selected
 SQL> 

No idea how to impliment it though!!