We have an RAC env with 10gR2 on AIX server.
Everytime when cpu loading high, we always can found some procedure with high buffergets shown in AWR report. But it can't get more detail information in AWR sql report.
Our programmers say it hard to debug, because it hard to verify which SQL in this procedure really get problem. Any sugguestion to help them ?? Is there any utility or tool can drill down the more detail( beffergets / cpu usage .... ) of procedure/function??