How to find the queries using parallel in Oracle
How to fine the query using parallel operator in Oracle SELECT DISTINCT p.sql_id, DBMS_LOB.SUBSTR(t.sql_text, 4000, 1) AS sql_text, s.executions_delta AS executions, s.cpu_time_delta / 1000000 AS cpu_seconds, s.elapsed_time_delta / 1000000 AS elapsed_seconds, p.other_tag FROM dba_hist_sql_plan p JOIN dba_hist_sqltext t ON p.sql_id = t.sql_id JOIN dba_hist_sqlstat s ON p.sql_id = s.sql_id WHERE…









