Re: Tool to track what all is happening in database when i run an oc4j application

From: Rohit <>
Date: Tue, 9 Dec 2008 13:52:22 -0800 (PST)
Message-ID: <>

> Hey thanks for information. I agree that i need to get familiar with
> Oracle but will you let me know if with this tracing option turned
> on , can i get info about the actual tables touched , what update (if
> possible actual row/column level change) happened to it. While i study
> these things , just let me know if at all its possible to reverse
> engineer whole schema that application is using.
> -Rohit

[Quoted] I tried oracle Enterprise manager and was able to see some queries by performing few operations in application. So i got the idea of it.One still i am confused about is, is there a way to find how different tables are related to each other ? meaning relationship schema for all tables in a table space. Or is this completely logical thing and there is not such information maintained at table space level and only the application which uses those tables know what is the relation. Coz if this is the case , i will have to perform hell lot operations to get the complete picture of relation ships between different tables. Received on Tue Dec 09 2008 - 22:52:22 CET

Original text of this message