You are hereOracle

Oracle


Topics related to Oracle RDBMS Oracle Server

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:



Distribuir

Distribuir contenido

Follow DatabasesLA on Twitter

En línea

En este momento hay 0 usuarios y %count invitados en línea.

Estadisticas

Locations of visitors to this page

hidden hit counter