Re: In 7.3, v$instance does not show the current instance

From: Jeffrey Hunter <jhunter_at_fore.com>
Date: Sun, 09 Jan 2000 07:56:59 -0500
Message-ID: <3878859B.80C3BE22@fore.com>

elee3_at_my-deja.com wrote:

> In 7.3, v$instance does not show the current instance. But in 8.0, it
> does. Which v$view will show the current instance name in Oracle 7.3??
>
> Thanks.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

You can use v$thread.

SQL> select * from v$version;

BANNER

---

Oracle7 Server Release 7.3.4.4.0 - Production PL/SQL Release 2.3.4.4.0 - Production
CORE Version 3.5.4.0.0 - Production
TNS for Solaris: Version 2.3.4.0.0 - Production NLSRTL Version 3.2.4.0.0 - Production

SQL> select open_time, instance from v$thread;

OPEN_TIME INSTANCE

-------------------- ----------------

12/20/99 12:25:45 ERPDB Cheers,
-- jeff

---

Jeffrey M. Hunter                   Email:  jhunter_at_fore.com
Senior Database Administrator       Office: 724.742.7435
Marconi Communications              Pager:  888.704.5610
2000 FORE Drive                     Fax:    724.742.6800
Warrendale, PA 15086-7566           Web:    www.marconi.com
-------------------------------------------------------------

Received on Sun Jan 09 2000 - 06:56:59 CST