Joel Garry wrote:
> iloadmin wrote:
>
>>Hello,
>>
>>I've been given the exciting responsibility of getting oracle 9 sga
>>sized to be the backend of a website. I have some oracle experience
>>and I understand the sga consist of memory structures which are part
>
> of
>
>>an instance. I know the sga contain data information and manipulates
>>memory virutally. My goal is to approximately size the
>>shared_pool_size, db_block_size, db_cache_size and log_buffer
>>parameters. After doing some research I found a formula to size the
>>sga.
>>
>>db_cache_size + db_keep_cache_size + db_recycle_cache_size +
>>DBnk_cache_size +
>>shared_pool_size+ large_pool_size + java_pool_size + log_buffers +
>
> 1MB.
>
>>Again, I am not trying to be exact. I do not want to accept the
>>default settings of an oracle installation for these parameters. The
>>database will be the backend of website and it is my first time
>>attempting this. I am willing to research for all my answer and test
>>my hypothesis as I learn about them so I can complete the
>>responsibility. The database will be working hand in hand with
>
> redhat
>
>>linux version 3 and the OFA for Oracle 9 have been set including the
>>blocksize for the mount points.
>>
>>My quesiton "knowing this will be the backend what numbers should I
>
> be
>
>>looking at to plug into these parameters to get this started" ?
>>Thanks in advance,
>>iloadmin
>
>
> The db_block_size depends on the primary purpose of the db, ie OLTP or
> DW.
No it doesn't, not without an awful lot of qualifiers (such as direct
I/O being in the picture). We've been over it enough, I would have thought.
Regards
HJR
Received on Thu Dec 16 2004 - 03:43:37 CST
