全部博文
-
编辑 删除
oracle性能优化参数调整
1.SHARE_POOL_SIZE数据字典的命中率计算：select ((1 - (Sum(GetMisses) / (Sum(Gets) + Sum(GetMisses)))) * 100) "Hit Rate" from V$RowCachewhere Gets + GetMisses <> 0;数据字典的命中率低于95%可考虑提升SHA...
-
编辑 删除
TSQL中实现ORACLE的多列IN
期望效果：<!--Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->select * From Empoylee Where(Address1,Address2) in(Select ...
