Re: Maintenance on an older DB

A version would be useful if u could post it to?

But anyway, some typical issues:-

1. Fragmentation problems
2. Indexes out of balance
3. Coalesce free space
4. Free capacity issues within tablespace or the physical disk.

Suggest that you backup your Database and then resolve any framentation problems you have.

Main issue you may next hit could be that your tablespaces are near to full or they may be auto-extending.

Resolving fragmentaion issues may get you some space back.

Perhaps the best way to resolve all these issues would be to do a full export/import and ensure you use COMPRESS=Y.

Also, certain combinations of Oracle and Solaris need to have the server bounced regularly or the instance freezes when you try to shutdown - u may need to check this out and apply a patch.

--
Posted via http://dbforums.com