Re: Impact of With Clause on Redo Log
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Mon, 19 Mar 2012 17:09:55 +0000 (UTC)
Message-ID: <jk7p93$jfp$1_at_solani.org>
On Mon, 19 Mar 2012 09:16:21 -0700, Deb wrote:
Date: Mon, 19 Mar 2012 17:09:55 +0000 (UTC)
Message-ID: <jk7p93$jfp$1_at_solani.org>
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.
-- http://mgogala.byethost5.comReceived on Mon Mar 19 2012 - 12:09:55 CDT