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

On 09.12.2008 21:25, Rohit wrote:

>> First of all, it's called "tracing".  Then, you can trace an Oracle
>> session even without access to the source code of the application.
>> Assuming you have a recent release of Oracle you can enable session
>> trace via Grid Control / Enterprise Manager or an PL/SQL package.  You
>> could also write a login trigger which switches tracing on.

Definitively!

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

Yes, you can get at all the SQL executed.

> While i study
> these things , just let me know if at all its possible to reverse
> engineer whole schema that application is using.

You do not need to trace the application to reverse engineer the schema.   Just look at all table definitions and their relationships. There are views like USER_TABLES which exhibit information about all the tables. See the Reference document.

There are even tools like Toad, SQL Developer, Power Designer, Visio and many more that will give you a printable graphic representation of the schema.

Cheers

        robert Received on Wed Dec 10 2008 - 21:53:49 CET