Page 1 of 1

Exclude specific tables in check_oracle_health

Posted: Wed Oct 22, 2014 2:09 am
by yitzyb
Hi.

We use the http://exchange.nagios.org/directory/Pl ... th/details (check_oracle_health) plugin and I was wondering if anyone knows how to set an exception to exclude certain tables from the TableSpace Usage check.

Thanks.

Re: Exclude specific tables in check_oracle_health

Posted: Wed Oct 22, 2014 3:45 pm
by tmcdonald
I didn't see a specific exemption flag in the usage. Can you give an example of one of the checks you are running with it?

Re: Exclude specific tables in check_oracle_health

Posted: Thu Oct 23, 2014 2:16 am
by yitzyb
One of the checks is DB Tablespace Usage. After a discussion with our DBA, he informed me that there are tables named UNDOTS that do not need to be monitored. He asked me if we could add an exception to the check to ignore those tables. The attached screenshot shows the specific check to which I am referring.

Re: Exclude specific tables in check_oracle_health

Posted: Thu Oct 23, 2014 4:18 pm
by sreinhardt
I believe tmcdonald was hoping for a command example. I can see that it is checking the undots table. How do you have the command currently setup, and have you tried modifying it in any way to exclude that table?