oracle的内存结构
数据库的内存结构:
Memory structures are allocated to the Oracle instance when the instance is started.
The two major memory structures are known as the System Global Area(Also called the shared
Global Area)and the Program Global Area(also called the Private Global Area or the Process
Global Area)
SGA:
The System Global Area(SGA) is a shared memory area.All users of the database share the
information maintained in this area.The SGA and the backgroud processes constitute an Oracle instance.Oracle allocates memory for the SGA when an Oracle instance is started and de-allocates it when the istance is shut down.The information stored in the SGA is divided into multiple memory structures that are allocated fixed space when the instance started.
DATABASE Buffer Cache:
The database buffer cache is the area of memory that caches the database area,holding blocks
from the data files that have been read recently.The DB buffer cache is shared among all the users connected to the database.
There are three type of buffers.
Dirty buffers:Dirty buffers are the buffer blocks that need to be written to the data files.
The data in these buffers has changed and has not yet been written ti the disk.
Free buffers :Free buffers do not contain any data or are free to be overwritten.When Oracle reads data from disk,free buffers are used to hold this area.
Pinned buffers :Pinned buffers are the ones that are currently being accessed or explicityly retained for futer use.(for example,the KEEP buffer)
Oracle maintains two lists to manage the buffer cache,The write list(dirty buffer list) has the buffers that are modified and need to be written to the disk(the dirty buffers).
The least recently used(LRU) list contains fr
相关文档:
关于SGA设置的一点总结
本总结不针对特例,仅对服务器只存在OS + ORACLE 为例,如果存在其他应用请酌情考虑
写这个也是因为近来这种重复性的问题发生的太多所导致的
首先不要迷信STS,SG,OCP,EXPERT 等给出的任何建议、内存百分比的说法
基本掌握的原则是, data buffer 通常可以尽可能的大,shared_pool_size 要适度 ......
1、查找表的所有索引(包括索引名,类型,构成列):
select t.*,i.index_type from user_ind_columns t,user_indexes i where t.index_name = i.index_name and t.table_name = i.table_name and t.table_name = 要查询的表
2、查找表的主键(包括名称,构成列):
select cu.* from user_cons_columns cu, user_constr ......
Oracle 内存结构如下图:
1:实例(Instance)
在一个中,每一个运行的Oracle数据库都与一个数据库实例相联系,实例是我们
访问数据库的手段。
实例在操作系统中用ORACLE_SID来标识,在Oracle中用参数INSTANCE_NAME来标识,
它 ......
记录一下ORACLE 10gR2的软件下载地址,备用。
下载OTN上的这些软件,你需要一个OTN免费帐号,不过如果通过迅雷进行下载,就不用登陆OTN了:
Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Microsoft Windows (32-bit)
http://download.oracle.com/otn/nt/oracle10g/10201/10201_database ......
先看下面的例子:oracle中两个系统表.emp,dept.
example:
1:not exists(not in)
not exists:
这条语句返回select * from scott.dept d where e.deptno=d.deptno and d.deptno=10条件满足的结果集.也就是说,
返回的结果集中不存在d.deptno=10结果集的记录,即emp表中没有dept表中d.deptno=10的记录.
SQL& ......