You might try the following (using the ReqStatus connection property): select *, connection_property('ReqStatus', sci.Number) as ReqStatus from sa_conn_info() sci order by 1; |
The following excerpt from the Foxhound Help for the purge process describes how Foxhound determines what connection-level data can be deleted because it is "uninteresting"; this goes beyond "idle" but it may be of interest to you: A connection is defined as "uninteresting" when all the following conditions are true for the previous and current samples recorded by the Foxhound Monitor for that connection:
Very sophisticated! I really would like to accept yours and Volkers answer. Anyway as only one can be choosen I will take Volkers because it is the more straight forward and fits more what I had in mind ;-)
(25 Jan '12, 12:07)
Martin
|
What about "LastReqTime" and "UncommitOps" in sa_conn_info's output?