Solved

A Question about Oracle redo genaration

Posted on 2012-04-01
3
313 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
  • 2
3 Comments
 
LVL 17

Expert Comment

by:Anuroopsundd
ID: 37794511
0
 
LVL 17

Expert Comment

by:Anuroopsundd
ID: 37794515
0
 
LVL 4

Accepted Solution

by:
VictorTarasov 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Via a live example, show how to take different types of Oracle backups using RMAN.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

756 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