Where Are the Settings Stored for Each Instance
Q
Where Are the Settings Stored for Each Instance? - Oracle DBA FAQ - Introduction to Oracle Database 10g Express Edition
✍: 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.
2007-04-25, 5030👍, 0💬
Related Topics:
