Tool to track what all is happening in database when i run an oc4japplication

#31

On 09.12.2008 21:25, Rohit wrote:

Quote:

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.

Hey thanks for information. I agree that i need to get familiar with
Oracle

Definitively!

Quote:

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.

Quote:

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

#32

On 09.12.2008 21:25, Rohit wrote:

Quote:

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.

Hey thanks for information. I agree that i need to get familiar with
Oracle

Definitively!

Quote:

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.

Quote:

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

#33

On 09.12.2008 21:25, Rohit wrote:

Quote:

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.

Hey thanks for information. I agree that i need to get familiar with
Oracle

Definitively!

Quote:

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.

Quote:

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

#34

On 09.12.2008 21:25, Rohit wrote:

Quote:

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.

Hey thanks for information. I agree that i need to get familiar with
Oracle

Definitively!

Quote:

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.

Quote:

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

#35

On 09.12.2008 21:25, Rohit wrote:

Quote:

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.

Hey thanks for information. I agree that i need to get familiar with
Oracle

Definitively!

Quote:

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.

Quote:

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

#36

On 09.12.2008 21:25, Rohit wrote:

Quote:

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.

Hey thanks for information. I agree that i need to get familiar with
Oracle

Definitively!

Quote:

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.

Quote:

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Tool to track what all is happening in database when i run an oc4japplication

comp.databases.oracle.tools comp.databases.oracle.tools

Re: Tool to track what all is happening in database when i run anoc4j application - 12-10-2008 , 02:53 PM

Re: Tool to track what all is happening in database when i run anoc4j application - 12-10-2008 , 02:53 PM

Re: Tool to track what all is happening in database when i run anoc4j application - 12-10-2008 , 02:53 PM

Re: Tool to track what all is happening in database when i run anoc4j application - 12-10-2008 , 02:53 PM

Re: Tool to track what all is happening in database when i run anoc4j application - 12-10-2008 , 02:53 PM

Re: Tool to track what all is happening in database when i run anoc4j application - 12-10-2008 , 02:53 PM