Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: memory configuration
L. Tseng wrote:
>
> 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
> =-=-=-=-=-=-=-=-=-=-=
Hi Leslie,
there's so many to say about these items that it will fill books. So why not read 'Tuning Oracle' published by Oracle Press and OSBORNE. it covers those items. For getting started with oracle (aslo sizing memory and disk space) take a look at 'DBA Handbook' fromthe same publishers.
-- Regards Matthias Gresz :-)Received on Wed Dec 03 1997 - 00:00:00 CST