René Nyffenegger's collection of things on the web | |
René Nyffenegger on Oracle - Most wanted - Feedback
- Follow @renenyffenegger
|
Oracle database settings | ||
Controlfiles
A database needs controlfiles
The location of the controlfiles can be found through v$controlfile
Character Sets(Ordinary) character set
The (ordinary) character set for a database can be determined with:
select value from nls_database_parameters where parameter = 'NLS_CHARACTERSET'; National character set
The national character set for a database can be determined with:
select value from nls_database_parameters where parameter = 'NLS_NCHAR_CHARACTERSET'; Default tablespaces
An Oracle database can be configured with a
default tablespace and a default temporary tablespace. These are used for users who are not configured with
default tablespaces or
default temporary tablespaces.
Logfiles
The location of the online redo log can be found with:
select member from v$logfile; Time zone |