Re: SQL performance issue

For troubleshooting SQL issues I start with planx.sql ( https://github.com/karlarao/scripts/blob/master/performance/planx.sql) to get most of the info I need to see what's happening, and which part of the plan_id it's spending most of the time and related info I can correlate with around the SQL_ID. This was written by Carlos but I added a few of my own SQLs and call to snapper

_at_planx Y <sql_id>

And then I would run sqld360/sqldb360 if I need more info like metadata info, parameters, etc.

-Karl

-- 
Karl Arao
Wiki: karlarao.wiki
Twitter: _at_karlarao <http://twitter.com/karlarao>

--
http://www.freelists.org/webpage/oracle-l