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()