Title: RE: how do you verify that create table ... nologging ... as sele
Thank you to all that replied to my question, and thank you Mr. Reardon for telling me about the "log_file_usage.sql" script from Steve Adams/Ixora.
I have to make a confession - I've been unfaith
Jacques,
What about using the following script to measure actual amount of redo in
the log file:
---
--
-- Script: log_file_usage.sql
-- Purpose: to see how much of the current log file has been used
-- For:
Title: RE: how do you verify that create table ... nologging ... as select
> -Original Message-
> From: Jeremiah Wilton [mailto:[EMAIL PROTECTED]]
> ...
>The 'redo writes' and 'redo blocks' statistics are racked up by LGWR ,
>so you shouldn't see your session doing much of them.
>
>A b