Monthly Archives: June 2014

Fragmentation in table

Deleted records not freeing up space   We have deleted records from big tables in database. But each table still holds the same blocks and extents. It means they have not released the space logically. How to use this space. … Continue reading

Posted in Performance and Tuning, Uncategorized | Leave a comment

Tar a file or copy them with the same permission in linux

Tar a file with the same permission cd /u01 #tar cvpzf /mnt/backup/u01-app_orac1.tar.gz app Copy the zip file to another server and unizp it like cd /mnt/backup/ #tar xpvzf u01-app_orac1.tar.gz To copy folder including sub folder and files with the same … Continue reading

Posted in Linux commands for DBA | Leave a comment