熱點推薦:
您现在的位置: 電腦知識網 >> 編程 >> Oracle >> 正文

ORACLE在HP-UX下的系列問題處理(20)

2013-11-13 15:44:30  來源: Oracle 

  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
  
  
  

From:http://tw.wingwit.com/Article/program/Oracle/201311/17230.html
  • 上一篇文章:

  • 下一篇文章:
  • 推薦文章
    Copyright © 2005-2013 電腦知識網 Computer Knowledge   All rights reserved.