Re: which server am I on?
From: Jim Gregory <jim.gregory_at_daytonoh.ncr.com>
Date: 1996/12/19
Message-ID: <E2oExv.MBA_at_intruder.daytonoh.ncr.com>#1/1
Date: 1996/12/19
Message-ID: <E2oExv.MBA_at_intruder.daytonoh.ncr.com>#1/1
To get server name:
select distinct machne from v$session;
To get database::
select name from v$database
HTH
Jim Gregory
>==========L. Tseng, 12/18/96==========
>
>Is there an easy way to tell what server your are on in a SQL*Plus
>session? How about the way to show the database/instance for the
>session? I found myself frequently confused over having serveral
>sql*plus sessions connecting to different Oracle servers (local,remote)
>and instances.
>
>Thanks,
>
>Leslie
>
Opinions expressed are mine and do not reflect those of my company or clients. Received on Thu Dec 19 1996 - 00:00:00 CET