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

wait等待事件及其處理方法

2013-11-13 16:04:55  來源: Oracle 

  wait等待事件及其處理方法

  db file sequential read

  調整SQL增加buffer cache加快磁盤讀寫速度

  log file sync

  減少事務提交將redo文件存放於高速硬盤

  db file scattered read

  FTS調整SQL增加索引加快磁盤讀寫速度

  latch free – need ppp

  enqueue – need ppp and SQL

  SQL*Net more data from client

  減少數據傳輸網絡優化

  direct path read

  排序問題調整IO或者減少排序

  direct path write

  直接路徑訪問問題加快磁盤讀寫速度

  buffer busy waits – need ppp and SQL

  SQL*Net more data to client

  減少數據傳輸網絡優化

  log buffer space

  加大log buffer

  log file switch completion

  加大log文件尺寸大小

  library cache pin

  減少相同游標的並發解析比如綁定變量

  SQL*Net break/reset to client

  檢查SQL語句是否出錯

  file open

  減少log文件打開

  free buffer waits

  增加buffer cache size

  db file parallel read

  調整SQL優化IO加大buffer cache

  write complete waits

  增加buffer cache 或者優化DBWR

  library cache lock

  避免同一時間進行硬解析

  SQL*Net more data from dblink

  減少數據傳輸網絡優化

  log file switch (checkpoint incomplete)

  增加log文件或者調整加大log文件的大小


    library cache load lock

  避免同一時間cursor進行硬解析

  row cache lock

  need p

  local write wait

  truncates / reduce cache size

  降低cache size

  sort segment request

  SMON busy process rollback problem

  SMON進出繁忙rollback問題

  process startup

  在MTS情況下增加initORA文件中min servers and dispatchers參數

  file identify

  降低CHECKPOINTS保持文件打開

  pipe put

  加快pipe管道讀

  switch logfile command

  避免頻繁進行log切換

  SQL*Net break/reset to dblink

  檢查sql是否有誤

  log file switch (archiving needed)

  歸檔空間不足

  direct path write (lob)

  優化IO減少lob讀寫

  undo segment extension

  Use UNDO or with RBS increase RBS size avoid OPTIMAL

  undo segment tx slot

  Use UNDO increae # of RBS segs


From:http://tw.wingwit.com/Article/program/Oracle/201311/17779.html
    推薦文章
    Copyright © 2005-2013 電腦知識網 Computer Knowledge   All rights reserved.