thank you
--- Stephane Paquette
<[EMAIL PROTECTED]> wrote:
> 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).
>
__________________________________________________
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).
