I faced this problem earlier. I found user has given very big process and it has eaten up all the resources.

You may want to increase the size of Library Casche. You should be OK.

Infact, restarting the DB should be OK. As long as the query is not running same query.

Try and let me know the result