What's inside a redo record in Oracle's Redo log?
0
votes
2
answers
1114
views
While reading the Redo log wiki page , I was confronted with the following statement:
> For example, if a user
UPDATE
s a salary-value in a table containing employee-related data, the DBMS generates a redo record containing change-vectors that describe changes to the data segment block for the table. And if the user then COMMIT
s the update, Oracle generates another redo record and assigns the change a "system change number" (SCN).
In what way do change-vectors describe changes to the data? Do they contain a copy of the old and the updated data, or just the SQL statements? I also don't understand the difference between the first generated redo record and the one generated after the update is commited.
Asked by Mehdi Charife
(131 rep)
May 6, 2023, 02:10 PM
Last activity: May 8, 2023, 08:09 AM
Last activity: May 8, 2023, 08:09 AM