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?

Or you could use heavy duty material to remove the tree (bulldozer, tractors, chainsaws...). The options keep growing.

Payback for my excellend sql server teacher and others on this forum.

Working with Oracle subforum: Driver mania

I have no experience with SSIS but would leave a minimum of 2 GB for the OS/other applications (max memory<6 GB).

Have a look at

Sql server best practices on technet

MSDN

Specific on...

As an accidental Oracle dba myself (coming from sql server 2000) I've found the Oracle concepts most interesting to grasp what the main differences are.

After that backup/restore (rman, needs...

if it is an index, you could try to drop it and rebuild

Maybe we will wait until Release 2 comes out. By the time it is well established.

Have you checked for double-hop issues?

Technet

Forum post

Had no troubles with ora oledb so far. Selecting 10000 rows works fine. Perhaps a mismatch in "case" with the CaSe sensiTive Oracle?

I still need to test against some linked...

Why don't you use the CASE-statement instead of decode?

sum (CASE WHEN ACTIVITY='X' OR ACTIVITY='Y' ... THEN 1 ELSE 0 END)

Also have a look an analytical functions for Oracle.

What is your current bottleneck? Cpu, I/O ...?

what oracle driver did you install on the sql server ? 9i, 10g, 11g?