Re: What is table fetch continued row

From: <michael_bialik_at_my-deja.com>
Date: Sat, 24 Jul 1999 16:52:41 GMT
Message-ID: <7ncr0m$ej8$1@nnrp1.deja.com>

Hi.

It is number of accesses to "chained rows" in your system.
Briefly - "chained row" is row that spans more than 1 block and need at least 2 accesses to get it. If you see that value > 0 and rising - reorg your data ( export/import ).

Good luck. Michael.

In article <37984C15.6F51337B_at_synergy-infotech.com>, Anurag Minocha <anurag_at_synergy-infotech.com> wrote:
> Hi,
>
> I have seen people using the query:--
>
> select name,value from v$sysstat where name
> 2 like 'table fetch continued row';
>
> What does table fetch continued row mean.
>
> any help will be appreciated.
>
> Thanks
> anurag
>
> reply at
> anurag_at_synergy-infotech.com
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Sat Jul 24 1999 - 11:52:41 CDT