|
|
Archives of the TeradataForum
Message Posted: Thu, 31 Mar 2005 @ 19:10:40 GMT
Subj: | | Re: Question on Concurrent sessions |
|
From: | | Anomy Anom |
<-- Anonymously Posted: Thursday, March 31, 2005 13:41 -->
| we do select * from dbc.sessioninfo and load into a table. | |
| we use crontab to run this on regular basis. | |
The crux of the issue is if user 'A' has 3 rows in the table (doesn't matter whether Logonoff or sessioninfo) with same logondates and
different logontimes with a difference of a second or some time none at all, how do you know that these 3 rows are concurrent sessions created by
one web user or by 3 different sessions created by 3 different users...? BTW we are on Windows platform.
| |