Suppose your DB is OLTP and you have 50 users online. Your DB is in archive log mode and has enough space in the archive directory. You have a table named Table_A. It has 1 million rows.

You execute this:

delete from Table_A;

Can anyone tell me what exactly will happen next to the database? Exactly what will be written to online redo logs?


Now you modify your SQL and make it commit every 5000 rows. Will you have the same amount of redo?

How about commit every single row? Will that be good to the DB?

Qingbo