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: Varying query performance

Re: Varying query performance

From: srivenu <srivenu_at_hotmail.com>
Date: 28 Dec 2003 04:24:16 -0800
Message-ID: <1a68177.0312280424.22699bd6@posting.google.com> 





sev,


The number of buffers needed for the table are more than the number of
blocks in the table below HWM.


This is because the query needs CR buffers whereas INSERTS and UPDATES
need CURRENT Buffers.


You can check all these in V$BH.


Just check whether the UPDATES are being done with an INDEX scan or
FTS.



regards


Srivenu
Received on Sun Dec 28 2003 - 06:24:16 CST












Original text of this message













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