Re: Oracle server name in SQL prompt

From: Winnie Liu <winnie_liu_at_infonet.com>
Date: Tue, 28 Sep 1999 22:35:35 -0700
Message-ID: <7ss8k2$2f5$1@birch.prod.itd.earthlink.net>

I get it in a kind of dump way. I do a query on V$sesion and find out the column "machine" in which one of the bg process like 'smon' is running on.

I know.. this method does not work on parallel server!

Winnie Liu
DBA
Infonet Services Corporation
mailto:winnie_liu_at_infonet.com

Michael Morley wrote in message ...
>Anybody know how to put the name of the host server into the SQLPROMPT
>SQLPlus parameter? I can get the instance name but not the server name.
>
>Thanks.
>
>Mike M
>
>
Received on Wed Sep 29 1999 - 00:35:35 CDT