Some of the prices I got off of programmers paradise, others are word of mouth, so any clarifications on prices would be appreciated. The tools marked “yes” are ones that I use or would use. I would use Quest’s Performance Analyzer given the chance. I’ve never used it but from the demos of the tool, I like what I see. I have never used Mumbai, but plan to and like again what I see in the demos. All the other tools marked “yes” I use. All the tools except “other stuff”, I consider reasonable tools for one job or another. Some are better than others in different ways. The “other stuff” tools I don’t see much point in. I generally consider OEM with diagnostic pack too expensive and slow, but hey, if customers have it, I’ll use it ! Plus diag pack comes with v$active_session_history and all of AWR which I can query directly with OEM.

Is there any tool, where I will write an SQL query and it will automatically return me the most optimized query based on my time/ IO cost requirement ?
I am not asking about explain plan and all where I have to make a trial and error to get the best time saving query written by me own.
Please reply and forgive my unawareness regarding this.
– Arpan

I was frustrated by the slowness of OEM Grid Control and its agents. When you are under pressure you don’t want to be waiting minutes just to know if all your databases are up and accepting connections. So I developed this dashboard to give the answer reliably in seconds not minutes.

The dashboard is just for looking at things so it’s safe. Installing it takes about the same effort as installing SQL Developer and adding all your database connections. You can schedule a batch job to collect nightly statistics on tablespace growth for capacity planning. Everything it does is something that other tools did not give me or did so in a too complicated way.

This is not so much a performance tool although it does include Tanel Poder’s Snapper script in its Sessions panel. It’s for getting quick answers in the fewest mouse clicks.

I forgot to say just click on my name to go to the website http://www.dbcafe.ch/ where you can download the free dashboard for Oracle databases. It runs on Windows but the databases can be on any platform.

Starting 2017 Panorama contains it’s own sampling engine so one can use Panorama based on AWR and ASH data (if Diagnostics Pack is licensed) or based on it’s own sampled workload history including ASH.
This way AWR- and ASH-like analysis is also available for Standard Edition or EE without Diagnostics Pack.