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?

Thanks.

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

---------------------------(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