Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Overall executions at DB level

Overall executions at DB level

From: Spendius <spendius_at_muchomail.com>
Date: 10 Aug 2006 05:32:39 -0700
Message-ID: <1155213159.808984.286920@b28g2000cwb.googlegroups.com> 





Hi,


Do you think doing


SQL> SELECT SUM(executions) FROM V$SQL[AREA]
at regular intervals relevantly reflects the number of total
SQL executions whatsoever in your database ?
(I'm not sure as I've noticed sometimes that substracting
a value from the next one returns a negative number
- guess it's because in the meantime Oracle rid V$SQL
of a few statements...)



Thanks.


Spendius
Received on Thu Aug 10 2006 - 07:32:39 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US