who are currently accessing my table?

How can I know who are currently accessing a table?. I need to create an index or alter it but I cant because I dont have exclusive access. I know how many threads are connected, by using onstat -t, but I want to know which sessions they are. (my users dont close the applications at nigth) Thanks in advance Carlos

onstat -g ses "Carlos Kobashikawa C." <ckobashi@luzdelsur.com.pe> wrote in message news:8v48t0$8mt$1@news.xmission.com... > > How can I know who are currently accessing a table?. > I need to create an index or alter it but I cant because I dont have > exclusive access. I know how many threads are connected, by using onstat -t,> but I want to know which sessions they are. (my users dont close the > applications at nigth) > > Thanks in advance > > Carlos

Steve, this isnt so simple as you think. "onstat -g ses" (or -g sql) gives you the current query, but my table may have been opened within a transaction. I've tried that, searching every session in my server and I couldnt find the specific one, even when there were many threads connected to my table. That isnt the answer. In article <LeiR5.256846$3E6.2805316@news1.alsv1.occa.home.com>, "Steve Waggoner" <steve.dot.waggoner@integtech.dot.com> wrote: > onstat -g ses> > "Carlos Kobashikawa C." <ckobashi@luzdelsur.com.pe> wrote in message > news:8v48t0$8mt$1@news.xmission.com... > > > > How can I know who are currently accessing a table?. > > I need to create an index or alter it but I cant because I dont have > > exclusive access. I know how many threads are connected, by using > onstat -t,> > but I want to know which sessions they are. (my users dont close the > > applications at nigth) > > > > Thanks in advance > > > > Carlos > > Sent via Deja.com http://www.deja.com/ Before you buy.