Re: Undo Usage and Read consistency - ORA-1555
- From: Jared Still <jkstill@xxxxxxxxx>
- To: oraclelist@xxxxxxxxxxxxx
- Date: Tue, 14 Jul 2009 15:07:26 -0700
On Tue, Jul 14, 2009 at 1:28 PM, Randy Johnson <oraclelist@xxxxxxxxxxxxx>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
Other related posts:
