Slow process while working thru DBLink
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Slow process while working thru DBLink

  1. #1
    Join Date
    Dec 2001
    Posts
    203

    Slow process while working thru DBLink

    Hi guys,

    I am trying to transfer(insert) 5000 rows from one database to another and it is taking too much time thru application.

    While the same process is taking 17 mnts in local database.

    I shall appreciate your suggestions.

    Regards
    sumit

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Are the platforms/setup the same on both databases, would performing the same insert locally on the destination take the same time as the primary?

    Have you looked at network bottlenecks?
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  3. #3
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    17 minutes to insert 5000 rows? What you running it on, a Palm Pilot?
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  4. #4
    Join Date
    Nov 2000
    Location
    Baltimore, MD USA
    Posts
    1,339
    The SQL and the plan are the important pieces of information here. Over-generalized questions generally elicit overly-general responses.

    The problem is most likely in the SELECT, and not the INSERT. When working across links, it is extremely important to control where the resulset is generated and restricted. Without the statement or plan, all I can tell you is to look into the DRIVING_SITE hint, and good luck.

    - Chris
    Christopher R. Long
    ChrisRLong@HotMail.Com
    But that's just my opinion. I could be wrong

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    In addition, operations over a dblink are inherently slower than local operations because the network is typically the bottleneck. There are also issues with two-phase commit that could potentially slow your application down.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width