ITPub博客

首页 > 数据库 > Oracle > Recursive Calls

Recursive Calls

原创 Oracle 作者:n-lauren 时间:2014-08-12 10:41:59 0 删除 编辑

官网对recursive calls 的解释如下:

       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。

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/22990797/viewspace-1249687/ ,如需转载,请注明出处,否则将追究法律责任。

下一篇: FILTER JOIN
请登录后发表评论 登录
全部评论

注册时间:2011-09-26

  • 博文量
    146
  • 访问量
    316745