File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Oracle/OAS and the fly likes How to trace SQL statements ? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "How to trace SQL statements ?" Watch "How to trace SQL statements ?" New topic

How to trace SQL statements ?

Horaci Macias
Ranch Hand

Joined: Nov 08, 2001
Posts: 74
I'm using EJB + Oracle8i, and I would like to trace all SQL statements made to Oracle, or all SQL statements made to a table in Oracle, to tune my code.
Anybody knows how can I do it ?
Thanks in advance,
Horaci Macias
Desai Sandeep
Ranch Hand

Joined: Apr 02, 2001
Posts: 1157
Hi Horaci,
Have you deployed the EJB in Oracle 8i DB?
If you are using Oracle JDeveloper as an IDE for deployment,this IDE provides you a feature to view SQL statements which is used by the EJB.I believe a similar fearure exists with the Oracle Application Server also.
In general, I suppose you need to look at tools provided by Container Vendors for tracing SQL statements.
Hope this helps,

I agree. Here's the link:
subject: How to trace SQL statements ?
It's not a secret anymore!