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