Boost your Database Performance with SecureFiles

Introduction Today i want show you a comparison between Securefiles and Basicfiles. I know that there are some other sites out there which are showing how fast Securefiles can be, but in my Tests i will also try to show some more facts and benefits about the NOLOGGING Option which i have described in a…

NOLOGGING What it is (and what it is not)

Whenever a insert or bulk load operations are performed on a database, also redo and undo blocks are created. Through the NOLOGGING option less redo blocks are written by the corresponding operation. When are NOLOGGING operations useful: To improve the performance of large insert operations To improve the build times of large indexes To improve…

Peter`s DBA Blog

Erfahrungen eines Oracle DBA`s

Schlagwort-Archive: NOLOGGING

Boost your Database Performance with SecureFiles

NOLOGGING What it is (and what it is not)