Call: +44 (0)1904 557620 Call

Pete Finnigan's Oracle Security Weblog

This is the weblog for Pete Finnigan. Pete works in the area of Oracle security and he specialises in auditing Oracle databases for security issues. This weblog is aimed squarely at those interested in the security of their Oracle databases.

[Previous entry: "Google hacking and reverse engineering Java"] [Next entry: "Alex has presentation notes available and a forthcoming paper"]

tracing inside a PL/SQL procedure

I found an interesting thread on the Oracle-l mailing list a few days ago titled "How to trace what is happening inside the stored procedure". This thread asked if its possible to trace what is going on inside a PL/SQL procedure. This generated a few interesting comments from a few posters. The thread index is here.

I also wrote a paper about the many ways to set trace in Oracle for the current session or another session and also how to set the different levels of trace. This paper is called "many ways to set Oracle trace for your session, others sessions and at instance level".

The post of interest to me in the oracle-l thread was one by Tanel Poder where he goes into great detail about how X$ tables work and how the MODULE and ACTION data for each session are accessed through the X$ tables. For those amongst you who like internals details. This thread is a must read. The thread by Tanel is here.