SYS ADM: Oracle 7.3.2 重新启动后运行出现问题:追踪被打开了
问题描述
我的系统曾一次掉电,恢复电源后,它运行得非常慢。
syslog并没有错误,网络活动也很正常。
这是为什么?
配置信息
操作系统 - HP-UX
版本 - 10.20
硬件系统 - HP9000
系列 -K210
Application - Oracle 7.3.2 and later
解决方法
问题在于 Oracle 7.3.2 的tracing,但是它被默认的打开了.
用以下的步骤关闭tracing:
1.从$ORACLE_HOME/otrace/admin中删除或重命名collect.dat , regid.dat 和process.dat 文件.
2. 设置这个环境变量.
EPC_DISABLED=true
注重: 也要设置Oracle用户的profile. 脚本.
3. 关闭并重新启动一个工作站,确定响应是否变快.
4. 在SQL*Plus 中记入日志,并确认改善后的响应时间.
注重: 这个措施在其它工作站上也会起作用
.........following with all English text ....SYS ADM: Oracle 7.3.2 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 - HP-UX
Version - 10.20
Hardware System - HP9000
Series - K210
Application - Oracle 7.3.2 and later
Solution
The problem is caused by tracing, which, for Oracle 7.3.2 and later,is turned on by default.
Use these steps to turn off tracing:
1. Delete or rename the files collect.dat, regid.dat, and
process.dat from $ORACLE_HOME/otrace/admin.
2. Set this environment variable.
EPC_DISABLED=true
Note: Also make this setting the Oracle user profile. script.
3. Shut down and restart an instance to determine if response has improved.
4. Log in to SQL*Plus to confirm improved response time.
Note: These changes will only take effect in the other instances