- 博客(15)
- 收藏
- 关注
转载 VirtualBox下保证Guest和Host之间时间同步以及虚拟机之间共享磁盘
今天在搭建RAC的时候一直找不到如何设置才能是的虚拟机跟真实机之间时间同步的问题,网上找了很多资料,但绝大多数都是关于VMWare的设定,而且还是要禁止同步的。 自己搭建RAC是使...
2013-07-12 15:50:44
174
转载 unusable index in oralce
今天在网上看到一篇帖子,说的是被置为unusable的索引在truncate相应表之后竟然有变回valid的状态,后来在11g里面试了下,仍然发生,以后遇到这种问题要小心了。具体过程如下: idx_test是表...
2013-06-20 08:57:15
90
转载 Key Compression of Index
What is Index Compression?Oracle introduced a compression option for indexes in Oracle 8.1. You can create an...
2013-04-19 11:09:06
182
转载 Index Scan
索引分类: Full Index Scan 数据的获取仅从索引中得到,结果集按序排列(每次得到叶块中的数据都是从branch遍历到leaf block得到,顺序是以引导列为基础进行排序),索引列部分或者...
2013-04-18 10:45:59
178
转载 NOTES on concepts ---Partitions
Each partition is an independent object withits own name and optionally its own storage characteristics. ...
2012-12-03 14:02:09
61
转载 NOTES on concepts ---Tables
1. Category 1)Object tables 2)Relational tablesHeap-organized tableIndex-organized tableExternal...
2012-11-29 14:58:38
81
转载 NOTES on concepts ---schema objects
1. Object types 1) table: store data in row 2) index 3) partition:pieces of large tables a...
2012-11-29 13:56:01
66
转载 index-organized table
B-tree index entries are usually quite small, because they only consist of the key valueand a ROWID. In index-orga...
2012-11-28 17:27:45
88
转载 concept---Index-Organized Table
1. Overview A table stored in a variation of B-tree index structure. Each index entry in the B-tree als...
2012-11-28 17:11:46
87
转载 Configure OGG to maintain a standby database
1.Overview of a live standby configuration In thisconfiguration, there is an inactive Oracle GoldenGa...
2012-11-28 10:30:24
87
转载 Tips on GoldenGate
1. Oracle补全日志 默认情况下redo日志中只记录rowid以及被修改的字段的信息。当GoldenGate还原该事务,是SQL层面根据唯一键值来定位记录,故需要将主键或其他字段信息附近到日志中。最小附加日志,是...
2012-11-26 17:18:46
63
转载 Monitoring GoldenGate Processing
Overview monitoring toolsGGSCI information commandsThe ggserr.log file (error log)Process rep...
2012-11-26 09:57:48
111
转载 GoldenGate Architecture
Architecture1.Manager The GoldenGate Managerprocess is used to manage all of the GoldenGateproc...
2012-11-23 17:01:50
62
转载 GoldenGate安装、配置
Preinstall: 1. Alter source database in archive mode( alter the target either i...
2012-11-23 15:58:15
111
转载 SQL语句中SELECT语句的执行顺序
select语句执行的逻辑处理顺序:(8)SELECT (9)DISTINCT(11) (1) FROM (3) JOIN (2) ON (4) WHERE (5) GROUP BY (6) WITH {C...
2012-11-23 14:11:44
71
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人