Step 1: Get the SQL_ID

Before you do anything else, identify the query using its SQL_ID. You can get it:

• From the application or APEX session logs
• Using a query on recent activity:

  SELECT sql_id, sql_text
  FROM gv$sql
  WHERE sql_text LIKE '%target_table%'
  AND last_active_time > SYSDATE - 1/24
  ORDER BY last_active_time DESC;