Re: Information about tables in use?!

Hi! I'd just add that there is an undocumented onstat option, -T, which does the same thing as -t, but list ALL that are cached, not only the active ones. I've found a use or two for this puppy. It's been around since 7.10.UD1 at least I think.... Rgds Karlsson Art S. Kagel wrote: > Mr Cheuk Kong Lo wrote: > > > > I'd like to know if there is a way to find out what tables are in > use > > by a user (thread). Any possible of knowing what row is current in > use > > by a user (thread) as well? > > > > Onstat -g opn shows open tables by thread id. Onstat -k will show > locked rows/pages by rstcb which can be translated to thread id in > onstat -u. You cannot track rows which are not locked.> > Art S. Kagel