Re: Help for Oracle 7.3.2.3.

Hi !

Mehul Zaveri wrote:
>
> Dear friends ?
> Can somebody highlight on this :-
> How to see , who/which session is using a table / (or any object) ,
> directly or indirectly. (thru synoym / view) ?
> Oracle version I am using is 7.3.2.3 and P.O. 8.

Watch v$access and v$locked_object views.

					Bye:
						Bert
-- 
                                           :
 ----.----,  ------------------------------:----------------------------
   --;----"-----,  ,--------,  ,--------,  |     Bertalan Gombos
     |          |  ;--------'  |           |    software engineer
  ---|----------'  `--------   |           |  bgombos_at_freemail.c3.hu
`----'  ---------------------------------  `------------------------ '98