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-----
Sent: Friday, March 21, 2003 9:24 AM
To: Multiple recipients of list ORACLE-L
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephane Paquette
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
