Shared SQL Dependency Management (249)
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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Local and Remote Dependency Management (250)REM
- Oracle Shared Pool Memory ManagementOracle
- SQL management baseSQL
- SQL Plan ManagementSQL
- SQL Plan Management(SPM)SQL
- How to Move/Recreate GI Management Repository to Different Shared Storage
- SQL Plan Management介紹SQL
- SQL Server Management Studio (SSMS)SQLServerSSM
- SQL PLAN Management的測試SQL
- 11g-sql plan managementSQL
- Shared SQL Areas (88)SQL
- Shared SQL Areas和Private SQL AreasSQL
- Shared SQL Areas and Private SQL Areas (87)SQL
- sql_shared_cursor (轉)SQL
- Oracle10g New Feature -- 13. Automatic Shared Memory ManagementOracle
- shared_pool_spare_free.sqlSQL
- shared SQL,parent cursor,child cursorSQL
- Oracle OCP 1Z0 053 Q66(Automatic Shared Memory Management)Oracle
- 【Shared Pool】使用DBMS_SHARED_POOL包將PL/SQL大物件儲存到Shared PoolSQL物件
- Oracle11g中SQL Plan Management (一)OracleSQL
- Oracle11g中SQL Plan Management (二)OracleSQL
- Oracle11g中SQL Plan Management (三)OracleSQL
- PL/SQL Program Units and the Shared Pool (89)SQL
- Oracle 11g SQL效能的新特性(三)- SQL Plan ManagementOracleSQL
- Oracle 11g 新特性 -- SQL Plan Management 示例OracleSQL
- How to find dependency
- [Javascript] Circular dependencyJavaScript
- shared_pool的sql命中率SQL
- v$sql v$sqlarea v$sql_shared_cursor及遊標SQL
- 使用DBMS_SHARED_POOL包將PL/SQL大物件儲存到Shared PoolSQL物件
- Sql Server系列:Microsoft SQL Server Management Studio模板資源管理器SQLServerROS
- 新增輔助資料庫 (SQL Server Management Studio)資料庫SQLServer
- 啟用日誌傳送 (SQL Server Management Studio)SQLServer
- sql執行計劃_v$sqlarea_v$sql_v$sql_shared_cursorSQL
- oracle11g中SQL最佳化(SQL TUNING)新特性之SQL Plan Management(SPM)OracleSQL
- 【DBA】Oracle 11g 針對SQL效能的新特性(三)- SQL Plan ManagementOracleSQL
- 利用SQL Server Management Studio(SSMS)複製資料庫SQLServerSSM資料庫
- 使用Trace Management Object監測和診斷SQL Server(一)ObjectSQLServer