Re: Undo Usage and Read consistency - ORA-1555
Date: Tue, 14 Jul 2009 15:07:26 -0700
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
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
Certifiable Oracle DBA and Part Time Perl Evangelist