2011年3月7日
摘要: select*fromv$database;select*fromv$datafile;--查询锁SELECTRPAD(oracle_username,10)o_name,session_idSID,DECODE(locked_mode,0,'None',1,'Null',2,'Rowshare',3,'RowExeclusive',4,'Share',5,'ShareRowExclusive',6,'Exclusive')lock_type,object_name,xidusn,x 阅读全文
posted @ 2011-03-07 14:12 Jeremy@sungard 阅读(217) 评论(0) 推荐(0) 编辑