how to Change parameter at statement level

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. Received on Mon May 23 2005 - 06:49:53 CDT