Re: SQL*Plus question (Where am I)

If you also need to know the server name (in case you have the same SID on multiple machines)...
SQL> select host_name,instance_name from v$instance;

Under normal installations, as a non-privileged user, you won't be able to see that view. If you want all users to see that information, and your DBA will do it, have him/her issue the following:

SQL> connect / as sysdba
SQL> grant select on v_$instance to public;

Kurt

Frank Cornacchiulo wrote:

> At the SQL*Plus prompt, is there a way of finding out what database I am
> logeed into?
>
> Thanks,
> FC
Received on Fri Oct 06 2000 - 10:06:17 CDT