Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
sql statement
- Thread starter glj
- Start date
SantaMufasa
Technical User
GLJ,
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.
![[santa]](/data/assets/smilies/santa.gif "[santa] [santa]")
Mufasa
(aka Dave of Sandy, Utah, USA @ 15:58 (30Aug04) UTC (aka "GMT" and "Zulu"), 08:58 (30Aug04) Mountain Time)
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)
- Thread starter
- #3
- Status
Similar threads