Oracle - Instance Settings Stored in SPFile in Oracle

Instance Settings Stored in SPFile in Oracle

Q

Where Are the Settings Stored for Each Instance in Oracle?

✍: FYIcenter.com

A

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.

⇒Introduction to Oracle Database 10g Express Edition

⇒⇒Oracle Database Tutorials

2016-10-16, 364👍, 0💬

Popular Posts:

AND, OR, XOR, and NO...

What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...

Selecting Some Speci...

How To Select Some Specific Columns from a Table in a Query in SQL Server? If you want explicitly te...

BEGIN ... END Statem...

How to put statements into a statement block in SQL Server Transact-SQL? You can put statements into...

Using SELECT Stateme...

Can SELECT Statements Be Used on Views in SQL Server? Select (query) statements can be used on views...

CREATE VIEW - Creati...

How To Create a View on an Existing Table in SQL Server? If you want to a view on an existing table,...