Working from member (no database handy at the moment) that would be something like: SELECT name, type, value FROM v$parameter WHERE name like '%cluster%'; On Sat, Feb 5, 2011 at 2:04 PM, Alex List <alex@xxxxxxxxxxxxxx> wrote: > Is there another way to get these values through a view or something > (select) ?? > > My application will connect and then verify preferably by "select" if its a > Cluster or Standalone DB. > > Thanks. > Alex > > > > On Sat, Feb 5, 2011 at 16:52, <paul.baumgartel@xxxxxxx> wrote: > >> Instance parameters cluster_database and cluster_database_instances will >> tell you: >> >> SQL> show parameter cluster >> >> NAME TYPE VALUE >> ------------------------------------ ----------- ----- >> cluster_database boolean TRUE >> cluster_database_instances integer 3 >> cluster_interconnects string >> >> >> *Paul Baumgartel* >> UBS AG >> IB Accounting Solutions >> 400 Atlantic Street >> Stamford, CT 06904 >> >> 203.719.4368 >> >> paul.baumgartel@xxxxxxx >> www.ubs.com >> >> >> ------------------------------ >> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto: >> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Alex List >> *Sent:* Saturday, February 05, 2011 1:37 PM >> *To:* Oracle I List >> *Subject:* Rac-Standalone info view >> >> Hi, >> >> I was trying to find out which view could provide me information if I am >> logged on Rac or Standalone instance. >> Disregard many ways to look for this info, but considering only when >> connected, and through the views find out if I am logged in a Standalone or >> in a Rac Instance. >> >> According to the database connection I have to enable or disable some >> features in my application, that's why I am looking for this. >> >> Thank you in advance. >> Alex >> >> >> Visit our website at http://www.ubs.com >> >> This message contains confidential information and is intended only >> for the individual named. If you are not the named addressee you >> should not disseminate, distribute or copy this e-mail. Please >> notify the sender immediately by e-mail if you have received this >> e-mail by mistake and delete this e-mail from your system. >> >> E-mails are not encrypted and cannot be guaranteed to be secure or >> error-free as information could be intercepted, corrupted, lost, >> destroyed, arrive late or incomplete, or contain viruses. The sender >> therefore does not accept liability for any errors or omissions in the >> contents of this message which arise as a result of e-mail transmission. >> If verification is required please request a hard-copy version. This >> message is provided for informational purposes and should not be >> construed as a solicitation or offer to buy or sell any securities >> or related financial instruments. >> >> >> UBS reserves the right to retain all messages. Messages are protected >> and accessed only in legally justified cases. >> > > -- Cheers, -- Mark Brinsmead Senior DBA, The Pythian Group http://www.pythian.com/blogs