TAILIEUCHUNG - Sizing the Shared Pool

Defined by SHARED_POOL_SIZE Library cache contains statement text, parsed code, and execution plan. Data dictionary cache contains definitions for tables, columns, and privileges from the data dictionary tables. UGA contains session information for Oracle Shared Server users when a large pool is not configured. | Sizing the Shared Pool Objectives After completing this lesson, you should be able to do the following: Determine the size of an object and pin it in the shared pool Tune the shared pool reserved space Describe the user global area (UGA) and session memory considerations Measure the library cache hit ratio List other tuning issues related to the shared pool Measure the dictionary cache hit ratio Set the large pool Shared Pool Contents Major components of the shared pool are: Library cache Data dictionary cache User global area (UGA) for shared server sessions Database buffer cache Redo log buffer Shared pool Library cache Data dictionary cache User global area Large pool UGA Shared Pool Contents The shared pool contains the following structures: The library cache, which stores shared SQL and PL/SQL code The data dictionary cache, which keeps information about dictionary objects The user global area (UGA), which keeps information about shared server connections when the large pool is not configured. Tuning Considerations for the Shared Pool A cache miss on the data dictionary cache or library cache is usually more expensive than a miss on most other SGA memory structures; therefore tuning the shared pool is a priority. When you tune the shared pool, you should concentrate on the library cache because the algorithm that assigns memory space in the shared pool prefers to hold dictionary data in memory longer than library cache data. Therefore, tuning the library cache to an acceptable cache hit ratio ensures that the data dictionary cache hit ratio is also acceptable. If the shared pool is too small, the server must dedicate resources to managing the limited space available. This consumes CPU resources and causes contention. If the shared pool is too large performance can decrease because: There is less memory for other memory structures (thus reducing performance) Many entries can make finding current contents slower than in a smaller pool. Shared Pool Defined by .

• Cơ sở dữ liệu
• Sizing the Shared Pool
• Oracle XML Applications
• database
• data management
• Oracle XML
• Performance Tuning
• XML Data
• Administration
• Handbook of comparative public administration
• Comparative public administration
• Development public administration
• Public administration
• Developed nations
• History public administration
• Contemporary bureaucratic politics
• Administrative theory
• Ketoprofen co administration
• Febrile state on pharmacokinetics
• Pharmacokinetics of levofloxacin
• Goats following intravenous administration
• Pharmacokinetic parameters following co administration
• Doctoral thesis
• Administration management
• State Administration
• Commercial banks
• Current period
• Doctoral dissertation
• Institutionnal capacity
• State administration adapting
• Market economy development
• International intergration
• Elements of development administration
• Development administration
• Peoples particjpation
• Decision making process
• Administration of law and order
• Public policy
• Nuclear engineering and technology
• Tissue distribution of tritium following oral administration to rats
• Excretion of tritium following oral administration to rats
• Effects on genotoxicity of tritium following oral administration to rats
• Tritium following oral administration to rats
• Tax administration in ethiopia the case kolfe keranio sub
• City administration revenue office
• Kolfe Keranio Sub City
• Non probability technique
• Capital and time resources
• Business administration
• Master of Business administration thesis
• Business administration thesis
• Hypercompetition the case of VMS
• Mobile sector
• Lecture Principles of network and system administration
• Principles of network and system administration
• Bài giảng Nguyên lý quản trị mạng và hệ thống
• Distinguished names
• System administration directories
• Network information service
• Doctoral thesis summary Business administration
• Master thesis Business Administration
• Supply chain social sustainability
• Supply chain integration
• Supply chain performance
• Modern Administration
• Indian Legacy
• Building Blocks
• Profound Puzzle
• BUREAUCRATIC POLITICS
• Enhanced Administration
• Lesson Vietnam U
• Relations
• Policy Initiatives During the Carter Administration
• Developments During the
• Reagan and Bush Administrations
• Developments During the Clinton Administration
• During the Carter Administration policy
• The Clinton administration
• Ecology of development
• Planning and development
• Planning and development administration
• The use of accounting services by micro
• Small business enterprises in dembi dollo town administration
• Dembi dollo town administration
• Inventory turnover period
• Doctoral thesis summary
• Quality of bachelor training
• Bachelor training
• Microsoft Exchange Server 2003
• Administration Guide
• Exchange administration
• Exchange Server architecture
• configuring global
• manageability
• Policy Making
• Inlergavernmentztl Relations
• Bureaucracy
• Organization Behavior
• Performance Management
• Financial Management
• production management
• project management
• management experience
• methods of administration
• management know how
• personnel administration
• administration skills
• controlling personnel
• corporate control
• management tips
• managing corporate governance
• organisational levels
• theoretical frameworks
• civil service
• Flemish administration
• administration practice
• pioneering discovery
• combat infections
• genes including Toll
• different non linear
• optimization techniques
• illegal adulterant
• Public administration management
• Head of state administrative agency
• Public administration reform process
• Linux system administration
• The benefits of Linux
• System administration
• Installing Linux
• Startup and shutdown
• Tools of the trade
• LPI 101 Junior Level Administration
• Junior Level Administration
• Linux Fundamentals
• Hardware & Architecture
• Install a Linux system
• Process text streams using filters
• LPI 102 Junior Level Administration
• The Linux Documentation
• Managing Users
• Shells Scripting
• Shutdown and Runlevels