Re: User Flags

Marius G Dreyer wrote: > > Hi Everyone...... > > A simple question ? > > When one do a onstat -u you get all the users currently logged onto the > database. > You also get the flags per session ie. Y--P--- > > Now the question. Where in the SMI tables can I do a select to give the > flags for a session ? If I select from userthreads, i get a column called > flags, but it is an integer. > Is there a way to "decode" that ? > > Many thanks in advance > > Cheers > Marius Hi Marius, I really don't know anything about these flags, especially about "Y" and "P". I think I should read the FM. But inside your sysmaster.sql script there you will find a view called "syssessions" where a lot of bits of this "flags" field are masked. I think it must be easy for you to find the corresponding bits for the value "Y" and "P". Bye Stefan