From memory request to PL/SQL source line

Here is a little experimental script based on a great blog post by Stefan Koehler entitled Trace back to responsible SQL or PL/SQL code for a particular (PGA) memory request by intercepting process with DTrace and one of my old blog post  Geeky PL/SQL tracer/profiler : First step

And here is what it does :


Source PL/SQL program doing huge memory allocation :

Capture 01

Script Output : (smem_detail.sql by Tanel Poder)

Capture 02

Basically this script will help trace back the PL/SQL source line responsible for particular  memory allocation (memory leak) by specifying the memory allocation reason.

For more info please read the above blog posts 🙂


One thought on “From memory request to PL/SQL source line

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s