If the presence of bind variables is your only difference, then I'd look at the setting for CURSOR_SHARING. This might be set to FORCE, which probably isn't what you want to use on a 9.2.0 installation. Instead, try using SIMILAR or EXACT.
Dig deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.