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: Performance issue on table queries on increasing size of unrelated tables

Re: Performance issue on table queries on increasing size of unrelated tables

From: Daniel <danielroy10junk_at_hotmail.com>
Date: 26 May 2005 19:04:31 -0700
Message-ID: <1117159471.891091.97390@g14g2000cwa.googlegroups.com> 





My only theory as to why the growth of some unrelated table might
affect a query is that possibly these growing tables are using up more
of the buffer cache, and therefore you need more physical IO when
performing this unrelated query, slowing it down. Running the query
with autotrace on might help prove/disprove this theory.



Daniel
Received on Thu May 26 2005 - 21:04:31 CDT












Original text of this message













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