Forum OpenACS Q&A: Response to ACS Hangs after "Running scheduled proc sec_sweep_sessions"

Here is what I would check:

1.  old version of AOLserver - you should upgrade

2.  old version of Oracle driver that has a bug

3.  Setting of idle timeout for database connections - check the MaxOpen and MaxIdle settings in your nsd.tcl file and set to very high numbers

4.  size of your /tmp directory may be too small for the file being downloaded

These are the things I would check first.