DB statistics using stored procedure?

From: <rachael_at_LakesideSoftware.com>
Date: Wed, 22 Sep 1999 17:35:06 GMT
Message-ID: <7sb409$j9p$1@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. Received on Wed Sep 22 1999 - 12:35:06 CDT