- 博客(6)
- 收藏
- 关注
原创 Does your high availability design works as you expect ?
We may pay more attention to our core system architecture design. Use RAC with two nodes at least,normal redundancy diskgroup or higher, multiple IO chains,multiple network cards binding for private network,use local DG with same operation system power and
2020-05-24 19:38:46
177
原创 What should be considered if you want to use oracle in-memory
1.Which side shall we enable in-memory,primary or standby.In-memory can be enabled on both primary and standby side.So if you have ADG and it already provide query for PRD, you may want to enable ...
2020-04-07 22:44:47
230
原创 log file sync case sharing
category: oracle databaseissue: performanceapply to: architects/support/operationbackground:The customer suffered performance issue in the database and got complain from business.They analyze...
2020-03-28 12:55:29
332
原创 with as 固化的结果集是否可以使用原表的索引?
结论with as 固化的结果集再添加条件再次使用的时候是可以使用原表的索引的。测试步骤如下:1.构建测试表create table dbmgr.TEST_APPEND as select * from dba_objects ; insert into dbmgr.TEST_APPEND select * from dbmgr.TEST_APPEND ;
2017-09-20 22:30:54
3422
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人