Re: FTS waiting on db file sequential reads?

From: Kenny Payton <k3nnyp_at_gmail.com>
Date: Thu, 18 Sep 2014 15:31:54 -0400
Message-ID: <CAEidWqM8W7W=BvuY7iKzri6Bznve6cHcLF9Rm0z7i-F685YAqw_at_mail.gmail.com>

Look at the "analyze table list chained rows" command. It could be chained or migrated rows.

We have pretty bad re-occurring migrated rows from time to time and have to reorg occasionally to get rid of them. Oracle added a feature to 12.? and 11.2.0.4 that gives you some control over migrated rows. The problem apparently raised its head during some Exadata performance proofing.

Kenny

On Thu, Sep 18, 2014 at 3:25 PM, Chris Taylor < christopherdtaylor1994_at_gmail.com> wrote:

> The last analyzed date (yesterday) shows CHAIN_CNT = 0 but I'm not
> positive that is accurate. (Seems like I remember you have to check a
> different way to get an accurate picture of chained or migrated rows)
>
> Chris
>
> On Thu, Sep 18, 2014 at 2:18 PM, Wolfgang Breitling <
> breitliw_at_centrexcc.com> wrote:
>
>>
>> - chained rows
>> - delayed block clean out
>>
>>
>>
>>

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Sep 18 2014 - 21:31:54 CEST