We do not know which problem you are talking about? We are not psychic here. Did you flush shared pool? There is nothing like purging shared pool. Tell us about the problem which lead you to restart the system.
Yes, I am talking about the flushing the shared pool. The tool was keep on throwing an error saying that "table does not exist" though with all the permissions. We flushed the shared pool-no improvements. Finally we bounced the database and the problem went away.
What could be the reason ??
1 person found this helpful
There is not any relationship between the error you got and flushing shared pool. With NO re-producible case, it is hard to give any explanation on your problem. I suggest you mark this question an answered and open a new thread when next time you get the same problem but before restarting the database.