This week's book giveaway is in the Design forum.
We're giving away four copies of Building Microservices and have Sam Newman on-line!
See this thread for details.
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

Win a copy of Building Microservices this week in the Design forum!
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,

Have you checked out Aspose?
subject: How to trace SQL statements ?
It's not a secret anymore!