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, 783👍, 0💬
Popular Posts:
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...
Where to find answers to frequently asked questions on Storage Engines: MyISAM, InnoDB and BDB in My...
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...
How to download Microsoft SQL Server 2005 Express Edition in SQL Server? Microsoft SQL Server 2005 E...
Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...