Re: Chained Rows

>>>>>
>
>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........
>

<<<<<
Which system tables? If the Tables hold data for objects that you can identify maybe using the chained rows clause of the analyze command maybe you can drop and recreate the objects. Also are you sure that the chaining is not do to the row being larger than your database block size. A lot of the system tables use long columns to store text and large text entries will exceed a block in size.

I sure hope you did not leave statistics on your system (dictionary?) tables. I know the 7.0 DBA Guide says to compute them but Oracle support has said never to do this as it has a tendency to create performance problems.

If you are taking about Oracle product tables owned by System then I would like to hedge all comments. We have never analyzed any Oracle tool tables or indexes. I should give that some thought.

Mark Powell -- The only advise that counts is the advise that you follow so follow your own advise Received on Wed Apr 02 1997 - 00:00:00 CST