Re: PUBLIC rollback segments in 7.1.6

From: Mserban <mserban_at_aol.com>
Date: 1997/03/29
Message-ID: <19970329011701.UAA03384@ladder01.news.aol.com>#1/1

If you do not have ANY rollback segments defined/enumerated in your init<sid>.ora file, by default ORACLE will always bring online, at instance startup, a number of rollback segments = TRANSACTIONS/TRANSACTIONS_PER_ROLLBACK_SEGMENT, provided they have been created already. TRANSACTIONS and TRANSACTIONS_PER_ROLLBACK_SEGMENT are two init<sid>.ora parameters. If you have PRIVATE rollback segments defined in init<sid>.ora, but their number is insufficient, ORACLE will bring online the required PUBLIC rollback segments to make up the difference. This behavior has nothing to do with 7.1.6.

I hope this helps.

Michael Serbanescu
Senior Consultant, MIACO Corporation Received on Sat Mar 29 1997 - 00:00:00 CST