2021年2月22日
Oracle check TBS usage
摘要： select d.tablespace_name, space||'M' "SUM_SPACE(M")", blocks "SUM_BLOCKS", space - nvl(free_space, 0) || ‘M’ “USED_SPACE(M)", round((1-nvl(free_space, 阅读全文
posted @ 2021-02-22 21:32 Orchidelle 阅读(60) 评论(0) 推荐(0)
Oracle kill locked sessions
摘要： select * from v$locked_object; select * from v$session where sid in (select session_id from v$locked_objects); -- kill locked session select 'alter sy 阅读全文
posted @ 2021-02-22 20:48 Orchidelle 阅读(124) 评论(0) 推荐(0)