Hi,
We have a heavily used application that uses hibernate in a number of areas to query an Oracle database (10.2.0.4). Our DBA's have notified us of a problem with a high version count for particular inserts and updates generated by hibernate, that is causing a problem with the application scaling. We're seeing a large number of similar but slightly different inserts and updates for certain heavily used tables.

For example, we have a sender table with about 50 columns. Within the sql area, we see many different insert and update statements, with different combinations of columns that are being inserted and updated each time. It's likely that these different combinations are all valid (as in columns left out of particular combinations are null anyway) but all these different queries are filling up the shared sql area portion of the SGA - which will kill us eventually.

If I have to move away from using hibernate and hand code these inserts and updates then I will, but if there was some way to get hibernate to generate consistent inserts and updates for particular objects then that would be cool and save me a few days of coding.

Any help would be appreciated

Regards
Denis