Percent Increase Behavior

From: Medic Alert <news_at_medicalert.org>
Date: 1997/03/04
Message-ID: <331C6BD1.26C8@medicalert.org>#1/1

According to Oracle's 7.x documentation, when the percent increase parameter of a storage clause is set to some non-zero value, after the second extent is allocated, the third extent should be the size of the second
increased by pct_increase then rounded up to the next multiple of the database block size (usually 2K). In actuality, however, I have found that the number of bytes
allocated is rounded up to the next
multiple of 10K! I've checked this on
instances running on 0S/2, VMS, and HP-UX and they all show the same behavior.
Anyone else noticed this?

Run the SQL script below to see if you
get any values back which are not integers:

• begin SQL statement --------

SELECT
   bytes/(1024*10)
FROM
   sys.dba_extents E
WHERE
   segment_name IN (

      SELECT
        table_name
      FROM
        sys.dba_tables T
      WHERE
        pct_increase > 0

   )
   and extent_id > 1;

• end SQL statement --------
  • TRW

Received on Tue Mar 04 1997 - 00:00:00 CST