Viewing server-side failover settings

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Andy Kent - 03 Oct 2008 09:58 GMT

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

Reply to this Message

DA Morgan - 03 Oct 2008 21:22 GMT

> I understand I can configure server-side TAF with
> DBMS_SERVICE.MODIFY_SERVICE. But how do I query current failover
[quoted text clipped - 4 lines]
>
> Andy

desc dba_services

Signature

Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Reply to this Message

Andy Kent - 06 Oct 2008 10:25 GMT

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?

> > I understand I can configure server-side TAF with
> > DBMS_SERVICE.MODIFY_SERVICE. But how do I query current failover
[quoted text clipped - 12 lines]
> damor...@x.washington.edu (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org

Reply to this Message