SQLHC is running for long time in any version.

Hi Folks,

Am facing some issues with sqlhc tool. When i run it against any sql on any version like 19.13.0.0.0 or 12.2.0.1.0, it's taking more than 2 hours to get it completed. it got stuck up in the below statement for very long time while executing.

Can anyone give some suggestions to speed it up. Besides can we use SQLDB360 tool ? as sqlt tool is providing more info.

FROM ( WITH object AS (

SELECT /*+ MATERIALIZE */ object_owner owner, object_name name

FROM gv$sql_plan

WHERE inst_id IN

(SELECT inst_id

FROM gv$instance) AND sql_id = :sql_id AND object_owner IS NOT NULL AND object_name IS NOT NULL UNION