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