Select Page

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:

5S Approach to Improving Database Performance

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.

5S Approach to Improving Database Performance

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.

If you are interested in learning more about Datavail, please visit our blog as well as our latest post about Oracle – Oracle Secure Backups to S3 on 10g.

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.

How to Solve the Oracle Error ORA-12154: TNS:could not resolve the connect identifier specified

The “ORA-12154: TNS:could not resolve the connect identifier specified” Oracle error is a commonly seen message for database administrators.

Vijay Muthu | February 4, 2021

Best RAID For SQL Server | RAID 0, RAID 1, RAID 5, RAID 10

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.

Eric Russo | June 8, 2015

How to Recover a Table from an Oracle 12c RMAN Backup

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.

Megan Elphingstone | February 2, 2017

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.

Work with Us

Let’s have a conversation about what you need to succeed and how we can help get you there.

CONTACT US

Work for Us

Where do you want to take your career? Explore exciting opportunities to join our team.

EXPLORE JOBS