Re: Q: Top 10 Issues to Monitor in Oracle Environment!

Kalle <kminerva_at_jippii.fi> wrote in message news:<3D9A7CE2.EA718107_at_jippii.fi>...
> Hi all,
>
> I need to "list" top 10 issues need to monitor in Oracle Environment...
>
> Do you have any idea, I know this quite general question, but I hope
> your comments!
>
> TIA
> Kalle

Kalle, I believe that the top 10 items that need monitoring varies by DB based on the applications being supported and on existing resource constraints (CPU, memory, and disk) if any.

The one universal item is the amount of free space available to be used by objects. If you use LMT with uniform extents this is very easy to monitor. How easy managing space is depends on availability and the existing physical layout.

Other items to be considered are sort area in use (temporary tablespace) and rollback segment space usage.

It can be worthwile to examine the SQL cache and look for nearly identical SQL statements that could be shared with minor modifications and the heavy hitters (logical and physical IO) to see if they have changed.

For just about everything else I would look at the statspack reports.

IMHO -- Mark D Powell -- Received on Wed Oct 02 2002 - 09:16:06 CDT