Provides access to some SQL Data Definition Language (DDL) statements
from a stored procedure. It also provides special admin operations that are
not available as DDLs.
The ALTER_COMPILE and ANALYZE_OBJECT procedures commit the current transaction, perform the operation, and then commit again. This package runs with the privileges of calling user, rather than the package owner SYS.
Subprocedures: ALTER_COMPILE Compile the PL/SQL object. ANALYZE_OBJECT Provide statistics for the database object.
For full documentation of the packaged procedures above see the Oracle Manual:
"Oracle9i Supplied PL/SQL Packages and Types Reference"
or the book Oracle Built in Packages by Steven Feuerstein et al
DBMS_UTILITY - Utility routines,
ANALYZE - Analyse Table | Index
INDEX_STATS DBA_PART_COL_STATISTICS ALL_PART_COL_STATISTICS USER_PART_COL_STATISTICS DBA_TAB_COL_STATISTICS ALL_TAB_COL_STATISTICS USER_TAB_COL_STATISTICS DBA_USTATS ALL_USTATS USER_USTATS