Re: Overall executions at DB level

From: Gints Plivna <gints.plivna_at_gmail.com>
Date: 10 Aug 2006 06:40:09 -0700
Message-ID: <1155217209.219563.143570@m73g2000cwd.googlegroups.com>

Ana C. Dent wrote:
> "Spendius" <spendius_at_muchomail.com> wrote in news: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
> >
> >
>
> SO?
> Not all SQL is created equal.
> SELECT SYSDATE FROM DUAL;
> is much less resource intensive than a SELECT doing a 12 table join.
> By your methodology they both would count the same.

And you offer what?
Giving some ratio to each SQL statement? :)

Gints Plivna
http://www.gplivna.eu Received on Thu Aug 10 2006 - 08:40:09 CDT