随笔分类 - 数据库
摘要:1. 监控事例的等待 select event,sum(decode(wait_Time,0,0,1)) "Prev", sum(decode(wait_Time,0,1,0)) "Curr",count(*) "Tot" from v$session_Wait group by event order by 4; 2. 回滚段的争用情况 select name, waits, gets, wa...
阅读全文
摘要:SQL 设置不产生日志的ALTER DATABASE [pubs] SET RECOVERY SIMPLE即可,ALTER DATABASE [pubs] SET RECOVERY FULL是产生日志。
阅读全文
摘要:select * from dbo.sysfilesDBCC SHRINKFILE ('hrms_Data',7)
阅读全文
摘要:SET NOCOUNT ONDECLARE @LogicalFileName sysname,@MaxMinutes INT,@NewSize INTUSE joekoe -- 要操作的数据库名SELECT @LogicalFileName = 'joekoe_log', -- 日志文件名,注意这里是逻辑文件名@MaxMinutes = 10, -- Limit on time allowed t...
阅读全文