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

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:51 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(51): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(66): id_of(Object(PDO), 'uri', '/notes/developm...') #2 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1759612541, '216.73.216.149', 'Mozilla/5.0 App...', NULL) #3 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/installed/packages/dbms/resource_manager/api/dequeue_parallel_statement(58): insert_webrequest() #4 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 51