Re: How to identify the 'current' instance
From: Loyal Barber <lbarber_at_ix.netcom.com>
Date: 1996/10/15
Message-ID: <3263BB1C.2714_at_ix.netcom.com>#1/1
Date: 1996/10/15
Message-ID: <3263BB1C.2714_at_ix.netcom.com>#1/1
j4xprel_at_pbsrv10.isp.pacbell.com wrote:
>
> running under hp-ux, after exporting ORACLE_SID=TST, TWO_TASK=DEV and
> then logging on to sql*plus with 'sqlplus user_id_at_T:host_name:PRD' is
> there any way to query the correct current instance?
>
> thanks in advance.
select value
from v$parameter
where name = 'db_name'
/
Loyal Received on Tue Oct 15 1996 - 00:00:00 CEST