Re: v$session Question

Ken Halsted wrote:
>
> I'm trying to see who is logged in to our database and was wanting to use
> the v$session table to do it but I have a question about how often does the
> STATUS column of that table get updated because it seems that it takes
> forever for this to update. It contains 'ACTIVE' or 'INACTIVE' it seems.
> It's very unreliable though. Does anyone know how I can see only users who
> are currently logged on to the database?
>
> Thanks for any help at all.
>
> Ken.
>
> --
> _________________
> Kenneth W. Halsted
> Mountaire Corporation
> ph: (501) 399-8812
> url: http://www.mountaire.com
> email: kenman_at_mail.snider.net

ACTIVE is if they are "doing" something....Anyone who is on V$SESSION is already logged on...

-- 
===========================================
Connor McDonald
"These views mine, no-one elses etc etc"
connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue."