Re: Getting interesting info about an Oracle instance

Simon Harvey wrote:
> Hi all,
>
> Ihope someone will be able to help with this one as I'm still a bit scared
> of oracle!!
>
> I'm doing a project for my final year at university that will create a tool
> like toad, that can alert dba's of problems with the database. But I dont
> know what tables to monitor!
>
> Could anyone suggest the names of some tables that will give me interesting
> facts about the datasbase.Nothing fancy.
>

Look in the Oracle docs at the information found in the 'V$' tables (as they're often referred to). That's where you'll find stuff related to Oracle's performance and all. You can find the doc set at http://tahiti.oracle.com/pls/tahiti/tahiti.show_mindex?letter=V (hope that doesn't word wrap).

> Perhaps the current number of logins, the load on the processor or system in
> general. I suppose you clever oracle types would be able to tell me we what
> sort of things you would find useful from a tool like thins. I'm also hoping
> to aloow the user to enter his or her own sql so that he or she isnt limited
> by the the functions i provide.
>

Well now, the load on the processor is something you'll more likely get from the O/S. I'd like to see a tool that any user could run that would tell them in layman's terms why the system is so slow. But hey, you did say this was just a university project ... not a lifetime pursuit.

> Another thing I'm wondering is, is PL/SQL the best (and only) way to detect
> events or warnign levels in the database? Can anyone think of a better
> solution?
>

Well, the answer to that question depends on my own preferences (and you're very unlikely to get a general consensus). PL/SQL is a great tool ... I use it all the time ... but is it the best? I can't tell you how many computer languages have been invented, each professing to be an improvement over some other language.

> My sincerest thanks to anyone who can offer some advice on this matter.
>
> Take Care All
>
> Simon Harvey
>
Received on Fri Oct 25 2002 - 11:07:11 CDT