Speeding up the BODI Repository

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.