Resetting Databases to Improve Performance

You can periodically reset a database and then reload it. Even if you reload a database very often, the main database (.pag) files can grow unless you reset the database.

  To reset a database, use a tool:

Tool

Topic

Location

MaxL

alter database appname.dbname reset

Oracle Essbase Technical Reference

ESSCMD

RESETDB

Oracle Essbase Technical Reference