RE: chained rows

From: Steve Adams <steve.adams_at_ixora.com.au>
Date: Wed, 14 Jun 2000 11:29:42 +1000
Message-Id: <10527.109153@fatcity.com>

Hi Robin,

The chaining is probably in the schema that you did not analyze, namely SYS. That is, the data dictionary.
It is perfectly normal, and almost untunable.

Regards,
Steve Adams

http://www.ixora.com.au/
http://www.oreilly.com/catalog/orinternals/
http://www.christianity.net.au/


-----Original Message-----
From:	Robin Li [SMTP:rli_at_nyp.org]
Sent:	Wednesday, June 14, 2000 4:22 AM
To:	Multiple recipients of list ORACLE-L
Subject:	chained rows

Hi all,

Our monitoring tool reports that there are chained rows in the database. We analyze the schema once a week and get no rows returned from:

select owner, table_name, chain_cnt/num_rows*100 "chain%" from dba_tables
where num_rows <> 0 and chain_cnt <> 0;

The tech person from the monitoring tool's company told us that they determined chained rows by 'select value from v$sysstat where name ='table fetch continued row';

We do have a value returned from that query:

VALUE

24132

My question is: how to find out which table has the chained row?

TIA
Robin

Robin Li *
Technical Specialist, DBA Phone#: (212) 297-3073 *
FCG Management Services Fax#: (212) 297-4231 *
333 East 38th Street, 2nd fl. E-mail: rli_at_nyp.org *
New York, NY 10016 *
-- Author: Robin Li INET: rli_at_nyp.org

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). Received on Tue Jun 13 2000 - 20:29:42 CDT