Re: Machine Name as 0.0.0.0 in V$session

Subbiah, Nagarajan wrote:

>The query 'select username,machine,count(1) from v$session group by
>username,machine' gives the machine name as '0.0.0.0' for some of the users
>intermittently especially when there are high number of connections
>established from the application server. Any idea about why the machine name
>shows as '0.0.0.0'?
>
>

Raja, I can think of two things only:
1) Oracle bug. For some reason, oracle is unable to properly read machine name.
2) Machine misconfiguration. What does "hostname" command show? Is the machine

    on the name server? Is the name in /etc/hosts?

-- 
Mladen Gogala
Oracle DBA
Ext. 121


--
http://www.freelists.org/webpage/oracle-l