Re: DB statistics using stored procedure?

Rachel,

Expanding on the other responses, the statistics of an oracle database is located in the v$.. tables from the data dictionary. However, to place the pertinent information there, you need to run scripts that will gather the info and place it in the tables which you will later query.

The scripts will compute or estimate statistics in an object, schema or the whole database. For the last two, you run it the following way:

From sqlplus, do:
execute dbms_utility.analyze_schema('username', 'compute or estimate');
or
execute dbms_utility.analyze_database('compute or estimate');  

Compute takes more time than estimate, but it is more accurate. Try login in as sys or other power user when analyzing the database. Hope it helps.

Dave Received on Sat Sep 25 1999 - 00:17:16 CDT