Re: Overall executions at DB level

Spendius wrote:
> 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

Try:
SELECT
  NAME,
  VALUE
FROM
  V$SYSSTAT
WHERE
  NAME IN ('user calls', 'recursive calls');

'user calls' is the number of login, parse, fetch, and execute requests since the database instance last started. 'recursive calls' will include trigger SQL executions and space management calls. If you don't want to include parse calls, subtract the value for 'parse count (total)' from the same view. If you do not want to include logins, subtract the value for 'logons cumulative' from the same view.

SELECT
  SUM(DECODE(NAME,'user calls',VALUE, 'recursive calls', VALUE, 'parse count (total)', -VALUE, 'logons cumulative', -VALUE, 0)) FROM
  V$SYSSTAT; The above should provide an answer that is close.

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc. Received on Thu Aug 10 2006 - 08:16:13 CDT