Databases Reference
In-Depth Information
B
A Summary of Oracle
Packages Used for
Performance Tuning
In this topic we have used various Oracle tools and packages to investigate and solve
performance issues.
There are also many tools in the market, made by third-party
software vendors, which can help DBAs and developers in
many fields, from coding PL/SQL packages and procedures
to analyzing data warehouses or tuning the database I/O.
In this appendix we present a brief summary of these packages, providing a small reference
from which we can start when we want to solve a performance problem. The packages are
presented in alphabetical order.
DBMS_ADDM
This package provides procedures to manage Oracle Automatic Database Diagnostic Monitor.
