Thanks for the reply Paul.

I agree with you. The tables used in the query have recent stats gathered. My concern is same query with simple parallel hint using cbo.

Thanks,