Re: Multiple Instances

From: Sheilah Scheurich <scheuric_at_wantnospamsprynetatall.com>
Date: 1998/01/13
Message-ID: <34BBB69A.2654DF07@wantnospamsprynetatall.com>#1/1

You can't really limit per instance however, if the databases are really small, continue to lower the db_block_buffers and shared_pool_size until the swapping stops. Don't go to the point where the database is useless, but you should be able to limit the SGA allocation fairly well.

-Sheilah Scheurich
DBA
my email is wrong - remove the words "want no spam at all" to respond via email

O.R.G. wrote:

> To reply, please delete 'remove' from email address.
>
> In a development area where "database performance" is not critical
> (system performance is) we've created multiple Oracle Instances for
> each developer to use.
>
> At times all six instances are running but we take a tremendous hit
> with swapping. Is there any way to limit the swap oracle uses per
> instance? BTW each instance's SGA values are set for a SMALL
> db.
>
> Thanks!
>
> Otto R. Garcia
Received on Tue Jan 13 1998 - 00:00:00 CST