The RECOMMEND_MV procedure creates a table of recommended materialized views based on the statistics for the database collected with the ANALYZE command
The RECOMMEND_MV_W procedure creates a table of recommended materialized views based on the statistics for the database collected with the ANALYZE command and the specific workload for the database gathered in a trace file
The REFRESH_ALL_MVIEWS procedure refreshes all materialized views that need refreshing
The REFRESH_DEPENDENT procedure refreshes all materialized views in the databsae that need refreshing and that are based on a particular base table
