OEM gives me, as the DBA, a very graphical representation of what's going on with my Oracle footprint, and it's very quick to display to me where I would have issues and where I can correct them. This gives me the capability to see when there are issues happening, which means that I can actually act on the issues pretty quickly before it becomes apparent to the business that there is something going on within the database, that could, for example, have a negative effect on their ability to get a drug out the door.
Improvements to My Organization:
From my point of view, I've found OEM to be one of the easier products to deal with. It's the product that I use day in daily to view all of my databases, and the fact that I can actually integrate multiple databases and multiple middleware solutions into one single point is perfect for me, so I'm really happy with it.
Room for Improvement:
The features that I'd want to use in Enterprise Manager would be in and around the diagnostics and tuning area of the database. Again, that is an additional license. Whilst I can get Enterprise Manager, I can do certain things with it, the really, really high-value part of Enterprise Manager requires additional licenses. So I'd like to see more advanced functionalities that, frankly, don't require us to spend more money.
We've had no issues with deploying it.
It's been very stable. I don't recall any big issues with stability.
We've been able to scale it as needed.
It was a very, very complicated product to set up. We initially used it with Oracle Single Sign-On to link Microsoft Active Directory to our E-Business Suite instance. It was difficult to set up, and actually now we've migrated to Oracle Access Manager with Identity Manager, and it's even more complicated.
Oracle Access Manager is a product that Oracle has brought in. They've took over a company which had their own identity management solution. They took it over and re-labelled it, re-branded it to be their product. We had a few enhancements in it, but when they released it is was absolutely full of bugs, and, actually really, really complicated to set up.
Later releases and scripts is what have made it a little bit easier, but I would like Oracle before they put these products out to the market, to invest some time in making them easier to set up.
We implemented it with our in-house team.
Read the documentation, because we found and still find it extremely complicated to bind the latest versions of the database into Enterprise Manager. It was much easier in earlier versions, but much more complicated now.