Re: ORA_SID in Sql*Plus?

Douglas Scott wrote:
>
> Does anyone know if there is a way to find out what database instance
> you're in from inside of Sql*Plus? I go in and out of 2 instances all
> day long (beta & production databases) and sometimes lose track of which
> one I'm in (especially after an interruption like a meeting). I could
> get out and come back in, but if there is someway to tell which instance
> it would be easier.
>
> Douglas Scott
> dsscott_at_gte.net

connect as system/manager (or any user with dba role) and do
SELECT *FROM V$DATABASE;

-- 
  AMARENDRA B NETTEM ( http://www.iit.edu/~nettama)
  ORACLE CONSULTANT
  WHITTMAN-HART CORPORATION
  CHICAGO.