Search notes:

DBMS_RESOURCE_MANAGER.DEQUEUE_PARALLEL_STATEMENT

select
   ses.sid,
   ses.serial#,
   sql.sql_id,
   sql.sql_text
from
   v$session ses                             join
   v$sqlarea sql on ses.sql_id = sql.sql_id
where
   ses.state = 'WAITING' and
   ses.event = 'resmgr:pq queued';

begin
  
   dbms_resource_manager.dequeue_parallel_statement (
      session_id      => ‥,
      session_serial  => ‥,
   -- inst_id         => ‥,
      sql_id          =>'‥',
   );

end;
/

See also

dbms_resource_manager

Index