[askdba] Re: [dba_gurus] count from v$session

  • From: Nisar Tareen <ntareen@xxxxxxxxx>
  • To: Ananth Antony <ananth_a_75@xxxxxxxxx>, dba_gurus@xxxxxxxxxxxxxxx
  • Date: Tue, 22 Feb 2005 14:08:46 -0800 (PST)

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?


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:
   To unsubscribe from this group, send an email to:
   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.

Other related posts: