Re: Avoiding ORA-4021

From: Chuck <chuckh_at_softhome.net>
Date: 22 Sep 2003 19:47:19 GMT
Message-ID: <Xns93FEA09BDCA73chuckhsofthomenet@130.133.1.4>

Sybrand Bakker <gooiditweg_at_sybrandb.nospam.demon.nl> wrote in news:p0ojmvc10kv03am9a6g6jrarsvlb9cfusa_at_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
>

The application that has the object pinned is 24x7. I guess I will have to wait until the next monthly reboot to grant my permissions. Received on Mon Sep 22 2003 - 14:47:19 CDT