Finding if a specific object (procedure / package etc) is being used by a session
Hello
We have a 19c database
Sometimes when we try to compile an object like a procedure or package the session from where we are running that compile from hangs as there is another session holding a library cache pin lock on that object. So we are trying to come up with a way to determine if we can find out during any given time if any specific procedure or package is being used by a particular session and first close that session and then do the compile
Any help or guidance would be greatly appreciated
Thanks a lot