Re: ORA-00054: resource busy...
Date: Sat, 20 Feb 1999 07:52:55 GMT
Message-ID: <rRtz2.9113$0p5.3375_at_news.rdc1.md.home.com>
Examine what, and when your code is locking or allowing to be locked by Oracle. You probably started to updated sometime and your code or another user's process/job/code has the same thing in mind. Simple answer but you and/or your DBA can examine locking behavior with management tools or by querying the V$ tables to pinpoint and resolve the problem(s).
Mike Rose
ewong74_at_netscape.net wrote in message <7al51h$otu$1_at_nnrp1.dejanews.com>...
>Hi,
>
>I am calling a PL/SQL block(has been compiled successfully) from a csh
script
>and I got the following error. The wired thing is that I don't get this
error
>every time. Any idea?
>
>Thanx.
>
>ORA-00054: resource busy and acquire with NOWAIT specified
>ORA-06512: at "SYS.DBMS_SYS_SQL", line 491
>ORA-06512: at "SYS.DBMS_SQL", line 32
>ORA-06512: at "USER.MY_PROC", line 6.
>
>Ed
>
>
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Sat Feb 20 1999 - 08:52:55 CET