Viewing Information About the Database

The following views provide information about the database content and structure.

View	Description
DATABASE_PROPERTIES	Displays permanent database properties.
GLOBAL_NAME	Displays the global database name.
V$DATABASE	Contains database information from the control file.

Note:

select * from GLOBAL_NAME;

GLOBAL_NAME

MYDB.US.ORACLE.COM

select dbid, name, created, log_mode, open_mode, dataguard_broker

from v$database;

DBID	NAME	CREATED	LOG_MODE	OPEN_MODE	DATAGUARD_BROKER
1234567890	MYDB	2003-09-20 7:21:27 AM	ARCHIVELOG	READ WRITE	DISABLED

select * from DATABASE_PROPERTIES order by property_name;

PROPERTY_NAME	PROPERTY_VALUE	DESCRIPTION
DBTIMEZONE	-07:00	DB time zone
DEFAULT_PERMANENT_TABLESPACE	USERS	Default Permanent Tablespace ID
DEFAULT_TBS_TYPE	SMALLFILE	Default tablespace type
DEFAULT_TEMP_TABLESPACE	TEMP	ID of default temporary tablespace
DICT.BASE	2	dictionary base tables version #
EXPORT_VIEWS_VERSION	8	Export views revision #
GLOBAL_DB_NAME	MYDB.US.ORACLE.COM	Global database name
NLS_CALENDAR	GREGORIAN	Calendar system
NLS_CHARACTERSET	UTF8	Character set
NLS_COMP	BINARY	NLS comparison
NLS_CURRENCY	$	Local currency
NLS_DATE_FORMAT	DD-MON-RR	Date format
NLS_DATE_LANGUAGE	AMERICAN	Date language
NLS_DUAL_CURRENCY	$	Dual currency symbol
NLS_ISO_CURRENCY	AMERICA	ISO currency
NLS_LANGUAGE	AMERICAN	Language
NLS_LENGTH_SEMANTICS	BYTE	NLS length semantics
NLS_NCHAR_CHARACTERSET	UTF8	NCHAR Character set
NLS_NCHAR_CONV_EXCP	FALSE	NLS conversion exception
NLS_NUMERIC_CHARACTERS	.,	Numeric characters
NLS_RDBMS_VERSION	10.2.0.2.0	RDBMS version for NLS parameters
NLS_SORT	BINARY	Linguistic definition
NLS_TERRITORY	AMERICA	Territory
NLS_TIMESTAMP_FORMAT	DD-MON-RR HH.MI.SSXFF AM	Time stamp format
NLS_TIMESTAMP_TZ_FORMAT	DD-MON-RR HH.MI.SSXFF AM TZR	Timestamp with timezone format
NLS_TIME_FORMAT	HH.MI.SSXFF AM	Time format
NLS_TIME_TZ_FORMAT	HH.MI.SSXFF AM TZR	Time with timezone format