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: how to Change parameter at statement level

Re: how to Change parameter at statement level

From: chao_ping <zhuchao_at_gmail.com>
Date: 24 May 2005 20:58:52 -0700
Message-ID: <1116993532.456726.29000@g49g2000cwa.googlegroups.com> 





Hi, Morgan,


    You can't tune the index fast full scan/table full scan to 100%
performance increase, but it is possible to get  30%  performance gain
via tune parameters like db_file_multiblock_read_count etc.


     What I want is, provided I can't tune the execution plan at remote
site, doing index fast full scan, I want to tune the index fast full
scan performance.



Look at the following sample:


DFMBC=8: 18 seconds.


DFMBC=128: 12 seconds.
Received on Tue May 24 2005 - 22:58:52 CDT












Original text of this message













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