The use case was the monitoring of the database, which included consumption of resources such as CPU, memory, processes, and I/O.
One of the clearest examples is the agility of discovering processes/sessions that are burdening the database environment. With this agility, the DBA can more quickly verify this type of problem, in addition to checking locked sessions and not having to do several searches in views and tables of the data dictionary. The tool already does this for you in an agile way.
We had a case where a particular DML command could not perform the required update command on a table, and in this case we saw, within a few minutes, that we had another session doing an exclusive lock on the table. It was caused by an index rebuild command without the "online" option, that marked it to be rotated daily.
I believe that one of the most valuable resources this tool has is the ability to check offending processes, which are burdening the hardware resources, and to generate advice quickly that can improve a query's performance.
Another feature is the Resource Manager, where we can manage the consumption of resources of certain queries, separately in resource groups. Depending on the characteristics of the query, queries can be placed in groups that consume less database and hardware resources.
There are others features as well, such as AWS and ASH report which, in Enterprise Manager, are generated in a more agile way, and with a more friendly interface, helping to detect abnormalities in the database.
One of the things that can be improved is the quality of results generated by BI Publisher. They are somewhat confusing when it comes to analysis.
Another point is in the installation of the product. The installation steps are very complex and the documentation for them is very generic and does not make very clear the correct steps from the installation to the addition of the host and database.
Another point that can be improved is the agent instability in the monitored hosts, because sometimes an agent has to be resynchronized to recapture the information.
More than five years.