Subject | Oldest transaction is stuck and slowing the database down |
---|---|
Author | kapsee |
Post date | 2006-02-23T21:10:15Z |
Hi:
I found some posts similar to this but did not completely answer my
question.
I am running into cases once in a while where the oldest transaction
is stuck (almost a million behind the next transaction) and is slowing
the database down. Is it possible to find out any details about that
transaction, like the tables in has touched, any sql it has run etc ?
Any other ways to debug this ?
Thanks a lot!
K
I found some posts similar to this but did not completely answer my
question.
I am running into cases once in a while where the oldest transaction
is stuck (almost a million behind the next transaction) and is slowing
the database down. Is it possible to find out any details about that
transaction, like the tables in has touched, any sql it has run etc ?
Any other ways to debug this ?
Thanks a lot!
K