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.
⇒ Change Settings in Binary SPFile in Oracle
⇐ Start the Default Instance in Oracle
2020-09-15, 1673🔥, 0💬
Popular Posts:
Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for ...
Where to find answers to frequently asked questions I am new to Oracle database. Here is a list of f...
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...
Where to find SQL Server Transact-SQL language references? You can find SQL Server Transact-SQL lang...
How To Create a Table Index in Oracle? If you have a table with a lots of rows, and you know that on...