I am part of Enterprise Database Operations for NetApp IT. We are a team of Oracle database administrators (DBAs) managing a large conglomeration of new and old Oracle databases supporting our global business applications. Just like any other group of Oracle DBAs in any other Oracle shop anywhere in the world, we face the same day-to-day issues and problems and triumphs as everyone else.


As an Oracle Database Administrator, I need to have complete control of my entire environment, especially when it comes to data storage. If you’ve worked as a DBA for a long time, you probably experienced difficulty getting proper visibility and access into performance and capacity metrics of your storage systems without having to constantly engage storage administrators to retrieve the required information. I know this segregation of duties has created some lively discussions for me because unless I have full access, I will never feel completely secure about my environment.


Inspector.jpgRecently, we started implementing a new tool in our OEM arsenal, the NetApp Storage System Plug-In for OEM. The proclamation that this new capability as one of the best things since sliced bread for the DBA crowd is true.


Like most Oracle DBAs, we use Oracle Enterprise Manager (OEM) 12c to help us manage our databases. We spent a long time and took great care in implementing alerts and templates while organizing our databases within OEM to make our lives easier as administrators. This has been very successful and has really improved our ability to provide consistent support across our database universe.


Because the NetApp plug-in is an extension to OEM, it is able to tap into and enhance OEM’s capabilities of gathering comprehensive performance, configuration, and availability information. For those familiar with NetApp solutions, this means that the plug-in can monitor and provide information about our 7-mode storage, storage virtual machines, and clustered storage systems.


Oracle DB.jpgAs DBAs, we can now use OEM to access in-depth information about the NetApp storage underlying our Oracle databases. Where previously we had to log into each individual Oracle database server and storage controller to retrieve performance and capacity information, we can now point-and click our way to detailed storage information without ever leaving our OEM home base.


It is one thing to “know” that storage affects our databases?it’s an entirely different (and better) thing to be able to see and report on the current storage metrics. My two favorite features are the consolidated storage/performance views and the consolidated database/performance views. Check it out and let me know what you think in the comments section.


I may not have complete control over my entire dominion quite yet, but I now feel more secure that I have the information to do my job effectively.


The NetApp-on-NetApp blog series features advice from subject matter experts from NetApp IT who share their real-world experiences using NetApp’s industry-leading storage solutions to support business goals. Want to view learn more about the program? Visit www.NetAppIT.com.