Oracle Enterprise Manager Grid Control
EM can automatically connect to Metalink to check for required patches for each target database and download them to a software library.
Over the next few months I will add monitoring, alerts, admin accounts, developer user accounts (so they can get their own ADDM (statspack) results), and groups. I will also work to add every db to the Grid.
This is just the start. EM is pretty cool and I expect we will be able to:
* Increase uptime and proactive management
* Automate the instance reporting (for licensing contract purposes)
* Improve general and custom reporting for all instances
* Centralize much of the management
* Compare database settings and schemas between two databases or between a stored baseline and any database
* Create new users in multiple databases using any other user as a starting template
* Handle configuration management
* Assist with change control
* Keep configuration histories
* Make it simple to answer questions like:
o “What was the database doing yesterday at 2:22PM?”
o “When was this database last backed up?”
o “Are their any blocking locks?”
o “What are the top SQL queries?”, “What are the top five wait events?”
o “What hosts are connected to my database?” (i.e. are development boxed connecting to production databases)
o “What is the explain plan for this query?”
* Job queuing and command execution library
More to follow…
-Rick
