Hibernate version:
2.1.6

DB:
Oracle 9.2.0

OS:
AIX 5.3

Hi,
We have developed system that perform batch processing in Oracle 9i. Simply it read date from file insert to DB after calculate few things and generate output files.

This system works enought fast on Windows, but when we have moved to AIX it works very slow...

I can write that on my laptop (1.6GHz Centrino,515MB, Sun JVM 1.4.2) where I've installed our Java system and when I've started Oracle system calculate around 40 contracts per seconds (producing around 1000-2000 output rows). When I've moved to AIX 5.3 (LPAR with one virtual processor and 2GB RAM + 8 HDD in RAID FiberChannel+ IBM JVM 1.4.2) systems calculate ONLY 2 contracts per seconds - 20 times slower. But this AIX is the newest server

I've started vmstat and I've discovered that only few percent (peak was 20%) goes to "user time" most of the time goes to "idle". I think that something is wrong with Oracle<->Java (Hibernate) communicatio but I have no idea what is wrong.

Any suggestions?

By accident I've sent post without Subject, sorry

Could be anything - may even be an issue in your DNS server during Oracle Names lookup. Times out then used a secondary method to find the datasource. Good luck.

Currently I use following hibernate.properties to connect to Oracle:

hibernate.connection.driver_class=oracle.jdbc.driver.OracleDriver
hibernate.connection.url=jdbc:oracle:thin:@127.0.0.1:1524:finca
hibernate.connection.username=xxx
hibernate.connection.password=xxx
hibernate.dialect=net.sf.hibernate.dialect.Oracle9Dialect
hibernate.show_sql=false


As you see I use localhost, do you think that it is something with DNS?

How often this Oracle Names lookup is performed during hibernate operation ?

Reagards

You can try using tnsping to get an indication of any network issues.

If you run your app local to the database box, try using the oci drivers rather than the thin.

Hi,
There was problem with LPAR configuration, I will know what exaclty happend on Monday. I after reconfiguration our program has used 100% of CPU and it is right. Now program runs 20-30 faster than before ! I will make some test on AIX with OCI because currently we use thin driver. I've check OCI on my PC but performance was not so good as with thin. But I think in our situation DB performance and DB communication is not a issue now - it works very fast. Now we have to optimise Java performance.
By the way when we finish our project I will send long mail about is it possible to use Hibernate and where it makes sense in batch processing (in our solution we have around 1mln input rows and about 17mln output rows). We use mixed solution Hibernate / PL/SQL.

Regards
Michal Szymanski

Thin driver performance better than OCI driver?!? I find that *very* hard to believe.

Yes I know that is hard to belive but it can be true :)

Look at "Java Programming with Oracle JDBC" chapter "19.8 OCI Versus Thin Drivers":

"type of operation except executions of CallableStatement objects. On a Unix platform, my
experience has been that the CallableStatement numbers are tilted even more in favor of the
OCI driver. Nonetheless, you can feel completely comfortable using the Thin driver in almost any
setting. The Thin driver has been well-tuned by Oracle's JDBC development team to perform
better than its OCI counterpart."

I will send my result when we install our soft on AIX system...we will see what happen.