| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Re: return hostname in PL/SQL
Charlie Mengler schrieb am 23.05.00:
> Here is what I did just yesterday -
>
> HTH!
>
> DECLARE
> CURSOR machine_cur IS
> select machine from v$session
> where program like '%PMON%';
>
Hi,
but what if your server is running on an non-unix-machine? On NT, your program would be ORACLE80.EXE (not like '%PMON%').
I would select from v$session where TYPE = 'BACKGROUND' for this purpose.
If you only want the host name, it would be better to select TERMINAL; again, on NT you get for machine 'DOMAIN\HOSTNAME' rather than 'HOSTNAME'.
Cheers,
Jose
 |
 |