-
编辑 删除
oracle 12c Deprecation of Oracle Streams
Deprecation of Oracle StreamsOracle Streams is deprecated in Oracle Database 12c and may be desupported and unavailable in a later Oracle Database release. Use Oracle GoldenGate to replace all replication features of Oracle Streams.可以看出在oracle 12c 版本以后，oracle streams 功能已经废...
-
编辑 删除
Oracle中的direct path read事件(转)
在11g中，全表扫描可能使用direct path read方式，绕过buffer cache，这样的全表扫描就是物理读了。 在10g中，都是通过gc buffer来读的，所以不存在direct path read的问题。 direct path read较高的可能原因有： 1. 大量的磁盘排序操作，order by, group by, union, distinct, rollup, 无法在PGA中完成排序，需...
-
编辑 删除
oracle 11.2 版本 asmcmd 针对 spfile 参数文件增加的命令
New ASMCMD commandsTo support this feature, new ASMCMD commands were introduced to back up, copy and move the ASM spfile. The commands are:spbackup - backs up an ASM spfile to a backup file. The backup file is not a special file type and is not identified as an spfile.spcopy - c...
