The SPFILE Initialization Parameter
The SPFILE initialization parameter contains the name of the current server
parameter file. When the default server parameter file is used by the server (that is,
you issue a STARTUP command and do not specify a PFILE), the value of SPFILE is
internally set by the server. The SQL*Plus command SHOW PARAMETERS SPFILE (or
any other method of querying the value of a parameter) displays the name of the
server parameter file that is currently in use.[@more@]
parameter file. When the default server parameter file is used by the server (that is,
you issue a STARTUP command and do not specify a PFILE), the value of SPFILE is
internally set by the server. The SQL*Plus command SHOW PARAMETERS SPFILE (or
any other method of querying the value of a parameter) displays the name of the
server parameter file that is currently in use.[@more@]
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/10599713/viewspace-1002608/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- Initialization Parameter Files and Server Parameter Files (287)Server
- Special Characters in Initialization Parameter Files
- OPTIMIZER_MODE Initialization Parameter
- Rules Governing Initialization Parameter FilesGo
- DB_NAME Initialization Parameter (87)
- DB_DOMAIN Initialization Parameter (88)AI
- The SGA_TARGET Initialization Parameter (74)
- Step 3: Create the Initialization Parameter File (61)
- DB_BLOCK_SIZE Initialization Parameter (92)BloC
- The SGA_MAX_SIZE Initialization Parameter (72)
- UNDO_MANAGEMENT Initialization Parameter (118)
- DB_CACHE_SIZE Initialization Parameter (109)
- Initialization Parameter Changes from 9i to 10g
- ORA-29707: inconsistent value 2 for initialization parameter cluster_database_Database
- Oracle修改初始化引數（initialization parameter）scope的選項Oracle
- The COMPATIBLE Initialization Parameter and Irreversible Compatibility (119)
- Initialization
- list initialization
- 初始化 (Initialization)
- Oracle ParameterOracle
- Oracle Spfile and pfileOracle
- Required parameter $xxx follows optional parameter $yyyUI
- SKIP_UNUSABLE_INDEXES InitializationIndex
- Understanding Initialization Parameters (85)
- Other SGA Initialization Parameters (96)
- Sessions & Processes parameterSession
- Import parameter: STATISTICSImport
- Export Parameter : BufferExport
- Export Parameter : QueryExport
- MySQL過程報 Parameter number N is not an OUT parameter錯誤MySql
- 【spfile】修改及重置spfile實操 plus 故障處理一則
- [VRDevice] Initialization of device oculus failed.VRdevAI
- 使用DBMS_UTILITY.get_parameter_value檢視session的parameterSession
- ASM下遷移spfileASM
- Oracle的spfile和pfileOracle
- Oracle ASM spfile in a disk groupOracleASM
- Oracle修改spfile的位置Oracle
- 恢復SPFILE檔案