Friday, December 20, 2013

Recursive Procedure Compilation

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: 

1 comment:

  1. Shared to Linkedin on 20th June 2018.