Determining DML is used most??? 
Author Message
 Determining DML is used most???

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?


Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate

message can get through to the mailing list cleanly

Tue, 05 Jul 2005 03:10:49 GMT
 [ 1 post ] 

 Relevant Pages 

1. I am getting this message when i am tring to export or import anything using

2. Using char/varchar variable instead of object names when issuing DML commands

3. using the USER environment variable in DML statements

4. ora-04045 when using DML commands

5. Using VB to determine if a DSN uses integrated security

6. Use of @am, Am I dumb?

7. Busy Day = Slowdown from 12 AM - 5 AM

8. error ORA-01855: AM/A.M. or PM/P.M. required

9. Which rollback segment am I using NOW?

10. which table am I using ?

11. Which version of 6.5 am I using?

12. Can I add coulmn in my existing table which i am using for replication

Powered by phpBB® Forum Software