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 problem: anything else I can do to make this faster?

Re: Performance problem: anything else I can do to make this faster?

From: <sconover_at_gmail.com>
Date: 3 Mar 2005 13:59:39 -0800
Message-ID: <1109887179.762042.188670@l41g2000cwc.googlegroups.com> 





Yep, I gathered stats on the whole schema using
dbms_stats.gather_table_stats.



Does it make any sense that even just using the RBO a join of a table
with 1m rows with a table with 2m rows would take this long?  This
doesn't seem like a big deal in terms of what Oracle can handle.  Those
1.4m logical reads are what bother me...



Are there any obvious db environment / setup / config values that could
be off that would cause my problem?



-Steve
Received on Thu Mar 03 2005 - 15:59:39 CST












Original text of this message













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