SQL Server Performance

SSIS 2008 - Data Extraction is dead slow while retrieving from oracle databse

Discussion in 'SQL Server 2008 Questions [Archive Only - Closed]' started by ashokksharma, Dec 27, 2010.

  1. ashokksharma New Member

    Hi
    When I tried to extract the data from oracle database it is dead slow. though my query is complex but it still it is taking 10 hours of time to retrieve 20 milions of record
    please advice some techniqes for faster retrivel.
    Thanks in advance.
    ashokksharma, Dec 27, 2010
    #2

  2. Luis Martin Moderator

    Welcome to the forums.
    Did you post the same question in Oracle forums?.
    May be your query need some indexes in Oracle database.
    Luis Martin, Dec 28, 2010
    #3

  3. satya Moderator

    Welcome to the forums.
    What you mean to say it is very slow?
    How many rows are you extracting?
    Did you check the network connectivity to that ORacle instance and any network related issues while this task is running. I see this as a network related problem and see the kind of query is executed between the products.
    satya, Dec 29, 2010
    #4

  4. RamJaddu Member

    RamJaddu, Jan 18, 2011
    #5

Share This Page