Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: the number of concurrent queries
select * from v$sysstat where NAME in ('user commits','user rollbacks');
-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Gurelei
Sent: Monday, March 24, 2003 7:54 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: the number of concurrent queries
I guess I have been using a "sql statement" and a "query" interchangebly. I am using status = 'ACTIVE' to identify the sqls currently running. For the user commits and rollbacks, which table contain these values?
thank you
gene
--- Stephane Paquette
<stephane.paquette_at_standardlife.ca> wrote:
> v$session.status indicates that a sql statement is
> going on.
> I do not know any indicator on query.
>
> But you do have indicators on transactions.
>
> The total transactions are the sum of user commits
> and user rollbacks.
> Check those 2 statistics.
>
> Stephane
>
> -----Original Message-----
> Sent: Friday, March 21, 2003 12:29 PM
> To: Multiple recipients of list ORACLE-L
>
>
> 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
> >
>
-- 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 inReceived on Mon Mar 24 2003 - 08:11:16 CST
![]() |
![]() |