Re: Chaining and Migration

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 12 Jan 1999 21:41:28 -0000
Message-ID: <916178137.19434.4.nnrp-08.9e984b29@news.demon.co.uk>

The problem with the 'select count(*)' stuff is probably the usual one = of
books getting out of date. I believe you will find that chained rows = only
show up in v$sysstat in newer versions of Oracle 7 if they have been accessed through an indexed read, but not if they have been accessed as part of a tablescan

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

    select substr(name,1,40), VALUE
    from v$sysstat
    where name = 'table fetch continued row'

Then doing a select count(*) from offensive table, and redoing the above query, and then comparing the result.

When I do this, I get the same VALUE number, 1559, leading me to believe the rows are migrated, not chained. Received on Tue Jan 12 1999 - 15:41:28 CST