This post describes some deep knowledge of SGA. LOCK_SGA is used to make sure that the contents from the SGA are not flushed, i.e data from the DB buffer cache not written back to disc. It is like to pin the contents of SGA. SGA_LOCK locks the entire SGA into physical memory. It is usually advisable to […]