Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Investigating those locks

Re: Investigating those locks

From: Axel Stahl <stahl_at_pdg-online.de>
Date: Wed, 29 Jan 2003 15:40:29 +0100
Message-ID: <3e37e7d1$1@news.celox.de>


Hello Paul,

if you mean that I want to have the SQL-statement which caused the "first" lock to be served on a silver tray, you are right :-)

Axel

"Paul Brewer" <paul_at_paul.brewers.org.uk> schrieb im Newsbeitrag news:3e36fce9_1_at_mk-nntp-1.news.uk.worldonline.com...
> "Sybrand Bakker" <gooiditweg_at_nospam.demon.nl> wrote in message
> news:ajbd3vomsnsjrul1m4ml0mt34e1chfjigl_at_4ax.com...
> >
> > Please check out the locking scripts provided in
> > $oracle_home/rdbms/admin and the corresponding doco.
> > They haven't changed so you can use the 8i or the 7.3.4 doco as well.
> >
> I suspect that the OP would prefer to have the DBA_WAITER bring the the
> answer to his table, on a silver tray.
> (Hope this doesn't lose in translation; if it does I admit to being a
> dba_blockhead).
>
> Regards,
> Paul
>
>
>
Received on Wed Jan 29 2003 - 08:40:29 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US