Re: Performance degradation

Hi:

Just a thought, here. High variability in response times usually indicates a general level bottleneck. Things to check would be: SGA hit ratios, O/S paging, disk workload (ie. reads or writes/sec), CPU utilization, rollback contention, redo buffer contention, redo log disk hot-spot, checkpoints/logswitch, freelist contention, and all the myriad other latch contentions.

Good luck.

--
David C. Sisk
http://www.ipass.net/~davesisk/ORACLEonNT.htm

abeal_at_us.ibm.com wrote in message <71qmcc$66r$1_at_nnrp1.dejanews.com>...
>We have an Oracle database running on Solaris 2.6 using Oracle 7.3.3 with
>typically 1100 concurrent connections many of which are idle most of the
>time. However, recently we started experiencing severe database
degradation
>where the database slows to a crawl. One of the DBA was able to observe a
>high number of enqueues, library cache latches, and high number of shared
>pool latches. When the degradation happens, it is usually so severe that
>they have to shutdown the database and restart it.
>
>I have a lot of posts in this newsgroup with similiar problems, and I would
>like to hear suggestions of things to look at or things to try.
>
>alan
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Thu Nov 05 1998 - 18:34:51 CST