首页 > 数据库 > 数据库开发技术 > PL/SQL Program Units and the Shared Pool (89)

PL/SQL Program Units and the Shared Pool (89)

原创 数据库开发技术 作者:tsinglee 时间:2007-10-24 11:21:57 0 删除 编辑

Oracle processes PL/SQL program units (procedures, functions, packages, anonymous
blocks, and database triggers) much the same way it processes individual SQL
statements. Oracle allocates a shared area to hold the parsed, compiled form of a
program unit. Oracle allocates a private area to hold values specific to the session that
runs the program unit, including local, global, and package variables (also known as
package instantiation) and buffers for executing SQL. If more than one user runs the
same program unit, then a single, shared area is used by all users, while each user
maintains a separate copy of his or her private SQL area, holding values specific to his
or her session.
Individual SQL statements contained within a PL/SQL program unit are processed as
described in the previous sections. Despite their origins within a PL/SQL program
unit, these SQL statements use a shared area to hold their parsed representations and a
private area for each session that runs the statement.

Oracle处理PL/SQL块(存储过程,函数等)和处理单独的SQL语句相似 .
Oracle分配一个私有区域来保存会话执行的程序块的值 , 包括本地, 全局 , 变量, 执行SQL的buffers


来自 “ ITPUB博客 ” ,链接:,如需转载,请注明出处,否则将追究法律责任。

上一篇: Shared SQL Areas (88)
下一篇: Dictionary Cache (90)
请登录后发表评论 登录
  • 博文量
  • 访问量