We have new requireent to create seprate manager for executing requests which are comming from specific responsibility, Since the requests comming from specif responsibility will be expected to run long time .
The reson beehind the requirments.
We are maintaing Historical data and to access the report we have created two set of responsibilities for online data and archive data.
Sometime user submiting Archive database request during business hours which is expected to run little long time.
Now we would like to restrict to run such report during business hours , if at all manadatory to run then we are thinking to create seprate manager with mnimal process.
How to define specialzatio ule for responsibility level ?
This feature is not available yet and we have few enhancement requests created to achieve the same -- ENHANCEMENT : CONCURRENT MANAGER SPECIALISATION RULE ON RESPONSIBILITY
Please see the following docs for a workaround.
How to Split the Load of Work to Many Concurent Managers (Doc ID 473310.1)
How to Make User Run Any Requests Using Standard Manager Except Specific Program Run by Custom Manager? (Doc ID 1297419.1)
Thanks to both for update,
In this case workaround not helping us , since user use to submit same requests during online /archive requirement .
ex, There are 100 Requests which use to submit against both archive and online . But we are planning to create seprate manager with max 5 process
so if user submiting requests for online data then pending requests will increase , also long running requests will block online requests .
Any other possible option ?
If you have more hardware resources on the server then you may consider creating more than one custom concurrent manager with higher number of processes.
If the above doesn't help, then another approach would be using Active Data Guard for reporting -- Using Active Data Guard Reporting with Oracle E-Business Suite Release 12.1 and Oracle Database 11g (Doc ID 1070491.1)