摘要: 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 阅读(49) 评论(0) 推荐(0) 编辑
摘要: 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 阅读(112) 评论(0) 推荐(0) 编辑