SYS ADM: Oracle
重新啟動後運行出現問題
追蹤被打開了
問題描述
我的系統曾一次掉電
恢復電源後
它運行得非常慢
syslog並沒有錯誤
網絡活動也很正常
這是為什麼？
配置信息
操作系統
HP
UX
版本
硬件系統
HP
系列
K
Application
Oracle
and later
解決方法
問題在於 Oracle
的tracing
但是它被默認的打開了
用以下的步驟關閉tracing:
從$ORACLE_HOME/otrace/admin中刪除或重命名collect
dat
regid
dat 和process
dat 文件
設置這個環境變量
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
HP
UX
Version
Hardware System
HP
Series
K
Application
Oracle
and later
Solution
The problem is caused by tracing
which
for Oracle
and later
is turned on by default
Use these steps to turn off tracing:
Delete or rename the files collect
dat
regid
dat
and
process
dat 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
From:http://tw.wingwit.com/Article/program/Oracle/201311/17230.html
