Re: Poor Buffer Hit Ratio

Never mind about your buffer cache, you've clearly got an application design / SQL design / Logical Data Model issue here!

Start looking at v$sql and v$sqlarea.

Extract the SQL statements that look difficult and 'replay' them either from SQL*Plus or alternatively, look at tracing SQL statement on a session or instance-wide basis. SQL Trace and TKProf can also help here.

David P.

Oracle Certified DBA.