Re: Avoiding ORA-4021

From: Sybrand Bakker <gooiditweg_at_sybrandb.nospam.demon.nl>
Date: Thu, 18 Sep 2003 18:42:10 +0200
Message-ID: <p0ojmvc10kv03am9a6g6jrarsvlb9cfusa@4ax.com>

On 18 Sep 2003 14:27:07 GMT, Chuck <chuckh_at_softhome.net> wrote:

>ORA-04021: timeout occurred while waiting to lock object SYS.DBMS_LOCK
>
>I'm trying to grant access on a system object that is constantly in use. Is
>there any way to do that and avoid ora-4021 apart from killing the users
>that have the object open?

Try do to it outside office hours, or shutdown the database, bring it up in restricted mode and perform your grant.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Sep 18 2003 - 11:42:10 CDT