Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: What is table fetch continued row
Another thing to consider is the tables PCTFREE value. Wh n there is
not enough free space in the block to update a row, migration will
occur. The default value is 10 %. AN export/import will correct the
problem but most likely for a short period. The key is knowing the
characteristics of the table and how data is worked on in the table.
Dave Grzebien
Expert Technical Consultants, Inc
dave_at_etci.net
michael_bialik_at_my-deja.com wrote:
> 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 - 19:59:12 CDT