Changing Space Usage Alert Thresholds for a Tablespace

You receive an alert in Database Control when a space usage threshold for a tablespace is reached. There are two types of space usage alerts that you can enable: warning, for when tablespace space is somewhat low, and critical, for when the tablespace is almost completely full and action must be taken immediately.

For both warning and critical alerts, you can specify alert thresholds in the following ways:

• By space used (%)

  When space used becomes greater than or equal to a percentage of total space, an alert is issued.

• By free space (MB)

  When remaining space falls below an amount (in MB), an alert is issued.

  Free-space thresholds are more useful for large tablespaces. For example, for a 10 TB tablespace, setting the percentage full critical alert to as high as 99 percent means that the database would issue an alert when there is still 100 GB of free space remaining. Usually, 100 GB remaining would not be a critical situation, and the alert would not be useful. For this tablespace, it might be better to use a free-space threshold, which you could set to issue a critical alert when 5 GB of free space remains.

For both warning and critical alerts for a tablespace, you can enable either the space used threshold or the free-space threshold, or you can enable both thresholds.

To change space usage alert thresholds for tablespaces:

1. Go to the Database Home page.

   See "Accessing the Database Home Page".

2. At the top of the page, click Server to view the Server subpage.

3. In the Storage section, click Tablespaces.

   The Tablespaces page appears.

4. Select the tablespace whose threshold you want to change, and then click Edit.

   The Edit Tablespace page appears, showing the General subpage.

5. Click the Thresholds link at the top of the page to display the Thresholds subpage.

6. In the Space Used (%) section, do one of the following:

   • Accept the default thresholds.

   • Select Specify Thresholds, and then enter a Warning (%) threshold and a Critical (%) threshold.

   • Select Disable Thresholds to disable the percentage full thresholds.

7. In the Free Space (MB) section, do one of the following:

   • Accept the default thresholds.

   • Select Specify Thresholds, and then enter a Warning (MB) threshold and a Critical (MB) threshold.

   • Select Disable Thresholds to disable the threshold for free space remaining.

8. Click Apply.

   A confirmation message appears.