SQL Script Database Information

Updated: 28-Feb-2001
Version: 1.0

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 ON
SET VERIFY OFF

col instance_name form a8 Heading "Instance"
col name form a8 Heading "DB Name"
col host_name form a12 Heading "Hostname"

select dbid
	,name
	,instance_name
	,host_name
	,created
	,log_mode
from v$database, v$instance
/

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