A Summary of Oracle Packages Used for Performance Tuning - Oracle Database 11gR2 Performance Tuning - page 499

DBMS_SPACE
This package enables the analysis of segment growth and space requirements.
Procedures
The most relevant procedures are:
F CREATE_TABLE_COST : determines the size of a table
F CREATE_INDEX_COST : determines the size of an index
F FREE_BLOCKS : returns information about free blocks in an object
F SPACE_USAGE : returns information about free blocks in a segment
managed by automatic space management
DBMS_SPM
This package provides an interface to manipulate plan history and SQL plan baselines.
Procedures
The most relevant procedures are:
F LOAD_PLANS_FROM_CURSOR_CACHE : loads one or more plans from
the cursor cache for a SQL statement
F LOAD_PLANS_FROM_SQLSET : loads plans stored in a SQL tuning set into
SQL plan baselines
F EVOLVE_SQL_PLAN_BASELINE : evolves SQL plan baselines associated with
one or more SQL statements, changing them to accepted if they are found to be
better than the SQL plan baseline performance and if the user asks such action
F DROP_SQL_PLAN_BASELINE : drops a single plan or all the plans associated
with a SQL statement
DBMS_SQL
This package provides an interface to use dynamic SQL to parse both DML and DDL
statements using PL/SQL.