Defining tablespace types

You can define tablespace types for ETSM containers during instance configuration by using the auto-configuration method.

For information about the auto-configuration method, see Automatic configuration.

If the instance is already configured, irrespective of the configuration method used, you can override the tablespace types by using pconfig variables.

Using auto configuration

When you load the ORACLE_AUTO_CONFIG.kml file, you can define the tablespace types for the ETSM applications in the default_auto_config.txt file. If you do not have ORACLE_AUTO_CONFIG.kml loaded, or if you do not have the tablespace types defined, the tablespaces identified as undo, rollback, read-only, or temp are monitored by the corresponding ETSM_ containerType application, and the remaining tablespaces are monitored by the ETSM_REGULAR application.

By default, the following pconfig variables are created with default values when the instance is configured using auto configuration method:

  • /OracleConfig.LargeTablespaceSize (default value is 200000000 bytes)
  • /OracleConfig.VeryLargeTablespaceSize (default value is 400000000 bytes)

Tablespaces are sorted into regular, large, or very large ETSM containers based on the values of the preceding pconfig variables, if you do not override the settings in the default_auto_config.txt file.

Using manual or batch configuration

To define the tablespaces to be in different containers or to exclude tablespaces from monitoring, use the PATROL Configuration Manager. For more information, see Using PATROL Configuration Manager to modify and migrate configuration.

If you do not have the tablespace types defined, tablespaces identified as undo, rollback, read-only, or temp are monitored by the corresponding ETSM_ containerType application, and the remaining tablespaces are monitored by the ETSM_REGULAR application.

You can also set the values (in bytes) of the following pconfig variables to sort tablespaces into regular, large, or very large ETSM containers:

  • /OracleConfig.LargeTablespaceSize
  • /OracleConfig.VeryLargeTablespaceSize

For more information about the pconfig variables, see pconfig variables.

Was this page helpful? Yes No Submitting... Thank you

Comments