Oracle uses STEAL NO-FORCE logging. The following content is just my
conjecture which is not proved.
A log record has 2 parts: undo and redo. For Oracle, undo is treated
differently. Undo data is written to pages, which in in turn triggers
redo log writing.
The following transaction update account's credit and level.
-------------
Undo logging
-------------
Redo part
---------
Stored in redo log:
LSN TYPE TID Redo-data
-------------------------
1 SOT 1
3 UP 1 credit: 100
5 UP 1 level: 2
6 EOT 1
LSN: log sequence number
TID: transaction id
SOT: start of transaction
UP: update
EOT: end of transaction
Undo part
----------
The following stuff is stored in pages.
TID Undo-data
----------------
1 credit: 90
1 level: 1
The writing of undo part to pages triggers the following redo logging:
LSN TYPE TID Redo-data
-------------------------
2 UP 1 credit: 90
4 UP 1 level: 1
Redo log buffer
----------------
Refer to http://en.wikipedia.org/wiki/Redo_log.
Under the following situations, log records in redo log buffer must be
flushed to online redo log:
1) If a page stealing happens.
2) When committing happens.
References:
[1] Oracle Database Concepts
相关推荐
oracle FORCE LOGGING.txt
之前看到过一篇文章是介绍Oracle的一个内部隐含参数_disable_logging,最近又看到有朋友论述这个参数,所以下面这篇文章就来给大家介绍下关于Oracle中隐含参数_disable_logging的相关资料,需要的朋友可以参考下。
eclipse中maven 下载不到oracle数据库驱动 ojdbc5 ojdbc6 需要我们手动将驱动安装到本地仓库 https://blog.csdn.net/az44yao/article/details/87773714 参考地址: ...
tempfile 'D:\oracle\oradata\Oracle9i\user_temp.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local; /*第2步:创建数据表空间 */ create tablespace test_data ...
LOGGING EXTENT MANAGEMENT LOCAL; -- 删除用户 DROP USER ELWY CASCADE; -- 创建用户 CREATE USER ELWY IDENTIFIED BY "ELWY" DEFAULT TABLESPACE ELWY_DATA TEMPORARY TABLESPACE ELWY_TEMP; -- 用户授权 ...
CREATE TABLESPACE ... DATAFILE 'D:\oracleData\tablespace\tcyTableSpace.dbf' SIZE 100M AUTOEXTEND ON NEXT 32M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
Oracle10g.jar oscache-2.1.jar persistence.jar poi-2.5.1.jar portlet-api.jar proxool-0.8.3.jar spring-agent.jar spring-aop-2.0.xsd spring-aop.jar spring-beans-2.0.xsd spring-beans.jar spring-context....
Oracle Database 12c Release 1 (12.1.0.1) JDBC Drivers SimpleFAN Download simplefan.jar (21,048 bytes) - Classes for subscribing to RAC events via ONS; simplefan policy and javadoc JDBC Thin for ...
1. 首先是创建数据库用户 ...create tablespace lecast_data logging datafile 'D:\oracle\product\10.2.0\oradata\orcl\lecast_data.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local;
oracle学习文档 笔记 全面 深刻 详细 通俗易懂 doc word格式 清晰 第一章 Oracle入门 一、 数据库概述 数据库(Database)是按照数据结构来组织、存储和管理数据的仓库,它产生于距今五十年前。简单来说是本身可视...
针对物理迁移,也即通过RMAN备份来进行还原并应用归档的方式(这里不讨论通过dd方式进行的冷迁移),虽然注意的是要将数据库设为force logging的方式,在用RMAN做全备之前,一定要执行: 否则可能会产生坏块。 ...
/*第1步:创建临时表空间 */create temporary tablespace user_temp temp.../*第2步:创建数据表空间 */create tablespace user_data logging datafile ‘D:\oracle\oradata\Oracle9i\user_data.dbf’ size 50m
CREATE SMALLFILE TABLESPACE "NNC_DATA01" DATAFILE 'f:\database\DATA\NNC_DATA01' SIZE 256K AUTOEXTEND ON NEXT 512K MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;...
CREATE TABLESPACE TS_RISK3 LOGGING DATAFILE '****\TS_RISK3.DBF' SIZE 10240M REUSE AUTOEXTEND ON NEXT 8M MAXSIZE 32767M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
10.2.6 LOGGING和NOLOGGING 348 10.2.7 INITRANS和MAXTRANS 349 10.3 堆组织表 349 10.4 索引组织表 352 10.5 索引聚簇表 368 10.6 散列聚簇表 376 10.7 有序散列聚簇表 386 10.8 嵌套表 390 10.8.1 嵌套表...
ORA-14102: 只能指定一个 LOGGING 或 NOLOGGING 子句 安装补丁:8795792补丁 oracle
第 1章 开发成功的Oracle应用程序...................................................... 61 1.1 我的方法................................................................................ 63 3 / 976 1.2 ...
nolog = no logging方式导入 (默认FALSE) Export Valid Keywords: query = select语句,只支持单表查询 table = 导入目标表名 (控制文件) mode = 导入操作 INSERT/APPEND/REPLACE/TRUNCATE (控制文件,默认INSERT...
create tablespace tablespaceName logging datafile 'D:\PROGRAMFILES\ORACLE\PRODUCT\10.2.0\ORADATA\BWDB.DBF' 具体下载看