Monthly Archives: April 2009

Oracle Performance Tuning Notes

Click for the Course notes with scripts for a 3 day performance tuning course I did recently.

Posted in Performance tuning

schema moves by the magic of partition exchange

Here’s an example of how to use partition exchange to move partitions or even entire unpartitioned tables from one schema to another. Is mean to be very fast and generate very little redo. Even more so if the partitions and

Posted in Performance tuning, Scripts, Space

Use ftp in shell scripts with password in .netrc

ftp can be used in shell scripts by specifying the ftp password in a .netrc file. On the source server create/edit this file: $ vi $HOME/.netrc Add in a line with the username password details: machine targetservername login targetusername password

Posted in Linux