You are hereOracle
Oracle
Topics related to Oracle RDBMS Oracle Server
LOGGING or NOLOGGING, that is the question - Part 1
Introduction
The main question about NOLOGGING I hear all the time is: does creating a table with the NOLOGGING option means there is “no generation of redo ever”, or just that the initial creation operation has no redo generation, but that DML down the road generates redo? How and when can the NOLOGGING option be employed?
FOR UPDATE or not FOR UPDATE
Have you considered the impact of an unnecesary FOR UPDATE on your queries?
El export dump comprimido
¿Has estado en la situacion de mover un archivo dump generado por export y este es demasiado grande o que no dispongas del espacio suficiente para crearlo en el servidor de BD?
The squeezed dump
Sometimes you'll try to move data from one DB to another, or just between platforms. If you use the old export/import duo there are some workarounds to split big dump files in smaller pieces... but ¿what if, even with smaller pieces my file is unmanageable?
There is a workaround when working with Unix and Linux platforms: pipes and IO redirection.
These simple scripts would allow you to compress and decompress dump files 'on the fly'
Recover that lost space
Do you know what happens when you issue a DELETE? Have you wondered what happen after COMMIT? ... well, I might say that there is life after delete for all those blocks that belonged to the data recently deleted.
I'll present the following test case to show you how this works:
