host_name from v$instance mystery

From: <kal121_at_my-deja.com>
Date: 2000/04/14
Message-ID: <8d5r04$qc4$1@nnrp1.deja.com>#1/1

Where does Oracle get the host_name in the v$instance table?

The reason I ask is, on one machine, the host_name is simply the machine name, for example: DARTHVADER

On another machine, the host_name is the fully qualified domain name, for example: LEIA.DEV.MYCOMPANY.COM

Why is this? I like to display the host_name in my prompt, but having the full name display is too long! How can I fix it so that it only shows LEIA, not LEIA.DEV.MYCOMPANY.COM?

Thanks

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Apr 14 2000 - 00:00:00 CDT