Technical Blog

Pages

▼
Apr 20, 2014

Oracle Baseline

›
Oracle Baseline ...
Dec 31, 2013

Buffer Aging , LRU Lists,Dirty List & DBWR

›
All Oracle data is obtained by users from the buffer cache.The basic purpose of the cache is to minimize physical disk I/O by holding (buff...

PGA & SGA

›
PGA stands for Process Global Area which is also known as Program Global Area. It is called global area because is keeps information which...
Dec 20, 2013

Row chaining & Migration

›
ANALYZE TABLE {BAD_TABLE} LIST CHAINED ROWS INTO {MY_CHAINING_TABLE}; For More Reference

PCTFREE , PCTUSED ,INITRANS & MAXTRANS

›
       The datafiles are the physical storage space on the server. Storage in the datafiles is allocated by blocks to each extent that is u...
‹
›
Home
View web version
Powered by Blogger.