Materialized View in a RAC Database

From: "Anurag Verma" <anuragdba@xxxxxxxxx>
To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
Date: Mon, 24 Dec 2007 15:03:00 -0800

Is there any way to direct the scheduled run of a Materialized view to a
specific node in a RAC database?

I have a 6 node RAC database running on Sun Solaris and out of that, 1 node
is having 8 CPUS whereas all the other nodes
are having 4 CPUS each.

The Materialized view in question runs every hour, and I would like to make
it run only on the node which is having 8 CPUS?

Is it possible ? (Using any service or TNS entries or any other method) ???

-- 

Anurag Verma,
Database Administrator
ERCOT(Electric Reliability Council of Texas),
Texas 76574

Follow-Ups:

Re: Materialized View in a RAC Database
From: Anurag Verma

Re: Materialized View in a RAC Database
From: hrishy

Materialized View in a RAC Database

Other related posts: