Specify Script - Freespace Fragmented Into More Than

 

Use this dialog box to specify a script to run when the free space on a tablespace is fragmented into a number of extents that is greater 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.

 

  • <tablespace> - The name of the tablespace 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.

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

  • <largest-extent-size><size-designator> - Total amount of the largest free extent in the tablespace, measured in KB, MB, or GB.

 

 

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