Ananth, Why not to diplay the username, status and check which sessions are these and which mode. Nisar Tareen Ananth Antony <ananth_a_75@xxxxxxxxx> wrote: Hi Friends, I got the output like this. Here dbserver is my server name. no application running in that ...except the database. but since it is showing the sessions like below.. and too it present 2 times. whether this will affect the performace? Thanks Ananth SQL> select machine,count(*) from v$session group by machine; MACHINE COUNT(*) ---------------------------------------------------------------- ---------- DBSERVER 7 dbserver 34 --------------------------------- Do you Yahoo!? Take Yahoo! Mail with you! Get it on your mobile phone. [Non-text portions of this message have been removed] --------------------------------- Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/dba_gurus/ To unsubscribe from this group, send an email to: dba_gurus-unsubscribe@xxxxxxxxxxxxxxx Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. --------------------------------- Do you Yahoo!? Yahoo! Mail - Easier than ever with enhanced search. Learn more.