如何修改_hash_area_size 隐藏参数？

[jarry]

测试环境
【 OB
【 使用版本 】4.3.5.1
【问题描述】由于SQL会有大表的hash join，希望通过修改hash_area_size提高性能，但一直报语法错误。

obclient [SYS]> alter system set _hash_area_size = ‘64M’;
OBE-00900: You have an error in your SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use near ‘_hash_area_size = ‘64M’’ at line 1
obclient [SYS]> alter system set _hash_area_size=‘67108864’;
OBE-00900: You have an error in your SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use near ‘_hash_area_size=‘67108864’’ at line 1
obclient [SYS]> alter system set _hash_area_size=67108864;
OBE-00900: You have an error in your SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use near ‘_hash_area_size=67108864’ at line 1
obclient [SYS]>

先修改了workarea_size_policy=‘manual’ 之后也不行。

[来轩]

通过SYS租户修改吧，测试了一下业务租户修改不了 alter system set _sort_area_size=‘64M’ tenant=tenant_name;

[来轩]

[来轩]

alter system set “_sort_area_size” = ‘64M’; 这样执行

[dddddba]

如果不指定租户 默认使用的是哪个？

[jarry]

试了一下，在sys租户下执行不用加双引号。在普通租户下执行，需要加双引号。

[菜鸟收割机]

666