Oracle’s dbms_utility package contains a lot of neat functionality for the database developer. Today we?re going to look at the analyze_schema procedure. The analyze_schema procedure can be used to generate statistics for Oracle’s cost-based optimizer. The parameters are: Procedure analyze_schema