Zabbix监控Oracle 连接数

muugua

#!/usr/bin/python　　# coding:utf-8
　　#
　　# check Oracle process
　　# dbsession: current connect session
　　# dbprocess: db max connect session
　　# presession: current connect session precent
　　import cx_Oracle
　　import sys
　　# conn to DB
　　conn = cx_Oracle.connect('user/passwd@orcl')
　　cursor = conn.cursor()
　　dbProcess = {}
　　# current connect session
　　sessionSQL = "select count(*) process from v$session"
　　cursor.execute(sessionSQL)
　　sessionRow = cursor.fetchone()
　　dbProcess['dbsession'] = sessionRow[0]
　　# db max connect session
　　processSQL = "select value count from v$parameter where name ='processes'"
　　cursor.execute(processSQL)
　　proce***ow = cursor.fetchone()
　　dbProcess['dbprocess'] = proce***ow[0]
　　# current connect session precent
　　presession = (dbProcess['dbsession']) / float(dbProcess['dbprocess'])
　　dbProcess['presession'] = '%.2f' % (presession * 100)
　　cursor.close()
　　# close db
　　conn.close()
　　#print(dbProcess)
　　try:
　　if sys.argv[1]:
　　if sys.argv[1] == 'dbsession':
　　print(dbProcess['dbsession'])
　　if sys.argv[1] == 'dbprocess':
　　print(dbProcess['dbprocess'])
　　if sys.argv[1] == 'presession':
　　print(dbProcess['presession'])
　　except:
　　print("Usage: %s dbsession |dbprocess |presession" % sys.argv[0])