Before the SQL server use DBLINK query oracle
Select * from MES... ZMES. TBLINVINTRANSACTION A time WHERE XXX s
Using the new method
Select * from OPENQUERY (MES, 'select * from ZMES. TBLINVINTRANSACTION WHERE A... ') 62 s
Use the openquery should be faster, isn't it, why instead of a times slower