Starting with Enterprise Manager Cloud Control 13c, we released a new corrective action called “Add Space to Tablespace”. This corrective action automatically addresses the ‘tablespace full’ problem across different types of tablespaces – locally managed, dictionary managed, permanent, temp and undo tablespaces. When a tablespace is near full and the tablespace full alert has triggered, the corrective action will increase the tablespace by extending existing datafiles, or create new datafiles for Database Instance and Pluggable Database targets.

Add Space to Tablespace corrective action can be used on any of the following Tablespace Full metrics to increase either Smallfile or Bigfile datafiles.

•    Tablespace Free Space (MB)
•    Tablespace Space Used (%)
•    Tablespace Free Space (MB) (dictionary managed)
•    Tablespace Space Used (%) (dictionary managed)
•    Tablespace Free Space (MB) (Temp)
•    Tablespace Space Used (%) (Temp)
•    Tablespace Free Space (MB) (Undo)
•    Tablespace Space Used (%) (Undo)

See the steps below to setup an “Add Space to Tablespace” corrective action.

1.    Navigate to Enterprise > Monitoring > Corrective Actions.

tablespace
Figure 1: Add space to tablespace

2.    Select “Add Space to Tablespace” from “Create Library Corrective Action” drop down and click “Go”.

step 2

3.    Populate the Name field for the corrective action and select “Metric Alert” event type.

step 3

4.    Click on the Parameters tab and fill out parameters for the corrective action.

4

5.    Click on “Save to Library”.

5

6.    The corrective action will be in Draft status. Test the corrective action by generating an alert and manually running the corrective action via Incident Manager.

6

6

7.    Publish the corrective action after verifying it is working fine.

7

8.    Now that your corrective action has been published, you can start using it by associating it as a corrective action for the Tablespace Full metric. You can do this for a specific database target in its Metric and Collection Settings page, or for many targets as part of your monitoring template for your database targets. Below are instructions for associating the corrective action from Metric and Collection Settings page.

  1. a.  Navigate to target home page and click on [Target menu] > Monitoring > Metric and Collection Settings.
  2.  
  3. b.  Click on the Edit icon for any Tablespace Full metric.
  4.  

  5. 8

  6.  
  7. c.  Click “Edit” in the Monitored Objects section.
  8.  

  9. 9

  10.  
  11. d.  Click on “Add” next to Warning or Critical in the Corrective Actions section.
  12.  

  13. 10

  14.  
  15. e.  Search for the corrective action and select it.
  16.  

  17. 11

  18.  
  19. f.  Click “Continue” after the corrective action is added to the metric.
  20.  

  21. 12

  22.  
  23. g.  Back in the Metric and Collection Settings page, the corrective actions column will display which metric threshold has an associated corrective action.
  24.  

  25. a

  26.  
  27. h.  Be sure to save the changes by clicking on “OK” in the Metric and Collection Settings page.
  28.  

  29. b

  30.  

 

  • For more information about the Add Space to Tablespace corrective action, see the MOS article “EM 13c How to Use Corrective Action: Add Space to Tablespace” (Doc ID 2640622.1).
  • Visit our documentation library for details about how corrective actions work.