sql_id = util.input_with_default('SQL_ID', 'dkqs29nsj23jq')
start_time = util.input_with_default(
'Start date and time (DD-MON-YYYY HH24:MI:SS)', '01-JAN-1900 12:00:00')
end_time = util.input_with_default(
'End date and time (DD-MON-YYYY HH24:MI:SS)', '01-JAN-2200 12:00:00')
instance_number = util.input_with_default('Database Instance (1 if not RAC)',
'1')
mainquery = sqlstatwithplans(sql_id, start_time, end_time, instance_number)
mainresults = dbconnection.run_return_flipped_results(mainquery)
util.exit_no_results(mainresults)
date_times = mainresults[0]
plan_hash_values = mainresults[1]
elapsed_times = mainresults[2]
num_rows = len(date_times)
"""
There are multiple rows for a given date and time.
Build list of distinct date times and build a list of
the same length for each plan. Initialize plan lists
with 0.0. Later we will loop through every row updating
the entrees for a given plan and date.
"""
end_time=util.input_with_default('End date and time (DD-MON-YYYY HH24:MI:SS)','01-JAN-2200 12:00:00')
instance_number=util.input_with_default('Database Instance (1 if not RAC)','1')
queryobj = signatures.groupofsignatures()
queryobj.set_start_end_instance(start_time,end_time,instance_number)
lines = util.read_config_file(util.config_dir,database+util.groupsigs_file)
for line in lines:
if len(line) > 0:
queryobj.add_signature(int(line))
querytext = queryobj.build_query()
results = dbconnection.run_return_flipped_results(querytext)
util.exit_no_results(results)
# plot query
myplot.title = "SQL matching group of signatures on "+database+" database, instance "+instance_number+" elapsed versus executions"
myplot.ylabel1 = "Number of executions"
myplot.ylabel2 = "Averaged Elapsed Microseconds"
myplot.xdatetimes = results[0]
myplot.ylists = results[1:]
myplot.line_2subplots()
# Get user input
sql_id=util.input_with_default('SQL_ID','dkqs29nsj23jq')
start_time=util.input_with_default('Start date and time (DD-MON-YYYY HH24:MI:SS)','01-JAN-1900 12:00:00')
end_time=util.input_with_default('End date and time (DD-MON-YYYY HH24:MI:SS)','01-JAN-2200 12:00:00')
instance_number=util.input_with_default('Database Instance (1 if not RAC)','1')
mainquery = sqlstatwithplans(sql_id,start_time,end_time,instance_number)
mainresults = dbconnection.run_return_flipped_results(mainquery)
util.exit_no_results(mainresults)
date_times = mainresults[0]
plan_hash_values = mainresults[1]
elapsed_times = mainresults[2]
num_rows = len(date_times)
"""
There are multiple rows for a given date and time.
Build list of distinct date times and build a list of
the same length for each plan. Initialize plan lists
with 0.0. Later we will loop through every row updating
the entrees for a given plan and date.
"""
