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.
共享SQL的依赖性管理
1. Oracle不仅管理方案对象之间的依赖性,还需管理共享池中各个共享 SQL 区的依赖性
2. 用户创建,修改或移除了表,索引,同义词,或序列,或者重新编译了包,或包声明,那么所有依赖共享 SQL 区都将被置为无效
3. 当一个基于无效共享 SQL 区的游标继续执行时,Oracle 将重新对 SQL 语句进行语法分析,并 重新生成共享 SQL 区
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10599713/viewspace-984633/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/10599713/viewspace-984633/