Transaction Elapsed Time

Hi folks,

Does somebody know a query to list active connections with their elapsed time? For example, in Oracle I can query V$SESSION to filter active sessions (ACTIVE=YES) and the elapsed_time for each connection.

Thanks!

long-running-query

asked 28 May '13, 15:57

Roger
126●5●5●10
accept rate: 0%

flat view

One Answer:

active answers oldest answers newest answers popular answers

2	Check out this blog post: Question: How do I list the active sessions and the elapsed times they are running? permanent link answered 28 May '13, 16:01 Breck Carter 32.5k●541●726●1050 accept rate: 20% flat view

Your answer

toggle preview

community wiki:

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

learn more about Markdown

Question tags:

long-running-query ×18

question asked: 28 May '13, 15:57

question was seen: 3,042 times

last updated: 28 May '13, 16:01

SAP SQL Anywhere

Transaction Elapsed Time

Follow this question

Related questions