Oracle database settings

Ref: 

Controlfiles

A database needs 

The location of the controlfiles can be found through

Character Sets(Ordinary) character set

The (ordinary) character set for a database can be determined with:

value from where parameter = 'NLS_CHARACTERSET';

National character set

The national character set for a database can be determined with:

value from 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  or .

Logfiles

The location of the  can be found with:

select member from ;