| 编程中国 | 业界新闻 | 技术文章 | 视频教程 | 下载频道 | 程序源码 | 个人空间 | 编程论坛
全能ASP/PHP/ASP.NET主机,支持月付专业 MSSQL 数据库空间,支持月付专业 MySQL 数据库空间,支持月付学习型 ASP/PHP/ASP.NET 主机 30元/年
高端软件开发 = 年薪十万不是梦   
共有 902 人关注过本帖
标题:关于每项的解释,请大家帮忙看下
收藏  订阅  推荐  打印
tianshenghao
Rank: 1
等级:新手上路
帖子:3
积分:138
注册:2007-7-3
关于每项的解释,请大家帮忙看下

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代表什么意思,用过的大侠说明下行吗,谢谢,谢谢
2008-1-10 13:06
ILoveMK
Rank: 12Rank: 12Rank: 12
等级:版主
帖子:487
积分:5588
威望:6
注册:2007-2-12

看看官方的解释:
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-1-10 17:14
共有 901 人关注过本帖
关于我们 | 广告合作 | 编程中国 | 清除Cookies | Archiver | WAP | TOP

编程中国 版权所有,并保留所有权利。鲁ICP备08000592号
Powered by Discuz, Processed in 0.046436 second(s), 9 queries.
Copyright©2004-2008, BCCN.NET, All Rights Reserved