Shared SQL Areas and Private SQL Areas (87)
Oracle represents each SQL statement it runs with a shared SQL area and a private
SQL area. Oracle recognizes when two users are executing the same SQL statement
and reuses the shared SQL area for those users. However, each user must have a
separate copy of the statement’s private SQL area.[@more@]
SQL area. Oracle recognizes when two users are executing the same SQL statement
and reuses the shared SQL area for those users. However, each user must have a
separate copy of the statement’s private SQL area.[@more@]
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/10599713/viewspace-978364/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- Shared SQL Areas和Private SQL AreasSQL
- Shared SQL Areas (88)SQL
- Cursors and SQL Areas (99)SQL
- SQL Work Areas(101)SQL
- Overview of the Program Global Areas (97)View
- Software Code Areas (105)
- It is worth mentioning it is also one of the main areasAI
- 6.4 滾動區域(Scrolling Areas)
- Oracle discoverer中exp/imp Business Areas (BAs) 和foldersOracle
- sql_shared_cursor (轉）SQL
- Shared SQL Dependency Management (249)SQL
- shared_pool_spare_free.sqlSQL
- shared SQL,parent cursor,child cursorSQL
- Ubuntu elasticsearch max virtual memory areas vm.max_map_count [65530] is too low, increase to at leUbuntuElasticsearch
- v$sql v$sqlarea v$sql_shared_cursor及遊標SQL
- sql執行計劃_v$sqlarea_v$sql_v$sql_shared_cursorSQL
- PL/SQL Program Units and the Shared Pool (89)SQL
- Docker安裝 elasticsearch 報錯max virtual memory areas vm.max_map_count [65530] is too lowDockerElasticsearch
- shared_pool的sql命中率SQL
- 【PL/SQL】在PL/SQL中執行重新整理Shared Pool命令SQL
- 【Shared Pool】使用DBMS_SHARED_POOL包將PL/SQL大物件儲存到Shared PoolSQL物件
- cursor_sharing與v$sqlarea_v$sql_v$sql_shared_cursorSQL
- v$sql v$sqlarea v$sql_shared_cursor及父遊標，子游標SQL
- v$sql_shared_cursor中的BIND_MISMATCHSQL
- 使用DBMS_SHARED_POOL包將PL/SQL大物件儲存到Shared PoolSQL物件
- V$SQL_SHARED_CURSOR檢視硬解析的原因SQL
- SQL在shared pool中的解析過程問題SQL
- 11G can flush one SQL Cursor out of shared poolSQL
- 檢視v$sql_shared_cursor檢視獲取sql語句為什麼不能共享?SQL
- 清除shared pool中某條sql的執行計劃SQL
- 共享SQL區在shared pool中釋放的條件SQL
- SQL Plan Baseline與Shared Cursor機制研究（一）SQL
- SQL Plan Baseline與Shared Cursor機制研究（二）SQL
- SQL Plan Baseline與Shared Cursor機制研究（三）SQL
- dbms_shared_pool.purge 清理某個SQL執行計劃SQL
- v$sql_shared_cursor檢視記錄多版本的資訊SQL
- SQL%FOUND,SQL%NOTFOUND,SQL%ROWCOUNTSQL
- 【SQL】Oracle SQL monitorSQLOracle