def rman(): try: cur1 = con.cursor() statement = rman_time cur1.execute(statement) res1 = cur1.fetchall() print(res1) cur1.close() cur2 = con.cursor() statement = rman_current cur2.execute(statement) res2 = cur2.fetchall() print(res2) cur2.close() cur3 = con.cursor() statement = rman_history cur3.execute(statement) res3 = cur3.fetchall() print(res3) cur3.close() except cx_Oracle.DatabaseError as e: error, = e.args print(sys.stderr, "Oracle-Error-Code:", error.code) print(sys.stderr, "Oracle-Error-Message:", error.message) return render_template('rman.html', data=res1, data1=res2, data2=res3)
def frandata(): try: cur1 = con.cursor() statement = fra_status cur1.execute(statement) res1 = cur1.fetchall() print(res1) cur1.close() cur2 = con.cursor() statement = reco_usage cur2.execute(statement) res2 = cur2.fetchall() print(res2) cur2.close() cur3 = con.cursor() statement = datafile_usage cur3.execute(statement) res3 = cur3.fetchall() print(res3) cur3.close() except cx_Oracle.DatabaseError as e: error, = e.args print(sys.stderr, "Oracle-Error-Code:", error.code) print(sys.stderr, "Oracle-Error-Message:", error.message) return render_template('frandata.html', data=res1, data1=res2, data2=res3)
def locks(): cur1 = con.cursor() statement = ddl_locks cur1.execute(statement) res1 = cur1.fetchmany(100) print(res1) cur1.close() cur2 = con.cursor() statement = dml_locks cur2.execute(statement) res2 = cur2.fetchall() print(res2) cur2.close() return render_template('locks.html', data1=res1, data2=res2)
def alertlogs(): cur2 = con.cursor() statement = log_locations cur2.execute(statement) res2 = cur2.fetchall() print(res2) cur2.close() cur1 = con.cursor() statement = alert_log_View cur1.execute(statement) res1 = cur1.fetchmany(100) print(res1) cur1.close() return render_template('alertlogs.html', data1=res2, data2=res1)
def tablespace(): try: cur1 = con.cursor() statement = temp_tbs cur1.execute(statement) res1 = cur1.fetchall() print(res1) cur1.close() cur2 = con.cursor() statement = tbs_detail cur2.execute(statement) res2 = cur2.fetchall() print(res2) cur2.close() cur3 = con.cursor() statement = default_tbs cur3.execute(statement) res3 = cur3.fetchall() print(res3) cur3.close() cur5 = con.cursor() statement = space_usage cur5.execute(statement) res5 = cur5.fetchall() print(res5) cur5.close() cur6 = con.cursor() statement = tbs_quota cur6.execute(statement) res6 = cur6.fetchall() print(res6) cur6.close() except cx_Oracle.DatabaseError as e: error, = e.args print(sys.stderr, "Oracle-Error-Code:", error.code) print(sys.stderr, "Oracle-Error-Message:", error.message) return render_template('tablespace.html', data=res1, data1=res2, data2=res3, data3=res5, data4=res6)
def index(): try: cur1 = con.cursor() statement = basic_info cur1.execute(statement) res1 = cur1.fetchall() print(res1) cur1.close() cur2 = con.cursor() statement = system_info cur2.execute(statement) res2 = cur2.fetchall() print(res2) cur2.close() except cx_Oracle.DatabaseError as e: error, = e.args print(sys.stderr, "Oracle-Error-Code:", error.code) print(sys.stderr, "Oracle-Error-Message:", error.message) return render_template('home.html', data=res1, data1=res2)
def memory(): cur1 = con.cursor() statement = asm_usage cur1.execute(statement) res1 = cur1.fetchall() print(res1) cur1.close() cur2 = con.cursor() statement = asm_stat cur2.execute(statement) res2 = cur2.fetchall() print(res2) cur2.close() cur3 = con.cursor() statement = sga_info cur3.execute(statement) res3 = cur3.fetchall() print(res3) cur3.close() cur4 = con.cursor() statement = sga_pga cur4.execute(statement) res4 = cur4.fetchall() print(res4) cur4.close() cur5 = con.cursor() statement = mem1 cur5.execute(statement) res5 = cur5.fetchall() print(res5) cur5.close() cur6 = con.cursor() statement = mem2 cur6.execute(statement) res6 = cur6.fetchall() print(res6) cur6.close() return render_template('memory.html', data1=res1, data2=res2, data3=res3, data4=res4, data5=res5, data6=res6)