Re: Views for Getting General Stats Out of the DB

"Simon Harvey" <noThanks_at_pdf.com> wrote in message news:3d4e5cd3_17_at_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:
>
> a. How many users logged in

V$SESSION
> b. How much room the entire database is using

Interesting question. I suspect a union of dba_data_files and dba_temp_files. But the question needs defining some more.

> c. How much space specific users are using with there schema

their/there yuk! dba_extents might be useful.

>
> 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.

in general all over the place (or as the designers would no doubt put it) where needed.

>
> 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?

plain text files in various dump_dest locations or else places defined in the network configuration files.

>
> 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.

double espresso for me, or did you have some other java in mind?

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************