优化
-
编辑 删除
optimizer_dynamic_sampling
看到这样一段话：Correlation between columns in the same table always causes problems if those columns appear together in your where clause; the issue is not restricted to inde...
-
编辑 删除
[转]非dba用户使用autotrace
SQLPLUS的AutoTrace是分析SQL的执行计划，执行效率的一个非常简单方便的工具，在绝大多数情况下，也是非常有用的工具。SQL> connect / as sysdbaSQL> @?/rdbms/admin/utlxplan.sqlTable created.SQL> create pub...
-
编辑 删除
跟踪正在执行的sql语句
在3层结构中的应用服务器端，通过查几个动态视图来完成跟踪使用netstat命令来获得pid
-
编辑 删除
WHAT ARE RECURSIVE CALLS?
In Oracle, a recursive call is a call, for example, that must be completed before the user's SQL can be completed. Say you wanted to order a pizza for delivery. You make one call, place your ...
