My Oracle Support Banner

Restoration Procedure for Statement/Batch Performance Issues in Oracle Database Machine / Exadata (Doc ID 1476710.1)

Last updated on JANUARY 17, 2020

Applies to:

Oracle Exadata Hardware - Version 11.1.0.7 and later
Information in this document applies to any platform.

Purpose

 This article provides the direction and steps to achieve the fastest possible restoration of service and subsequent root cause analysis when a Performance Issue has been discovered in a Business Critical SQL Statement or Batch process in Engineered systems that include RDBMS Compute Nodes and Exadata Cells.

Troubleshooting Steps

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Purpose
Troubleshooting Steps
 Prerequisites
 I. Restoration for a batch process
 II. Restoration for a particular slow statement
 III. Diagnostics Collection
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.