全部博文
-
编辑 删除
Transparent Gateway
(1) install the transparent gateway compent, you will see a directory : $Oracle_home\ora90\tg4msql(2) configure listener.ora,add sid_desc to sid_list_listener(sid...
-
编辑 删除
Oracle优化
analyze 后CBO 模式下选技的行数据比例过大（10%）优化器采取全表扫描analyze table tab_name compute statistics for table for all indexed columns for all indexesalter sesion set optimizer_mode=choo...
