随笔分类 -  数据库

摘要: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... 阅读全文
posted @ 2005-05-17 20:44 toddzhuang 阅读(640) 评论(0) 推荐(0) 编辑
摘要:SQL 设置不产生日志的ALTER DATABASE [pubs] SET RECOVERY SIMPLE即可,ALTER DATABASE [pubs] SET RECOVERY FULL是产生日志。 阅读全文
posted @ 2005-05-16 20:02 toddzhuang 阅读(995) 评论(0) 推荐(0) 编辑
摘要:select * from dbo.sysfilesDBCC SHRINKFILE ('hrms_Data',7) 阅读全文
posted @ 2005-05-16 19:36 toddzhuang 阅读(364) 评论(0) 推荐(0) 编辑
摘要:SET NOCOUNT ONDECLARE @LogicalFileName sysname,@MaxMinutes INT,@NewSize INTUSE joekoe -- 要操作的数据库名SELECT @LogicalFileName = 'joekoe_log', -- 日志文件名,注意这里是逻辑文件名@MaxMinutes = 10, -- Limit on time allowed t... 阅读全文
posted @ 2005-05-16 19:27 toddzhuang 阅读(442) 评论(0) 推荐(0) 编辑

点击右上角即可分享
微信分享提示