In 10g, statistics will automatically be gathered for your objects and there is a method to gather stats on the SYS objects as well. There's a new SYSAUX tablespace that contains most of the objects for any add-on database options (like Oracle Text, for example).
To save yourself time, I'd prepare a new ORACLE_HOME with the 10g base release and apply the 10.1.0.3 patchset before doing an upgrade (or creating a new database). This will save you a step or two later and will fix a significant number of bugs that you may encounter.
Dig Deeper on Oracle database installation, upgrades and patches
Related Q&A from Dan Norris
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.