Row Chaining & table fetch continued row

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).