Re: Good Performance Issue to consider. Suggestions welcome

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Tue, 10 Aug 1999 20:07:19 +0200
Message-ID: <934308449.16135.0.pluto.d4ee154e@news.demon.nl>

Hi Tapan,
Usually saturation of the server is caused by a) DBWR and LGWR problems: the server becoming I/O bound b) excessive paging and swapping.

Question: what are those processes doing. Could you snoop into to sql area, or v$open_cursor. You might consider to get Toad and use that against those session, it has a trace optimization option which will shouw you how much resources are being used. It will also show your the basic sanity of your system in the option server stats.

Hth,

Sybrand Bakker, Oracle DBA

Tapan Trivedi <tapan.trivedi_at_abbnm.com> wrote in message news:37B02D9D.B0488147_at_abbnm.com...
> Hey Gurus,
> I have a problem where during heavy updates, insert statements the
> CPU usage on the Digital UNIX system that we have Oracle 7.3 on
> increases very much. Just two processes the sqlplus session and the
> SNAP replication process use up about 50 % of the CPU , which makes the
> other application users scream. I was wondering as to what might be the
> cause of the same. Does anybody have an idea ? Any comments,
> suggestions, experiences are welcome.
>
> Thanks a lot
>
> Tapan
Received on Tue Aug 10 1999 - 13:07:19 CDT