hey guys - I need your help.
when I try to add a partition to a table, it invalidates
all packages that are referencing that partition.
whenever a user tries to run a sp it automaticallt tries to compile the package body.
sometimes, the operation hangs, and in v$session_wait you
see that it is stuck on "library cache lock" wait, causing
all other users to hang as well on "library cache pin" wait.
the oracle version is 220.127.116.11.0 on NT.
my questions are:
1. is this a normal Behavior that refencing SP's becomes
INVALID and needs to be compiled after I issue an
"alter table add partition" command?
2. why does the compilation stucks on this wait?
please help me - it's urgent.
10x in advance.