from where you are running this query? directly in the DB server or from any third party?

trace the session and see what it is doing.

Thanks,