This was tested on Oracle 11.2. You cannot compile a procedure if anybody is running it so, if you write a procedure which compiles itself, it hangs:
This appears in V$SESSION_EVENT as a library cache pin:
… and, if you look in x$kglpn, you see that SID 296 is blocking and waiting simultaneously:
No comments:
Post a Comment