Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: low buffer_hit_rate !!!!!

Re: low buffer_hit_rate !!!!!

From: Phil Cook <pncook_at_worldnet.att.net>
Date: 1997/12/20
Message-ID: <67f9h7$sbu@bgtnsc02.worldnet.att.net>#1/1 







Something else to check is the number of full table scans
that your applications are performing, especially on larger tables.
These blocks will never be in the buffer cache.  Look at your 
high io tables in v$sqlarea and then run explain plan.  There
are a number of tools on the market that can perform this
analysis automatically.



Phil Cook


Certified Oracle DBA
Received on Sat Dec 20 1997 - 00:00:00 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US