With the help of various posts in web we have developed this scripts and posts. Code and information are provided "AS IS" without warranty of any kind.
Saturday, 22 September 2012
Script to find the Database Name and Status
Database Info
select instance_name,open_mode,flashback_on from v$database;
