-
编辑 删除
NOTES on concepts ---Partitions
Each partition is an independent object withits own name and optionally its own storage characteristics.Benefits include:Increased availability： The query optimizer automatically r...
-
编辑 删除
NOTES on concepts ---Tables
1. Category1) Object tables2) Relational tablesHeap-organized table Index-organized tableExternal table A table is either permanent or temporary. A permanent t...
-
编辑 删除
NOTES on concepts ---schema objects
1. Object types1) table: store data in row2) index3) partition: pieces of large tables and indexes4) view5) sequence6) dimension:A dimens...
-
编辑 删除
index-organized table
B-tree index entries are usually quite small, because they only consist of the key valueand a ROWID. In index-organized tables, however, the B-tree index entries can be large,because they consist of t...
-
编辑 删除
concept---Index-Organized Table
1. OverviewA table stored in a variation of B-tree index structure.Each index entry in the B-tree also stores non-key column values. Thus, the index is the data, the data is the index....
-
编辑 删除
Configure OGG to maintain a standby database
1. Overview of a live standby configurationIn thisconfiguration, there is an inactive Oracle GoldenGate Extract groupand an inactive data pump on the live standby system. Both of those...
-
编辑 删除
Tips on GoldenGate
1. Oracle补全日志默认情况下redo日志中只记录rowid以及被修改的字段的信息。当GoldenGate还原该事务，是SQL层面根据唯一键值来定位记录，故需要将主键或其他字段信息附近到日志中。最小附加日志，是开启logmnr...
-
编辑 删除
Monitoring GoldenGate Processing
Overview monitoring toolsGGSCI information commands The ggserr.log file (error log)Process reportThe discard filesThe logs at operating-system levelUsing the information commands ...
-
编辑 删除
GoldenGate Architecture
Architecture1.Manager The GoldenGate Managerprocess is used to manage all of the GoldenGateprocesses and resources. A single Manager process runs on each server wher...
-
编辑 删除
GoldenGate安装、配置
Preinstall:1. Alter source database in archive mode( alter the target either if perform. a bidirectional replication ).2. Add supplemental log to the source database.da...
-
编辑 删除
SQL语句中SELECT语句的执行顺序
select语句执行的逻辑处理顺序：(8)SELECT(9)DISTINCT(11) <TOP_specification> <select_list>(1) FROM <left_table>(3) <join_type> JOIN <right_table>(2) ON <join_condition>(4) WHERE <wher...
