Shared SQL Dependency Management【每日一译】--2013-1-15

In addition to managing dependencies among schema objects, Oracle also manages
dependencies of each shared SQL area in the shared pool. If a table, view, synonym, or
sequence is created, altered, or dropped, or a procedure or package specification is
recompiled, all dependent shared SQL areas are invalidated. At a subsequent
execution of the cursor that corresponds to an invalidated shared SQL area, Oracle

reparses the SQL statement to regenerate the shared SQL area.

除了管理用户间的的对象依赖，O也管理每个共享SQL区域的依赖关系在共享池中。如果

一个表，视图，同义词或者序列的创建，修改或者删除，或者存储过程，包的说明被重新

编译，所有依赖的共享SQL区域是无效的，在后续执行对应于无效共享SQL区域的游标，O

重新解析SQL语句并且重新建立共享SQL区域。