RDBPROD: Collecting performance data for analyzing performance issues (Doc ID 1908668.1)

Last updated on APRIL 16, 2024

Applies to:

Goal

When a query against an Oracle Rdb database takes much longer than expected, or a query which previously had a short response time now performs badly, it is important to collect data for further analysis.

Required items are:

• Strategy
• Cardinality of referenced table(s)
• Results of the query (Execution time); good example and bad example

Solution

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