Re: When ORA-00054 and when wait?

Sybrand Bakker wrote:
>
> On Tue, 19 Feb 2002 18:11:47 GMT, j.w.vandijk_at_hetnet.nl (Jaap W. van
> Dijk) wrote:
>
> >When a required lock is already taken, which DML or DDL statement will
> >result in a ORA-00054 (resource busy...) and which will result in a
> >wait until the lock is freed?
> >
> >And where is this documented?
> >
> >Jaap.
>
> AFAIK any DDL is always implicitly 'for update nowait' and will result
> in ora-0054 if the associated dictionary table is locked.
> A select for update is always wait unless you explicitly code 'for
> update nowait'. The same applies to the LOCK TABLE statement.
> This should be documented with the for update clause of the select
> statement, and the LOCK table statement.
> Any implict DML locks (ie you issue an update without isuing a select
> for update) are always 'for update wait'
>
> Hth
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address

9i (finally) has a timeout facility when attempting a for-update-wait

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."