Re: Memory leak

From: Sybrand Bakker <gooiditweg_at_sybrandb.nospam.demon.nl>
Date: Wed, 24 Sep 2003 18:04:47 +0200
Message-ID: <c3g3nvc22iiqh90c92an041ovqhjes2tl5@4ax.com>

On Wed, 24 Sep 2003 09:54:15 +0200, "Langelage, Frank" <frank_at_lafr.de> wrote:

>Anna C. Dent wrote:
>> Adolfo wrote:
>>
>>> We check with top and sar -r
>>
>>
>> You do NOT have a memory leak.
>> This is typical behavior for Oracle on Solaris.
>> The "lost" memory is being used by Solaris for
>> file system buffer cache.
>>
>
>Don't know about Solaris 2.6, but on Solaris 8 or 9 you can mount
>filesystems with option "forcedirectio".
>Do this only for filesystems which contain oracle datafiles only,
>nothing else.
>This flag avoids the buffering of the oracle datafiles by the os. The
>buffering is not needed, because oracle buffers data and index. So you
>eliminate one memory transfer which also consumes some time.

forcedirectio is available for ufs filesystems only. Using ufs filesystems for Oracle can not be recommended.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Sep 24 2003 - 11:04:47 CDT