Oracle Performance Diagnostic Guide

Welcome to the Oracle Performance Diagnostic Guide This guide is intended to help you resolve query tuning, hang/locking, and slow database issues. The guide is not an automated tool but rather seeks to show methodologies, techniques, common causes, and solutions to performance problems.

Most of the guide is finished but a few areas are still under development. We are working to complete the entire guide by March 20010.

Your feedback is very valuable to us - please email your comments to: Vickie.Carbonneau@oracle.com

Tool usage is discussed on the home page of the Performance Diagnostic Guide.

Click here to access the Performance Diagnostic Guide (Currenty works with Internet Explorer only)

NOTE: Loading the Performance Diagnostic Guide can take several minutes. Once the data is loaded, navigation within the guide will be quick.

The Oracle Performance Diagnostic Guide is now available in a pdf and html format. Due to size, the guide has been split into three documents: Query Tuning; Hang/Locking; and Slow Performance. Click below to view and download the portion of the Oracle Performance Diagnostic Guide in the format of your choice.

	pdf Version	html Version
Query Tuning	Click Here	Click Here
Hang/Locking	Click Here	Click Here
Slow Performance	Click Here	Click Here

Credits

Technical Content: Hector Pujol, Roderick Manalac, Steve Dixon, and various others who authored content on MetaLink		>
Developer: Vickie Carbonneau
Contributors: Alvaro Corena, Carl Davis, Steve Franchi, Dennis Pitman
Design and Content Reviewers: Jan Boonen, James Cremonini, Steve Dixon, Jeff Gregory, Andrew Hambelton, Alex Melidis

Feedback

We look forward to your feedback. Please email any comments, suggestion to help improve this guide, or any issues that you have encountered with the tool usage toVickie.Carbonneau@oracle.com.

Oracle Performance Diagnostic Guide (OPDG) [ID 390374.1]

附件