Re: which server am I on?

From: Jim Gregory <jim.gregory_at_daytonoh.ncr.com>
Date: 1996/12/19
Message-ID: <E2oExv.MBA@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 CST