Basic Initialization Parameters in Oracle Database

Published by Ahmad on

DBA can create database through DBCA  or Manually. If DBA is creating database manually then DBA  will create parameter file that is pfile. In pfile DBA should use the basic initialization parameters which are Oracle recommended. If DBA are using these basic parameters then database runs properly and efficiently. In special circumstances DBA can use other parameters which are documented.

The following is a list of the database basic initialization parameters:

CLUSTER_DATABASE

COMPATIBLE

CONTROL_FILES

DB_BLOCK_SIZE

DB_CREATE_FILE_DEST

DB_CREATE_ONLINE_LOG_DEST_n

DB_DOMAIN

DB_NAME

DB_RECOVERY_FILE_DEST

DB_RECOVERY_FILE_DEST_SIZE

DB_UNIQUE_NAME

INSTANCE_NUMBER

LDAP_DIRECTORY_SYSAUTH

LOG_ARCHIVE_DEST_n

LOG_ARCHIVE_DEST_STATE_n

NLS_DATE_LANGUAGE

NLS_TERRITORY

OPEN_CURSORS

PGA_AGGREGATE_TARGET

PROCESSES

REMOTE_LISTENER

REMOTE_LOGIN_PASSWORDFILE

SESSIONS

SGA_TARGET

SHARED_SERVERS

STAR_TRANSFORMATION_ENABLED

UNDO_TABLESPACE

Check regularly my post and give feedback & comments!!!!.

Send us the Invitation or Follow us.

Thanks

Ahmad (Riaz Ahmad Ansari)

OCE In (11g R2 RAC)

OCP In (11g/10g/9i)

 


3 Comments

Ravindra malwal · October 24, 2018 at 9:49 pm

Nice doc

Mohammad zeeshan · November 2, 2018 at 9:31 pm

Great post sir, well explained the parameter file.

Vinoth · November 12, 2018 at 9:34 pm

Nice doc..

Leave a Reply

Your email address will not be published. Required fields are marked *