Explain The Major Functions Provided By The Dbms_stats Procedure?

1.	Explain The Major Functions Provided By The Dbms_stats Procedure?
Answer» The dbms_stats procedure performs the FOLLOWING general FUNCTIONS: Set or get STATISTICS using the set_xxx and get_xxx subprograms. Transfer statistics using the export_xxx and import_xxx subprograms. GATHER optimizer statistics using the gather_xxx subprograms. The dbms_stats procedure performs the following general functions:

Answer»

The dbms_stats procedure performs the FOLLOWING general FUNCTIONS:

The dbms_stats procedure performs the following general functions:

Discussion