1、db file sequential read

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

2、log file sync

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

3、db file scattered read

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

4、latch free – need p1,p2,p3

5、enqueue – need p1,p2,p3 and SQL

6、SQL*Net more data from client

減少數據傳輸，網絡優化

7、direct path read

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

8、direct path write

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

9、buffer busy waits – need p1,p2,p3 and SQL

10.SQL*Net more data to client

減少數據傳輸，網絡優化

11.log buffer space

加大log buffer

12.log file switch completion

加大log文件尺寸大小

13.library cache pin

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

14.SQL*Net break/reset to client

檢查SQL語句是否出錯

15.file open

減少log文件打開

16.free buffer waits

增加buffer cache size

17.db file parallel read

調整SQL，優化IO，加大buffer cache

18.write complete waits

增加buffer cache ，或者優化DBWR

20.library cache lock

避免同一時間進行硬解析

21.SQL*Net more data from dblink

減少數據傳輸，網絡優化

22.log file switch (checkpoint incomplete)

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

23.library cache load lock

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

24.row cache lock

need p1

25.local write wait

truncates / reduce cache size

降低cache size

26.sort segment request

SMON busy, PRocess rollback problem

SMON進出繁忙，rollback問題

27.process startup

在MTS情況下，增加init.ORA文件中min servers and dispatchers參數

28.file identify

降低CHECKPOINTS，保持文件打開

29.pipe put

加快pipe管道讀

30.switch logfile command

避免頻繁進行log切換

31.SQL*Net break/reset to dblink

檢查sql是否有誤

32.log file switch (archiving needed)

歸檔空間不足

33.direct path write (lob)

優化IO，減少lob讀寫

34.undo segment extension

Use UNDO or with RBS, increase RBS size, avoid OPTIMAL

35.undo segment tx slot

Use UNDO, increae # of RBS segs