Re: Application migration from non RAC databases to RAC databases

On Thu, 20 Sep 2007 10:14:40 -0700, Vin <vinay.thite_at_gmail.com> wrote:

>Hello All,
>
>Do we have any material available on "migrating applications from
>non-RAC databases to RAC databases" ?
>
>I am asked to study the readiness of "application migration from
>non-RAC to RAC databses" and create analysis report. I am asked
>to analyse the changes required for making the migration APART
>FROM TECHNICAL DATABASE MIGRATION ? We know how to migrate
>database from non-RAC to RAC, what we need to know is "What
>needs to be done to avoid performance / configuration issues
>later after changing to RAC" etc.
>
>I would greatly appreciate any advice on this.
>
>Thanks,
>Vin

If your non-rac application is non-scalable, especially if it uses full table scans all over the place, RAC will make things *worse*, as a read of <db_file_multiblock_read_count> blocks will result in <db_file_multibllock_read_count> global cache cr requests. For the rest I agree for once with hpuxrac. Oracle states in their docs RAC will make a non-scalable app suffer.

-- 
Sybrand Bakker
Senior Oracle DBA