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