When archiving what gets put in logs????

[jballum]

I have a site that is set with Archiving on and was looking for a little information as to what exactly is logged when an Insert statement is done and an Update statement as well.

The reason I ask is the logs are taking up approx. twice as much space as the database itself.

Note: before the process was run it was verified that the archive location was empty.

Thanx

JB

 

[sem]

Nothing unusual, because your database stores only current data snapshot, while logs - all the changes, i.e. a lot of states. It's the same as the size of photo and size of movie.

Regards, Dima

 

[jballum]

Dima,

So I do an update and in the log it logs what exactly?

JB

 

[Turkbear]

Hi,
( May I Dima?),
When it is triggered by the ARCH process it copies the Redo
Log - so it contains all the redo log entries..

It does not do this when you perform the update ( the changes are 'written' to the redo log) , but when the redo log needs archiving..

To learn more about this, read the DBA docs and the Oracle concepts manual.