Hi. AFAIK the idle time information is not available (yet?). The only idle time which is available is the UKT idle time. To get it, you have to enable time information collection (x_cons DBNAME time enable) and then use (x_cons DBNAME show sleep) to get the idle status of all UKTs. Unfortunatly this only works if all tasks are idle and shows therefore only the idle time of the last task that became idle in the corresponding UKT. CU jrg
> -----Original Message----- > From: Robert Kr�ger [mailto:krueger@;signal7.de] > Sent: Montag, 28. Oktober 2002 17:52 > To: [EMAIL PROTECTED] > Subject: Re: how to find out session age > > > > thanks a lot. is there a way to find out how long the > connection has been > idle? > > regards, > > robert > > > On Monday 28 October 2002 16:29, Hahn, Uwe wrote: > > Please try: select username,date,time from transactions > > > > regards > > Uwe > > > > > -----Original Message----- > > > From: Robert Kr�ger [mailto:krueger@;signal7.de] > > > Sent: Montag, 28. Oktober 2002 15:56 > > > To: [EMAIL PROTECTED] > > > Subject: how to find out session age > > > > > > > > > > > > Hi, > > > > > > is there a way to query system tables for the age of a > > > database session? I > > > didn't find it in the docs but I'm sure there must be a table > > > containing this > > > information ("CONNECTEDUSERS" doesnt). > > > > > > Thanks in advance, > > > > > > Robert > > > > > > > > > > > > > > > _______________________________________________ > > > sapdb.general mailing list > > > [EMAIL PROTECTED] > > > http://listserv.sap.com/mailman/listinfo/sapdb.general > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
