Re: RAC for Reporting...!

One other thing: do you have to use RAC Guard to implement Active/Passive RAC or is it just a case of setting ACTIVE_INSTANCE_COUNT=1 and configuring tnsnames.ora with LOAD_BALANCE=OFF. Whenever I read about Active/Passive, RAC Guard is always referred to.

I am installing 9i today so I'll give the queries a test in there. The particular query I'm having trouble with contains a correlated subquery. I think this must be causing a problem with 9i query rewrite.

I need to do some more research into the restrictions of query rewrite.

Thanks again.

Matt

"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:<409a7edd$0$4548$afc38c87_at_news.optusnet.com.au>...
> Matt wrote:
>
> > What do you think..?
>
> Pretty sound as an idea... but if your queries are not being re-written
> in 8i, that's not encouraging. Yes, 9i allows rewrites to happen in many
> more circumstances than 8i, but it will be case of testing very
> carefully (obviously).
>
> I get the impression you've thought about it a lot, and have done a lot
> of research on various options, and so I feel fairly confident you are
> going to end up adopting an appropriate and reliable solution, whatever
> it happens to be.
>
> Active-Passive RAC is actually a pretty good idea (the cynic in me says
> 'precisely because it's not a fully-fledged RAC as she was intended to
> be'). Rememeber, the passive node is only passive to Oracle Net Services
> users. Nothing to stop you logging onto it in the confines of the server
> room and doing whatever you need to do. Pretty flexible all up.
>
> Regards
> HJR
Received on Fri May 07 2004 - 02:23:45 CDT