Re: Oracle 7.3.4-8.1.7-9.2 Gateway performance
- From: Jared Still <jkstill@xxxxxxxxx>
- To: rlsmith@xxxxxxx
- Date: Mon, 20 Sep 2004 10:27:42 -0700
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@xxxxxxx> 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
> --
> //www.freelists.org/webpage/oracle-l
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
