If you have only recently moved to Oracle8, or have moved and are still using standard build tablespaces, try locally managed tablespaces for your temporary segments to reduce data dictionary overheads. If you are new to Oracle9i, then investigate the advantages of using locally managed tablespaces everywhere for your user schema. This will remove things like extent management overheads completely from the Data Dictionary operation.

Locally managed tablespaces are more efficient than standard build tablespaces - a factor that could mean the difference between "managing" and "overwhelmed" on some databases.

To Oracle Tips Index