Re: Impact of With Clause on Redo Log

From: Mladen Gogala <>
Date: Mon, 19 Mar 2012 17:09:55 +0000 (UTC)
Message-ID: <jk7p93$jfp$>

On Mon, 19 Mar 2012 09:16:21 -0700, Deb wrote:

> Does a with clause(and if it fetches huge data with ROWID) have
> any impact on the Redo Log?
> Thanks Deb

Well, CTE (Common Table Expressions, the "smart" name for the WITH clause) as such doesn't have any impact on redo processing but the underlying query might. Have you tried running the statement with 10046 trace, to see what is it doing and how? However, it is highly unlikely that a query is doing anything with a redo, unless it is doing a block cleanup from a previous long running transaction.

Received on Mon Mar 19 2012 - 12:09:55 CDT

Original text of this message