IOUG Collaborate 2015 Webinar with Chuck Ezell on Oracle Health Checks
Author: 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.
The “ORA-12154: TNS:could not resolve the connect identifier specified” Oracle error is a commonly seen message for database administrators.
Which RAID should you use with SQL Server? Learn the differences between RAID 0, RAID 1, RAID 5, and RAID 10, along with best practices.
Our database experts explain how to recover and restore a table from an Oracle 12c RMAN Backup with this step-by-step blog. Read more.