新手求助查询table1表格是否锁定的语句怎么写？

Question

查询table1表格是否锁定的语句怎么写？
查询某个用户是否锁定又怎么写？？？
新手，谢谢

Answer 1

以SYSDBA的角色登录。1、select   p.spid,c.object_name,b.session_id,b.oracle_username,b.os_user_name   
from   v$process   p,v$session   a,   v$locked_object   b,all_objects   c   
where   p.addr=a.paddr   and   a.process=b.process   and   c.object_id=b.object_id   
    2、SELECT * FROM DBA_USERS

Answer 2

查看该sql语句是否在session_wait中

Answer 3

用SYS登陆--查看表是否锁定
SQL> SELECT table_name,status FROM DBA_TABLES WHERE table_name='EMP';TABLE_NAME                     STATUS                                           
------------------------------ --------                                         
EMP                            VALID                                            --查看用户是否解锁
SELECT username,account_status FROM dba_users;USERNAME                       ACCOUNT_STATUS                                   
------------------------------ --------------------------------                 
MGMT_VIEW                      OPEN                                             
SYS                            OPEN                                             
SYSTEM                         OPEN                                             
DBSNMP                         OPEN                                             
SYSMAN                         OPEN                                             
SCOTT                          OPEN                                             
OUTLN                          EXPIRED & LOCKED                                 
MDSYS                          EXPIRED & LOCKED                                 
ORDSYS                         EXPIRED & LOCKED                                 
CTXSYS                         EXPIRED & LOCKED                                 
ANONYMOUS                      EXPIRED & LOCKED                                 USERNAME                       ACCOUNT_STATUS                                   
------------------------------ --------------------------------                 
EXFSYS                         EXPIRED & LOCKED                                 
DMSYS                          EXPIRED & LOCKED                                 
WMSYS                          EXPIRED & LOCKED                                 
XDB                            EXPIRED & LOCKED                                 
ORDPLUGINS                     EXPIRED & LOCKED                                 
SI_INFORMTN_SCHEMA             EXPIRED & LOCKED                                 
OLAPSYS                        EXPIRED & LOCKED                                 
MDDATA                         EXPIRED & LOCKED                                 
DIP                            EXPIRED & LOCKED                                 
TSMSYS                         EXPIRED & LOCKED                                 已选择21行。