Re: db-parameter Oracle 8.1.7

From: Nuno Souto <nsouto_at_optushome.com.au.nospam>
Date: Mon, 9 Dec 2002 23:42:13 +1100
Message-ID: <3df4927f$0$25755$afc38c87@news.optusnet.com.au>

Mon, 09 Dec 2002 12:13:58 +0000, mkoster said (and I quote):
>
> we have a RS6000 and increased from 4 GB to 8 GB RAM

why?

>
> i changed the parameters from
>
> db_block_buffers = 32768
> shared_pool_size = 448000000
> shared_pool_reserved_size = 44000000
> log_buffer = 1024000
> sort_area_size = 1310720
>
> to
>
> db_block_buffers = 49132
> shared_pool_size = 784000000
> shared_pool_reserved_size = 78400000
> log_buffer = 1638400
> sort_area_size = 1966080

Why?

>
> what do you mean ???
>

precisely...

-- 
Cheers
Nuno Souto
nsouto_at_optusnet.com.au.nospam

Received on Mon Dec 09 2002 - 06:42:13 CST