[askdba] Re: [dba_gurus] count from v$session
- From: Abraham Kurian <kurian24@xxxxxxxxx>
- To: askdba@xxxxxxxxxxxxx
- Date: Thu, 24 Feb 2005 13:02:13 +0530
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.
>
>
Other related posts:
