RE: the number of concurrent queries

thank you

• Stephane Paquette <stephane.paquette_at_standardlife.ca> 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
  > <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
  > > >
  > >
  >

  ---

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