Can you please tell me if I can programmatically, in PL / SQL code (and when calling) a procedure, somehow influence the priority of its execution? Say to increase, so that it is executed in the first place, while other processes (procedures) are waiting?
- Your question is not entirely clear. Could you give an example where this question arose? - 0xdb
- At certain points on the server, several procedures are run that compete for resources. Is it possible to somehow programmatically make one of these procedures always take precedence over the others? - Anatoly Ernst
- My question remains open. Where or in connection with which this question arose? Are we talking about jobs? - 0xdb
- With a lack of server resources))) There is a critical procedure that starts to be performed late, when the server is already thrashing with might and main and it has to wait for the release of resources, then its turn. And I would like to somehow push through it and make it run first of all. Although theoretically possible? ))) - Anatoly Ernst
- This is the procedure that runs the jobs. At the task level, how can you manage priority? - Anatoly Ernst
|