Oracle：11gR2的安装后看”基本的初始化参数“
从中可以得出几点结论：
- 大部分的 基本参数(basic)需要设置
- 和os路径相关的参数需要设置
- 基本的内存、进程、游标参数需要设置
- 如果在spfile中设置的参数，可以从【V$spparameter】的 {isspecified=false}获得
- 基本参数与否？和可修改与否？没有关系。完全是两个不同的角度看待问题。
附录：基本参数
| NAME | TYPE | ISBASIC | ISSES_ MODIFIABLE |
ISSYS_ MODIFIABLE |
DESCRIPTION | |
| 1 | compatible | String | TRUE | Database will be completely compatible with this software version | ||
| 2 | control_files | String | TRUE | control file names list | ||
| 3 | db_block_size | Integer | TRUE | Size of database block in bytes | ||
| 4 | db_domain | String | TRUE | directory part of global database name stored with CREATE DATABASE | ||
| 5 | db_name | String | TRUE | database name specified in CREATE DATABASE | ||
| 6 | db_recovery_file_dest | String | TRUE | IMMEDIATE | default database recovery file location | |
| 7 | db_recovery_file_dest_size | Big integer | TRUE | IMMEDIATE | database recovery files size limit | |
| 8 | nls_language | String | TRUE | TRUE | NLS language name | |
| 9 | nls_territory | String | TRUE | TRUE | NLS territory name | |
| 10 | open_cursors | Integer | TRUE | IMMEDIATE | max # cursors per session | |
| 11 | processes | Integer | TRUE | user processes | ||
| 12 | remote_login_passwordfile | String | TRUE | password file usage parameter | ||
| 13 | sga_target | Big integer | TRUE | IMMEDIATE | Target size of SGA | |
| 14 | undo_tablespace | String | TRUE | IMMEDIATE | use/switch undo tablespace | |
| 15 | cluster_database | Boolean | TRUE | if TRUE startup in cluster database mode | ||
| 16 | db_create_file_dest | String | TRUE | TRUE | IMMEDIATE | default database location |
| 17 | db_create_online_log_dest_1 | String | TRUE | TRUE | IMMEDIATE | online log/controlfile destination #1 |
| 18 | db_create_online_log_dest_2 | String | TRUE | TRUE | IMMEDIATE | online log/controlfile destination #2 |
| 19 | db_unique_name | String | TRUE | Database Unique Name | ||
| 20 | instance_number | Integer | TRUE | instance number | ||
| 21 | ldap_directory_sysauth | String | TRUE | OID usage parameter | ||
| 22 | log_archive_dest_1 | String | TRUE | TRUE | IMMEDIATE | archival destination #1 text string |
| 23 | log_archive_dest_2 | String | TRUE | TRUE | IMMEDIATE | archival destination #2 text string |
| 24 | log_archive_dest_state_1 | String | TRUE | TRUE | IMMEDIATE | archival destination #1 state text string |
| 25 | log_archive_dest_state_2 | String | TRUE | TRUE | IMMEDIATE | archival destination #2 state text string |
| 26 | pga_aggregate_target | Big integer | TRUE | IMMEDIATE | Target size for the aggregate PGA memory consumed by the instance | |
| 27 | remote_listener | String | TRUE | IMMEDIATE | remote listener | |
| 28 | sessions | Integer | TRUE | user and system sessions | ||
| 29 | shared_servers | Integer | TRUE | IMMEDIATE | number of shared servers to start up | |
| 30 | star_transformation_enabled | String | TRUE | TRUE | IMMEDIATE | enable the use of star transformation |
