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

ORACLE RBA(redo byte address)

Redo Byte Address (RBA)
Recent entries in the redo thread of an Oracle instance are addressed using a 3-part redo byte address, or RBA. An RBA is comprised of
the log file sequence number (4 bytes)
the log file block number (4 bytes)
the byte offset into the block at which the redo record starts (2 bytes)
RBAs are not necessarily unique within their thread, because the log file sequence number may be reset to 1 in all threads if a database is opened with the RESETLOGS option.
RBAs are used in the following important ways.
 
With respect to a dirty block in the buffer cache, the low RBA is the address of the redo for the first change that was applied to the block since it was last clean, and the high RBA is the address of the redo for the most recent change to have been applied to the block.
Dirty buffers are maintained on the buffer cache checkpoint queues in low RBA order. The checkpoint RBA is the point up to which DBWn has written buffers from the checkpoint queues if incremental checkpointing is enabled -- otherwise it is the RBA of last full thread checkpoint. The checkpoint RBA is copied into the checkpoint progress record of the controlfile by the checkpoint heartbeat once every 3 seconds. Instance recovery, when needed, begins from the checkpoint RBA recorded in the controlfile. The target RBA is the point up to which DBWn should seek to advance the checkpoint RBA to satisfy instance recovery objectives.
The on-disk RBA is the point up to which LGWR has flushed the redo thread to the online log files. DBWn may not write a block for which the high RBA is beyond the on-disk RBA. Otherwise transaction recovery (rollback) would not be possible, because the redo needed to undo a change is always in the same redo record as the redo for the change itself.
The term sync RBA is sometimes used to refer to the point up to which LGWR is required to sync the thread. However, this is not a full RBA -- only a redo block number is used at this poin


相关文档:

Oracle基本操作

1.创建表空间
  create tablespace test datafile'c:\test.dbf' size 10m;  //名字不要为数字
2.创建用户
create user userName identified by password;  //不要为数字
3.给用户授权
grant dba to userName; --授予DBA权限
grant unlimited tablespace to userName;--授予不限制的表空间
grant sele ......

oracle 存储过程的基本语法

http://topic.csdn.net/t/20040818/16/3287013.html 
1.基本结构
CREATE OR REPLACE PROCEDURE 存储过程名字
(
    参数1 IN NUMBER,
    参数2 IN NUMBER
) IS|AS
变量1 INTEGER :=0;
变量2 DATE;
BEGIN
END 存储过程名字
说明:is也可换成as
2.SELECT INTO STATEMENT
& ......

oracle创建表空间和表

 Oracle安装完后,其中有一个缺省的数据库,除了这个缺省的数据库外,我们还可以创建自己的数据库。
    对于初学者来说,为了避免麻烦,可以用'Database Configuration Assistant'向导来创建数据库。
    创建完数据库后,并不能立即在数据库中建表,必须先创建该数据库的 ......

oracle统计信息收集

http://www.51testing.com/?uid-16403-action-viewspace-itemid-101604
 统计信息包括下面几类:
 
表统计:包括记录数、block数和记录平均长度。
列统计:列中不同值的数量(NVD)、空值的数量和数据分布(HISTOGRAM)。
索引统计:索引叶块的数量、索引的层数和聚集因子(CLUSTERING FACTOR)。
系统统计 ......

关于oracle的表空间,分区表,以及索引的总结

 http://episode.javaeye.com/blog/183016
表空间: 
Oracle的UNDOTBS01.DBF文件太大的解决办法 
1、.禁止undo tablespace自动增长 
alter   database   datafile   'full_path\undotbs01.dbf'   autoextend   off; 
2.-- 创建一个新的小 ......
© 2009 ej38.com All Rights Reserved. 关于E健网联系我们 | 站点地图 | 赣ICP备09004571号