When
 trying to connect to database (11g,12c)  I  see wait 
events on "resmgr:pq queued" indefinitely. 
What can be done to resolve the resmgr:pq queued wait message?
By changing the following parameter, this issue was resolved :
alter system set "_parallel_statement_queuing"=FALSE scope=both;
What can be done to resolve the resmgr:pq queued wait message?
By changing the following parameter, this issue was resolved :
alter system set "_parallel_statement_queuing"=FALSE scope=both;
 
Brak komentarzy:
Prześlij komentarz