Migration query taking time I'm doing a migration from Oracle to SQL Server and, for one of the tables where we have 3 million records, it is taking a lot of time to complete.

When I check the activity monitor, I can see the a wait type of PREEMPTIVE_COM_SEQSTRMREAD. Please help me understand what could be the issue.

I'm using linked server to connect Oracle from SQL Server.
To find out more about the PREEMPTIVE_COM_SEQSTRMREAD wait type I would read this great article at sqlauthority, but as Shanky said in the comments, SSIS would more than likely serve you better for a large migration.