RDBPROD: Collecting performance data for analyzing performance issues
(Doc ID 1908668.1)
Last updated on FEBRUARY 05, 2020
Applies to:Oracle Rdb Server on OpenVMS - Version 7.2 and later
HP OpenVMS Alpha
HP OpenVMS Itanium
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:
- Cardinality of referenced table(s)
- Results of the query (Execution time); good example and bad example
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