Re: Getting interesting info about an Oracle instance

"Simon Harvey" <ReplyToGroup_at_thanks.com> wrote in message news:<nM9u9.7022$Ai6.248000_at_stones>...
> 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.
>
> 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.
>
> 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?
>
> My sincerest thanks to anyone who can offer some advice on this matter.
>
> Take Care All
>
> Simon Harvey

If you have Oracle Support, go to metalink.oracle.com and search for TFTS. A bunch of interesting things, much of it obsolete and crying for update to usefulness.

PL/SQL is neither the best nor the only way to detect things in the database, but I think most people would recommend it. Depending on your definition of best, of course. Probably the largest determinant is whether you want to be able to use it for other than Oracle databases, followed by what skills you want to develop. I saw something once written in Perl that was pretty k001. You could also do something shellish like Big Brother and have it use plain SQL for the db parts.

jg

--
@home is bogus.
http://dbi.perl.org/
http://bb4.com/
http://search.cpan.org/author/SHULL/karma100/