Question:
What is the database_properties view and what information does it
contain?
Answer: Oracle needed a way to display global parameter values with
standard SQL, and we now have the database_properties view
that allows you to see system-wide default values such as the
default tablespace and default temporary tablespace, global database
name, time zone, and much, much more.
select
property_value
from
database properties
where
property_name =
'default_permanent_tablespace';
Here we can see a list of all of the values for our database from
database_properties:
select *
from
database_properties
order by 1;
PROPERTY_NAME PROPERTY_VALUE DESCRIPTION
------------------------- ---------------
-------------------------------- DBTIMEZONE
0:00 DB time zone
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
Global database name
NLS_CALENDAR JULIAN
Calendar system
NLS_CHARACTERSET WE8ISO8859P1
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 AL16UTF16 NCHAR Character set
NLS_NCHAR_CONV_EXCP FALSE NLS conversion
exception
NLS_NUMERIC_CHARACTERS ., Numeric
characters
NLS_RDBMS_VERSION 11.2 RDBMS
version for NLS parameters
NLS_SAVED_NCHAR_CS WE8ISO8859P1
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 TZH:TZM
Timestamp with TZ format
NLS_TIME_FORMAT HH.MI.SSXFF
AM Time format
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM
TZH:TZM Time with timezone format
 |
|
Get the Complete
Oracle SQL Tuning Information
The landmark book
"Advanced Oracle
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
buy it
for 30% off directly from the publisher.
|
