Re: SID stored in DB???

From: James Lorenzen <james_lorenzen_at_allianzlife.com>
Date: Wed, 26 May 1999 13:58:13 GMT
Message-ID: <7igulk$p8d$1@nnrp1.deja.com>

In article <374b07a0.374778963_at_news1.alterdial.uu.net>, mtackes_at_rgare.com (Matt) wrote:
> Is the database's SID stored anywhere in the database itself???
>

The SID is the instance identifier for the database. The database does not have a SID. The rules are a database (the disk structure) may be pointed at by one or more instances (the memory structures inaddition to the disk). An instance may only look at one database.

If you have only one instance per database, you can name them the same and get the answer from the v_$database view.

HTH
James

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Wed May 26 1999 - 08:58:13 CDT