OraFAQ Forum: Server Administration » Select statement generates Redo

Home » RDBMS Server » Server Administration » Select statement generates Redo (Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Select statement generates Redo [message #534519]

Wed, 07 December 2011 01:10

abhi_sri
Messages: 20
Registered: September 2010
Location: India

Junior Member

Hi,

Whenever any transaction happen in database redo has generated for this transaction. This redo will be helpful if in future any kind of recovery required.
Now my question is- Do select statement treat as a transaction as it doesn't modify any thing in database.
And If select statement should not be a transaction, there should not be any redo generation for select statement.

So is select statement generate redo? If yes then Why ?

Thanks in advance for all your favours.

Regards
Abhishek

Report message to a moderator