Re: Multiple Instances

From: Karl E. Jørgensen <SPAMGUARD_kjorg_at_email.msn.com>
Date: 1998/01/11
Message-ID: <#CJ3qqqH9GA.269@upnetnews03>#1/1

Limit the memory usage per Oracle instance ? Needless to say, you will be sacrificing performance by using less memory - but since database performance is not an issue (or is it?), this may help: - Decreasing the size of your database block buffers - Decreasing the size of your shared pool.

But if I read your posting correctly, you are running one instance per developer !!?
If you are, then I'd suggest giving them each their own schemas in the same instance instead.

--
Karl
Oracle Certified DBA

O.R.G. wrote in message <34b3c0ba.1325374_at_38.8.213.2>...


>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



begin 666 Karl E. Jørgensen.vcf
M0D5'24XZ5D-!4D0-"E9%4E-)3TXZ,BXQ#0I..DKX<F=E;G-E;CM+87)L.T4N
M#0I&3CI+87)L($4N($KX<F=E;G-E;@T*3D]413I396YI;W(@4WES=&5M<R!%
M;F=I;F5E<@T*55),.@T*55),.FAT=' Z+R]S97%U96PM:6UA9V4N8V]M#0I%
M34%)3#M04D5&.TE.5$523D54.E-004U'54%21"-K:F]R9T!M<VXN8V]M#0I2
@158Z,3DY.# Q,3%4,38P,S S6_at_T*14Y$.E9#05)$#0H`
`
end
end

Received on Sun Jan 11 1998 - 00:00:00 CST