Re: Find out how often SQL is run
Date: Thu, 18 Feb 2010 06:11:46 +0100
> Do I have to schedule a job to query v$sqlarea regularly?
That would be my approach.
Almost all information you mention is in there (if TIMED_STATISTICS=true):
- elapsed time (total)
- cpu time (total)
- open versions (number of "childs")
And you can use this per child:
to get (different) execution plans used.
On Wed, Feb 17, 2010 at 9:02 PM, Ingrid Voigt <GiantPanda_at_gmx.net> wrote:
> I need to find out how often a particular query (identified by
> SQL id) is run. If possible also how long executions take and
> if the execution plan varies. Database version is 10.2.0.4 Standard
> Edition on Windows.
> Do I have to schedule a job to query v$sqlarea regularly? Or is there
> something better (Statspack?)
> Thanks for your help.
> Ingrid Voigt
-- Toon Koppelaars RuleGen BV Toon.Koppelaars_at_RuleGen.com www.RuleGen.com TheHelsinkiDeclaration.blogspot.com (co)Author: "Applied Mathematics for Database Professionals" www.RuleGen.com/pls/apex/f?p=14265:13 -- http://www.freelists.org/webpage/oracle-lReceived on Wed Feb 17 2010 - 23:11:46 CST