Test resource is busy or not for ORACLE

Some time, we have no system or dba role, we must use schema ownere to test the resource busy or not

follow is the test:

// start sqlplus1 drop table t_log; create table t_log( myid integer, logname varchar(100));

insert into t_log values(1, 'log1');

update t_log set  logname= 'log12345' where myid=1; //here no commit

// start sqlplus2 select * from t_log where myid=1  for update nowait; // ora-00054

select * from t_log where myid=1  for update wait 1; (s) // ora-30006

转载于:https://www.cnblogs.com/cquccy/p/3430842.html