how to find how many user connected to database a day

Hi all, 'onstat -g ses' show me who is currently connecting to server. Is there a way I can count how many users were connecting to server in a day or so? Any help would be appreciated. Thanh Ngo

What about onstat -u? What you get would not necessarily be the exact no users/day unless you log the result during peak period. The command would be: $onstat -u | tail You really need to monitor this in order to get #users/day. You cannot use this to get previous #users either unless you are logging it. -Jonathan In article <3A3A710F.FBE4F843@ti.com>, t-ngo@ti.com wrote: > Hi all, > 'onstat -g ses' show me who is currently connecting to > server. Is there a way I can count how many users were > connecting to server in a day or so? > > Any help would be appreciated. > > Thanh Ngo > Sent via Deja.com http://www.deja.com/

Thanh Ngo wrote: > > Hi all, > 'onstat -g ses' show me who is currently connecting to > server. Is there a way I can count how many users were > connecting to server in a day or so? > > Any help would be appreciated. Record, daily, the max session id from onstat -g ses and subtract from it the previous day's max. That is the number of sessions since yesterday. If you want add in any current sessions with a session id less than yesterday's max so as to count continuing sessions in each days total. If you want to be more precise and eliminate new system pseudo sessions subtract the number of session ids greater than yesterday's max that have a pid of zero (0). Art S. Kagel