Re: Machine Name as 0.0.0.0 in V$session
- From: Mladen Gogala <mgogala@xxxxxxxxxxxxxxxxxxxx>
- To: Nagarajan.Subbiah@xxxxxxxx
- Date: Thu, 17 Mar 2005 09:47:44 -0500
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
