Re: Rollback segments

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Thu, 25 Mar 1999 09:51:27 -0800
Message-ID: <36FA779E.E7BDAEE@us.oracle.com>

Comments inline.

HTH Pete

Jean-François Vincent wrote:

> Is it best to have one big roollback segments or
> a few small ones ?

It sounds like you only have a small database, but generically, the number of rollback segments needed is determined by the number of concurrent transactions. The rough rule of thumb is to create n/4 rollback segments where n is the number of concurrent transactions.

> why all the rollbacks segments are not automatically online at the
> startup, i know how to change that but i don"t know why.

If the rollback segments are private (as it seems), add a line to your init.ora file that lists the rollback segment names:

rollback_segments = rbs1, rbs2, ...

> thank you for explanation.

No problems.

>
>
> J-Fr.

--

Regards

Pete

---

Peter Sharman                             Email: psharman_at_us.oracle.com
WISE Course Development Manager           Phone: +1.650.607.0109 (int'l)

Worldwide Internal Services Education            (650)607 0109 (local)

San Francisco

SQL> select standard_disclaimer, witty_remark   2 from company_requirements;

Opinions are mine and do not necessarily reflect those of Oracle Corporation

"Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook
"Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA

---

Received on Thu Mar 25 1999 - 11:51:27 CST