Re: Viewing server-side failover settings

Thanks. On a related topic, how can we get a measure of how well cache fusion and load balancing are working?

With regard to cache fusion I've seen lengthy queries on gv$bh to compare caches. Is it possible to tell from gv$bh whether cache fusion is actually happening rather than the same blocks just happening to have been read into cache by the different instances? Is there anythign in EM to help and would we need to upgrade to Enterprise Edition to get it?

On Oct 3, 9:22 pm, DA Morgan <damor..._at_psoug.org> wrote:
> Andy Kent wrote:
> > I understand I can configure server-side TAF with
> > DBMS_SERVICE.MODIFY_SERVICE. But how do I query current failover
> > settings?
>
> > We have 11.1.0.6 Standard Edition running a 2-node cluster on SuSe 10.
> > Apols for the newbie question but I'm new to RAC.
>
> > Andy
>
> desc dba_services
> --
> Daniel A. Morgan
> Oracle Ace Director & Instructor
> University of Washington
> damor..._at_x.washington.edu (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org
Received on Mon Oct 06 2008 - 04:25:27 CDT