KinsaKaUy? wrote:But you asked "Does it l have explain plan tools? same with 11.2?" which you could have very easily answered for your self by consulting the documentation. Ok, so your forgot if it was available in 9i. You could still constult the documentation to see if it is or not.
Yes, I read it already (before)
But if you are not using it for a long time you tend to forget :(
Why would Oracle, or anyone, spend time, money or other resources to design a tool to detect problems with such ancient software? That time would be better spent on building new, better things.Even in the latest versions of DBs like 11.2.0.x The tool seems did not improve or maybe little? when you hit performance issues. Statspack vs AWR. :)