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, 179👍, 0💬

Popular Posts:

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,...

Verifying SQL Server...

How do you know if SQL Server is running on your local system in SQL Server? After installing SQL Se...

Define External Tabl...

How To Define an External Table in a Text File in Oracle? You can use the CREATE TABLE statement to ...

DDL (Data Definition...

What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...

Define External Tabl...

How To Define an External Table in a Text File in Oracle? You can use the CREATE TABLE statement to ...