Also check the power saving mode of the vm host(s). For reliable performance: high performance mode instead of balanced power saving

Great article, will reread it twice

MSDAORA is an old driver for Oracle.

Try OracleOleDB or the Attunity drivers

64-bit client version is oracle X.Y.Z.B? Like 11.2.0.2

congratulations

have a look at

alternative

Depends on selectivity (most distinct values goes) and the number of rows returned

WHERE clauses like Date BETWEEN a And B and Database = 'X'.

Assuming the most popular query relies on...

You'll have to check the NLS-settings of the database[/url]

In the earlier days in compares to varchar, but now the database can be fully in unicode so that varchar2 is also...

Did you also check "In Process" option? (should be enabled)

Answer: join mysummedhours with T_DM_HUMAN_RESOURCES

select mysummedhours.F_EMPLID, mysummedhours.Wk_Reported,summedworkhours

,T_DM_HUMAN_RESOURCES.F_RESOURCE_MGR_NAME

from

(

SELECT LP.F_EMPLID,to_char(LP.F_WK_END_DT, 'WW') Wk_Reported ,SUM( LP.F_CCSI_WORK_HRS) summedworkhours

from DW.T_DM_LABOR_PAYTIME LP

WHERE EXISTS (SELECT 1 FROM DW.T_DM_HUMAN_RESOURCES HR WHERE LP.F_EMPLID=T_DM_HUMAN_RESOURCES.F_RESOURCE_ID)

GROUP BY LP.F_EMPLID,to_char(LP.F_WK_END_DT, 'WW')

) mysummedhours

INNER JOIN

DW.T_DM_HUMAN_RESOURCES...

Grouped by LP.F_EMPLID and Wk_Reported

select mysummedhours.F_EMPLID, mysummedhours.Wk_Reported,summedworkhours

from

(

SELECT LP.F_EMPLID,to_char(LP.F_WK_END_DT, 'WW') Wk_Reported ,SUM( LP.F_CCSI_WORK_HRS) summedworkhours

from DW.T_DM_LABOR_PAYTIME LP

WHERE EXISTS (SELECT 1 FROM DW.T_DM_HUMAN_RESOURCES HR WHERE LP.F_EMPLID=T_DM_HUMAN_RESOURCES.F_RESOURCE_ID)

GROUP BY LP.F_EMPLID,to_char(LP.F_WK_END_DT, 'WW')

) mysummedhours

Glad it works now, what have you done to make it work?

Maybe it is related to oracle oledb fetchsize (default 100) OraOLEDB-Specific Connection String Attributes for Rowsets

Maybe it is related to oracle oledb fetchsize (default 100) OraOLEDB-Specific Connection String Attributes for Rowsets

There are more people having the issue like psubrama2000 who found a workaround workaround at the end.

What oracle driver/what version does the linked server use?