Technical Blog

Analytic functions compute an aggregate value based on a group of rows. They differ from aggregate functions in that they return multiple r...

Oracle Baseline ...

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