Specify Script - Chained Row Count Greater Than

 

Use this dialog box to specify a script to run when a table has a chained row count greater than a specified percent.

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.  

  • <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.

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

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

  • <percent-of-total-rows>% - The percentage of table rows that are chained.

 

 

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