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'? These connections goes away in few minutes. It seems to
me that some of the disconnected sessions by the applications are hanging in
the database and its released after few minutes. The database is on HP-UX
11.11 & Oracle 9.2.0.5.
Thanks,
Raja.
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Mar 17 2005 - 02:46:31 CST
