Re: Problem with use_indirect_data_buffers

Ruben Puettmann wrote:

> hello,
>
> I have an problem with use_indirect_data_buffers under Linux.
>
> Hardware : Compaq DL380 G2 with 4 gig RAM
> Software : Linux 2.4.18 with higmem (64 GB)
> Oracle 8.1.7 enterprise
>
>
> I have add use_indirect_data_buffers = true to my configuration cause I
> want that oracle use
> /dev/shm for the block_buffers . so that I have more space in the SGA
> vor other things.
>
> Don't aks me why I need so much SGA, I need it ;-)
>
> my mount looks:
>
> shmfs on /dev/shm type shm (rw,size=2G,mode=777)
>
> Oracle starts with no error if use_indirect_data_buffers=true but oracle
> don't use
> /dev/shm:
>
> Filesystem Size Used Avail Use% Mounted on
> shmfs 2.0G 0 2.0G 0% /dev/shm
>
> Now I have make the block_buffers so high that it don't fits in the SGA.
> Oracle don't start. Error allocation ....
>
> What error do I make ??
>
> Thx for help
>
> Ruben

Actually I would be interested in knowing why you think you need such a large SGA.

Daniel Morgan Received on Fri Jun 28 2002 - 15:48:39 CDT