stop concurrent requests

How to stop concurrent requests

How to Terminate running Concurrent Requests->
Set Terminating or Running to Completed/Terminated
UPDATE fnd_concurrent_requests
SET phase_code = 'C', status_code = 'X'
WHERE status_code ='T'
OR phase_code = 'R'
commit
How to set pending jobs on Hold->
Place Pending/(Normal/Standby) to On Hold
UPDATE fnd_concurrent_requests
SET hold_flag = 'Y'
WHERE phase_code = 'P'
AND status_code in ('Q','I')
commit

No comments:

How to restore the drop table in 19c Oracle Autonomous Data Warehouse.

  In Oracle Autonomous Data Warehouse (ADW) 19c, if you have accidentally dropped a table and want to restore it, there are a few recovery ...