Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Migrated Rows
Howard,
Yeah, I've analysed with compute stats on all the tables and I've detected the chained rows ok. I'm led to believe that the V$SYSSTAT view tells me that I have migrated rows. I can easily identify and unchain the chained ones, but I wanted to know how to identify the migrated ones - none of the manuals seem to say how.
However, it would apear that if I fix the chained rows, I'll (probably) fix the migrated ones as well, so no worries - apart from corectly determining the PCTFREE/PCTUSED stuff which someone (not me !) has set to 1% and 90% - which implies that these tables don't update or delete rows very often/at all.
Cheers,
Norman.
-----Original Message-----
From: Howard J. Rogers [mailto:howardjr_at_www.com]
Posted At: Thursday, June 14, 2001 10:26 PM
Posted To: server
Conversation: Migrated Rows
Subject: Re: Migrated Rows
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.
Received on Fri Jun 15 2001 - 03:06:35 CDT