Re: Materialized View in a RAC Database

From: hrishy <hrishys_at_yahoo.co.uk>
Date: Tue, 25 Dec 2007 08:09:07 +0000 (GMT)
Message-ID: <507345.3344.qm@web27806.mail.ukl.yahoo.com>

Hi

If you are using dbms_job to schedule the refreshes then have a look at the instance parameter for the dbms_job package the submit method can be passes a instance number.

regards
Hrishy

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

---

Sent from Yahoo! Mail - a smarter inbox http://uk.mail.yahoo.com

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Dec 25 2007 - 02:09:07 CST