Monthly Archives: April 2013

Bind variable peeking: Retrieve peeked and passed values per execution in oracle 11.2

To understand this blog post you have to know what bind variable peeking is. You can found a very good explanation into this Kerry Osborne’s blog post. So when dealing with performance issues linked to bind variable peeking you have … Continue reading

Posted in Perl Scripts | 8 Comments

Drill down to sql_id execution details in ASH

Some times ago I explained how we can link a huge PGA or TEMP consumption to a sql_id over a period of time into this blog post. Now I need to extract this information not only per sql_id but also … Continue reading

Posted in Perl Scripts | Leave a comment