Migrated Rows

From: Norman Dunbar <ndunbar_at_lynxfinancialsystems.co.uk>
Date: Wed, 13 Jun 2001 13:57:13 +0100
Message-ID: <F43E6BAE5BB5D411A44C00805FBE740D9E6F7F@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 Wed Jun 13 2001 - 07:57:13 CDT