| Oracle Resources Home - ExamGuru.net - Your Portal for the IT Certification Practice Exam Questions | |
|
Oracle OCP Certification Exam Guides - Oracle DBA Interview Questions - ExamGuru.net Home
Oracle Topics: SQL | Pl/SQL | SQL*PLUS | Backup & Recovery | Init.ora Paramaters | Replication | RMAN | DataGuard | v$ Views | Oracle 10g | Oracle RAC | Performance Tuning & Monitoring |
Instance [Oracle] | ||
|
An instance is the (executed) Oracle software (Oracle processes) and the memory they use (SGA).
It is the instance that manipulates the data stored in the database.
System identifier (SID)
A SID identifies an instance.
This name is (usually on Unix) stored in the environment variable $ORACLE_SID.
In Windows, the SID can be entered into the ORACLE_SID.
Starting an instance
An instance can be started using the SQL*Plus startup command.
When an instance is started, it reads a file with instance configuration parameters from either the init.ora file or the spfile.
Links |