Is there a way to see the real sql given to the database

saro · **Posted:** Thu May 27, 2004 11:42 am

Environment Info
Hibernate : 2.1
Database : Oracle 9

I'm in to the performance tuning of my system. Needs to see how long it takes for different querys to execute under different load conditions. Based on this I might need to tweak some logics, queries here and there.
I'm gonna use some SQL profiler. Means I need to get the exact sql statement that's been given to the oracle, to use it in my SQL profiler. Currently I see the hibernate query(i.e ORM query) by having my show_sql true.
So could some pls let me know how do I get to see the exact SQL given to my db, oracle. Thanks in advance..

christian · **Posted:** Thu May 27, 2004 11:43 am

http://www.hibernate.org/27.html

Check the "Database utilities".

max · **Posted:** Fri May 28, 2004 5:06 pm

you could also start out with enable the SQL logging category. Look in log4j.properties and/or docs about it.