DBMS_XPLAN.DISPLAY_CURSOR took more CPU time
We observed from AWR report, the below query took 190 sec to execute (CPU time):
SELECT * FROM TABLE(dbms_xplan.display_cursor(:sql_id, :child_number, 'advanced'));
Normally above query run pretty fast.
Is there any reasons for such latency?