> P.S. I'm a Java developer and I cannot understand your sentence about Java > apps. > Usually well instrumented Java apps can give enough information as > non java-ones. > Some of mine could also enable 10046 event for the session under > investigation and report query elapsed time and app server elapsed > time . Your are good example then. But even you are saying that java app "almost" as non java-ones. You have to instrument it. You need to do it in addition. Most of non java-ones have it build in (or a clear relation ship session = connection). Most of java-ones usually are not instrumented :( This is the difference, at least so far. -- Jurijs +44 7738 013090 (GMT) ============================================ http://otn.oracle.com/ocm/jvelikanovs.html -- //www.freelists.org/webpage/oracle-l