Collections:
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.
2020-09-15, 782👍, 0💬
Popular Posts:
What is mscorsvw.exe - Process - Microsoft .NET Framework NGEN in SQL Server? Process mscorsvw.exe i...
How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...
How To Enter Unicode Character String Literals in SQL Server Transact-SQL? Unicode characters are mu...
Where to find answers to frequently asked questions on Oracle basic concepts? I am new to Oracle dat...
Where to find answers to frequently asked questions on Using INSERT, UPDATE and DELETE Statements in...