|
Thanks for that reference. Setting it to "the number of processors less 1" makes good sense. And "normally this is set too high by default install" is a clear snap on the face of whoever at Oracle makes the fancy imagination in his ivory tower.
That article is about OLAP. I've always wondered whether I need to use that kind of stuff, when I see it as an option in database installation, and see the parameter olap_page_pool_size or those undocumented ones. Dbms_aw package is something I've never bothered to check. Not sure when I need it. According to
http://docs.oracle.com/cd/E11882 ... dml_app_dbms_aw.htm
it's for analytic workspace. But anyway, I assume the suggestion in the article is not necessarily specific to OLAP or AW.
When you say "关闭CPU的超线程", you mean disable it at OS level? Is there any specific reason you want to disable CPU hyperthreading? Or you just mean setting PARALLEL_THREADS_PER_CPU=1 in Oracle only? |
|