Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

The duration of a database session

 
Jiafan Zhou
Ranch Hand
Posts: 193
Fedora Linux Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all,

I am wondering is it normal to know the duration of a connected database session, from the time a database connection was established to the time the connection was terminated. Considering the fact of using the database pool.

I thought this is a common user case, but after googling a while, I am surprised to find that most database products does not have this information.

I am not interested in the Timeout option due to the fact it is a different user case.


Thanks.
 
Wendy Gibbons
Bartender
Posts: 1111
Eclipse IDE Oracle VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I guess as nobody has commented in 5 days the answer is no, nobody else cares

 
Jiafan Zhou
Ranch Hand
Posts: 193
Fedora Linux Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Wendy Gibbons wrote:I guess as nobody has commented in 5 days the answer is no, nobody else cares



Yep, then how about the duration of database transaction?
 
Martin Vajsar
Sheriff
Posts: 3752
62
Chrome Netbeans IDE Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'd say most databases have tools to query active transactions and their age. But if you're speaking about past transactions, then I'm not sure. In any case, it would be heavily database dependent.

Does your database provide some sort of performance reports? If it does (which is probable), my advice would be to read the documentation about these reports to see whether something like this is included in them. If it isn't, my guess is that the database doesn't track it. One of measurements usually tracked by databases is number of transactions per seconds (TPS), but this is completely unrelated to their duration.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic