Re: Materialized View in a RAC Database
- From: hrishy <hrishys@xxxxxxxxxxx>
- To: anuragdba@xxxxxxxxx, ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 25 Dec 2007 08:09:07 +0000 (GMT)
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@xxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
