一个python 循环执行oracle sql 的demo

最新推荐文章于 2024-08-13 08:00:00 发布

lixora

最新推荐文章于 2024-08-13 08:00:00 发布

阅读量2.3k

点赞数 1

分类专栏： Python

本文链接：https://blog.csdn.net/lixora/article/details/78220988

版权

Python 专栏收录该内容

8 篇文章 0 订阅

订阅专栏

# -*- coding: utf-8 -*-
import ConfigParser
import string, os, sys
import cx_Oracle
import time

cf = ConfigParser.ConfigParser()
cf.read(".\db.conf")

#read by type
db_tnsname = cf.get("db", "db_tnsname")
db_user = cf.get("db", "db_user")
db_pass = cf.get("db", "db_pass")
interval = cf.getint("db","interval")

print "db_tnsname:", db_tnsname
print "db_user:", db_user
print "db_pass:", db_pass
print "interval:", interval

print '##########show oracle db event ##############'
db1=cx_Oracle.connect(db_user,db_pass, db_tnsname)
##获取游标
cursor = db1.cursor()
sql1='select event,count(*) from v$session group by event order by 2'
print sql1
#执行查询
while (1 == 1):
time.sleep(interval)
print '----------------------------------------------------------'
print('|'+time.strftime('%Y-%m-%d %H:%M:%S',time.localtime(time.time()))+"|")
print '----------------------------------------------------------'
cursor.execute(sql1)
result = cursor.fetchall()
for row in result:
print row
print('----------end---------------------------------------------\n')
cursor.close
db1.close()