Reclaiming Space in the Database

Previous

Next

---

You can recover unused free space in the database on the Compact Storage page. Compacting storage is accomplished using a database job that runs in the background. This database job frees up unused spaces allocated for tables and reorganizes data for optimal space utilization.

To access the Storage page, you must have a database account that has been granted a DBA role.

To compact your database storage:

1. On the Database Home Page, click the Administration icon and then Storage.

2. If prompted, enter the appropriate administrator username and password and click Login.

3. On the Tasks list, click Compact Storage.

   The Compact Storage page appears and displays the following:

   • Space Allocated. Displays the amount of space in MB currently allocated to database user objects.

   • Available. Displays the amount of space in MB currently available.

   • Physical Limit. Displays the amount of space in MB available for database objects.

   • Percent Used. Displays a percentage that indicates the space used in comparison with the maximum database size permitted.

4. Click Compact Storage.

   The process may take several minutes.