RE: the number of concurrent queries

From: Stephane Paquette <stephane.paquette_at_standardlife.ca>
Date: Fri, 21 Mar 2003 11:08:46 -0500
Message-Id: <24738.322713@fatcity.com>

I do not think that you could record the number of concurrent queries. On the other hand, you can record the number of concurrent transactions. That is what your query will do.

Another way is to use statspack.
We're running statspack on our 22 production instances at each hour. We're keeping 2 months of stats.
We have a central point collecting data through views on statspack tables and producing nice graphs ....

My next job is to convince that we should monitor jobs also.

Stephane

-----Original Message-----

From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Gurelei Sent: Friday, March 21, 2003 9:24 AM
To: Multiple recipients of list ORACLE-L Subject: the number of concurrent queries

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
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Gurelei
INET: gurelei_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Mar 21 2003 - 10:08:46 CST