Pages
Home
About
Sitemap
Contact us
OracleOcean
All About Oracle Database
Category
Home
Why Oracle?
DBA
Why DBA?
Database Architecture
Licensing
Backup and Recovery
SQL & PL/SQL
Oracle Spatial
Certification
Associate (OCA)
Professional (OCP)
Master (OCM)
Certified Specialist (OCS)
Certified Expert (OCE)
Interview Series
Licensing Questions
Backup and Recovery Questions
SQL & PL/SQL Questions
General Database Questions
OracleOcean
Licensing
Licensing Questions
How to detect RAC (Real Application Cluster) feature usage?
Deepak Kharb
June 04, 2016
By Using v$active_instances view
SELECT DECODE(COUNT(*), 0, 'No', 'Yes') RAC
FROM
( SELECT 1 FROM v$active_instances WHERE rownum = 1
);
Sample Output:-
No comments :
Write comments
Subscribe to:
Post Comments ( Atom )
Get updates in your email box
Complete the form below, and we'll send you our recent update.
Popular Posts
ORA-01704: string literal too long
What is the cause of the ORA-01704: string literal too long ? or How to insert records length larger than 4000 into CLOB columns? Ca...
How to find the sid of oracle database?
Following are the different ways to find the SID of ORACLE database. 1. Without connecting to database WINDOWS: If Environment V...
Types of RMAN Backup
Full backup : A full backup backs up all data files in the database, block-by-block, a standalone backup with everything you need to reco...
How to find list of installed features of Oracle Database?
Following are the two ways to know which options are installed on your oracle database:- 1. V$OPTION :- displays database options and fea...
Oracle Database Server
An Oracle Database consists of at least one database instance and one database. The database instance handles memory and processes. ...
Recent Posts
No comments :
Write comments