Subject:            SQL: IS THE DATABASE MOUNTED SHARED/EXCLUSIVE
Author:            RBEARD
Modified:           01 Apr 96 09:20:14           



 
How to Determine whether the Database is mounted SHARED or EXCLUSIVE 
-------------------------------------------------------------------- 
 
The following query will determine whether the database is mounted shared  
or exclusive. 
 
For further information see bug 274816
 
When the database is mounted shared, the following query returns 1 or more  
rows: 
 
SELECT * FROM v$process  
WHERE program  
LIKE '%(LCK%)%'; 
 
When the database is mounted exclusive, it returns 0 rows.