1. 查询占据高水位的对象select owner,table_name,object_type, count(1) num_objfrom (select e.owner, nvl(nvl(t.table_name,l.table_name),i.table_name) table_name, case when t.table_name is not null then 'TABLE'&nb...【阅读全文】
ORACLE死锁(ORA-00060)故障排查的一般性手法【背景】今晨巡检发现SAP PRD产生一个死锁:Sun Jun 29 10:30:36 2014ORA-00060: Deadlock detected. More info in file /oracle/PRD/saptrace/diag/rdbms/prd/PRD/trace/PRD_ora_2065024.trc.网上找到一个不错的troubles...【阅读全文】