The forum will be down for maintenance over the weekend of August 18-20, 2017. The forum will be shut down on the evening (EDT) of Friday, August 18. Downtime is unknown but may be up to two days. The forum will be restarted as soon as maintenance is complete.

Our product currently use SA 12.0.1.3873 on Linux OS. Since SA 12.0.1.3324 we are trying check and use intra-query parallelism mechanism. As known MAX_QUERY_TASKS option by default is set to 0 (maximum level of parallelism). In our experience we didn't see results of intra-query parallelism furthemore some of queries have encountered with endless loop processing or drop connection problems. Due these problems we set this option to 1 (prevent intra-query parallelism using). In last EBF's readme files we found fixes related to parallelism. For some tests we set MAX_QUERY_TASKS back to N/2 (where N count of logical processors) and saw in top output that realy were used N/2 processors. Our question - is the some recommendation to set MAX_QUERY_TASKS option regarding to number of logical processors; how last fixes have improved intra-query parallelism using

Thanks , Hanan Brener

asked 18 Dec '13, 12:52

HBrener's gravatar image

HBrener
426212333
accept rate: 0%

Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×61

question asked: 18 Dec '13, 12:52

question was seen: 411 times

last updated: 18 Dec '13, 12:52