the number of concurrent queries

From: Gurelei <gurelei_at_yahoo.com>
Date: Fri, 21 Mar 2003 06:22:51 -0800 (PST)
Message-Id: <24738.322697@fatcity.com>

Hi.

I'm trying to get a feel of the number of the queries executed at the same time against a database. I have been using the following script (actually this is a part of a script)

Select a.type, count(1) col1
from v$session a,

     v$process b
where
a.paddr=b.addr

and a.status like 'ACTIVE%'
and a.type <> 'BACKGROUND'
and a.osuser <> 'oracle'

I want to see only ACTIVE sessions, not-background and not executed by oracle. Does anyone see anything wrong with that?

thanks
Gene

---

Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com Received on Fri Mar 21 2003 - 08:22:51 CST