Overview of Oracle parameter files

Parameter files are settings that are used to configure the database. such as the location of the control file (control_files), the size of the data block (db_block_size), buffer cache size (db_cache_size), and other information

1. Oracle parameter list

Select * from V$parameter;

2. Modify parameter Example

Alter system set processes=1000scope=spfile;--modifies the maximum number of connections to the database

3, scope below 4 kinds

A), scope=memory-effective immediately, until the database is closed;

b), scope=spfile-reuse the SPFile file to restart the data before it takes effect;

c), scope=both-will take effect immediately in memory, and modify the SPFile to ensure that after the restart of the database also effective;

d), do not specify scope-equivalent to both (database started through SPFile)

< note > Static parameter values can not be modified by modifying the memory to take effect, by modifying SPFile (), restart the database to take effect, that is, the 2nd way;

How do I see if the database is started with a pfile (text file) or spfile (binary file)?

SELECT * from V$parameter wherename= ' spfile '-if there is a record, the SPFile starts

4, for some parameters can not be immediately modified, only for the newly established session to modify these parameters

Select name from V$parameter a where a.issys_modifiable= ' DEFERRED '

Modify Example:

Alter system set sort_area_size=65536 deferred;--deferred modification

5. Cancel Parameter setting

alter system reset Sort_area_size scope=spfile sid= ' * ';

This column more highlights: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/