Thread: Determining DML is used most???

Determining DML is used most???

From
"King_Henree@yahoo.com"
Date:
Hello All,

I am using Java J2EE with CMP 2.0 with finders and
selectors with a JBoss 3.0.4 application server and
would like to determine which queries and other DML
are being executed the most.  I have thought about
setting up triggers to execute and populate a table
with that information every time a DML statement is
ran, but that does not solve the problem of
determining which SELECT statements are being run
most.  Does anyone have any solutions for this?

Thanks.

__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com