redo log generation during unrecoverable/nologging

# Capture amount of redo logs generated when table is created in UNRECOVERABLE SQL> select vs.name, vm.value from v$mystat vm, v$statname vs where vm.statistic# = vs.statistic# and vs.name like '%redo size%'; NAME VALUE —————————————————————- ———- redo size 597736 SQL> create table test_all unrecoverable as (select * from all_objects); Table created. SQL> select vs.name, vm.value from…