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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
