Re: performance monitoring

tony_barratt_at_hotmail.com (tony) wrote in message news:<a3a05820.0107110114.10679427_at_posting.google.com>...
> Hi List,
> I posted a message to comp.unix.solaris enquiring about monitoring for
> Solaris 7. The response suggested that Oracle itself can do some
> reporting on performance issues, which is good because monitoring of
> the db is also required.
> Could someone please supply an URL which would help me arrange some
> monitoring for 8.1.6?
>
> TIA
>
> Tony
>
>
> > Hi List,
> >
> > I've got a requirement to monitor a E220 with Solaris 7 and Oracle and
> > others like it. More specifically what needs monitoring is:
> > Disk usage, mem usage, CPU, read/write hard drive, network i/o,
> > database performance. Some sort event needs generating when a threshold
> > for each of the parameters above is exceeded.
> > Is there any freeware stuff that will do this?
> > I know about Big Brother, but I don't think a C compiler will be
> > allowed.
> >
> > TIA
> >
> > Tony
>
> tony-
>
> doesn't oracle have administration software monitoring the databases?

Tony, your question is very broad. The Oracle Performance and Tuning manual is full of queries you can run to monitor specific areas of the database and Oracle provides a base GUI tool, OEM, to manage and monitor the database with. The 8.1 version of Oracle includes the statspack which can be used to monitor internal performance. Several third party vendors, Platinum Software, Precise Software offer tools for monitoring the Oracle db. Some of these third party tools support paging on problem determination.

But what you need depends on what it is you really need to monitor and how much money you can afford to spend on the effort. You might want to be more specific about what you are looking for, say performance trends vs system crashes.

• Mark D Powell --