Munin contributed plugins

# Version: 1.0

#

# This program is free software; you can redistribute it and/or modify

# as published by the Free Software Foundation.

# This program is distributed in the hope that it will be useful,

# but WITHOUT ANY WARRANTY; without even the implied warranty of

# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

# GNU General Public License for more details.

# You should have received a copy of the GNU General Public License along

# with this program; if not, write to the Free Software Foundation, Inc.,

# 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.

#

# Prerequistes:

#	1) env.ORACLE_HOME set in munin-node

#	dbport  : port used by the monitored instance (notice: numeric value)

#	dbname  : database to be monitored

#	dbhost  : host or ip address of db instance

#

#%# family=auto

#%# capabilities=autoconf

#

# Queries

#

                    decode(name, 'library cache',0,

                                 'dictionary chace',0,

                                 'free memory',0,

log_buffer_query = "SELECT TO_CHAR(ROUND(SUM(decode(pool, NULL,

                   decode(name, 'log_buffer', (bytes)/(1024*1024),0),0)),2)) sga_lbuffer

memory_components = { "fixed_area"   => fixed_area_query,

# config definition

#

elsif ARGV[0] == "config"

	puts "graph_title Oracle SGA from #{dbname}"

	puts "graph_category db"

	puts "graph_info This graph shows the SGA memory usage (in MB)"

		# make sure fixed_area is at the bottom of the stack

		if ( m ==  'fixed_area' )

	        	puts "#{m}.draw AREA"

                	puts "#{m}.draw STACK"

		end

	end