Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Locks in dba_ddl_locks not appear in V$sessions

658611Dec 23 2011 — edited Dec 23 2011

Hi,

I need to drop a stored procedure which status is invalid, but when I try to do it the process never end...

When I look in dba_ddl_locks then I found 4 sessions locking the object, but if I look for this sessions in V$sessions that not appear so than I can´t kill that sessions.

If I try to close the instance by using of shutdown immediate, database don´t close and still waiting for that sessions be closed. I only can down the instance by shutdown abort, but when restart it I have the same problema again...

I work wiht Oracle 9i on W2003R2.

Somebody knows how can I kill that sessións??

Thanks

This post has been answered by Helios-GunesEROL on Dec 23 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 20 2012

Added on Dec 23 2011

#general-database-discussions

11 comments

4,277 views