Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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
<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. 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--
Received on Wed Jan 17 2001 - 12:18:53 CST
![]() |
![]() |