Since both mod_perl and dynamic loading and unloading have been mentioned in same post I'd like to mention that dynamic loading of modules should be avoided in mod_perl scenario as it actually wastes more RAM. You should try to preload all modules you use during server startup. It is covered in mod_perl guide.
Another note is that no Module doesn't unload module. It simply calls module's unimport method. See perlfunc:use.