select * from v$sysstat where NAME in ('user commits','user rollbacks');
-----Original Message-----
Sent: Monday, March 24, 2003 7:54 AM
To: Multiple recipients of list ORACLE-L
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
<[EMAIL PROTECTED]> 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
> <[EMAIL PROTECTED]> 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: [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).
> >
>
>
> __________________________________________________
> 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).
>
__________________________________________________
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).
