Re: Increasing size of SGA / Reducing Use of SGA

In article <1994Mar11.124410.978_at_gtewd.mtv.gtegsc.com>, davidsonj_at_gtewd.mtv.gtegsc.com writes:
|>
|> Two questions:
|> a) Why am I unable to restart the database with the new INIT.ORA file when
|> I seem to have plenty of memory and diskspace? According to the prologue
|> of the INIT.ORA file, I only need 6.8 MB - we have 164 MB or so - and
|> I don't think changing this file has much if any impact on disk space.
|>
|> b) What sort of things can I do to free up SGA? I tried dropping MANY packages
|> and tables from various user accounts that were not currently in use and
|> this seemed to have no impact when I thought reducing the size of the
|> data dictionary would reduce the use of the SGA. Can anyone explain
|> this? Suggest how to reduce my use of SGA?
|>
|> MUCH THANKS IN ADVANCE...Let's see if you can beat ORACLE to the solution
|> even when they have a 1 week head start!
|>
|> jim
|>
|> p.s. I am running version 7.0.12 or the Oracle server on Ultrix 4.2A

Under UNIX SVR4 one must tune appropriate shared memory segments and semaphores for Oracle. Your shared memory segments and the number of semaphores must be adequate to support your SID's SGA size. Not sure about Ultrix - I suggest you revert to the Oracle installation manual for your specific platform. More than likely your current shared memory configuration will not support the medium SGA. You should also read the db aministration manual and review the init.ora parameters. This will help you understand the make up of the SGA and the effect of specific parameters.

-- 
Thanks,
--------------------------------------------------
joseph r minnich	jminnich_at_bugaboo.ssnet.com