Ok, it's official. I hate the 10g OEM.
I think I've lost alot with the 10g OEM. We've struggled to get grid control and the OEM OMS working, and it seems so sluggish and difficult to do the simplest things. Sorting Top SQL. Looking at queries that seem to be acting funny. Quick glances to see if N users are connected. All either hidden , difficult to use, or non existant.
And don't get me started on SQL_ANALYZE disappearing. We used to be able to take a diffucult query, put it in a text box, hit a button and have it's index usage analzed and suggestions made. GONE! Don't say that the AWR replaces this, as it doesn't seem to have any of it's old capabilities.
I know they are trying to position grid control as a enterprise monitoring system, but what we need first and formost is a DATABASE monitoring system.
Thank God I have Toad.
Rant over.
Bob