| Basic terminology problems! [message #90620] |
Wed, 26 May 2004 02:55  |
Ach
Messages: 26
Registered: April 2004
|
Junior Member |
|
|
Hi all,
Can anybody direct me on the exact meaning of these terms in Oracle,it seems these are a little different with related terms in Database theory:
1.Schema
2.Database
3.Database engine
4.instance
-thanks in advance
|
|
|
|
| Re: Basic terminology problems! [message #90623 is a reply to message #90620] |
Mon, 31 May 2004 15:24  |
William Robertson
Messages: 1643
Registered: August 2003
Location: London, UK
|
Senior Member |
|
|
A schema is the set of objects belonging to an account. It is often used as another way to refer to an Oracle account.
A database is a set of data. In Oracle it is physically located in a set of OS files.
"Database Engine" is used sometimes to refer to the various processes and tools that interpret commands, retrieve and modify data etc. I'm not sure there is a precise definition for this without further context.
An Oracle Instance is the set of processes and memory you get when you start and mount a database. An instance only exists while it is up and running. Although most installations have only one instance per database, it is possible to configure multiple instances using "Real Application Clusters" - the idea is to allow multiple servers to share the load.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
