摘要: 建立与oracle的web程序,经常性出现sql性能不高导致的问题,比如程序好好的突然数据库查询变得很慢,几乎加载不了,这时候就有可能是oracle查询计划出错的原因。 1 2 3 SELECT * FROM( 4 select /*+ ... 阅读全文
posted @ 2015-12-15 20:48 YOU_CAN 阅读(329) 评论(0) 推荐(0)
摘要: 视图SELECT-- int.rowner "rgroup owner",-- int.rname "refresh group",mv.owner as "mview owner",mv.mview_name as "mview name",mv.master_link as "master li... 阅读全文
posted @ 2015-12-15 20:47 YOU_CAN 阅读(171) 评论(0) 推荐(0)