Re: memory problem - oracle 10203 on HPUX

If you set filesystemio_options=directIO then you don't have to set /usr/sbin/mount
-F vxfs -e -o noatime,*mincache=direct*

This is because the init.ora parameter directs oracle to use direct IO calls to all files and so you don't have to also instruct the filesystem to use direct IO calls to files opened in it.

Did I misunderstand something?

Finn

On 1/23/08, Juan Miranda <j.miranda_at_sermatica.es> wrote:
>
>
>
> Ujang
>
>
>
> Remember also to bypass fs cache using direct i/o, (only if you have
> Online JFS):
>
>
>
> filesystemio_options=directIO
>
> /usr/sbin/mount -F vxfs -e -o noatime,*mincache=direct *
>
>
>
>
>
>
>
> If you don´t use RAW volumen, you must configure io slaves because vxfs
> don´t permit asynch i/o.
>
> I used this:
>
> disk_asynch_io=false
>
> dbwr_io_slaves=6
>
>
>
>
>
> This is my configuration for a Datawarehouse
>
>
>
> Free
>
>
>
> 5000
>
> PGA
>
>
>
> 9000
>
> SGA
>
> buffer pool
>
> 11000
>
> shared pool
>
> keep pool
>
> 0
>
> Buffer SO
>
>
>
> 3200
>
> System
>
>
>
> 3600
>
>
>
> total
>
> 31800
>
>
>
>
>
>
>
> Juan.
>
>
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l