Specify Script - Empty Used Segment Space Exceeds

 

Use this dialog box to specify a script to run when the empty used space within a table segment exceeds a specified amount.

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.

  • <usage><size-designator> - Value of used disk space, in KB, MB, or GB.

  • <threshold><thr-designator> - Value of the triggering condition, in KB, MB, or GB, or % (value units).

  • <percent-of-table-size>% - The percentage of space allocated to a segment that is empty and unused (i.e., the percentage of space above the "high-water mark"). Available on the Empty Used Segment Space table alert.  

 

 

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