Re: Sizing rollback segments?

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 22 Jul 1999 20:41:29 +0800
Message-ID: <37971179.4165@yahoo.com>

David Van Zandt wrote:
>
> I raised an ORA-1555 yesterday (rollback space too small for
> transaction) on one database, and "solved" it by creating an additional
> (and larger) segment. Next I turned to my handy Oracle Press DBA guide,
> and my eyes glazed within 30 seconds....
>
> Can anyone please steer me toward a "more better" source on resizing
> segments? There have been some significant changes to a number of
> schemas, and my knowlege of tweaking the INITsid.ORA is hit or miss.
>
> TIA,
> Dave VZ
> Alcoa Engineered Products

"Advanced DBA Guide" by Kevin Loney is a reasonable reference.

You can buy it online off www.amazon.com

HTH
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Thu Jul 22 1999 - 07:41:29 CDT