Database Tuning (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center