Scheduled job priority vs interactive sessions priority
edited Jun 14, 2011 4:00AM in Database ORA-600 / ORA-7445 Analysis , Diagnostic Repository (ADR) & Packaging (MOSC) 5 commentsAnswered ✓
Hi,
documentation about DBMS_SCHEDULER in "Oracle® Database PL/SQL Packages and Types Reference 10g Release 2 (10.2)" states:
job_priority: This attribute specifies the priority of this job relative to other jobs in the same class as this job.
However, I wonder if there is any way to modify scheduler job's priority but relative to ordinary database sessions.
The reason is that scheduled jobs perform batch work, while ordinary database sessions perform interactive work. So it looks reasonable to favour interactive work over batch work in order to provide better response time to interactive users.
Thank you,
Nicolau
job_priority: This attribute specifies the priority of this job relative to other jobs in the same class as this job.
However, I wonder if there is any way to modify scheduler job's priority but relative to ordinary database sessions.
The reason is that scheduled jobs perform batch work, while ordinary database sessions perform interactive work. So it looks reasonable to favour interactive work over batch work in order to provide better response time to interactive users.
Thank you,
Nicolau
0