SQL>  select sql_id,
  2             decode(instr(program, '(P0'), 0, 'FOREGROUND', 'PX Slave') TYPE,
  3             count(*)
  4        from v$active_session_history
  5       where event = 'cursor: pin S wait on X'
  6       group by sql_id,
  7                decode(instr(program, '(P0'), 0, 'FOREGROUND', 'PX Slave')
  8      having count(*) > 100
  9       order by count(*) desc
 10  /

SQL_ID        TYPE         COUNT(*)
------------- ---------- ----------
5cbgcgdgxusy0 FOREGROUND      12781
3hcf3bkju3mnv FOREGROUND        319


SQL> select sql_id, count(*)
  2    from v$sql
  3    where sql_id = '5cbgcgdgxusy0'
  4    group by sql_id
  5    /

SQL_ID          COUNT(*)
------------- ----------
5cbgcgdgxusy0         32

select * from V$SQL_SHARED_CURSOR where sql_id = '5cbgcgdgxusy0'

ALTER SYSTEM SET OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=TRUE;

SELECT * FROM dba_sql_plan_baselines

BEGIN
   DBMS_OUTPUT.put_line (
      DBMS_SPM.DROP_SQL_PLAN_BASELINE (sql_handle   => 'SQL_31a70ddb5cd05066',  
                                       PLAN_NAME    => NULL));
END;