6123550 consistent gets.. so many gets, doesnt it ring bell??


I am suspecting that the run time plan is going for Index Full Scan as against your explain pan showing Index Range Scan.. And when you give the hint, its obiviously going for Index Range scans and hence seeing o/p in 2 secs..

What you need to check is the SQL address and check the plan from v$sql_plan

Rgds
Abhay