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 -> Views for Getting General Stats Out of the DB

Views for Getting General Stats Out of the DB

From: Simon Harvey <noThanks_at_pdf.com>
Date: Mon, 5 Aug 2002 12:09:07 +0100
Message-ID: <3d4e5cd3_17@news.teranews.com>


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:

  1. How many users logged in
  2. How much room the entire database is using
  3. 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 Received on Mon Aug 05 2002 - 06:09:07 CDT

Original text of this message

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