> session statistics before & after test operation), I had a problem in ver > 8.1.6.3 that one of the operations wasn't nologging despite my nologging > clause in DDL command. I don't remember with which operation I actually saw > it but after altering relevant operations to nologging, then the nologging > operation actually worked. I mistyped a word here - basically when I altered the tables to nologging, then the nologging operation actually worked in nologging mode (it didn't if I just had specified alter table move nologging). Also I increased _db_file_direct_io_count for having bigger direct IO size for parallel slaves. Tanel. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------