Repo Maintenance
I
1) Take Full Backup
2) Take Only Wanted Backup.
3) Then Project ---> Compact Repository
4) Reimport the Data From ATL files
If the repo is Still Slow
II
1) Go to Repo in Toad
2) Take AL_STATISTICS Backup
3) Truncate the table AL_STATISTICS
4) Reimport the data from ATL files
If the repo is Still Slow
III
1)Take the Backup of AL_MACHINE_INFO table.
2)Create a new repo
3)You will be losing AL_MACHINE_INFO, without this
jobs may/may not execute. So insert the data
back from backup table.
Finally
Clean the Bin Dir DMP Files.
