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.
Scope
This document is intended to advise database users on proactive best practices for the collection of diagnostic performance data
Details
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!