topic Re: Oracle extension table space query time out in Extensions

Oracle extension table space query time out

Mizső — Wed, 14 Dec 2022 08:29:49 GMT

Hi @diego_morales ,

Is it possible extend the Oracle extension for configurable table space query time out. Now it is hard coded 10 sec.

One of our customers faced with this issue, maybe it will be useful for other clients too.

Thanks in advance.

Best regards,

János

Re: Oracle extension table space query time out

Mike_L — Wed, 14 Dec 2022 09:12:44 GMT

I'm not sure why you tagged Diego as he has absolutely nothing to do with the Oracle extension. That being said, which of the Oracle extensions are you using?

Re: Oracle extension table space query time out

Mizső — Wed, 14 Dec 2022 12:17:10 GMT

Hi @Mike_L,

Client use the 1.0.5 Oracle extension, I guess this is the latest one.

Regarding Diego, perviously I worked with him on other extension question. I thought he is a member of the extension development team and he can pass this information to the extension team.

Have a nice day.

Best regards,

Mizső

Re: Oracle extension table space query time out

Mizső — Fri, 13 Jan 2023 16:31:39 GMT

Hi @Mike_L,

Do you have any update for me based on the provided data? What dou you think? Would the latest 1.0.9. version help to the cutomer or the "Introduce 5 minutes interval for Most consuming SQL Queries" referring to other queries?

Thanks in advance for your help.

Best regards,

Mizső

Re: Oracle extension table space query time out

Mike_L — Fri, 13 Jan 2023 17:13:52 GMT

That is unrelated. That's relating to reporting of slow Oracle queries.

Re: Oracle extension table space query time out

Mike_L — Fri, 13 Jan 2023 17:14:47 GMT

Please open a support case for this issue. If our queries of the extension is timing out it'd make sense to increase it. Support can send that over to the data source team.

Re: Oracle extension table space query time out

Mizső — Fri, 13 Jan 2023 21:41:23 GMT

Hi @Mike_L ,

Thanks for your swift respones.

Best regards,

Mizső

Re: Oracle extension table space query time out

ayamaya — Wed, 01 Nov 2023 03:06:53 GMT

Hello, I have the same problem, when querying the table spaces in my DB, the query that the extension uses takes more than 10 seconds and this causes me to time out so that the activegate can recover the response and for reasons we do not see tablespace metrics.
Could you find a solution to this?

Re: Oracle extension table space query time out

Mizső — Wed, 01 Nov 2023 09:41:52 GMT

Hi @ayamaya,

Sorry but my client do not use the Oracle extesnion anymore, so I do not know the answer. I do not see any related information in the release notes. ☹️

Best regards,

Mizső

Re: Oracle extension table space query time out

ayamaya — Wed, 01 Nov 2023 15:25:12 GMT

Good morning, thank you very much, sorry.