Stephane:
Why do you think if would records the number of
concurrent transactions, but not the queries? what is
the difference from the v$session standpoint/
- Stephane Paquette
<stephane.paquette_at_standardlife.ca> wrote:
> 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: 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).
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: Stephane Paquette
> INET: stephane.paquette_at_standardlife.ca
>
> 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 - 11:26:55 CST