Re: Row Chaining & table fetch continued row

v$tables will report what the system or session has encountered since instance startup. Analyze or similar will report the actual number in the table.

If an instance has been running for several days and the "...fetch continued row..." is low, why bother?

Rajesh Dayal wrote:

> Hi all,
> I am checking Row-Chaining in one of Production
> Environment. But at the end I am not able to reconcile
> my results. I would appreciate if someone help me doing
> that......
>
> After analyzing one table I see that it has 4202 Chained Rows.
>
> Then I run following SQL
>
> SQL> select value
> 2 from v$sysstat
> 3 where name = 'table fetch continued row';
>
> VALUE
> ----------
> 951
>
> SQL> Select my.value
> 2 From v$mystat my,
> 3 V$sysstat sys
> 4 Where my.statistic# = sys.statistic#
> 5 And sys.name = 'table fetch continued row';
>
> VALUE
> ----------
> 0
>
> Now I do
>
> SQL> select * from prasanta.tdpsv ;
>
> After this I run following queries again,
>
> SQL> Select my.value
> 2 From v$mystat my,
> 3 V$sysstat sys
> 4 Where my.statistic# = sys.statistic#
> 5 And sys.name = 'table fetch continued row'
>
> VALUE
> ----------
> 0
>
> SQL> select value
> 2 from v$sysstat
> 3 where name = 'table fetch continued row'
>
> VALUE
> ----------
> 960
>
> Shouldn't the above two values be 4202 and 5153, as per
> description of 'table fetch continued row' ?? Am I
> missing something????
>
> TIA,
> Rajesh
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rajesh Dayal
> INET: Rajesh_at_ohitelecom.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

--
Venlig hilsen

Mogens Nørgaard

Technical Director
Miracle A/S, Denmark
Web: http://MiracleAS.dk
Mobile: +45 2527 7100


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mogens =?iso-8859-1?Q?N=F8rgaard?=
  INET: mno_at_MiracleAS.dk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).