Chained Row Tables

Hi,

I am using database on Unix and Oracle 8.0.4.

Can anyone tell me what should be the primaray check for imporving the database response ?

Also tell me How can I find out tables containg chained rows ?

Thanks,

Improving response. In order to do that, first you need to find where you have the response problem ? It could be

Memory contention - Look in to SGA components and are sufficient
Redolog contention - See the log size is sufficient
RBS contention - See the RBS sizing is ok
I/O contention - See Data and Index, SYSTEM, RBS tablespaces are distributed on different file systems.

Here Iam talking about DBA Perspective. BEfore looking into this have a look at the application queries(SQL) and get some statistics using explain plan/tkprof/statspack/utlbstat.sql and utlestat.sql.

Just ideas from where you can start diggin...

After analyzing the table using ANALYZE command select CHAIN_CNT column from DBA_TABLES view which gives number od chained/migrated rows.

Hi,

If you have your tables Analyzed, You can find the Chained Rows from User_tables

Otherwise Anaylze tables, and issue

Select Table_name, Chain_Cnt from User_Tables
where Chain_cnt > 0;

You can also create Chained_Rows table and anaylze table and get the Chained Rows there... The scripts is

%Oracle_Home%\Rdbms\Admin\Utlchain.sql

Hope this helps..
Thanks

Thanks for the reply.

Just want to ask one more question. If i analyse tables then tell me what all options i have to give with ANALYSE command.

Hi all,

Thanks i got it and now will resolve it.

Analyze table with the compute statistics option and it would compute the statistics and then you can find the chained rows and etc. Never analyze the system/sys tablespace objects.


Sam