I like the performance tuning features, particularly since it gives me a good glimpse of what has been happening. We maintain the data for 31 days, so I can graphically go back and see what exactly happened during that time. I can drill down to the user level or the SQL level and see what was happening at any point in time. That's a pretty good feature, and because it's more graphical, I don't have to analyze a whole bunch of rows.
Improvements to My Organization
In terms of the user response time, if I were to do a lot of queries, and analyze it, we can quickly provide the result to the end user or the developers, and then quickly come back to solving a lot of performance problems.
Room for Improvement
With any Oracle protocol, and Enterprise Manager is one of them, as far as the interface is concerned, it's not good and is still pretty ugly. I would like to see a decent UI because there are a lot of tools on the market that also give good drill-down capabilities. For example, with Enterprise Manager's drill down to database blocking logs, you can no longer see that in the UI, whereas other tools allow that. I need to be able to do this type of drill-down in one tool without having to manage different tools that do different things.
Use of Solution
I've been using Oracle products for 22 years.
We've had no issues with deployment.
You should go with the latest version as it's more stable, and that's one of the reasons I like it. It's a pretty stable platform.
We have a pretty good number of database with Oracle Enterprise Manager. You can scale it as much as you want. We have about 1,200 databases that we manage using it.
Customer Service and Technical Support
I have not used technical support because I am not the one who administer it. Technical support is good, I've heard.
If you're using one or two databases, Enterprise Manager is not something you want to use because Oracle has other products that can make it simpler. But ff you are using more than five or six databases, Enterprise Manager is the way to go.