ITPub博客

Instance Recovery: Instance recovery is done automatically by SMON. it is reqd in case of abonormal shutdown such as shutdown abort or any such reason.Instance recovery is recovery of a single da...

Undo LifetimeUndo information has different states during it’s lifecycle, depending onrunning transactions and retention settings.There are three states or types of extents in the Undo tablespac...

Buffer Cache概述Buffer Cache是SGA的一部分，Oracle利用Buffer Cache来管理data block，Buffer Cache的最终目的就是尽可能的减少磁盘I/O。buffer cache所能提供的功能主要包括： 通过缓存数据块，从...