Re: Private vs. Public Rollback Segments

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 08 Aug 2001 00:47:18 -0700
Message-ID: <F001.00363B99.20010808001117@fatcity.com>

Private rollback segments ensure that every instance in OPS gets to start up with at least one non-system rollback segment. It also gives you the option of localising rollback segments for each specific instance to a tablespace on disks with some affinity to the instance's node. (But that consideration seems to have disappeared with 9i and SMUT).

Jonathan Lewis

Seminars on getting the best out of Oracle Last few places available for Sept 10th/11th See http://www.jlcomp.demon.co.uk/seminar.html

-----Original Message-----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Date: 08 August 2001 03:10

|Hi all,
|
|I think we can create a big private rollback segment for huge
transaction
|when we need one or two.
|
|
|Sinardy
|
|-----Original Message-----
|Sent: Wednesday, 8 August 2001 8:45 AM
|To: Multiple recipients of list ORACLE-L
|
|
|Can someone explain the benefit of using a private rollback segment?
The
|only advantage I can see is having more control over what rollback
segments
|actually come on line when the instance is started. The drawback is
you
|have to use the rollback_segments parameter in the parameter file
which we
|know a lot of newbies miss. It seems like the easiest way to go is
just use
|public segments, even in non-parallel server situations and then you
don't
|have to worry about the rollback_segments parameter.
|
|- Ethan
|- http://www.geocities.com/epost1
|
|---------------------------------------------------------------------

---

|--
|This e-mail is intended for the use of the addressee(s) only and may
contain
|privileged, confidential, or proprietary information that is exempt
from
|disclosure under law. If you have received this message in error,
please
|inform us promptly by reply e-mail, then delete the e-mail and
destroy any
|printed copy. Thank you.
|
|=====================================================================

---

|==
|--
|Please see the official ORACLE-L FAQ: http://www.orafaq.com
|--
|Author: Post, Ethan
| INET: epost_at_kcc.com
|
|Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
|San Diego, California -- Public Internet access / Mailing
Lists
|--------------------------------------------------------------------
|To REMOVE yourself from this mailing list, send an E-Mail message
|to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
|the message BODY, include a line containing: UNSUB ORACLE-L
|(or the name of mailing list you want to be removed from). You may
|also send the HELP command for other information (like subscribing).
|
|--
|Please see the official ORACLE-L FAQ: http://www.orafaq.com
|--
|Author: Sinardy
| INET: sinardyxing_at_bcsis.com
|
|Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
|San Diego, California -- Public Internet access / Mailing
Lists
|--------------------------------------------------------------------
|To REMOVE yourself from this mailing list, send an E-Mail message
|to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
|the message BODY, include a line containing: UNSUB ORACLE-L
|(or the name of mailing list you want to be removed from). You may
|also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jonathan Lewis
  INET: jonathan_at_jlcomp.demon.co.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Wed Aug 08 2001 - 02:47:18 CDT