Re: Oracle optimisation tips when running locally?

On Tuesday, February 11, 2014 6:26:33 AM UTC-8, adrian.ha..._at_gmail.com wrote:
> I have Oracle 10.2 & 11g running locally on a Windows 7 (32 bit) machine purely for development purposes.
>
> Although I only run 1 instance at a time, they both can take up lots of RAM and slow my PC down.
>
> At most, I use a maximum of 3 concurrent connections and the majority of development is done against Oracle Databases without any i.e. Oracle Text etc...
>
> Has anyone a similar setup that may have a few any optimisation to reduce the foot print a bit?
>
> I know this sounds mickey mouse but the live instances on running no Blades and having everything locally is so much faster and easier.
>

The most obvious is to not be running dbconsole. If you don't use java, you might be able to reduce that init parameter. Show SGA and let us know what it says. Check PGA and SGA advice tables to see if you can set things down.

I'm sure there's more that isn't coming off the top of my head, but at some point the reality sets in that it is a hog.

jg

-- 
_at_home.com is bogus.
https://twitter.com/kevinclosson/status/433047447464443905/photo/1