Database stuff
There are a couple of interesting configuration properties to be set at $TOMCAT_HOME/OpenKM.cfg file.
The parameter hibernate.show_sql helps developer showing at log the SQL sentences generated by Hibernate. By default this parameter is set to false.
hibernate.show_sql=true
The parameter hibernate.statistics helps developer enabling the Hibernate statistics. By default this parameter is set to false.
hibernate.statistics=true
Use these parameters meaningful only for development and fine tuning.