首页 > IT基础架构 > 网络安全 > Initialization Parameter Files and Server Parameter Files (287)

Initialization Parameter Files and Server Parameter Files (287)

原创 网络安全 作者:tsinglee 时间:2007-11-30 11:39:16 0 删除 编辑

To start an instance, Oracle must read either an initialization parameter file or a
server parameter file. These files contain a list of configuration parameters for that
instance and database. Oracle traditionally stored initialization parameters in a text
initialization parameter file. You can also choose to maintain initialization parameters
in a binary server parameter file (SPFILE).

Initialization parameters stored in a server parameter file are persistent, in that any
changes made to the parameters while an instance is running can persist across
instance shutdown and startup.

Initialization parameters are divided into two groups: basic and advanced. In the
majority of cases, it is necessary to set and tune only the basic parameters to get
reasonable performance. In rare situations, modification to the advanced parameters
may be needed for optimal performance.

Most initialization parameters belong to one of the following groups:
■ Parameters that name things, such as files
■ Parameters that set limits, such as maximums
■ Parameters that affect capacity, such as the size of the SGA, which are called
variable parameters
Among other things, the initialization parameters tell Oracle:
■ The name of the database for which to start up an instance
■ How much memory to use for memory structures in the SGA
■ What to do with filled redo log files
■ The names and locations of the database control files
■ The names of undo tablespaces in the database

1. 参数可以分为以下几种类型:
* 用于命名的参数,例如为文件命名
* 用于设限的参数,例如设定一个最大值
* 用于设定容量的参数,例如设定 SGA 的大小


来自 “ ITPUB博客 ” ,链接:,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
  • 博文量
  • 访问量