topic Re: Oracle database increase session time in General Topics

Oracle database increase session time

Oblagonte — Thu, 21 Oct 2021 01:25:20 GMT

Hi All,

Our application use Oracle database and connect application via TCP 1521 and 7777. One session have to keep 24 hour and is it any ways to increase that time?

Thanks !!

Re: Oracle database increase session time

MP18 — Thu, 21 Oct 2021 02:46:49 GMT

@Oblagonte

Under Security Rule click on service where you have port TCP 1521 and 7777 click on port and override the session timeout to 24 hours

if you want it.

This will do for all the users but if you only want for single source IP then you can make new rule and add it before the existing rule and change the TCP service - override to 24 hours.

Regards

Re: Oracle database increase session time

MP18 — Thu, 21 Oct 2021 02:50:54 GMT

Re: Oracle database increase session time

MP18 — Thu, 21 Oct 2021 02:52:13 GMT

Re: Oracle database increase session time

Oblagonte — Thu, 21 Oct 2021 04:37:33 GMT

Thanks for the recommendation. If i want set session timeout to never, is it possible or there is limit on that?