Actually this is kind of vauge but maybe someone can point me in the right direction to start looking for an answer...
We have a view that has been workin on our system for over a year. As of yesterday whenever it is accessed it just hangs the client and the Oracle proccess has to be ended and the client killed, I also have tried to run and explain plan on it and it still hangs. I am thinking maybe it was somehow corrupted and maybe I should rebuild it???