为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM Database Server 64 V8
【操作系统】:Red Hat Enterprise Linux Server release 7.6 (Maipo)
【CPU】: x86_64
【问题描述】*:
在
https://eco.dameng.com/document/dm/zh-cn/ops/installation-install.html#2.1%20%E6%95%B0%E6%8D%AE%E5%BA%93%E5%8F%82%E6%95%B0%E4%BC%98%E5%8C%96%E8%B0%83%E6%95%B4
提到的脚本,拿到服务器上执行报错:
PRINT ‘SP_SET_PARA_VALUE(2,’‘OPTIMIZER_MODE’‘,1);’;
PRINT ‘SP_SET_PARA_VALUE(2,’‘ADAPTIVE_NPLN_FLAG’‘,0);’;
PRINT ‘SP_SET_PARA_VALUE(2,’‘PARALLEL_PURGE_FLAG’‘,1);’;
PRINT ‘SP_SET_PARA_VALUE(2,’‘PARALLEL_POLICY’‘,2);’;
PRINT ‘SP_SET_PARA_VALUE(2,’‘UNDO_EXTENT_NUM’‘,16);’;
PRINT ‘SP_SET_PARA_VALUE(2,’‘ENABLE_INJECT_HINT’‘,1);’;
END IF;
select MEMORY_TARGET+BUFFER+RECYCLE+HJ_BUF_GLOBAL_SIZE+HAGR_BUF_GLOBAL_SIZE+CACHE_POOL_SIZE
+DICT_BUF_SIZE+SORT_BUF_GLOBAL_SIZE+RLOG_POOL_SIZE;
exception
when others then
raise_application_error (-20001,substr( ’ 执行失败, ‘||SQLCODE||’ ‘||SQLERRM||’ '||dbms_utility.format_error_backtrace , 1, 400));
<<return_2000>> null;
end;
The script file is not complete,last sql has not been executed.
SQL>
SQL>
用命令行执行需要在脚本最后一行加上/