Skip to Main Content

SQL & PL/SQL

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!

Lock on package compilation

guruparanJun 17 2008 — edited Jun 17 2008

Hi All

When I tried to compile a package I got the below error.

create or replace package my_sample_pack
*
ERROR at line 1:
ORA-04021: timeout occurred while waiting to lock object my_sample_pack

Then I queried

 v$access 

. There is an entry. I also, flushed the shared_pool. But still this problem exists. What should I do from here?

Thanks in advance.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 15 2008
Added on Jun 17 2008
3 comments
1,044 views