Re: how to Change parameter at statement level

chao_ping wrote:
> We often use alter session set parameter_name=value, to tune some
> specific SQL.
> But for example we have such a case:
> select a.id,b.name from a_at_dblink ,b
> where a.col1=b.col1
> and a.id=:b1;
>
> But unfortunately table a_at_dblink is huge and no proper index we can
use
> , and I have to use full table scan to scan the big table. I want to
> increate the Db_file_multiblock_read_count for that table a full scan
> to get better performance. How to make it?
> I remember I have seen it from google someone suggest we can use
> /*+parameter db_file_multiblock_read_count=128*/ etc to get such
> result, but I can't make it.
>
> Can someone who knows can give some idea/test case?
>
> Thanks Very much.

No Oracle version, no O/S. How, then, can you expect any valid help?

Also, I don't understand why you state "no proper index we can use". With queries across database links using 9.2.0.6 I have no problem using the existing indexes.

Post your Oracle version, your O/S and the query plan showing the indexes are not used on the remote table. Possibly it's a problem with Oracle on your specific O/S.

David Fitzjarrell Received on Mon May 23 2005 - 11:17:16 CDT