Originally posted by gbrabham
Your SGA has become fragmented ...
Your will have to restart the database to clear up the fragmentation.
Not necessary to restart - flushing the shared pool will do the trick.