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
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 ...
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...
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 ;
关注
