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. """