I have been looking at LMT recently
I created a 10001M datafile at 8K block size for a 64K locally managed
extents
Noticed from dba_free_space that the largest contiguous free space was 3968M
Dumped the file header and got the same results as Paul / Jeremiah but I did
note that
for a 8k block size
Title: RE: Bitmap Header in a Uniform LMT?
Please resend link?
-Original Message-
From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]]
Sent: Saturday, August 10, 2002 12:34 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Bitmap Header in a Uniform LMT?
Rajesh,
I did visit
Rajesh,
I did visit the link you mentioned.
Nice and concise information on LMT (and other things as well).
Thanks for posting the link.
- Kirti
-Original Message-
Sent: Friday, August 09, 2002 3:33 PM
To: Multiple recipients of list ORACLE-L
Getting no responses on this, I cre
by: Subject: RE: Bitmap Header in a Uniform
LMT?
[EMAIL PROTECTED]
Raj - My apologies for being late with a reply. Your latest message prompted
me to recall that Jeremiah Wilton investigated this (or a similar aspect)
back in April. I went into Google and typed "LMT bitmap headers" (without
the quotes), and it retrieved the discussion. I have inserted it below fo
Getting no responses on this, I created a test 9.0 database on my NT 4.0
workstation, with a block size of 4K. My observations are :
While creating a LMT with uniform extents of size 16K, the minimum datafile
size has to be 25K. With uniform extents of size 32K, the datafile size has
to be more