注册 登录
编程论坛 Oracle论坛

关于每项的解释,请大家帮忙看下

tianshenghao 发布于 2008-01-10 13:06, 1707 次点击
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代表什么意思,用过的大侠说明下行吗,谢谢,谢谢
1 回复
#2
ILoveMK2008-01-10 17:14
看看官方的解释:
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.
1