RE: Dblink Insert too slow HELP!!!

I'm not clear which piece(s) are unmodifiable vendor code. Is it that you have a vendor application that only runs on v7 and another vendor application that you've got on v9 and you just generically need data from the v7 database in the v9 database? Excuse the rest if I've got that wrong. I'm having trouble imagining that someone wrote an application striding requiring part on v7 and part on v9 so I'm trying to make up a scenario I grok.

If I've got that right, then what is the bit on 8.1.7? Again, I'm guessing that rather than database, you mean software linked against 8.1.7 libraries so that it is able to talk to both 7.x and 9.x.

>From what you wrote, it seems that this is a one-way pipe and that the
select part is fine. So, why not just produce a file suitable for loader or external access and deposit the file local to the 9.x database?

If I'm way off target on my guesses, please elaborate a bit more on your situation.

Regards,

mwf

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Smith, Ron L. Sent: Monday, September 27, 2004 1:46 PM To: ORACLE-L
Subject: Dblink Insert too slow HELP!!!

I am using an 8.1.7 database as a gateway to do inserts from a 7.3.4 database to a 9.2 database. The reads are fast enough but inserts take forever. Updates that should run in minutes are taking hours. We have tried dropping the indexes but it makes no difference. Both applications are purchased vendor code and cannot be modified. So I need to find a solution for the slow inserts.

Thanks!
Ron

Important Notice!!
If you are not the intended recipient of this e-mail message, any use, = distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received = this message by mistake, then delete the e-mail message. Thank you.

--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l