Re: Performance - Chained Rows

--0-2053999932-971198415=:20848
Content-Type: text/plain; charset=us-ascii

Absolutely. You first need to determine whether these are true chained rows or migrated rows. Both show up in the chain_cnt column of dba_tables. If they are migrated rows (most likely), increase the PCTFREE for the table, and reorg it. If they are true chained rows and the table contains LOBs, store the LOBs in a separate lob segment. If they're chained rows and you're not using LOBs your choices are to increase the block size to something large enough to accomodate the largest row, or live with it. Be advised that changing the block size requires recreating the database.

  "Weerd Kirsten, E.C. de" <Kirsten.deWeerd_at_Oranjewoud.nl> wrote:

Hi,

I'm still looking for a cause of performance problems ...

I have found a table, very frequently used in forms and procedures, with about 10% chained rows. Other most frequently used tables have about 0,3 % chained rows. Could this be an issue ???

Greets,

Kirsten

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Weerd Kirsten, E.C. de
INET: Kirsten.deWeerd_at_Oranjewoud.nl

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).


---------------------------------
Do You Yahoo!?
Get Yahoo! Mail - Free email you can access from anywhere!
--0-2053999932-971198415=:20848
Content-Type: text/html; charset=us-ascii



<P>Absolutely. You first need to&nbsp;determine whether these are true chained rows or migrated rows. Both show up in the chain_cnt column of dba_tables. If they are migrated rows (most likely), increase the PCTFREE for the table, and reorg it. If they are true chained rows and the table contains LOBs, store the LOBs in a separate lob segment. If they're chained rows and you're not using LOBs your choices are to increase the block size to something large enough to accomodate the largest row, or live with it. Be advised that changing the block size requires recreating the database. <BR>

<P>&nbsp; <B><I>"Weerd Kirsten, E.C. de" &lt;Kirsten.deWeerd_at_Oranjewoud.nl&gt;</I></B> wrote: <BR><BR>

<BLOCKQUOTE style="BORDER-LEFT: #1010ff 2px solid; MARGIN-LEFT: 5px; PADDING-LEFT: 5px">Hi,<BR><BR>I'm still looking for a cause of performance problems ...<BR><BR>I have found a table, very frequently used in forms and procedures,<BR>with about 10% chained rows. Other most frequently used tables have about<BR>0,3 % chained rows. Could this be an issue ???<BR><BR>Greets,<BR><BR>Kirsten<BR>-- <BR>Please see the official ORACLE-L FAQ: http://www.orafaq.com<BR>-- <BR>Author: Weerd Kirsten, E.C. de<BR>INET: Kirsten.deWeerd@Oranjewoud.nl<BR><BR>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051<BR>San Diego, California -- Public Internet access / Mailing Lists<BR>--------------------------------------------------------------------<BR>To REMOVE yourself from this mailing list, send an E-Mail message<BR>to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in<BR>the message BODY, include a line containing: UNSUB ORACLE-L<BR>(or the name of mailing list you wan!

t to be removed from). You may<BR>also send the HELP command for other information (like subscribing).</BLOCKQUOTE><p><br><hr size=1><b>Do You Yahoo!?</b><br>
Get Yahoo! Mail - Free email you can access from anywhere!