Instance
From Oracle FAQ
⧼orafaq-jumptonavigation⧽⧼orafaq-jumptosearch⧽
An Oracle Instance is a running Oracle Database made up of memory structures (SGA) and background processes (SMON, PMON, LGWR, DBWR, etc.). An instance only exists while it is up and running.
Simply put, a database resides on disk, while an instance resides in memory.
A database is normally managed by an instance. However, when using RAC, multiple instances can be started for a single database (on different nodes of a cluster). Each instance is identified with a unique identifier known as the ORACLE_SID.
| Glossary of Terms | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | # |
