René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

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