just trying to do the upgrade ASAP
UNDO works fine, if you've done your homework then you can implement this. If not just go with rollback segs.
The next one is dicey, CBO has undergone material changes between 8i and 9i. You are better off gathering stats using dbms_stats and deal with any SQL issues that may arise. If you are steadfast on not gathering stats and upgrading to 9i (you may want to verify what an upgrade does to the stats - I can't remember if the upgrade erases the stats), then consider setting OPTIMIZER_FEATURES_ENABLE to an appropriate value (check the reference guide).
Are you planning to bypass PGA_AGGREGATE_TARGET as well? :--) sorry couldn't resist.
Hi, I am upgrading 8i database to 9i. I will not be moving to UNDO management right away. I assume rollback segments will work on 9i the same way they work on 8i. I will be moving to UNDO soon since it is better. Similarly I will not be gathering statistics. I assume the existing statistics will work the same way on 9i as they worked on 8i and that it is not mandatory to generate them on 9i. I will be generating statistics soon. I am just trying to do the upgrade ASAP since it is overdue without worrying about other things. Does anyone have similar experience or any comments about this approach. Thanks for the help.
------------------------------ Do you Yahoo!? Get on board. You're invited<http://us.rd.yahoo.com/evt=40791/*http://advision.webevents.yahoo.com/mailbeta>to try the new Yahoo! Mail.