Re: Memory leak

From: Langelage, Frank <frank_at_lafr.de>
Date: Wed, 24 Sep 2003 22:31:48 +0200
Message-ID: <bksuvl$5pq4h$1@ID-48907.news.uni-berlin.de>

Sybrand Bakker wrote:
> 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.
>

Why not ? Can you explain this a little bit more ? What's the recommended filesystem type for Oracle on Solaris then ? Veritas-FS (VxFS) ? Received on Wed Sep 24 2003 - 15:31:48 CDT