Re: Oracle Health & Statistics

On Apr 5, 3:43 pm, "Bobby" <bobby.ow..._at_talktalk.net> wrote:
> On 5 Apr, 14:38, "gazzag" <gar..._at_jamms.org> wrote:
>
>
>
>
>
> > On 5 Apr, 14:30, "Bobby" <bobby.ow..._at_talktalk.net> wrote:
>
> > > Hi,
>
> > > Yes, I know you're probably all fed up of newbie questions and
> > > vagueness regarding checking health of an Oracle server/database. But
> > > hopefully you'll forgive me for this one.
>
> > > I've been tasked with writing a generic component for doing an "Oracle
> > > Health Check" as well as a "SQL Server Health Check". The purpose of
> > > this is to add to our SLA system so that DBAs are informed when there
> > > are performance issues, or other "potential" problems. I am fine with
> > > SQL Server as i am very familiar with it, but have only just started
> > > looking at Oracle.
>
> > > Yes, this is very vague also and I apologise. I've looked through
> > > various documentation and there seems to be an overwhelming amount of
> > > information in places such as v$stat, v$lock. Loads of information
> > > regarding cache hit ratios, CPU time, etc.
>
> > > What i've decided to to is ask all of you expert DBAs in this posting
> > > for a recommendation of the top (possibly about 5 to 10) most common
> > > and useful stats/performance checks I can do on an Oracle database (or
> > > server). This will be generic as we cannot really build in
> > > functionality for all database schemas, usages, etc. Could anyone
> > > possibly let me know which figures may be useful in most installations
> > > of Oracle.
>
> > > Many thanks in advance.
>
> > > Regards
>
> > > Bobby
>
> > Why didn't the person who has tasked you with this work spoken to the
> > Oracle DBA's themselves? The best person to monitor your Oracle
> > databases would be the DBA's. I'd suggest that they have the tools
> > and ability to do this.
>
> > HTH
>
> > -g- Hide quoted text -
>
> > - Show quoted text -
>
> Hi,
>
> We don't have any Oracle DBAs. Some of our customer use Oracle backend
> databases for certain applications, but again do not have DBAs onsite.
> By us implementing this feature in our software, we can alert certain
> people within their company before problems arise and users start to
> suffer. I know this doesn't sound an ideal scenario, but thats why I
> thought it best to ask the oracle experts in their own news groups
>
> Regards
>
> Bobby- Hide quoted text -
>
> - Show quoted text -

I like this approach. You sell a product, probably database neutral, you don't have any Oracle DBAs (you want to build something, not using any of the many products already available, which you obviously don't know), and now you come here for *free* advice on reinventing the wheel.
Software vendors get more and more lack of scruples nowadays! If you don't have any inhouse Oracle knowledge I would recommend hiring a consultant, instead of misusing this newsgroup.

--
Sybrand Bakker
Senior Oracle DBA