Hi,

The views V$SQL and V$SQLAREA have the columns for buffer_gets, executions, rows_processed etc.

Sort your result on buffer_gets colums and select only the queries resulting in high buffergets. Also look for statements which are executed a few times but having high buffergets. You should tune these.

Baliga