| 网站首页 | 业界新闻 | 小组 | 威客 | 人才 | 下载频道 | 博客 | 代码贴 | 在线编程 | 编程论坛
欢迎加入我们,一同切磋技术
用户名:   
 
密 码:  
共有 1695 人关注过本帖
标题:关于每项的解释,请大家帮忙看下
只看楼主 加入收藏
tianshenghao
Rank: 1
等 级:新手上路
帖 子:3
专家分:0
注 册:2007-7-3
收藏
 问题点数:0 回复次数:1 
关于每项的解释,请大家帮忙看下
Statistics
----------------------------------------------------------
          0  recursive calls
          0  db block gets
          4  consistent gets
          0  physical reads
          0  redo size
        544  bytes sent via SQL*Net to client
        503  bytes received via SQL*Net from client
          2  SQL*Net roundtrips to/from client
          0  sorts (memory)
          0  sorts (disk)
         10  rows processed
         我第一次用,不知道recursive calls代表什么意思,用过的大侠说明下行吗,谢谢,谢谢
搜索更多相关主题的帖子: SQL client Net calls via 
2008-01-10 13:06
ILoveMK
Rank: 3Rank: 3
等 级:新手上路
威 望:6
帖 子:487
专家分:0
注 册:2007-2-12
收藏
得分:0 
看看官方的解释:
Recursive Calls. Number of recursive calls generated at both the user and system level.
Oracle Database maintains tables used for internal processing. When it needs to change these tables, Oracle Database generates an internal SQL statement, which in turn generates a recursive call.
In short, recursive calls are basically SQL performed on behalf of your SQL. So, if you had to parse the query, for example, you might have had to run some other queries to get data dictionary information. These would be recursive calls. Space management, security checks, calling PL/SQL from SQL—all incur recursive SQL calls.

天下归心
2008-01-10 17:14
快速回复:关于每项的解释,请大家帮忙看下
数据加载中...
 
   



关于我们 | 广告合作 | 编程中国 | 清除Cookies | TOP | 手机版

编程中国 版权所有,并保留所有权利。
Powered by Discuz, Processed in 0.016582 second(s), 7 queries.
Copyright©2004-2024, BCCN.NET, All Rights Reserved