DB statistics using stored procedure?
From: <rachael_at_LakesideSoftware.com>
Date: Wed, 22 Sep 1999 17:35:06 GMT
Message-ID: <7sb409$j9p$1_at_nnrp1.deja.com>
[Quoted] [Quoted] 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.
Date: Wed, 22 Sep 1999 17:35:06 GMT
Message-ID: <7sb409$j9p$1_at_nnrp1.deja.com>
[Quoted] [Quoted] 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 - 19:35:06 CEST