Technical Blog

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 stands for Process Global Area which is also known as Program Global Area. It is called global area because is keeps information which...

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

       The datafiles are the physical storage space on the server. Storage in the datafiles is allocated by blocks to each extent that is u...

Oracle introduced Oracle Managed Files (OMF) concept in Oracle 9i. OMFs simplify the administration task of an Oracle Database. Oracle man...