Oracle Database Discussions

Guys,

I'm bit confused with this direct insert statments and redo.

Ive created below table, and used direct insert statment. But Autotrace shows redo size?

Any idea why? I was expecting redo will bypass.

Only thing is our DB is on force logging mode but the table space is in NO force logging.

create table WC_TEST_NK (name varchar2(100)) nologging;

insert /*+ append */ into WC_TEST_NK (name) select row_WID from WC_BIGTABLE where rownum < 100

          10484  redo size

            8236  redo size for direct writes

               2  redo subscn max counts

               2  redo synch time (usec)

           30007  redo synch time overhead (usec)

               1  redo synch time overhead count ( 32ms)

               1  redo synch writes

               1  redo write info find

Thanks!