Message-Id: <10744.126907@fatcity.com>
From: SHAIBAL TALUKDER <shaibal_talukder@yahoo.com>
Date: Wed, 17 Jan 2001 10:18:53 -0800 (PST)
Subject: Chained row detection

--0-1186452551-979755533=:2788
Content-Type: text/plain; charset=us-ascii


List

While third party application is runninng ON PRODUCTION, I m thinking to analyze tables so that I can populate chained_rows table to check whether there are chained rows or not.

I know this will slow down the performance for a while. Any experience of serious perofrmance degradation for doing this?Analyzing tables does not lock a table, which is already being used by a user - right!

Platform: Sun OS 5.6, Oracle 7.3.4

Any suggession will be highly appreciated.

Shaibal



---------------------------------
Do You Yahoo!?
Yahoo! Mail Personal Address - Get email at your own domain with Yahoo! Mail.
--0-1186452551-979755533=:2788
Content-Type: text/html; charset=us-ascii

<P>List</P>
<P>While third party application is runninng <STRONG>ON PRODUCTION</STRONG>, I m thinking to analyze tables so that I can populate chained_rows table to check whether there are chained rows or not.</P>
<P>I know this will slow down the performance for a while.&nbsp;Any experience of serious perofrmance degradation for doing this?Analyzing tables does not lock a table, which is already being used by a user - right!</P>
<P>Platform: Sun OS 5.6, Oracle 7.3.4</P>
<P>Any suggession will be highly appreciated.</P>
<P>Shaibal</P><p><br><hr size=1><b>Do You Yahoo!?</b><br>
<a href="http://personal.mail.yahoo.com/">Yahoo! Mail Personal Address</a> - 
Get email at your own domain with Yahoo! Mail.
--0-1186452551-979755533=:2788--