Database connections, session timeout

Question

Hi allI want to ensure that the DB connections for inactive users are terminated after 30 mins of inactivity. There is a login user taking up a session almost every hour.How can we check the number of db connections in ACC?How can we check the user is inactive or not in ACC?How can we achieve that DB connections for inactive users are terminated after 30 mins of inactivity in ACC?Kindly help me out with this issue.
ThanksAshish

dsareen1 · Accepted Answer

Hi Ashish,

- How can we check the number of db connections in ACC?

Ans: If you are using postgres, you can check postgres DB reports or run following query, for count of DB connections:

SELECT sum(numbackends) FROM pg_stat_database;

- How can we check the user is inactive or not in ACC?

Ans: You can check in logins.log when user last logged in. It is not possible to check whether the logged in user is active or not.

- How can we achieve that DB connections for inactive users are terminated after 30 mins of inactivity in ACC?

Ans: Session expiration doesn't work at Client console level in ACC. It only works for web client.

Thanks,

Deepika

Sign up

Login with SSO

Login to the community

Login with SSO