数据库服务器内存由16G增加为64G,为充分利用内存资源,对Oracle内存参数做了如下调整: SQL>alter system set sga_max_size=40960M scope=spfile; SQL>alter system set sga_target=40960M scope=spfile; SQL>alter system set pga_aggregate_target=10240M scope=spfile; 在重启数据库时出现如下报错: SQL> shut
1.查看已分配内存,看到memory_max_target为20GSQL> show parameter sga NAME TYPE VALUE------------------------------------ ----------- ------------------------------lock_sga boolean FALSEpre_page_sga bool
今天测试服务器遇到问题 ORA-04030:out of process memory when trying to allocate string bytes 一看就猜到是内存不足了,把Oracle给累坏了 Oracle版本:Oracle 10.2.0 操作系统:Windows Server 2003 于是,直接查了下怎么修改Oracle内存大小的命令: alter system set sga_max_size=2048M scope=spfile; 然后果断重启Oracle,于是杯具就产生
Don’t confuse error 823 and error 832 本文大意: 错误832: A page that should have been constant has changed (expected checksum: 1dcb28a7, actual checksum: 68c626bb, database 13, file 'E:\Program Files\microsoft sql server\MSSQL\data\BlahBlah.
使用jdk的jconsole进行监控jmx 首先,设置监控对象的端口 配置 catalina.sh #vi /usr/tomcat/bin/catalina.sh 注: /usr/tomcat/bin/catalina.sh 是 tomcat所在目录的bin目录 (linux环境下) 在 # OS specific support. $var _must_ be set to either true or false.之前添加内容 # JAVA_OPTS 设置内存 JAVA_OPTS="