Re: how to determine number of chained rows
From: Hans Forbrich <fuzzy.graybeard_at_gmail.com>
Date: Mon, 15 Apr 2013 09:15:05 -0600
Message-ID: <516C1979.8060506_at_gmail.com>
On 15/04/2013 8:57 AM, Jeffrey Beckstrom wrote:
> DBMS_STATS does not compute number of chained rows.
> analyze table x list chained rows - this does but if the table is large and has lots of chained rows, then need a lot of rollback space for rows inserted into the chained_rows table.
>
> Is there another way to just get a count of chained rows?
>
Would "How to Identify, Avoid and Eliminate Chained and Migrated Rows ? [ID 746778.1]" possibly help? Especially #2 ...
Date: Mon, 15 Apr 2013 09:15:05 -0600
Message-ID: <516C1979.8060506_at_gmail.com>
On 15/04/2013 8:57 AM, Jeffrey Beckstrom wrote:
> DBMS_STATS does not compute number of chained rows.
> analyze table x list chained rows - this does but if the table is large and has lots of chained rows, then need a lot of rollback space for rows inserted into the chained_rows table.
>
> Is there another way to just get a count of chained rows?
>
Would "How to Identify, Avoid and Eliminate Chained and Migrated Rows ? [ID 746778.1]" possibly help? Especially #2 ...
/Hans
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Apr 15 2013 - 17:15:05 CEST