Re: how to Change parameter at statement level

chao_ping wrote:
> 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.

You said it is a remote database. Any DBA that would let you have remote access to change an init parameter should turn in his or her security badge.

That's not tuning a query ... that's tuning the entire instance.

-- 
Daniel A. Morgan
Relational theory is not something that is simply a nice-to-have.
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)