Impact of With Clause on Redo Log

From: Deb <>
Date: Mon, 19 Mar 2012 09:16:21 -0700 (PDT)
Message-ID: <>

Hi All,

    I'm using Oracle Database 11g Enterprise Edition Release - 64bit Production.

    I recently did changes to one of my select statements inside a PL/ SQL stored procedure to use a WITH clause instead of using Global temporary tables. After this change, my production Redo Log size has increased drastically.

    Currently it is 500+ GB per day while earlier it was between 150-200 GB per day.

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

Deb Received on Mon Mar 19 2012 - 11:16:21 CDT

Original text of this message