Re: Isnt there anybody who can answer

Jonathan,

Completely agree with you.
Anurag, you could also look at v$lock or v$locked_object to see which locks are
currently active, or run %ORACLE_HOME%/rdbms73/admin/utlockt.sql to mention a few options.
But you posted your initial question on Sunday, when at least I can't verify the validity of several approaches: no personal oracle on my own PC. Usenet is a volunteer business, we're not getting paid (and then both Jonathan and myself would probably get rich).

In article <930568290.19250.0.nnrp-06.9e984b29_at_news.demon.co.uk>,   "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:
>
> Your question is too generalised for anyway to
> give a good answer. But you might want to look
> as the dbms_lock package in $ORACLE_HOME/rdbms/admin/dbmslock.sql
> as that might describe the sort of thing you are after.
>
> --
>
> Jonathan Lewis
> Yet another Oracle-related web site: www.jlcomp.demon.co.uk
>
> Anurag Minocha wrote in message

<37775140.D2398D38_at_synergy-infotech.com>...
> >I had posted one question . The subject was
> > Identifying whether a particular lock is active or not.
> >
> >Is'nt there anybody who can answer This .If yes i am sending the
> >question again with this mail
> >
> >Hi ,
> >Is there a way i can assign a number to a lock (select ... for
update)
> >and then find out from some other procedure that whether that
particular
> >
> >lock is active or not. Please Help me out with this or suggest some
> >other method to do this.
> >
> >anurag
> >
> >
> >reply at
> >anurag_at_synergy-infotech.com
> >
> >
> >
> >
> >
>
>

Hth,

--
Sybrand Bakker, Oracle DBA

All standard disclaimers apply

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Jun 28 1999 - 07:14:59 CDT