PostgreSQL uses MVCC (multi-version concurrency control) to provide transactional semantics. In the simplest form, MVCC lets each transaction work on a different copy of a row in a table. What it means is whenever a row is updated, a new version of the row is created.
Sharing knowledge is the ultimate key to gaining knowledge..
The only two things that stay with you for life
are you & your knowledge !
Live while you can!
Teach & inspire while you could &
Smile while you have the teeth.. 😉
Sunday, 6 March 2022
Saturday, 5 February 2022
Tracing Oracle Data Guard
Tracing can also be enabled in dataguard using the parameter "Log_Archive_Trace"
The values can be set using DG-Broker (if configured) or at SQL prompt as below.
Sunday, 16 January 2022
Feedspot - Top database blog list
Dear All,
I am pleased to inform that I received this recognition from Feedspot and I'm proud to be part of the awesome family- Thank you Anuj and Team for this recognition!
Sunday, 9 January 2022
Consistency check before performing RMAN resetlogs.
The article covers consistency check before performing OPEN RESETLOGS after restoring a database using backup