Find out how often SQL is run
- From: Ingrid Voigt <GiantPanda@xxxxxxx>
- To: Oracle-l@xxxxxxxxxxxxx
- Date: Wed, 17 Feb 2010 21:02:20 +0100
Hi,
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.
Regards
Ingrid Voigt
--
//www.freelists.org/webpage/oracle-l
Other related posts:
