On Thursday 31 May 2001 04:55, Lages, Carl wrote:

> select instance from v$thread; will return sid

That does not technically return the SID. That is
the instance name, which is not required to be
identical to the SID.

While it is true that the SID normally matches the
instance name, it is not required.

Someone else was asking about this a few days ago,
and his SID's did *not* match the instance name.

There is no way to query the SID, it is external to the db.

Jared
Oracle LazyDBA home page