Hello,
We are doing database import for migration from informix to oracle...
Database size is 700 Gb...
I would like to know what should be the ideal size for tablespace PSAPROLL [we have not moved to UNDO]...
Also how should we create rollback segment..What should be the value for
MINEXTENTS,MAXENTENTS,INITIAL EXTENS AND NEXTEXTENTS...
Also how many rollback segment should be created...
All these should be done keeping in mind the Database Size, Number of Parallel processes that are running [12]...
Kindly suggest...
Thanks & Regards,
RaHuL...