转载:Oracle的LOB(CLOB)大字段以及(SYS_LOB***$$)清理
Oracle的LOB(CLOB)大字段以及(SYS_LOB***$$)清理
bash-4.2# su - grid$ bashbash-4.2$ asmcmdASMCMD> lsdgState Type Rebal Sector Logical_Sector Block AU Total_MB Free_MB Req_mir_fre
确认存储过程是否死锁SELECT * FROM V$DB_OBJECT_CACHE WHERE name='PKG_TEST' AND LOCKS!='0';查出sid的值select SID from V$ACCESS WHERE object='PKG_TEST';查sid,serial#SEL
SELECT l.session_id sid, s.serial#, l.locked_mode, l.oracle_username, l.os_user_name, s.machine, s.terminal,
@TOC仅解析XML中某个标签中的值-- Created on 2020-12-23 by 20161 declare -- Local variables here --创建xml解析器实例xmlparser.Parser xmlPar xmlparser.Parse
select b.file_id 文件ID, b.tablespace_name 表空间, b.file_name 物理文件名, b.bytes 总字节数, (b.bytes-sum(nvl(a.bytes,0))) 已使用, sum(nvl(a.bytes,0