MySQL 8.0 Study 014 Tips
学习系列
Oracle drop user trace Tips
SYS@cdb1> drop user C##_U1;
drop user C##_U1
*
ERROR at line 1:
ORA-01922: CASCADE must be specified to drop 'C##_U1'
SYS@cdb1>
MySQL 8.0 Study 000 Tips
常用sql
Oracle kill sql lock Tips
--Oracle查询被锁对象数目 / Check lock objects
select count(1) from v$locked_object;
--查询被锁对象 / Check which objects
select b.owner,b.object_name,a.session_id,a.locked_mode from v$locked_object a,dba_objects b where b.object_id=a.object_id;
--查询被锁对象的连接 / Check connect infor for lock objects
alter session set nls_date_format = 'YYYY-MM-DD HH24:MI:SS';
select t2.username,t2.sid,t2.serial#,t2.logon_time from v$locked_object t1,v$session t2 where t1.session_id=t2.sid order by t2.logon_time;
--关闭被锁对象连接 / kill session which have lock.
alter system kill session '26,45052';
MySQL 8.0 Study 013 Tips
学习系列
MySQL 8.0 Study 012 Tips
学习系列
Oracle Migration Methods Advisor Tips
Oracle Linux Kernel Tips
MySQL 8.0 Study 011 Tips
学习系列
Oracle UNDO tablespace size Tips
MySQL 8.0 Study 010 Tips
学习系列
MySQL 8.0 Study 009 Tips
学习系列