Re: Oracle 7.3.4-8.1.7-9.2 Gateway performance

What leads you to believe the problem is in the 8.1.7 database?

note: Rewrite your updates in Perl with DBI, compile the DBD::Oracle with Oracle 8.1.7 and use it for your Oracle home.

Via DBI you can make connections to both the 7.3.4 and 9.2 databases, and skip the 8i database altogether. You just have to retain the 8i binaries so that you can connect to both vs 7 and 9.

Jared

On Mon, 20 Sep 2004 08:27:35 -0500, Smith, Ron L. <rlsmith_at_kmg.com> wrote:
> We are using Oracle 8.1.7 as a gateway between 7.3.4 and 9.2 for updates
> and inserts.
> We are experiencing problems with what appears to be the 8.1.7 server.
> After several hours of updates (a few thousand updates) the response
> begins to deteriorate and becomes unacceptable.
>
> All that is in the 8.1.7 database is synonyms and dblinks.
>
> Has anyone experienced this problem?
>
> Thanks!
> Ron
> --
> http://www.freelists.org/webpage/oracle-l
>

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