Re: How to detect memory leaks
From: andrew_webby at hotmail <andrew_webby_at_hotmail.com>
Date: 4 Sep 2001 03:42:31 -0700
Message-ID: <f45d9b0.0109040242.59f9e4eb_at_posting.google.com>
Date: 4 Sep 2001 03:42:31 -0700
Message-ID: <f45d9b0.0109040242.59f9e4eb_at_posting.google.com>
vissuyk_at_yahoo.com (Vissu) wrote in message news:<2bedd6a7.0108290909.3d7ed044_at_posting.google.com>...
> We suspect that Oracle is leaking memory. How can we prove it ?. We
> have buffer cache, shared pool size, etc set to very high values. When
> we add these memory settings shouldn't it be equal to or less than the
> RAM available to avoid swapping ? The OS is Solaris and Oracle is
> 806.
>
> Any help will be appreciated.
>
> Vissu
It sounds more like you have so much memory set for oracle that the moment a client connects, you immediately start paging.
Bad.
Set it to a lot less than max available RAM. A read of the documentation wouldn't go amiss either. Received on Tue Sep 04 2001 - 12:42:31 CEST