| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Datafile size - Is bigger better?
I usually add 1MB to all file sizes, just to make the math and the filesize specification simpler--if I want 1024MB of space, I make the file 1025MB.
Paul Baumgartel
CREDIT SUISSE
Information Technology
DBA & Admin - NY, KIGA 1
11 Madison Avenue
New York, NY 10010
USA
Phone 212.538.1143
paul.baumgartel_at_credit-suisse.com
www.credit-suisse.com
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Wolfgang Breitling
Sent: Tuesday, November 14, 2006 11:40 PM
To: jaykash_at_hotmail.com
Cc: oracle-l_at_freelists.org
Subject: Re: Datafile size - Is bigger better?
At 07:09 PM 11/14/2006, Wolfgang Breitling wrote:
At 03:57 PM 11/14/2006, JayDBA wrote:
3. On locally managed files, we loose header space equal to the extent size. E.g. on a datafile with uniform extent sizing of 128M a 2gb file would waste 6% space / file. This number can run into gigabytes on systems with 100's of 1000's of files
That is not true. The bitmap(s) for managing the space are fixed at 64K. If you create the datafiles for LMTs as an integral multiple of the uniform extent size + 64K, you can use the full size of the tablespace. If not Oracle will take the first extent and use 64K of it for the bitmap but the remainder is not usable - until you extent the datafile size by 64K:
I was describing that wrong. Oracle is not taking the first extent to create the space bitmap. It takes the first 64K of the datafile - after the file header block - to create the bitmap. The first extent then starts at an offset of 64K + 1 block. But if the datafile size does not include the extra 64K for the bitmap the space left after the last uniform size extent is allocated is 64K short of a full extent and is therefore unusable. Once the additional 64K are added, that unusable space plus the 64K make for a full uniform size extent and can be used.
Regards
Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com <http://www.centrexcc.com/>
http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Nov 15 2006 - 12:39:13 CST
 |
 |