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 <http://a.id>,b.name <http://b.name> from a@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.
--
Regards
Zhu Chao
www.cnoug.org <http://www.cnoug.org>
--
http://www.freelists.org/webpage/oracle-l
Received on Sat May 21 2005 - 03:19:44 CDT
