Forum OpenACS Q&A: Response to something like vacuum analyze or compact database for Oracle?

As far as I understand (and I use Oracle regularly) there is no such equivalent. The reason is that Oracle doesn't need to clean itself up -- you might say that its design is slightly superior in this respect.