Please explain what you mean by "respond properly"? Do you mean it never returns or it takes a long time (how much) or ...But still SQL doesn't respond properly.
Please share the explain plan. Better yet, share the tkprof output from the query execution.EXPLAIN PLAN doesn't show full table access for any of these tables
You do realize that you would have to help us by prividing such info that would allow us to help you.For some reasons, I can't share explain plan