Each row of "V$SQLAREA" contains a SQL statement that is currently being executed. The column "EXECUTIONS" tells how many times that statement has been executed this load. If a particular SQL statement does not get executed over a period of time, then another SQL statement takes its place; then later (upon re-execution) you may find the original statement back in V$SQLAREA. The Oracle server reparses the statement and EXECUTIONS is at 1 again.
Although I have never tried it, it seems to me that you could create a trigger on the underlying table from which V$SQLAREA draws its data.
Mufasa
(aka Dave of Sandy, Utah, USA @ 15:58 (30Aug04) UTC (aka "GMT" and "Zulu"), 08:58 (30Aug04) Mountain Time)
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.