Re: Definitions Help

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: 1997/09/26
Message-ID: <01bcca60$4c2fbf40$ba030059@billyv.vslabs.co.za>#1/1

David Parry <dparry_at_nu-pharm.com> wrote in article <342A7721.3B8F_at_nu-pharm.com>...
> What is the definition and difference between:
>
> 1)Database
> 2)Instance
> 3)SID
OK, I'm going to have a stab at it with a simple and pure technical definition. All flames to /dev/null please. :-)

Database = files/raw devices that are used for storing data and indexes for tables, and other database/system related information and structures.

SID = (system id) the name given to an Oracle database (see initSID.ora and v$database).

(but a SID can also be:)
SID = (session id) Oracle id for a session (see v$session).

Instance = database engine - multiple database engines can run for the same database (see v$instance and v$active_instances)

Er..I hope I haven't confused you. :-)

regards,
Billy Received on Fri Sep 26 1997 - 00:00:00 CDT