Using regular expressions to choose tablespaces

PATROL for Oracle enables you to use regular expressions to add and remove tablespaces under ETSM, including the following wildcard (meta) characters:

• *** represents 0 or more characters.
• ? represents a single character.

You can also combine these meta-characters to form a regular expression.

For auto-configuration, you can specify regular expressions in the default_auto_config.txt file in the following tablespace variables:

• oracle-sid |EXCLUDE_TBS|CLASSIC TS*|
• oracle-sid |DEFAULT_TBS|S?STE*|
• oracle-sid |LARGE_TBS|TS_*|
• oracle-sid |READONLY_TBS||
• oracle-sid |ROLLBACK_TBS||
• oracle-sid |TEMPORARY_TBS||
• oracle-sid |UNDO_TBS||

You can set the following Agent pconfig variables by using the*** and ? characters in regular expressions:

• /OracleConfig. oracle-sid.DefaultTablespaces
• /OracleConfig. oracle-sid.LargeTablespaces
• /OracleConfig. oracle-sid.VeryLargeTablespaces
• /OracleConfig. oracle-sid.TemporaryTablespaces
• /OracleConfig. oracle-sid.RollbackTablespaces
• /OracleConfig. oracle-sid.UndoTablespaces
• /OracleConfig. oracle-sid.ReadonlyTablespaces
• /OracleConfig. oracle-sid.ExcludeTablespaces

To set these pconfig variables with regular expressions, use one of the following methods:

• From the host, right-click and choose Development > Agent Configuration > Edit > Add Variable, and add a variable.

• Execute the following command in the system output window:
  %PSL pconfig("REPLACE","/OracleConfig. ORACLE_SID . tablespaceType ", " RegularExpression|tablespaceName");

  Example

  
  %PSL pconfig("REPLACE","/OracleConfig.kol920db.ExcludeTablespaces","T*E?");
kol920db is the database name and T*E? is the regular expression for the ETSM tablespaces. After executing the command, PATROL for Oracle excludes all the tablespaces that have the T*E? string in their name from ETSM monitoring.

  Note

  Separate multiple regular expressions or tablespace names by space characters.