Measuring Execution Time

Even if the user reports that “it’s slow,” confirm it:

SELECT elapsed_time/1000000 AS seconds, executions
FROM gv$sql
WHERE sql_id = '<your-sql-id>';

This shows average time per execution. One run taking 90 seconds may not be a problem—unless it’s being called hundreds of times per hour or runs in a timeout-sensitive context.