Re: Performance degradation

From: <satar_at_my-dejanews.com>
Date: Thu, 05 Nov 1998 19:35:30 GMT
Message-ID: <71sum2$4a3$1@nnrp1.dejanews.com>

Very Interesting enviroment to have 1100 concurrent users. Anyway, I read your reply to another post...In your situation I will be running in MTS mode.

Good Luck,
Satar

In article <m190hqxvbc.fsf_at_klondike.tiani.com>, Juergen Gmeiner <jg_at_tiani.com> wrote:
> abeal_at_us.ibm.com writes:
>
> > 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.
>

Oracle DBA/UNIX System Admin
Advanced Enterprise Solutions
(949) 756-0588
Oracle Re-Seller

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Nov 05 1998 - 13:35:30 CST