Re: SGA size

> How can I set the size of SGA? I haven't found any parameter in
>INIT.ORA which set the SGA size.
>

You might want to tune the shared pool first and then the block buffer. A poor shared pool hit ratio can degrade performance dramatically even with a large block buffer.

--
Ken Walters
kwalters_at_pbs.org
DBA
Public Braodcasting Service
kwalters_at_pbs.org Received on Thu Sep 17 1998 - 08:19:08 CDT