Tagged Questions
0
votes
1answer
28 views
Oracle scheduler max_jobs_Slave_processes is set to null, how many will be allocated?
Executing the following query against my database:
select value
from dba_scheduler_global_attribute
where attribute_name='MAX_JOB_SLAVE_PROCESSES';
yields a value of NULL. My question is what ...
2
votes
1answer
2k views
In Oracle, if parallel_max_servers is set to be significantly less than the DOP can the explain plan be sub-optimal?
For tables that have DEGREE DEFAULT, the degree of parallelism (DOP) is calculated by Oracle using number of CPUs and number of threads per CPU amongst other things. As I understand it, when costing ...
1
vote
1answer
155 views
Why am I not seeing any benefits of parallel execution when parallel clause is used?
I have these two methods of creating a table and populating with rows. The first one uses a
parallel (degree 3) clause, so I expected the inserts to be much faster. But I timed the time taken for a) ...
