Re: Performance degradation

Just a thought...

Myabe your problem is not related to Oracle but Solaris 2.6. I had similar problems when I upgraded to Solaris 2.6 because I didn't install one of their patches (105181-09). This patch "supposedly" fixes a myriad of bugs relating to the kernel, paging, and the socket layer. It caused my system to randomly hang with telnet sessions and SQLNET connections (anything tcp/ip related). After installing the patch, my machine seems to work much better.

You can do a quick test to see if you have the patch installed. If you type "netstat -i" and you see an unusually high number of input packet errors being reported, you're not running the patch.

Also, if you are using SUNSWIFT adapters (hme drivers), you may want to patch this as well (patch 105795-05).

Steven Kang
Eryx Corp.
skang_at_eryx.com

abeal_at_us.ibm.com wrote:
>
> 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 Sat Nov 07 1998 - 16:28:32 CST