Re: init.ora and procesors

From: skv_genius <svyas_at_lehman.com>
Date: 1 Dec 2005 01:28:17 -0800
Message-ID: <1133429297.667916.251790@g49g2000cwa.googlegroups.com>

Sybrand Bakker wrote:
> On Thu, 01 Dec 2005 07:55:23 +0100, Morff <morff1_at_wp.pl> wrote:
>
> >Hi
> >
> >My firm bought a new machine with 4 procesor - we had a machine with 2
> >procesors . Which parameters on init.ora should I change when I install
> >ORA and import database to new machine ? Or somewhere else ? OS is
> >SunSolaris , Oracle is 8.1.7.
> >
> >Best regards
>
> None,
> Oracle will detect the number of processors automatically.
>
> --
> Sybrand Bakker, Senior Oracle DBA

Hi,

But you should look at tuning the DB_BLOCK_LRU_LATCHES and the DB_WRITER_PROCESSES parameters accordingly , if your instance needs the additional advantage.

Regards
Sushil. Received on Thu Dec 01 2005 - 03:28:17 CST