Re: lowering memory demands

You need to lower your init<sid>.ora parameters, db_block_buffers and shared_pool_size.
Most likely you have a db_block_size of 8 and db_block_buffers of 16000, I would lower it to 8000 or 10000.
I would lower the shared_pool_size to 40M The init<sid>.ora file typically is located in $ORACLE_HOME/dbs You need to bounce the database once you have changed the parameters. The total SGA should not exceed 128-160M in your case.

Of course this is all well documented, and some RTM would be required from you the next time.

Regards,

Sybrand Bakker, Oracle DBA

"Dolommite" <dolommite_at_yahoo.com> wrote in message news:MPG.143de38552b28112989699_at_news.earthlink.net...
> I started my initial DB on my Sol8 machine, and got the following msgs *
> (8i):
> ============
> SVRMGR>
> ORACLE instance started.
> Total System Global Area 211660708 bytes
> Fixed Size 94116 bytes
> Variable Size 79740928 bytes
> Database Buffers 131645440 bytes
> Redo Buffers 180224 bytes
> Database mounted.
> Database opened.
> =============
> I've only got .5gb in this machine, now it's about gone already. Any
> type of access to the db and it starts paging. How can I lower this? I
> know this is a pretty academic q for most of you - so my apologies in
> advance.
>
> Greg
Received on Fri Sep 29 2000 - 00:51:30 CDT