Re: Undo Usage and Read consistency - ORA-1555

From: Jared Still <jkstill_at_gmail.com>
Date: Tue, 14 Jul 2009 15:07:26 -0700
Message-ID: <bf46380907141507s4981b34q5c7c0c5c6ab069d3_at_mail.gmail.com>

On Tue, Jul 14, 2009 at 1:28 PM, Randy Johnson <oraclelist_at_sbcglobal.net>wrote:

> Or use a smaller block size so you end up with fewer rows
> Per block.
> - Can anyone think of another way to decrease the effected
> rows?
>

Rebuild the table with a higher PCTFREE.

Or as of 10gR2 ( I think it was R2) you can use ALTER TABLE ... MINIMIZE ROWS_PER_BLOCK Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jul 14 2009 - 17:07:26 CDT