Problem with use_indirect_data

From: Ruben Puettmann <ruben.puettmann_at_freenet-ag.de>
Date: Fri, 28 Jun 2002 21:48:24 +0200
Message-ID: <3D1CBD88.92643F11@freenet-ag.de>

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 Received on Fri Jun 28 2002 - 14:48:24 CDT

Problem with use_indirect_data_buffers