Oracle "Basic" initialization parameters Oracle Database Tips by Donald Burleson

Starting in Oracle 10g, initialization parameters are now divided into two groups, basic and advanced. Oracle has over 250 initialization parameters and over 100 undocumented parameters, but the list below is the list of "basic" Oracle parameters.  For a complete treatment of using Oracle parameters, see my book "Oracle Tuning: The Definitive Reference".

• Oracle undocumented (dangerous) parameters
   

• Oracle parameter list

Oracle "basic" 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
 job_queue_processeslog_archive_dest_n
 log_archive_dest_state_n
 nls_language, nls_territory
 open_cursors
 pga_aggregate_target
 processes
 remote_listener
 remote_login_passwordfile
 rollback_segments
 sessions
 sga_target
 shared_servers
 star_transformation_enabled
 undo_management
 undo_tablespace

 

If you like Oracle tuning, see the book "Oracle Tuning: The Definitive Reference", with 950 pages of tuning tips and scripts.  You can buy it direct from the publisher for 30%-off and get instant access to the code depot of Oracle tuning scripts.