Re: determine from some table which instance you are in

On Thu, 23 Aug 2001, jeff.kish_at_ait-mmii.com wrote:

> Is there any table or view I can query to find out the Oracle
> instance that I am connected to as a certain user? What about
> the machine name?

select instance_name, hostname from V$INSTANCE;

-- 
Galen Boyer
It seems to me, I remember every single thing I know.