| 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: Question about LMT
i
agree, I think the 64k is a mute point, at worse case you have one unusable
extent at the end when using LMT. But if your extents are 100M, it may be
a little issue.
"Walking on water and developing software from a
specification are easy if both are frozen."
Christopher R. Spence <FONT
face="Comic Sans MS" size=2>Oracle DBA <FONT face="Comic Sans MS"
size=2>Fuelspot
<FONT face=Tahoma
size=2>-----Original Message-----From: Guy Hammond
[mailto:guy.hammond_at_avt.co.uk]Sent: Wednesday, June 13, 2001 10:11
AMTo: Multiple recipients of list ORACLE-LSubject: RE:
Question about LMT
<SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Luc,
<SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">
<SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">How are you
calculating the size you want to resize the <SPAN
class=SpellE>datafiles to? If it is based on how much
they are actually used, then no. If it is based on an external
calculation of how much space you expect to use, then yes, but 64k won't make
much difference when you're dealing with files of hundreds of
megabytes.
<SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">
<SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">HTH,
<SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">
<SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">g<FONT
face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">.
<SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">
<SPAN
lang=EN-US
style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma; mso-ansi-language: EN-US">-----Original
Message-----From: DEMANCHE
Luc (Cetelem) [mailto:Luc.Demanche_at_cetelem.fr] <SPAN
style="FONT-WEIGHT: bold">Sent: 13 June 2001 13:56<SPAN
style="FONT-WEIGHT: bold">To: Multiple recipients of list
ORACLE-LSubject: RE:
Question about LMT
<FONT face="Times New Roman"
size=3>
<FONT face=Arial color=blue
size=2>Hi
Guy,
<FONT face="Times New Roman"
size=3>
<FONT face=Arial color=blue
size=2>My
question is only for the extra 64 Kb. When we created datafiles, we
added 64 Kb for the last extend (because bitmap index need only 64
Kb).
<FONT face=Arial color=blue
size=2>Is it
important to keep this extra 64 Kb when we want to resize the
datafiles.
<FONT face="Times New Roman"
size=3>
<FONT face=Arial color=blue
size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">Luc
<SPAN
style="FONT-SIZE: 12pt">
Received on Wed Jun 13 2001 - 12:42:47 CDT
 |
 |