Re: Materialized View in a RAC Database

From: Anurag Verma <anuragdba_at_gmail.com>
Date: Mon, 24 Dec 2007 15:04:20 -0800
Message-ID: <e2431aa40712241504w158e5f76p5dbd4269df927897@mail.gmail.com>

By the way, the Oracle version I am having is 10.2.0.3 on Oracle Clusterware.

On Dec 24, 2007 3:03 PM, Anurag Verma <anuragdba_at_gmail.com> wrote:

>
> 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
>

-- 

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:04:20 CST