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
2
3作者： 来源： 更新日期：2006-01-04
5
6
7建立表空间
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
/*不带任何参数存储过程(输出系统日期)*/
create or replace procedure output_date is
begin
dbms_output.put_line(sysdate);
end output_date;
/*带参数in和out的存储过程*/
create or replace procedure get_username(v_id in number,v_username out varchar2)
as
begin
select username into v_usern ......
select lower( column_name) ||','||'--'||comments
from user_col_comments c
where c.table_name = upper('acc_fundcap')
SELECT * from USER_TAB_COMMENTS WHERE TABLE_NAME='T_META';
INSERT INTO 表名(字段名1, 字段名2) SELECT 字段名1, 字段名2 from 另外的表名; ......
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 ......
1、数据库的逻辑结构和物理结构：
Oracle logically divides the database into a smaller units to manage ,store,and retreive
data efficently.
Tablespace\Blocks\Extents\segment\
有四种segment:
data segment、Index segment、Temporay segment、Rollback Segment
temporary segment:
Ar ......
