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
|
|
 |
|
Guarantee your Success!
Oracle is the
world's most complex, robust and flexible database, considered
impossible to master without a mentor.
That's why all BC
Oracle trainers are working professionals, experts in Oracle who
share their tips and secrets. |
|
| |
|
Burleson is the American Team
Note:
This Oracle
documentation was created as a support and Oracle training reference for use by our
DBA performance tuning consulting professionals.
Feel free to ask questions on our
Oracle forum.
Verify
experience!
Anyone
considering using the services of an Oracle support expert should
independently investigate their credentials and experience, and not rely on
advertisements and self-proclaimed expertise. All legitimate Oracle experts
publish
their Oracle
qualifications.
Errata?
Oracle technology is changing and we
strive to update our BC Oracle support information. If you find an error
or have a suggestion for improving our content, we would appreciate your
feedback. Just
e-mail:
 and include the URL for the page.
Copyright © 1996 - 2012
All rights reserved.
Oracle ©
is the registered trademark of Oracle Corporation.
|
|
