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

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

[@more@]