| samir |
Posted: Nov 10, 2006 11:23:46 AM |
Total Post: 8
Joined: Nov, 2006
|
Pls tell me how to fin out whuch table containg chained row or columns
and how to minimize and solved tje problem
regards
himanxshu |
|
|
 Vishal |
| Posted: Nov 15, 2006 10:11:51 PM |  |
|
Total Post: 37
Joined: Mar, 2006
|
you can check chain_cnt in dba_tables to see if the table contains chained/migrated rows.
|
|
|
|
|
| SURESH |
| Posted: Jan 08, 2007 04:59:28 AM | |
|
Total Post: 10
Joined: Jan, 2007
|
analyze table <one> list chained rows;
here one is the table name i think it may be help full for u
|
|
|
|
|
| mani |
| Posted: Jan 16, 2008 03:54:58 AM | |
|
Total Post: 6
Joined: Jan, 2008
|
Analyze table <table_name> compute|Estimate statistics;
select chain_cnt from dba_tables where table_name=<table_name>
if u get any values for this... then it is migrated/chained....
|
|
|
|
|
| positive |
| Posted: Jun 29, 2008 03:51:48 PM | |
|
Total Post: 483
Joined: Jun, 2008
|
http://neworacledba.blogspot.com/
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
