轉載詳細的Oracle ASH/AWR介紹及報告分析

http://space.itpub.net/?uid-35489-action-viewspace-itemid-697546

http://space.itpub.net/?uid-35489-action-viewspace-itemid-697550

另外，關於GCS/GES型別的等待事件，有以下說明：

I am seeing the wait events 'ges remote message', 'gcs remote message', and/or 'gcs for action'. What should I do about these?

These are idle wait events and can be safetly ignored. The 'ges remote message' might show up in a 9.0.1 statspack report as one of the top wait events. To have this wait event not show up you can add this event to the PERFSTAT.STATS$IDLE_EVENT table so that it is not listed in Statspack reports.