ORA-4031 error and can't login to the db

hello,

i was applying the 11.5.10 maintenance patch for oracle 11i. the last phase of the patch is to recompile invalid objects. i recieved an ora-4031 trace file dump and everything is just hanging right now. i'm also not able to login to the database, either as sys or any user. it just sits there.

has anyone seen this happen before or knows what's going on? the 4031 trace seems to have been generated when trying to recomile a view. from my understanding, the 4031 tends to happens when the SGA is too small and it can't allocate any more memory to it. but how can i get into the db to shut it down and resize everything? i don't know why i'm unable to log in and don't know how to get around it.

help! :)

thanks in advance,
haroon

--
http://www.freelists.org/webpage/oracle-l