Basic Initialization Parameters in Oracle Database
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..