How to exclude a tablespace from being monitored?
How to exclude multiple tablespaces from being monitored?
The Foglight for Oracle DB cartridge allows excluding tablespaces from being monitored the Administration page. However, when it comes to multiple tablespaces that need to be excluded, the ASP might be a slow option.
RESOLUTION 1
Use the Tablespace Settings pane to configure the default monitoring settings for the Tablespaces Storage collection, by excluding from monitoring one or more of the following types of tablespaces:
This pane also includes the Tablespace Exclude List section. Use this section to add one ore more tablespaces to the Exclude list.
To add tablespaces to the Exclude list:
RESOLUTION 2 - Adding multiple (hundreds, thousands) of tablespaces to be excluded
This allows you to create a text list for a groovy script to use and add the entries to the agent property list for you per agent. It will not accept regular expressions but it will save you time from having to add these from agent properties manually.
Please use the attached DBO_update_exclude_tablespaces.groovy script. The script body contains the explanation and examples on how to use it.
Preparing the input files
Input files: prepare, for every agent, a file named <agent-name>.txt (take the exact Agent name from Agent Status which includes the list of tablespaces to exclude for that agent. Every tablespace name should be on a line of its own. Place all the input files in the same directory, of your choice.
Editing the script
Open the script for editing.
Save the changes.
Running the script
The script can be executed either from the Fglam host command line, or from FMS Script Editor.
Notes
The script will have printouts ion the FMS log, when it runs successfully, or when it fails for any reason.
Log printouts
The script will have printouts in the FMS log, when it runs successfully or when it fails for any reason.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center