What query can I perform to determine if I am running on a RAC system? If I'm on a RAC, I need to query from GV$* rather than V$*.

  • You can always use the gv$* views, they work with single instances, too. This removes the hassle to check if you are on RAC or not – jmk Apr 13 '15 at 6:33

You can check the value of the CLUSTER_DATABASE parameter:

SQL> select name, value from v$parameter where name = 'cluster_database';

NAME                  VALUE
--------------------- ---------------------
cluster_database      TRUE 

According to the Oracle Database Reference:

CLUSTER_DATABASE is an Oracle RAC parameter that specifies whether or not Oracle RAC is enabled.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.