Monthly Archives: June 2018

Oracle推进SCN系列：使用oradebug在mount状态下推进SCN

Posted on June 29, 2018 by Alfred Zhao

我这里演示下推进SCN 10W数量级，实际需求推进多少可以根据ORA-600 [2662] [a] [b] [c] [d] [e]具体值来确认。 Continue reading →

Posted in Oracle备份恢复 | Tagged oradebug, SCN | Comments Off

记录一则完整的SPA(10g->11g)测试过程

Posted on June 22, 2018 by Alfred Zhao

因为Oracle跨越大版本，优化器、新特性变动较多，需要进行SPA测试比对前后期性能差异。 Continue reading →

Posted in Oracle性能优化 | Tagged SPA | Comments Off