Question: what is mvcc in oracle?
Answer: MVCC in Oracle This automatic reuse facility enables Oracle to manage large numbers of transactions using a finite set of rollback segments. The header block of the rollback segment is used as a transaction table. Here the status of a transaction is maintained (called System Change Number, or SCN, in Oracle).