Oracle FAQ

Your Portal to the Oracle Knowledge Grid

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

Home -> Community -> Usenet -> c.d.o.server -> Re: How to get the INSTANCE and SID name via SQL

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

From: Robert Weiss <roweiss_at_web.de>
Date: Sun, 10 Nov 2002 19:34:28 +0100
Message-ID: <aqm8rl$bet8g$1@ID-6705.news.dfncis.de>

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 Received on Sun Nov 10 2002 - 12:34:28 CST

This message: [ Message body ]
Next message: Howard J. Rogers: "Re: Standby database question"
Previous message: Vladimir M. Zakharychev: "Re: Free E-mail Server"
In reply to: Anton Buijs: "Re: How to get the INSTANCE and SID name via SQL"
Next in thread: Sybrand Bakker: "Re: How to get the INSTANCE and SID name via SQL"
Reply: Sybrand Bakker: "Re: How to get the INSTANCE and SID name via SQL"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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