How to keep your DB clean
FYI - FIS' Oracle Best Practices guide contains some helpful information on keeping your Oracle DB clean. In particular, the guide mentions the RARPTTRN.bat process, which runs the QT Clean stored proc (spQtClean) to purge temporary data, especially in the webbinfiles* tables, which are the biggest data hogs. If I remember correctly, the QT Clean stored proc will only delete records from webbinfiles* if the records are flagged with WebCd = 'A'. In addition, I think the stored proc is missing the webbinfilescontent table, so if you decide to use the stored proc, you might need to modify it to handle all the webbinfiles* tables. However, a better approach would probably be to make a copy of the QT Clean stored proc, and modify it to meet your needs.
@douglaswalker