Database connections, session timeout | Community
Skip to main content
A
ashish_gra
Employee
August 11, 2022
Solved

Database connections, session timeout

  • August 11, 2022
  • 1 reply
  • 740 views

Hi all

I 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.

Thanks
Ashish

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by dsareen1

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

1 reply

D
dsareen1Accepted solution
Employee
August 14, 2022

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

    Terms & ConditionsAccessibility statement

    Loading footer...