package will not re-compile Options

[acesiowa]

In our development environment we need to re-compile packages as we change our code. Once in a while a session will hold onto a package, like it is being used, restricting me from compiling it.

Is there a way to find out what SID is holding on to the package in order for me to kill it?

[acesiowa]

In our development environment we need to re-compile packages as we change our code. Once in a while a session will hold onto a package, like it is being used, restricting me from compiling it.

Is there a way to find out what SID is holding on to the package in order for me to kill it?

Just the name of the view will work. I don't want to take up any more time than in neccessary. With the name of the view, I can figure out what columns I need.

[acesiowa]

Just the name of the view will work. I don't want to take up any more time than in neccessary. With the name of the view, I can figure out what columns I need.

select x.sid
from v$session x, v$sqltext y
where x.sql_address = y.address
and y.sql_text like '%<package name>%';

figured it out

thanks anyway