Hello

I suggest you read about Locally Managed Tablespaces and make your extent sizes uniform .

Well its very difficult to say why your hit ratio has gone down drastically.I think you should be using statspack to gather statistics to come to a find the problem first.


Just a sugesstion did you analyze all your tables and indexes after moving to 9i ?why dont you do an analyze first and check ?

regards
Hrishy