Re: chained rows

From: Ashish Shah <ar_shah_at_yahoo.com>
Date: Tue, 13 Jun 2000 14:10:23 -0700 (PDT)
Message-Id: <10527.109096@fatcity.com>

1. create chained_rows table from $ORAclE_HOME/rdbms/admin/utlchain.sql
2. analyze table emp list chained rows into chained_rows;
3. select * from chained_rows.

this should doit.

• Robin Li <rli_at_nyp.org> wrote:
  >
  > -- 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).
  

  ---

Ashish
Toronto, Canada

---

Do You Yahoo!? Received on Tue Jun 13 2000 - 16:10:23 CDT