Reverse Engineering a Resource Manager Plan From Within the Database
(Doc ID 1388634.1)
Last updated on SEPTEMBER 17, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 10.1.0.2 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
Goal
The provided scripts use the data stored in the data dictionary to re-construct a given resource manager plan. You can use this to reverse engineer all your resource manager components for
recreation or transport. At the same time it is an example on how to use the DBMS_METADATA package for the resource manager components.
Solution
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
| Goal |
| Solution |
| Requirements |
| Configuring |
| Instructions |
| Script |
| Sample Output |
| References |