| chained rows [message #57887] |
Tue, 15 July 2003 16:47  |
ns deep
Messages: 3
Registered: June 2003
|
Junior Member |
|
|
|
how to check for the chained rows in a particular table of a specific user which has like 30 tables. please let me know is there any way around other than using analyze table on each table . Thanks.
|
|
|
|
| Re: chained rows [message #57889 is a reply to message #57887] |
Wed, 16 July 2003 01:13  |
Kishor
Messages: 11
Registered: February 2003
|
Junior Member |
|
|
Hi
analyze table table_name
then query the dba_tables, column is chain_cnt to see how much rows are chained
another method is
create a table chained_rows using
ORACLE_HOME/rdbms/admin/utlchain.sql
then
analyze table table_name list chained rows
then
query the chained_rows table to see the rowids which are chained.
I think this will help you
any queries please welcome
Kishor Bhalwankar
|
|
|
|
| Re: chained rows [message #57894 is a reply to message #57887] |
Wed, 16 July 2003 05:50 |
kothari Alpesh
Messages: 27
Registered: December 2001
|
Junior Member |
|
|
Dear,
execute the following package from the system user.
EXEC DBMS_UTILITY.ANALYZE_SCHEMA('Schema_name');
Then check the with the following query in the user
Select table_name,chain_cnt from user_tables;
Which will gives u chained rows in the tables.
bye
Alpesh
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
