Who knows the answer?

From: Antonio Pascual <apa_at_jerez.micro.lucent.com>
Date: Thu, 23 Sep 1999 11:56:16 +0200
Message-ID: <7sctet$bhv@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 - 04:56:16 CDT