Re: Server ID.

From: Mark Malakanov <malakanov_at_sapience.ca>
Date: Thu, 14 Oct 1999 17:59:10 -0400
Message-ID: <CZAuc3oF$GA.196@mailserver.corvis.ru>

Andrey ,

select decode(s1.machine, s2.machine,'I''M ON SERVER','I''M ON WORKSTATION') from v$session s1,v$session s2
where s1.audsid=userenv('sessionid')
and s2.SID=1;

Enjoy!
Mark Malakanov
OraDBA
Sapience, Toronto

Andrey Petrashenko wrote in message
<3805E13C.6C7AFF08_at_scs.ntu-kpi.kiev.ua>...
>Hello!
>
>Can anybody tell me the simplest method to recognize that I'm working on
>Server machine (not client workstation) ?
>Maybe registry entries or query...
>--
>&y.
Received on Thu Oct 14 1999 - 16:59:10 CDT