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

Popular Posts:

RAND() - Generating ...

How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...

Running Queries with...

How to run Queries with "sqlcmd" tool in SQL Server? "sqlcmd" is a client tool that you can use to i...

Unicode Character St...

How To Enter Unicode Character String Literals in SQL Server Transact-SQL? Unicode characters are mu...

Downloading and Inst...

How to download and install Microsoft SQL Server Management Studio Express in SQL Server? Microsoft ...

"CREATE PROCEDURE" -...

How To Create a Simple Stored Procedure in SQL Server Transact-SQL? If you want to create a simple s...