In-depth analysis of Oracle learning notes (chap. III) ____oracle

Initialization parameters are divided into 3 classes: Derivation parameters operating system dependent parameter variable parameters

Derivation parameter example: Sessions = (1.1 * processes) +5

Operating system dependent parameters: for example, Db_cache_size, limited to operating system physical memory.

Variable parameters:

Static parameters, dynamic parameters

Display parameters, suppressed parameters (beginning with "_")

$ORACLE _home/sqlplus/admin/glogin.sql

Set Sqlprompt "_user@_connect_jdentifier>"

Show parameter is actually a query V$parameter view, which is based on the two underlying data dictionary tables X$ksppi and X$KSPCCV, which (filtering out suppressed parameters), can query all parameters and their descriptive information through the two base tables.

Initialization parameter file init manual modification must be restarted before it takes effect

Server parameter file SPFILE can be modified by command--"V$spparameter

V$system_parameter system-level parameter settings, which are first inherited from V$system_parameter when a new session is created

V$parameter session level, which differs from V$system_parameter if session-level parameters are modified

Show parameter--> v$parameter

Show Spparameter--> V$spparameter

SPFile will not be locked during the Oracle run, so spfile can be modified during the Oracle run, and accidental loss is eliminated.

Search Order Spfile<oracle_sid>.ora--> Spfile.ora--> Init<oracle_sid>.ora

Startup Pfile= '

You can call SPFile in Pfile

Parameter file, if the parameter is set repeatedly, the parameter read later replaces the previous setting.

You can specify SID parameters when modifying parameters for the Rac,alter system command.

For Scope=spfile modified parameters, the current instance is invalid, but can be found through v$spparameter.

Without the scope parameter, the Scope=both. If it is a static parameter, only SPFile can be specified, otherwise an error will be given.

Reset parameter defaults: Alter system reset Parameter_name scope= sid=

V$rman_configuration View Query Rman configuration

Rman control file Automatic backup location default to Flashback area, can modify location via Rman Configure command

V$backup_spfile query automatic backup of control files and parameter files

List Backup of SPFile

11g start, create Pfile/spfile from memory.