(Version 24.01 but also in the latest)
When we encounter an error in our application we do a apex_util.submit_feedback,
We noticed that the response time of this function was 2.5 seconds and more.
We traced it back to the trigger on WWV_FLOW_FEEDBACK
`select nvl(max(feedback_id),0) + 1 into :new.feedback_id`
`from wwv_flow_feedback`
`where security_group_id = xx;`
This took 2.5 seconds because of a Full table scan.
However
`select max(feedback_id) into :new.feedback_id`
`from wwv_flow_feedback`
`where security_group_id = xx;`
`:new.feedback_id := coalesce(:new.feedback_id,0) + 1;`
will take under 0.5 seconds ( because of a Hash join on the two indexes, bypassing table-access)