# Toad is not responding when compiling a package

**URL:** <https://forums.toadworld.com/t/toad-is-not-responding-when-compiling-a-package/10293>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [March 4, 2011, 1:41pm UTC](https://forums.toadworld.com/t/toad-is-not-responding-when-compiling-a-package/10293 "2011-03-04T13:41:27Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![anatoad](https://avatars.discourse-cdn.com/v4/letter/a/8491ac/32.png) [@anatoad](https://forums.toadworld.com/u/anatoad)\
**Post date:** [March 4, 2011, 1:41pm UTC](https://forums.toadworld.com/t/toad-is-not-responding-when-compiling-a-package/10293/1 "2011-03-04T13:41:27Z")

</div>

Hi,

For some hours ago I’ve canceled an DROP INDEX operation. Toad become non responsive, and I had to “kill” it from Windows Task Manager. I started Toad again, and I executed DROP INDEX myIndex FORCE. This worked.

But I have a package containing several procedures related to the table whose index I dropped. Now, when I compile this package, Toad becomes not responsive.

It seems that something has been locked (?). Has anybody some tips?

Thank you in advance.

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [March 4, 2011, 1:41pm UTC](https://forums.toadworld.com/t/toad-is-not-responding-when-compiling-a-package/10293/2 "2011-03-04T13:41:27Z")

</div>

My guess is that there is a lock in the database. Oracle is waiting on the lock,  
and Toad is waiting on Oracle.

Start up another copy of Toad, go to the session browser, Locks tab, and you  
should be able to find the session holding the blocking lock.

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [March 4, 2011, 6:15pm UTC](https://forums.toadworld.com/t/toad-is-not-responding-when-compiling-a-package/10293/3 "2011-03-04T18:15:49Z")

</div>

Or you can go directly to your locked session and check the waits. My guess is  
that you will find a library cache pin there because there is another session  
running which uses the package you want to recompile.