Re: How to get the INSTANCE and SID name via SQL

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Sun, 10 Nov 2002 22:15:11 +0100
Message-ID: <h0jtsuch51q491hibsnh8f4ug1ms9a66db@4ax.com>

On Sun, 10 Nov 2002 19:34:28 +0100, Robert Weiss <roweiss_at_web.de> wrote:

>Anton Buijs wrote:
>
>> V$INSTANCE.INSTANCE_NAME is the name of the instance, what is the SID.
>
>V$SESSION.SID (the Session-ID)
>
>Mfg, Robert

No. The term 'SID' is used in several contexts. The poster was referring to the SID of the database. It is usually equal to the instance name, though in 8i and higher you can override the instance name.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sun Nov 10 2002 - 15:15:11 CST