Oralce Architectural Components
Meroy Structure
Oracle’s memory structure consists of two memory areas known as :
System Grobal Area(SGA):allocated at instance start up,and is fundamental component of an Oralce instance
Program Global Area(PGA):allocated where the server process is started
SGA:System Grobal Area
Is dynamic,sized
Size by the SGA_MAX_SIZE parameter
Allocated and tracked in granules by SGA components
Contiguous virtual memory allocation
Granule size based on total estimated SGA_MAX_SIZE
SGA可以动态改变,最大的尺寸可以通过SGA_MAX_SIZE来改变。Granules是SGA的最小单位。SGA是连续的内存区域,并且最大不能超过 SGA_MAX_SIZE.
可以通过show sga 查看SGA 大小.
可以通过语句
select component,granule_size from v$sga_dynamic_components.
查看granule的大小
1.The SGA consists of several memory structures:
Shared Pool: SHARED_POOL_SIZE
Database Buffer Cache: DB_CACHE_SIZE
Redo Log Buffer: LOG_BUFFER
Other structures(for example ,lock and latch management,statistical data)
2.There are two additional memory structures that can be configured within the SGA:
Large Pool: LARGE_POOL_SIZE
Java Pool: JAVA_POOL_SIZE
Shared Pool
Used to store
Most recently executed SQL statements
Most recently used data definitions
It consists of two key performance-related memory structures:
Library Cache
Data Dictionary Cache
Sized by the parameter
每一个SQL将被解析,制定执行计划。解析SQL语句被存到共享池中。包含两部分重要内容。为Library Cache和Data Dictionary Cache
Library Cache
Stores information about the most recently used SQL and PL/SQL statements
Enables the sharing of commonly used statements
Is manager by a least recently user(LRU) algorithm
Consists of two structures:
Shared SQL area
Shared PL/SQL area
Size determined by the Shared Pool sizing
存储的是经过编译解析后的SQL语句和PL/SQL语句的内容.
包含两部分。一部分是SQL area ,一部分是PL/SQL area
大小由Shared Pool 管理
Data Dictionary Cache
A collection of the most recently used definitions in the database
Includes information about database files, tables , indexes , columns , users, privileges ,and others database objects.
During the parse phase ,the server process looks at the data dictionary for information to resolve object names and validate access
Improves response time on queries and DML
Size determined by the Shared Pool sizing.
数据字典是使用最频繁的,各种数据操作都需要使用到.各种数据库信息被保存在这里.用来响应各种查询和DML操作
大小由Shared Pool 管理
Database Buffer Cache
Stores copies of data block that have been retrieved from the data files
Enables great performance gains when you bobtain and update data
Manager through an LRU algorithm
DB_BLOCK_SIZE determines primary block size
缓存数据文件中的数据。
Consists of independent subcaches
DB_CACHE_SIZE
DB_KEEP_CACHE_SIZE
DB_RECYCLE_CACHE_SIZE
Can be dynamically resized
DB_CACHE_ADVICE Set to gather statistics for predicting different cache size behavior
Statistics displayed by V$DB_CACHE_ADVICE
Redo Log Buffer
Records all changes made to the database data blocks
Primary purpose is recovery
Changer recorded within are called redo entries
Redo entries contain information to reconstruct or redo changes
Size defined by LOG_BUFFER
主要用来恢复数据文件。每做一次操作,就会形成一个操作记录。
Large Pool
An optional area of memory in the SGA
Relieves the burden placed on the Shared Pool
Used For:
Session memory(UGA) for the Shared Server
I/O server processes
Backup and restore operations or RMAN
Parallel execution message buffers
PARALLEL_ATUOMATIC_TUNING set to TRUE
Dose not use an LRU list
Sized by LARGE_POOL_SIZE
Can be dynamically resized
JAVA Pool
Services parsing requirements for java commands
Requied if installing and using java
Size by JAVA_POOL_SIZE parameter
PGA: Program Global Area
Memory reserved for each user process connecting to an Oracle database
Allocated when a process is created
Deal located when the process is terminated
Used by only one process
分享到:
相关推荐
<br>系统设计<br> 1 jive设计思路 <br> 2 jive的工作内幕 <br> 3 Jive源代码研究 <br> 4 Jive中的设计模式 <br> 5 jive学习笔记 <br><br><br> <br>设计模式<br> 1 大道至简-Java之23种模式一点就通 <br> 2 设计模式...
Oracle学习笔记精华版Oracle学习笔记精华版Oracle学习笔记精华版Oracle学习笔记精华版
Oracle学习笔记Oracle学习笔记Oracle学习笔记Oracle学习笔记Oracle学习笔记Oracle学习笔记Oracle学习笔记Oracle学习笔记Oracle学习笔记Oracle学习笔记Oracle学习笔记Oracle学习笔记Oracle学习笔记
oracle 个人学习笔记oracle 个人学习笔记oracle 个人学习笔记oracle 个人学习笔记oracle 个人学习笔记oracle 个人学习笔记oracle 个人学习笔记oracle 个人学习笔记oracle 个人学习笔记oracle 个人学习笔记
Oracle非常有用的笔记。。。。。。。。。。。Oracle学习笔记Oracle学习笔记Oracle学习笔记Oracle学习笔记
系统设计<br> 1 jive设计思路 <br> 2 jive的工作内幕 <br> 3 Jive源代码研究 <br> 4 Jive中的设计模式 <br> 5 jive学习笔记 <br><br><br><br><br>数据库设计<br> 1 Jive Forums数据库说明(英文) <br> 2 Jive KB...
oracle学习笔记 oracle学习笔记oracle学习笔记 oracle学习笔记
本文档主要是网易云李兴华老师进行授课时所作笔记,从Oracle11g数据库的安装到复杂查询做了详细的文档记录。
oracle学习笔记,包含所有oracle概念,包,函数,oracle的组成,oracle的plsq,oracle的存储过程,oracle的事务等
Oracle学习笔记 以下是我这一周学习oracle整理的笔记,包括课堂的内容和自己看额外看的视频补充的一些内容,基本上囊括了所有oracle的基本知识。主要的形式是例子代码加代码解释加运行结果,我个人认为对于没有学习...
oracle学习笔记-入门基础-01-张园
分享给需要的朋友们韩顺平oracle学习笔记.pdf 大家来下载吧!
资源名称:Oracle学习笔记-日常应用、深入管理、性能优化内容简介:Oracle学习笔记-日常应用、深入管理、性能优化Oracle 11g是最具代表性的高端关系型数据库管理系统,它在世界各地的大型商务数据库应用系统中被广泛...
学习oracle知识笔记整理,包括pl/sql编程,过程、函数、游标开发等。
oracle学习笔记
超详细Oracle学习笔记,详细记录了oracle的学习过程中遇到的各种问题及基础知识,适合初中级oracle使用人员学习参考。
Oracle学习笔记