I am using oracle 8.1.7. I have an application that uses up to 400MB of memory on the oracle process when documents are being processed, but this memory is not released when processing finishes.
As a result, users of the a performance degradation. Has anyone had such an experience and suggestions on what to look at for to troubleshoot.

Thanks in advance