Thanks dave.

But stats are collected everyday for remote tables,so its not the issue.
We are accessing the tables through DB link and we are joining around 7-8 remote tables in the select queries. Few tables does contain lots of data. What will you recommend?