Re: DB statistics using stored procedure?

rachael_at_LakesideSoftware.com wrote in message <7sb409$j9p$1_at_nnrp1.deja.com>...
>Are there any builtin stored procedures that come with Oracle (on NT)
>that return statistics about a database? For example, SQL Server has
>various stored procedures (like sp_configure, sp_helpdb, sp_helpdevice,
>etc.) that return database/device/logfile size, database options that
>are set, etc. If not, are there any tables that contain this
>information that can be queried with a SQL call? We'd like to retrieve
>this information from a client application written in Visual Basic
>through and ODBC SQL call.
>
>Please respond via e-mail if possible.
>
>Thanks!
>
>Rachael
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.

Most of Oracle's statistics can be found in the V$ tables described in the SQL
Quick reference guide and elsewhere. Some statistics can also be found looking
at the DBA_ data dictionary views. You might want to look at the DBMS_UTILITY
package and the ANALYZE_SCHEMA function to generate some statistics for a given
schema - you also need to do this to keep your cost-based optimizer running at
peak performance.

Hopefully some of that was useful.

Good luck

Graham

--
Empowerment - delegating the responsibility but not the authority.

Opinions expressed do not necessarily reflect those of Abbott Laboratories .

--
Empowerment - delegating the responsibility but not the authority.

Opinions expressed do not necessarily reflect those of Abbott Laboratories. Received on Wed Sep 22 1999 - 14:16:12 CDT