execution detail of a sql_id in cursor - Oracle Database Script. SELECT MODULE, parsing_schema_name, inst_id, sql_id, plan_hash_value, child_number, sql_fulltext, to_char(last_active_time, 'DD/MM/YY HH24:MI:SS'), sql_plan_baseline, executions, elapsed_time/executions/1000/1000, rows_processed FROM gv$sql WHERE sql_id IN ('&sql_id');
SELECT MODULE, parsing_schema_name, inst_id, sql_id, plan_hash_value, child_number, sql_fulltext, to_char(last_active_time, 'DD/MM/YY HH24:MI:SS'), sql_plan_baseline, executions, elapsed_time/executions/1000/1000, rows_processed FROM gv$sql WHERE sql_id IN ('&sql_id');