RE: ** chained rows fixing
- From: "Gogala, Mladen" <MGogala@xxxxxxxxxxxxxxxxxxxx>
- To: "'ajoshi977@xxxxxxxxx'" <ajoshi977@xxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
- Date: Fri, 23 Sep 2005 15:08:05 -0400
Alter table AJOSHISTABLE rebuild tablespace system storage ( PCTFREE 85
PCTUSED 10);
That would guarantee that no chained rows will ever be found in this table.
If anyone here is working for Seagate, Fujitsu or Maxtor, I will gladly
accept your donations.
--
Mladen Gogala
Ext. 121
_____
From: A Joshi [mailto:ajoshi977@xxxxxxxxx]
Sent: Friday, September 23, 2005 1:50 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: ** chained rows fixing
I plan to increase the pctfree to prevent chained rows in future. Is there
any thing else I need to do. I assume a simple delete and insert will
eliminate chained row. Do I need anything else. Can some provide a generic
script for this. I have all the chained row in table chained_rows. Any other
guidelines. Thanks. Help is appreciated.
Other related posts:
