Thats my next step and need to coordinate with application group as these queries with lots of input values are given by PB application.

I flushed the shared pool yesterday and query was running instantaneously and when they complain again I will doing the trace as first step.

Thx anyway.