Materialized View in a RAC Database

From: Anurag Verma <anuragdba_at_gmail.com>
Date: Mon, 24 Dec 2007 15:03:00 -0800
Message-ID: <e2431aa40712241503t321417c4see104ef215439ff6@mail.gmail.com>

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

--

http://www.freelists.org/webpage/oracle-l Received on Mon Dec 24 2007 - 17:03:00 CST