SQL Script Database Information

Updated: 28-Mar-2005
Version: 3.1

Description

Basic Database details - useful to put in as part of a glogin.sql script if you have lots of database on one machine

Parameters

None

SQL Source

REM Copyright (C) Think Forward.com 1998- 2005. All rights reserved. 

CLEAR
SET HEAD off
SET VERIFY OFF
SET FEED OFF

alter session set nls_date_format='DD-MON-RR HH24:MI' ;

col c0 newline

select   'DBID          : ' || dbid c0
	,'DB Name       : ' || name c0
	,'Instance Name : ' || instance_name c0
	,'Host          : ' || host_name c0
        ,'Version       : ' || version
	,'Platform      : ' || platform_name c0
	,'Created       : ' || created c0
	,'Log Mode      : ' || log_mode c0
	,'Open Mode     : ' || open_mode c0
        ,'Prot Mode     : ' || protection_mode c0
        ,'Prot Level    : ' || protection_level c0
        ,'Database Role : ' || database_role c0
        ,'Swit Over Stat: ' || switchover_status c0
        ,'Force Logging : ' || force_logging c0
        ,'Flashback On  : ' || flashback_on c0
from v$database, v$instance
/

set feed on head on

Related Links

Oracle 9i: (SQL Script) Database Information 9i

Return to Index of SQL Scripts

Site Map

General Information : Home | Company Profile | Contact Us | Legal
Database Support : Proactive Support | Pay Per Incident Support
Expert Services : High Availability | Creative Solutions | Training
Build Services : Oracle Installations | Revive your Oracle Setup | Low Cost Development
Free Oracle Resources: DBA Scripts | Oracle Links