ORACLE在HP-UX下的系列問題處理(20)
2024-08-29 13:39:45
供稿:網友
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