A Question about Oracle redo genaration

Dear Experts,

Which type of DML Statments genarate more redo?

and can you tell me, Does SELECT statment also genarate redo?

Thank You in advance.
Pradeep.
Pradeep SiriwardanaSystems EngineerAsked:
Who is Participating?
 
Victor TarasovConnect With a Mentor Head of the Department of System AdministrationCommented:
A select for update will generate both redo and undo.

A read only select will USE undo (for read consistency)

A read only select may GENERATE redo due to block cleanouts.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.