SYS ADM: Oracle 重新启动后运行出现问题追蹤被打开了
问题描述
我的系统曾一次掉电恢复电源后它运行得非常慢
syslog并没有错误网络活动也很正常
这是为什么?
配置信息
操作系统 HPUX
版本
硬件系统 HP
系列 K
Application Oracle and later
解决方法
问题在于 Oracle 的tracing但是它被默认的打开了
用以下的步骤关闭tracing:
从$ORACLE_HOME/otrace/admin中删除或重命名collectdat regiddat 和processdat 文件
设置这个环境变量
EPC_DISABLED=true
注意: 也要设置Oracle用户的profile 脚本
关闭并重新启动一个工作站确定响应是否变快
在SQL*Plus 中记入日志并确认改善后的响应时间
注意: 这个措施在其它工作站上也会起作用
following with all English text SYS ADM: Oracle performance problems after restart; tracing onProblem Description
My system lost power Ever since it came back up system
performance has been very slow There are no errors in syslog and network activity seems normal
What is causing this problem?
Configuration Info
Operating System HPUX
Version
Hardware System HP
Series K
Application Oracle and later
Solution
The problem is caused by tracing which for Oracle and lateris turned on by default
Use these steps to turn off tracing:
Delete or rename the files collectdat regiddat and
processdat from $ORACLE_HOME/otrace/admin
Set this environment variable
EPC_DISABLED=true
Note: Also make this setting the Oracle user profile script
Shut down and restart an instance to determine if response has improved
Log in to SQL*Plus to confirm improved response time
Note: These changes will only take effect in the other instances