select * from dbaashcount d where d.date_minute not in (select date_minute from combinedashcount)""" dbconnection.run_return_no_results(insert_sql) dbconnection.commit() # query final results grouped by minute querytext = """ select to_date(DATE_MINUTE,'YYYY/MM/DD HH24:MI'), wait_count from combinedashcount order by date_minute""" r = dbconnection.run_return_flipped_results(querytext) util.exit_no_results(r) # plot query myplot.title = "Sessions waiting on '" + wait_event + "' waits on " + database + " database, instance " + instance_number myplot.ylabel1 = "Number of sessions" myplot.xdatetimes = r[0] myplot.ylists = r[1:] myplot.line()
where d.date_minute not in
(select date_minute from combinedashcount)"""
dbconnection.run_return_no_results(insert_sql)
dbconnection.commit()
querytext = """
select
to_date(DATE_MINUTE,'YYYY/MM/DD HH24:MI'),
ALL_COUNT,
CPU_COUNT
from combinedashcount
order by date_minute"""
results = dbconnection.run_return_flipped_results(querytext)
util.exit_no_results(results)
# plot query
myplot.xdatetimes = results[0]
myplot.ylists = results[1:]
myplot.title = "ASH active session count for "+database+" database, instance "+instance_number
myplot.ylabel1 = "Sessions"
myplot.ylistlabels=["Total","CPU"]
myplot.line()
