oracle RDBMS Kernel Executable 占用内存过高
oracle RDBMS Kernel Executable 占用内存过高
参考:https://www.cnblogs.com/markkang/archive/2019/11/25/11925406.html
cmd:sqlplus /nolog
连接数据库:conn / as sysdba;
Oracle 11g 版本后,可以修改MEMORY_MAX_TARGET 值来设置想要的内存(这里设置为 1024M):
- alter system set memory_max_target=1024M scope=SPFILE;
- 关闭数据库实例:shutdown immediate
- 启动Oracle实例:startup