Chained Row Tables

[Upeshp]

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,

[sreddy]

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.

[Oracledba8]

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

[Upeshp]

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.

[Upeshp]

Hi all,

Thanks i got it and now will resolve it.

[sambavan]

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