 |
|
Oracle "Basic" initialization parameters
Oracle Tips by Burleson Consulting |
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 "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. |
