Module: check_mk
Branch: master
Commit: abfbae14456099e021c9bcb8ffe5c3c23af9f23e
URL:
http://git.mathias-kettner.de/git/?p=check_mk.git;a=commit;h=abfbae14456099…
Author: Andreas Boesl <ab(a)mathias-kettner.de>
Date: Mon Mar 16 09:51:17 2015 +0100
new include file db.include
---
checks/db.include | 77 +++++++++++++++++++++++++++++++++++++++++++++
checks/oracle_tablespaces | 51 ++----------------------------
2 files changed, 79 insertions(+), 49 deletions(-)
diff --git a/checks/db.include b/checks/db.include
new file mode 100644
index 0000000..c8dcd7a
--- /dev/null
+++ b/checks/db.include
@@ -0,0 +1,77 @@
+#!/usr/bin/python
+# -*- encoding: utf-8; py-indent-offset: 4 -*-
+# +------------------------------------------------------------------+
+# | ____ _ _ __ __ _ __ |
+# | / ___| |__ ___ ___| | __ | \/ | |/ / |
+# | | | | '_ \ / _ \/ __| |/ / | |\/| | ' / |
+# | | |___| | | | __/ (__| < | | | | . \ |
+# | \____|_| |_|\___|\___|_|\_\___|_| |_|_|\_\ |
+# | |
+# | Copyright Mathias Kettner 2015 mk(a)mathias-kettner.de |
+# +------------------------------------------------------------------+
+#
+# This file is part of Check_MK.
+# The official homepage is at
http://mathias-kettner.de/check_mk.
+#
+# check_mk is free software; you can redistribute it and/or modify it
+# under the terms of the GNU General Public License as published by
+# the Free Software Foundation in version 2. check_mk is distributed
+# in the hope that it will be useful, but WITHOUT ANY WARRANTY; with-
+# out even the implied warranty of MERCHANTABILITY or FITNESS FOR A
+# PARTICULAR PURPOSE. See the GNU General Public License for more de-
+# ails. You should have received a copy of the GNU General Public
+# License along with GNU Make; see the file COPYING. If not, write
+# to the Free Software Foundation, Inc., 51 Franklin St, Fifth Floor,
+# Boston, MA 02110-1301 USA.
+
+# no used space check for Tablsspaces with CONTENTS in
('TEMPORARY','UNDO')
+# It is impossible to check the used space in UNDO and TEMPORARY Tablespaces
+# These Types of Tablespaces are ignored in this plugin.
+# This restriction is only working with newer agents, because we need an
+# additional parameter at end if each datafile
+
+
+def db_get_tablespace_levels_in_bytes(size_bytes, params):
+ # If the magic factor is used, take table size and magic factor
+ # into account in order to move levels
+ magic = params.get("magic")
+
+ # Use tablespace size dependent dynamic levels or static levels
+ if type(params.get("levels")) == tuple:
+ warn, crit = params.get("levels")
+ else:
+ # A list of levels. Choose the correct one depending on the
+ # size of the current tablespace
+ for to_size, this_levels in params.get("levels"):
+ if size_bytes > to_size:
+ warn, crit = this_levels
+ break
+ else:
+ return None, None, "", False
+
+ # warn/crit level are float => percentages of max size, otherwise MB
+ if type(warn) == float:
+ output_as_percentage = True
+ if magic:
+ normsize = params["magic_normsize"] * 1024 * 1024
+ hbytes_size = size_bytes / float(normsize)
+ felt_size = hbytes_size ** magic
+ scale = felt_size / hbytes_size
+ warn *= scale
+ crit *= scale
+ max_warning_level, max_critical_level = params["magic_maxlevels"]
+ warn = min(warn, max_warning_level)
+ crit = min(crit, max_critical_level)
+ levels_text = " (levels at %.1f%%/%.1f%%)" % (warn, crit)
+ warn_bytes = warn * size_bytes / 100
+ crit_bytes = crit * size_bytes / 100
+
+ # Absolute free space in MB
+ else:
+ output_as_percentage = False
+ warn_bytes = warn * 1024 * 1024
+ crit_bytes = crit * 1024 * 1024
+ levels_text = " (levels at %s/%s)" %
(get_bytes_human_readable(warn_bytes), get_bytes_human_readable(crit_bytes))
+
+
+ return warn_bytes, crit_bytes, levels_text, output_as_percentage
diff --git a/checks/oracle_tablespaces b/checks/oracle_tablespaces
index 8cb4e85..c1784b7 100644
--- a/checks/oracle_tablespaces
+++ b/checks/oracle_tablespaces
@@ -98,53 +98,6 @@ def inventory_oracle_tablespaces(info):
inventory.append(("%s.%s" % t, parameters))
return inventory
-
-def get_tablespace_levels_in_bytes(size_bytes, params):
- # If the magic factor is used, take table size and magic factor
- # into account in order to move levels
- magic = params.get("magic")
-
- # Use tablespace size dependent dynamic levels or static levels
- if type(params.get("levels")) == tuple:
- warn, crit = params.get("levels")
- else:
- # A list of levels. Choose the correct one depending on the
- # size of the current tablespace
- for to_size, this_levels in params.get("levels"):
- if size_bytes > to_size:
- warn, crit = this_levels
- break
- else:
- return None, None, "", False
-
- # warn/crit level are float => percentages of max size, otherwise MB
- if type(warn) == float:
- output_as_percentage = True
- if magic:
- normsize = params["magic_normsize"] * 1024 * 1024
- hbytes_size = size_bytes / float(normsize)
- felt_size = hbytes_size ** magic
- scale = felt_size / hbytes_size
- warn *= scale
- crit *= scale
- max_warning_level, max_critical_level = params["magic_maxlevels"]
- warn = min(warn, max_warning_level)
- crit = min(crit, max_critical_level)
- levels_text = " (levels at %.1f%%/%.1f%%)" % (warn, crit)
- warn_bytes = warn * size_bytes / 100
- crit_bytes = crit * size_bytes / 100
-
- # Absolute free space in MB
- else:
- output_as_percentage = False
- warn_bytes = warn * 1024 * 1024
- crit_bytes = crit * 1024 * 1024
- levels_text = " (levels at %s/%s)" %
(get_bytes_human_readable(warn_bytes), get_bytes_human_readable(crit_bytes))
-
-
- return warn_bytes, crit_bytes, levels_text, output_as_percentage
-
-
def check_oracle_tablespaces(item, params, info):
try:
sid, tbsname = item.split('.')
@@ -224,7 +177,7 @@ def check_oracle_tablespaces(item, params, info):
raise MKCounterWrapped("Login into database failed")
- warn, crit, levels_text, output_as_percentage =
get_tablespace_levels_in_bytes(max_size, params)
+ warn, crit, levels_text, output_as_percentage =
db_get_tablespace_levels_in_bytes(max_size, params)
infotext = "%s (%s), size: %s, free: " % \
(ts_status,
@@ -290,5 +243,5 @@ check_info['oracle_tablespaces'] = {
"has_perfdata" : True,
"group" : "oracle_tablespaces",
"default_levels_variable" : "oracle_tablespaces_defaults",
- "includes" : [ "oracle.include" ]
+ "includes" : [ "oracle.include",
"db.include" ]
}