Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: SID - riddle

Re: SID - riddle

From: David Fitzjarrell <oratune_at_aol.com>
Date: Fri, 12 Jan 2001 21:22:40 GMT
Message-ID: <93nsim$40c$1@nnrp1.deja.com>

In our last gripping episode "Marek Smith" <m.rezac_at_sh.cvut.cz> wrote:
> Hi!
> I am writing the documentation for my application and I need to
 describe the
> meaning of SID. Now I realized I had never known what that shortcut
 exactly
> menas... I tried to find it in original documentation but I failed. I
> suppose that the full meaning is very good hidden. Can you help me?
 Thank
> you.
> Marek
>
>

The meaning is not hidden:

            SID: system identifier

I found it quite clearly in the documentation in a great number of places. The definition, from the documentation:

Oracle System Identifier (SID)

A name that identifies a specific instance of a running pre-release 8.1 Oracle database. For an Oracle Parallel Server database, each node within the cluster has an instance referencing the database. The database name, specified by the DB_NAME parameter in the initdb_name.ora file, and unique thread ID make up each node's SID. The thread ID starts at 1 for the first instance in the cluster, and is incremented by 1 for the next instance, and so on.

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com
http://www.deja.com/
Received on Fri Jan 12 2001 - 15:22:40 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US