Re: Who knows the answer?

select name from v$database;
gives you the database name;

select distinct machine from v$session where type='BACKGROUND'; gives you the instance machine;

Antonio Pascual a écrit dans le message <7sctet$bhv_at_nntpb.cb.lucent.com>...
>This is a stupid question, but I don't know the answer and I've couldn't
>find
>anyone who knows it.
>Imagine.
>I have in my Unix workstation 3 or 4 sqlplus opened sessions. Each of one,
>connected to a different host,
>
> SESSION 1: sqlplus user1/pass1_at_host1
> SESSION 2: sqlplus user2/pass2_at_host2
> SESSION 3: sqlplus user3/pass3_at_host3
>
>I go to lunch, and when I back, I don't know what session is 1, or 2 or 3.
>How could i know the host for each session.
>
>With the command, shows the user
>SQL> show user
>user is user1
>
>but, if the user is equal for all sessions?.
>
>Thanks.
>
>
>
Received on Thu Sep 23 1999 - 06:53:41 CDT