If you generate a lot of logs in ODI, purging through ODI built-in mechanism can be very slow. A lot faster to do it through Database, but you have to respect foreign keys. Here is a sample plsql script to do so. Here is a simple script with one para

meter which is the number of days of log you want to keep, it will there retrieve session number and delete in the logs table following the dependencies....