File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to trace SQL statements ?

 
Horaci Macias
Ranch Hand
Posts: 74
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1157
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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,
Sandeep

 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic