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; /