All,

Database- 9206
OS - Sun solaris 64bit, 5.8

We have a 4tb database with 64 tablespaces, 896 datafiles, putting this database in backup mode using alter tablespace begin backup commands would take 20 to 25 mins. Lately, it is taking over 2 hrs.

The only change before this unusually big difference was we moved to locally managed temporary tablespaces. I don't think this contributes in any way, but that was the only change on the database.

We tried different backup times, but still the same result.

I don't know what/where to start looking for this problem.

Greatly appreciate all your suggestions.

Regards
Vj