Re: Has anyone else seen a huge slowdown Oracle Gateway connections to SQL Server when moving from Gateway 11g to 12c?

Hi Jay,

I don't see big value in oracle events for your issue. Do you consider setting
HS_FDS_TRACE_LEVEL=DEBUG
on your gateway to see more details?

please share your findings,
 Martin

-- 
Martin Berger                Oracle ♠
martin.a.berger_at_gmail.com _at_martinberx <https://twitter.com/martinberx>
^∆x      http://berxblog.blogspot.com



Am Fr., 1. Nov. 2019 um 16:43 Uhr schrieb Redacted sender Jay.Miller for
DMARC <dmarc-noreply_at_freelists.org>:



> We have an Oracle Gateway connection from a 12.1 Oracle database to a SQL


> Server 2012 database. It has connected through a separate Windows 2008

> Oracle 11.2.0.1 Gateway server for many years with no issues.

>

>

>

> We set up a new 12.2.0.1 Oracle Gateway server on Windows 2012 to test but

> all queries run very slowly and then start hanging.  We’re opening a SR but

> thought I’d ask if anyone here has seen something similar.

>

>

>

> On the database side the session shows it’s waiting on *HS message to

> agent*.

>

>

>

> Could it be an issue with the Gateway being 12.2 and the database being

> 12.1? I tried to find the certification matrix but metalink said:

>

> Oracle Gateway Release's

> The certification matrix for the 11.1, 11.2 and 12c Gateways is now

> available on OTN from the following URL -

>

> http://www.oracle.com/technetwork/database/gateways/index.html

>

> and that gives an error “We can’t find the page you were looking for”

>

>

>

> Any advice appreciated.

>

>

>

> Thanks,

>

> Jay Miller

>

> Sr. Oracle DBA

>


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