Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: DB statistics using stored procedure?

Re: DB statistics using stored procedure?

From: Chetan Wagle <chetanw_at_yahoo.com>
Date: Thu, 23 Sep 1999 10:57:43 +0530
Message-ID: <7scdlq$8fq$1@herald.ctp.com>


Hi,

   Also go and check out Oracle's UTLBSTAT/UTLESTAT utilities.

HTH,
Chetan
Bangalore, India

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.
Received on Thu Sep 23 1999 - 00:27:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US