memory configuration

From: L. Tseng <lesliet_at_u.washington.edu>
Date: 1997/12/02
Message-ID: <66231m$ei8$1@nntp6.u.washington.edu>#1/1

Hi, DBAs,

I am trying to get an idea on how everyone allocates memory for Oracle server. Could you please privide some info on your server? thanks.

For a dedicate Oracle database server,
how much total memory in the system (Sun Sparce server, NT, HP, etc.)? how many db_block_buffers,shared_pool_size,log_buffer are set in the init file?

The exmaple in Oracle's default init.ora file has a LARGE module define as

db_block_buffers = 3200
shared_pool_size = 900000
log_buffe = 327680

Are these setting pratical for LARGE apps? How LARGE can this setting afford?

Leslie

-- 


=-=-=-=-=-=-=-=-=-=-=

Leslie Tseng
lesliet_at_writeme.com


=-=-=-=-=-=-=-=-=-=-=

Received on Tue Dec 02 1997 - 00:00:00 CST