Disconnect Inactive Users in Database - Timeout

L

leite1969

New Member
Dear,

Someone looking for a solution timeout in the database, ie an automatic way to topple inactive users for a given time (by means inactive, those sessions that did not any kind of transaction in the bank, leaving the session open) .

We develop a solution that makes the timeout of idle sessions as configured. If anyone is interested in testing, please send email to leite1969@yahoo.com.br we can send the routine to test.

Att.


Eduardo Leite
 
Is a session inactive simply by virtue of an absence of transactions? I disagree. Examples:
  • User is reading transaction tables to produce a report.
  • User is running compute-intensive, non-update code.
  • User is running I/O-intensive code (reading or writing a file or network).
  • User is reviewing audit data.
My applications have lots of very active human and batch users that can go a long time between transactions. But that doesn't mean they should be kicked out. Nor do I see any benefit from kicking them out.
 
You must log in or register to reply here.
Back
Top