高手教教

Question

我在操作这张表时候，能不能用sql语句查到别人也在操纵这张表？

Answer 1

可以通过动态试图v$locked_object来查询SQL> desc v$locked_object;
 名称                                      是否为空? 类型
 ----------------------------------------- -------- ----------------- XIDUSN                                             NUMBER
 XIDSLOT                                            NUMBER
 XIDSQN                                             NUMBER
 OBJECT_ID                                          NUMBER
 SESSION_ID                                         NUMBER
 ORACLE_USERNAME                                    VARCHAR2(30)
 OS_USER_NAME                                       VARCHAR2(30)
 PROCESS                                            VARCHAR2(12)
 LOCKED_MODE                                        NUMBER有object_ID, session和process信息， 你可以通过这些查到你需要的更多的东西可以用object_ID和all_objects表关联，从而通过object_name来做过滤。