Rollback Segments

Hi,

I have a couple of questions about rollback segments. Any help is appricated. So, my System: Oracle 8.1.6 on Linux

Question 1:
According to Technet, if I don't specify rollback segments in my init.ora file, the Oracle instance will automatically aquire the rollback segments it needs (from those that are avaiable). At the moment, I'm refering to PUBLIC rollback segments. Technet also states that the SYSTEM rollback segment is aquired automaticaly as well and that if there are too many transactions for the non-SYSTEM rollback segments, Oracle will use the SYSTEM segment. So, if this occurs, and I create and bring online additional rollback segments, will they automatically be utilized by the instance, or will I have to shutdown and restart the instance?

Question 2:
If I specify the rollback segments I want the instance to use in init.ora, do I need to specify system segments as well, or only just the public/private rollback segments? (ie, are SYSTEM rollback segments always automatically aquired?)

Question 3:
If I added an additional SYSTEM rollback segment and bring it online, its it utilized automatically?

Much Thanks,

Will C. Received on Sun Jun 10 2001 - 15:13:56 CDT