Re: Migrated Rows

From: Howard J. Rogers <howardjr_at_www.com>
Date: Fri, 15 Jun 2001 07:25:38 +1000
Message-ID: <3b292bff$1@news.iprimus.com.au>

Assuming you have calculated statistics on your tables in the recent past, a simple select table_name from dba_tables where chain_cnt <> 0 would do the trick. That of course will also pick up any tables that have row chaining as well as row migration, but at least it would be a start.

But I suspect you want something a bit cleverer than that.... in which case, er... I'm at a loss.

Regards
HJR

--
=============================!!=============================
The views expressed are my own only, and definitely NOT those of Oracle
Corporation
=============================!!=============================


"Norman Dunbar" <ndunbar_at_lynxfinancialsystems.co.uk> wrote in message
news:F43E6BAE5BB5D411A44C00805FBE740D9E6F7F_at_apps.leeds.lfs.co.uk...


> Hi,

>

> I'm looking at a 8.0.6 database I've discovered chained rows and

> migrated rows.

> The chained stuff I can identify no worries.

>

> The migrated stuff bothers me as I can see from V$SYSSTAT that I have

> 'table fetch continued row' (ie migrated rows) but I can't find any

> scripts to help me identify them - which table etc.

> I've looked in Google and on Metalink but no joy.

>

> Any ideas anyone ?

>

>

> Cheers,

> Norman.

>

> ------------------------------------------------------------------------

> --------

> Norman Dunbar EMail: NDunbar_at_LynxFinancialSystems.co.uk

> Database/Unix administrator Phone: 0113 289 6265

> Lynx Financial Systems Ltd. Fax: 0113 201 7265

> URL: http://www.LynxFinancialSystems.com

> ------------------------------------------------------------------------

> --------

>

Received on Thu Jun 14 2001 - 16:25:38 CDT