ORACLE在HP-UX下的系列问题处理(20)

王朝oracle·作者佚名  2008-05-31
窄屏简体版  字體: |||超大  

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

 
 
 
免责声明:本文为网络用户发布,其观点仅代表作者个人观点,与本站无关,本站仅提供信息存储服务。文中陈述内容未经本站证实,其真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
 
© 2005- 王朝網路 版權所有 導航