Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Chained Rows

Re: Chained Rows

From: Frank Abney <abneyf_at_osshe.edu>
Date: 1997/04/04
Message-ID: <Pine.GSO.3.95.970404110325.14140A-100000@osshe.edu>#1/1

Another thing you can look at is your block size. If there are any long variables in the table, you may get chaining if a single row will not fit into a single block.


Frank Abney                              Email: abneyf_at_osshe.edu
Oregon State System of Higher Education Phone: (541) 737-6269

On Wed, 2 Apr 1997, Jared Hecker wrote:

> Basically it means your table storage parameters should be reexamined
> - especially PCTFREE and NEXT_EXTENT. Recalculate the maximum record
> length and resize accordingly. Algorithms are in the doc set, I think
> in the Server Reference.
>
> To fix: export it, drop and recreate it with new storage parameters,
> import it.
>
> hth -
>
> jh
>
> On Tue, 01 Apr 1997 20:34:13 GMT, theo.verbinnen_at_innet.be wrote:
>
> >hi all,
> >
> >
> >i found out that five system tables contain chained rows?
> >is this a normal situation? I guess not but what to do about it?
> >thanks for your help........
> >
>
>
>
Received on Fri Apr 04 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US