Re: Oracle optimisation tips when running locally?

From: ddf <oratune_at_msn.com>
Date: Tue, 11 Feb 2014 11:23:22 -0800 (PST)
Message-ID: <1355682d-2084-4e0c-969e-9c7fb5a00b11_at_googlegroups.com>

On Tuesday, February 11, 2014 7:26:33 AM UTC-7, 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.
>
>
>
> Many thanks in advance
>
>
>
> harry

Windows 7 is a hog anyway, and Oracle running on it makes it no better. I currently run an 11.2.0.3 database on my Windows 7 laptop and here is how my SGA is set:

SQL> show sga

Total System Global Area 1670221824 bytes

Fixed Size                  2255784 bytes
Variable Size            1023411288 bytes
Database Buffers          637534208 bytes
Redo Buffers                7020544 bytes

SQL> It's pretty small but I don't run any more than two sessions, and most often I run a single session. My database is pretty spare, with no XMLDB, no java, no Text or sample schemas.

You'll need to 'grin and bear it' with Windows -- just scale down your memory parameters and restart the database and you should see improvements. Of course if your "11g" database is 11.2.0.1 you really need to consider upgrading to 11.2.0.3 to fix some of the bugs that can affect you on Windows. Likewise if your 10.2 database is 10.2.0.1 consider upgrading to 10.2.0.4 or 10.2.0.5.

David Fitzjarrell Received on Tue Feb 11 2014 - 20:23:22 CET