Title: RE: Running multiple instances on a [large] server
I see some values 0 for chaint_cnt in
dba_tables . How do I know if this is chained rows or migrated rows ?
Any hits .
Thanks,
ak
ak
Smart-alek answer: Apply one of the methods to eliminate migrated rows,
and if the problem doesn't go away, you know you have some chained rows ;-)
Chained rows are a little difficult to diagnose. Look at the value for
avg_row_len - is it near the db_block_size? I haven't tried this, but
AK,
hi, row chaining is because the big row(row length is bigger than the
block size), while row migration is because of small pctfree and updated rows.
So, just look at the length of the rows. If chained rows, no
way(unless you use larger block size and the row
starting point...
http://asktom.oracle.com/pls/ask/f?p=4950:8:104855126678244125::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:358341515662,
If you have Oracle magazine, though, he answers your specific question.
[EMAIL PROTECTED] 3/11 10:40a
AK,
hi, row chaining is because the big row
and
what objects have LIOs for row chaining and how much.
Program 1 will be available from Oraperf.com
Anjo.
On Tuesday 11 March 2003 07:49, you wrote:
ak
Smart-alek answer: Apply one of the methods to eliminate migrated rows,
and if the problem doesn't go away, you know you have some chained
Hi all,
I am checking Row-Chaining in one of Production
Environment. But at the end I am not able to reconcile
my results. I would appreciate if someone help me doing
that..
After analyzing one table I see that it has 4202 Chained Rows.
Then I run following SQL
SQL select value
am checking Row-Chaining in one of Production
Environment. But at the end I am not able to reconcile
my results. I would appreciate if someone help me doing
that..
After analyzing one table I see that it has 4202 Chained Rows.
Then I run following SQL
SQL select value
2 from v