Impact of With Clause on Redo Log

    I'm using Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 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?

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