Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to trace SQL statements ?

 
Horaci Macias
Ranch Hand
Posts: 74
  • 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
  • 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

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic