sallywu1218的专栏

SELECT s.sid,s.serial#,p.spid,l.oracle_username,l.os_user_name,d.object_name,l.locked_mode FROM v$locked_object l,dba_objects d,v$session s,v$process p WHERE d.object_id= l.object_id AND l.session_

select sys.v_$session.osuser,sys.v_$session.machine,v$lock.sid,    sys.v_$session.serial#, decode(v$lock.type, 'MR', 'Media Recovery',   'RT','Redo Thread', 'UN','User Name', 'TX', 'Transaction'

IF your oracle has account expire error, pls execute following command:   su - oracle sqlplus / as sysdba alter user mals60 account unlock; alter user mals60 identified by mals60;

PK 查询 select cu.* from user_cons_columns cu, user_constraints au where cu.constraint_name = au.constraint_name and au.constraint_type = 'P' and au.table_name = 'RNWDATATABLELTE'; 删除