WINDOWS下的程序员出身,偶尔也写一些linux平台下小程序, 后转行数据库行业,专注于ORACLE和DB2的运维和优化。 同时也是ios移动开发者。欢迎志同道合的朋友一起研究技术。 数据库技术交流群:58308065,23618606
全部博文(599)
发布时间:2012-12-29 21:09:07
By default RMAN has three types of compression : 1. Null Compression2. Unused Block Compression3. Binary CompressionTill Oracle Version 10.1 only 'Null' compression in done by default but from Oracle Version 10.2 'Null' and 'Unused Bloc'k Compression is done. T......【阅读全文】
发布时间:2012-12-28 10:04:53
Beginning with Oracle10G, when statistics are gathered for a table, the old statistics are retained so should there be any problem with performance of queries dependent on those statistics, the old ones can be restored.How long does Oracle retain the statistics for ? The default peri......【阅读全文】