2018年12月27日
oracle问题处理sql
摘要： select * from DBA_HIST_SYSMETRIC_SUMMARY; select sum(inserts) inserts, sum(UPDATES) UPDATES, sum(DELETES) DELETES from dba_tab_modifications where TAB 阅读全文
posted @ 2018-12-27 18:54 Qtong 阅读(263) 评论(0) 推荐(0)
oracel 密码延时特性；更改 pfile导致启动报错ORA-49601: syntax error: found "%s": expecting one of: "%s" etc
摘要： [oracle@db ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Wed Dec 26 13:04:11 2018 Copyright (c) 1982, 2013, Oracle. All rights re 阅读全文
posted @ 2018-12-27 18:52 Qtong 阅读(696) 评论(0) 推荐(0)
sqlserver 开启快照
摘要： 同事总结的 记录之(1).打开快照：在master数据库执行如下：ALTER DATABASE [dbname] SET ALLOW_SNAPSHOT_ISOLATION ON;ALTER DATABASE [dbname] SET READ_COMMITTED_SNAPSHOT ON;在nc数据库 阅读全文
posted @ 2018-12-27 18:49 Qtong 阅读(1956) 评论(0) 推荐(0)