Monthly Archives: April 2009

Oracle Performance Tuning Notes

Posted on 17 April 2009 by Andrew Fraser

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

Posted in Performance tuning | Leave a comment

schema moves by the magic of partition exchange

Posted on 17 April 2009 by Andrew Fraser

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 … Continue reading →

Posted in Performance tuning, Scripts, Space | 1 Comment

Use ftp in shell scripts with password in .netrc

Posted on 17 April 2009 by Andrew Fraser

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 … Continue reading →

Posted in Linux | Leave a comment