Specify Script - (Max Extents - Allocated) <

 

Use this dialog box to specify a script to run when the maximum extents minus the allocated extents for a table is less than a specified number of extents.

Field Name

Description

Script Name

Enter the name of the script.

Where to Run

Select the Agent where you want the script to run from the drop-down list.

Script Parameters

This section displays what parameters will be passed to the script when it is run. The parameters will be passed in the order specified.

 

  • <table> - The name of the table that triggered the alert condition.  

  • <segment> - The name of the table segment that has triggered the alert.

  • <segment-type> - The type of segment that has triggered the alert. The possible types of segments include:

    • TABLE

    • TABLE PARTITION

    • TABLE SUBPARTITION

    • NESTED TABLE

    • CLUSTER

    • INDEX

    • INDEX PARTITION

    • INDEX SUBPARTITION

    • LOBINDEX

    • LOBSEGMENT

    • LOB PARTITION

    • LOB SUBPARTITION

  • <computer> - The name of the computer where the triggering condition occurred.

  • <rdbms-type> - The type of RDBMS where the triggering condition occurred (for example, Oracle).

  • <rdbms-instance-name> - Oracle SID

  • <database> - The name of the database where the triggering condition occurred.

  • <available-extents> - The number of extents still available to the segment for growth. This value equals the maximum extents available to the object minus the extents currently allocated to the segment.

  • <threshold> - Value that you set for the triggering condition. If the value unit was specified as a %, then a % will follow this value.

  • <extent-count> - The number of extents allocated to a segment, or the number of free extents in the tablespace (depends on Alert type).

 

 

To learn more, see Running Scripts in Response to an Alert.