Solved

A Question about Oracle redo genaration

Posted on 2012-04-01
3
315 Views
Last Modified: 2012-09-07
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.
0
Comment
Question by:Pradeep Siriwardana
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 17

Expert Comment

by:Anuroopsundd
ID: 37794515
0
 
LVL 4

Accepted Solution

by:
Victor Tarasov earned 500 total points
ID: 37794532
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

Featured Post

Enroll in June's Course of the Month

June’s Course of the Month is now available! Experts Exchange’s Premium Members, Team Accounts, and Qualified Experts have access to a complimentary course each month as part of their membership—an extra way to sharpen your skills and increase training.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
Via a live example, show how to take different types of Oracle backups using RMAN.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question