Different explain plan with different oracle drivers
Hello,
OS: HPUX
DB: 11.2.0.4
I have an issue executing a query using different oracle drivers (ojdbc6 and classes12) from Java.
It's supposed the ojdbc6 is recommended for Oracle 11.2.0.4
I have executed a trace for both drivers.
With classes12 driver it execute fast
{noformat} (lowercase, curly brackets, no spaces)
| call | count | cpu | elapsed | disk | query | current | rows |
------- ------ -------- ---------- ---------- ---------- ---------- ----------
| Parse | 1 | 0.00 | 0.00 | 0 | 0 | 0 | 0 |
| Execute | 1 | 0.00 | 0.00 | 0 | 0 | 0 | 0 |
| Fetch | 265 | 0.12 | 0.23 | 13 | 5211 | 0 | 2641 |
------- ------ -------- ---------- ---------- ---------- ---------- ----------
| total | 267 | 0.12 | 0.24 | 13 | 5211 | 0 | 2641 |
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: 367 (MMR66E)
Number of plan statistics captured: 1
0