11 2021 档案
摘要：1.获取程序运行时长 ps -eo pid,etime,cmd | grep 'server' | grep -v 'grep' 2.查看硬盘转速 sginfo -g /dev/sda
阅读全文
摘要：查询所有表和行数 SELECT a.name, b.rows FROM sysobjects AS a INNER JOIN sysindexes AS b ON a.id = b.id WHERE (a.type = 'u') AND (b.indid IN (0, 1)) ORDER BY b.
阅读全文
摘要：1、查看死锁是否存在select username,lockwait,status,machine,program from v$session where sid in(select session_id from v$locked_object);Username：死锁语句所用的数据库用户；Lo
阅读全文
