Re: Views for Getting General Stats Out of the DB

From: Richard Foote <Richard.Foote_at_oracle.com>
Date: Tue, 06 Aug 2002 09:33:34 +1000
Message-ID: <3D4F0B4E.7F0D74E4@oracle.com>

Hi Sybrand and all,

My apologies. I didn't even notice I was doing it (long story) !!

Regards

Richard
Sybrand Bakker wrote:
>
> On Mon, 05 Aug 2002 23:44:03 +1000, Richard Foote
> <Richard.Foote_at_oracle.com> wrote:
>
> ><!doctype html public "-//w3c//dtd html 4.0 transitional//en">
> ><html>
> >Hi Simon,
> >Basically, yes, there are a huge bunch of DD and V$ views you need to
> >look at to answer your questions Check out the Reference Manual (which
> >you can find by either checking out tahiti.oracle.cm or otn.oracle.com).
> >It contains a full list of the DD views and the v$ dynamic performance
> >views which describes all the views you are after.
> >While you're there, look at the Oracle Supplied PL/SQL packages manual
> >and check out the dbms.logmnr package that allows you to read inside the
> >redo logs. The Concepts and Administration guides also have much useful
> >info on Log Miner.
> >Good Luck
> >Richard
> >Simon Harvey wrote:
> ><blockquote TYPE=CITE>Hi,
> >I'm writting an app for my Final Year project at university that will
> >keep
> > tabs on an oracle database. It's going to do this by running queries
> >on the
> > data dictionary at specific intervals.
> >What I was wondering is what dictionary views display details such as:
> >a. How many users logged in
> > b. How much room the entire database is using
> > c. How much space specific users are using with there schema
> >and so on and so forth. Is there a view that tells you very general
> > management statistics like that or are they all distributed all over
> >the
> > place.
> >I was also wanting to do some analysis of the logs that oracle keeps.
> >Is
> > there a way to access these logs? Are they kept as plain text someplace
> >and
> > where might that be?
> >Kindest thanks to you all for making this place such an amazing resource.
> >I
> > don't know to much about oracle but I'm off to try and help some guys
> >in the
> > java groups.
> >Take care
> >Simon</blockquote>
> ></html>
>
> Please do NOT post in HTML, many newsreaders can not read it.
>
> Regards
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address

text/x-vcard attachment: Card for Richard Foote

Received on Mon Aug 05 2002 - 18:33:34 CDT