how toChange parameter at statement level
- From: zhu chao <zhuchao@xxxxxxxxx>
- To: "Oracle-L (oracle-l@xxxxxxxxxxxxx)" <oracle-l@xxxxxxxxxxxxx>
- Date: Sat, 21 May 2005 15:15:03 +0800
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@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>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » how toChange parameter at statement level
