Re: Buffer cache hit very low...!!!

  • From: David Sharples <davidsharples@xxxxxxxxx>
  • To: chiragdba@xxxxxxxxx
  • Date: Tue, 13 Sep 2005 22:10:01 +0100

well you rebuild your indexes (why are you doing this - saying FTS doesnt 
make sense as FTS's dont use indexes)
 if you rebuild indexes it will flood you buffer cache with rubbish so thats 
why your ratio is low, so you spend all morning doing PIO's which slow your 
users down.
 You seem fixed on rebuilding your indexes for everything, you may want to 
review that policy

 On 9/13/05, Chirag DBA <chiragdba@xxxxxxxxx> wrote: 
> 
> Still,
>  Well, Users are happy. but in the morning when they run large batch jobs, 
> yeah couple of guys do face some problems. As per my observations ,highest 
> waits were DB_SEQUENTIAL_WAITS.
>  So have done rebuilding of indexes as Sequential reads can be high 
> because of the FTS on the tables. Even for the 40GB Database, we have only 
> 250 MB SGA so which I am planning to increase. In normal day operation no 
> query is getting locked or taking very long to execute. 
>

Other related posts: