Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Chained Rows
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.eduOregon 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