Collections:
Other Resources:
Instance Settings Stored in SPFile in Oracle
Where Are the Settings Stored for Each Instance in Oracle?
✍: FYIcenter.com
Settings for each instance are stored in a file called Server Parameter File (SPFile). Oracle supports two types of parameter files, Text type, and Binary type. parameter files should be located in $ORACLE_HOME\database directory. A parameter file should be named like "init$SID.ora", where $SID is the instance name.
2016-10-16, 204👍, 0💬
Popular Posts:
How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...
Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...