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.

Follow-Ups:

RE: ** chained rows fixing
From: Mark W. Farnham

RE: ** chained rows fixing

Other related posts: