Re: Finding which user has opened a table

On Feb 17, 1:15 pm, roger_vi...@yahoo.es wrote: > I have a question about finding which sessions are using a particular > table in case where the table is accessed by synonyms of another > instance. > > The case is the following: > > I have  two instances, and I have created a synonym in instance b for > table a > > For example: > In database_a@instance_a: > > create table table_a (> ... > ); > > In database_b@instance_b: > > create synonym syn1 on database_a@instance_a:table_a;> > In database "a" I need to know which sessions are using the table_a. > With this information, I find the process id (pid) > It's simple to know which sessions are using the table_a if this > sessions are in the same instance. > But sometimes, I get only sessions which pids belong to oninit > processes > > Is it possible to know which users are using the table in such > circumstances ? > > Thanks in advance Yon can find by table or by session, run this statement "onstat -g opn| grep ? " Where "?" you can use Partnum of the table in hex or rstcb address of your session.