hi, the count of 7 could just be the list of background process running on your system , pl. add username is null in the where clause of your statement that will take care of this problem Regards Kurian On Tue, 22 Feb 2005 14:08:46 -0800 (PST), Nisar Tareen <ntareen@xxxxxxxxx> wrote: > 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. > >