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

Popular Posts:

CREATE TABLE - Creat...

How to create new tables with "CREATE TABLE" statements in SQL Server? If you want to create a new t...

sys.procedures - Lis...

How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to...

bin2hex - Converting...

How To Convert Binary Strings into Hexadecimal Character Strings in SQL Server? When a query returns...

CAST() - Converting ...

How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...

Calculating Age in D...

How To Calculate Age in Days, Hours and Minutes in SQL Server Transact-SQL? On many Web sites, news ...