IOUG Collaborate 2015 Webinar with Chuck Ezell on Oracle Health Checks
John Kaufling | | March 12, 2015
With the heavy workload that most, if not all, DBAs face, it’s no wonder there is little time left to perform routine health checks. Below are details of a webinar we ran with IOUG Collaborate 2015 — a presentation of the Independent Oracle Users Group. Presenter Chuck Ezell discussed the real value of health checks, based on the thousands of them performed Datavail clients.
Among other things Chuck covered in his presentation is the Datavail 5S Approach to proactive database maintenance:
These five areas help organize the tuning approach and define the major concerns beyond the architecture, setup, and data model. They also address how performance tuning becomes less of a mystery if it can be measured, documented, affected, and improved.
Why do performance tuning? Chuck says that 80% of unplanned outages are due to ill-planned changes made by operations or developers. Sixty percent of availability and performance errors are the result of misconfigurations. You can learn about the 5S approach in more detail in the white paper, The 5S Approach to Improving Database Performance.
Beyond the 5S approach, Chuck will look at such database problem areas as:
- Drive speeds
- Operating System Parameters
- Application Details
- Database Parameters
- Instance Details
- Table Space Naming
- Redo/Undo Log: Sizing and Frequency
- I/O Waits
- And more.
Here’s an example of some of the diagnostics Datavail looks at when tuning a database.
Watch the SlideShare, Optimizing Alert Monitoring with Oracle Enterprise Manager to find out how OEM Grid configuration using Datavail’s Alert Optimizer™ and custom templates helps eliminate unwanted alerts, while enriching actionable alerts, and improving the performance of the entire database system.
About Chuck Ezell:
Chuck supports some of the world’s largest retailers with database performance tuning for their internal applications. Chuck helps Datavail locate and eliminate bottlenecks in database administration, while uncovering opportunities to improve performance.
He excels at optimizing and customizing EBS systems. Chuck works with Java, SQL, .NET, and other languages on systems by Oracle, HP, IBM, among others. He uses AppDynamics, Splunk and Visual VM, along with other tools, for database tuning operations.
Contact Datavail for more information on how we might best support you and your organization with custom solutions tailored to your needs.
Subscribe to Our Blog
Never miss a post! Stay up to date with the latest database, application and analytics tips and news. Delivered in a handy bi-weekly update straight to your inbox. You can unsubscribe at any time.
The “ORA-12154: TNS:could not resolve the connect identifier specified” Oracle error is a commonly seen message for database administrators.
EPM applications help measure the business performance. This post will help you choose the best EPM solutions for your organization’s needs and objectives.