Oracle體系結(jié)構(gòu)及備份(六)sga-shared_pool
Jun 07, 2016 pm 03:09 PM一 什么是shared_pool The shared pool portion of the SGA contains the library cache, the dictionary cache, the result cache, buffers for parallel execution messages, and control structures. This div includes the following topics: Library Ca
一 什么是shared_pool
?
?
????????The shared pool portion of the SGA contains the library cache, the dictionary cache, the result cache, buffers for parallel execution messages, and control structures.
?
????????This div includes the following topics:
?
????????Library Cache
????????The library cache includes the shared SQL areas, private SQL areas (in the case of a shared server configuration), PL/SQL procedures and packages, and control structures such as locks and library cache handles.
?
????????Shared SQL areas are accessible to all users, so the library cache is contained in the shared pool within the SGA.
?
?
????????Dictionary Cache
????????The data dictionary is a collection of database tables and views containing reference information about the database, its structures, and its users. Oracle Database accesses the data dictionary frequently during SQL statement parsing. This access is essential to the continuing operation of Oracle Database.
?
????????The data dictionary is accessed so often by Oracle Database that two special locations in memory are designated to hold dictionary data. One area is called the data dictionary cache, also known as the row cache because it holds data as rows instead of buffers (which hold entire blocks of data). The other area in memory to hold dictionary data is the library cache. All Oracle Database user processes share these two caches for access to data dictionary information.
?
?
????????Result Cache
????????The result cache is composed of the SQL query result cache and PL/SQL function result cache, which share the same infrastructure.
?
????????The DBMS_RESULT_CACHE package provides administration subprograms, which, for example, flush all cached results and turn result-caching on or off systemwide. The dynamic performance views V$RESULT_CACHE_* allow the developer and DBA to determine, for example, the cache-hit success for a certain SQL query or PL/SQL function.
?
????????Similar to the result cache, the client result cache also caches results, except that the caching is done on the client side.
?
????????用于存儲(chǔ):
????????最近執(zhí)行的SQL語句
????????最近使用的數(shù)據(jù)定義
?
????????由三個(gè)與性能相關(guān)的部分組成
????????庫緩存
????????數(shù)據(jù)字典緩存
????????結(jié)果緩存
?
????????由參數(shù)SHARED_POOL_SIZE決定大小。
?
?
?
二 操作示例
?
SQL> show parameter shared_pool_size; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ shared_pool_size big integer 12M SQL> show parameter sga_target; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ sga_target big integer 160M
三 總結(jié)
????????1. 用于存儲(chǔ):最近執(zhí)行的SQL語句、最近使用的數(shù)據(jù)定義;
????????2.由三個(gè)與性能相關(guān)的部分組成:庫緩存、數(shù)據(jù)字典緩存、結(jié)果緩存;
????????3.可以通過參數(shù)shared_pool_size查看共享池的大小。
?
<span><span>我的郵箱</span></span><span>:</span>wgbno27@163.com <span> <span>新浪微博</span></span><span>:</span>@Wentasy27 <span>微信公眾平臺(tái)</span>:JustOracle(微信號(hào):justoracle) <span>IT交流群</span>:336882565(加群時(shí)驗(yàn)證 From CSDN XXX) <span>Oracle交流討論組</span>:https://groups.google.com/d/forum/justoracle <span><strong>By Larry Wen</strong></span>
![]() |
![]() ![]() |
@Wentasy |

Hot AI Tools

Undress AI Tool
Undress images for free

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

To safely and thoroughly uninstall MySQL and clean all residual files, follow the following steps: 1. Stop MySQL service; 2. Uninstall MySQL packages; 3. Clean configuration files and data directories; 4. Verify that the uninstallation is thorough.

The main difference between MySQL and Oracle is licenses, features, and advantages. 1. License: MySQL provides a GPL license for free use, and Oracle adopts a proprietary license, which is expensive. 2. Function: MySQL has simple functions and is suitable for web applications and small and medium-sized enterprises. Oracle has powerful functions and is suitable for large-scale data and complex businesses. 3. Advantages: MySQL is open source free, suitable for startups, and Oracle is reliable in performance, suitable for large enterprises.

MySQL uses GPL and commercial licenses for small and open source projects; Oracle uses commercial licenses for enterprises that require high performance. MySQL's GPL license is free, and commercial licenses require payment; Oracle license fees are calculated based on processors or users, and the cost is relatively high.

In different application scenarios, choosing MongoDB or Oracle depends on specific needs: 1) If you need to process a large amount of unstructured data and do not have high requirements for data consistency, choose MongoDB; 2) If you need strict data consistency and complex queries, choose Oracle.

The key to learning Java without taking detours is: 1. Understand core concepts and grammar; 2. Practice more; 3. Understand memory management and garbage collection; 4. Join online communities; 5. Read other people’s code; 6. Understand common libraries and frameworks; 7. Learn to deal with common mistakes; 8. Make a learning plan and proceed step by step. These methods can help you master Java programming efficiently.

Learning Java requires learning basic syntax, object-oriented programming, collection frameworks, exception handling, multithreading, I/O streaming, JDBC, network programming, and advanced features such as reflection and annotation. 1. The basic syntax includes variables, data types, operators and control flow statements. 2. Object-oriented programming covers classes, objects, inheritance, polymorphism, encapsulation and abstraction. 3. The collection framework involves ArrayList, LinkedList, HashSet, and HashMap. 4. Exception handling ensures program robustness through try-catch block. 5. Multithreaded programming requires understanding of thread life cycle and synchronization. 6. I/O streams are used for data reading, writing and file operations. 7. JDBC is used to interact with databases. 8. Network programming passes S

The steps to connect to an Oracle database connection pool using JDBC include: 1) Configure the connection pool, 2) Get the connection from the connection pool, 3) Perform SQL operations, and 4) Close the resources. Use OracleUCP to effectively manage connections and improve performance.

To connect Oracle database to Tableau for data visualization, you need to follow the following steps: 1. Configure Oracle database connection in Tableau, use ODBC or JDBC drivers; 2. Explore data and create visualizations, such as bar charts, etc.; 3. Optimize SQL queries and indexes to improve performance; 4. Use Oracle's complex data types and functions to implement through custom SQL queries; 5. Create materialized views to improve query speed; 6. Use Tableau's interactive functions such as dashboard for in-depth analysis.
