易截截图软件、单文件、免安装、纯绿色、仅160KB

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


相关文档:

oracle根据外键名查关联的表

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数据库中重复数据的方法

在对数据库进行操作过程中我们可能会遇到这种情况,表中的数据可能重复出现,使我们对数据库的操作过程中带来很多的不便,那么怎么删除这些重复没有用的数据呢?
  重复数据删除技术可以提供更大的备份容量,实现更长时间的数据保留,还能实现备份数据的持续验证,提高数据恢复服务水平,方便实现数据容灾等。 重复的数据 ......

Oracle 索引组织表(IOT)

     索引组织表(IOT)有一种类B树的存储组织方法。普通的堆组织表是以一种无序的集合存储。而IOT中的数据是按主键有序的存储在B树索引结构中。与一般B树索引不同的的是,在IOT中每个叶结点即有每行的主键列值,又有那些非主键列值。
     在IOT所对应的B树结构中,每个索引项包 ......

Oracle 開發筆記

Oracle 物件的命名限制
任何物件的名稱不得超過 30 位元(Bytes)
Oracle 的 dummy query 寫法
SELECT SYSDATE from dual
Oracle 選取部分資料的方法
SELECT * from table WHERE ROWNUM<10; /* 取出前 10 筆 */
實現 Oracle 上的分頁顯示 [精華] ......

LINUX下Oracle库备份脚本

vi /opt/back.sh(oracle用户)
#!/bin/ksh
tim=`date +%Y%m%d`
unset USERNAME
#export DISPLAY=0.0.0.0:0.0
#export ORACLE_BASE=/home/oraprod3
#export ORACLE_HOME=/prod/oracle/prod3db/9.2.0
#export ORACLE_SID=PROD3_db
#export LD_LIBRARY_PATH=/prod/oracle/prod3db/9.2.0/lib
#export ORACLE_TERM=vt100 ......
© 2009 ej38.com All Rights Reserved. 关于E健网联系我们 | 站点地图 | 赣ICP备09004571号