Re: how to Change parameter at statement level

Hi, seems we have a mis-understand between you and me. I don't think alter session at this instance can change the parameter at remote instance, this is why I am posting this question.

To Morgan,
  The actual problem is more complicated. The actual query is like: select a.id, b.name, b.address from site_notes_at_admindb a, site_user b where a.last_modify_date > sysdate and a.last_modify_date < sysdate -1 and a.id=b.id;

There is an index on site_notes_at_admindb (id, last_modify_date), as oracle version is 8.1.7, skip scan is not avaliable. and I don't want to build another index (last_modify_date, id). So I will have to do a index fast full scan on admindb.

Given the best plan I can get, I want to tune the index_ffs on remote admindb.
Does anyone have a valid solution about this? Thanks Received on Tue May 24 2005 - 04:10:27 CDT