Best Practices: Proactive Data Collection for Performance Issues (Doc ID 1477599.1)

Last updated on MARCH 25, 2021

Applies to:

Oracle Database - Standard Edition - Version 10.1.0.2 and later
Oracle Database - Enterprise Edition - Version 10.1.0.2 and later
Oracle Database - Personal Edition - Version 10.1.0.2 and later
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Information in this document applies to any platform.

Purpose

This document describes a best practice methodology to ensure that sufficient performance data is pro-actively gathered enough at first occurrence of the problem to enable effective root cause determination. It can be used alongside the following document to both attempt to avoid problems and then if that is unavoidable, collect the information required for a quick diagnosis:

<Document 1482811.1> Best Practices: Proactively Avoiding Database and Query Performance issues

NOTE: These recommendations are best practices that apply to the MAJORITY of scenarios encountered by support. Each issue is different and specific additional diagnostic may be required in some circumstances to completely achieve a root cause diagnosis. It is not necessarily feasible to collect this targeted information up front for every issue since specific diagnostics required to resolve one particular issue may not be relevant in all cases. The goal is to provide a solid starting point that will collect enough for most issues to be resolved or to enable prompt recommendations for further tracing.

Ask Questions, Get Help, And Share Your Experiences With This Article

Would you like to explore this topic further with other Oracle Customers, Oracle Employees, and Industry Experts?

Click here to join the discussion where you can ask questions, get help from others, and share your experiences with this specific article.
Discover discussions about other articles and helpful subjects by clicking here to access the main My Oracle Support Community page for Database Tuning.