Title: RE: CHAINED ROWS
Thanks Jacques...forgot
about the Index-organized tables.
Samir
Samir Sarkar
Oracle DBA - Lennon
Team SchlumbergerSema
Email :
[EMAIL PROTECTED]
[EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217
EPABX : +44 (0) 115 - 957 6418
Ext. 76217 Fax
: +44 (0) 115
recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: CHAINED ROWS
Date: Wed, 09 Jan 2002 01:56:54 -0800
Thanks Jacques...forgot about the Index-organized tables.
Samir
Samir Sarkar
Oracle DBA - Lennon Team
SchlumbergerSema
Email : [EMAIL PROTECTED]
[EMAIL PROTECTED]
Phone
.
Mike
From: SARKAR, Samir [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: CHAINED ROWS
Date: Wed, 09 Jan 2002 01:56:54 -0800
Thanks Jacques...forgot about the Index-organized tables.
Samir
Samir Sarkar
Oracle
I have seen that There are some number of
chained rows in several tables of a schema in my database .
What is it done in such a situation ?
Thank you
Bunyamin
of list ORACLE-LSubject:
CHAINED ROWS
I have seen that There are some number of
chained rows in several tables of a schema in my database .
What is it done in such a situation ?
Thank you
Bunyamin
The information contained in this communication is
confidential, is intended only
If Oracle 8i is ur current
version, run the utlchain1.sql script available in ur
ORACLE_HOME/rdbms/admin
directory. This will create
the chained_rows table for u.
Now analyze the affected
table using the command :
analyze table
table_name list chained rows into chained_rows;
Now when u
ROWS
I have seen that There are some number of
chained rows in several tables of a schema in my database .
What is it done in such a situation ?
Thank you
Bunyamin
Just analyze table xxx list chained rows and use the procedure titled
Reducing Migrated and Chained Rows in the Designing and Tuning for
Performance guide, chapter 20. I've used this on large tables and it works
quite well.
Steve Orr,
Bozeman, Montana
-Original Message-
Sent: Tuesday
Title: RE: CHAINED ROWS
If your chained rows are inside an Index-Organized table, be sure to read the Oracle manual on the Analyze command. There are two versions of the chained-row table, for index-organized tables you should create the chained-row table with universal rowids (head_rowid has