| How to check Migrated/Chained rows [message #64406] |
Sun, 23 January 2005 22:43  |
Vivek Vijai
Messages: 67
Registered: April 2004
|
Member |
|
|
Hi All,
I have Analyzed a table(Compute Statistics), just wondering how to check whether there are any migrated or Chanined rows in the table.
Can any one tell me the procedure to check it.
Chained rows can be checked from dba_tables=>chain_int?
But what about Migrated rows.
Please help me out.
Thanks in advance,
Vivek.
|
|
|
|
| Re: How to check Migrated/Chained rows [message #64408 is a reply to message #64406] |
Mon, 24 January 2005 00:47  |
Deepa
Messages: 269
Registered: November 2000
|
Senior Member |
|
|
run the $ORACLE_HOME/rdbms/admin/utlchain.sql script.
ANALYZE TABLE
LIST CHAINED ROWS;
this query will list all chained rows
select owner_name, table_name, head_rowid from chained_rows;
The Analyzed table
list chained rows command dumps all chained/migrated rows into chained_rows table. So chained_rows table gives a collective measurement of chained/migrated rows. Migration and Chaining are different, however, Oracle represents these as the same internally
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
