Suppose we want to investigate/debug the initial phases of an oracle process creation such as the authentication step (Oracle getting anyone’s password) , how to processed ? We will have to attach to the process just after it’s creation ! Here is a systemtap script that may help !
TEST ENV : Oracle 12.1.0.2.6/UEK4/OEL 6/systemtap 3.1
I just modified the script used in my blog post systemtap : A mini oracle db firewall to suspend the oracle process just after is has been forked (using the SIGSTOP signal the idea come from Mauro Pagano blog post Manually holding an enqueue with SystemTap).
Now attach to the oracle process using GDB/intel pin for example and hit Ctr+C to resume execution.
DOWNLOAD : new_proc_sus.stp
That’s it 😀
Hatem Mahmoud's blog 