Next week for some period of time I am given the task of analyzing an existing Oracle database of version 10g and come up with a list of suggestions/recommendations.
Can you help me a little bit as to what points I should concentrate on.
"Upgrade to a supported release"
I recommend that it be upgraded to a supported version.
what is OS name & version?
I would suggest you scan alert logs and trace files. They will give a lot of information of what's going wrong in your DB. Of course upgrade to a newer version would be a suggestion.
Upgrade, auditing, security, performance are just few of the areas that come to the mind.