Oracle-L: Re: PCTFREE and PCTUSED

From: Tanel Poder <tanel.poder.003_at_mail.ee>
Date: Sun, 09 Nov 2003 12:54:25 -0800
Message-ID: <F001.005D6243.20031109125425@fatcity.com>

> We haven't even touched the subject of ITL entries which is also
unaffected
> by ASSM.

By the way, in 9i there is one interesting issue with ITLs, that every table datablock gets 2 ITL slots by default, even if INITRANS and MAXTRANS are set to 1. And blocks formatted due direct path inserts will have 3 ITL entries by default.

Tanel.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: tanel.poder.003_at_mail.ee

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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 Sun Nov 09 2003 - 14:54:25 CST