We might have
difficulty in the near future to compare the performance between 10g and
11g.
for 10g 10.2.0.4.0 64bit(ojdbc14-10.2.0.4.jar + 10G database):
for 10g 10.2.0.4.0 64bit(ojdbc14-10.2.0.4.jar + 10G database):
| b0ffw4gqmj634 | select synchronization_lock_datetime from it_entity_lock where extended_entity_name = 'IT_POOL' and primary_key_string = :1 for update |
for 11g 11.2.0.1.0 64bit (ojdbc6-11.2.0.1.jar + 11G database):
| bjkc1zp7z6q6n | select synchronization_lock_datetime from it_entity_lock where extended_entity_name = 'IT_POOL' and primary_key_string = :1 for update |
Can who kindly tell
us:
1) If the binary for
Application program to test 10g and 11g are different from each other
?
2) are there any SQl
changes to above Top SQLs ?
We are expecting the
SQL_ID/Hash Value should always be the same under different version
of compiler.
Different JDBC driver version casue this.
